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.
Thanks Thomas
docs.microsoft.com/.../connection-cds
You will need to use 'Add a new row'
How do I set the flow to Create 'Purchase Order Receipt'
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
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.
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
MVP-Daniyal Khaleel 76
Tom_Gioielli 30 Super User 2025 Season 2
Gerardo RenterÃa Ga... 15 Most Valuable Professional
