Individual items will not rollup in Manufacturing Standard Cost Changes

This issue is almost always caused by either incorrect setup or data was imported in with incorrect values. To determine what is causing the issue, follow the below steps.

1.  Make sure the Low-Level Code is set correctly for the item. Go to Tools | Utilities | Manufacturing| MRP Low-Level Codes. Set the Max number to 20 and Process.
2.  You can also run the MRP Low-Level Codes Utility in SQL.

Select * from IVR10015 where LLC =’20’

3.  If the LLCs were correct, then we need to look at the BOM if you are running Standard Cost Changes. Go to Cards | Manufacturing |Bill of Materials, pull up the finished good, click on the component that is not rolling up and verify there is an Extended Quantity and Extended Cost. Verify the Floor Stock checkbox is not marked, floor stock items are not included in rollups. Verify the In Date is not in the future.

4.  If the component has a very small quantity (say .00005) and a very small cost (say $0.00002), verify the extended cost will update the standard cost that is in the functional currency decimal places. If my finished good has a standard cost of $8.52, the above extended cost of $0.00010 will not update the standard cost.

5.  Run the Individual Items not Rolling Up script using the below link. There are 3 sections in the script. Follow the below steps to correct each section.

                    https://mbs2.microsoft.com/fileexchange/?fileID=cf100311-3a4a-4626-9a50-fcefcb81381f

6. Results of Individual Items not rolling up script.

Section 1 - The first section are 3 scripts that verify the consistency of the costing columns.

Script 1 verifies the cost of the TOTALCOSTI_1 column in the ICIV0323      

Run the below script.

Select * from ICIV0323 where MATCOSTI_1+MATFIXOHDCOSTI_1+MATVAROHDCOSTI_1+LABCOSTI_1+

LABFIXOHDCOSTI_1+LABVAROHDCOSTI_1+MACHCOSTI_1+MACHFIXOHDCOSTI_1+MACHVAROHDCOSTI_1<>TOTALCOSTI_1

If this script returns results, it means that the TOTALCOSTI_I column has an incorrect value. Update the field to the correct cost using SQL.

Script 2 This script verifies the total costs in the ICIV0323 table matches the standard cost in IV00101. If these do not match, GP will not be able to update the standard cost of the item.

Run the below script.

Select a.* from ICIV0323 a join IV00101 b on a.ITEMNMBR=b.ITEMNMBR where a.MATCOSTI_1+a.MATFIXOHDCOSTI_1+a.MATVAROHDCOSTI_1+a.LABCOSTI_1+a.LABFIXOHDCOSTI_1+a.LABVAROHDCOSTI_1+a.MACHCOSTI_1+a.MACHFIXOHDCOSTI_1+a.MACHVAROHDCOSTI_1<>b.STNDCOST

If this script returns results, it means that the STNDCOST column in the IV00101 has an incorrect value. Update the field to the correct cost using SQL.

Script 3 This script verifies the material costs in the ICIV0323 table matches the standard cost in CT00003. If these do not match, GP will not be able to update the standard cost of the item.
         

Run the below script.

        Select a.* from ICIV0323 a join CT00003 b on a.ITEMNMBR=b.ITEMNMBR where a.MATCOSTI_1<>b.COST_I

                 If this script returns results, it means that the COST_I column in the CT00003 has an incorrect value.

Update the field to the correct cost using SQL to match the ICIV0323.

Section 2 – This section contains individual scripts. An item needs to be in all these tables. In addition, some of these tables have columns that need to be verified.   Find each table from the resulting scripts and verify the following columns and values. 

1. Iv00101 Table

Verify the below columns in the IV00101

VCTNMTHD column must be a 4 or a 5

DECPLQTY column cannot be blank or 0

DECPLCUR column cannot be blank

UOMSCHDL column must have a valid UofM schedule

ITEMTYPE column must be 1

2. CT00003 Table

There must be a record in this table

3. ICIV0323 Table

There must be a record in this table.

NO_CALC_MAT column needs to be 0

4. IVR10015  Table

There must be a record in this table.

ITEMSTATUS_I column must be 1

LLC column is depended on how many tiers down on BOMs the specific item is. If it is a BOM, it will be a 0. If it has a value of 0 and it is a component assigned to a BOM, it is incorrect.

5. CT00102 Table

There must be a record in this table.

ITEMTYPE column must be 1

VCTNMTHD column must be 4 or 5

Section 3- Specific scripts that are from the MFGCheckdata script. If any of these three scripts return results, they must be corrected.

1. Checkdata error “Perpetual items on Periodic BOM”

There is a child item that has a valuation method of Perpetual (actual cost), but the parent item is Periodic (standard cost).

Resolution:

Go to BOM Entry (Cards | Manufacturing | Bill of Materials) and remove the item from the BOM or go to Change Valuation Method (Tools | Utilities | Inventory | Change Valuation Method) and change the valuation method.

2. Checkdata error “BOM Child missing Item Master Record”

There is a child part item number defined in the Bill of Material Line table (BM010115) table does not have a corresponding Item Master (IV00101) record.

Resolution:

Either go to the Item Maintenance (Cards | Inventory Item) window to create the item number or use SQL to remove all occurrences of that item from Bill of Material Line table (BM010115) and BOM Revision table (BM010415).

 To determine the records in the BM010115 run the following script. To update the BM010415 replace the BM010115 with the BM010415 in the below scripts.

Select * from BM010115 where CPN_I not in (select ITEMNMBR from IV00101)

 To delete the records from the BM010115 run the following script. This is sample text. This is sample text. This is sample text.

Delete BM010115 where CPN_I not in (select ITEMNMBR from IV00101)