Hi All
I have a question regarding our sales invoices.
The problem is that apparently there is missing som invoices in NAV. We expect that the invoices numbers come in one after the other but as you can see frem the screenshot below there is one (Invoice no. 103119) missing and we havent deleted it so where is it?
Kind regards
Rasmus
*This post is locked for comments
Hello,
If you are using “Sales Invoices” (Rather than Sales Orders), there is another possible scenario related to the possibility of missing number in your Posted Sales Invoices.
In Sales & Receivables Setup, look at Numbering – if your “Invoice Nos.” and “Posted Invoice Nos.” are set to the same code, then if you enter a Sales Invoice and delete it (rather than post it) – it leaves a gap in the number series.
I’ve seen this setup used by customers who don’t want the number to change between when they created the Sales Invoice and when they posted the invoice (resulting in the Posted Sales Invoice)
Lauren
Hi Rasmus,
You should firstly check some posted invoices are deleted as Archer and Tharanga mentioned, or data is filtered on Posted Sales Invoices by system.
You can use Navigate page, filter for Document Nos and check them in related Entries such as Customer Ledger Entry, G/L Entry, ... Another way is open Sales Invoice Header table from Development Environment directly and search them.
If you have the access to NAV development environment then open the table 36 (Sales header) and check the column "Posting No." in the table and you will be able to find the 103119 in the "Posting No." column.
If you didn't delete it then it is still in the sales order list or sales invoice list.
What is that mean?
In NAV posting No. is assign to a invoice at the time posting. So what you saying is totally correct. Your posted sales invoice list should have the proper no series and it should not have any missing numbers.
However there is a one case this can be happen.
Think if you have posted your first invoice and it got the number 103118. Then you try to post your second invoice. So that NAV will assign a 103119 to your second invoice. Think this invoice gets a error at the time of posting. Then NAV will not reverse that assign No. and it will keep it as a posting No.
So since these is a error you skip the second one and post the third invoice. Nav will assign 103120 to your third invoice becasue NAV never reverse the no. series.
So what will happen to 103119 ? Nothing to worry about. When you correct that error and post it, It will post as the 103119 and you will not find any sequence error in your posting series.
As a solution check is there any invoice without posting. :)
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
