Microsoft Dynamics AX (Archived)

costing sheet/ costing version

(0) Share

Report

Posted on by kongyu

420

Hi,

Anyone familiar with AX inventory costing version and costing sheet?

I have a multi level BOM structure and I setup a costing sheet as below:

Total Material Cost

a) Coil cost group (let say result is USD 20)

b) Oil cost group (let say result is USD 10)

Total Process Cost

a) Cutting cost group (let say result is USD 20)

Total indirect cost

a) Overhead = 10% of (Total Material group + Total process cost)

After I run the BOM calculation, the total material cost and total process cost are calculate correctly by each BOM level. But the OVERHEAD cost is not as what i expected.

I expect the Overhead = USD 50 x 10% = USD5.

So my final FG cost id USD 55. But Ax calculate the Overhead cost is by each BOM level and it roll and total up from bottom level to the upper level. Thus my total overhead cost become very high.

I try to play with the setting “Subtype” = Level, sublevel & total but still can’t get it.

Can anyone please advice.

Thanks.

*This post is locked for comments

All responses (2)

Answers (0)

Martin Kinze 85 on at

Like (0)

Report

Re: costing sheet/ costing version

Hi,

I've exactly the same problem.

When using explosion mode "single level" you can use "sublevel" and the indirect costs are calculated only once.

BUT: This seems to be not working for multilevel.

Has anyone an idea why?

THX!

Martin
Weaveriski 23,616 on at

Like (0)

Report

Re: costing sheet/ costing version

AX is functioning correctly in theory because you are basing the overhead on the total material and total process cost, and the sub-BOM's are calculated using the same logic and therefore the overhead is applied to these. You could apply the 5% to the cost groups rather than the totals, but this would mean the structure of your cost groups would not contain the cost groups defined in the final product in the sub-products otherwise it would again apply this and roll it up. Your setup should be total from my understanding, but depending upon the configuration I am not sure how this would work.

Also check the explosion mode on the costing version, you could set this to single level, and then when you run it for the top one it will pick up that level, but if you run it for the lower levels it will, guessing about your structure, include the indirects at the lower level and therefore roll them up to the parent anyway because they are in the costing version.