kamran
6th February 2003, 16:34
Hi All
Can anyone tell me how the Customer Control Checklist works? which tables is it comparing? is it gld106 to acr200?
The problem I have is when this is run I am getting several invoices on the report which show finalised amount 0.01- and closing balance of 0.01- while the open item bal. is 0
Having checked the the sales invoice the 0 balance is correct yet the control account is showing 0.01- why????
thanks for any help you can give me.
Kam
MariaC
7th February 2003, 12:38
the checklist looks at tfgld106 and tfgld102 and compares the data in these tables to tfacr200. If there are any differences it will show the transaction which is causing the problem. a 1c difference could be a rounding problem. You will have to check the transactions carefully to find this.
Otto_NL
11th February 2003, 20:58
Hello,
It can be that this account shows one cent left,
maybe you can try to run write off payment difference of
write off currency differences. You can run both sessions with print only. The output can be checked, in order if the same documents appear
Hope this helps you
Regards
Otto
Moshe Almog
12th February 2003, 09:24
Hi,
One cent is probably due to rounding differences which were not done exactly the same in GLD as in ACR.
I think that they should not bother you and you can leave them as is.
If you ensist on fixing them you should find the problematic document and fix it either in ACR or GLD.
You should really know what you are doing !!!!
The fix in GLD will usually be in a line with the account that is not ballanced in the report against a line for rounding difference account.
If the fixed document is allready finalized, it means you have to fix table tfgld106 and thanyou will have to run rebuild balances from transactions.
Than you have a problem if the period is already closed and used for reporting purposes.
I strongly recommend not to bother with 1 cent diff.
If it happens many times you may check with BaaN and get a basic fix for the program that causes the problem.
Moshe Almog