Charge in shipment and invoice line is duplicated on print output if charge name is translated

Description

If the name of a charge is translated the corresponding line in shipment receipt and invoice is duplicated (2 other languages additional to base language activated) in the print output.

If name for all languages is equal, shipment and invoice is printed correct.

It seems that the ...line_vt view does not restrict select on c_charge_trl to just one language.

Environment

None

Activity

Carlos Ruiz

August 6, 2016 at 8:48 PM

Solved in https://idempiere.atlassian.net/browse/IDEMPIERE-3150#icft=IDEMPIERE-3150

Daniel Tamm

March 24, 2016 at 8:36 AM

(edited)

The problems are the c_charge_trl joins in the views c_invoice_linetax_vt and m_inout_line_vt

It currently looks like

LEFT JOIN c_charge_trl ct ON il.c_charge_id = ct.c_charge_id

but it should look like

LEFT JOIN c_charge_trl ct ON il.c_charge_id = ct.c_charge_id AND uomt.ad_language::text = ct.ad_language::text

I found this problem in my own customized jasper invoices which uses the view c_invoice_linetax_vt so I can't tell you exactly how you can reproduce, but you must have at least two translations of a charge for the problem to occur.