How to Find Open Purchase Orders for an Old BOM Revision
Engineering released Rev C on Monday. The supplier still has a Rev B order due next week. One work order can use some of the older pieces. The rest need a decision before the supplier completes the batch.
Compare open PO lines with the approved engineering change and the demand still allowed to use the old revision. Keep the effective rule, order status and quantities visible for review.
One supplier order, two revision decisions
The new revision applies to new orders from June 1. Engineering has approved the 30-unit legacy build on Rev B.
| Record | Revision | Units | Review outcome |
|---|---|---|---|
| PO-812 / 10, open | B | 100 | 30 can cover approved legacy demand |
| WO-301, legacy build | B | 30 | Approved use |
| WO-308, new build | C | 80 | Requires Rev C |
| PO-812 / 10, potential excess | B | 70 | Ask about conversion, change or cancellation |
The buyer should review 70 Rev B units and verify Rev C coverage for WO-308. Changing the revision in the spreadsheet won’t establish that the supplier can ship the new part.
Bring in the effective revision rule
Use the engineering change record, open PO lines, and the work orders or allocations. Match the part number, revision, site and effectivity rule. A rule based on serial number or order approval needs that field in the analysis.
Check already committed material
Separate unreceived, unaccepted, held and released inventory. Show legacy demand that engineering explicitly permits. Keep the older revision with unknown disposition on a hold-for-review list.
Review with engineering before calling the supplier
Put approved changes and PO lines in separate tabs and include the legacy allocation rules.
Which open PO lines reference superseded revisions? Show quantity still usable on approved work, excess units to review, and source rows for the effective rule.
Confirm the approved disposition and supplier options before changing the purchase order.
Dynamics 365 engineering change management
The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.
Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.
For more checked examples, see Jolene.pro Workbook Studies.