[BC SaaS] Standard Cost Rollup for items using "Average" Costing Method (Reference only)

(1) Share

Report

Posted on by SL-10120158-0

Hi everyone,

We are currently running Business Central SaaS.

Our inventory setup is configured with the Average Costing Method (Weighted Average/PMP) for our items.

Even though our inventory valuation is based on Average Cost, we still need to calculate once a year a "theoretical" Standard Cost based on our current BOMs and Routings.

The goal is to update the Standard Cost field on the Item Card solely for reference, reporting, and variance analysis purposes. We do not want this to affect the General Ledger or the actual Inventory Valuation.

The Issue is that we are finding it impossible to run the Standard Cost Worksheet (Rollup) for these items. The calculation does not seem to work.

Question:
Has anyone successfully managed to run a Standard Cost Rollup for items set to "Average" in standard BC? If so, is there a specific setup required to allow the calculation without impacting the GL?

Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

OussamaSabbouh 5,396 on at

Like (1)

Report

Hello,

No, BC cannot roll up Standard Cost for items using Average cost.

Roll-up only works when the item and all components are Standard cost.

There is no setup trick to calculate Standard Cost for Average-cost items without affecting the G/L.

Workarounds = external calculation or a custom extension.

Regards,

Oussama Sabbouh

3 people found this reply helpful.

Was this reply helpful? Yes No