The custom mix part numbers usually have cost entered from the price books from the Paint Manufacturers. This cost is usually at the regular discount schedule for factory pack, which is approximately 40%. The cost is actually around 50% on custom mix and thus inventory values will get out of sync.

The Following procedure will help to isolate that cost so that it can be corrected.

1. In Account Entry in General Ledger (8.4.1) create a different GL account for Inventory and Cost of Goods Sold for Custom Mix Part Numbers.

2. In Inventory Entry (5.1.1) enter the Inventory and Cost of Goods account into each Custom Mix Part Number. Enter <G> at the bottom of the screen to enter GL Accounts into Inventory and Cost of Goods. You will want to fill in the Return Mdse and Warranty accounts also.

3. Every month do a Custom Inventory Sales Analysis (2.1.6) to get the Cost of Components being costed out through Component Use (5.4.5). This assumes you are downcounting your components properly.

4. Then do 2 journal entries (8.1.1):

   One to reverse the cost from the two Custom Mix GL accounts back down to 0. Debit the Custom Mix Inventory Account and Credit the Custom Mix Cost of Goods Account. Get the amount from either the Custom Mix Inventory or Cost of Goods Account for the period.  The two accounts will be the same amounts since you are not dealing with sales, but inventory costs.  They will cancel each other out back down to $0.

   Second, using the Cost from the Custom Inventory Sales Analysis report or Posted Component Use Report (5.4.5.5), Debit the regular Cost of Goods Account and Credit the regular Inventory Account.