Printing Accounts in Arrears

Overview

Use this job aid to print the A/R Aging Analysis sorted by name id number and location code. The A/R Aging Analysis report does not print sub-totals. The report prints name id, document location code, name id description, prepaid balance, payments on hold, current balance, age category 1 - 6 balance, and the account balance.

To print an account in arrears:

1. From the Toolbar, click ACR for Accounts Receivable.
2. From the Accounts Receivable menu, select Report Manager , and then select A/R Balance Reports.
3. Select Print A/R Balance Reports.
4. Select A/R Aging Analysis - By Name Id Number.
5. In the Name Id Number Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the name id, or type the name id number range you want to print. Leave blank to print all name id’s.
6. In the Location Code Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the location code, or type the location code range you want to print. Leave blank to print all locations.
7. In the Name Id Description Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the name id, or type the name id description range you want to print. Leave blank to print all name id’s.
8. In the Name Id Type Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the name id type, or type the name id type range you want to revise. Leave blank to print all name id types.
9. In the Credit Rating boxes, click Lookup or type * and press Enter, and then select the name id type, or type the name id type range you want to revise. Leave blank to print all name id types.
10. In the 1099 Required boxes, click Lookup or type * and press Enter, and then select the name id type, or type the name id type range you want to revise. Leave blank to print all name id types.
11. In the Pay Paytronage? boxes, click Lookup or type * and press Enter, and then select the name id type, or type the name id type range you want to revise. Leave blank to print all name id types.
12. In the Collection Lisa boxes, click Lookup or type * and press Enter, and then select the name id type, or type the name id type range you want to revise. Leave blank to print all name id types.
13. In the Misc. Field #5 Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the miscellaneous field, or type the miscellaneous field range you want to print, or leave blank to print all.
14. In the Statement-Type Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the statement, or type the statement range you want to print. Leave blank to print all. NOTE: This is a user-defined misc field. The title for your field may be different.
15. In the Reserved Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the name id, or type the credit limit range you want to print. Leave blank to print all. NOTE: This is a user-defined misc field. The title for your field may be different.
16. Click OK.
17. In the boxes on this window, type an option - 0 for all values, 1 for equal to, 2 for not equal to, or 3 for greater than, 4 for greater than or equal to, 5 for less than, or 6 for less than or equal to. Leave blank to print all values.
18. Click OK.
19. In the Name Id Number and Location Code boxes, type a subtotal option - 0 for no subtotals, 1 for subtotal this level, 2 for new page this level, or 3 for subtotal and new page.
20. In the Legend Line box, type a description of what options you selected to print this report.
21. In the Print Activity Detail? box, type Yes to print detail, or type N to eliminate detail from the report.
22. In the Print Grand Total Information? box, type Yes to print grand total information, or type N to eliminate the grand total information from the report.
23. In the Replace Name Id? with Alternate Name Id box, type Yes to print the alternate name id on the report, or type N to print the name id on the report.
24. Click OK.
25. In the Amount Due Calculation Date box, type a date to calculate the cash amount due. Leave the box blank to print the entire account balance on the report.
26. In the Print Accounts with Zero Balance? box, type Y to include accounts with zero balances on the report, or type no to exclude accounts with a zero balance.
27. In the Calculate G/L Reconciliation Balance? box, type Y to open a window for specifying the date to calculate balances. The transactions are subtracted in reverse sequence from the balance to determine the balance on a specific historical date, or type N to exclude the G/L calculations.
28. In the Print Invoice/Payment Detail? box, type Y to include detail information if print positions are defined, or type N to omit detail information.
29. In the Print Customer Contact Information? box, type Y to print contact detail information, or type N to omit contact information.
30. Click OK.
31. In the Printer box, type the number associated to the place you want your report to print.
32. In the Print Type box, type the number associated to the characters per inch to print the report in.
33. In the Copies box, type the number of copies of the report you want to print.
34. In the Pages From and To boxes, type the page number range you want to print the report for. Leave the boxes blank to print all pages.
35. Click OK.

Learn more about Credit Management feature:

• Performing an Account Balance Inquiry
• Checking Available Credit
• Revising Credit Limits
• Printing Accounts in Arrears
• Historical Balances in Credit Management
• Credit Management Multiple Period Definitions
• Credit Management Notes - Setup & Use