cancel
Showing results for 
Search instead for 
Did you mean: 

EBS RFEBGB00 program - how can I post to alternative accounts?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

H Bill,

Could you please provide the layout of BACS statement.

I am struck in this.

Please help.

Thanks in advance

Regards,

sophia

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

OT83 is the configuration transaction and there is a help PDF to go through when doing the configuration.