Cheque format

[Janice]

Hi,

I use GP 9 and I have just changed the cheque date to comply with the
Canadian Payments Association format of YYY MM DD using the information from
the Microsoft knowledgebase. The font type and size in the body of the cheque
has changed and I am now getting dingbats (**) before Dollar and cents and
more dingbats (**) where the total amount of the cheque used to be in
numerical form. This is what I would like to fix: 1) Font back to Arial size
9 or 10 2) no
dingbats on cheque 3) date in correct format

Thanks.

[Don]

Hi Janice,

I have a document that explains how to do this modification please email me
at ***@hotmail.com and I will send it to you.

Thanks

Post by Janice
Hi,
I use GP 9 and I have just changed the cheque date to comply with the
Canadian Payments Association format of YYY MM DD using the information from
the Microsoft knowledgebase. The font type and size in the body of the cheque
has changed and I am now getting dingbats (**) before Dollar and cents and
more dingbats (**) where the total amount of the cheque used to be in
numerical form. This is what I would like to fix: 1) Font back to Arial size
9 or 10 2) no
dingbats on cheque 3) date in correct format
Thanks.
--
Janice

[David Musgrave [MSFT]]

You can use the RW_DateToString() Report Writer function I wrote in a
calculated field, use a format string of "YYYY MM DD" and it will output the
exact results.

in date IN_Date;
in string IN_Format;

{
Format Syntax:-
ddd = day of week as 3 letters
dddd = day of week in full
N = day of year
NN = day of year (padded)
D = day of month
DD = day of month (padded)
M = month of year
MM = month of year (padded)
mmm = month of year as 3 letters
mmmm = month of year in full
YY = year of date (2 digits)
YYYY = year of date (4 digits)
}

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:***@online.microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by Don
Hi Janice,
I have a document that explains how to do this modification please email me
Thanks

Post by Janice
Hi,
I use GP 9 and I have just changed the cheque date to comply with the
Canadian Payments Association format of YYY MM DD using the information from
the Microsoft knowledgebase. The font type and size in the body of the cheque
has changed and I am now getting dingbats (**) before Dollar and cents and
more dingbats (**) where the total amount of the cheque used to be in
numerical form. This is what I would like to fix: 1) Font back to Arial size
9 or 10 2) no
dingbats on cheque 3) date in correct format
Thanks.
--
Janice

[Leslie Vail]

Is there some reason this cannot be done with Report Writer?