Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit 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)