Skip to end of metadata
Go to start of metadata

Expert Empowerment Session:
How does parent price work in relation to multiple layers

The Update Parent Prices Globally functionality (Production -> Update Parent Item Prices Globally), updates the parent item prices defined in a Bill of Materials (BOM) automatically, if their component items prices have changed. However, sometimes when changing the prices, the Update Parent Item Prices Globally returns the system message:

No parent item prices to be updated found [Message 65020-3]

This system message indicates that none of the component items prices have changed in their price lists.
Accordingly, there is no price update required for parent items.

In order to obtain results from the Update Parent Item Prices Globally function, the price of an item must have changed in the price list used in the BOM and the price list must be selected in the Update Parent Item Prices Globally - Selection Criteria window.  If the price of a component item is updated in the BOM, it will not update the price of the item in its related price list, selected for the component item in the BOM. Consequently, when running Update Parent Item Prices Globally, the system message: No parent item prices to be updated found [Message 65020-3] is returned.

For example, a BOM exists for the parent item Chocolate Chip Muffins. In this BOM, the component Item No. 133, Chocolate, has a Unit Price of GBP 1.00.

This price corresponds to its price as defined in the Base Price list.

If the price of the component item Chocolate is changed to GBP 0.50 in the BOM, it will not update the price of the item in the Base Price list.

In this scenario, the Update Parent Item Prices Globally will return the system message because it cannot detect a price change for that item in the price list (as selected in the Update Parent Item prices Globally - Selection Criteria window).

If the price list is now updated corresponding to the price defined in the BOM the Update Parent Item Prices Globally will return results for those BOMs where the price of the component does not match the price defined in the price list.

Continuing with the Chocolate Chip Muffin example, the price of the component item Chocolate is updated in the Base Price list to GBP 0.50. This now corresponds to the price defined for the item in the Chocolate Chip Muffin BOM as seen in the previous screenshot.

When the Update Parent Item Prices Globally is executed, the result does not show the BOM for the parent item Chocolate Chip Muffin. This is because there is no difference between the price defined for the component Chocolate in the BOM and that defined for the item in the Base Price list.

The result shows another BOM parent item, Item Code 135 the Chocolate Shapes - Bunny.

The parent price for the Chocolate Chip Muffin BOM can only be manually updated in the BOM. Alternatively, the price of the component item should be returned to its original state and it will then appear in the Update Parent Item Prices Globally result.

Note
Update Parent Item Prices Globally will not detect changes made to prices of the components in a sublevel BOM (a BOM within a BOM), where the parent of that sublevel BOM is not defined as a Phantom Item.

Another reason the system message No parent item prices to be updated found [Message 65020-3] may be displayed when running the Update Parent Item Prices Globally is due to the selection criteria used.  In particular, the incorrect use of the options Parent Items or Component Items in the selection criteria window may cause the message to display.

The selection of either of these options has an impact on the way the system checks for updates.

Component Items
When selected, the system looks at the named component items and returns the parent items based on the price changes made to these component items.

Parent
When selected, the system looks at the components of the named parent items and returns those BOMs where a component item price has changed in its corresponding price list.

In the previous examples, item 133 Chocolate, had its price changed from GBP 1.00 to GBP 0.50. Continuing with this example, in Update Parent Item prices Globally - Selection Criteria, the option Component Items is selected for the Selection Criterion and the item code 133 is entered in the Code From and To fields.

With these options, selected results are returned.

However, when the Selection Criterion is changed to Parent Items, no results will be returned. Instead the system message No parent item prices to be updated found [Message 65020-3] will be displayed.

To return results with the option Parent Items chosen in the Selection Criterion,  the parent item code needs to be entered in the Code From and To fields.

In this example, the Code From and To fields contain parent item codes 133 to 510 (Chocolate Shapes - Bunny to Chocolate Chip Muffin, respectively.

When executed, results are returned highlighting the changes to component item prices in their respective price lists.