I had this message pop up when using the “Navigate” function on a cash receipt in Business Central when i wanted to view the related GL entries.
In this instance the message does a really good job of explaining the issue. The same document number and posting date have been used on more than one transaction, however coming from a Dynamics GP background I was curious as to how this had happened.
In Dynamics GP you can generally use the same document number for different document types however you can’t use the same document number for the same document type.
I suspect its possible in Dynamics NAV \ Business Central because the index keys on the tables in the background don’t prevent it however I was curious to recreate it myself.
Therefore to recreate you simply add multiple cash receipts (it could be other types of transactions but I’m using cash receipts as an example) to a batch and give them all the same Document Number. As you can see below I’ve given a cash receipt the same document number for different customers.
After posting them go to “Customer Ledger Entries” and highlight one of the entries and click “Actions > Navigate” as per below
You are then presented with the message “This combination of document number and posting date has been used more than once.”
Where its gets confusing is you can now see double the number of entries
Also, if I drill down on the GL entries I see the entries for both of the documents
I must stress this isn’t wrong, its just different than what I’m used to. I’d also personally try and prevent this by recommending users always use unique document numbers per transaction.
Thanks for reading.