Ageing Formats
This article provides an overview of the ageing formats used through the various reports. It is possible for the user to control the Ageing Formats by creating them in Epicor using the Codes displayed in the table below. The Ageing formats are company specific and so it is possible to have a distinct format in each company.
If none of the below Formats are created in a company than the reports will use the below default values. Use the Aging Report Format screen to create the records
| Report | Code | Description | Type | First Label | AgeDays1 | AgeDays2 | AgeDays3 | AgeDays4 | AgeDays5 |
| Finance | BSKYAP | Accounts Payable Invoices | Value | 0 | 30 | 60 | 90 | 120 | |
| Label | Future | Current | Over30 | Over 60 | Over 90 | Over 120 | |||
| Finance | BSKYAR | Accounts Receivable Invoices | Value | 0 | 30 | 60 | 90 | 120 | |
| Label | Future | Current | Over30 | Over 60 | Over 90 | Over 120 | |||
| Sales | BSKYSHP | Customer Shipments (On Time Delivery) | Value | 0 | 7 | 14 | 21 | 28 | |
| Label | Early | On Time | Up To 1 Week | 2 To 3 Weeks | 3 To 4 Weeks | Over 4 Weeks | |||
| Sales | BSKYOVER | Overdue Sales Orders | Value | 7 | 14 | 30 | 60 | 90 | |
| Label | Less Than a Week | Up To 2 Weeks | Up To 30 Days | Up To 60 Days | Up To 90 Days | Over 90 Days | |||
| Sales | BSKYOPOR | Open Sales Order Pipeline | Value | 7 | 14 | 21 | 42 | 54 | |
| Label | Week 1 | Week 2 | Week 3 | Week 4 - 6 | Week 6 - 8 | Week 9+ | |||
| Production | BSKYPROD | Job Operation Ageing (Production Attainment) | Value | 0 | 7 | 14 | 21 | 28 | |
| Label | Early | On Time | Up To 1 Week | 2 To 3 Weeks | 3 To 4 Weeks | Over 4 Weeks | |||
| Production | BSKYPROV | Jobs Overdue | Value | 7 | 28 | 56 | 84 | 112 | |
| Label | Week 1 | Week 2 - 4 | Week 4 - 8 | Week 8 - 12 | Week 12- 16 | Week 16+ | |||
| Material Management | BSKYRCV | PO Receipts (On Time Delivery) | Value | 0 | 7 | 14 | 21 | 28 | |
| Label | Early | On Time | Up To 1 Week | 2 To 3 Weeks | 3 To 4 Weeks | Over 4 Weeks | |||
| Material Management | BSKYPART | Stock Ageing | Value | 7 | 30 | 90 | 185 | 365 | |
| Label | Last Week | Last 30 Days | Last 90 Days | Last 6 Months | Last Year | Over 1 Year | |||
| Material Management | BSKYPURO | PO Releases Overdue | Value | 0 | 7 | 14 | 21 | 28 | |
| Label | Not Overdue | On Time | Up To 1 Week | 2 To 3 Weeks | 3 To 4 Weeks | Over 4 Weeks |