View source | Discuss this page | Page history | Printable version   

Receivables Aging Schedule

Contents

Availability

Bulbgraph.png   This feature is available starting from 3.0PR17Q2.

To get this feature in previous Openbravo 3 versions you must install the external module Aging Balance Report from the Module Management window.

Overview

The report shows the past due receivables as of the date the user selects.

Source of Information

The source of the information for this report is invoices as the origin of the receivables and the payables.

Multi-currency

This report supports multicurrency.

Filters

FiltersAging Receivables Core2.png

HTML/PDF/Excel output

The report can be generated in HTML, PDF and Spreadsheet format.

Receivables Aging Schedule

It should Display a table showing the following data:

If the credits are posted in the same account as the Receivables, then the Net would match the balance of the Business Partner. If the credits are posted in a different account, such as prepayments, then the balance of the Business Partner would match with the Total.

If the Show Doubtful Debt check is selected, two more fields are shown.

Also, when Show Doubtful Debt is selected, the Total amount is the sum of all the debts that are not doubtful. Therefore, the Net is Total + Doubtful - Credits

OutputAging.png

Receivables Aging Schedule Details

It should Display a table showing the following data: By clicking on the PDF or the XLS link, either a PDF or a spreadsheet file are generated.

The information is grouped by Business Partner, in case there report is run for more than one. For each Business Partner the information shown is:

If the credits are posted in the same account as the Receivables, then the total Net Due would match the balance of the Business Partner. If the credits are posted in a different account, such as prepayments, then the balance of the Business Partner would match with the total Net Due plus the Credits (undoing the subtraction of the credits to the total).

Plus, there is a summatory line for all the Business Partners.

If the Show Doubtful Debt check is selected, two more fields are shown.

Also, when Show Doubtful Debt is selected, the Total amount is the sum of all the debts that are not doubtful. Therefore, the Net Due is Total + Doubtful - Credits

OutputAgingTrhee.png


Back button.png   Back to Financial Management

Retrieved from "http://wiki.openbravo.com/wiki/Receivables_Aging_Schedule"

This page has been accessed 4,197 times. This page was last modified on 1 September 2020, at 05:07. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.