Skip to main content
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... / A/P Check Date Format ...
Small and medium business | Business Central, N...
Answered

A/P Check Date Format on Report ID 10411

(0) ShareShare
ReportReport
Posted on by john.ellis 3,494

Hi:

I'm modifying the A/P check layout of Report ID 10411 for check in the middle with stub on top and bottom.

I need the dates on the stubs and the check to be mm/dd/yyyy.

So, in Report Builder I modified properties of the text boxes to reflect this.

That did not work, because the date still prints as September 30, 2022 instead of 09/30/2022.

Next, I went into the Bank Account Card and changed the two fields for check date format and check date separator to reflect mm/dd/yyyy.

Still, no joy.

How do I change the format of the date, then?

Thanks!

John

  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,547 on at
    RE: A/P Check Data Format on Report ID 10411

    Hi,

    Adding information.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-format-property

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,571 Moderator on at
    RE: A/P Check Data Format on Report ID 10411

    Hi,

    Your welcome.

    Yes choose Config. package to update the field for all master records, or Edit in excel or Create a custom report to update the records.

    Thanks.

  • john.ellis Profile Picture
    john.ellis 3,494 on at
    RE: A/P Check Data Format on Report ID 10411

    Hi Nitin:

    Yes, changing the fields in the vendor card proved successful.  Thank you, Sir!

    I have never had the need to select these fields in a vendor card, before.

    Will this change need to be conducted for each vendor one by one, or is there a way of doing so for all vendors at once?

    Thanks!

    John

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,571 Moderator on at
    RE: A/P Check Data Format on Report ID 10411

    Hi,

    Please refer to the Bank Account card's field for Check date format and separator, reset the text field. and then check if success.

    We also have those fields in customer card, please check there too.

    pastedimage1664707521920v1.png

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans