mibuso.com
Home› NAV/Navision Classic Client

Unit Cost problem due to negative inventory

raniapetraniapet Member Posts: 3
edited 2007-02-17 in NAV/Navision Classic Client
I have a problem with the unit cost. Some items were transferred from our previous program into Navision with a negative inventory, thus a unit cost of zero. When a sale is made, then the computer creates a unit cost of its own, and profitability is wrong.

I cannot do a revaluation journal because it does not bring any values at that date because inventory is negative.

How can I correct the unit cost in these items?

Thank you

Comments

  • mukshamuksha Member Posts: 274
    If the quantum of items are less then you can post the adjustment entry from the item journal by changing the workdate and apply the entry against which you want to make adjustment.
    Mukesh Sharma
  • raniapetraniapet Member Posts: 3
    I cannot post anything before a certain date, so I cant do that!!! :|
  • Alex_ChowAlex_Chow Member Posts: 5,063
    The unit cost will automatically be adjusted when you do a positive adjustment for the stock. The cost will be whatever the cost you put in on the positive adjustment.

    If you cannot post something for a certain date, ask your accounting supervisor to open up those dates for you.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Most importantly, if you know you have negative stock in the system then it means you know your stock is wrong - so do a full stocktake and post it via a physical inventory journal.

    As for application, I am not exactly sure about it, but I think if you have a starting entry of -5 and it says a Remaining Quantity of -5 in the item ledger entries (Item Card, Ctrl+F5) and then you find you have 3 in stock and post it via a Phys. Inventory Journal and therefore it will post 8, then you run the Adjust Cost - Item Entries then I think they will be applied automatically. Negative remaining quantities are always applied by whatever extra stock you have by this batch job - I'm not sure but I think.
  • Alex_ChowAlex_Chow Member Posts: 5,063
    Miklos Hollender wrote:
    Most importantly, if you know you have negative stock in the system then it means you know your stock is wrong - so do a full stocktake and post it via a physical inventory journal.

    As for application, I am not exactly sure about it, but I think if you have a starting entry of -5 and it says a Remaining Quantity of -5 in the item ledger entries (Item Card, Ctrl+F5) and then you find you have 3 in stock and post it via a Phys. Inventory Journal and therefore it will post 8, then you run the Adjust Cost - Item Entries then I think they will be applied automatically. Negative remaining quantities are always applied by whatever extra stock you have by this batch job - I'm not sure but I think.

    You're right, any negative quantities will be applied when you put positive quantites in there.

    One other note, you probably want to bring all of your negative stock to 0 before you move forward with Navision.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Sign In or Register to comment.