When we run the Bank Statement loader the check number goes to another column not in Bank Trx Number column.
So the problem with mappings. so Create new mapping as same as SWIFT940 name as SWIFT940NEW
then
in that old mapping for bank_trx_number rec_id_no is 61A and position is 1
customer_text rec_id_no is 61 and position is 7.
So i changed rec_id_no fro bank trx number is 61 and position is 7
rec_id_no is nulll for customer_text and position is also null.
So now when we run bank loader cp check number is stored in correct column .ie. number column.
So the problem with mappings. so Create new mapping as same as SWIFT940 name as SWIFT940NEW
then
in that old mapping for bank_trx_number rec_id_no is 61A and position is 1
customer_text rec_id_no is 61 and position is 7.
So i changed rec_id_no fro bank trx number is 61 and position is 7
rec_id_no is nulll for customer_text and position is also null.
So now when we run bank loader cp check number is stored in correct column .ie. number column.
No comments:
Post a Comment