etext template is not padding according to the template definition for trailer record
I am using a FIXED_POSITION_BASED etext template to produce a positive pay file from Payables. We are passing amount fields in the both the detail and trailer records. The amount fields cannot show any decimals.
The amount field on the detail record is defined as:
Length=10
Format=Number
Pad= R, ‘0’
Data=ROUND ((PaymentAmount/Value *100),2)
Description=Amount. Position 35-44; Format ($$$$$$$$cc). Right-justified, zero-filled, numeric
This is a sample of the detail record produced from the etext template.
20413480000703120000000000000003201458612000ZELLER 800 LASALLE AVENUE LLC --> Amount = 1458612000
The corresponding XML shows the following:
-<PaymentAmount><Value>14586.12</Value>
The amount field on the trailer record is defined as: