Padleft formula in the custom ACH provider export scenario is not working

  • 4 April 2023
  • 2 replies

Userlevel 3


I have created a customized ACH provider export scenario for bank file and our client would like to add an additional zero to the T_batch_value field, making it a 10-digit value. I have attempted to use the PadLeft formula within the export scenario, but it has not produced the desired result.

For your reference, I have attached the data provider, export scenario, and schema files.


I would greatly appreciate any assistance in resolving this issue.





Best answer by psoni1585 5 April 2023, 05:04

View original

2 replies

Userlevel 3

Hi Guys,


I’ve made couple of changes in the the schema file under data provider and export scenario formula and now it’s working fine as per the requirement. 


1st Change:- Removed total from the batch value and added FillonEnd


2nd change :-  Used below formula in the export scenario.

=PadLeft(Provider.FormatAmount10([Document.CuryDetailTotal]), 10, '0')


Userlevel 7

Thank you for sharing your solution with the community @psoni1585 !


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