Skip to Content
Menu
This question has been flagged
5 Replies
3567 Views

Hello Team,

We needs the extract data from database for one of our customer for the partial of full paid invoice list.

Please provide query which i have to run to extract the data ?

Your help is appreciated

Rahul

Avatar
Discard

Provided that you are talking about OpenERP database to fetch from ,OpenERP already provides filter for the same and you may export those records.

Best Answer

Check this module. It will help. \https://www.odoo.com/apps/7.0/account_open_receivables_payables_xls/

Avatar
Discard
Best Answer

Rahul,

There is a boolean called PAID/reconcile on invoice and reconcile_id on AML which will simply separate paid/unpaid/partially paid invoices.

Thanks.

Avatar
Discard
Best Answer

You should look at https://www.odoo.com/apps/7.0/account_open_receivables_payables_xls/

This module adds the 'Open Receivables/Payables by Period' report to the Accounting Partners reports. The report is available in PDF and XLS format.

Avatar
Discard