mlores
18th March 2011, 15:30
Hello to all

I would want the possibility somebody to comment which are the tables that contribute in generating the amount that comes out in the report of clients' balances for company (Session tfacr2434m000) in Baan IV c4.

For some reason the balance of a client in the control account (session tfacr2415m000), and the total balance of the account, is OK , the client's balance also specifies in the session tfacr2433m000 is OK also, even and when this balance is not requested until a date.

However, in this client, the balance in the session tfacr2434m000, has a difference in plus, that I'am not able to find in what table it is reflected.

To find it, would be necessary me to know which are all the tables that contribute to compose the value "Balance Invoices" that it is in the report tfacr2434m000.

Please, help me. Thanks.

hunehoek
8th April 2011, 11:53
I made a query with tables
- ttccom010100 (client-information),
- ttfacr200100 (sell - information)
The column t_cuno (client-number) is in both tables
I only give this information, because I'm Dutch. I can't make a long English story and I do'n't know if I understood the question right.

mlores
11th April 2011, 14:04
Thank You for Hunehoek and for RedBatz for her answers.
Boths are very goods. I solved the problem
Thank You again.

Gracias a Hunehoek y a RedBatz por sus respuestas. Ambas fueron muy buenas y logré resolver el problema.
Gracias de nuevo.

Estoy a su disposición, y del grupo.