Community mailing list archives

community@mail.odoo.com

Re: Get Invoice of an account voucher

by
CAYLEY CONSULTING, Omar OUHARI
- 11/29/2015 17:14:56
Hello,

thanks for your quicly replay.
I did this sql query:

Query1 = SELECT a.reconciliation_id FROM account_move_line a, account_voucher b WHERE b.move_id=a.move_id AND reconciliation_id IS NOT NULL
l
Query2 = SELECT move_id FROM account_move_line WHERE move_id IN (Query1 )

Query3 = SELECT id as invoice_id FROM account_invoice WHERE move_id in (Query2) 

But I couldn't find no invoice_id.


Omar OUHARI
Consultant IT
Tel : + 212.6.77.55.20.23

2015-11-29 20:47 GMT+00:00 Steinfeld, Maik (Intero Technologies) <M.Steinfeld@intero-technologies.de>:
Account.voucher is generated from payment. Move line for payment is linked in account.voucher line. This move line should habe reconcile_ID or partial_reconcile_id. In system there is another move line with same reconcile_ID. This is the move which is linked in invoice.

Intero Technologies GmbH
Maik Steinfeld
Heinrich Heine Ring 76
18435 Stralsund

Von: Omar Ouhari <omar.ouhari@gmail.com>
Gesendet: 29.11.2015 9:38 nachm.
An: Community
Betreff: Get Invoice of an account voucher

Hello,

I have a list of an account voucher (ids) and I want to get for every couhcer the invoice which generate it.
I couldn't find the invoice id in the account voucher object.
Is there any idea to get the invoice id from account voucher object ?

Thanks.


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe