Solved

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

  • 4 April 2023
  • 2 replies
  • 139 views

Userlevel 3
Badge

Hi,

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.

 

Thanks, 

Pankaj

icon

Best answer by psoni1585 5 April 2023, 05:04

View original

2 replies

Userlevel 3
Badge

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
Badge

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

Reply


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