Because LineNo = 0 only while you move to new line and haven’t entered anything yet in any column. As soon as you start filling in the data, LineNo is set to “normal” current value (most often a multiple of 10’000).
Even if you already have some lines completed and focus is on next empty line – for which the LineNo = 0 – when you try to post, Navision ignores that empty line and posting goes on…
This error is probably form the GetReceivedLines function. do you receive goods tot he Purchase order, and then consolidate the lines onto one big invoice and post there? If so that is where to look. Maybe he did the get lines function twice.
It is a new issue that we havent had before and only occurs on this PO. We only invoice what the vendor gives us an invoice for at a time, so we consolidate receipts and then invoice multiples.
My purchaser has notified me that they were able to invoice 3 out of 4 of those lines individually.
And yes that is the exact wording of the error which is why I am a bit confused.
It is not possible and i strongly recommend not to interfere any data in the posted transaction. Its better to use reversal features like credit memo for making corrections.
The thing to do here is to resolve the issue, find out why it happened and make sure it doesn’t happen again. Hacking the database is never an alternative to user training.
Dan if you are not able to diagnose this (and its a very common user error) then get your partner in to show you what went wrong, otherwise you could cause serious damage to your system.