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