gptip42day - Unable to Perform Cost Rollup

Frank Hamelly | MVP...

46,532 Super User 2025 Season 1

Like(1)

Report

Here's a good one for you, gang. If you're using GP Manufacturing and you ever restore one database over another - for example, if you're setting up a new company, run these scripts on the new company -

Select * from COSS0401

Select * from MOPS0100

COSS0401 is the Costing Setup Table. MOPS0100 is the Manufacturing Order Preferences table.

If there is more than one record in either of these tables, you must remove the incorrect one, i.e., the record that has the incorrect Company ID in the first column of the tables. To verify which company ID relates to which database, check SY01500 in the DYNAMICS database.

This condition will throw a 'Subquery returned more than one value' error when you try to do a cost rollup from within either the Standard Cost Changes window or via the 'Rollup and Revalue' Routine in Manufacturing.

Apparently, when a company is restored into another company, the MFG setup tables do not get updated with the new company ID (they still have the old company's ID and running the company restore script does not update them). Then when you go into the MFG setup windows, another row is added to these tables with the new company ID.

This was originally posted here.