Options

Incorrect Item Ledger Entry and Value Entry

jdelfraissejdelfraisse Member Posts: 14
We have submitted the problem to our partner, I was curious of the ideas from other users on how to fix this. We can't determined what caused the problem and can't find any other examples of it happening before. We have a sales invoice that was posted. The item in question was sold for 1 CASE (25 each). The problem is the Item Ledger Entry and Value Entry both have the quantity at 1 each instead of 25 each. The sale amount shows the 1 case price, the cost shows the 1 each cost. This is a problem with quantity on hand as well as the value of the item. Any suggestions on the entries to fix this problem? Bottom line, the customer was charged the correct amount, it just didn't come out of ledger or value correctly.

Thanks,

Jonathan
Jonathan Delfraisse
A Microsoft Dynamics Nav End User
Version US 4.00 SP3 (5.0 SP1)

Comments

  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    We have submitted the problem to our partner, I was curious of the ideas from other users on how to fix this. We can't determined what caused the problem and can't find any other examples of it happening before. We have a sales invoice that was posted. The item in question was sold for 1 CASE (25 each). The problem is the Item Ledger Entry and Value Entry both have the quantity at 1 each instead of 25 each. The sale amount shows the 1 case price, the cost shows the 1 each cost. This is a problem with quantity on hand as well as the value of the item. Any suggestions on the entries to fix this problem? Bottom line, the customer was charged the correct amount, it just didn't come out of ledger or value correctly.

    Thanks,

    Jonathan

    If possible, best is to use journals to zero the item then block it, create a new one and put the correct entries in the new item.

    These are generally one offs, and the cost to track them down is far more than the cost of fixing it and moving on. Unless of course it starts to happen again.
    David Singleton
  • Options
    ara3nara3n Member Posts: 9,256
    I suggest to unapply the Item Ledger entry. Create a credit memo and apply it to the sale with qty of 1 and same sales amount.

    Then create the sales order with correct qty (case) and apply it to the entry that the sale had happened.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    kitikkitik Member Posts: 230
    My guess is that:
    * Quantity per unit of measure of the CASE was set to 1 instead of 25 at the moment of creating the line.
    * You had a sales price created for the CASE, so the price was correct.

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • Options
    jdelfraissejdelfraisse Member Posts: 14
    The problem was the Quantity(Base) was not the correct number in the sales invoice when it was processed. We are not sure how this happened and think it was a one-time thing. Our solution to fix it was to "Copy Document" to a sales credit which copied the bad Quantity(Base). Post that and then do a new sales invoice. The Quantity(Base) was correct and it processed correctly. Thank you for all of your help in this.
    Jonathan Delfraisse
    A Microsoft Dynamics Nav End User
    Version US 4.00 SP3 (5.0 SP1)
Sign In or Register to comment.