Sunday 20 March 2016

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

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)

SAP FICO Certifications and Material

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

SAP FICO SGL Certifications

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
SAP FICO Material and Certifications

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).

SAP FICO MAterial and Certifications

My posting can look like 

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

And GL view :

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

Source: scn.sap.com

3 comments:

  1. Really it is useful and thanks for sharing the information SAP FICO Training

    ReplyDelete


  2. SAP MM TrainingChennai, furnish the best training with Real-time projects. We configured the course as for the Industrial demands. We offers long-term support.
    sap fico training in chennai

    ReplyDelete