Open Forum

Expand all | Collapse all

Unit cost history

  • 1.  Unit cost history

    Posted 15 days ago
    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.

    Ideas?

    Thanks

    ------------------------------
    Matt McDowell
    Supply Chain Analyst
    Valley Blades Limited
    Waterloo ON
    ------------------------------


  • 2.  RE: Unit cost history

    TOP CONTRIBUTOR
    Posted 14 days ago
    Matt,
    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
    Consultant
    ArcherPoint Inc.
    Lawrenceville GA
    ------------------------------