Open Forum

Expand all | Collapse all

Unit cost history

  • 1.  Unit cost history

    Posted Jan 02, 2019 09:33 AM
    Hi all,

    We are using FIFO costing. I have a part that was sitting around $300 for a length of time. 300 pcs of the part were adjusted in using the item journal at 0 dollars.  The closing entry on this date brought the unit cost down to $65.

    What I need to do now is analyze to see if this has happened with any other parts.  But I am stuck as to how to get this data out of NAV. The only way I can see it currently is by drilling down onto unit cost from the item card - which opens page "average cost calc. overview". The problem is I can't un-filter this page to show me history of all parts.



    Matt McDowell
    Supply Chain Analyst
    Valley Blades Limited
    Waterloo ON
    NAVUG Summit - Post

  • 2.  RE: Unit cost history

    Posted Jan 03, 2019 09:45 AM
    See if you can go to the Value Entry table and find all entries where the Unit Cost = 0.  That should give you an indication of any other items that followed the same scenario.​

    Crystal Tollison
    ArcherPoint Inc.
    Lawrenceville GA

    NAVUG Summit - Post

If you've found this thread useful, dive deeper into User Group community content by role