You may want to test in a test company, but I don't think negative quantity (over-distribution) of a Standard Cost item will create the issue you describe.  You can look at the KB article on Cost Hierarchy ("What is the item cost hierarchy in Sage MAS 90 and 200" - Resolution ID 638) and work the mechanics.  You may also want to have a look at Resolution ID 425322 if the average costs are significantly incorrect coming into the PO - although again, they should typically reflect the anticipated actual cost which is often different and must be entered manually anyway.  Finally, Resolution ID 401110 might offer a solution - again, test the resolution in a test company.  If the resolution works, you could extract, manipulate, and use VI to import transactions to facilitate the process (monthly) if needed.  Hope some of this helps.

You may want to test in a test company, but I don't think negative quantity (over-distribution) of a Standard Cost item will create the issue you describe.  You can look at the KB article on Cost Hierarchy ("What is the item cost hierarchy in Sage MAS 90 and 200" - Resolution ID 638) and work the mechanics.  You may also want to have a look at Resolution ID 425322 if the average costs are significantly incorrect coming into the PO - although again, they should typically reflect the anticipated actual cost which is often different and must be entered manually anyway.  Finally, Resolution ID 401110 might offer a solution - again, test the resolution in a test company.  If the resolution works, you could extract, manipulate, and use VI to import transactions to facilitate the process (monthly) if needed.  Hope some of this helps.

Hello WadeB,

Can you please Email Sage Support at [email protected] with your Sage Customer Account number and put "Attn: Long Nguyen" on the subject of the email.  I will take a look at this issue.  

Thank you,

Long Nguyen

Sage 100 ERP Support Analyst.