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 ProductSpindle Document Distribution
Ref NumberKBA-01-02-041
Document Date29-04-2021
Original AuthorMatthew Perry
Document Versionv1.0
Last updated
Update Author