The inventory record that was last sold is considered the master record.
When we merge two parts with the same part number, the values for the following fields are accumulated into the values in the ‘Master’ record: Total Cost, On Hand, On Order, Committed, Core Quantity, Month-to-Date Quantity, Month-to-date Sales, Year-to-date Quantity, Year-to-date Sales, and the Monthly quantity for 12 months.
In addition, any parts on open orders or open purchase orders are updated with the new line code.
There are a number of fields that are not affected. This was done with the assumption that the ‘Master’ record, which was created more recently, has correct values.