KBA-01-02-041 - Setting the ##AMOUNT## value to two decimal places

Modified on Wed, 6 Dec, 2023 at 11:06 AM

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)) + "##"
HTML


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


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article