Time and Materials Billing Backlog table in Project Operations

Even wondered what is Time and Materials Billing Backlog table in Project Operations which you see in the Sitemap but you might not be sure what records are in it –

Time and Materials Billing Backlog

Here’s the purpose of Time and Materials Billing Backlog entity –

Given that you have 2 Time Entries Submitted for Approval to the Project Management / Account Manager.
When the Time Entries are Submitted, the Approver receives them for Approval. The Project Approver can then Approve the Time Entries.
Once they Approve the Time Entries, they are turned into Actuals (msdyn_actual) in Project Operations.
Then, Actuals are then Supposed to be marked as Ready to Invoice.
So, when the Actuals are the created and even when they are marked Ready to Invoice, that’s when they appear in Time and Materials Billing Backlog view.
This table is in fact Actuals table itself! 😊 (There’s no Time and Entry Billing Backlog as a separate Table in Dataverse).
In fact, Accounting managers or Project Managers can Ready the Actuals from the Time and Materials Billing Backlog table itself.
Now, then the Invoice is created for the ready Actuals, they are added to Invoice Lines
And then, they are removed from the Time and Materials Billing Backlog view.

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Enable OneNote Integration for Dynamics 365 Sales environment

January 2, 2024 priyeshwagh777 d365 for sales, Dynamics 365 CE Dataverse, Dynamics 365, onenote integration, onenote integration with crm, power apps, Power Automate, Power Platform, sharepoint integration

Since collaboration tools like Teams, SharePoints are a norm, so is OneNote. Here’s how you can enable OneNote Integration in your Dynamics 365 CRM Instance –

Settings

Given that you are a Dynamics 365 Administrator, you can navigate to Power Platform Admin Center of your environment –

Go to the Settings on the Environment you want to enable OneNote Integration on
Once you are in Settings, you can expand Integration section and then click on Document management settings.
Then, you’ll be redirected to the classic UI and there, you can select Enable OneNote Integration (provided that SharePoint Based Document Integration is already enabled).
It’ll open up this dialog box and you’ll see the pre-enabled OneNote for the tables which you want to enable. You can choose the ones you want to enable OneNote Integration for and click Submit. This dialog box will then close.
Also, double-check on the entity level if OneNote Integration is turned On or not.
Once this is done, you can refresh the record on which the OneNote Integration is enabled and click on + on the Timeline to show the Activity options. You’ll see OneNote appear as well.
Once you click on it, it’ll be redirected to SharePoint location where the OneNote notebook is created.
Now, when you come back on the record and click on Related section and go to Documents. You’ll see the OneNote notebook appear there in the record.

Hope this post helps!

Here are some Power Automate posts you want to check out –

Thank you!

Setting up Project Operations Lite | Blog Series

January 2, 2024January 8, 2024 priyeshwagh777 Project Operations Dataverse, Dynamics 365, power apps, Power Automate, Power Platform, Project Operations, project operations lite, project operations setup

I felt that I should document steps to setup a Project Operations Lite Trial environment for everyone who’s trying to spin up a Project Operations Instance and trying to get the basic setup done as of January 2024.

Hopefully, this blog series will help you to quickly access and understand the info you need to setup your Project Operations Lite trial environment –

Provisioning a Project Operations Trial

Blog	Description
Starting a Project Operations Lite Trial Environment	Describes how you can provision a new trial for Project Operations Lite and

Setting up Master Data in Project Operations Lite

Blog	Description
Setting Up Default Organizational Unit, Cost and Sales Price List in Project Operations Lite	Find and rename a default Organizational Unit, attach a Cost Price List to the default Org Unit and also create a Sales Price List (Roles, Prices will be added in preceding post)
Resource Roles and adding Role Prices to Cost and Sales Price List in Project Operations	Review and Create Resource Roles, Add Resource Roles to Sales and Cost Price Lists

Billing / Invoicing

