Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

Standard cost including fees

Posted on by 35

Our system is NAV 2013R2.

We have some items where the costs are made up of:

- Raw materials

- Man hours /capacity

- Machining hours

- Freight

- Customs

- Tools

For the freight, customs and tools it should be a fixed amount (or percentage for customs), but today we have put it in the BOM, which means that i.e. "Tools" has to be added to stock before it can be used on the item. But it is a bit artificial as we just count the tools in the stock when needed, it doesn't reflect a psychical item. Is it possible to add some fees to an items standard cost?

Ideally a break down like:

Rawmaterials = equals standard price for material used (OK as of now)

Man hours = Time in BOM x rate from workcenter (OK as of now)

Machining hours = Time in BOM x rate for machining on workcenter (Not implemented, but as far as I can see I can only add it on top of the unit cost on the workcenter, not have a seperate rate for manpower and machinging cost?)

-Freight = fee added 20 USD

- Customs = 2 % of total cost (or similar)

- Tools = fee added 30 USD

The actual posting for the fee's need to go to a designated GL account.

Can something like that be achieved?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Standard cost including fees

    Morten,

    This manufactured item, I am guessing based on the scenario this item is manufactured, you are trying to capture variable or fixed outside costs. Since a manufactured Item rolled-up cost is per unit, could you set the Freight and Tools are a Unit Cost level by applying an Overhead Amount on the finished good item? The Customs % you can set as 2% or Indirect % for the Finished Good item.   Sadly these amounts are all booked to 1 GL Account based on the Posting Group setups.

    I am not considering the Cost Accounting granule. This is something you might consider as the base functionality might not achieve what you want. I am attaching the Cost Accounting manual so you can read up on it.

    Hope this helps.

    Thanks,

    Steve

    NAV2013_5F00_05_5F00_FinancialManagementAdvanced.pdf

  • Morten_DK Profile Picture
    Morten_DK 35 on at
    RE: Standard cost including fees

    That looks like a neat functionality, but I am not sure that is what I am looking for. I need to register the cost fees somewhere - as far as I can see "Cost share" extracts current information?

  • Suggested answer
    Manan_Shah Profile Picture
    Manan_Shah 1,457 on at
    RE: Standard cost including fees

    Hi,

    There is option on item card where you can check item components wise cost.

    It's name cost share.

    please check, i think that will be useful for you.

    Please verify the reply if it answers your query

    Best Regards,

    Manan Shah

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans