| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 387 |
| Technical Name |
lv_nova_ar_aging |
| License | OPL-1 |
| Website | https://www.luanviservices.com |
Accounts Receivable Aging Report
The essential credit control tool. Generate an AR aging report as of any date, see every outstanding invoice bucketed by how overdue it is, and quickly identify which customers need attention. Color-coded risk levels make it easy to prioritise collections.
📊 Classic aging grid
Current, 1-30, 31-60, 61-90, 91+ days — one row per customer, one column per bucket. Configurable bucket thresholds.
🎨 Risk colour coding
Green (OK), yellow (Warning), red (Critical) per customer based on the oldest outstanding bucket.
📄 Two-section PDF
Summary grid on page 1, then a full invoice-by-invoice drill-down per customer on subsequent pages.
📈 Distribution bar
A visual stacked bar shows what % of your total AR sits in each aging bucket at a glance.
Example aging grid
| Customer | Current | 1-30d | 31-60d | 61-90d | 91+d | Total | Risk |
|---|---|---|---|---|---|---|---|
| Acme Corp | $1,200 | $400 | — | — | — | $1,600 | 🟢 |
| Beta Ltd | — | $800 | $600 | — | — | $1,400 | 🟡 |
| Gamma Inc | — | — | $300 | $900 | $2,100 | $3,300 | 🔴 |
How to use
- Go to Accounting → Customers → AR Aging Report.
- Set the "As of" date (today by default), choose company and optionally filter customers.
- Adjust the bucket thresholds if needed (default: 30/60/90 days).
- Click Print PDF Report for the full document, or View Overdue Invoices to open the list.
Compatibility
Odoo 18.0 Community Enterprise Requires: Accounting / Invoicing
Technical notes
- Data source:
account.move.linewhereaccount_type = asset_receivable,state = posted,reconciled = False,amount_residual ≠ 0. - Overdue days are computed relative to the as of date, not today — useful for historical reporting.
- No new database tables — pure wizard-based computation.
- Risk thresholds: OK = oldest ≤ bucket_2, Warning = oldest ≤ bucket_3, Critical = oldest > bucket_3.
Support
For questions or bug reports, please use the support button on the App Store or email luanviservicesinfo@gmail.com.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 387 |
| Technical Name |
lv_nova_ar_aging |
| License | OPL-1 |
| Website | https://www.luanviservices.com |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module