Blog	Description
Time and Materials Billing Backlog table in Project Operations	Explains what Time and Materials Billing Backlog table in Dataverse in Project Operations is used for.

Copilot for Project Operations

Blog	Description
Enable Copilot for Project Operations	Enable / Disable Copilot as a feature for Project Operations
Create Project Plan using Copilot in Project Operations	Create a Project Plan for your Project using Copilot based on the Description and other details on the Project record.

Here are some Power Automate posts you want to check out –

Resource Roles and adding Role Prices to Cost and Sales Price List in Project Operations

January 1, 2024 priyeshwagh777 Project Operations Dataverse, Dynamics 365, power apps, Power Automate, Power Platform, project operations configuration, project operations lite

Now that in the previous blog posts of this series, the Organization Units, Cost Price and Sales Prices were setup – Setting Up Default Organizational Unit, Cost and Sales Price List in Project Operations Lite, let’s look at what Roles (or Resource Roles) are and how you can add them to the Price Lists

Resource Roles

Let’s see how we can add Resource Roles –

Navigate to Resources Area and then select Resources sub-area in Project Operations App.
Now, navigate to Roles on the Sitemap and you’ll see some existing Roles already available out-of-the-box
If you open any existing roles, you’ll see that Billing Types the type/behavior of the Role which we’ll discuss in further sections.

Now, let’s add the Resource in both Cost and Sales Price Lists in the next section.

Add Role in Cost Price List

Now, lets assume we want to assign a Cost Price to the Consulting Lead role (which is of type Chargeable). Let’s see below on how we can do this –

Navigate to the Organizational Units in Settings area in Project Operations since it’s easy to go than to find the Cost Price as you might not remember the exact name every time.
Open the Organization Unit record which is your default Organization Unit for the PO environment.
Now, since we had already associated a Cost Price in the previous sections, you can open the Price List.
Now, once you open the Cost Price List, go to Role prices tab and click on + New Role Price to add the existing Role to this price list and define the Cost of the Role to the organization.
Now, make sure you select the Role and also select the Organization Unit even if you have selected the Cost Price List from the Organization Unit. That’s because you can add multiple prices for the same role across different Organization Units.

I’m keeping a sample Cost Price of $150
Once you Save and Close, the Role Price will be defined in this Cost Price for this Org Unit.

Alternatively, let’s also add the same Role in the Sales Price List as well from this series.

Add Role in Sales Price List

Let’s also add the same Consulting Lead role to the Sales Price List as well –

Navigate to the Sales area and then look for Price Lists. Look for the Sales Price List you created for your organization.
In the Sales Price list, go to Role Prices and click on Add New Role Price
Now, as Sales Prices are supposed to be higher than Cost Prices, I’m using a Price of $240 for the Consulting Lead which was $150 in the Cost Price
And once you Save and Close, it’ll be added to the Sales Price list as shown below.

Hope this post was useful!

Here are some Power Automate posts you want to check out –

Enable Copilot for Project Operations

January 1, 2024 priyeshwagh777 CRM with .NET Web Applications copilot, Dataverse, power apps, Power Automate, Power Platform

Recently, you must have observed Copilot being introduced in every other Microsoft Business and M365 applications. Dynamics 365 Project Operations too being no exception! Here’s how you can get the same

Enable Copilot in Project Operations

Here’s how you can enable Copilot in Project Operations –

In Project Operations app, Navigate to Settings in the SiteMap area –
Then, Navigate to Parameters. Then, open the Parameter record itself (Avoid click on the Default Organization Unit as it’ll take you to the Org Unit record and not the intended Parameter record).
Then, you can drop down from the Feature control and see that the Copilot option is available to enable for you.
Once you click on it, it’ll ask you for confirmation. Click OK if everything looks good to you.

It takes a few moments for Copilot to be enabled for Project Operations environment.

Disable Copilot

Here’s how you can disable Copilot if not needed –

