Bank Reconciliation - Picking wrong accounts

[Former Member]

Dear All,

I have configured manual bank reconciliation for our house banks as follows,

GL Codes Description Symbols Acc Mod Curr GL Acc Acc Symbol Desc

102310 Bank ACC 01 - Main LK00 ++++++++++++ Main

102311 Bank ACC 01 - Incoming Payments LK01 +++++++++++1 Receipts

102312 Bank ACC 01 - Cheque Payable LK02 +++++++++++2 Payments - Cheques

102313 Bank ACC 01 - Bank Draft (Foreign) LK03 +++++++++++3 Bank Draft

102314 Bank ACC 01 - Bank Transfers (Dm) LK04 +++++++++++4 Bank Transfers

102315 Bank ACC 02 - Main LK05 +++++++++++5 Main

102316 Bank ACC 02 - Incoming Payments LK06 +++++++++++6 Receipts

102317 Bank ACC 02 - Cheque Payable LK07 +++++++++++7 Payments - Cheques

102318 Bank ACC 02 - Bank Draft (Foreign) LK08 +++++++++++8 Bank Draft

102319 Bank ACC 02 - Bank Transfers (Dm) LK09 +++++++++++9 Bank Transfers

When process using Tcode ff67, LK00-LK04 range is working fine but LK05-LK09 range is picking wrong accounts (ie. It picks from LK00-LK04) range.

Any idea to come across above error ? Appreciate your help on this.

Thanks

Madhawa

[Former Member · Accepted solution]

I think your account numbering and masking is wrong.

As you have masked all numbers for the first main account you need to use different GLs for your 2nd bank account

ie use

102320

102322

102323 etc.

if you must use these Gls you cant mask the way you have

[Former Member · Accepted solution]

Thanks for your reply.

I have 8 house banks and GL codes created as follows,

102310 Bank ACC 01 - Main

102311 Bank ACC 01 - Incoming Payments

102312 Bank ACC 01 - Cheque Payable

102313 Bank ACC 01 - Bank Draft (Foreign)

102314 Bank ACC 01 - Bank Transfers (Domestic)

102315 Bank ACC 02 - Main

102316 Bank ACC 02 - Incoming Payments

102317 Bank ACC 02 - Cheque Payable

102318 Bank ACC 02 - Bank Draft (Foreign)

102319 Bank ACC 02 - Bank Transfers (Domestic)

Iif I create GL accounts keeping with 10 (Main + 9 clearing accounts) will be ok. But I need keeping with 5 accounts (Main + 4 clearing accounts for each house bank).

As suggested, if I keep GL accounts codes instead of mask, is it recomended to keep ?

Thanks