We're updating the issue view to help you get more done. 

Exception with table alias in virtual columns (only for views)

Description

Alias in virtual columns (only on views) cannot be used when view has translation (e.g. M_InOut_Line_v, M_InOut_Line_vt) and is used for print format. Cannot use M_InOut_Line_v alias because M_InOut_Line_vt view is used in query by idempiere.

Error: missing FROM-clause entry for table "M_InOut_Line_v"

STEPS TO REPRODUCE:
1. Create virtual column on M_InOut_Line_v (columnSQL=SELECT UPC FROM M_Product WHERE M_Product_ID=M_InOut_Line_v.M_Product_ID)
2. Add this line to random Print Format which uses M_InOut_Line_v
3. Run report with previous Print Format when you are logged with non system language or set Language on BPartner to language Spanish (M_InOut_Line_vt table has to be used in query)

PS: Log and ScreenShot are based on view DD_Order_Line_v

Environment

None

Status

Assignee

Hiep Lq

Reporter

Tomáš Švikruha

Labels

Tested By

None

Priority

Major