-   Finance, Invoicing and Integration (
-   -   SQL Help tfgld008 (

jojanna 4th July 2017 12:21

SQL Help tfgld008
I am trying to create a SQL query from Baan table tfgld008 (Trial Balance) to pull out the ledger account, opening balances, closing balances etc. When I run select * from baandb.ttfgld008 it just gives me the ledger and description etc with no amounts. How do I go about pulling through all the balances? I can see the details in table tfgld3501s000 (Ledger History) but the attributes all revert back to tfgld008.
Any help would be much appreciated….I am very very new to SQL.

bhushanchanda 5th July 2017 14:51

Welcome to the board.

The values being displayed are just form fields. The original values are calculated using business logic.

You use data in tables - tfgld201,tfgld202,tfgld202....212 for getting the required values.

All times are GMT +2. The time now is 14:20.

©2001-2017 - -