Posted sales invoices missing invoice

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

RE: Posted sales invoices missing invoice

view page "Customer Ledger Entries" and check if there are entries for the missing invoice no. (document no.). if there are entries, then the posted sales invoice was deleted.

follow

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Posted sales invoices missing invoice

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. :)

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Posted sales invoices missing invoice

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.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

RE: Posted sales invoices missing invoice

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Posted sales invoices missing invoice

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

Was this reply helpful? Yes No