In case you don’t want to use Copilot and want to disable it, you can open the Parameter record in Project Operations’ Settings area and drop down from the Feature Control ribbon button to find that you can now Disable Copilot if it is in enabled state.

Hope this post was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Setting Up Default Organizational Unit, Cost and Sales Price List in Project Operations Lite

January 1, 2024 priyeshwagh777 Project Operations Dataverse, Dynamics 365, organizational units in project operations, power apps, Power Automate, Power Platform, price lists in project operations lite, Project Operations, project operations lite, roles in project operations lite

One of the first things to do when starting a new Project Operations Lite environment is to start setting up organizational data for your environment and in that, setting up Organizational Units, Price Lists and Roles is one of the first things to start setting up –

Let’s see on how you can start the same!

Organizational Unit

One of the first things is to find the Default Org unit for your Project Operations Lite environment –

Ensure that in your Project Operations environment, you are in Project Operations app. On the SiteMap, switch to the Projects area and then, Settings sub-area.
Now, locate Parameters and there should be 1 record in the Parameters which is mapped to the Default Organization Unit. Select the same (click on the clickable Default Organization Unit lookup itself to directly go to the Organizational Unit [or referred to as Contracting Unit in further blogs])
Once in the Org Unit record, update the name to what should be relevant based on your use case.
I’ve renamed this to a more readable name based on my example. Now, it should be easy for you to deal with this Org Unit while referencing further.

Cost Price List in Organizational Unit

Now that the Org Unit is found and renamed correctly, let’s add a Cost Price List first –

In your Org Unit record, click on Add Existing Price List.
Then, click on New Record button upon clicking the Look for records lookup field.
Select Price Lists as the record type and it should be the only option there.
Then, it’ll open the Price List record creation form on the window and you can start filling in the details. Make sure the Context selected is of type Cost.
Also, the Effective Start Date and Effective End Date should be relevant as all calculations will be successful only if the dates to be processed for transactions fall inside the intended Price List dates.

Save and Close the record once completed.
Then the saved record will be shows as selected on the lookup field and you can then click on Add button at the bottom.
Once added, the sub-grid on the Org Unit will take a while to refresh and then show you the tagged Cost Price List correctly.

Now, you have tagged a Cost Price List successfully. Let’s quickly add a Sales Price List.

Sales Price List

Now that you have created and tagged a Cost Price List in the previous section, let’s quickly create a Sales Price List shell so that you have a corresponding Sales Price List to look at as well –

Navigate to the Sales area and then select, Sales sub-area in the Sitemap.
Here, click on the Price Lists table and then click to add a new Price List record.
Note that the Context of the record should be Sales this time since we want to create a Sales Price List. Save & Close once the record looks satisfactory based on your relevant information to fill in.
Now, you can see that the Sales and Cost Price Lists are ready in your environment.

Next Section here will cover adding Resource Roles, and then adding Role Prices to the Sales and Cost Price Lists.

In later parts of this series, we’ll continue to add more to the Price Lists, Roles etc.

Hope this post was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Starting a Project Operations Lite Trial Environment

January 1, 2024 priyeshwagh777 CRM with .NET Web Applications Dataverse, Dynamics 365, power apps, Power Automate, Power Platform, Project Operations, project operations lite, project operations lite trial

One of the first things you want to get done is to spin up a Project Operations Trial environment. Here’s how you do it!
Note that no Credit Card is required for a Project Operations trial environment.

Project Operations Trial Environment

Here’s how you start a Project Operations trial environment –

