SAP DM- Reverse sign in the XBRL report

[IOL]

We are implementing the financial statement for SAP DM ST1600 in accordance with ESEF regulations.

In some cases, the sign logic used in the report differs from the regulator's requirements.

Example: If an item is presented in the report as a negative value, it may be required to reverse its value in the XBRL report, but keep it displayed as "negative".

Question:

When generating the iXBRL in SAP DM, is it possible to reverse the value sign based on some attribute for the tagged item? Is there functionality exist in add-in SAP DM Mapper?

Please help me.

I have also verified this problem in another tool designed for tagging and there, such functionality (Reverse sign) exists.

[Marc_Kuipers · Accepted solution]

Hi Iwona

Yes, DM can handle this "Negated data"

Tag the negated values in Excel as usual, but using a negative scale in the Unit, so that the XBRL value is turned to the opposite number and fits the balance attribute of the concept.

Example:

IMPORTANT REMARK: do not change the sign of the amount manually or using any formula in Excel.

This will set the iXBRL values (in the fact) to opposite sign, while the format of the displayed amount will not change in the Form. This way, the iXBRL document stays consistent.

Regards,

Marc

[Marc_Kuipers]

Iwona

As an example, see:

https://www.sec.gov/ix?doc=/Archives/edgar/data/4457/000000445720000091/uhal-20200930.htm

This report was created with SAP Disclosure Management - and you can see an example, where on the report it shows as 613, but the fact is -613,000

Hope this helps!

Marc

[IOL]

Marc,

Thank you for advice.

I changed the ixt:zerodash format to 'default' now.

It is OK.

Does this mean that ixt:zrodash cannot be used as a template for tagging all cells in the report?

Do I have to clearly indicate the cell in which it should be used for the each period?

Can we imagine the following case:
for example:
In the first year of FY 19, the reporting item has a value of 0 presented as '-' on the report.
We copy the definition of the Fy 19 report to the new period FY 20 and this item already has a balance, eg 100. This means that in such a situation the format must be changed from zerodash to default for these items.
Then, in the year FY21, the value of the item again has the value 0, presented as "-", so you have to view the report again and change the format from default to zerodash.

This means you cannot have a report template with XBRL mappings and formatting for use in subsequent periods.

This method of parameterization generates additional work for the inspection.

Do you have some solution for this?

Thanks,

Iwona

[Marc_Kuipers]

There's no solution for this I would say. You'd have to check the mappings manually

[Marc_Kuipers]

Hi Iwona

Please close the thread if it has been completed

https://blogs.sap.com/2017/08/15/what-to-do-with-my-answered-questions/

Thanks!

[Marc_Kuipers]

Iwona

That format ixt:zerodash is not correct - and probably the cause.

Not sure how it got there - could be a bug

Did you explicitly set the format in the mapper, or did you leave it 'default'

Marc

[IOL]

Marc,

What do you mean about "could be an issue in the Previewer..."? Are you think about web browser or ixbrlviewer file, which is attached to the inline file generated from SAP DM?

Actual value in the instance is - 1 904 022.

My previous version - Unit PLN without Negated

<span style="font-size:8pt; left:22.83pt; top:0.26pt;">(<ix:nonFraction name="ifrs-full:EmployeeBenefitsExpense" contextRef="CYTD" unitRef="PLN" decimals="0" format="ixt:numcommadecimal" scale="3" sign="-">1 904 022</ix:nonFraction>)</span>

Current version - Unit PLN with Negated

<span style="font-size:8pt; left:22.83pt; top:0.26pt;">(<ix:nonFraction name="ifrs-full:EmployeeBenefitsExpense" contextRef="CYTD" unitRef="PLN" decimals="0" format="ixt:zerodash" scale="3">1 904 022</ix:nonFraction>)</span>

Iwona

[Marc_Kuipers]

Hello Iwona

What is the actual fact value in the instance (not the previewer file)

I.e. should be a line like this

<span style="font-family:Arial"> <ix:nonFraction name="us-gaap:IncreaseDecreaseInInventories" contextRef="DYPriorSixMonthsToDate" unitRef="USD" decimals="-3" format="ixt:numdotdecimal" scale="3" sign="-">613</ix:nonFraction></span>

The NaN could be an issue in the Previewer...

Marc

[IOL]

Marc,

Thank you for your explanation.

I know this option. I defined a Unit where I used the negative scale.

I used this unit to tag ifrs-full:EmployeeBenefitsExpense.

Data Cache

Document

Report XBRL - As you can see in XBRL Fact value presents NaN values

I was looking for another solution because, I thought I could not define Unit PLN with and without the negated option.

However, you are presenting this solution.

So the question is what causes NaN to present values in our XBRL report.

Iwona