Community mailing list archives
Re: Get Invoice of an account voucherby
CAYLEY CONSULTING, Omar OUHARI
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
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.
Tel : + 18.104.22.168.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
Heinrich Heine Ring 76
18435 StralsundHello,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.