Sign Based (Dr / Cr) assignment of G/L accounts to FS item

[vineet_s]

Dear Experts,

In the new 2202 release of Group Reporting, is it possible to have substitution rules to allow for sign based assignment of G/L Accounts to FS Items.

E.g. If a bank account has net debit balance assign it to Cash FS Items and if it has a net credit balance assign it to a Liabilities FS Item.

Regards

Vineet

[João_FI_FIN-CS]

Hi,

According 2020 release and I don't know on 2021 and 2022, but until 2020, the substitution and validation rules only reads the data coming from Flexible File and not from FI.

So if you want to impact data coming from FI, you've to build rules on FI.

Regards.

[michaeldubois1]

Hi Vineet

Out of interest, does that mean that if you set your triggering selection to include GLAccount and FS Item, it will still reclassify the whole FS Item value?

Thanks

Michael

[vineet_s]

Hi Mike,

Yes, that correct. Even if trigger selection includes GL account, the whole FS item gets reclassified.

This was confirmed by SAP as well. Sign based reclass works quite differently. GL account is not available in balance per characteristics option.

Please check the comments on the below SAP CIP

https://influence.sap.com/sap/ino/#/idea/251395/?section=sectionComments

Regards

Vineet

[michaeldubois1]

Thanks Vineet, that is good to know.

[Florian_Roll]

Hi Vineet,

the setup of a journal substitution which depends on the period end balance of a GL account or FS item is not possible because the sign of the balance cannot be known when posting the accounting journal.

Hence, a "default" (debit or credit side) FS item should be assigned.

It can than be reclassified at period end depending on the balance of the FS item or GL account either in:

- Accounting, eg. with advanced valuation also making use of latest innovations such as "Advanced valuation: post balance sheet reclassification"

- Group Reporting with the reclassification (aka posting rules)

Hope this helps.

Kind regards,

Florian

[vineet_s]

Thanks a lot Florian.

The upcoming innovation on post balance sheet reclass. could help.

However the reclassification rules at FS Item level doesnt help. What is required is a sign based reclass involving both G/L account and FS item as trigger, and this doesnt work at the moment. The entire FS item balance gets reclassified, instead of just the value associated with the particular G/L account.

Regards

Vineet