Purpose



The report is used for printing //Historical// Accounts Receivable reports.  It is similar in look to the A/R Detail report, but the source of the A/Rs is the G/L records rather than the orders (since the orders may have changed).  It also does not break the A/Rs into their corresponding Ages.



Information Structure 



The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within:
  * GL
    * 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's contact information and not the contact information for the particular order.



Tables Accessed 



||~ **Purpose** ||~ **Table** ||~ **Linkage Information** ||~ **Filter Information** ||
|| GL Level || GL || || **Where GLAccountID  14** ||
|| Order Level || TransHeader || **Left Join** GL.TransactionID  TransHeader.ID || TransHeader.StatusID  3  ||
|| Company Info || Account || **Left Join** Account.ID  TransHeader.AccountID || ((?Account_AccountID  -1) or (?Account_AccountID  TransHeader.AccountID)) ||
|| Payment Terms || PaymentTerms || **Left Join** PaymentTerms.ID  Account.PaymentTermsID || ||
|| Contact Info || AccountContact || **Left Join** AccountContact.ID  Account.AccountingContactID ||   ||
|| Salesperson || Employee || **Left Join** Employee.ID  TransHeader.Salesperson1ID || {?Salesperson_EmployeeID}  -1 or {?Salesperson_EmployeeID}  TransHeader.SalespersonID ||
|| Division || EmployeeGroup || **Left Join** EmployeeGroup.ID  TransHeader.DivisionID || {?Division_DivisionID}  -1 or {?Division_DivisionID}  TransHeader.DivisionID  ||
Parameters 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 ||~ Type ||~ Default ||~ Data Filter ||~ Notes ||
|| Report Date || ?ReportDate_DateTime || DateTime || Today() || where GL.EntryDateTime > Salesperson: Jim Smith \\ >> Division: North Plant \\ >> Company: Smith Refineries \\ If the filter is set to -1, do not show the filter line in the header. \\ Display and Group Fields \\ Group Header #1 \\ ||~ Category ||~ Item ||~ Field ||~ Notes ||
|| 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 || ||
||^ || Current Order Total || TransHeader.TotalPrice || ||
||^ || ?ReportDate Balance Due || **Sum(GL.Amount) ** where GL.EntryDateTime