Just wanted to add to this, in case anyone ever searches on it...
glopnbal and glperbal both have balances stored in them.
thanks again for your help Brian.
________________________________
From: Tony Hughes <thughes281@...>
To: vantage@yahoogroups.com
Sent: Thu, July 1, 2010 12:35:57 PM
Subject: Re: [Vantage] tables used in General Ledger report
That's the one, thank you! glperbal had the data I'd been looking for.
________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Thu, July 1, 2010 11:17:51 AM
Subject: RE: [Vantage] tables used in General Ledger report
It doesn't map to a real table. GLPerBal (period balance) is sort of analogous
but not really, but I think its built on the fly for the report and contains the
sum of the credits and debits for each GLAccount for the selected date
range/period.
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tony
Hughes
Sent: Thursday, July 01, 2010 12:09 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] tables used in General Ledger report
thank you Brian,
in the report data def for that report there's a "header" table and a "detail"
table (I love developers who think alias and obfuscate are synonyms)
The detail table, for sure, I agree is gljrndtl...
but I cannot figure out what the header table is from. I thought "gljrnhed"
sounded good, but that table has only a couple entries and neither are telling
me what I'm looking for.
basically, the results on the GL report do not match the sum of specific
gljrndtl entries, that's what we're trying to determine.
________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Thu, July 1, 2010 10:23:16 AM
Subject: RE: [Vantage] tables used in General Ledger report
GLJrnDtl is where the action is at.
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Thursday, July 01, 2010 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] tables used in General Ledger report
Does anyone know which actual physical tables are the source for the
report data
in the "General Ledger" crystal report?
Thank you,
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
glopnbal and glperbal both have balances stored in them.
thanks again for your help Brian.
________________________________
From: Tony Hughes <thughes281@...>
To: vantage@yahoogroups.com
Sent: Thu, July 1, 2010 12:35:57 PM
Subject: Re: [Vantage] tables used in General Ledger report
That's the one, thank you! glperbal had the data I'd been looking for.
________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Thu, July 1, 2010 11:17:51 AM
Subject: RE: [Vantage] tables used in General Ledger report
It doesn't map to a real table. GLPerBal (period balance) is sort of analogous
but not really, but I think its built on the fly for the report and contains the
sum of the credits and debits for each GLAccount for the selected date
range/period.
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tony
Hughes
Sent: Thursday, July 01, 2010 12:09 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] tables used in General Ledger report
thank you Brian,
in the report data def for that report there's a "header" table and a "detail"
table (I love developers who think alias and obfuscate are synonyms)
The detail table, for sure, I agree is gljrndtl...
but I cannot figure out what the header table is from. I thought "gljrnhed"
sounded good, but that table has only a couple entries and neither are telling
me what I'm looking for.
basically, the results on the GL report do not match the sum of specific
gljrndtl entries, that's what we're trying to determine.
________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Thu, July 1, 2010 10:23:16 AM
Subject: RE: [Vantage] tables used in General Ledger report
GLJrnDtl is where the action is at.
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Thursday, July 01, 2010 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] tables used in General Ledger report
Does anyone know which actual physical tables are the source for the
report data
in the "General Ledger" crystal report?
Thank you,
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]