Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th July 2017, 12:21
jojanna jojanna is offline
Newbie
 
Join Date: Jul 2017
Posts: 1
jojanna is on a distinguished road
Baan: Baan V - DB: None - OS: Windows
SQL Help tfgld008
Baan: Other/Unknown

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.
Reply With Quote
Sponsored Links
  #2  
Old 5th July 2017, 14:51
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
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.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11
SQL Trace mraja71 Tools Development 2 5th November 2002 15:41
A powerful SQL worksheet with edit capability halvorn Third Party Products 0 28th February 2002 08:37


All times are GMT +2. The time now is 02:25.


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