Navigate to https://trials.dynamics.com/ which will be redirected to https://dynamics.microsoft.com/en-us/dynamics-365-free-trial/ and the page you’ll see will be something like this –
Scroll down on the page till you see the option for Project Operations. Click on Try for free.
Once you click on Try for free, you can enter a new email on which you want to start a trial. I’ve come up with a sample email which I haven’t used before. I prefer not to enter an email/username which I already use.
Click Next and then you can select Setup my account.
Then, you can validate/enter the details which would be something like this and click Next.
Then, choose if you want to receive an OTP via Text or a Call. Text is my preferred way so I selected that and clicked on Send verification code.
I received an OTP which I entered as asked on the next pane and clicked Verify.
Further, I’ll be shown the login details of the trial environment I want to create. Once this is done and I save the information, I click on Next.
Then, you’ll be shown the details of the environment you’ll be provisioning. Save this info before proceeding.
Next, click on Start using Dynamics 365 Project Operations (CE) – Preview Trial. It’ll redirect you to the questionnaire page on a new tab where you’ll need to answer the questions before choosing the Deployment Type.

Deployment Type Questionnaire

As we left off from the Step #9 in the above section, you’ll be taken to a questionnaire Wizard in order to provision a Project Operations trial –

Yes to managing Opportunities as they move through the process.
Yes to requiring advance or extensible resource management.
Yes to requirement of workflow for approval of Time and Expense.
No to advanced Expense management.
No to Non-Stocked Materials
No to Stocked materials as well.
Select the version here. Even if you would have answered the questions randomly, you would have still gotten to choose a different version than recommended. Hence, the answers above point to a recommendation of Project Operations Lite type of Deployment.
Click Begin Setup once Lite Deployment is selected.
Setup will start provisioning once you click on Start.
And it’ll take a while and it’ll say that it will redirect you to the Power Platform Admin Center.
And once you are redirected to Power Platform Admin Center and you’ll see that the environment is provisioning. This will take a few minutes before completion.

Set Name and URL for your environment

Provisioning a Project Operations trial will get set a predefined URL and name which you should update to be readable –

Open the environment once the link is clickable and the State is set to Ready.
Then, click on the Edit button
Once you click Edit, you’ll get to update the Name and the URL. Set to something that is relevant to the purpose of the environment.
Once you click on Save, you’ll see this loading page which will take a while to complete and finally, your Project Operations Lite environment setup will be ready!

Here’s Microsoft’s Documentation detailing which all Deployment Types have different Project Operations features available – https://learn.microsoft.com/en-us/dynamics365/project-operations/environment/determine-deployment-type?WT.mc_id=DX-MVP-5003911

Hope this post was useful!

Here are some Power Automate posts you want to check out –

Difference between Project Operations Deployment Types

January 1, 2024 priyeshwagh777 Project Operations Dataverse, Dynamics 365, power apps, Power Automate, Power Platform, Project Operations, project operations deployment types

Now, as you know that there are the following 3 types of Project Operations Deployments –

Project Operations Lite (Deal to Proforma Invoicing).
Project Operations for resource/non-stocked scenarios.
Project Operations for production/stocked scenarios.

To keep the comparison understandable and simple, let’s review the below in a short summary.

Comparison

Project Operations Lite	Project Operations for Resource/Non-stocked	Project Operations for Production/Stocked
Finance & Operations module is not setup	Finance & Operations setup is required	Finance & Operations Setup is required
No Dual Write Integration	Dual Write Integration is required.	Dual Write Integration is required.
Up to Pro-forma Invoicing is available	Pro-forma Invoicing in PO and Customer-facing Invoicing in F&O	Full Invoicing in F&O
Basic Expense	Basic and Full Expense with Receipt OCR	Full Expense with Receipt OCR

Hope this quick summary was useful. I’ll continue adding more to this article over time.

Here’s official Microsoft Documentation for full deployment guidance with questionnaire –

Here are some Power Automate posts you want to check out – https://learn.microsoft.com/en-us/dynamics365/project-operations/environment/determine-deployment-type?WT.mc_id=DX-MVP-5003911

Thank you!

Getting Started with Microsoft Graph API

December 31, 2023 priyeshwagh777 Uncategorized Dataverse, microsoft graph api, microsoft graph explorer, power apps, Power Automate, Power Platform, powerautomate

Microsoft Graph API is a superb way to leverage Microsoft 365 services as a developer. Before you start to wonder where all to get started from, this post is for you!

