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