The Invoice Aging and Order Aging windows are used to display an aged analysis of your open invoices and orders, as of the current date. The Aging windows are split pane windows that enable you to view open invoice and order amounts by aging period, as well as the invoice and order details that make up those amounts.
For historic or prior period aging reports, see Historic - Aged Receivables for more.
For order aging based on order dates vs. transaction dates, see Setting a Column Index for more.
Important! In order for your invoice aging to be accurate, you must reconcile your customer accounts. See Applying Payments to Open Invoices for more information.
The Invoice Aging window is a split pane window (3 panes). The top pane displays the customer account name and description, and the following six aging columns:
| Total Due At (current date) | Total open customer invoices as at the current date. |
| 0-30 days | Open customer invoices dated 0-30 days prior to the current date. |
| 31-60 days | Open customer invoices dated 31-60 days prior to the current date. |
| 61-90 days | Open customer invoices dated 61-90 days prior to the current date. |
| 91-120 days | Open customer invoices dates 91-120 days prior to the current date. |
| Over 120 days | Open customer invoices dated more than 120 days prior to the current date. |
The middle pane displays open invoices for the account and aging period that is active. For example, if you activate an amount in the 31-60 days column, the middle pane will display all invoices that contribute to that amount for that customer. The bottom pane displays details for the active invoice in the middle pane. In this way, you can quickly analyze all your outstanding invoices to customers.
NOTE: If the account Name or Description field is active, the middle pane will display the customer account ledger (e.g. all postings in the customer account).
Click NewViews/Account/Accounts Receivable in the NV2 Database Explorer.
If the top right window is not the Invoice Aging window, click the window list button at the left of the title bar that reads /ACCOUNT/AR and choose Invoice Aging.
In the top pane, activate any amount in any aging column to see the open invoices for that amount; the invoices are displayed in the middle pane. Activate any invoice in the middle pane to see the invoice detail in the bottom pane.
The Order Aging window is a split pane window (3 panes). The top pane displays the customer account name and description, and the following seven aging columns:
| All Orders | All orders, including orders dated in the future. |
| Total Orders At (current date) | Total orders as at the current date. |
| 0-6 days | Orders dated 0-6 days prior to the current date. |
| 7-14 days | Orders dated 7-14 days prior to the current date. |
| 15-21 days | Orders dated 15-21 days prior to the current date. |
| 22-28 days | Orders dated 22-28 days prior to the current date. |
| Over 28 days | Orders dated more than 28 days prior to the current date. |
The middle pane displays orders for the account and aging period that is active. For example, if you activate an amount in the 7-14 days column, the middle pane will display all orders that contribute to that amount for that customer. The bottom pane displays details for the active order in the middle pane. In this way, you can quickly analyze all your outstanding orders for customers.
NOTE: If the account Name or Description field is active, the middle pane will display the customer account ledger (e.g. all postings in the customer account).
Click NewViews/Account/Accounts Receivable in the NV2 Database Explorer.
If the top right window is not the Order Aging window, click the window list button at the left of the title bar that reads /ACCOUNT/AR and choose Order Aging.
In the top pane, activate any amount in any aging column to see the orders for that amount; the orders are displayed in the middle pane. Activate any order in the middle pane to see the order detail in the bottom pane.
If you want the invoice and order aging to be generated using a date other the current date, you can set an alternate date using the Report As Of Date field in Setting User Options.