/ERP/GL_ACCT Account Signage in BPC Optimized for S/4HANA

[former_member277290]

It is a universal requirement to display GL Account balances with signage according to their account types. That is: Credit balances on Liability or Income accounts should be displayed as positive, while Debit balances on Asset or Expense accounts should be displayed as positive.

In Standard BPC, one could use properties such as ACCTYP in combination with configuration like 'CreditPositive' to determine how to treat these values.

In Embedded BPC, this is much less convenient, but still possible by using the 'Reverse Sign for Nodes' hierarchy option, and specifying this property manually in the Account Hierarchy you maintain, and then creating formulas in BEx Query Designer, as described in this post from William Yu, or this other article, or this other article.

However, in BPC Optimized for S/4HANA, we are given a standard SAP-built InfoObject, /ERP/GL_ACCT to work with. It is a virtual characteristic, built on the HANA View RTC_C_GLACCOUNT, which specifies its master data. It also has a Local Hierarchy Implementation with class CL_FCOM_IP_HRY_READER_GLACCT, which takes the Hierarchy info from the Financial Statement Version (FSV) maintained in S4.

So this appears to mean that, as standard in BPC Optimized for S/4HANA, one cannot control the signage display of account values at all.

Questions:

1) Is the above correct? Can it really be the case that account signage cannot be controlled out of the box? Or am I just missing a simple option which does this as standard?

2) What is the suggested fix here? Is it advisable to modify the SAP Standard InfoObject? Would we need to create a custom hierarchy class to read/specify the node reversal property?

Any suggestions would be most welcome.

[lucas_costa3 · Accepted solution]

Hi Elliott,

/ERP/GL_ACCT is now fully supporting signage, the articles you mentioned are workarounds for when this was not possible. Check note below:

2531080 - "Reverse sign"-functionality for nodes in the hierarchies of InfoObject /ERP/GL_ACCT

[former_member277290 · Accepted solution]

Thanks Lucas, this looks like the right answer.

Unfortunately, I tried following along with the instructions of Note 2563214 and could not make sense of the instructions. It says "...select and input "RSTADD" as Line Type." I have no idea what this means. Attached the appropriate screen - do you know what is intended here?

[lucas_costa3 · Accepted solution]

Hi, FBIW_T_RSTADD should a table type (not structure) and then in the next screen, you can select line type.

Example

[former_member277290 · Accepted solution]

Thanks! It would have been helpful if the correction instructions mentioned that, and if the description didn't include the word 'structure'! 🙂

[former_member626665]

Hello experts,

What is the sign criterion when entering planning data in the system according to account type?

System: BPC Optimized S/4HANA 1909

Thanks!

[Vishwanathg7]

Hello All,

I am facing the same issue while on S4HANA 1809. FSV sign change is activated for /ERP/GL_ACCT for own type hierarchy and not Standard Type. Do you have any work around to achieve the sign change for Income and Liability accounts.

Thanks

Vishwanath

[Victor_Arroyo]

Hi Elliot,

I think that the best option would be to make a copy of the infoobject and modify it.

Victor Arroyo

Best Regards,

[former_member277290]

Thanks for the suggestion Victor, but in this case you have your Hierarchy Type set to Standard. This will not work in S/4 Optimized, as the GL Account Master Data and Hierarchy must be read from the Financial Statement Version.