Bank statement not getting uploaded in Interface
Hi,
We are using bank statement mapping template similar to Standard, only difference is date format change. After running the Bank Statement Loader program with Load as option, Exception report shows no exceptions found in output but still the bank statement is not found generated in Interface.
Following is the maaping details in Mapping template:
Column Name | Rec Id | Position |
STATEMENT_NUMBER | 28 | 1 |
BANK_ACCOUNT_NUM | 25 | 1 |
STATEMENT_DATE | 62 | 3 |
CONTROL_BEGIN_BALANCE | 60 | 5 |
CONTROL_END_BALANCE | 62 | 5 |
CURRENCY_CODE | 60 | 4 |
TRX_DATE | 61 | 1 |
TRX_CODE | 61 | 6 |
AMOUNT | 61 | 5 |
TRX_TEXT | 61A | 1 |
BANK_TRX_NUMBER | 61A | 1 |
CUSTOMER_TEXT | 61 | 7 |
BANK_ACCOUNT_TEXT | 61 | 8 |
date format :
|
Bank File format Type SWIFT940