After post consolidation data is not coming for few GL's

[nupur_dubey]

Hi Folks,

I am facing an issue in BPC 10.1 NW my client is executing the consolidation step for specific category, scope and time but the data is not coming for Few of the GL's because of that balance sheet is showing the outstanding amount. The logic of the report is :closing value of last year get copied into another category as opening value of current year after post consolidation For few of the GL's it is coming correct but for few of the GL's it is not showing the data or wrong data. Can anyone please help me with solution.

Thanks in advance!!

Regards,

Nupur Dubey

[former_member186338]

Full info required! And absolutely strange idea to add tag BPC MS! Question down voted.

[akos_beres]

Nupur, run a report with the accounts nested with group/scope and audittrail. It sounds like you are not picking up a few of the audittrails. Also you could post some logic and or data examples.

Akos

[nupur_dubey]

Hi Akos,

Thanks for the quick response. I am sharing one example here for dec.2017.

1. X is my GL account, P1 is audit trail and A10 is category and the amount is 100rs. This is the closing value of dec.2017.

Every month user execute the consolidation process and after post consolidation the amount which is coming in A_10 category will populate in another category A_11(as last year rate in 2018.01). We can say that data which is coming in 2017.01 closing will come as 2018.01 opening balance. We are facing issue like few of the GL's it is coming but for few of the GL's it is not coming also it is showing wrong data. As per suggestion run a report with the accounts nested with group/scope and audittrail, can you please explain in detail. It would be great help as I am kid in BPC.

[akos_beres]

Nupur,

Please see my answers below:

"the amount which is coming in A_10 category will populate in another category A_11(as last year rate in 2018.01)" this FX is probably driven by properties maintained in the category dimension. Most likely there is no LC amounts in A_11 and the carryforward business rule wouldn't pick up anything from here. This category is probably used for analysis purposes only anyway.

"We can say that data which is coming in 2017.01 closing will come as 2018.01 opening balance." Assuming that the company's fiscal year goes from 2017.01-2017.12, this statement doesn't make sense. Usually 2017.12 closing balance would be coming in as 2018.01 opening balance.

"Run a report with the accounts nested with group/scope and audittrail, can you please explain in detail." this is how your rows and columns should look like in your EPM report in Excel:

page axis: Company

Row axis: Account(X), Group(base) or Flow(base including the closing and opening flow), Audittrail (base)

Column: 2017.12 and 2018.01

With this report you should be able to see if there are any discrepancies between the closing and opening flow amounts by audittrail. Since there are some values that are populated, I assume there is an audittrail(s) that the carryforward business rule is not picking up. There are other possibilities but this is most likely.

You could post the carryforward business rule as well as the audittrail dimension if it is not too large.

Also are you using a starter kit?

Akos