Skip to Content
Author's profile photo TAMIM EL MAHMAH

Change Reconciliation account during FI posting (Without using SGL indicator)

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

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Bohdan Petrushchak
      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

      Author's profile photo TAMIM EL MAHMAH
      TAMIM EL MAHMAH
      Blog Post Author

      Hello Bohdan,

      Nice, thank you for your feed back 🙂

      Author's profile photo Former Member
      Former Member

      Really thanks to bohdan

      Author's profile photo Daniel de Carvalho
      Daniel de Carvalho

      Thanks Tamim, I will try that one in my Sandpit system.

      Thanks and Kind Regards,

      Daniel Carvalho

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Mir Osman Ali Khan
      Mir Osman Ali Khan

      Hi Tamim and others

      Many thanks for the valuable information.

      Regards,

      Farhan

      Author's profile photo Engin YILMAZ
      Engin YILMAZ

      Very good indeed. Thanks.

       

      Engin