dear expert

We’re in process of year end closing, really need expert favour to help us. We having problem in step no.2 – Automatic Balancing of Profit & Loss Account. The msg pop up “Unfinalized batches exist in fiscal year 2008"

Please advise us how to resolve the problem.

Thanks in advance

Finalize the batches?

thanks for your advise, but for you info the batch status of the unfinalized batch is deleted. And the system dows not allow us to finalize the batches.

Is there any way for us to resolve the issue ?

thanks

Error "Unfinalized batches exist in fiscal year ....


Is produced in the following fuction:

function check.for.unterminated.batches()
{
domain tfgld.year temp.year

select tfgld100.year:temp.year
from tfgld100
where tfgld100._index1 = {:year.f}
and tfgld100.stat <> tfgld.bstt.term
and tfgld100.stat <> tfgld.bstt.deleted
as set with 1 rows
selectdo
mess("tfglds0359", 1, year.f)
|* Unfinalized batches exist in fiscal year %1$d
delete.application.lock()
stop()
endselect
}


Review your records in tfgld100 marked with status 2-in use or 1-free or 4 - ready.

All of them should be Finalized or Deleted.

Cheers,

Felipe Saavedra

Dear Expert,

All the unfinalized batch status in the system has been set with 'deleted'. But the system stil does not allow us to process the Automatic Balancing of Profit and Lass Acct.

Below is the sample of one the record having the problem for your perusal.

Fiscal Year : 2008
Batch : 54
Batch Status : 7 (Deleted)
User : bsp
Trsansaction Entry date : 05-11-2007
FInalization Date :
Batch Modifiable : 2 (No)
Fiscal Period : 3
Reporting Period :3
Tax Period : 3
Tax Year : 2008
Batch Reference :
Access Mode for batch : 1 (All Users)
Finalization Run Number : 0
Finalization Status : 1 (Free)


Thanks in advance for your reply.

Pease confirm that there are no Batch records for year 2008 with status different from tfgld.bstt.term and tfgld.bstt.deleted.

Secondly confirm that if a Batch is marked as deleted in tfgld100 then there anre no records in tfgld101 (Transaction Types) and tfgld102 (Non Finalized Transactions) asociated to the Bach number marked as Deleted.

Regards,

Felipe Saavedra
Disus

Dear Ali,

Please Check the data in all Tables (tfgld100,101& 102). these table wiil show you the status of all transaction. there may be some problem in these tables.

dear finamp and vvvvv

There are no deleted status data in tfgld101, and tfgld102 only contains unfinalized data for year 2009. BUt the system still does not allow me to proceed with Auto balancing of profit and lost because every time i click on the process the system will alert me with error message "Unfinalized batches exist in financial year 2008"

What else should i check on the system ?

thanks

Dear Ali,

Plz check tfgld109 (finalization run no), tfgld100 (Batch Status), tfgld101(batch status by transaction type) status = "Inuse" not to check "Deleted"

dear finamp,

i have checked all records in tfgld100 for year 2008. Some of the records having a in use batch status and some of them are ready. But all the batches are not found in tfgld101 and tfgld102. So may i change all the in use and ready batches to deleted.

Thanks

Sure, just keep a track of your changes in case you need to reverse them.

Regards,

Felipe

Dear Ali,

As you said in tfgld100 for 2008 there are some batch staus are "in use & ready" stage. plz check all those batch no in tfgld106, if they are not there then you may change to delete status & if you found then change to finalized status. this will make a proper link for your data.

Hi, pls make sure that all your integration batches are posted & finalized also.
Else can check in tfgld106, see any other unposted transactions

Regards,
Tebby

Dear experts,

Thanks for all your advise and issues related to Automatic balances of profit and loss solved.

Now i can move the the new step but unlucky when i try to close period the Close Period - Error Report has been generated by the system. One of the message reported is 'Credit Financial Company : 500, Logistic Company : 500, Integration Document Type : 10002125, Transaction Date: 05-02-2008 not posted"
"Period 6 - 2008 before period 7 - 2008 not yet finally closed.
ACP and ACR status should be '(Finally) Closed' before closing CMG for period 7.

Please someone explain to me how to resolve the issues.

Thanks in advance

Dear Ali,

As you said in above post there is integration pending for Map & Post (salesorder/ cost of goods sold) for 7 period.
pls. run Map & post session to generate the pending integration transaction.

dear finamp,

I really appreciate your effort to resolve my issue, just want to confirm because according from my users they don't want to map and post the transaction because according to them they woory it will affect their acct balance, is there any way how for us to ignore the transaction.
Another issues is, we are in the year of 2010, but all the trnsaction is exist in period 7-2009. is it possible for us to post back the transactin in the period 07-2009 or we just post it in current period in 2010.

Please advice.

Thanks

Dear Ali,

I think it's impossible to post back on same period but u can map & post those transaction in current period.

And one thing more, if you are talking about not to posting into finance then you have to delete those transaction from integaration table.