opening balance load issue

[former_member223749]

Hi,

We are having issue in opening balance load in Aug2015 month end closer.

Opening balance data manger package is successful without any error.

No data has been carry forwarded.

   “0” records submitted and “ 0” records failed.

Kindly help us to resolve the issue.

Thanks,

Devi

[former_member223749 · Accepted solution]

Hi,

Thanks for all the suggestion, actually there is no issue in any configuration.

data exist in 2015.Aug , so it was showing "0" records. i have cleared the data in Aug.2015 and loaded the data using opening balance , it's works fine.

with the help of SAP support, i have resolved the issue.

Thanks,

Devi

[Former Member]

Hi Devi,

From which month or year you are loading data to opening month Aug,2015.Share some screen short of your script logic,business rule and report. I thing your script is not pick the value or there some selection problem in DM.

Khokan

[former_member223749]

Hi,

2015.Mar we are loading as opening balance for 2015.Aug.

Sript logic as below. i am not able to share screen shot, as my company policy will not allow.

//For running balance carry forward rule (copy opening)

*RUN_PROGRAM COPYOPENING

CATEGORY = %VERSION_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%]//For More than one other scope parameters: OTHER = [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

　

//For running account calculation rule for posting of closing balance of retained earnings. The balance of retained earnings is not being loaded from ECC.

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %VERSION_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

CALC=RECL

//OTHER = [ENTITY=%ENTITY_SET%]//For More than one other scope parameters: OTHER = [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

Thanks

Devi

[Former Member]

Hi Devi,

Write CALC=CF and category dimension use OPENING_PERIOD properties value should be "Mar".This property can take absolute value such as an February and March if the properties left blank then the system assumes that the closing balances are copied from the last period in the prior year.

Khokan

[Former Member]

Hi Devi,

Kindly provide your DM log & Your DM Advanced Script Screens too..

Aravind