Dear D365 Business Central Community,

If you use two different number series for posted and unposted documents, and you create a sales invoice, get an error during the posting process, and then delete the unposted document, the system still behaves as if the document was posted, even though it was not - it fills the posting number with the number the posted invoice was supposed to get, and when you delete the document, a message appears that there is a posted invoice with the above number, creates and posts an empty posted document, which increases the number series unnecessarily.

We originally reported this as a bug, the support team replied that this is part of a core posting process that can't be changed, but a secondary ID can be created to store the required value in case the posting process fails, and that we can try to post it here.

Would it be possible to add a new field called "Original Posting No." to the Sales Header table (36)? When the invoice is created, it will be filled with the same value as the Posting No. If the posting fails, the Posting No. value will be overwritten with the value from the Original Posting No. 

Thank you for your consideration.