Solved

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

  • 4 April 2023
  • 2 replies
  • 138 views
P
Rank
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
3 Attachments

2 replies

P
Rank
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')

 

Chris Hackett
Rank
Userlevel 7
Badge

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

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*.

Reply


Terms & ConditionsCookie settings
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