Differences
This shows you the differences between two versions of the page.
deposits_made_report_standard [2019/01/17 09:04] |
deposits_made_report_standard [2019/01/17 09:04] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | 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' | ||
+ | * The Payment (Payment) | ||
+ | * The Payment Method (PaymentAccount) | ||
+ | * The Payment GL Account (GLAccount) | ||
+ | * The Payment' | ||
+ | * 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 {? | ||
+ | || Payment || Payment || **Left Join** Payment.DepositJournalID | ||
+ | || Payment Journal || Journal || **Left Join** Journal.ID | ||
+ | || Payment Method || PaymentAccount || **Left Join** PaymentAccount.ID | ||
+ | || Payment GL Account || GLAccount as PaymentGLAccount || **Left Join** PaymentGLAccount.ID | ||
+ | || Order || TransHeader || **Left Join** TransHeader.ID | ||
+ | || Company || Account || **Left Join** Account.ID | ||
+ | || Employee || Employee || **Left Join** Employee.ID | ||
+ | || Division || EmployeeGroup || **Left Join** 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 || ? | ||
+ | || Show Payment 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) | ||
+ | ||^ || 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/ | ||
+ | |||
+ | |||
+ | |||
+ | Backlinks | ||
+ | * [[include_componentbacklinks|include component" | ||