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