Announcements
Hi
I want to be able to receipt and bill a whole purchase order without having to receipt each individual product.
As an example we have a bulk stock update that comes in once a month with 60 products included.
All products are going to a single warehouse and we just want to quickly receipt the lot.
Any ideas.
A possible solution would be to create a custom field called 'Receipt whole Purchase Order' on the Purchase Order entity.
Then when the field is set to 'Yes' then either by Power Automate or Plugin (Your choice):
- Create a 'Purchase Order Receipt' record
- For each Purchase Order Product found on the 'Purchase Order', create a 'Purchase Order Receipt Product' record and copy the quantity on 'Purchase Order Product' to the quantity received field on the 'Purchase Order Receipt Product'.
Using this sort of logic, Field Service will automatically set the 'Purchase Order' status to "Products Received' once the plugin or power automate has been completed
Hi Thomas,
Thanks for this
I'm struggling to put the flow together.
I've added the Yes/No Choice. "Receipt whole Purchase Order"
And built a flow
When a row is added, modified or deleted "Purchase Order"
Condition - "Receipt whole Purchase Order" Equals "Yes"
If Yes - Perform Unbound Action (Not sure how to add the action to change "Status")
Apply to Each.
I'm not great with flows so apologies if this looks totally wrong.
Looks mostly correct so far.
Flow steps below:
- When row is modified "Purchase Order"
- Condition - "Receipt whole Purchase Order" Equals "Yes"
- Get List of Purchase Order Products
- Create 'Purchase Order Receipt'
- Apply to Each (Get List of Purchase Order Products)
- Create Purchase Order Receipt Product
- Fields:
- Copy Quantity from each Purchase Order Product
- Link the Purchase Order Receipt Product to the 'Purchase Order Receipt' which was created before
How do I set the flow to Create 'Purchase Order Receipt'
docs.microsoft.com/.../connection-cds
You will need to use 'Add a new row'
Thanks Thomas
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 27
KristineRisberg 19
Manoj - ManoVerse 17 Super User 2026 Season 1
