Item Inventory Consolidation

Inventory>Utilities>Item Inventory Consolidation Tool

This feature will allow consolidating Item inventory onto a single record. It has replaced the ability to update Item Inventory, which changed the unit cost of the record which was updated to the cost of the record it was updated by.

The item record must be in a Costed status.

Only the Amount Available will be allowed to move.

Reserved amounts will stay on the original record.

To move from other stores or product codes or adjust the balance, use the existing adjustment routines.

• Select the records to consolidate using the Find feature.
• Enter at least part of the item number.  More information can be entered but at least part the Item number is required. Use F8 to search for item numbers.

• From the list found, highlight the record to send the other amounts to. 
• Click the Set Destination button.

One option is to use the newest record as the destination as it should have the most current cost.

• Tag all the records still in the top list to be added to the destination record.

In tagging records make sure the records are actually similar enough to combine. For example, if dye lots don’t match consolidation may not be desired. Another example would be a large cost difference, for example in the case of a special buy.

• Click the process button

See article >How-to-Understand-the-adjustments-made-during-Item-Inventory-Consolidation- for details on the adjustments made during consolidation.

See article How-to-Make-Item-Inventory-Consolidation-a-part-of-Receiving-Costing for details on making this part of the receiving costing process.

See Consolidation to a Negative Inventory Record.

 

Must be from the same store.

If cost need to be averaged, check Average Cost in the lower right of the screen.