Question Re: Loading inception-to-date balances in Enterprise Resource Planning Q&A

Loading inception-to-date balances

MortenR — Fri, 16 Aug 2024 20:21:09 GMT

Hi all,

I am aware of this roadmap item: Ability to enter or load reported data for dimension totals .

As we go live with GR in 2025 and we run on S4H PCE, we need to have a workaround, as the above roadmap item will not yet be available I believe.

Can anyone think of a workaround until then? Our entities provide a full inception-to-date balance sheet (w/o movements) and YTD P/L balances. We need to get this into Group Reporting. The loading process needs to transform these inception-to-date balances into periodic deltas with transaction type 915 by substracting the 900 opening balances stored in GR.

We plan to use GRDC, but would be open for any other method that can fulfill our requirement.

Regards,

Morten

Re: Loading inception-to-date balances

FlorianRoll — Mon, 19 Aug 2024 06:30:20 GMT

Try/test using 2 doc type, splitting inception-to-date balance for the load (e.g. doc type A1) and opening calculation + opening reversal (e.g. doc type A0)

1. GR carry-forward: assign dedicated opening doc type (e.g. A0, PL00) to inception-to-date doc type (e.g. A1, PL00)

2. Use GRDC mapping with Group Reporting as source to invert opening on opening doc type (A0). After GR balance carry forward, run GRDC mapping job reading subitem 900 in period 000, invert the amount, load to 915 in period 1.

3. Regular inception-to-date load runs on separate doc type (e.g. A1 on PL 00)

Anticipated result (to be checked/tested by you)

- Doc type A0 should carry opening balances on subitem 900 and opening reversal on subitem 915

- Doc type A1 should carry complete inception-to-date balances on subitem 915

- Total of A0+A1 should carry opening on subitem 900 and current year's changes on 915

Re: Loading inception-to-date balances

HengyeZhu — Tue, 20 Aug 2024 01:27:20 GMT

Hi Morten, just one question here, you don't need to reverse the YTD amount of each period, not limited to period 000 to the next period?

Re: Loading inception-to-date balances

Pierluigi_C — Fri, 23 Aug 2024 14:53:19 GMT

Hi Florian,

Using the Doc type A0 to reverse the figures posted in subitem 900 this could generate some issue with the currency conversion. The amounts posted in subitem 900 in period 000 are converted with the closing rate of previous year while the figures posted in subitem 915 in document type A0 will be converted with the average rate

Re: Loading inception-to-date balances

FlorianRoll — Mon, 26 Aug 2024 06:07:02 GMT

Data would look like this:

Re: Loading inception-to-date balances

FlorianRoll — Mon, 26 Aug 2024 06:14:10 GMT

Data would look like this...

period	doc type	subitem	amount
000	A0	900	1000
001	A0	915	-1000
001	A1	915	1500

result: we have 1000 on opening balance (900) and 500 on periodic changes (915) with an inception-to-date balance loaded of 1500 on A1.

Re: Loading inception-to-date balances

Pierluigi_C — Mon, 26 Aug 2024 07:31:35 GMT

Hi Florian, thanks a lot for your reply.

Assuming the closing currency conversion rate of the PY 1.5 and the average currency conversion rate of the current year as 1.7, the approach suggested will generate the following result:

period	doc type	subitem	amount loc curr	amount Group Curr
000	A0	900	1000	1500
001	A0	915	-1000	-1700
001	A1	915	1500	2550

In group currency the document type A0 will be different from 0