Differences

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

Link to this comparison view

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) ​