Inventory Costing

santosh_1
santosh_1 Member Posts: 1
in NAV/Navision Classic Client
my client has an requirement like

For example, we have an item that costs $5 with 5 on hand and when we run the inventory valuation report on 2/28/2016 it shows $25.

The cost goes up to $7 on 5/1/2016, we have 10 on hand, and when we run the report on 5/31/2016 it shows $70.

However, if we run the report on 5/31/16 using the 2/28/2016 date filter, it shows $35 instead of the $25 when we ran it on 2/28/2016. Which appears to be the 5 that we had on hand on 2/28/2016 multiplied by the new cost that took place on 5/1/2016. Is this because we have our items set up as Standard in the costing method?

Is it possible to run the reports and get the same results, no matter which day we run the report? If we had to change the costing method, is there a quick way to change them all?

Answers

  • Sebastien_Konsbruck
    Sebastien_Konsbruck Member Posts: 30
    edited 2016-07-04
    Dear Santosh,

    It's quite time costly to understand what exactly you need. I recommend you to read the following whitepaper which explains a lot about costing in NAV 2013 (most should still be applicable to 2016): archerpoint.com/sites/default/files/docs/ms-dynamics-nav-2013-inventory-costing-wp-ap.pdf

    Altough one might often think there is need for development, it looks like your request is related more to reporting requirements than to coding questions.

    In the event in which there is no suitable costing method for your current customer I strongly recommend you not to modify the standard valuation codeunit but to do reporting based on information gathered in a second table (or create a view, ...) for example.

    Best regards,
    Sebastien

    Edit: I saw you posted this in the "Classic Client" forum. Attached you can find the PDF for NAV 5.0

Categories