Debit and Credits Report for Bank Reconciliation Configuration OT83 Posting Rules

[Chris_547]

Hello everyone,

I was looking for your help on locating a report which would make the bank reconciliation project a lot easier. In OT83, posting rules are used to describe any unique combination of GL accounts, posting keys, posting type, document type, and posting area. This would be miserable to do from scratch.

Is there such a report that would display credits and debits in one line? Example below.

I'm aware of reports such as FS10N and S_ALR_87012289, but these don't quite fit what I'm looking for.

 

[Chris_547]

Could there be a better way to create posting rules in OT83? I understand not every transaction will have a debit & credit posting key. Also, Posting Type doesn't appear in OT83. I also found a layout in FS10N the closest to this layout: Posting Key, G/L Account, G/L Account(Debit), Document Type.

[Chris_547]

I was able to resolve it this way: find every unique transaction using bank account, debit/credit as -/+, then transaction type code. From there, I was able to engineer backgrounds from assign external transactions, to posting rules.

[Chris_547]

These are the steps I took to create our configuration:

1. Identify all GL accounts to be used in the configuration

2. Enter all the specific GL Accounts as Account Symbols

3. Identify all unique types of transactions in the bank data – bank account, transaction type code, and credit/ debit (+/-)

4. Describe the payment being completed in the Create Keys for Posting Rules

5. Use the Define Posting Rules to describe the journal entry for the payment

6. Describe the Transaction Type code used for the payment from step 3

7. Identify bank statement file format in Assign Bank Accounts to Transaction Types