Uncompleted Sales Invoice Posting Process

kulwant wrote:

Is there any Customisation ??

i bet yes!
if you're sure that the invoice posting really went wrong, you have two options:
1(safe option): restore the more recent backup, if possible
2(be careful): you have to delete all the wrong entries in all tables (from posted sales invoice to gl register, gl entries, vat entries, cust ledg entries etc), be sure to also clean the necessary fields on the posted shipment in order to be able to reissue the same invoice.

for the second option, you need to be aware of what you do, and know NAV "like your brother", so to say.
There are so many tables involved in the posting process, that a single forgotten table can screw up the system. (if you have to sequentialize the posted invoice nos. by date the problem gets bigger, but not all localizations have to)
well, good luck, and again
Be sure that the invoice posting really went wrong!
EDIT: a description of the error would be really helpful, but i think you don't know it because the user didn't read it ](*,)

ria wrote:

On this table there is a modification, but our technical sure that the modification doesn't change the standard posting process.
And error like this, never happen before, and just the only one
If delete the table i'm not sure, because system was created the value entry that contains cost amount, it's really risk i think.

Do you know, does run from remote desktop can make uncompleted posting like that?

this never happened to our customers which run nav on remote (the system should roll back even if the network fails)...anyway, my guess is that someonene put some additional commit to the standard posting process, that is fired in some particular cases...maybe after writing one of the ledger tables.
As i said, the second solution is very risky, and i wrote it just because it is possible to do it, by an advanced nav developer. That said, i wouldn't be 100% sure to do a "hack" like this without the support of a functional person, too. :whistle:

ria wrote:

Ah, i can't make a posting credit memo, because customer ledger entry, g/l entries, item ledger entries, and other not created on the invoice, invoice just created the posted invoice document, and the value entries. If i make a credit memo, there is a new unbalance entries.

then, there's probably a "new" commit after the insertion of value entries

Obviously one or all of the remaining 6 lines created the error which the user did not read. Just create a new invoice, use Get Shipment Lines. You should now see the 6 uninvoiced lines. Mark them and say ok. NAV should produce the error which the user ignored. Fix the error.

To find out which 6 lines have not been invoiced: Run Form 516, filter for Type Order and Shipped, Not invoiced <> 0.

ria wrote:

Ah, i can't make a posting credit memo, because customer ledger entry, g/l entries, item ledger entries, and other not created on the invoice, invoice just created the posted invoice document, and the value entries. If i make a credit memo, there is a new unbalance entries.

:shock:
Get the people in immediately which have done the modification. Obviously something is very wrong about it. As Mirko said probably a commit somewhere where it should not be.

To test things: Make a backup of your DB and restore it somewhere so that you can try how to fix this without doing it in the live system.