Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?

(0) ShareShare
ReportReport
Posted on by 2,432

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!

pastedimage1673991976845v1.png

  • Suggested answer
    Syed Sahabuddin Profile Picture
    Syed Sahabuddin 2 on at
    SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?
    Solution:
    1. Go to Accounts Receivable module.
    2. Open the Setup.
    3. Go to the settlement tab.
    4. Select this option and click enabled.
     
    Go to Customer Transactions
     
     
    Thanks
    Syed Sahabuddin
  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?

    Hi Kim J,

    Hope the issue is solved by now.

    Appreciate if you kindly mark this thread if answered.

    Regards,
    Sourav

  • lmai Profile Picture
    lmai 2,432 on at
    RE: SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?

    Thanks, Sourav, for taking the time to share your knowledge.  I appreciated.  

  • lmai Profile Picture
    lmai 2,432 on at
    RE: SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?

    Thank, Andre', for your feedback.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?

    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.

    pastedimage1674015394224v1.png

    4. Once done, then select the SO invoice posting date. Here I have selected 20/01/2023.

    And post the invoice.

    pastedimage1674015483081v2.png

    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.

    pastedimage1674015657087v3.png

    pastedimage1674015693925v4.png

    Regards,
    Sourav

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,979 Super User 2025 Season 1 on at
    RE: SO invoice date is default at the point of invoice. After the invoices are posted, is there a way to edit the invoice dates without having to reverse so many sales orders?

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans