Skip to main content
Question

How to format Payment Amount in Positive Pay padded with zeros at left only, to create 10 total characters?

  • March 11, 2026
  • 1 reply
  • 15 views
Laura03
Captain II
Forum|alt.badge.img+20

Hello,

I’m trying to create Payment Amount in a Positive Pay CSV file padded on the left to include 11 total characters like this example:

 

I’ve tried several formulas:

=PadLeft(CStr([APPayment.OrigDocAmt]),10,'0')

=PadLeft(CStr([APPayment.OrigDocAmt]),10.2,'0')

=PadLeft(CStr(Round([APPayment.OrigDocAmt],2)),10,'0')
=PadLeft(CStr([APPayment.OrigDocAmt]),12,'0')

The above formulas produce results that are padded at the left but include 2 extra digits on the right.

I thought Acumatica might be using Price/Cost Decimal Places field in Miscellaneous Settings section of Companies screen to set Decimal Places to 4…. however when I temporarily changed this setting from 4 to 2, it made no difference in my Positive Pay GI. 

 

Thank you in advance for your help!

Laura

~ Laura Barber, WM Synergy

1 reply

bwhite49
Captain II
Forum|alt.badge.img+12
  • bwhite49
  • Captain II
  • March 13, 2026

Hi Laura,

I think this will do it.

=PADLEFT((LEFT([APPayment.OrigDocAmt], LEN([APPayment.OrigDocAmt])-5)),8,'0')+'.'+LEFT(RIGHT([APPayment.OrigDocAmt],4), 2)

    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