dear all,

can anybody tell me why do i get this message "0 batches selected for finalization" everytime i try to finalize one batch in session tfgld1210 (Global Selection of Batches for Finalization) ?

The batch status is Ready, and all the related transactions are still showed up in table tfgld102 (Nonfinalized Transactions).
But still i can't finalize the batch. :confused:

Please help.

Thanks.

regards,
Richard Citra.

These may points may sound silly but they sometimes happen.

Are the input parameters set correctly ?

For example is the year, user login code, batch numbers, fiscal/reporting periods, set so as to select the batches needed.

Are you able to select the batches using Select Batches for Finalisation?

Terry

hi Terry,
yes, actually i've set all the required parameters correctly (year, company, batch number, transaction entry date, fiscal period).

The problematic batch can be selected using session tfgld1210 (Global Selection of Batches for Finalization).

Anyway, the batch don't showed up in Select Batches for Finalization.


-Richard Citra

Check out if the batch is stuck in the process of finalisation.

Check out the run number (you can to so in tfgld100)

Go to this run number and try to finalise it again. If there is any error try to fix them

hi mprakash,
actually the batch cannot be linked to any run number because as i mentioned before, the batch don't showed up in session Select Batches for Finalization.
So, the batch still hasn't any link to any finalization run number.

In table tfgld100, the Batch Status = Ready, Finalization Run Number = 0, Finalization Status = 1 (Free), Select = 2 (No).

Anybody please help...... :(

-Richard

Mprakash

What is the status in tfgld101 ? Note this table may have more than one record for the batch depending on how many transaction types there are in the batch

Terry

hi Terry,
i look in table tfgld101 and the value in field Transaction Type Lockin is 1 (Free) :eek: . Should I modify (via session ttaad4100) the value of this field to 4 (Ready) so the problematic batch can be finalized?

-Richard.

rcitra

Yes try changing to ready and see if that does the trick

Terry

If there is a chance that other users modify the tables, you should check if the document before the first record you have in tfgld102 is present in tfgld106. Check if the batch number you have problems with is present in gld106.
If it is a manually created batch, you can try to enter the transaction type via maintain transactions, and then exit. If everything is ok, the gld101 status will change to ready.
If it is an integration batch (or other automatically created), you can use the same approach, but you have to change the field "Batch modifyable" from no to yes. Then you can enter the batch manually. Of course you don't change anything in the transactions......

In this way, you get the system to check, wheter it is ok, or not. Safer this way, and it only takes 10 seconds more.

Kind regards
Eric

hi Eric,
the problematic batch and the document number linked to the batch is not present in tfgld106.

could you please tell me exactly on what session should i do your suggestion? (i'm a newbie in Baan Finance :o ).

many thanks.

-Richard

Dear
You will check transactions record on thair batch that had transactions or not and try to check all of transaction type on batch that have no record transactions or not

Dear Richard,

Transaction type batch status "free" in tfgld101 can mean any of the following:
1. A transaction type was inserted in session maintain transactions (tfgld1101m000), but transaction was not actually made. Thus the transaction type is empty without any transaction in it.

2. The transaction is not balanced. Possibly the user might have left it half way. Or a system transaction itself might have a rounding off error or any such error.

3. Everything else is correct but the system has not updated the status to "Ready"

Obviously possible solutions could be:

1. First check if the transaction type in the said batch contains any transaction. Just go to session tfgld1101m000, double click the said transaction type to enter into it. Empty inside? come out and delect the transaction type record.

2. If this was not the case, print non-finalized transaction for that particular batch and type, and see each document contained in it. Look for any unbalanced documents. Unbalanced? Analyse the reason and accordingly rectify in tfgld102 thru. session ttaad4100

3. If this was also not the case, and it is a pure case of system not updating the status, go to tfgld101 and rectify the status to "Ready"

Please note, GTM correction should always be the last resort, and only when you are sure of the reason and inter-relation of the field with the other table/fields. Otherwise, GTM corrections may lead to a lot of complications.

Tell me if this helped you

All the best + Cheers
Baanmanindia69

baanmanindia69,
i did some checking as you've suggested, and found that our case is neither no.1 or no.2. So we can confirm that it's a pure system failure in updating the status.

I did the GTM correction (table tfgld101) and the batch now can be finalized.

Thanks for your help. ;)

Kind regards,
Richard.

Hi Richard,

I forgot to tell one thing. Even for the last case also, GTM correction is not required. Just enter into the transaction and come out... the status is automatically changed to "Ready"

Anyway, now the GTM change is done, no issue. All the best.

Best regards
Baanmanindia69