Error when running a Manufacturing Standard Cost Rollup/Replace in GP 'Procedure or function mcstDoItemSCST02 expects parameter @parent_part2'

Hi Everyone,

I wanted to share some information regarding an error you may see during a Standard cost Rollup/replace process and provide you steps on how to resolve it.  The error is "Procedure or function mcstDoItemSCST02 expects parameter@parent_part2".

This is caused by a recursive BOM.  A bill of materials cannot contain a component that is also the same as the finished product. Recursive items cannot be entered in the Bill of Materials Entry dialog box but may be created by mistake during an import process. Therefore, recursive items cannot be removed from within the Microsoft Great Plains program. You may have to use SQL Query Analyzer to remove the recursive item from your bill of materials.

Steps to Correct:

Step 1

Run the below script.

Select * from BM010115 where PPN_I=CPN_I

If the script returns results, delete the lines using the Dex_Row_id in SQL.

Step 2

Run low level codes utility (Tools | Utilities | Manufacturing | MRP Low Level Codes). I would suggest running the executable in SQL even if they have run the LLC Utilities tool. This will help locate any recursive BOMs.

exec mbomLLCUtility 110

Then to make sure there are no recursive BOMs check the LLC in IVR10015   with the following script.

Select * from IVR10015 where LLC =’110’

If the above script returns results, it means that there is some type of recursive BOM in their system. I do not have any scripts that will identify the recursive BOM so you will need to have your client evaluate what all of the items have in common from the script results. An example of a recursive BOM would be finished good is Green Phone, subassembly of Green Phone is Handset Assembly, component of Handset Assembly is Green Phone. You will need to delete these using SQL.

If it is not apparent which BOM needs to be deleted run the script again but set the LLC to a smaller number, say 105. Look at this item it is usually the item or is assigned directly to the item causing the duplicate.

Locate the MakebyCode_1 column. Look for items that have a value of 3 in this column. This means that this is a subassembly. Go to Inquiry | Manufacturing | BOM View and enter you time. See what the item is used in and see if you can determine what BOM had the recursive BOM.

Step 3

Contact the support desk.