Infor LX & BPCS Finance Tip: AR Aging

An ACR system parameter allows you to specify whether to measure invoice age from the date on which you create the invoice, invoice date, or the date on which the invoice is due. You can set up a separate terms code for each customer on the system to set the basic terms of payment for that customer. For example, this term could specify the number of days an invoice can be due before it is considered past due and the number of days that a discount is available. The system uses the terms code data to calculate invoice due dates and uses system parameter information to age invoices. Whichever date you specify Accounts Receivable | Run Instructions | 27 ACR Overview to measure invoice age from, the age of an invoice is defined as the number of days between that date and the current processing date.

You also use the Accounts Receivable System Parameters program, ACR820D, to establish five generic aging buckets for your receivables. To determine the time length for each of these buckets, specify the number of aging days for each bucket. The number of aging days aging is the difference between the invoice aging date and the current processing date. You can set the time periods and assign names to each bucket according to your needs.

Each time you generate any of the receivable Trial Balance reports, the system recalculates the age of every invoice. If you use calendar months as financial periods, change the bucket definitions each month to reflect the appropriate 1-month bucket, 2-month bucket, and so on. If you use an aging system based on days, like the one described in the preceding paragraph, you do not need to change the bucket definitions.

Note that you can process future dated invoices if you use a negative age bucket and specify negative aging days.

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author Facebook page Twitter Linked In YouTube Website