Carry forward in periodic model

[Former Member]

Hi All,

In the periodic model, can we do the carry forward once a year instead of periodically (monthly)?

In my testing, I have to execute the carry forward every month.

How do I carry forward once a year for periodic model? In the business rule, I have ticked "Applied to YTD" but still the system ask me to carry forward monthly.

Appreciate your help.

Thank you in advance.

[Former Member · Accepted solution]

Hi

Applied to YTD" option, we tick this option when we need to move/copy  YTD values in periodic model,but in your case you use periodic model then this option I thing don't need. As Aravind says is right . Run carryforward with out select  Apply to YTD option.

Khokan

[Former Member · Accepted solution]

Hi Khokan,

In periodic model whereby the "Apply to YTD" option is not ticked, how do we execute the carry forward? Is it every period? or is it once a year in January?

Thank you

[Former Member · Accepted solution]

In Periodic model there is no need to execute carry forward each month, you can execute it once a year. The purpose of Balance Carry forward is to carry forward the balance from previous year to current year.But you can carry forward the balance in same period if required there is option in business rule “same period”.

Khokan

[Former Member · Accepted solution]

Hi Khokan,

Any specific setting for periodic model in order for me to execute it once a year?

In Category dimension, I put blank for all properties required for balance carry forward. Is there anything I have to define here?

I did many times checking on the referred documents and all the setting are in place. And the documents doesn't mention anything about periodic model.

With the same setting, I can execute the balance carry forward once a year only  if I use YTD model without "Apply to YTD" option.

Thank you.

[Former Member · Accepted solution]

Btw, we are in the BPC 10.1

Any differences in the balance carry forward between BPC 7 and BPC 10.1?

The documents are referring to the BPC 7.5

[Former Member · Accepted solution]

This is my testing.

Model : Periodic

Input data:

August 2015 : 100 (period data)

December 2015 : 100 (periodic data)

"Apply to YTD" option : not ticked.

Execute carry forward in January 2016, and the result is :

system only carry forward value in December 2015 i.e : 100

I need the system to carry forward the YTD 2015 value which is 200 (100 in aug and 100 in Dec).

How do I do this?????

Appreciate your help.

Thank you

[former_member186338 · Accepted solution]

Sorry, but what accounts do you want to Carry Forward? Hope you are talking about Balance Sheet accounts (AST/LEQ). Nothing to Carry Forward for P&L accounts

Vadim

P.S. And BS accounts are always YTD even in Periodic model...

[Former Member · Accepted solution]

Try checking the option Apply YTD...

Aravind

[Former Member · Accepted solution]

@vadim

Well, my data testing above were for Balance sheet account. If you're saying that balance sheet is always YTD even in the periodic model then the system already do the correct thing i.e. carry value in December (which is actually the YTD value for balance sheet) only. But.....if balance sheet is always YTD even in the periodic model, how do we load the data from BW because it is periodic data?

For income statement, actually the total of income statement should be carried forward as retained earning (balance sheet account). If the system does not carry forward Income statement (which it doesn't carry anything for income statement in my testing), how do we generate the current year retained earning to the next year then??? Another calculation using account transformation??????

@Aravind,

I did tick the option "Apply YTD", but the system carry nothing to the next year.

Is this system bug? My understanding, if I tick "Apply YTD" then system should carry the YTD value of the prior year. Am I right?

Thank you.

[former_member186338 · Accepted solution]

BS Accounts AST and LEQ are always YTD (in both YTD and Periadic models). Per definition!

"how do we load the data from BW because it is periodic data" - it depends on how you configure upload. Load balances - YTD!

"Another calculation using account transformation??????" - yes!

Please install and read documentation for the IFRS kit... You will see a lot of preconfigured business rules etc...

Vadim

[Former Member · Accepted solution]

No the system will not take the prior year ....

The system will take the year which you will mention when running your DM Package ....

Coming to the use of "Apply YTD" This option will Copy YTD value of the source year you had selected in DM Package as shown below

[Former Member · Accepted solution]

We defined target date in DM package for balance carry forward.

[former_member186338 · Accepted solution]

Hi Aravind,

But what are you trying to show?

BS121 and BS122 are both Balance Sheet Accounts - AST type. Even in Periodic model both are inputted and stored as YTD.

Vadim

[Former Member · Accepted solution]

As per standard procedure only closing balance you can send to next year opening month.There is no other any properties in category dimension which will fulfill your current requirement.My suggestion is , try to use YTD model,which solve your problem

Khokan

[Former Member · Accepted solution]

Sorry for that Vadim i had taken BS account screen by mistake...

Please see the screen below

Aravind

[former_member186338 · Accepted solution]

Carry forward from BS to P&L account??? What for???

[Former Member · Accepted solution]

I just want to show him the purpose of Apply to YTD option.....

[former_member186338 · Accepted solution]

By the way, if we return back to reasonable BS -> BS, what will happen without "Apply to YTD"?

[Former Member · Accepted solution]

It will post YTD Value itself...!

[former_member186338 · Accepted solution]

You mean no difference between with "Apply YTD" or without "Apply YTD" for BS accounts?

YTD value is 306 in your sample!

[Former Member · Accepted solution]

Yes,Vadim upto my knowledge i didn't find any difference...for the ending periods of BS ...!

[Former Member · Accepted solution]

@Aravind,

Thank you for your screen shot.

So can I conclude that "Apply YTD" will work to carry forward the value from source period to the target period within the same year and it's only applicable to carry forward BS to Income statement account for PERIODIC MODEL? By the way, your BS YTD value is 306 but the value carry forward to PL is -306  and I don't see you tick the "Reverse sign" option. Is this valid that it will automatically reverse the sign?

Regarding BS to BS carry forward, based on my testing , there are differences between with or without option "Apply YTD". System doesn't carry forward the value as per expectation with "Apply YTD" in both PERIOD and YTD model for BS to BS account. Appreciate if you could confirm on this.

[former_member186338 · Accepted solution]

I think "-" is because we perform:

AST -> INC

"+" will be for

AST -> EXP

Vadim

[former_member186338]

Please read and check your settings against:

Vadim

P.S. By the way, setting "Apply to YTD" is meaningless for periodic model!

[Former Member]

Hi Vadim,

I read the document and configured based on that document.

If I don't tick "Apply to YTD" , the system does not carry any value to the next period.

If I tick "apply to YTD", the system carry value to the next period (it only work if the parameter in the data package is set to next period). If I set the period to next year January, there is no value carried to the next year.

Thank you

[former_member186338]

If you configure everything properly based on this document - then you will have correct results. It means that you made a mistake somehow. But in order to help you all settings and dimension members have to be checked! Sorry

Vadim

[Former Member]

Hi U,

As you said, Apply YTD option is used when you had saved the data in a YTD Model ...

That means it depends on your Model whether it is Periodic Or YTD ....

So if you don't have Values in Periodic and then you have to check the option Apply YTD....

So please check with your Measures Type of your model where you are posting the transaction data...

Aravind

[Former Member]

Let me double check again.

But it is possible to have yearly carry forward with period model,right?

What is this "apply to YTD" function? I am confused.