web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics GP (Archived) / Canadian Date format C...
Microsoft Dynamics GP (Archived)

Canadian Date format Cheque CPA

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

I know that I have seen this somewhere, but now that I need it I can not find it anywhere.

We all know that the date format comes from Windows Language and Time formats and that is the default that GP uses when it is showing a date on reports.

While this is nice for all the reports and documents that are generated, however, in Canada we are being (have been) forced by the CPA to format the cheque date in a specific fashion to make is better for OCR capture.

In the Canadian Payroll there is a Script that has been created that formats the date as required, and that is great, however, I am being requested by more and more clients to provide that same (some say correct) formation of the date for Invoices and Payable  cheques.

Has anyone got a solution?

The format of the date for the Canadian payroll cheque is shown and printed as

Y Y Y Y M M D D with the same text field shown below.

It appears that we can format the date in any fashion desired, as long as the text below tells the OCR what it is looking at.

There are spaces between each number in the format and I have tried to apply a filter in RW but that does not seem to work.

Thanks,

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Bill,

    You're still printing cheques :-) ?... jokes apart, are you looking for this thread :

    community.dynamics.com/.../32842

    David Musgrave refers here to one of his blog entries about date formating in RW, and than there is also this one from him :

    community.dynamics.com/.../displaying-dates-in-any-format-on-reports

    Hope this helps

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Just getting the client up and operational on GP2015 and taking baby steps - we will have them on EFT sooner than later, but in the mean time they seem to be hung up on the date format of the cheque

    They want to see the CHEQUE Data as

    Y Y Y Y M M D D

    so on the face of the cheque it looks like

    2 0 1 6 0 1 2 1

    I have found a function on the Report Writer for REPORTS.dic but there is not the same Script on the Canadian Payroll R7131.dic

    That is where I am stumped.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Do you have a way to publish here the code that is used to format the report in the R7131.dic ? What's the exact name of the report (technical name) ? I might be able to look into it myself, as we have the CPY setup too...

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Ok, now that makes sense.  I was being very literally with the Musgrave Blog and when I was looking for Functions I was looking only under the System Series.  

    As soon as I look under the User Defined Functions and change the CORE to PROJECT I am able to find the script - RW_P_ChequeDateCPA - once I put that onto a calculated field and add the P_CPY_Cheques_Work.P_Cheque_Date - I get the right format of the date - 0 1 1 6 2 0 1 6

    Tanks for the pointers and direction.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Jumped the gun.

    So the RW is a tool that is very dictionary focused and it appears that SCRIPTS are not available from one dictionary to another.

    In the R7131.dic - Canadian Payroll - there is a user defined function - RW_P_ChequeDateCPA

    However, in the REPORTS.dic - System - there is no such user defined function

    Can anyone tell me that there is a way to move scripts from one dictionary to another?

    I want / need to have the Date format of the Cheque in Payables look like the date format used on the Payroll Cheque.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Bill,

    I guess the one that could answer this is David Musgrave himself... he's probably well placed to know it. Unfortunately he was on vacation  for the past weeks. He just came back, but not sure he'll pull his Surface Book right away to check the forums :-).. will try to get hold of him.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Thanks Beat - Hey David, got on line I need your help . . . huh, not answering -

    sorry way to much coffee.

    Thanks Beat.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    Hi Bill and Beat

    Sorry for the delay, but I have been relaxing in Sydney and then on a cruise from Australia around New Zealand.

    Now I have to come back to reality and it hurts. :-)

    Anyhow the bit that you are missing is covered in a KB article I wrote many moons ago.

    How to use Customization Maintenance packages to enable Great Plains Report Writer functions from a 3rd party report dictionary

    https://support.microsoft.com/kb/862665

    Good luck

    David

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    David, sorry you are back to work – darn that work getting in the way of ‘family and fun’

    So, reading over the KB  I am troubled in that I don’t get how the Function that I know is in the Canadian Payroll (R7131.dic) but not in REPORTS.dic

    In the R7131 there is a function that formats the date as we need.

    What I am reading here, I would export into package the report where I want the R7131 function to be used.  By editing the package in NOTEPAD and using the proper name as it is found in the R7131.dic it will move that function or use that function without moving it to the REPORTS.dic.

    Hope I got this right – it sort of makes sense if you suspend the fact that the function does not appear to move – other than by reference in the new dictionary.

    But you are the one that would know – I am still learning after 20 years at the GP racket.

    Thanks in advance and welcome back to the land of the working – even though you are down under.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Bill,

    Yes you read that right.. I remember having played in the past with the XML format of exported packages when I was playing with VBA code in reports...  though I never imagined that you could just swap / copy functions from one report to the other... but this looks definitly the quickest way to get one customization from a dictionary to another.

    Thanks David for bringing this back up in the light.

    EDIT: Ok ... so this actually doesn't work from another dictionary then 0... (i.e. REPORTS.DIC)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans