Item Ledger Entry XXXX Already Exists Error

davisj
davisj Member Posts: 38
edited 2004-05-06 in Navision Financials
We are running Navision 2.6F database and clients in a manufacturing environment and recently had some modifications made to two consumption posting programs by our Solution Center. After these modifications went into production we started to receive "already exists errors" in the posting of item ledger entries. The error messages are "Item Application Entry Entry No. 1234567 Already Exists" and "Item Ledger Entry Entry No. 1234567 Already Exist". Our Solution Center is working on the problem but we wanted to know if anyone had information about how best to research and solve this issue. The basic concept or assumption is that one Navision client is getting the sequence number for the Item Ledger Entry No. (Key) and this Key is not getting updated before another client is getting the same number. Is there something special that has to be set in the form or some variable that has to be set so the act of acquiring the sequence number for the Key will bump the sequence immediately preventing the next client from getting the same sequence number and thus giving the "already exists error"?

We have been working with our Solution Center for 2 days now and any help/thoughts would be greatly appreciated.

Comments

  • RobertMo
    RobertMo Member Posts: 484
    Obviuouslly the posting routines have been changed with some unexpected consequences. One should not change posting routines unless knowing exactly what he is doing or at least not without heavy testing.
    I believe that your NSC is experienced enough to find bugs and solve them.
    A hint. If this happens only when two or more clients are posting at the same time, then maybe locking of proper tables before getting last record should be checked.
    And it has nothing to do with some settings on form or vars...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • lakshmivalluru
    lakshmivalluru Member Posts: 168
    Hi,

    There is only one area you can check that is code. Check the chages you have doen to posting. If you have written a code to create item ledger entry or item application entry then you might not have incremented the Entry no porperly. Chances are you might be using same variable in increment entry No in existing code as well as the new code written by the your developers.

    Let us know if you have sorted the problem.
    LR

Categories