Consolidation group change: Balance sheet/income statement balance 14,560

[Former Member]

Dear All,

While performing the consolidation group change task, system throws the error message :

Balance sheet/income statement balance 14,560,497.62- INR

Message no. UCD1011

Diagnosis

The document to be posted is not completely in balance.

Entries involving items of the balance sheet or the income statement must always have a zero balance to ensure that both the balance sheet and the income statement are balanced, respectively. This is not true in this case.

System Response

Entry cannot be posted.

Procedure

Correct the amounts for the balance sheet items and/or income statement items.

I have checked the COI Settings and not showing any error.

I have analysed the problem and found that system is not picking one FS item 107501 i.e Profit and Loss CY.

Can any one suggest me how to resolve this.

Thanks in advance.

G Vinod

[dan_sullivan · Accepted solution]

I have experienced this when the reclassification of net income to retained earnings is not executed or needs to be re-executed due to data being reloaded.

My initial suggestions is to re-execute this reclassification and then re-execute the cons group changes task.

[Former Member · Accepted solution]

Hi Dan

thank you for reply.

I have re executed the reclassification task 14010- retained earnings classification.

still system is showing the same problem.

Only one FS item (107501 - Profit and Loss - CY) balance is not being picked in cons group change entry

Please provide me further inputs.

Thanks and regards,

G Vinod

[dan_sullivan · Accepted solution]

It the reclassification method for task 14010 cumulative or periodic? If periodic, the difference may be from a prior period.

Is the amount of the difference for the specific item for only the current period or cumulative balance for all periods?

Is the item type for item 107501 balance sheet or income statement?

Edited by: Dan Sullivan on Apr 26, 2011 8:06 AM

[Former Member · Accepted solution]

Hi DAN,

Thank you for the reply.

Reclassification method 14010 - Selection in trigger tab is: Periodic

the difference is from previous period i. e 14,560,497.62- INR

The above mentioned balance is upto period 006/2010. consolidation group change happened in 009/2010

FS item 107501 is Balance sheet item.

Please provide me further inputs

Thanks and Regards,

G Vinod

[dan_sullivan · Accepted solution]

One suggestion I can make is to re-execute the Reclassification task 14010 for the previous periods and then re-execute the cons group changes tasks.

An alternative is to change the Reclassification method 14010 from periodic to cumulative and re-execute in the current period and then re-execute the cons groups changes.

Edited by: Dan Sullivan on Apr 27, 2011 8:12 AM

[Former Member · Accepted solution]

Hi DAN,

thanks for the prompt reply.

i have done as you suggested. but result has not been changed.

and i have further analyzed the problem and system is considering the 107520 (BS Clearing a/c) while posting PCC.

i have executed the same task in previous PCC and worked it well.

as per under standing this FS Item should become Zero. but in this case it is not becoming ZERO

those previous period PCC happened immediately after the FY change i.e starting of the new financial year.

But the present case happened in the middle of the year and the console unit data upload is through flexi.

kindly provide further inputs

Thanks and Regards,

G Vinod

[dan_sullivan · Accepted solution]

It is not that FS Item 107520 be zero but that the balance sheet and income statement items in total net to zero.

Does the net of the flex upload file net to zero for these items?

[Former Member · Accepted solution]

Hi DAN,

Thanks for the prompt reply.

we are using the flexi upload - cumulative TB (YTD).

when you upload, obviously it will not be zero independent balances of BS and PL. because the TB which we are uploading will not contain FS item for the current year profit. the profit is the difference of the PL items. to the extent of profit, BS items will show the difference.

Please consider above and provide further inputs.

Thanks and Regards,

G Vinod

[dan_sullivan · Accepted solution]

Sorry but I did not understand.

The trial balance, in total, should net to zero. If that is not the case this may be the cause of the out of balance issue.

[Former Member · Accepted solution]

Hi DAN,

i ll elaborate what i wanted to convey.

When we upload

1. TB Equal to ZERO

2. Net of BS items may not be equal to ZERO

Eg: if September 2010 (FY is April to Mar) file is being uploaded, the profit till the period September will be in PL items. so to the extent of profit element will be the difference in BS Items.

when u run profit calculation task, after data upload and validation, system will pass the following entry,

In case of Loss:

BS - Profit and loss - CY - Dr

PL- Profit before MI - Cr

BS- BS Clearing A/c Cr

PL - PL Clearing A/c Dr

when u run PCC, system ll pick these two items *BS - Profit and loss - CY and BS- BS Clearing A/c. so obviously, posting cannot be done.

Please tell me if u still not understand

Thanks and Regards,

G Vinod

[dan_sullivan · Accepted solution]

In my experience the only entry for the reclassification of profit to retained earnings is to BS - Profit and loss - CY and PL - PL Clearing A/c.

What is the purpose of PL- Profit before MI - Cr and BS- BS Clearing A/c?

Are you using COI? If so there should be a setting for Appropriation of Retained Earnings for Org changes and method changes which may be substituted for the BS - Profit and loss - CY in PCC. If you are not using COI then it is a setting in PCC configuration.