on 10-30-2014 12:43 PM
Hello everybody,
I am processing an Electronic Bank Statement, with Bank format BACS, using the program RFEBGB00. I need to post some transactions to GL Accounts other than the ones defined in the Global Settings for EBS config. These transactions are identified by specific character strings within the Narrative field of the EBS record. How can I make this happen?
Example:
Execute RFEBGB00 program with screen fields entered as follows:
Import Data Tick
Bank format BACS
Transaction file C:\bankfile.txt
PC upload Tick
Post immediately Select
Session names 1
Assign value date Tick
Execute as background job Tick
Print bank statement Tick
Print transaction total Tick
Processing errors Tick
Processing mismatchs Tick
Print posting log Tick
Print statistics Tick
Contents of EBS – Data records (transaction file c:\bankfile.txt):
1234568765432100300000000000000000000405000000L1-OP GENERAL ACEBANKGO1234567814171
6543211234567800300000000000000000000025000000L2NDONWESTEND2EBANKGO8765432114171
Record layout is:
Cc 1 – 6 Branch Sort Code
Cc 7 – 14 Branch Account Number
Cc 15 Type of Account Code
Cc 16 – 17 Transaction Code
Cc 18 – 23 Originator’s Sort Code
Cc 24 – 31 Originator’s Account Number
Cc 32 – 35 Originator’s Reference
Cc 36 – 46 Amount
Cc 47 – 100 Narrative
Includes:
Cc 47 – 64 Originator’s Name / Transaction Description
Cc 65 – 82 Reference Number
Cc 83 – 100 Unused
Cc 101 – 106 Date
Global Settings for Electronic Bank Statement:
Sort Code 123456 }
Bank Account 87654321 } maps to GL Account 12345
Transaction Code 03 }
This is configured in Global Settings for EBS and the postings work ok.
However if the Narrative field of an EBS transaction record begins ‘BACS SAP’ I want to change the mapping to GL Account 54321. How can I change the config to enable this to happen?
I would be grateful if anybody could provide an answer to my question.
Thank you.
billph117
H Bill,
Could you please provide the layout of BACS statement.
I am struck in this.
Please help.
Thanks in advance
Regards,
sophia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The above will happen through respective configuration in OT83. IF there are any specific strings then configuration is required in OTPM with respective account modifier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
as you point out the GL accounts are configured via the EBS settings. There are transaction codes and posting rules linked to account symbols which are linked to GL accounts.
That is the way to configure the GL accounts.
If you have an exceptional rule - you will need some code, and I would suggest a new transaction type - and the code amends the external transaction type of the line to the new one to enable the correct posting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.