You’re offline. This is a read only version of the page.
Announcements
I want a GL transaction detail report, which will be used by an outside auditor.
I first exported the transaction detail from 01620a to Excel, but thought it would be easier to break up the results into monthly reports without headers or footers. A report cleanup for exporting data looked tedious, so I print previewed the report and in a separate window ran a query of the temporary report work table. The results of this query returns a field called VR_01620.Trans_Flag, which is created in the view statement. The values for this field are 'G' for posted GL entries, or 'A' which appears to represent accruals (?).
I went back and just did a select of the GLTran records for the same period. The totals of this select statement differs from the total 'G' entries from the VR_01620 view. Can someone provide an explanation of the difference between the Detail GL report view and the GLTran posted detail? I'm looking for which approach would be best to use as a data dump.
*This post is locked for comments
Brian
<< 01620a
I haven't seen an 01620a.
The standard Detail GL has two flavours - 01620 is "standard" and 01620MC is "multi currency".
<< VR_01620.Trans_Flag, which is created in the view statement.
<< The values for this field are 'G' for posted GL entries,
<< or 'A' which appears to represent accruals (?).
No.
Look at view vr_10620.
The first section sets the flag to G.
Lookk down to the Join & Where-clause & you'll see that it selects where "(t.Posted = 'P' AND t.Acct <> s.YtdNetIncAcct) "
In other words it excludes the YtdNetIncome acct, (which doesn't have any transactions.)
Now look at the second section which does a "union all".
This section sets the flag to A.
It includes the YtdNetIncome acct, as well as any (other) acct with no transactions.
So G appears to mean "normal account" and A appears to mean (mainly) YtdIncome. (Or any other acct with no transactions.)
Rather than getting into this extreme detail, have you considered running a Preview of the standard report.
Then from the Preview window, (via buttons at the top of the window) you can Export the report in various formats, including Excel.
Unless you think the standard report has a problem, that seems like a relatively easy way to export the report.
<< Can someone provide an explanation of the difference between the
< Detail GL report view and the GLTran posted detail?
You woudl need to select only where Posted = P, and PerPost fell within the period(s) you are reporting.
If you compated in total (rather than comparing individual accounts) you would need to be aware of special accounts like thr YtdIncome acct.
And that the report probably peints and totals Income/Liabilities as positives rather than negatives.
Hope those thoughts help.
Barry
#1
André Arnaud de Cal...
294,206
Super User 2025 Season 1
#2
Martin Dráb
232,968
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
