Navision 3.70 - skipped # in posted invoice sequence

orbitalsalmon

Came across a strange thing this week regarding a skipped invoice # when sales orders are posted.

Basically, the posted invoice # sequence is fine one day, then we find a skipped # the next day. We double checked our sales test reports w/ the invoices in the system between previous and present days and everything is there. Seems it is solely a sequence issue.

This also happened one other time, over a year ago.

We've also noticed a pattern as to when it happens (this being the 2nd time), the skip seems to occur at the beginning of the day, perhaps on the 1st order that is posted for that day.

Any ideas why this happens?

(Navision 3.70 on native DB)

TheDoubleH

I have seen this happen once in a while.

When Navision posts a document, it actually sets a field on the Sales Header "Posting No." and/or "Pre-assigned No.".

I think, you have a sales header, that got the number assigned, but then hit an error. A commit is being made after the number has been assigned, but before actually posting.

kine

In this case, check all orders and sales invoices (not posted) if you find some with this field assigned. It seems as Henrik wrote, that you have some document which wasn't posted because some error.

ara3n

And if you try to delete the sales order, it will create the missing invoice no, with just one line stating it was deleted or canceled I believe.

Miklos_Hollender

It can happen if people try to invoice and order, there is some error, but the number is stuck there, and then later invoice it rather by invoice / get shipment lines.

Solution: decide whether you will invoice by order or by invoice / get shipment lines, and disable the other. (Only if it's important to have no gaps in # of course. Here it is a strict legal requirement.)