Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

costing sheet/ costing version

(0) ShareShare
ReportReport
Posted on by 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

  • Martin Kinze Profile Picture
    Martin Kinze 85 on at
    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 Profile Picture
    Weaveriski 23,616 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans