# Differences

This shows you the differences between two versions of the page.

 — gl_listing_report_standard [2019/01/17 09:04] (current) Line 1: Line 1: + Purpose + + + + This report provides the GL information for an particular Order, Customer, Activity Type, GL Account, or time-period. ​ This information is provided in + + + + Information Structure + + + + The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: + * The GL Entries (Ledger). + * The GL Account (GLAccount) + * The Order (TransHeader) + * The Customer (Account) + * The Activity (Journal) + * The Division (EmployeeGroup) + + + + Tables Accessed + + + + ||~ Purpose ||~ Table ||~ Linkage Information ||~ Filter Information || + || GL Entries || Ledger ||  || Ledger.OnBalanceSheet ​ 1 or ?​ShowOffBalanceSheet ​ 1 || + || GL Account || GLAccount || **Left Join** Ledger.GLAccountID ​ GLAccount.ID || ?​GLAccount_GLAccountID ​ -1 or GLAccount.ID ​ ?​GLAccount_GLAccountID || + || Order || TransHeader || **Left Join** Ledger.TransactionID ​ TransHeader.ID || ?​Order_OrderID ​ -1 or TransHeader.ID ​ ?​Order_OrderID || + || Customer || Account || **Left Join** Ledger.AccountID ​ Account.ID || ?​Customer_CustomerID ​ -1 or AccountID.ID ​ ?​Customer_CustomerID || + || Activity || Journal || **Left Join** Ledger.JournalID ​ Journal.ID || ?​ActivityTypeText in ("",​ "​All"​) or Journal.ActivityTypeText ​ ?​ActivityType || + || Division || EmployeeGroup || **Left Join** Ledger.DivisionID ​ EmployeeGroup.ID || ?​Division_DivisionID ​ -1 or ?​Division_DivisionID ​ Ledger.DivisionID || + Important Display Fields \\ The filters selected must be displayed at the top of the report. \\ * Division: Division.DivisionName \\ * Company: Account.CompanyName \\ * Order Number: ​ TransHeader.OrderNumber \\ * GL Account: GLAccount.AccountName \\ * Showing Off  \\ If the filter is not applied, suppress that section. \\  Summary Fields ​ \\ ||~ Item ||~ Field ||~ Notes || + || GL Account || GLAccount.AccountName || *Required Grouping Field || + || Total || Sum(Ledger.Amount) || not displayed directly || + || Debit || || Total is displayed in the Debit column if Total > 0 || + || Credit || || -(Total) is displayed in the Credit Column if Total < 0 || + || On B/S || Ledger.OnBalanceSheet || *Required Grouping Field \\ If OnBalanceSheet ​ True, Display ""​ else Display "​No" ​ || + ​Detail Fields ​ \\ The detail rows are suppressed if the ?​ShowSummaryOnly parameter is set to true (1).  Ideally, even when suppressed, this information would be exposed on drill down. \\ ||~ Item ||~ Field ||~ Notes || + || Entry Date || Ledger.EntryDateTime || || + || Order || TransHeader.OrderNumber || || + || Company || Account.CompanyName || ||  \\ || Activity Type || Journal.ActivityTypeText || ||  \\ || GL Account || GLAccount.AccountName || || + || Debit || Ledger.Amount || Suppressed if Ledger.Amount > 0 || + || Credit || -Ledger.Amount || Supppressed if Ledger.Amount ​ 0 || + || Net Credit || -Sum(Ledger.Amount) || Supppressed if Sum(Ledger.Amount) ​