Menu
▾
▴
#1189 Broken Report - MultiLevel BOM & Formula Detail
closed-fixed
5
2008-05-28
2008-04-23
No
Report - MultiLevel BOM & Formula Detail
is throwing this error:
===========> DataEngine.loadPrintData: null - ERROR: column rv_pp_product_bomline.implotion does not exist
SQL=SELECT RV_PP_Product_BOMLine.Levels,(SELECT M_Product.Value||' - '||M_Product_Trl.Name FROM M_Product INNER JOIN M_Product_TRL ON (M_Product.M_Product_ID=M_Product_Trl.M_Product_ID AND M_Product_Trl.AD_Language='es_MX') WHERE RV_PP_Product_BOMLine.M_Product_ID=M_Product.M_Product_ID) AS AM_Product_ID,RV_PP_Product_BOMLine.M_Product_ID,RV_PP_Product_BOMLine.IsQtyPercentage,B.Name AS BName,RV_PP_Product_BOMLine.IssueMethod,RV_PP_Product_BOMLine.QtyBOM,RV_PP_Product_BOMLine.QtyBatch,(SELECT C_UOM_Trl.Name FROM C_UOM INNER JOIN C_UOM_TRL ON (C_UOM.C_UOM_ID=C_UOM_Trl.C_UOM_ID AND C_UOM_Trl.AD_Language='es_MX') WHERE RV_PP_Product_BOMLine.C_UOM_ID=C_UOM.C_UOM_ID) AS CC_UOM_ID,RV_PP_Product_BOMLine.C_UOM_ID,RV_PP_Product_BOMLine.Scrap FROM RV_PP_Product_BOMLine LEFT OUTER JOIN AD_Ref_List XB ON (RV_PP_Product_BOMLine.IssueMethod=XB.Value AND XB.AD_Reference_ID=53226) LEFT OUTER JOIN AD_Ref_List_Trl B ON (XB.AD_Ref_List_ID=B.AD_Ref_List_ID AND B.AD_Language='es_MX') WHERE RV_PP_Product_BOMLine.M_Product_ID=145.0 AND RV_PP_Product_BOMLine.Implotion='N' AND RV_PP_Product_BOMLine.AD_Client_ID IN(0,11) AND RV_PP_Product_BOMLine.AD_Org_ID IN(0,11,12) AND XB.AD_Ref_List_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 104 AND AD_User_ID <> 100 AND IsActive = 'Y' ) ORDER BY RV_PP_Product_BOMLine.SeqNo [16]
Regards,
Carlos Ruiz
Logged In: YES
user_id=1769708
Originator: NO
In addition to the above error, the report is sent directly to the printer.
You cannot get a preview of the report.
Also the parameters for the report are not shown.
I will submit fixes soon.
Tony
Logged In: YES
user_id=332830
Originator: NO
Thank Carlos for report the bug, this is way that the community can contribute, so I am happy to help :-).
Kind regards
Victor Perez
www.e-evolution.com
Revision: 5166
http://adempiere.svn.sourceforge.net/adempiere/?rev=5166&view=rev
Author: vpj-cd
Date: 2008-05-11 21:50:38 -0700 (Sun, 11 May 2008)
Log Message:
-----------
fixed Broken Report - MultiLevel BOM & Formula Detail
http://sourceforge.net/tracker/?func=detail&atid=879332&aid=1949804&group_id=176962
Modified Paths:
--------------
trunk/base/src/org/eevolution/process/PrintBOM.java
Added Paths:
-----------
trunk/migration/350a-core/011_BF1949804_BrokenReportMultiLevelBOM.sql
trunk/migration/350a-core/postgresql/011_BF1949804_BrokenReportMultiLevelBOM.sql
Logged In: YES
user_id=1769708
Originator: NO
Victor,
The fix you provided in revision 5166 is not working.
Trunk will not compile, please see:
https://sourceforge.net/tracker/index.php?func=detail&aid=1962332&group_id=176962&atid=879332
I have a fix which I am currently testing and will commit soon.
Regards,
Tony
Logged In: YES
user_id=332830
Originator: NO
Hi Tony!
yes, here we have a issue the dependences the unique way to solve this issue is move the viewer to base or send the result direct to printer.
I will happy if Heng Sin Low can comment this post to find some possible solution.
Kind regards
Victor Perez
www.e-evolution.com
Logged In: YES
user_id=1769708
Originator: NO
Fixed with revisions 5171,5172,5173
Tony
Logged In: YES
user_id=1312539
Originator: NO
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).