Skip to main content
Answer

How to configure the amount on the check form with remittance

  • March 6, 2025
  • 2 replies
  • 52 views
A
Jr Varsity II

I have this formula that allows me to see the amount of the check like this

= IIF([APPayment.ExtRefNbr]<>[APPrintCheckDetailWithAdjdDoc.StubNbr],

'** VOID **',

PadRight(UCASE(LEFT([APPayment.AmountToWords], 1)) + LCASE(SUBSTRING(replace(replace([APPayment.AmountToWords], '  ', ' '), ' Only', ' and Cents') ,1 , LEN([APPayment.AmountToWords]) - 1  )) , 60, '*' ))

 

But I would like it to be presented in some way as Two Thousand Two Hundred Twenty Three And 00 Cents, what changes do I have to do on the formula?

Best answer by alejandradiaz68

I have fixit with the next formula

 

replace(replace(replace([APPayment.AmountToWords], ' and ', ' And '), ' Only', 'And 00 Cents'), '/100','Cents')

2 replies

A
Jr Varsity II
  • alejandradiaz68
  • Author
  • Jr Varsity II
  • Answer
  • March 6, 2025

I have fixit with the next formula

 

replace(replace(replace([APPayment.AmountToWords], ' and ', ' And '), ' Only', 'And 00 Cents'), '/100','Cents')

Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • March 7, 2025

Thank you for sharing your solution with the community ​@alejandradiaz68!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved