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
-
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
-
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
-
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!