Unique External Document No. for Sales Invoices in NAV 2009

Business Central/NAV Developers Forum
1

Dear All

We are trying to import sales invoice data through a manual process for a temporary period. We are concerned that when we post invoices we have created from the imports, duplicates in Pre-Assigned Number and/or Ext Doc number can be made, and therefore, very prone to human error through our manual import process.

Ideally, we would like External Document Number to be unique, and flag if duplicates occur to the user when posting. I took a quick look at the Sales Header field to see if we could make this an indexed/key field, and saw no simple switch in the properties.

Any help would be much appreciated.

Best,

Doug

2

You should ask your solution center put this check in the Posting or Journal Check codeunit. This is 5 lines of code and will be fast. But based on the experience you should think about future… Many customers start repeating extermal document no. every year or time to time and you will have repeating numbers.