Hi All,
When a Sales order is invoiced, D365 would populate the invoice date automatically. It will pick up the date you invoice as the invoice date. Since the actual invoice date is another dates, not the date the system defaulted, is there a way to populate the correct invoice dates by writing a code or using a template. Export these SO invoices, edit the invoice dates and populate it back into D365? I don't want to have reverse so many SO. Then invoice them as negative, then push in another batch of Sales orders. It is so much work. Is there any work around for editing invoice date? If so, what is the disadvantage/future consequences for doing that? For our SOs, we don't do pick/pack. Just SO confirmation then go straight to SO invoice. So, I don't see any issue? Does anyone have any advice for me to edit the invoice dates? Thanks so much!
Hi Kim J,
Hope the issue is solved by now.
Appreciate if you kindly mark this thread if answered.
Regards,
Sourav
Thanks, Sourav, for taking the time to share your knowledge. I appreciated.
Thank, Andre', for your feedback.
Hi Kim Johnson,
System will not allow to update in posted document.
Also this is not recommended try to update anything from backend because of below reasons.
- When a transaction is posted; it records in backend Table with a date and time stamp.
- When date and time stamp is updated in Table, you officially acknowledge the accounting impact in your books of accounts for future audit purpose.
- When a transaction is recorded in backend Table, it not only updates your journal but a lot other areas in the system impacts. The main and subledger accounts, the interim accounts, posting types, posting layers, number sequences and so on..
Steps to follow:-
1. Reverse the posted SO invoice if you want to update the actual invoice date. Make sure you reverse the posted product receipt also in case of stocked items.
2. Create new SO with same detail.
3. Now at the time of posting the invoice, you can personalize and add this column "Date of update (Invoice date)" in the Posing invoice form, if by default this is not available here.
4. Once done, then select the SO invoice posting date. Here I have selected 20/01/2023.
And post the invoice.
5. Now check in voucher. You will find the SO invoice date (which is the actual invoice date you wanted to post in) you posted.
Regards,
Sourav
Hi Kim,
There is no option to change the invoice date after posting. This is not allowed by accounting rules. What is the exact cause that you need to reverse too many orders?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156