Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0032097 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | major | always | 2016-02-02 16:53 | 2016-02-18 12:53 | |||
Reporter | guillermogil | View Status | public | |||||
Assigned To | guillermogil | |||||||
Priority | high | Resolution | fixed | Fixed in Version | RR16Q2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 19b60227dbe1 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
Product Version | SCM revision | |||||||
Review Assigned To | marvintm | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0032097: Orderline Warehouse was not taken into account on Returns | |||||||
Description | Orderline Warehouse was not taken into account on Returns. It is just taken into account on sales. | |||||||
Steps To Reproduce | Configure Select Warehouse preference to 'Y' Add Multi-tool stock to 2 warehouse of White Valley org. Login on WebPOS Add Multi-tool Select a warehouse Return that product Complete the ticket You will see on the backend that the selected warehouse is not used | |||||||
Proposed Solution | Modify Orderloader to allow a new bin. See diff attached | |||||||
Tags | No tags attached. | |||||||
Attached Files | 32097.diff [^] (1,084 bytes) 2016-02-02 16:54 [Show Content] [Hide Content]diff --git a/src/org/openbravo/retail/posterminal/OrderLoader.java b/src/org/openbravo/retail/posterminal/OrderLoader.java --- a/src/org/openbravo/retail/posterminal/OrderLoader.java +++ b/src/org/openbravo/retail/posterminal/OrderLoader.java @@ -1048,9 +1048,14 @@ if (negativeLine) { lineNo += 10; + Locator binForReturn = null; + if (orderLine.getWarehouse() != null && orderLine.getWarehouse().getReturnlocator() != null) { + binForReturn = orderLine.getWarehouse().getReturnlocator(); + } else { + binForReturn = getBinForReturns(jsonorder.getString("posTerminal")); + } addShipmentline(shipment, shplineentity, orderlines.getJSONObject(i), orderLine, jsonorder, - lineNo, pendingQty.negate(), getBinForReturns(jsonorder.getString("posTerminal")), - null, i); + lineNo, pendingQty.negate(), binForReturn, null, i); } else if (useSingleBin) { lineNo += 10; addShipmentline(shipment, shplineentity, orderlines.getJSONObject(i), orderLine, jsonorder, sampledata.diff [^] (29,388 bytes) 2016-02-03 15:26 [Show Content] [Hide Content] diff --git a/referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml b/referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml --- a/referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml +++ b/referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml @@ -7746,6 +7746,44 @@ </FACT_ACCT> <FACT_ACCT> + <FACT_ACCT_ID><![CDATA[2B009321D0DF437299F6840F7556888C]]></FACT_ACCT_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:11:50.137993]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:11:50.137993]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_ACCTSCHEMA_ID><![CDATA[AC1CF7D7135845709337B960AE4AC8A1]]></C_ACCTSCHEMA_ID> + <ACCOUNT_ID><![CDATA[D6B0178B58E54F37A5294390A49504EB]]></ACCOUNT_ID> + <DATETRX><![CDATA[2016-02-03 00:00:00.0]]></DATETRX> + <DATEACCT><![CDATA[2016-02-03 00:00:00.0]]></DATEACCT> + <C_PERIOD_ID><![CDATA[D1BD6CAF0CC544FAB0E5FEB072845D23]]></C_PERIOD_ID> + <AD_TABLE_ID><![CDATA[321]]></AD_TABLE_ID> + <RECORD_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></RECORD_ID> + <LINE_ID><![CDATA[0F3DCFA0EB97455D9FC39B2D4EBCA936]]></LINE_ID> + <GL_CATEGORY_ID><![CDATA[FC670B83E59C4E7CBD6B999D3F28B251]]></GL_CATEGORY_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <POSTINGTYPE><![CDATA[A]]></POSTINGTYPE> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <AMTSOURCEDR><![CDATA[3669.00]]></AMTSOURCEDR> + <AMTSOURCECR><![CDATA[0.00]]></AMTSOURCECR> + <AMTACCTDR><![CDATA[3669.00]]></AMTACCTDR> + <AMTACCTCR><![CDATA[0.00]]></AMTACCTCR> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTY><![CDATA[100]]></QTY> + <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> + <DESCRIPTION><![CDATA[03-02-2016 # 10]]></DESCRIPTION> + <FACT_ACCT_GROUP_ID><![CDATA[1DC5A8DA8F47436F9C1C5B0A0FE4F7AE]]></FACT_ACCT_GROUP_ID> + <SEQNO><![CDATA[10]]></SEQNO> + <FACTACCTTYPE><![CDATA[N]]></FACTACCTTYPE> + <DOCBASETYPE><![CDATA[MMI]]></DOCBASETYPE> + <ACCTVALUE><![CDATA[35000]]></ACCTVALUE> + <ACCTDESCRIPTION><![CDATA[Productos terminados A]]></ACCTDESCRIPTION> + <ISMODIFY><![CDATA[N]]></ISMODIFY> +</FACT_ACCT> + +<FACT_ACCT> <FACT_ACCT_ID><![CDATA[2B707C22B35D4530A16766A496CE5876]]></FACT_ACCT_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> @@ -12929,6 +12967,44 @@ </FACT_ACCT> <FACT_ACCT> + <FACT_ACCT_ID><![CDATA[4532BA25D3D8447D8633C52F5B39AF52]]></FACT_ACCT_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:11:50.137993]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:11:50.137993]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_ACCTSCHEMA_ID><![CDATA[AC1CF7D7135845709337B960AE4AC8A1]]></C_ACCTSCHEMA_ID> + <ACCOUNT_ID><![CDATA[D6B0178B58E54F37A5294390A49504EB]]></ACCOUNT_ID> + <DATETRX><![CDATA[2016-02-03 00:00:00.0]]></DATETRX> + <DATEACCT><![CDATA[2016-02-03 00:00:00.0]]></DATEACCT> + <C_PERIOD_ID><![CDATA[D1BD6CAF0CC544FAB0E5FEB072845D23]]></C_PERIOD_ID> + <AD_TABLE_ID><![CDATA[321]]></AD_TABLE_ID> + <RECORD_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></RECORD_ID> + <LINE_ID><![CDATA[5414B06F2DCC4548AF36D19A102F1D1B]]></LINE_ID> + <GL_CATEGORY_ID><![CDATA[FC670B83E59C4E7CBD6B999D3F28B251]]></GL_CATEGORY_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <POSTINGTYPE><![CDATA[A]]></POSTINGTYPE> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <AMTSOURCEDR><![CDATA[2754.00]]></AMTSOURCEDR> + <AMTSOURCECR><![CDATA[0.00]]></AMTSOURCECR> + <AMTACCTDR><![CDATA[2754.00]]></AMTACCTDR> + <AMTACCTCR><![CDATA[0.00]]></AMTACCTCR> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTY><![CDATA[100]]></QTY> + <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> + <DESCRIPTION><![CDATA[03-02-2016 # 20]]></DESCRIPTION> + <FACT_ACCT_GROUP_ID><![CDATA[1DC5A8DA8F47436F9C1C5B0A0FE4F7AE]]></FACT_ACCT_GROUP_ID> + <SEQNO><![CDATA[30]]></SEQNO> + <FACTACCTTYPE><![CDATA[N]]></FACTACCTTYPE> + <DOCBASETYPE><![CDATA[MMI]]></DOCBASETYPE> + <ACCTVALUE><![CDATA[35000]]></ACCTVALUE> + <ACCTDESCRIPTION><![CDATA[Productos terminados A]]></ACCTDESCRIPTION> + <ISMODIFY><![CDATA[N]]></ISMODIFY> +</FACT_ACCT> + +<FACT_ACCT> <FACT_ACCT_ID><![CDATA[45918D2C9CB34A928A1B286C3C6B85A8]]></FACT_ACCT_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[B5DE96143D6642228E3B9DEC69886A47]]></AD_ORG_ID> @@ -30510,6 +30586,44 @@ </FACT_ACCT> <FACT_ACCT> + <FACT_ACCT_ID><![CDATA[9C1D7111CA3C4CBFADF73A1CD7B976D4]]></FACT_ACCT_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:11:50.137993]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:11:50.137993]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_ACCTSCHEMA_ID><![CDATA[AC1CF7D7135845709337B960AE4AC8A1]]></C_ACCTSCHEMA_ID> + <ACCOUNT_ID><![CDATA[E487A614C4EB465FAB8EC9CBAE31E943]]></ACCOUNT_ID> + <DATETRX><![CDATA[2016-02-03 00:00:00.0]]></DATETRX> + <DATEACCT><![CDATA[2016-02-03 00:00:00.0]]></DATEACCT> + <C_PERIOD_ID><![CDATA[D1BD6CAF0CC544FAB0E5FEB072845D23]]></C_PERIOD_ID> + <AD_TABLE_ID><![CDATA[321]]></AD_TABLE_ID> + <RECORD_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></RECORD_ID> + <LINE_ID><![CDATA[5414B06F2DCC4548AF36D19A102F1D1B]]></LINE_ID> + <GL_CATEGORY_ID><![CDATA[FC670B83E59C4E7CBD6B999D3F28B251]]></GL_CATEGORY_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <POSTINGTYPE><![CDATA[A]]></POSTINGTYPE> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <AMTSOURCEDR><![CDATA[0.00]]></AMTSOURCEDR> + <AMTSOURCECR><![CDATA[2754.00]]></AMTSOURCECR> + <AMTACCTDR><![CDATA[0.00]]></AMTACCTDR> + <AMTACCTCR><![CDATA[2754.00]]></AMTACCTCR> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTY><![CDATA[100]]></QTY> + <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> + <DESCRIPTION><![CDATA[03-02-2016 # 20]]></DESCRIPTION> + <FACT_ACCT_GROUP_ID><![CDATA[1DC5A8DA8F47436F9C1C5B0A0FE4F7AE]]></FACT_ACCT_GROUP_ID> + <SEQNO><![CDATA[40]]></SEQNO> + <FACTACCTTYPE><![CDATA[N]]></FACTACCTTYPE> + <DOCBASETYPE><![CDATA[MMI]]></DOCBASETYPE> + <ACCTVALUE><![CDATA[61000]]></ACCTVALUE> + <ACCTDESCRIPTION><![CDATA[Variación de existencias de mercaderías]]></ACCTDESCRIPTION> + <ISMODIFY><![CDATA[N]]></ISMODIFY> +</FACT_ACCT> + +<FACT_ACCT> <FACT_ACCT_ID><![CDATA[9C371667D72145019543E970C8B02356]]></FACT_ACCT_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[01AD882EFC8545ACA6455E2F6FD51EE9]]></AD_ORG_ID> @@ -35945,6 +36059,44 @@ </FACT_ACCT> <FACT_ACCT> + <FACT_ACCT_ID><![CDATA[B7BF34ECB441491AA46F09CE2487F47C]]></FACT_ACCT_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:11:50.137993]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:11:50.137993]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_ACCTSCHEMA_ID><![CDATA[AC1CF7D7135845709337B960AE4AC8A1]]></C_ACCTSCHEMA_ID> + <ACCOUNT_ID><![CDATA[E487A614C4EB465FAB8EC9CBAE31E943]]></ACCOUNT_ID> + <DATETRX><![CDATA[2016-02-03 00:00:00.0]]></DATETRX> + <DATEACCT><![CDATA[2016-02-03 00:00:00.0]]></DATEACCT> + <C_PERIOD_ID><![CDATA[D1BD6CAF0CC544FAB0E5FEB072845D23]]></C_PERIOD_ID> + <AD_TABLE_ID><![CDATA[321]]></AD_TABLE_ID> + <RECORD_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></RECORD_ID> + <LINE_ID><![CDATA[0F3DCFA0EB97455D9FC39B2D4EBCA936]]></LINE_ID> + <GL_CATEGORY_ID><![CDATA[FC670B83E59C4E7CBD6B999D3F28B251]]></GL_CATEGORY_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <POSTINGTYPE><![CDATA[A]]></POSTINGTYPE> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <AMTSOURCEDR><![CDATA[0.00]]></AMTSOURCEDR> + <AMTSOURCECR><![CDATA[3669.00]]></AMTSOURCECR> + <AMTACCTDR><![CDATA[0.00]]></AMTACCTDR> + <AMTACCTCR><![CDATA[3669.00]]></AMTACCTCR> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTY><![CDATA[100]]></QTY> + <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> + <DESCRIPTION><![CDATA[03-02-2016 # 10]]></DESCRIPTION> + <FACT_ACCT_GROUP_ID><![CDATA[1DC5A8DA8F47436F9C1C5B0A0FE4F7AE]]></FACT_ACCT_GROUP_ID> + <SEQNO><![CDATA[20]]></SEQNO> + <FACTACCTTYPE><![CDATA[N]]></FACTACCTTYPE> + <DOCBASETYPE><![CDATA[MMI]]></DOCBASETYPE> + <ACCTVALUE><![CDATA[61000]]></ACCTVALUE> + <ACCTDESCRIPTION><![CDATA[Variación de existencias de mercaderías]]></ACCTDESCRIPTION> + <ISMODIFY><![CDATA[N]]></ISMODIFY> +</FACT_ACCT> + +<FACT_ACCT> <FACT_ACCT_ID><![CDATA[B82E2D4146824CF797397E9CC43710E7]]></FACT_ACCT_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml b/referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml --- a/referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml +++ b/referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml @@ -1620,6 +1620,30 @@ </M_COSTING> <M_COSTING> + <M_COSTING_ID><![CDATA[2FF60A2C9A4F47F99ECA8150116AB95A]]></M_COSTING_ID> + <CREATED><![CDATA[2016-02-03 14:09:05.252]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.252]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> + <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> + <DATEFROM><![CDATA[2016-02-03 14:08:16.0]]></DATEFROM> + <DATETO><![CDATA[9999-12-31 00:00:00.0]]></DATETO> + <ISMANUAL><![CDATA[N]]></ISMANUAL> + <QTY><![CDATA[100]]></QTY> + <PRICE><![CDATA[36.69]]></PRICE> + <CUMQTY><![CDATA[300]]></CUMQTY> + <COSTTYPE><![CDATA[AVA]]></COSTTYPE> + <ISPERMANENT><![CDATA[Y]]></ISPERMANENT> + <COST><![CDATA[36.69]]></COST> + <ISPRODUCTION><![CDATA[N]]></ISPRODUCTION> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <M_TRANSACTION_ID><![CDATA[18FCF30837A84C98B60CD3E92E4B6D88]]></M_TRANSACTION_ID> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> +</M_COSTING> + +<M_COSTING> <M_COSTING_ID><![CDATA[305C764C6537441EBA121883C1F2A2A9]]></M_COSTING_ID> <CREATED><![CDATA[2015-11-26 11:52:05.294]]></CREATED> <CREATEDBY><![CDATA[100]]></CREATEDBY> @@ -7368,13 +7392,13 @@ <M_COSTING_ID><![CDATA[C38D1ED641A143C48A8BAE7EBAAFD235]]></M_COSTING_ID> <CREATED><![CDATA[2013-07-04 23:01:14.845]]></CREATED> <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:01:14.845]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.266]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> <DATEFROM><![CDATA[2012-07-24 11:53:50.494]]></DATEFROM> - <DATETO><![CDATA[9999-12-31 00:00:00.0]]></DATETO> + <DATETO><![CDATA[2016-02-03 14:08:16.0]]></DATETO> <ISMANUAL><![CDATA[N]]></ISMANUAL> <QTY><![CDATA[100]]></QTY> <PRICE><![CDATA[36.69]]></PRICE> @@ -8517,13 +8541,13 @@ <M_COSTING_ID><![CDATA[E215C42A452F404A9FF24AA06EA50216]]></M_COSTING_ID> <CREATED><![CDATA[2013-07-04 23:01:14.842]]></CREATED> <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:01:14.842]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.403]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> <DATEFROM><![CDATA[2012-07-24 11:53:50.494]]></DATEFROM> - <DATETO><![CDATA[9999-12-31 00:00:00.0]]></DATETO> + <DATETO><![CDATA[2016-02-03 14:08:16.0]]></DATETO> <ISMANUAL><![CDATA[N]]></ISMANUAL> <QTY><![CDATA[300]]></QTY> <PRICE><![CDATA[27.54]]></PRICE> @@ -9614,6 +9638,30 @@ </M_COSTING> <M_COSTING> + <M_COSTING_ID><![CDATA[FC1487FB321D45E1BD4CFDEAC951D735]]></M_COSTING_ID> + <CREATED><![CDATA[2016-02-03 14:09:05.393]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.393]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> + <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> + <DATEFROM><![CDATA[2016-02-03 14:08:16.0]]></DATEFROM> + <DATETO><![CDATA[9999-12-31 00:00:00.0]]></DATETO> + <ISMANUAL><![CDATA[N]]></ISMANUAL> + <QTY><![CDATA[100]]></QTY> + <PRICE><![CDATA[27.54]]></PRICE> + <CUMQTY><![CDATA[700]]></CUMQTY> + <COSTTYPE><![CDATA[AVA]]></COSTTYPE> + <ISPERMANENT><![CDATA[Y]]></ISPERMANENT> + <COST><![CDATA[27.54]]></COST> + <ISPRODUCTION><![CDATA[N]]></ISPRODUCTION> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <M_TRANSACTION_ID><![CDATA[871186AE27DD4164AEB2E459B0F0DCC8]]></M_TRANSACTION_ID> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> +</M_COSTING> + +<M_COSTING> <M_COSTING_ID><![CDATA[FC1580DF06D3468B90E344967DD718DF]]></M_COSTING_ID> <CREATED><![CDATA[2013-07-04 23:01:14.84]]></CREATED> <CREATEDBY><![CDATA[0]]></CREATEDBY> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml b/referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml new file mode 100644 --- /dev/null +++ b/referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml @@ -0,0 +1,23 @@ +<?xml version='1.0' encoding='UTF-8'?> +<data> +<M_INVENTORY> + <M_INVENTORY_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></M_INVENTORY_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:07:35.743]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:11:50.150166]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <NAME><![CDATA[03-02-2016]]></NAME> + <M_WAREHOUSE_ID><![CDATA[CE7AB151695342FF879938F837F12E6E]]></M_WAREHOUSE_ID> + <MOVEMENTDATE><![CDATA[2016-02-03 00:00:00.0]]></MOVEMENTDATE> + <POSTED><![CDATA[Y]]></POSTED> + <PROCESSED><![CDATA[Y]]></PROCESSED> + <PROCESSING><![CDATA[N]]></PROCESSING> + <UPDATEQTY><![CDATA[N]]></UPDATEQTY> + <GENERATELIST><![CDATA[N]]></GENERATELIST> + <INVENTORY_TYPE><![CDATA[N]]></INVENTORY_TYPE> +</M_INVENTORY> + +</data> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml b/referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml new file mode 100644 --- /dev/null +++ b/referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml @@ -0,0 +1,39 @@ +<?xml version='1.0' encoding='UTF-8'?> +<data> +<M_INVENTORYLINE> + <M_INVENTORYLINE_ID><![CDATA[0F3DCFA0EB97455D9FC39B2D4EBCA936]]></M_INVENTORYLINE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:07:55.092]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:07:55.092]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <M_INVENTORY_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></M_INVENTORY_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> + <LINE><![CDATA[10]]></LINE> + <QTYBOOK><![CDATA[0]]></QTYBOOK> + <QTYCOUNT><![CDATA[100]]></QTYCOUNT> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> +</M_INVENTORYLINE> + +<M_INVENTORYLINE> + <M_INVENTORYLINE_ID><![CDATA[5414B06F2DCC4548AF36D19A102F1D1B]]></M_INVENTORYLINE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:08:13.643]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:08:13.643]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <M_INVENTORY_ID><![CDATA[18FA2628578443FA92C406DFD6C73A85]]></M_INVENTORY_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> + <LINE><![CDATA[20]]></LINE> + <QTYBOOK><![CDATA[0]]></QTYBOOK> + <QTYCOUNT><![CDATA[100]]></QTYCOUNT> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> +</M_INVENTORYLINE> + +</data> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml b/referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml --- a/referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml +++ b/referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml @@ -495,6 +495,26 @@ </M_STORAGE_DETAIL> <M_STORAGE_DETAIL> + <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <M_ATTRIBUTESETINSTANCE_ID><![CDATA[0]]></M_ATTRIBUTESETINSTANCE_ID> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTYONHAND><![CDATA[100]]></QTYONHAND> + <DATELASTINVENTORY><![CDATA[2016-02-03 00:00:00.0]]></DATELASTINVENTORY> + <PREQTYONHAND><![CDATA[0]]></PREQTYONHAND> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:07:55.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <M_STORAGE_DETAIL_ID><![CDATA[16831BA1C51E4CDF89C2739B1FA403BC]]></M_STORAGE_DETAIL_ID> + <RESERVEDQTY><![CDATA[0]]></RESERVEDQTY> + <ALLOCATEDQTY><![CDATA[0]]></ALLOCATEDQTY> +</M_STORAGE_DETAIL> + +<M_STORAGE_DETAIL> <M_PRODUCT_ID><![CDATA[AC79520FEB4743B3AAA379BF70B9B7DA]]></M_PRODUCT_ID> <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> <M_ATTRIBUTESETINSTANCE_ID><![CDATA[0]]></M_ATTRIBUTESETINSTANCE_ID> @@ -1331,6 +1351,26 @@ </M_STORAGE_DETAIL> <M_STORAGE_DETAIL> + <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <M_ATTRIBUTESETINSTANCE_ID><![CDATA[0]]></M_ATTRIBUTESETINSTANCE_ID> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <QTYONHAND><![CDATA[100]]></QTYONHAND> + <DATELASTINVENTORY><![CDATA[2016-02-03 00:00:00.0]]></DATELASTINVENTORY> + <PREQTYONHAND><![CDATA[0]]></PREQTYONHAND> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:08:13.0]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.0]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <M_STORAGE_DETAIL_ID><![CDATA[36286FBA765848FC82F608D8D39156CF]]></M_STORAGE_DETAIL_ID> + <RESERVEDQTY><![CDATA[0]]></RESERVEDQTY> + <ALLOCATEDQTY><![CDATA[0]]></ALLOCATEDQTY> +</M_STORAGE_DETAIL> + +<M_STORAGE_DETAIL> <M_PRODUCT_ID><![CDATA[158F7969866D4E81AC5B03547AABF45A]]></M_PRODUCT_ID> <M_LOCATOR_ID><![CDATA[FDC4AC6020F841B3BAA73048C5EA7180]]></M_LOCATOR_ID> <M_ATTRIBUTESETINSTANCE_ID><![CDATA[0]]></M_ATTRIBUTESETINSTANCE_ID> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml b/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml --- a/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml +++ b/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml @@ -1231,6 +1231,36 @@ </M_TRANSACTION> <M_TRANSACTION> + <M_TRANSACTION_ID><![CDATA[18FCF30837A84C98B60CD3E92E4B6D88]]></M_TRANSACTION_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:08:16.720022]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.331]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <MOVEMENTTYPE><![CDATA[I+]]></MOVEMENTTYPE> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <M_PRODUCT_ID><![CDATA[18C6723E5B53403D84D93D61F840FA30]]></M_PRODUCT_ID> + <MOVEMENTDATE><![CDATA[2016-02-03 00:00:00.0]]></MOVEMENTDATE> + <MOVEMENTQTY><![CDATA[100]]></MOVEMENTQTY> + <M_INVENTORYLINE_ID><![CDATA[0F3DCFA0EB97455D9FC39B2D4EBCA936]]></M_INVENTORYLINE_ID> + <M_ATTRIBUTESETINSTANCE_ID><![CDATA[0]]></M_ATTRIBUTESETINSTANCE_ID> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <TRANSACTIONCOST><![CDATA[3669.00]]></TRANSACTIONCOST> + <TRXPROCESSDATE><![CDATA[2016-02-03 14:08:16.0]]></TRXPROCESSDATE> + <M_COSTING_ALGORITHM_ID><![CDATA[B069080A0AE149A79CF1FA0E24F16AB6]]></M_COSTING_ALGORITHM_ID> + <ISCOSTCALCULATED><![CDATA[Y]]></ISCOSTCALCULATED> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <COSTING_STATUS><![CDATA[CC]]></COSTING_STATUS> + <CHECKRESERVEDQTY><![CDATA[Y]]></CHECKRESERVEDQTY> + <ISPROCESSED><![CDATA[Y]]></ISPROCESSED> + <CHECKPRICEDIFFERENCE><![CDATA[N]]></CHECKPRICEDIFFERENCE> + <MANUALCOSTADJUSTMENT><![CDATA[N]]></MANUALCOSTADJUSTMENT> + <ISCOSTPERMANENT><![CDATA[N]]></ISCOSTPERMANENT> +</M_TRANSACTION> + +<M_TRANSACTION> <M_TRANSACTION_ID><![CDATA[1900DDEF136749C0B653F1CCD0D4F8C3]]></M_TRANSACTION_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[01AD882EFC8545ACA6455E2F6FD51EE9]]></AD_ORG_ID> @@ -6241,6 +6271,36 @@ </M_TRANSACTION> <M_TRANSACTION> + <M_TRANSACTION_ID><![CDATA[871186AE27DD4164AEB2E459B0F0DCC8]]></M_TRANSACTION_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2016-02-03 14:08:16.720022]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.418]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <MOVEMENTTYPE><![CDATA[I+]]></MOVEMENTTYPE> + <M_LOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_LOCATOR_ID> + <M_PRODUCT_ID><![CDATA[12B5684B70BA4EAE93C3EA5DE38118A2]]></M_PRODUCT_ID> + <MOVEMENTDATE><![CDATA[2016-02-03 00:00:00.0]]></MOVEMENTDATE> + <MOVEMENTQTY><![CDATA[100]]></MOVEMENTQTY> + <M_INVENTORYLINE_ID><![CDATA[5414B06F2DCC4548AF36D19A102F1D1B]]></M_INVENTORYLINE_ID> + <M_ATTRIBUTESETINSTANCE_ID><![CDATA[0]]></M_ATTRIBUTESETINSTANCE_ID> + <C_UOM_ID><![CDATA[100]]></C_UOM_ID> + <TRANSACTIONCOST><![CDATA[2754.00]]></TRANSACTIONCOST> + <TRXPROCESSDATE><![CDATA[2016-02-03 14:08:16.0]]></TRXPROCESSDATE> + <M_COSTING_ALGORITHM_ID><![CDATA[B069080A0AE149A79CF1FA0E24F16AB6]]></M_COSTING_ALGORITHM_ID> + <ISCOSTCALCULATED><![CDATA[Y]]></ISCOSTCALCULATED> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <COSTING_STATUS><![CDATA[CC]]></COSTING_STATUS> + <CHECKRESERVEDQTY><![CDATA[Y]]></CHECKRESERVEDQTY> + <ISPROCESSED><![CDATA[Y]]></ISPROCESSED> + <CHECKPRICEDIFFERENCE><![CDATA[N]]></CHECKPRICEDIFFERENCE> + <MANUALCOSTADJUSTMENT><![CDATA[N]]></MANUALCOSTADJUSTMENT> + <ISCOSTPERMANENT><![CDATA[N]]></ISCOSTPERMANENT> +</M_TRANSACTION> + +<M_TRANSACTION> <M_TRANSACTION_ID><![CDATA[88F0AD4DC1484BE38F026A79A19FA292]]></M_TRANSACTION_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[BF129721D9FB4EB0819509934153E972]]></AD_ORG_ID> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml b/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml --- a/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml +++ b/referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml @@ -1344,6 +1344,23 @@ </M_TRANSACTION_COST> <M_TRANSACTION_COST> + <M_TRANSACTION_COST_ID><![CDATA[3213BAB2CDA2410F93F234A6A1A53A9A]]></M_TRANSACTION_COST_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <CREATED><![CDATA[2016-02-03 14:09:05.256]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.256]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <M_TRANSACTION_ID><![CDATA[18FCF30837A84C98B60CD3E92E4B6D88]]></M_TRANSACTION_ID> + <COST><![CDATA[3669.00]]></COST> + <COSTDATE><![CDATA[2016-02-03 14:08:16.0]]></COSTDATE> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <ISUNITCOST><![CDATA[Y]]></ISUNITCOST> + <DATEACCT><![CDATA[2016-02-03 00:00:00.0]]></DATEACCT> +</M_TRANSACTION_COST> + +<M_TRANSACTION_COST> <M_TRANSACTION_COST_ID><![CDATA[333B6F2A800D4807A81A5D03F6D95266]]></M_TRANSACTION_COST_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[3B187EC130A549A7A9388F8060EF156D]]></AD_ORG_ID> @@ -3690,6 +3707,23 @@ </M_TRANSACTION_COST> <M_TRANSACTION_COST> + <M_TRANSACTION_COST_ID><![CDATA[843C120C20AC4D43B9B65DD2F0F57C21]]></M_TRANSACTION_COST_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[D270A5AC50874F8BA67A88EE977F8E3B]]></AD_ORG_ID> + <CREATED><![CDATA[2016-02-03 14:09:05.396]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2016-02-03 14:09:05.396]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <M_TRANSACTION_ID><![CDATA[871186AE27DD4164AEB2E459B0F0DCC8]]></M_TRANSACTION_ID> + <COST><![CDATA[2754.00]]></COST> + <COSTDATE><![CDATA[2016-02-03 14:08:16.0]]></COSTDATE> + <C_CURRENCY_ID><![CDATA[102]]></C_CURRENCY_ID> + <ISUNITCOST><![CDATA[Y]]></ISUNITCOST> + <DATEACCT><![CDATA[2016-02-03 00:00:00.0]]></DATEACCT> +</M_TRANSACTION_COST> + +<M_TRANSACTION_COST> <M_TRANSACTION_COST_ID><![CDATA[851ED39C02BC43E9979B8BAB1D86E76E]]></M_TRANSACTION_COST_ID> <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[3B187EC130A549A7A9388F8060EF156D]]></AD_ORG_ID> diff --git a/referencedata/sampledata/The_White_Valley_Group/M_WAREHOUSE.xml b/referencedata/sampledata/The_White_Valley_Group/M_WAREHOUSE.xml --- a/referencedata/sampledata/The_White_Valley_Group/M_WAREHOUSE.xml +++ b/referencedata/sampledata/The_White_Valley_Group/M_WAREHOUSE.xml @@ -58,13 +58,14 @@ <ISACTIVE><![CDATA[Y]]></ISACTIVE> <CREATED><![CDATA[2013-07-04 23:01:13.699]]></CREATED> <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:01:13.699]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <UPDATED><![CDATA[2016-02-03 14:10:38.882]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> <VALUE><![CDATA[VBS/001]]></VALUE> <NAME><![CDATA[Vall Blanca Store Warehouse]]></NAME> <C_LOCATION_ID><![CDATA[53831A9B6EA64EE79FD98E6A41A44287]]></C_LOCATION_ID> <SEPARATOR><![CDATA[*]]></SEPARATOR> <ISSHIPPER><![CDATA[N]]></ISSHIPPER> + <M_RETURNLOCATOR_ID><![CDATA[2D0CE7A3EAB5497A99ECAD359D96D468]]></M_RETURNLOCATOR_ID> <ISALLOCATED><![CDATA[N]]></ISALLOCATED> </M_WAREHOUSE> @@ -109,13 +110,14 @@ <ISACTIVE><![CDATA[Y]]></ISACTIVE> <CREATED><![CDATA[2013-07-04 23:01:13.726]]></CREATED> <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:01:13.726]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <UPDATED><![CDATA[2016-02-03 14:08:26.55]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> <VALUE><![CDATA[WVS/001]]></VALUE> <NAME><![CDATA[White Valley Spain Distribution Center]]></NAME> <C_LOCATION_ID><![CDATA[F7029BEA56CD443EB991B5E25FD9DBA4]]></C_LOCATION_ID> <SEPARATOR><![CDATA[*]]></SEPARATOR> <ISSHIPPER><![CDATA[N]]></ISSHIPPER> + <M_RETURNLOCATOR_ID><![CDATA[4A8F85768FDD4B47BB3A468289C10A69]]></M_RETURNLOCATOR_ID> <ISALLOCATED><![CDATA[N]]></ISALLOCATED> </M_WAREHOUSE> test.diff [^] (7,447 bytes) 2016-02-03 15:26 [Show Content] [Hide Content] diff --git a/src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java b/src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java --- a/src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java +++ b/src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java @@ -11,7 +11,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo S.L.U. - * All portions are Copyright (C) 2014-2015 Openbravo S.L.U. + * All portions are Copyright (C) 2014-2016 Openbravo S.L.U. * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ @@ -370,6 +370,7 @@ BUTTON_SEARCHPRODUCT_CRAMPONS10POINT("Crampons 10 point", EnyoKind.SEARCHPRODUCT), // BUTTON_SEARCHPRODUCT_BASECAMPLANTERN("Basecamp lantern", EnyoKind.SEARCHPRODUCT), // BUTTON_SEARCHPRODUCT_MULTITOOL("Multi-tool", EnyoKind.SEARCHPRODUCT), // + BUTTON_SEARCHPRODUCT_SOLARCHARGER("Solar charger", EnyoKind.SEARCHPRODUCT), // BUTTON_SEARCHPRODUCT_THERMO1L("Thermo 1 L", EnyoKind.SEARCHPRODUCT), // BUTTON_SEARCHPRODUCT_UNISEXNORDICTOURINGSKIS("Unisex nordic touring skis", EnyoKind.SEARCHPRODUCT), // BUTTON_SEARCHPRODUCT_GPSHANDHELD("GPS handheld", EnyoKind.SEARCHPRODUCT), // @@ -469,6 +470,8 @@ BUTTON_EDIT_Services("actionButtonsContainer_showRelatedServices", EnyoKind.BUTTON), // BUTTON_STORE_STOCK("body_stockHere", EnyoKind.BUTTON), // + BUTTON_STORE_STOCK_ROW1("scrollListStockDetailsClickable_row1_stockInStoreLineClickable", + EnyoKind.BUTTON), // BUTTON_STORE_STOCK_ROW2("scrollListStockDetailsClickable_row2_stockInStoreLineClickable", EnyoKind.BUTTON), @@ -1195,7 +1198,7 @@ // Coupon Code LABEL_COUPONCODE("bodyContent_couponcode"), // BUTTON_COUPONCODE_APPLY("bodyButtons_okButton", EnyoKind.BUTTON), // - + // Returns Approval FIELD_APPROVAL_USERNAME("bodyContent_username"), // FIELD_APPROVAL_PASSWORD("bodyContent_password"), // diff --git a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32097_SelectWarehouseForReturns.java b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32097_SelectWarehouseForReturns.java new file mode 100644 --- /dev/null +++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32097_SelectWarehouseForReturns.java @@ -0,0 +1,121 @@ +/* + ************************************************************************* + * The contents of this file are subject to the Openbravo Public License + * Version 1.0 (the "License"), being the Mozilla Public License + * Version 1.1 with a permitted attribution clause; you may not use this + * file except in compliance with the License. You may obtain a copy of + * the License at http://www.openbravo.com/legal/license.html + * Software distributed under the License is distributed on an "AS IS" + * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the + * License for the specific language governing rights and limitations + * under the License. + * The Original Code is Openbravo ERP. + * The Initial Developer of the Original Code is Openbravo S.L.U. + * All portions are Copyright (C) 2016 Openbravo S.L.U. + * All Rights Reserved. + * Contributor(s): + ************************************************************************ + * + * @author GIG + * + */ + +package org.openbravo.test.mobile.retail.pack.selenium.tests.receipts; + +import static org.hamcrest.CoreMatchers.equalTo; +import static org.hamcrest.MatcherAssert.assertThat; + +import java.sql.ResultSet; +import java.sql.SQLException; + +import org.junit.Test; +import org.openbravo.test.mobile.common.selenium.SeleniumHelper; +import org.openbravo.test.mobile.common.selenium.database.DatabaseHelperSelect; +import org.openbravo.test.mobile.common.selenium.javascript.BackboneHelper; +import org.openbravo.test.mobile.common.selenium.javascript.TestId; +import org.openbravo.test.mobile.common.selenium.terminals.WebPOSTerminalHelper; + +public class I32097_SelectWarehouseForReturns extends WebPOSTerminalHelper { + + @Test + public void test() { + + // reload the master data + this.updateTerminalAfterDatabaseChange(); + + final Boolean whSelectionEnabled = (Boolean) SeleniumHelper + .executeScriptWithReturn("OB.MobileApp.model.get('permissions').OBPOS_warehouseselectionforline;"); + + SeleniumHelper + .executeScript("OB.MobileApp.model.get('permissions').OBPOS_warehouseselectionforline=true;"); + + tap(TestId.BUTTON_SEARCH); + write(TestId.FIELD_SEARCH_TEXT, "Multi-tool"); + tap(TestId.BUTTON_SEARCH_EXECUTE); + tap(TestId.BUTTON_SEARCHPRODUCT_MULTITOOL); + tap(TestId.BUTTON_STORE_STOCK); + tap(TestId.BUTTON_STORE_STOCK_ROW2); + tap(TestId.BUTTON_STOCK_ADDTORECEIPT); + tap(TestId.BUTTON_RECEIPT_ROW1); + tap(TestId.BUTTON_EDIT_RETURNLINE); + + tap(TestId.BUTTON_SEARCH); + write(TestId.FIELD_SEARCH_TEXT, "Solar charger"); + tap(TestId.BUTTON_SEARCH_EXECUTE); + tap(TestId.BUTTON_SEARCHPRODUCT_SOLARCHARGER); + tap(TestId.BUTTON_STORE_STOCK); + tap(TestId.BUTTON_STORE_STOCK_ROW1); + tap(TestId.BUTTON_STOCK_ADDTORECEIPT); + tap(TestId.BUTTON_RECEIPT_ROW2); + tap(TestId.BUTTON_EDIT_RETURNLINE); + + verify(TestId.LABEL_RECEIPT_ROW1_QTY, "-1"); + verify(TestId.LABEL_RECEIPT_ROW2_QTY, "-1"); + + final String receiptNo = BackboneHelper.getDocumentNo(); + + tap(TestId.BUTTON_PAY); + tap(TestId.BUTTON_PAYMENT_CARD); + tap(TestId.BUTTON_PAY_EXACT); + tap(TestId.BUTTON_PAY_DONE); + verify(TestId.LABEL_TOTALTOPAY, "0.00"); + + final String sql = "select * from m_inoutline where m_inout_id in (select m_inout_id from m_inout where c_order_id in (select c_order_id from c_order where documentno='" + + receiptNo + "')) order by line"; + new DatabaseHelperSelect() { + private int count = 0; + + @Override + protected void yieldResultSet(final ResultSet rs) throws SQLException { + count++; + final String locatorId = rs.getString("m_locator_id"); + final String productId = rs.getString("m_product_id"); + + logger.info(String.format( + "Verifying that the database record (%s) '%s' is one of the expected", locatorId, + productId)); + switch (count) { + case 1: + assertThat("Line 1 - The product id is not one of the expected", productId, + equalTo("18C6723E5B53403D84D93D61F840FA30")); + assertThat("Line 1 - The locator id is not one of the expected", locatorId, + equalTo("4A8F85768FDD4B47BB3A468289C10A69")); + break; + case 2: + assertThat("Line 2 - The product id is not one of the expected", productId, + equalTo("12B5684B70BA4EAE93C3EA5DE38118A2")); + assertThat("The locator id is not one of the expected", locatorId, + equalTo("2D0CE7A3EAB5497A99ECAD359D96D468")); + break; + default: + throw new IllegalArgumentException("The returned resulset is missing the assertions"); + } + } + }.execute(sql, 2); + + SeleniumHelper + .executeScript("OB.MobileApp.model.get('permissions').OBPOS_warehouseselectionforline=" + + whSelectionEnabled + ";"); + } + +} | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0083897) guillermogil (manager) 2016-02-03 15:26 |
Added diffs for sampledata and automation |
(0083908) hgbot (developer) 2016-02-04 07:53 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 19b60227dbe1b5d386656cf28c223d9da71e655a Author: Guillermo Gil <guillermo.gil <at> openbravo.com> Date: Wed Feb 03 09:41:05 2016 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/19b60227dbe1b5d386656cf28c223d9da71e655a [^] Fixed issue 32097: Orderline Warehouse was not taken into account on Returns If a warehouse is se on the orderline and it has a return bin that bin will be used --- M src/org/openbravo/retail/posterminal/OrderLoader.java --- |
(0083910) hgbot (developer) 2016-02-04 07:53 |
Repository: erp/pmods/org.openbravo.retail.sampledata Changeset: 4b575d98734acfb67e7b80ea09b746053c377748 Author: Guillermo Gil <guillermo.gil <at> openbravo.com> Date: Wed Feb 03 14:24:32 2016 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/4b575d98734acfb67e7b80ea09b746053c377748 [^] Related to issue 32097: Added sampledata for Automated tests --- M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml M referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml M referencedata/sampledata/The_White_Valley_Group/M_WAREHOUSE.xml A referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml A referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml --- |
(0083912) hgbot (developer) 2016-02-04 07:55 |
Repository: tools/automation/pi-mobile Changeset: cc138e52c9dfa1e372fc5f9e72b58c8df56f84c9 Author: Guillermo Gil <guillermo.gil <at> openbravo.com> Date: Wed Feb 03 15:25:04 2016 +0100 URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/cc138e52c9dfa1e372fc5f9e72b58c8df56f84c9 [^] Related to issue 32097: Added test case to Return Bin Development --- M src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32097_SelectWarehouseForReturns.java --- |
Issue History | |||
Date Modified | Username | Field | Change |
2016-02-02 16:53 | guillermogil | New Issue | |
2016-02-02 16:53 | guillermogil | Assigned To | => Retail |
2016-02-02 16:53 | guillermogil | Triggers an Emergency Pack | => No |
2016-02-02 16:54 | guillermogil | Assigned To | Retail => guillermogil |
2016-02-02 16:54 | guillermogil | Review Assigned To | => marvintm |
2016-02-02 16:54 | guillermogil | File Added: 32097.diff | |
2016-02-02 16:55 | guillermogil | Proposed Solution updated | |
2016-02-02 17:03 | azabaleta | Issue Monitored: azabaleta | |
2016-02-02 17:04 | guillermogil | Relationship added | related to 0032081 |
2016-02-03 15:26 | guillermogil | File Added: sampledata.diff | |
2016-02-03 15:26 | guillermogil | File Added: test.diff | |
2016-02-03 15:26 | guillermogil | Note Added: 0083897 | |
2016-02-04 07:53 | hgbot | Checkin | |
2016-02-04 07:53 | hgbot | Note Added: 0083908 | |
2016-02-04 07:53 | hgbot | Status | new => resolved |
2016-02-04 07:53 | hgbot | Resolution | open => fixed |
2016-02-04 07:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/19b60227dbe1b5d386656cf28c223d9da71e655a [^] |
2016-02-04 07:53 | hgbot | Checkin | |
2016-02-04 07:53 | hgbot | Note Added: 0083910 | |
2016-02-04 07:55 | hgbot | Checkin | |
2016-02-04 07:55 | hgbot | Note Added: 0083912 | |
2016-02-18 12:53 | marvintm | Status | resolved => closed |
2016-02-18 12:53 | marvintm | Fixed in Version | => RR16Q2 |
Copyright © 2000 - 2009 MantisBT Group |