Accounting mailing list archives

accounting@odoo-community.org

Avatar

Re: Financial Reports

by
Elico Corp, Eric Caudal
- 16/05/2016 02:56:37
Hi Jordi,
I agree with you with the following addition: most of my small customers need a simplified cashflow statement which is a mix of AR+AP+liquidity beginning balance and calculation of the intermediate balance.
I don't know if this is part of the roadmap but it should notbe difficult to extend from the current AR/AP reports, mixing them group by currency and adding a line for liquidity + calculation of expected balance.

Anyway: good job overall :)
--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore) Odoo Gold Partner, best Odoo Partner 2014 for APAC
On 05/16/2016 06:22 AM, Jordi Ballester Alomar wrote:
<blockquote cite="mid:CALVkZEdgZ0dgUuP3QwttMsJ1QokBKCsGSGWWJD1_ccevGHOQUg@mail.gmail.com" type="cite">
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.

--
Jordi Ballester Alomar
CEO & Founder | Eficent

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


Reference