Dynamics 365 Field Service : Create a list of receivable products for a purchase order

In the fast-paced world of field service operations, efficient inventory management is critical. When handling purchase orders (POs), one key process is creating a list of receivable products. This process ensures that technicians and warehouse managers know exactly what’s expected, what’s pending, and what’s received—helping maintain accuracy and avoid costly errors.

This blog will walk you through both the functional aspects (what business users see and why it matters) and the logical/system flow (how Dynamics 365 Field Service makes it work under the hood).

Why Create a List of Receivable Products?

When a company issues a purchase order to a vendor, the expectation is that the products will arrive in full and on time. However, in reality:

• Vendors may ship partial quantities.
• Products may arrive damaged or not at all.
• Multiple shipments may fulfill a single PO.

Here’s where the “Receivable Products” list in Dynamics 365 Field Service comes in. It acts as a checklist for warehouse staff to validate incoming goods against what was ordered.

Key Business Benefits

Transparency:

• Warehouse users instantly see which items are expected and their quantities.

Accuracy:

• Minimizes errors in receiving by matching items against POs.

Partial Receipts Support:

• Handles cases where only part of the PO is delivered.

Integration with Inventory:

• Automatically updates stock levels when items are marked as received.

Audit Trail:

• Provides a history of received items and quantities for financial and operational reconciliation.

Step-by-Step Functional Flow in Dynamics 365 Field Service

Here’s how a field service user typically creates a receivable products list:

Navigate to Purchase Order

• Go to Field Service > Inventory > Purchase Orders.
• Open the PO you wish to receive items for.

Check Purchase Order Lines

• Review all products listed under PO Lines.
• These represent the items ordered from the vendor.

Create Receivable Products

• Click on + New Receivable Product from within the PO.
•  The system will automatically pull the products from the PO Lines.

Enter Received Quantities

• For each product, enter the quantity received.
• You can partially receive if only part of the order has arrived.

Save and Post Receipt

• Once all received quantities are entered, save the record.
• Optionally, post the receipt to update inventory.

 Repeat for Additional Shipments

• If more shipments arrive later, create additional receivable product records.

Logical/System Perspective: How Does Dynamics Handle This?

• For developers and technical consultants, let’s break down what happens in the background.

Business Logic Flow

1. User Action: User clicks "New Receivable Product."

2. System Process:

• Retrieves all `msdyn_purchaseorderproduct` records for the selected PO.
• Populates a new `msdyn_receiptproduct` record for each item.

3. Partial Receipts:

• Updates `msdyn_quantityreceived` on `msdyn_purchaseorderproduct`.
•  Maintains pending quantities for future receipts.

4. Inventory Adjustment:

• When the receipt is posted, it triggers inventory updates via inventory journals (`msdyn_inventoryadjustment`).

5. Plugins/Workflows:

• Can validate received quantities don’t exceed ordered quantities.
•  May trigger notifications if shortages or discrepancies are detected.

Developer Customization Points

Here are logical touchpoints for extending this feature:

Custom Validation Plugin:

• Prevent users from receiving quantities larger than ordered.

Power Automate Flow:

• Send an email alert when a partial shipment is received.

Custom API/Action:

• Integrate with external vendor systems for automatic receipt creation from EDI feeds.

JavaScript on Form:

• Show warnings if received quantities differ from expected quantities.

Gotchas & Best Practices

Partial Receipts are Normal:

• Educate users that partial receipts won’t close the PO. The PO remains open until all items are fully received.

Inventory Impact Only on Post:

• Quantities entered do not affect inventory until the receipt is posted.

Security Roles:

• Ensure warehouse and inventory staff have appropriate access to create/edit receipt records.

Field Service Mobile App:

• This feature is available on mobile—enable warehouse staff to update receipts in real time.

Final Thoughts

Creating a list of receivable products for a purchase order may seem like a small step in the field service workflow, but it plays a vital role in ensuring inventory accuracy and operational efficiency. Dynamics 365 Field Service streamlines this process, making it easy for warehouse staff to stay on top of incoming goods.

For developers, understanding the underlying data model and flow unlocks powerful customization possibilities—whether integrating with vendor systems or automating inventory updates.

By leveraging this feature, organizations can reduce errors, improve accountability, and deliver better service to customers.