39
There is sometimes an issue in Dynamics NAV when you use a seperate number serie for unposted purchase/sales invoice/credit memo and a separate number serie for the posted documents.

If you try to post the invoice and you receives an error (mostly when you try to post document with obliged dimensions), then sometimes it is possible that NAV allready assigns a posted document number to the unposted invoice/credit memo. Afterwords the user deletes this invoice and this causes a gap in the posted number series.

So the COMMIT in codeunit 80 / 90 should be reviewed, so that a complete roll-back could be possible when an error is occured during the posting routine. The posted number series may never been raised if an error is occured.

It should be prevented that there are GAPS and it should also be prevented that NAV creates documents with text 'Deleted document'. Auditors/fiscal controllers does not like 'deleted documents'.
STATUS DETAILS
Under Review
Ideas Administrator

Thank you for your feedback. This is a great suggestion! We are considering it for our roadmap. 

 

Your help is greatly appreciated, 

Ivan Koletic

PM, Microsoft 


Comments

F

Many auditors does not like to have 'deleted documents' with text line 'deleted document'...
They think it is deleted because of fraud.

Category: Financial Management

F

Not sure…

In case that this is still by design, I think we need have a report / feature that show the gaps in the posted document numbers… with such report the user be aware that he/she need to delete something…

Category: Financial Management

F

some details about how repro:

BC 14.x RTM (on-prem)

1-Go to ‘Item Card’ (LS-81), set
- “Prevent Negative Inventory” = yes
2-Create new ‘Sales Invoice’
Header:
- Customer = 1000
Line:
- Item = LS-81
- Quantity = 1 // Answer Yes
Try to post, as result error:
“You have insufficient quantity of Item LS-81 on inventory.”
3-Check that in the document (unposted document) we could see “Posting No.” = 103032 ?!
4-Create new ‘Sales Invoice’
Header:
- Customer = 1000
Line:
- Item = LS-75
- Quantity = 2 // Answer Yes
Post
5-Go to ‘Posted Sales Invoice’, last 5 lines:
No.
103028
103029
103030
103031
103033

We could see a gap.

+
Additional info:
6-If now delete the document from step 2 then system create 'an empty document with the only text line "deleted document"' 103032 - as result no gap

Not sure that this help in scenario when we never delete

Category: Financial Management

F

In Belgium auditors do not like to see 'deleted documents'. Therefore we usually choose to set up unposted numbers to sales/purchase documents. When the document is posted, then we would like to receive a posted document number.

But this set-up does not work 100% correct. In case there is an error during posting routines (f.e. obligatory dimension is missing), we see also that the posted document number is allready linked to the unposted document. And when such a document is deleted, we receive a deleted document.

An other good solution could be that the application stores in an extended table linked to number series line, the deleted numbers. And when the application needs to have a new number that first re-uses the deleted number instead of taking a number out of the normal ranges.

Category: Financial Management

F

There should be no gap in the posted documents.
If there is no error in the posting routines, NAV/BC creates (in germany) an empty document with the only text line "deleted document"

Category: Financial Management