Skip to main content
Answer

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

  • December 14, 2021
  • 2 replies
  • 295 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.

Are your ready for rock ?

2 replies

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

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

Chandra M
Chris Hackett
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • December 24, 2021

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

Chandra M
Terms & ConditionsCookie settingsAccessibility statement
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