Microsoft Graph Explorer

Here’s how you can start using the Microsoft Graph API –

Navigate to the Microsoft Graph Explorer (https://developer.microsoft.com/en-us/graph/graph-explorer), you’ll see the below –
By default, if you run on Run Query, it’ll retrieve Sample Data already present.
You can click on the Person icon in order to Authenticate to the environment you are already logged in.
In case you are already logged in, select the environment or login from the start.
You’ll also need to provide consent in order to proceed.
Now that you are logged in, you can see the Tenant information being displayed and you can then also try to test run the same query and you’ll see your actual data being retrieved.

Important Notes

In order to access a Users’ data, they have to consent this data for access.
OData Queries are used to further query the data in order to access them.

Here’s the official link to the Microsoft Graph documentation and other resources: https://learn.microsoft.com/en-us/graph/?WT.mc_id=DX-MVP-5003911

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Permanently Delete users from Power Platform

December 31, 2023 priyeshwagh777 Power Platform Admin Center Dataverse, delete user in Entra ID, delete user in power platform, Dynamics 365, permanently delete user, power apps, Power Automate, Power Platform

Often times, as organizations have users enabled and disabled, over the course of time we see a lot of Disabled Users pile up in the system. Power Platform now lets you delete these Users permanently from the system.

Warning: Please note that this process will not get back the User you delete as you are going to permanently delete the User from Entra ID as well as Power Platform.

Enable Delete Users feature from Admin Center

First, you’ll need to enable this in the Power Platform Admin Center

Select the environment you wish to enable this feature in and then click on Settings.
Then, look for Features section.
you’ll find the option for Delete Disabled Users which would be OFF by default. Switch it to ON.

Zooming in a little bit, this is how the turned on feature should look –
Once you turn this ON, be sure to scroll to the bottom of the page and click on Save to save the changes you just made.

Now that you have turned this on. You can now Delete the Disabled Users.

Pre-Requisite: Permanently Delete User

Now, let’s see how this process is to be carried out –

Assuming the license of the User is now removed and if you Refresh the User in Power Platform Admin Center, you’ll see that the User will appear in the Disabled Users filtered list.
Even if you delete the User in M365, you can refresh the Power Platform and see the User Name still present
Now, if you open the User which you see with a different username in Power Platform Admin Center and click on it to open it in classic UI and see the Delete button to Delete the User
Here’s the delete button.
When you click on Delete and confirm it’ll throw the error message that this cannot be deleted.

Now, the next step is to permanently delete the User from Entra ID. Here’s a blog post to permanently delete the User from Entra ID: Permanently Delete a User in Entra ID

Delete in Power Platform

Now that the User is permanently deleted in Entra ID, you can re-attempt the delete the user in Power Platform.

Now, retry the step from the User page in classic UI as you’ll see the button there.
Now, you can click on the User in the Power Platform Admin Center and see that the user is showing that it has been deleted in the Environment
And you can see the button to now Delete Permanently in the environment as well.
And it’ll ask you if you want to really delete the User.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Time and Materials Billing Backlog

Share this:

Like this:

Settings

Share this:

Like this:

Provisioning a Project Operations Trial

Setting up Master Data in Project Operations Lite

Billing / Invoicing

Copilot for Project Operations

Share this:

Like this:

Resource Roles

Add Role in Cost Price List

Add Role in Sales Price List

Share this:

Like this:

Enable Copilot in Project Operations

Disable Copilot

Share this:

Like this:

Organizational Unit

Cost Price List in Organizational Unit

Sales Price List

Share this:

Like this:

Project Operations Trial Environment

Deployment Type Questionnaire

Set Name and URL for your environment

Share this:

Like this:

Comparison

Share this:

Like this:

Microsoft Graph Explorer

Important Notes

Share this:

Like this:

Enable Delete Users feature from Admin Center

Pre-Requisite: Permanently Delete User

Delete in Power Platform

Share this:

Like this: