Hello

Problem with finalizing acr invoice (with same currency that home currency), the error:

document status record not found
update method "finalization" not executed; see error log file
document xxx balance (home currency) is: 3148,5
document xxx balance (foreign currency) is: 3148,5
document xxx not balanced

I have checked tfgld102, the amount is correct , tax amount also (3148,5)
tfgld107 the tax amount is same 3148,5
nothing seems to be missing from these tables, periods are correct and i can't see any rounding error

what it is comparing, what table from where something else could be wrong or missing to cause this error (error that refers to tax amount) ??:confused:

Check the acr200 table too, just to be sure...
The application event log should give you some clues...

sk

Thank you but I have checked also acr200 (and also acr401 just in case, as the level of tax calc is transaction line)
the tax amount in HC, FC and invoice curr is everywhere the same (and correct as it should) and is not missing from anywhere.
the period has to be closed and I'm still not able to find the reason:confused:

What is application event log?

This is a bit unusual. In the past on c3 I always used to correct these by amending the values in gld102 as mentioned previously in the thread. The HC and FC being the same makes it even stranger.

Just as a matter of interest what version are you running and do you have the latest version of the sessions.

Sorry can't be more help.

Cheers
Neal

The application event log is only applicable if you are using a windows platform. It will be in the Administrator Tools in Control Panel. Open the Event Log Viewer in that and go to the Application log. Most of the times there will be an entry related to the error that you got. In one of these errors might be a listing of data not found in so and so table or cannot relate to so and so field. You would have to browse through the log to the time you got the error.

Good Luck!!

Neal: Why wouldnt the home currency and foreign currency be the same if the invoice is based on a local or home currency? Since there was no mention about a foreign currency in use for that invoice, i take it that it is based on a local currency.

sk

sk: I mentioned the Foreign Currency simply becuase when I had this problem in the past it was generally down to rounding errors with the FC values. Apologies for causing any confusion.

Cheers Neal

This has happened to me on several occasions. It general happens when a user gets "Kicked" out when finalizing an ACR invoice.

I usually go into GTM and go to the table "DOCUMENTS" (maybe tfgld107??) and look up that document number. Generally the fiscal period and batch number or some other relavant information is missing (for whatever reason).

I add the missing values in (compare with a good record) and try to finalize. It works everytime.

Justin

Good point Justin, documents table is tfgld018.

Cheers Neal

Can u please take the print of Non finalised transaction after rotating the currency, May be there be differences in the Dr and Cr side, b'coz if u r getting the message "Update method finalisatio......executed", then It would be mentioning some amnt also, that we have to reconcile.
Now go to table tfgld100, 101 and 109 also, set the batch status ready and then try to finalise the batch.
Let's see whether it works??
B'coz I have tried it in LN 6.1 and it works well there.

Best of Luck

thank you all!!
the problem was in table tfgld018, the doc status and periods missing,
the document not balanced was just a confusing message...

BR, Alice