Skip to Content
0

RTC - Carry Forward & Balance Sheet Reporting

Jul 09, 2017 at 04:18 PM

199

avatar image
Former Member

Hello Experts:

We have a situation where we wanted to report Balances for B/S Accounts in Real Time consolidation, but we have visibility only to movements of the current month. The data that we see is from Foundation view of ACDOCA. For some design/modeling reason SAP decided to not to include '000' period in the foundation view by introducing filter POPER != '000'.

Questions:

  1. How to report balance in RTC
  2. Is it by SAP design, implementation team is suppose to run Carry Forward business rule to bring Previous Year closing Balance to Current Year opening balance of period 001?
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Charlie Lin
Jul 18, 2017 at 06:06 AM
0

For period 000, there is a known issue. Apply note 2483616 Embedded currency translation is not generating results on Period 000

Share
10 |10000 characters needed characters left characters exceeded
Lucas Costa Mar 02 at 01:59 AM
0

Well, I will try to explain what I understand around the design and then how I think you should approach this.

The reason 000 is excluded is because RTC is supposed to work for multiple company codes in the same underlying system. Instead of taking whatever fiscal period is in ACDOCA, RTC will actually "convert" the document posting date to whatever fiscal period you have maintained to the RTC model. E.g.: you might have a company code under a fiscal period from Jan to Dec and another from Apr to Mar and another one from Aug to Jul... All going to the group fiscal period which can be, let's say, Apr to March.

The way this supposed to work in the BPC side is pretty much the same as you'd do with a standard model, there is no 000 period. The opening is determined by the FLOW type dimension (usually 100 or OPE). You would then be required to load the "closing balances" of the previous year you're suppose to consolidate and then run the BPC BCF.

Now it all depends on your landscape/business requirements. Case you don't have heterogeneous fiscal year variants between your company codes and your consolidation model, then you could potentially just remove the SAP filter on 000 and then the business rules would read the "opening" straight from ACDOCA and ACDOCC for the "input" type audit trail. You'd still need to configure the BPC BCF, but only for type "Manual" audit trails, entries you had inputted via Journal.

Share
10 |10000 characters needed characters left characters exceeded