Industry Use Cases

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.

RecordRevisionUnitsReview outcome
PO-812 / 10, openB10030 can cover approved legacy demand
WO-301, legacy buildB30Approved use
WO-308, new buildC80Requires Rev C
PO-812 / 10, potential excessB70Ask 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.

Leave a comment