Skip to content
logo Knowledgebase

How do I print Accounts Receivable statements for only past due invoices or customers?

Created on  | Last modified on 

Resolution

Solution: Add a condition based on the As of date prompt in the Print Selection window

  1. In Accounts Receivable, from the Reports menu, select the statement you wish to print.
  2. In the Data File Selection window, select the appropriate records and files.
  3. In the Statement of Account - Print Selection window, click [Conditions].
  4. If conditions already exist for the report the Condition Selection window appears.
  5. Click [Add] and then select AND as the connector in the Add Condition window.
  6. Under Field, select Due Date from the AR Transaction field list.
  7. Select Less or equal to for the Operator and, under Value, click List Items.
  8. Click [Index] and select Prompt Fields in the Item Value box.
  9. Click [OK].
  10. Select As of date and click [OK].
  11. Click [OK] in the Add Condition window and review the conditions in the Condition Selection window.
  12. Click [OK] and the statements will print only past due invoices based upon the As of Date.