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
Thank you for sharing your solution with the community
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(tDocument.CuryDetailTotal]), 10, '0')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.