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 1)
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

1)
?Account_AccountID -1) or (?Account_AccountID TransHeader.AccountID