Skip to main content
Solved

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


Forum|alt.badge.img

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

Best answer by psoni1585

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

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Author
  • Varsity I
  • 43 replies
  • Answer
  • April 5, 2023

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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • April 5, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings