Adventure Works Equipment: Truck Stock, Purchase Order Receiving, and Returns

Inventory in Field Service moves when a work order product is treated as usage and the transaction is posted against a valid product inventory record. Check the work order product line type, warehouse, quantity, and unit. If the line type is not usage, or the warehouse points to the main warehouse instead of the technician's truck, the wrong stock ledger is affected. More importantly, the manager reports that product inventory records exist for warehouses but not for trucks, so the truck stock has no record to decrement. Create product inventory records for each truck and for each stocked product, and associate the truck with the correct warehouse or truck inventory location. Set the work order product warehouse to the technician's truck so consumption decrements truck stock. Ensure inventory is enabled in Field Service settings and that the work order product is posted when the work order is completed. For existing discrepancies, use an inventory adjustment to align the physical count with the system count, and add a Power Automate flow that creates missing truck product inventory records when a new truck or product is added.

A purchase order alone does not change on-hand inventory. Receiving must create an inventory receipt or adjustment against the destination warehouse. Configure the purchase order with the correct vendor, warehouse, and product lines. When goods arrive, create a purchase order receipt for the received quantities, or create an inventory adjustment with a receipt type linked to the purchase order. Confirm the product inventory record exists for that warehouse and product. To automate the process, use a Power Automate flow that triggers when the purchase order status changes to received, creates the receipt lines from the purchase order products, and posts the receipt. Add validation that rejects quantities greater than the ordered quantity unless an override is approved. Enable purchase order processing in Field Service settings and make sure the users who receive stock have the inventory security roles. Test the flow with a small purchase order and verify that warehouse product inventory increases and that the purchase order shows as received.

Use the inventory return capability to move stock from the truck back to the warehouse. Create an inventory return record with the source truck, destination warehouse, and return product lines with quantities. Post the return so truck product inventory decreases and warehouse product inventory increases. If the return is tied to a specific work order, use a work order product with a return line type so the return is associated with the job. Replace the paper process with a Power Apps or mobile form that technicians submit, and a Power Automate flow that creates the inventory return and notifies the warehouse. Add an approval step for returns that involve expensive or serialized parts. Confirm product inventory records exist for both the truck and the warehouse before posting. Run a reconciliation report by truck and by warehouse after the first month to confirm the return process matches physical counts, and adjust the process if technicians are returning parts without a work order reference.