Introduction
When attempting to generate a PayThem button on a document, you may see an exception similar to the one below appear in the processor log when it fails:
This is due to the formatting of the value, in which only one decimal place will be picked up by the ## commands.
Applies to
- Spindle Document Distribution
- Spindle Document Management
Resolution
In the expression containing the ##AMOUNT## command on the Sage 50/Sage 200 report layout, please format it to match the one below (With InsertValueHere being the value originally used for the amount:
"##AMOUNT" +FormatString("{0:N2}",Sum(InsertValueHere)) + "##"
This will format the value to two decimal points (so an amount of 128.6 will become 128.60).
KBA Details
Related Product | Spindle Document Distribution |
Ref Number | KBA-01-02-041 |
Document Date | 29-04-2021 |
Original Author | Matthew Perry |
Document Version | v1.0 |
Last updated | |
Update Author |