Project Item requirement consumption from PO -to not be automatically consumed

Requirement : When you want manual control over your inventory consumption for inventory made from Purchase order item requirements

PRE-SETUP Information

  1. Create new Project Contract

    USMF/Project management and accounting/Common/Projects/Project contracts

Enter details as below:

Project contract ID: 000187(comes automatically based on number sequence setup)

Name: Demo

Funding Type: Customer

Funding Source: US-025

Sales Currency: USD

Click OK


Save & close project contact form

  1. Create new Project

    USMF/Project management and accounting/Common/Projects/All Projects

Enter details as below:

Project type: Time and Material

Project contract ID: 000282(comes automatically)

Name: Demo

Project group: TM

Customer: US-025

Sales Currency: USD


Click OK


  1. Set parameter in Project management paraments

    USMF/Project management and accounting/Setup/ Project management and accounting parameters

    General tab >Project Purchase orders >Item consumption should be turned off which tells that the items should be immediately consumed if it is marked


Using Item requirement form

Step1: Enter Item requirement

USMF/Project management and accounting/Common/Projects/All projects

Select project 000282

Open Item requirement from Plan tab

Click New

Enter Item number : P0011

Site:1

Warehouse :11

Quantity:10

Line property: Billable


Click Project tab

Enter Unit price(sales) as 10 USD

Now click Inquiries>sales orders


This will open the sales order created


Step2: Make a Purchase order for this from Item requirement form itself

Click Functions>Create Purchase order


Select Include checkbox and Click OK

Step3: open created Po and receive

USMF/Procurement and sourcing/Common/Purchase orders/All purchase orders

Select PO 000143 created in above step

Action Pane>Purchase tab >Click Confirm button


Action Pane>Receive tab


Click Generate Product Receipt

Key in product receipt number as ‘demo321’ and click Ok

We will get a dialog asking “Consume items for the project immediately” Yes or No option will be there


Please ask users to click NO

Note: If we click Yes then the inventory will get automatically consumed

Click product receipt journal


Step 4: Check Sale order Line status

USMF/Project management and accounting/Common/Projects/All projects

Select project 000282

Plan tab >Item requirements

Select Show All and Inquiries >Sales order

Step 5: Check Line status of the Sales order

*** Actual Result ***

We see that the line status of the Sales is “open order” which is correct as we had not consumed the inventory purchased automatically


*** Expected Result ***

Same as actual

Step 6: Make a picking list and packing slip from Item requirements form for consuming quantity

Click Posting>picking list


Click Ok

Click posting>Picking list registration

Updates>update All


Click close

Click Posting >packing slip


Update Quantity as Picked


Click Ok

Step7 : Check project posted transactions

USMF/Project management and accounting/Common/Projects/All projects

Select project 000282

Action Pane>manage tab

Click Related information>Posted transactions

We see that the project posted transactions are getting populate on Packing slip posting itself if we use Item requirements which is correct

Step 8: Check Sale order Line status

USMF/Project management and accounting/Common/Projects/All projects

Select project 000282

Plan tab >Item requirements

Select Show All and Inquiries >Sales order

Step 9: Check Line status of the Sales order

*** Actual Result ***

We see that the line status of the Sales is “Invoiced ” which is correct as we had made a complete consumption (full 10 quantity)

That’s because for Item requirements, Item transactions are consumed when the packing slip is updated.

Although a sales order is processed when the corresponding customer invoice is updated, item requirements are processed when the corresponding packing slip is updated.


NOTE: Sales order line status is Invoiced as it was invoiced as part of the Item requirement (which is Invoiced after posting the Packing slip)

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!