Accounting mailing list archives

accounting@odoo-community.org

Avatar

Re: Financial Reports

by
Open Source Integrators, Gregory A Mader
- 16/05/2016 04:45:44
HI Jordi,

Yes, we are willing to share.  We have had all of this at our website for a year.  We have signed the paperwork for the OCA.  Nobody has asked us before.  :)

Let me get this together, and I will talk to Max and Balaji about moving it over. 

Greg


On Sun, May 15, 2016 at 6:53 PM, Jordi Ballester Alomar <jordi.ballester@eficent.com> wrote:
Hi Greg,

The customer or supplier statement that you show is great! It is a necessary communication tool between companies, because they can tell each other what is owed to/from them.

The Aging report that I was showing would follow the same concept, but for multiple partners and in table format. So both could coexist. Would you be willing to share your module?

Perhaps what I'm still lacking is an actionable tree view of the due list, where users would be able to:
  • Add follow-up notes (on each invoice, or overall for a customer/vendor, not sure), 
  • Initiate payment for one or several items.

Regards,
Jordi.








On Mon, May 16, 2016 at 1:08 AM, Gregory Mader <gmader@ursainfosystems.com> wrote:
Hi all,

Jordi, how close is this?  In the US, we would call this a "Customer statement", and there is usually an equivalent "Vendor statement".



Inline image 1

Another example

Inline image 2

On Sun, May 15, 2016 at 3:22 PM, 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




--



<img src="cid:image003.png@01CDFF9B.276ED0C0" alt="Ursa Information Systems" height="125" border="0" width="141">

Greg Mader - President 

Ursa Information Systems
1706 Plum Lane, Suite 127
Redlands, California, 92374

Office:     1-855-URSA ERP x 700
              1-855-877 2377 x 700
Mobile:   1-909-499-1126


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




--

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




--



<img src="cid:image003.png@01CDFF9B.276ED0C0" alt="Ursa Information Systems" height="125" border="0" width="141">

Greg Mader - President 

Ursa Information Systems
1706 Plum Lane, Suite 127
Redlands, California, 92374

Office:     1-855-URSA ERP x 700
              1-855-877 2377 x 700
Mobile:   1-909-499-1126


Reference