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 :
- 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)
3 . If this option is not visible, change your Field status group of your Account group (Tcode OBD4) in “Document entry”
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
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).
My posting can look like :
And GL view :
Voila !
I hope it helps 🙂
Tamim
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
Hello Bohdan,
Nice, thank you for your feed back 🙂
Really thanks to bohdan
Thanks Tamim, I will try that one in my Sandpit system.
Thanks and Kind Regards,
Daniel Carvalho
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.
Hi Tamim and others
Many thanks for the valuable information.
Regards,
Farhan
Very good indeed. Thanks.
Engin