Tuesday, November 11, 2014

Dynamics GP - Check to Words shows extra 0's for cents. Check to Words is too long and is truncated at 80 characters.

Issue:
Payables check prints incorrect cents
If your currency has more than 2 decimal places, and you print checks, the check to Words function that prints the check amount in words on the check prints the cents with all of the zeroes for the number of decimal places the currency is set to.

Example. - 5 DP currency prints as

100.20 shows as One Hundred Dollars And 20000 Cents

Solution:

  • Open PSTL
  • Look under Misc Tools
  • Look for Decimal Place Tool
  • Tick the Box next to the Blue Tick (It will be a Red Tick after you tick it)


This will force the Check to Words to only display 2 decimal places in the description.

Original Solution
http://support.microsoft.com/kb/961423

However, this field is not on the cheque by default, you must add the "Amount in words" field from PM Payment work.
However, the "Amount in Words" field will throw an error if you use it directly.
Ignore it completely and instead, use the STRING A 255 Field. It will show the correct information once the PSTL tool has been installed.

If you want to wrap the field, you must use two (or more) calculated fields using the rw_parsestring function to split the string.
Then rw_parsestring against that calculated string.

  • CalcLine1 = RW_ParseString(Pmt_Work.STRING A 255 50  1)
  • CalcLine2 = RW_ParseString(Pmt_Work.STRING A 255 50  2)
OR you can use substring

  • CalcLine1 = RW_SubString(Pmt_Work.STRING A 255 1  60)
  • CalcLine2 = RW_SubString(Pmt_Work.STRING A 255 61  60)

No comments:

Post a Comment