Planning Worksheet- Planning purchases for an item with multiple revisions (using different Item Numbers)


We have some printed items (raw material components used in production) and when they are revised a new item number is issues so item 100-01 may get a new revision, item 100-02. This may not be the best practice because we will continue to use item 100-01 until its inventory is depleted and then will start using 100-02 instead.

So the problem is that we want the Planning Worksheet to plan and suggest purchases as needed for 100-02 but consider that there is still existing stock of 100-01.

Any thoughts or suggestions?

Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare/Mars Edge
D365UG-BC/NAVUG All-Star
Twitter: @RosenbergL

Maybe try using BOM versions with start dates and end dates for the 2 different items?