Skip to Content

Hello All,

I was facing an issue regarding the necessity to edit the reconciliation account derived from the customer/vendor data without using a SGL indicator.

Many SCN discussion confirm that it’s not possible as in standard the GL account is derived from the customer/vendor master data, nevertheless, there is a “standard” way (no specific development) to edit and select the reconciliation account we need during posting  and without using the SGL indicator:

Here is the steps :

  1. First, specify your GL accounts that you want to choose from, for example let say Recon. Accounts
    • 41110010 (entered in customer master data)
    • 41110011
    • 41110012

  2. check the box on  GL account masetr data  (Create/bank/interest TAB)  “Reconcil.acct ready for input” (Tcode FS00)


/wp-content/uploads/2016/03/1_911325.png

3 . If this option is not visible, change your Field status group of your Account group (Tcode OBD4) in “Document entry”

/wp-content/uploads/2016/03/2_911326.png

4. Go to transaction S_ALR_87002480 to customize your entries :

For each GL account that will be derived form the customer master data, enter the possible entries you need

/wp-content/uploads/2016/03/3_911384.png


That’s All  🙂


Now when your are posting with FB01 or FB70 for customers invoices, you will have the possibility to change the reconciliation account, the field is editable 🙂

but only accept the GL account entered in the table above (step 4).

/wp-content/uploads/2016/03/4_911386.png

My posting can look like :

/wp-content/uploads/2016/03/5_911390.png

And GL view :

/wp-content/uploads/2016/03/6_911391.png

Voila !

I hope it helps 🙂

Tamim

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Bohdan Petrushchak

    Hello Tamim,

    Thank you for useful post. Just to let you know, there is also an option to enable this functionality for documents posted in MM-module (e.g. MIRO). This functionality can be enabled via business function FIN_LOC_CI_14 “FI, LO, Localization Topics for Russia 2”. Please refer to OSS note 1836997 “Alternate reconciliation account selection in LIV” for further details, it contains quite a good description of what should be done to enable it.

    Regards,

    Bohdan

    (0) 
  2. Kaptain SAP

    Scenarios that came to my mind, for which this solution will be feasible are —

    HCM-AA Integration – where Asset is sold to customer (Employee), then part of it is deducted, every month from salary. The info-type in HCM will take a GL (whether a recon or not).

    Financing / Loaning scenarios will get quite a help if when TCode OBV9 restricts usage for 1 recon account.

    (0) 

Leave a Reply