View source | View content page | Page history | Printable version   

Projects:Payment Aging Balance/User Documentation

Contents

Aging Balance Report - User documentation

Overview

Purpose

This is a module named "Aging Balance Report" that provides a report which shows the past due receivables and payables as of the date the user selects.

Source

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

Reports

Two menu entries are created. One for Receivables, called Receivables Aging Inquiry, and another one for Payables, Payables Aging Inquiry.

These two reports can be found in the following application path: Financial Management // Receivables & Payables // Analysis Tools

Multi-currency

This report supports multicurrency.

Filters

FiltersAging.png

HTML/PDF output

Receivables Aging Schedule

It should Display a table showing the following data (Similar for Payables)

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 (Similar for Payables) By clicking on the PDF or the XML link, either a PDF or a xml 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

PDF and Excel output

The above output can be displayed in PDF or spreadsheet formats.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Payment_Aging_Balance/User_Documentation"

This page has been accessed 12,871 times. This page was last modified on 24 December 2014, at 15:26. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.