Hi.

When financial dept do finalise.the server become slow,but anyhow, at last it show all is finalise.

When they print the trial balance,the amount is correct,

but when print the financial statement (eg : p/l,mfg.......) ,the
amount is wrong.

I chk the program script,actually finance statement is take from table tffst150 ,right???


How am I going to make my financial statement to be correct ???
must I chg table tffst150 manually ????


Please guide me step by step.THANKS ALOT.

Try running the Rebuild ledger history session and run the reports again.

HI Maria,

What Is the session no for rebuilt ledger history ???

Once I run it,will it effect whatever already finalise??

What is the purpose to run this session??? to make the table tffst150 correct ????

THANKS ALOT.

The rebuild session is tfgld3206m000 and should only be run when there is no one working on the system. This session rebuilds your history totals from the ledger transactions(tfgld106). The trial balance print values from the history totals. This will at least ensure that your trial balance report is correct.

Did you run the select financial statement values before running the financial statement? This could also be a problem.

Hi -

Something else to consider....

Be sure that all of your ledger accounts and dimensions are linked to a statement account via session tffst1104m000.

If you have missed the setup for a ledger account/dimension, your financial statements will not agree with the trial balance.

Regards,
Linda

Hi Maria.

Yes,I ask the end user,they do run the "the select financial statement values " before run financial statement.

Financial stement take the value from tffst150, so if I run "rebuild ledger history" will it update the tffst150 to the correct amount since my trial balance is correct ????


Is the sesssion num (tfgld3206m000) correct? I got no tht session.But got tfgld3201m000 .

Additional info : when user do finalized,system show all the batch already finalised ,but in table tfgld109 ,the run number 18 (the num they run which is integration )show 'ready',so we manually chg it 'finalized successfully' since all already finalized. is this effect the report,is yes,what action I should take ???


Thanks alot

tfgld3201m000 will do the same job. It will not update tffst150, that is updated when you run select financial statement values.

If tfgld109 status is wrong then there could have been a problem with the finalisation. Make sure that all the transactions were actually finalised.

As Linda said, it could also be that you are missing some ledger accounts so check that.

Hi.

I already run the session "rebuild ledger history" session.
But I run "rebuild opening balance/histoy from transaction" instead of rebuild ledger history ( because other user suggest better use this)
.Due to my May account got problem,so I just run from month 5 to 5.

after do this .my financial statement become correct ,BUT my balance sheet become wrong and TRIAL BALANCE's opening balance all become zero.

MAY I KNOW WHAT IS WRONG?
HOW TO MAKE MY TRIAL BALANCE OPENING BECOME CORRECT ???

thanks alot.

If you rebuild your ledger history (tfgld3203 or 3206, they do the same job in a different way), all relevant records are removed from the history tables (tfgld20*) and rebuilt from your transaction history tfgld106 (and from tfgld102 I think).
If you have closed your previous financial year that's ok. But if you have only provisionally closed the previous year, this causes a problem since the provisional year end only writes the opening balance totals to the tfgld20* tables but does not create a transaction. As a result, the rebuild will wipe out your opening balance and does not rebuild it since there is nothing to rebuild it from. You will have to re-run the session to create a provisional opening balance yourself to correct this.

Dear Sir.

How to check the if last year a/c did not close ???
what is the session number to chk it ??

You said that ( You will have to re-run the session to create a provisional opening balance yourself to correct this. )

May I know waht is this meants?? and how to do it (attach with session number ) ??
Can you please teach me step by step ?????


Thanks alot.

Check the company parameters in finance to see what the current fiscal year is. If that is last year, then you haven't closed the year yet.

Go to finance/general ledger/year end processing and read the help text for the sessions involved. You will have to run close year provisional (tfgld6201m000 I think, I haven't got access to Baan at the moment.

If you haven't done a year end before then find someone on site who has and get all the latest patches from Baan. Provisional year end should run ok, but the final year end may not.