Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
grigoriy_babitskiy
Active Contributor

"A long time ago, in a SAP galaxy far, far away...." (c) there was the only one possibility to post to alternative reconciliation account of customer/vendor subledgers - Special G/L Indicators.

But with ERP 2005 (might be earlier) "A new hope" (c) has come - Postings with Alternative Reconciliation Account (tr. SM30 -> V_THKON)

And since then it is possible to post to alternative reconciliation accounts of Customer sublerdger in TRM.


Scenario: we use investment in deposit as example, where Banks are customers to us. We give them money as deposit. They owe us - the investment and interests. The requirements - to show interests with customers using alternative reconciliation account.


Postings:

  1. Nominal interests: Dt Customer (alt. recon. acc) Cr Interest revenue
  2. Final repayment: Dt Customer Cr Deposit acc.



Settings:

1. We assign alternative reconciliation account to usuall reconciliation of customer: 13102000 (usuall) - 18791120 (alternative).

IMG -> Financial Accounting (New) -> Accounts Receivable and Accounts Payable -> Business Transactions -> Postings with Alternative Reconciliation Account -> Define Alternative Reconciliation Accounts ( SM30 -> V_THKON)



2. We define account symbols for customer subledger

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Account Determination -> Definition of Account Symbols  (SM34 -> TRACX_ACC_DETER)

Let's define one account for usuall reconc. account and another - for alternative.

3. Now we assign general ledger accounts to account symbols

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Account Determination -> Assignment of G/L Accounts to Account symbols  (SM34 -> TRACX_ACC_DETER)

As you can see from text - we assign only G/L accounts, but not subledger!!!

As we don't need to change anything else, we don't show account symbol 2.1

4. What about posting specs?

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Account Determination -> Definition of Posting Specifications  (SM34 -> TRACX_ACC_DETER)

5. Let's assign posting specs to update types.

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Define Account Determination -> Valuation Areas (001) -> Assignment of Update Types to Posting Specs  (SM34 -> TRACX_ACC_DETER)

When you make a posting, the system always check whether an assignment exists for a specific valuation area. Only if no posting specification is available at that level will the system use the postings specs that is independent of the valuation area. That's why we assign posting spec to update type trough valuation area 001.

Results:

And after that we have the following postings for:

  • Final repayment

  • Nominal interests

Labels in this area