Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Add Due Date field to ...
Small and medium business | Business Central, N...
Suggested answer

Add Due Date field to customer invoices

(0) ShareShare
ReportReport
Posted on by McCluresPickles-Bob 10

Hi, I'm trying to find a way to add a DUE DATE header under my Invoice Date header on customer invoices.  I know how to edit the template but do not know what header code I need to add to have the document reference back to the sales order due date.  When I go to Page Inspection I can see it is Field 24

4188.Screen-Shot-2023_2D00_02_2D00_06-at-2.16.19-PM.png

How do I get that field information into my invoice template so that each time an invoice is created it will reference back to the Due Date field on the posted Sales Invoice?

7713.Screen-Shot-2023_2D00_02_2D00_06-at-2.05.36-PM.png

Thanks!

Bob

Categories:
Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Add Due Date field to customer invoices

    Hi, the ID you provided is the Layout ID, not the Report ID.
    But it doesn't matter, if it is not found in the Dataset, you need to add it using the method I provided above.

    Thanks

    ZHU

  • McCluresPickles-Bob Profile Picture
    McCluresPickles-Bob 10 on at
    RE: Add Due Date field to customer invoices

    Thank you both - thee Report ID is: 23019012 Sales - Invoice (Word) and I do not see an RDLC dataset option that I could edit.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Add Due Date field to customer invoices

    Hi,

    As suggested by Zhu, please find the correct Report, and try to find if the filed is not there already in the RDLC dataset, then you have to extend that report, otherwise add that field directly from RDLC dataset in the layout.

    Thanks.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Add Due Date field to customer invoices

    Hi, What is the Report ID of customer invoices?

    If you refer to Standard Sales - Invoice (1306, Report Request), please refer to the following practice.

    pastedimage1675729755763v1.png

    pastedimage1675730021643v2.png

    More details: https://yzhums.com/10723/

    Hope this helps.

    Thanks.

    ZHU

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Add Due Date field to customer invoices

    Hi Bob,

    Your screenshots indicate you are using Business Central; not Supply Chain Management. I have moved your question to the correct forum.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans