Skip to Content
0
Former Member
Jan 18, 2012 at 08:52 PM

Lock Box File issue

557 Views

I in the process of trying to test the lockbox upload and I was hoping someone could help me on this file issue.

the bank is providing the file as below for the "6" and the "4" record

620000100000480351220002470375406600000000014936CONCISYS INCORPORATE20111026

42000016019 901293890 0000048035

my issue is I cannot get SAP to match the invoice number becuase of the spaces. If I remove the spaces from the fil SAP will l match the invoice and clear the invoice. The bank is giving me the file in a Fixed Length format.

I have also tried the file this way

620300100000455000759116030755701208000000279048SIGNICAST 20120117

4203001601900000018000606470000045500

sap does not like the extra "0" in the fields.

I am indicating the file is a BAI2.

Any insight would help.