DBD: AR Ageing - Open Invoice Report

DBD: Accounts Receivable - AR Ageing And Open Invoice Report

🔵 Overview There are a few fields to bring to your attention.

A/R Open Invoice Report - ARGRAS

Option Field: In many cases, this is set to Normal, but if you are in the practice of printing this report for invoices over a certain date, then when you enter an A here, if any customer has invoices (say over 30 days), this will trigger the system to print all invoices for this customer.
Age As of: Important so your invoices fall in the right column. You can always look at your customer credit analysis screen to see the last time the invoices were aged.
If printing by period, make sure it is current. You also can blank out the year/period.
Invoice to Report: Use Drop Down for either all or only invoices older than a certain period.
Post Aged Balance to Cust Master: This option updates the data in the customer credit analysis screen, you should only check this field if you are printing all invoices or only Current and Older

There are two different ways to update your ageing.

Answer the question here when printing the AR open invoice report.
Utility designed for this: AR, Setup, System, Utilities, Rebuild AR files, Re-age Customer Master from O/I - you would just enter the desired date and click proceed.

💡 Note: If you are a company that will print Customer Statements, you should always have a current ageing before Statements are printed.

Frequently Asked Questions

Q: What does the Option field do on the AR Open Invoice Report?

A: In many cases, this is set to Normal, but if you are in the practice of printing this report for invoices over a certain date, then when you enter an A here, if any customer has invoices (say over 30 days), this will trigger the system to print all invoices for this customer.

Q: Why is the Age As Of field important?

A: It's important so your invoices fall in the right column. You can always look at your customer credit analysis screen to see the last time the invoices were aged.

Q: What should I check if I'm printing by period?

A: Make sure it is current. You also can blank out the year/period.

Q: What does the Invoice to Report field control?

A: Use the drop down for either all invoices or only invoices older than a certain period.

Q: When should I check Post Aged Balance to Cust Master?

A: This option updates the data in the customer credit analysis screen. You should only check this field if you are printing all invoices, or only Current and Older.

Q: How can I update my AR ageing?

A: There are two different ways: (1) Answer the question here when printing the AR open invoice report, or (2) use the utility designed for this — AR, Setup, System, Utilities, Rebuild AR files, Re-age Customer Master from O/I — enter the desired date and click proceed.

Q: Do I need a current ageing before printing customer statements?

A: Yes. If you are a company that will print Customer Statements, you should always have a current ageing before Statements are printed.

Tags: accounts-receivable, ar-ageing, open-invoice-report, customer-statements, DB-distributor