Differences
This shows you the differences between two versions of the page.
— |
ar_detail_report_standard [2019/01/17 09:04] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | Purpose | ||
+ | |||
+ | |||
+ | |||
+ | The report is used for Accounts Receivable management. | ||
+ | |||
+ | |||
+ | |||
+ | Information Structure | ||
+ | |||
+ | |||
+ | |||
+ | The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: | ||
+ | * Order (TransHeader) | ||
+ | * Company (TransHeader) | ||
+ | * A/P Contact Information (AccountContact) | ||
+ | * Payment Terms (PaymentTerms) | ||
+ | * Order Salesperson (Employee) | ||
+ | * Order Division (EmployeeGroup) | ||
+ | |||
+ | |||
+ | |||
+ | Note that, unlike the A/R summary, the Contact Information displayed here is the Company' | ||
+ | |||
+ | |||
+ | |||
+ | Tables Accessed | ||
+ | |||
+ | |||
+ | |||
+ | ||~ **Purpose** ||~ **Table** ||~ **Linkage Information** ||~ **Filter Information** || | ||
+ | || Order Level || TransHeader || || TransHeader.StatusID | ||
+ | || Company Info || Account || **Left Join** Account.ID | ||
+ | || Payment Terms || PaymentTerms || **Left Join** PaymentTerms.ID | ||
+ | || Contact Info || AccountContact || **Left Join** AccountContact.ID | ||
+ | || Salesperson || Employee || **Left Join** Employee.ID | ||
+ | || Division || EmployeeGroup || **Left Join** EmployeeGroup.ID | ||
+ | Parameters and Filter Options | ||
+ | || Division || ? | ||
+ | || Salesperson || ? | ||
+ | || Company || ? | ||
+ | || Report Title || ? | ||
+ | If any of these filters are //NOT// set to -1, then the filter information should be displayed in the right header of the first page, as in: \\ >> Salesperson: | ||
+ | || Group Header #1 || Division Name || Division: Division.DivisionName || || | ||
+ | || Group Header #2 || Company || Account.CompanyName || | ||
+ | ||^ || A/P Contact || AccountContact.FirstName + " " + AccountContact.LastName || || | ||
+ | ||^ || Credit Balance || Account.CreditBalance || || | ||
+ | ||^ || Phone || AccountContact.PrimaryNumber || || | ||
+ | ||^ || Payment Terms || PaymentTerms.TermsName || || | ||
+ | || Detail || Order Number || TransHeader.OrderNumber || || | ||
+ | ||^ || Sale Date || TransHeader.SaleDate || display in //short// date format (no time) || | ||
+ | ||^ || Age || Date() - cast(TransHeader.SaleDate as Date) || number of days since Sale || | ||
+ | ||^ || Description || TransHeader.Description || || | ||
+ | ||^ || Total Price || TransHeader.TotalPrice || || | ||
+ | ||^ || Current || Sum(TransHeader.BalanceDue) | ||
+ | ||^ || 0-30 || Sum(TransHeader.BalanceDue) | ||
+ | ||^ || Balance Due || Sum(TransHeader.BalanceDue) || || | ||
+ | || Group Footer #2 || Total Credits || Sum(Credit Balance Column) || || | ||
+ | ||^ || Total Current || Sum( Current Column ) || || | ||
+ | ||^ || Total 0-30 || Sum( 0-30 Column ) || || | ||
+ | ||^ || Total 31-60 || Sum( 31-60 Column ) || || | ||
+ | ||^ || Total 61-90 || Sum( 61-90 Column ) || || | ||
+ | ||^ || Total 91+ || Sum( 91+ Column ) || || | ||
+ | ||^ || Total Balance || Sum( Balance Due Column ) || || | ||
+ | || Group Footer #1 || Total Credits || Sum(Credit Balance Column) || || | ||
+ | ||^ || Total Current || Sum( Current Column ) || || | ||
+ | ||^ || Total 0-30 || Sum( 0-30 Column ) || || | ||
+ | ||^ || Total 31-60 || Sum( 31-60 Column ) || || | ||
+ | ||^ || Total 61-90 || Sum( 61-90 Column ) || || | ||
+ | ||^ || Total 91+ || Sum( 91+ Column ) || || | ||
+ | ||^ || Total Balance || Sum( Balance Due Column ) || || | ||
+ | Group By \\ The following groups are inserted in the report design: \\ ||~ **Description** ||~ **Level** ||~ **Optional** ||~ **Group ID field** ||~ **Group Display Field** ||~ **Notes** || | ||
+ | || Division || 1 || No || TransHeader.DivisionID || Division.DivisionName || || | ||
+ | || Company || 2 || No || TransHeader.AccountID || Account.Companyname || || | ||
+ | Sort Options | ||
+ | || Division || Division.DivisionName || 1 || No || || | ||
+ | || Company Name || Account.CompanyName || 2 || No || || | ||
+ | There are no user sort options for this report. | ||
+ | |||
+ | |||
+ | |||
+ | Export | ||
+ | |||
+ | |||
+ | |||
+ | The report data should export into clean comma-delimited/ | ||
+ | |||
+ | |||
+ | |||
+ | Test Cases | ||