Skip to main content
Solved

How to Remove blanks in Lines from Custom export scenario using ACH Provider

  • December 14, 2021
  • 2 replies
  • 267 views
luisrodriguez45
Freshman I

I have created an export scenario using ACH Provider for batch payments.

The file has 20 characters in the header and 382 for each pay line, therefore, in the line size property 382 was set, however, this causes the header to be filled with blank spaces which must be removed.

O1# is the Header

01#{H1_TypeOfReg:2}{H1_NumOfSec:7}{H1_Date:8}{H1_cons:3}

02#{R1_TypeOfReg_D:2}…

 

Best answer by ChandraM

Hi @luisrodriguez45  Pleas try using RTrim() function on the export scenario for the the 01# Header.

View original
Are your ready for rock ?
Did this topic help you find an answer to your question?

2 replies

C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • 716 replies
  • Answer
  • December 24, 2021

Hi @luisrodriguez45  Pleas try using RTrim() function on the export scenario for the the 01# Header.

Chandra M
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • 716 replies
  • December 24, 2021

Hi @luisrodriguez45  Please share the export scenario for any future support.

Chandra M

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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