reporting from Non leading ledger

[Former Member]

Hello All,

We are trying to get reporting for country specific statutory requirements . We have a non leading ledger configured for this purpose .

The transactions which are common to both leading and non leading ledger are posted to the operational chart of accounts .

Postings which are required for only non leading ledger are posted to separate group of accounts in same chart of accounts .

Now the problem here is when ever I am  trying to run any report for GL Balances in non leading ledger,  I have main balance in one account and

adjustments in another account which is obvious.  However business needs all the main balances and the statutory adjustments to be shown under

single account for country specific statutory requirements out of non leading  ledger. How we can achieve this ?

Regards

Niki.

[Former Member]

This message was moderated.

[Former Member]

hi,

Let say I have an account 10200000- Tax Provisions with a balance of 100$  and this is posted in both leading and non leading ledger .

However for country specific requirements I have non leading ledger L1 for  Singapore country reporting.

To make adjustments required for country reporting I have another account 70200000 - Adjustments to Provision and this has another balance of 20$ .

Now if I am running say F.01 for L1 ledger I am having two rows one for 100 and another for 20 $ because they are on different accounts .

However business says that for Singapore reporting if I run on L1 ledger then the balance should say 120$.

We created another account for postings to non leading ledger because the main account 10200000 is open item managed and will not allow direct posting to L1 - Non leading  ledger.

Thanks for your help,

Regards

Niki.

[Former Member]

Hi Nikil,

One option I can think about is Substitution rules.

you can maintain the prerequisites: Company Code, Ledger, Ledger Group, Business Transaction & GL Account: 10200000

Substitution: 70200000.

Hope this will help you out for your requirement.

Regards

Srinu

[sanilbhandari]

Hi Nikhil

Why not create a new FSV for Singapore and create a node in FSV where you club both the relevant GL Accounts under the same node. The primary reason your business wants to see balance at one place is that they are related and from TB/Balance sheet perspective they should be reported in total. Most customers have this kind of requirement and the best way to handle this is to club the GL under one node,say taxes.

This is how most of the global customers use SAP

regards

Sanil Bhandari