Skip to Content

TRM posting to alternative reconciliation account of customer subldeger

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

/wp-content/uploads/2014/07/alternative_497045.jpg


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.

IMG_14072014_154531.png

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!!!

assig gl acc.jpg

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)

D1120 specs.jpg

d1200 specs.jpg

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.

specs to update type.jpg

Results:

And after that we have the following postings for:

  • Final repayment

post MM1120+.jpg

  • Nominal interests

post MM1200+.jpg

Be the first to leave a comment
You must be Logged on to comment or reply to a post.