Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Modifying date format ...
Microsoft Dynamics GP (Archived)

Modifying date format on a Payables management check (Dynamics GP 10)

(0) ShareShare
ReportReport
Posted on by Titan - Home 265

We have just started doing some work in Canada and are using Canadian vendors who require us to pay them in Canadian funds.  We have established a Canadian checking account and have installed the multi-curency module.  However, the Canadian banking system requires the date on the check  to be in a different format than our USD account.   The date used on the face of the check for our USD account is MM/DD/YYYY.  However GP does not zero fill on the left for months 1-9 and dates 1-9 ( so the dates could read 7/9/2011).  The Canadian system requires MMDDYYYY, with the zero fill on the left  for months 1-9 and days 1-9 , and does not allow / ( so a date would read 07092011).  Where can I go in GP to change the format for that date on the face of the check.

Also, if that is possible, can it be tagged to one bank account only so that our USD checks continue in the current format?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Modifying date format on a Payables management check (Dynamics GP 10)

    Hi, the absolute best option would be to start from scratch with the cheque layout. I say this from experience!

    The cheque layout is not hard to modify - there are not a lot of fields on it and the standard GP layouts (in terms of paper and section size etc) are written to match exactly standard cheque formats, or at least be very close.

    If you need help with this let me know.

    Ian.

  • Titan - Home Profile Picture
    Titan - Home 265 on at
    Re: Modifying date format on a Payables management check (Dynamics GP 10)

    We were able to make it work using option 4 .   One thing we did not bring up in our first inquiry was that we use a modified ‘Check with stub on top’, thinking that it would not matter when we introduced Multi-Currency.   When we did a TEST Canadian check using the modified check format  the number/amounts were  displayed with ‘$” in front of them i.e.$75.00.  We then did a test Canadian check using the un-modified ‘Check With Stub on Top’ format  and saw that it placed a “C$” in front of each amount.  This is what we would prefer to use so it is very clear what currency the check is in( we have some vendors that bill us in both USD and Canadian depending on the job.).  

    The check was modified many years ago to match up with the check stock and to accommodate some fields needed on the check stub.  Unfortunately it was modified by individuals not longer here so we do not know exactly what was done.  

    We have opened up the check layout in Report Writer hoping to see why  we are not getting the “C$” on our modified check.   We noticed that under Calculated Fields in the Layout Tab In the Toolbox there is ‘Currency index’ in the un-modified check version.  In our Modified check that is not there.  Could that be our issue?  We would test it but can not figure out how to add it in our modified version.  If that is the issue can you give us guidance on how to add it?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Modifying date format on a Payables management check (Dynamics GP 10)

    Hi,

    The short answer to your query is No, GP cannot handle this situation. You cannot set up GP so that each Checkbook ID has its own date format. All date formatting comes form your windows settings when you open GP.

    However, that is not to say there isn't stuff you can do to allow for this. It is very common in Europe - especially where users span Europe and the US.

    Your options are:

    1. If the US bank will accept them - Change your date format in Windows to include leading zero's. (This new date format will then apply throughout GP).

    2. Use a different cheque layout for your Canadian cheques and modify this to display leading zero's in the date.

    3. Create a calculated field on the cheque layout that returns the correct date format based on the Checkbook ID (Or maybe currency ID? i.e. If CURNCYID = CAN$ then....)

    4. Create two windows profiles - one with the US date format and one with the Canadian date format set up in Regopnal Settings in control panel. Depending on which cheques you are printing, use eithre profile to launch GP (GP will pick up the correct date format from the windows profile).

    Ian.

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