How to append 00 to bank account number in BAI2 bank statement import
Hi there, I need some assistance with a format or a suggestion to append "00" as leading values onto my bank statement import for the bank account number.
Assume the below:
1). Bank Account as: 009427729336>> 9427729336
Example statement file:
03,9427729336,USD/
..
16,275,000000000003789,Z,081304012000000,009427729328/
88,ZBA TRANSFER FROM 009427729328
16,475,000000000003789,Z,813006292539777,000000100221,/
..
Bank Account in Oracle is setup as 009427729336. When I am importing, what format can I specify to append 00 to 9427729336 so that it matches the bank account number in Cash Man.