Negative stock?

Navision 3.70 UK We have one part on stock (let’s say qty: 2), then it was completely sold (with serial numbers), then received back on a Sales Credit Memo (with serial numbers as well). Now let’s look at the ledger entries of the credit memo: 2 ledger entries are created (because of the serial numbers). Next transaction is a neg. adjustment via item journal (qty. 1). Last transaction is a sales order/shipment (qty. 1) with serial number. Here comes the strange result: The first ledger entry of the credit memo is still OPEN and shows “Remaining Qty.” -1, the second ledger entry of the credit memo also shows OPEN and “Remaining Qty.” 1. In total this makes 0 (which would be expecetd), but as there is still one ledger entry OPEN with “Remaining Qty.” 1 the systems reserves it on new sales order AND you may sell it!! How could this have happened? What is the best way to correct it? Where in general can you see which ledger entries (positive/negative) belong to each other? You help is greatly appreciated.

Check that the following are the same on both lines: 1) Location Code 2) Serial No. 3) Lot No. If any of these fields are different, then the Item Ledgers would not apply.

Hi Chris, thanks for the answer. The three fields are in fact identical (location code), nor serial- or lot number. Any more ideas? Would it be dangerous to manually change the remaining quantity to 0 and the status OPEN to FALSE?

Tried to reproduce in 3.70b-DK - worked fine for me. Two hints: *Install all the hotfixes. There are 17 of the kind for 3.70-DK. *Revise the setup of the Item Tracking Code in use.

quote:

How could this have happened? What is the best way to correct it? Where in general can you see which ledger entries (positive/negative) belong to each other? You help is greatly appreciated.
Originally posted by mschenk - 2004 Nov 30 : 13:32:23

to see the application between ILE look at table 339. Do not change remaining quantity manualy! Sum of remaining qty has to be equal to sum of quantity, and has to reflect the application written in table 339. You could try to post one positive entry applying it to the entry having remaining qty -1, and a negative one applied to the other open entry you have. If this doesn’t work … well you should start thinking about modifying remaining qty and item ledger application … [B)] Elena

Thanks for all your answers. I now know where the problem came from: Upgrade from 3.10.A -->3.70.A! Explanation: In 3.10, there was always one ledger entry per “entry”, regardless of serial numbers. In 3.70, there is one ledger entry per serial number. During the upgrade, ledger entries are split when there is qty > 1 AND serial numbers present on the line. But, applied entries to the (originally 1) entry remain to the original entry, and do not point to the newly created one(s). Which gives above mentioned result. Stupid Microsoft [V] Hopefully they will come up with a solution quickly!