Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Show:

Carlos Ruiz August 6, 2016 at 8:48 PM

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.

Carlos Ruiz November 18, 2013 at 2:51 AM

Hi Volker, I tried to reproduce the issue but didn't find how.

Can you please provide steps to reproduce? Or maybe attach a screenshot and configuration of language on client and business partner.

Regards,

Carlos Ruiz

Duplicate

Details

Assignee

Reporter

Affects versions

Priority

Created October 8, 2013 at 7:27 PM
Updated October 1, 2016 at 8:52 AM
Resolved August 6, 2016 at 8:48 PM