Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Linking Invoice Receiv...
Small and medium business | Business Central, N...
Suggested answer

Linking Invoice Received Date to Due Date

(1) ShareShare
ReportReport
Posted on by JG-25091601-0 22
Hi there!  
Trying to get the Invoice Received Date field to auto default Due Date based on Vendor Lead times, however having difficulty.  Currently the document date is auto defaulting the Due Date.  I am trying to keep the Document date as the original order/PO date, however, because the document date is what updates the due date, I have to overwrite the document date to be the date my invoice was received.  I can't get the invoice Received Date field to drive the due date.  Any suggestions?
 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 79,097 Super User 2025 Season 1 on at
    Linking Invoice Received Date to Due Date
    Just addings some info:
    Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,799 Super User 2025 Season 1 on at
    Linking Invoice Received Date to Due Date
    The Order date field is there, its just not added to the posted purchase invoice page and its not available to add when you personalize your screen. But if you customize the profile you're using, you can add it to the page.
     
     
  • JG-25091601-0 Profile Picture
    JG-25091601-0 22 on at
    Linking Invoice Received Date to Due Date
    Thank you Valentin. 
     
    That would work except once you post a sales order or Purchase order, it is not visible on the document.  I need the original order date visible in BC on the posted invoice.  Suggestions?
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,799 Super User 2025 Season 1 on at
    Linking Invoice Received Date to Due Date
    That's how the system functions out of the box, there's no connection between the invoice receive date and the due date. By default:
     
    • The Document Date is automatically populated with the work date when you create a new document, and you can manually change it after
    • The Due Date is calculated as the document date + the payment terms (i.e. if the payment terms were net30 your due date would be the document date + 30 days)
    • The Invoice Receive Date is blank by default, and you can manually populate it. 
     
     I am trying to keep the Document date as the original order/PO date, 
    It sounds like it would be better if you used the Order Date field for this instead of using the Document Date. Then you can use the Document Date as the date the invoice was received. 
     

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans