Project cost accrual on purchase receipts
This topic describes how accrued project costs from purchase receipts can be tracked in Microsoft Dynamics 365 for Finance and Operations.
Invoices for a project often arrive later than the goods and services are delivered, which might have a significant impact on project key performance indicators (KPIs). It important to be able to track these transactions in both financial and project reports.
The following example scenario illustrates this.
Contoso Consulting has started a new cloud deployment project. A purchase order is created to buy a computer for the project. The computer will cost $1500 and installation services will cost $150. The vendor has delivered and installed the computer, but the invoice has not yet reached Contoso Consulting. The project manager would like to see project cost accrual of $1650 before the invoice gets delivered. This cost should also be reflected in the company's month end financial statements.
The accrued cost needs to be recorded on both the financial level and project level for reporting purposes. In Finance and Operations, the financial update of the product receipt can be tracked for the item and procurement categories.
Using this same scenario, let's see how posting a product receipt will impact General ledger and Project information.
The transactions for the committed cost will have the Transaction Origin field set to Purchase Order. Creating and confirming a purchase order does not create transactions for a project.
Step 2: Goods and services get delivered and a product receipt is registered.
Posting a product receipt will use the posting setup for procurement categories and products, and not the posting setup for the project categories. In order to correctly reflect financial impact of purchase accruals, this setup needs to be aligned.
Step 3: Create a draft vendor invoice.
In Finance and Operations, posting a product receipt does not impact project information. As a workaround, you could generate a draft vendor invoice right after posting the purchase receipt. Go to the Purchase Order page > Invoice tab > Generate > Invoice. This creates a pending invoice document that updates project information.
In the Committed cost page, records created in step 1 will be closed and new records will be created to reflect cost commitment coming from the pending vendor invoice. The Transaction origin field for the committed cost will be set to Vendor invoice.
The vendor invoice will remain in a pending state until the actual vendor invoice arrives.