AR Customer Payments Drilldown
You can use the AR Customer Payments Drilldown report to look up payment information for a customer and then drilldown to the invoices, which were paid. You can access this report by selecting .
The first level gives customer number, name, last invoice date and last payment date.
The second level gives more specific information on the month and transaction number of all the payments received from the customer including check number description, date, check date, a paid in full date if the invoice was paid in full, bank and account of deposit, and the check amount.
Level 3 gives transaction level details about the invoices that were paid on the payment transaction including transaction month and number, invoice number, transaction type, receivable type, description, invoice amount, amount applied, retainage pai. and discount taken.
Level 4 gives applied line level information with the line type description, invoice amount, applied amount, retainage amount and discount amount per line number.
Level 5 gives additional line level details including GL Company and account numbers, tax group, tax code, tax basis, tax amount, contract, contract item, units, unit of measure, retainage %, retainage amount, discount offered, discount taken.
|
Report Parameters |
Description |
|---|---|
|
Company |
Accept the default, or press F4 to select a company. |
|
Beginning Customer |
Press F4 to select the beginning customer for sorting. |
|
Ending Customer |
Press F4 to select the ending customer for sorting. |
|
Beginning Customer Sort Name |
Click the Field Lookup button or press F4 to select the Beginning Customer Sort Name |
|
Ending Customer Sort Name |
Click the Field Lookup button or press F4 to select the Ending Customer Sort Name |
|
Beginning Month |
Enter or select the applicable beginning month. |
|
Ending Month |
Enter or select the applicable ending month. |
|
Sort By Customer (S)ortName or (C)ontract |
Enter S or C |