0007264: Purchase Order -> Copy From Order does not find sometimes tax setup

Description

When you use this option from Purchase order, sometimes does not find the corresponding TAX, and it's ok setup.

Proposed Solution

I'va just upload two file. Anyway, I explain the lines midified:

You have to modify two files (attached):

File "src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder.java":
Replace the next line:

String strCTaxID = Tax.get(this, data[i].mProductId, DateTimeData.today(this), order[0].adOrgId, order[0].mWarehouseId.equals("")?vars.getWarehouse():order[0].mWarehouseId, CopyFromPOOrderData.cBPartnerLocationId(this, order[0].cBpartnerId), CopyFromPOOrderData.cBPartnerLocationId(this, order[0].cBpartnerId), order[0].cProjectId, true);

by

String strCTaxID = Tax.get(this, data[i].mProductId, DateTimeData.today(this), order[0].adOrgId, order[0].mWarehouseId.equals("")?vars.getWarehouse():order[0].mWarehouseId, CopyFromPOOrderData.cBPartnerLocationId(this, order[0].cBpartnerId), CopyFromPOOrderData.cBPartnerLocationId(this, order[0].cBpartnerId), order[0].cProjectId, order[0].issotrx.equals("Y")?true:false);

File "src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder_data.xsql":
In the SqlMethod name="select", replace the next SELECT:

SELECT O.C_BPARTNER_ID, O.C_BPARTNER_LOCATION_ID, O.M_WAREHOUSE_ID, O.C_CURRENCY_ID, O.C_PROJECT_ID,
        O.M_PRICELIST_ID, COALESCE(MAX(OL.LINE),0) AS LINE, O.AD_ORG_ID, O.AD_CLIENT_ID, '' AS C_UOM_ID, '' AS M_PRODUCT_ID,
        '' AS QTYORDERED, '' AS QUANTITYORDER, '' AS M_PRODUCT_UOM_ID,
        '' AS DESCRIPTION, '' AS PRICESTD, '' AS M_OFFER_ID, '' as orderline
        FROM C_ORDER O LEFT JOIN C_ORDERLINE OL ON O.C_ORDER_ID = OL.C_ORDER_ID
        WHERE O.C_ORDER_ID = TO_NUMBER(?)
        GROUP BY O.C_BPARTNER_ID, O.C_BPARTNER_LOCATION_ID, O.M_WAREHOUSE_ID, O.C_CURRENCY_ID, O.C_PROJECT_ID,
        O.M_PRICELIST_ID, O.AD_ORG_ID, O.AD_CLIENT_ID

by

SELECT O.C_BPARTNER_ID, O.C_BPARTNER_LOCATION_ID, O.M_WAREHOUSE_ID, O.C_CURRENCY_ID, O.C_PROJECT_ID,
        O.M_PRICELIST_ID, COALESCE(MAX(OL.LINE),0) AS LINE, O.AD_ORG_ID, O.AD_CLIENT_ID, '' AS C_UOM_ID, '' AS M_PRODUCT_ID,
        '' AS QTYORDERED, '' AS QUANTITYORDER, '' AS M_PRODUCT_UOM_ID,
        '' AS DESCRIPTION, '' AS PRICESTD, '' AS M_OFFER_ID, '' as orderline, O.ISSOTRX
        FROM C_ORDER O LEFT JOIN C_ORDERLINE OL ON O.C_ORDER_ID = OL.C_ORDER_ID
        WHERE O.C_ORDER_ID = TO_NUMBER(?)
        GROUP BY O.C_BPARTNER_ID, O.C_BPARTNER_LOCATION_ID, O.M_WAREHOUSE_ID, O.C_CURRENCY_ID, O.C_PROJECT_ID,
        O.M_PRICELIST_ID, O.AD_ORG_ID, O.AD_CLIENT_ID, O.ISSOTRX

Tags

comsup_sprint5

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0007039

closed

Hennadzi

Purchase Order -> Copy From Order does not find sometimes tax setup

Notes
(0012925) svnbot (reporter) 2009-01-30 16:47	Repository: openbravo Revision: 12568 Author: hennadzi Date: 2009-01-30 16:47:57 +0100 (Fri, 30 Jan 2009) Fixed bug 0007264: Purchase Order -> Copy From Order does not find sometimes tax setup --- U branches/r2.40/src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder.java U branches/r2.40/src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=12568&sc=1 [^]

(0014999) sureshbabu (reporter) 2009-03-26 12:36	Working fine

Issue History
Date Modified	Username	Field	Change
2009-01-30 12:19	psarobe	Type	defect => backport
2009-01-30 12:19	psarobe	fix_in_branch	=> 2.40
2009-01-30 13:51	PavelPonomarev	Assigned To	rafaroda => Hennadzi
2009-01-30 16:47	svnbot	Checkin
2009-01-30 16:47	svnbot	Note Added: 0012925
2009-01-30 16:47	svnbot	Status	scheduled => resolved
2009-01-30 16:47	svnbot	Resolution	open => fixed
2009-01-30 16:47	svnbot	svn_revision	=> 12568
2009-02-02 15:36	Hennadzi	Tag Attached: comsup_sprint5
2009-03-03 17:32	psarobe	Fixed in Version	=> 2.40MP3
2009-03-24 11:01	psarobe	Fixed in Version	2.40MP3 => 2.40MP4
2009-03-26 12:36	sureshbabu	Regression testing	=> No
2009-03-26 12:36	sureshbabu	Status	resolved => closed
2009-03-26 12:36	sureshbabu	Note Added: 0014999