Accounting mailing list archives

accounting@odoo-community.org

Avatar

Re: Financial Reports

by
RU3IX PTY LTD., Naran Moturi
- 16/05/2016 07:43:44
+1

We have developed customer statement based on open invoices (shown as below), however, customer statement could be two types :- Activity statement for a given period (Partner Ledger - but with properly presentable format) and statement with outstanding invoices at a given period.

Inline image 1
Also, we have developed customer outstanding invoices view at partner form level , to give user a quick view of outstanding balances, similar to follow-up view but in easily readable format, follow-up view is quite hard to understand if invoices has partial payment allocations

Inline image 2

-Naran

On Mon, May 16, 2016 at 8:22 AM, Jordi Ballester Alomar <jordi.ballester@eficent.com> wrote:
Dear OCA accounting experts,

During and after the Sorrento code sprint I've been thinking and working on the following reports:
  • Partner Balance
  • Partner Ledger
  • Open Invoices
  • Partner Aging
The report "Open Invoices" in v8 looks much like the Partner Ledger, and the work that was done in Sorrento was heading towards this direction, showing debit, credit, balance,... However this does not make sense to me at all, because this is reproducing the Partner Ledger. 

IMHO there should be the following reports:
  • Partner Ledger
  • Partner Balance - summary of Partner Ledger
  • Partner Aging
  • Partner Aging Balance - - summary of Partner Aging

The Partner Aging should really reflect what are the Accounts Receivable and Accounts Payable move lines that have due amounts at a given date, and should tell, at that date, what is/was the due amount, when it is due, and the accumulated totals by partner and currency. Even should show a break down by number of days due.

The Partner Aging Balance should just be a summation of the Partner Aging at the partner level, but showing the same information.

Find attached the proposed report, as it is being implemented here (still called open invoices in the code):

Important remark: The current code supports the computation of the AR/AP items due and the due amount, at the date provided in the report, which is a significant improvement over the standard reports of Odoo v9.

Please let me know your thoughts.

--

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


Reference