web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Difference between vr_...
Microsoft Dynamics SL (Archived)

Difference between vr_01620 view and GLTran select statement

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Barry Flynn Profile Picture
    Barry Flynn 3,090 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans