Purpose
This report provides a breakdown of all of the payments by deposit made (as determined using the Make Deposits feature in Control).
Information Structure
The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within:
- The Deposit's Journal Entry (Journal)
- The Payment (Payment)
- The Payment Method (PaymentAccount)
- The Payment GL Account (GLAccount)
- The Payment's Journal (Journal)
- The Order (TransHeader)
- The Customer (Account)
- The Employee (Employee)
- The GL (GL)
- The Division (EmployeeGroup)
Tables Accessed
~ Purpose | ~ Table | ~ Linkage Information | ~ Filter Information | ||||||
Make Deposit Entry | Journal as Deposit | Deposit.CompletedDateTime in {?ReportDateRange} | |||||||
Payment | Payment | Left Join Payment.DepositJournalID Deposit.ID | |||||||
Payment Journal | Journal | Left Join Journal.ID Payment.ID | Journal.IsSummary 0 | ||||||
Payment Method | PaymentAccount | Left Join PaymentAccount.ID Payment.PaymentAccountID | |||||||
Payment GL Account | GLAccount as PaymentGLAccount | Left Join PaymentGLAccount.ID Payment.BankAccountID | |||||||
Order | TransHeader | Left Join TransHeader.ID Journal.TransactionID | |||||||
Company | Account | Left Join Account.ID Journal.AccountID | |||||||
Employee | Employee | Left Join Employee.ID Journal.EmployeID | |||||||
Division | EmployeeGroup | Left Join Deposit.DivisionID EmployeeGroup.ID | ?Division_DivisionID -1 or ?Division_DivisionID Deposit.DivisionID |
Parameter and Filter Options
The following options need to be implemented to filter the data and/or provide information to reconfigure the report display:
||~ Description ||~ Parameter Name ||~ Data Type ||~ Default ||~ Data Filter ||~ Notes ||
Date Range | ?ReportDate | DateTime Range | 1/1/2011 - 2/1/2011 | Journal.CompletedDateTime between ?ReportDate | |||||||
Filter by Division | ?Division_DivisionID | Integer | -1 | ?Division_DivisionID -1 or Ledger.DivisionID ?Division_DivisionID | Use -1 for All | ||||||
Show Payment Details | ?ShowPaymentDetails | Boolean | False | Suppress Details |
Display and Group Fields
The filters selected must be displayed at the top of the report.
Group Header #1
||~ Category ||~ Item ||~ Field ||~ Notes ||
Group Header #1 | Division Name | Division: Division.DivisionName | |||||||
Group Header #2 | Deposit Date | Deposit.CompletedDateTime | |||||||
Deposit ID | Deposit.ID | ||||||||
Deposit Amount | Deposit.SummaryAmount | ||||||||
Detail | Payment Date | Deposit.CompletedDateTime | |||||||
Payment Method | PaymentAccount.AccountName | ||||||||
Payment GL Account | PaymentGLAccount.AccountName | ||||||||
Payment Amount | Deposit.SummaryAmount | ||||||||
Company | Account.CompanyName | ||||||||
Order Number | TransHeader.OrderNumber | ||||||||
Order Description | TransHeader.Description | ||||||||
Group Footer #2 | Deposit Amount | Deposit.SummaryAmount | Shown in bold red letters if Sum(Payment Amount) Deposit Amount, otherwise suppressed. | ||||||
Payment Total | Sum(Payment Amount) | ||||||||
Group Footer #1 | Total | Sum(Deposit Amount) |
Group By
The following group by options should be supported:
||~ Description ||~ Level ||~ Optional ||~ Group ID field ||~ Group Display Field ||~ Notes ||
Division | 1 | No | Deposit.DivisionID | EmployeeGroup.DivisionName | |||||||
Deposit ID | 2 | No | Deposit.ID | Deposit.ID |
Sort Options
The result set is always be sorted by these fields:
||~ Description ||~ Sort Text ||~ Level ||~ Optional ||~ Notes ||
Division | EmployeeGroup.DivisionName | 1 | No | ||||||
Deposit ID | Deposit.ID | 2 | No |
There are no user defined sort options in this report.
Export
The report data should export into clean comma-delimited/Excel data.
Backlinks