Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Finance, Invoicing and Integration (http://www.baanboard.com/baanboard/forumdisplay.php?f=5)
-   -   SQL Help tfgld008 (http://www.baanboard.com/baanboard/showthread.php?t=70178)

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.
:confused::)

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.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com