0047327: Configure and sell a product with Autobom gives an EWI : JSONObject["gross"] not found

Description

After following the wiki for configuring a BOM product using AutoBom, then selling it from the webpos, there is an EWI error showing that on the JSON sent to the backend the "gross" JSONObject is not included there
(maybe there was some missing information on the autobom wiki, but I think I followed all the steps properly there described)
http://wiki.openbravo.com/wiki/Modules:Auto_BOM_for_Retail/User_Documentation [^]

Steps To Reproduce

* download a CS Openbravo version locally, 20Q4.4
* add modules openbravo for retail, retail sampledata, auto bom (which will include dependant modules: bom versions, bom versions template)
* as System Admin role, set core module to be in development (from Module window, module name core, field In Development)
* go to window Windows, Tab & Fields, select Product, remove filters and on tab Tab select Manufacturing and set it to be active
* also on Windows, Tab & Fields, select Bill Of Materials Production and set it to be active
* compile (stopping tomcat) in order to have changes available
* change role to The White Valley Group Admin, go to Product window, select Avalanche Transceiver, mark field Bill of Materials and Auto Generate BOM as selected (we are setting product configuration as in the wiki: http://wiki.openbravo.com/wiki/Modules:Auto_BOM_for_Retail/User_Documentation#Product_configuration [^])
* on Bill of Materials tab for this product, add two products: Alpine poles and Alpine ski boot. With BOM Quantity = 1 (see image attached)
* on Manufacturing tab add the Vall Blanca Store and Central Mountains Store with their storage bin 0-0-0 (see manufacturing image attached)
* go to the webpos, add the product Avalanche Transceiver to the ticket, go to checkout, click on pay total then on done
* go to window from backoffice Errors While Importing POS Data (EWI), then see that a new record has been created and the order has not been taken into account properly (see attached documents for an example of its JSON and error output)

Tags

No tags attached.

Attached Files

23646 - producto configurado.png [^] (173,307 bytes) 2021-07-05 10:45

23646 - manufacturing configurado.png [^] (185,510 bytes) 2021-07-05 10:45

23646 - json ewi [^] (14,064 bytes) 2021-07-05 10:45 [Show Content] [Hide Content]

{
  "hasbeenpaid": "Y",
  "isbeingprocessed": "N",
  "id": "16A2A3A2FCD00D3420908C740A80630E",
  "client": "39363B0921BB4293B48383844325E84C",
  "organization": "D270A5AC50874F8BA67A88EE977F8E3B",
  "createdBy": "3073EDF96A3C42CC86C7069E379522D2",
  "updatedBy": "3073EDF96A3C42CC86C7069E379522D2",
  "documentType": "511A9371A0F74195AA3F6D66C722729D",
  "orderType": 0,
  "generateInvoice": false,
  "isQuotation": false,
  "oldId": null,
  "priceList": "496CF965DF9744D2A41248392D1DE407",
  "priceIncludesTax": true,
  "currency": "102",
  "currency$_identifier": "EUR",
  "session": "2687DF846A0AB8876DEF6AC274C02286",
  "warehouse": "CE7AB151695342FF879938F837F12E6E",
  "salesRepresentative": "3073EDF96A3C42CC86C7069E379522D2",
  "salesRepresentative$_identifier": "Vall Blanca Store User",
  "posTerminal": "9104513C2D0741D4850AE8493998A7C8",
  "posTerminal$_identifier": "VBS POS Terminal",
  "orderDate": "2021-06-07T11:11:51.397Z",
  "creationDate": "2021-06-07T11:11:41.037Z",
  "documentNo": "VBS1/0000108",
  "lines": [
    {
      "product": {
        "id": "934E7D7587EC4C7A9E9FF58F0382D450",
        "searchkey": "WVG/M0019",
        "uPCEAN": null,
        "_identifier": "Avalanche transceiver",
        "productType": "I",
        "hasAttributes": false,
        "productCharacteristics": [
          {
            "id": "03BDA8CD488345D882A45ED7B830F5BD",
            "product": "934E7D7587EC4C7A9E9FF58F0382D450",
            "characteristic": "DE2024EF85B64A779B1C8D978127BC50",
            "_identifier": "Price",
            "active": true,
            "obposFilteronwebpos": true,
            "characteristicValue": "AB1BA2A0DD2A4B83A566F880EEEF4929"
          },
          {
            "id": "1FB507A27F104BD5A62289DE504D861B",
            "product": "934E7D7587EC4C7A9E9FF58F0382D450",
            "characteristic": "D2DB5F7678F1431BAC0F5D754E3706BB",
            "_identifier": "Object",
            "active": true,
            "obposFilteronwebpos": true,
            "characteristicValue": "BEB24E3FA2A7408FB96531D12F448A85"
          },
          {
            "id": "4D4AC17480624023ACFC118A1D9C2A1E",
            "product": "934E7D7587EC4C7A9E9FF58F0382D450",
            "characteristic": "E3BFC19646784F3EBBE1BFC109BE46BF",
            "_identifier": "Range",
            "active": true,
            "obposFilteronwebpos": true,
            "characteristicValue": "97C16FD369584D03BCCE645CE352DA09"
          },
          {
            "id": "53516AC1477D464AA5E7B8E0FB0C7484",
            "product": "934E7D7587EC4C7A9E9FF58F0382D450",
            "characteristic": "2E488EBFB4CD43E1AC7990C08660DE35",
            "_identifier": "Brand",
            "active": true,
            "obposFilteronwebpos": true,
            "characteristicValue": "BC122628815941E99BB0EE7342F4B9BE"
          },
          {
            "id": "D19208CE6D5049518AB7FC50C9567745",
            "product": "934E7D7587EC4C7A9E9FF58F0382D450",
            "characteristic": "2F65268BEAF846E2A9FF41BB78DA7D73",
            "_identifier": "Battery Life",
            "active": true,
            "obposFilteronwebpos": true,
            "characteristicValue": "EAF12F6707EB44B7AA2CE2A5B1ACF890"
          },
          {
            "id": "DE0CF4BBBD69446EBF94AA16104E25B6",
            "product": "934E7D7587EC4C7A9E9FF58F0382D450",
            "characteristic": "CD99DC9C65B344E48D29B8EDFEB9905C",
            "_identifier": "Use",
            "active": true,
            "obposFilteronwebpos": true,
            "characteristicValue": "B1D2BCD5A2A74087BDCDA781F341048D"
          }
        ]
      },
      "productidentifier": null,
      "uOM": "100",
      "qty": 1,
      "priceList": 0,
      "description": "",
      "attributeValue": "",
      "obposCanbedelivered": true,
      "id": "7FFF22807D3ED9ED9D7DFCBE11FF873D",
      "organization": {
        "id": "D270A5AC50874F8BA67A88EE977F8E3B",
        "orgName": "Vall Blanca Store",
        "country": "106",
        "region": "AF310D01B53B461283EB40DB21DCA6B5"
      },
      "warehouse": {
        "id": "A154EC30A296479BB078B0AFFD74CA22",
        "warehousename": "Vall Blanca Store Warehouse"
      },
      "priceIncludesTax": true,
      "isEditable": true,
      "isDeletable": true,
      "grossListPrice": 150.5,
      "obrdmDeliveryMode": "PickAndCarry",
      "country": "106",
      "region": "AF310D01B53B461283EB40DB21DCA6B5",
      "kindOriginator": "OB.UI.ListProducts",
      "hasRelatedServices": false,
      "hasMandatoryServices": false,
      "promotions": [],
      "grossUnitPrice": 150.5,
      "grossUnitAmount": 150.5,
      "netUnitAmount": 124.38,
      "tax": "5235D8E99A2749EFA17A5C92A52AEFC6",
      "taxes": {
        "5235D8E99A2749EFA17A5C92A52AEFC6": {
          "id": "5235D8E99A2749EFA17A5C92A52AEFC6",
          "net": 124.38,
          "amount": 26.12,
          "name": "Entregas IVA 21%",
          "docTaxAmount": "D",
          "rate": 21,
          "taxBase": null,
          "cascade": false,
          "lineNo": 10
        }
      },
      "nameDelivery": "Pick and carry",
      "baseGrossUnitAmount": 150.5,
      "baseNetUnitAmount": 0,
      "netUnitPrice": 124.38,
      "netListPrice": 0,
      "baseGrossUnitPrice": 150.5,
      "taxRate": 1.21,
      "obposIspaid": true,
      "obposQtytodeliver": 1
    }
  ],
  "orderManualPromotions": [],
  "payments": [
    {
      "amount": 150.5,
      "origAmount": 150.5,
      "paid": 150.5,
      "date": "2021-06-07T11:11:50.544Z",
      "kind": "OBPOS_payment.cash",
      "name": "Cash",
      "rate": "1",
      "mulrate": "1.000000000000",
      "isocode": "EUR",
      "allowOpenDrawer": true,
      "isCash": true,
      "openDrawer": false,
      "printtwice": false,
      "id": "4BEAE0E3DBA72708A48CBC250CAAE2BF",
      "oBPOSPOSTerminal": "9104513C2D0741D4850AE8493998A7C8",
      "orderGross": 150.5,
      "isPaid": false,
      "isReturnOrder": false,
      "precision": 2
    }
  ],
  "payment": 150.5,
  "paymentWithSign": 150.5,
  "change": 0,
  "qty": 1,
  "taxes": {
    "5235D8E99A2749EFA17A5C92A52AEFC6": {
      "id": "5235D8E99A2749EFA17A5C92A52AEFC6",
      "net": 124.38,
      "amount": 26.12,
      "name": "Entregas IVA 21%",
      "docTaxAmount": "D",
      "rate": 21,
      "taxBase": null,
      "cascade": false,
      "lineNo": 10
    }
  },
  "description": "",
  "print": true,
  "sendEmail": false,
  "isPaid": false,
  "creditAmount": 0,
  "paidPartiallyOnCredit": false,
  "paidOnCredit": false,
  "isLayaway": false,
  "isEditable": true,
  "openDrawer": false,
  "approvals": [],
  "isPartiallyDelivered": false,
  "obposPrepaymentamt": 150.5,
  "obposPrepaymentlimitamt": 150.5,
  "obposPrepaymentlaylimitamt": 0,
  "cashVAT": false,
  "cloningReceipt": false,
  "invoiceTerms": "I",
  "obrdmDeliveryModeProperty": "PickAndCarry",
  "obrdmDeliveryDateProperty": "",
  "obrdmDeliveryTimeProperty": "",
  "nettingPayment": 0,
  "organizationTaxId": "B87654321",
  "organizationAddressIdentifier": "Pau Claris 138 1-1 -  - 08009 - Barcelona - BARCELONA   - Spain",
  "trxOrganization": "D270A5AC50874F8BA67A88EE977F8E3B",
  "isBeingDiscounted": false,
  "reApplyDiscounts": false,
  "calculateReceiptCallbacks": [],
  "selectedPayment": "OBPOS_payment.cash",
  "isNegative": false,
  "changePayments": [],
  "timezoneOffset": -120,
  "businessPartner": {
    "id": "ABD91C9D3BC94175B876FBBE9CACA008",
    "organization": "D270A5AC50874F8BA67A88EE977F8E3B",
    "searchKey": "VBS/C0001",
    "greetingId": null,
    "greetingName": null,
    "_identifier": "VBS Customer",
    "name": "VBS Customer",
    "firstName": "VBS Customer",
    "lastName": null,
    "description": null,
    "taxID": null,
    "taxCategory": null,
    "paymentMethod": "45A202BF44884F05B8A1BF741E2063B6",
    "paymentTerms": "D8955F8808A54C63BBF478A6843D834D",
    "priceList": "496CF965DF9744D2A41248392D1DE407",
    "invoiceTerms": "I",
    "contactId": "032576220FC44B0DA80145B3265E4D9A",
    "phone": null,
    "alternativePhone": null,
    "email": null,
    "businessPartnerCategory": "B1DD8B371643421C987EF1D5B358D5E9",
    "businessPartnerCategory_name": "Customer",
    "creditLimit": 0,
    "creditUsed": 0,
    "taxExempt": false,
    "customerBlocking": false,
    "salesOrderBlocking": true,
    "priceIncludesTax": true,
    "priceListName": "The White Valley Group Sale Price List",
    "priceListCurrency": "102",
    "loaded": "2021-06-07T13:11:33+02:00",
    "birthDay": null,
    "birthPlace": null,
    "isCustomerConsent": false,
    "language": "en_US",
    "language_name": "English (USA)",
    "comments": null,
    "availableCredit": 0,
    "commercialauth": false,
    "viaemail": false,
    "viasms": false,
    "shipLocId": "2AA7EADDF7EC405899262DDA3E572436",
    "shipLocName": "Pau Claris 138 1-1",
    "shipCityName": "Barcelona",
    "shipPostalCode": "08009",
    "locationModel": {
      "id": "2AA7EADDF7EC405899262DDA3E572436",
      "bpartner": "ABD91C9D3BC94175B876FBBE9CACA008",
      "name": "Pau Claris 138 1-1",
      "postalCode": "08009",
      "cityName": "Barcelona",
      "countryName": "Spain",
      "countryId": "106",
      "regionName": "BARCELONA  ",
      "regionId": "AF310D01B53B461283EB40DB21DCA6B5",
      "isBillTo": true,
      "isShipTo": true,
      "_identifier": "Pau Claris 138 1-1",
      "creationDate": "2013-07-04T23:01:13+02:00",
      "loaded": "2021-06-07T13:11:33+02:00"
    },
    "locId": "2AA7EADDF7EC405899262DDA3E572436",
    "locName": "Pau Claris 138 1-1",
    "cityName": "Barcelona",
    "postalCode": "08009",
    "countryName": "Spain",
    "locationBillModel": {
      "id": "2AA7EADDF7EC405899262DDA3E572436",
      "bpartner": "ABD91C9D3BC94175B876FBBE9CACA008",
      "name": "Pau Claris 138 1-1",
      "postalCode": "08009",
      "cityName": "Barcelona",
      "countryName": "Spain",
      "countryId": "106",
      "regionName": "BARCELONA  ",
      "regionId": "AF310D01B53B461283EB40DB21DCA6B5",
      "isBillTo": true,
      "isShipTo": true,
      "_identifier": "Pau Claris 138 1-1",
      "creationDate": "2013-07-04T23:01:13+02:00",
      "loaded": "2021-06-07T13:11:33+02:00"
    },
    "locations": [
      {
        "id": "2AA7EADDF7EC405899262DDA3E572436",
        "bpartner": "ABD91C9D3BC94175B876FBBE9CACA008",
        "name": "Pau Claris 138 1-1",
        "postalCode": "08009",
        "cityName": "Barcelona",
        "countryName": "Spain",
        "countryId": "106",
        "regionName": "BARCELONA  ",
        "regionId": "AF310D01B53B461283EB40DB21DCA6B5",
        "isBillTo": true,
        "isShipTo": true,
        "_identifier": "Pau Claris 138 1-1",
        "creationDate": "2013-07-04T23:01:13+02:00",
        "loaded": "2021-06-07T13:11:33+02:00"
      }
    ]
  },
  "grossAmount": 150.5,
  "netAmount": 124.38,
  "completeTicket": true,
  "movementDate": "2021-06-07T11:11:51.397Z",
  "accountingDate": "2021-06-07T11:11:51.397Z",
  "obposCreatedabsolute": "2021-06-07T11:11:41.037Z",
  "created": 1623064301037,
  "undo": null,
  "multipleUndo": null,
  "paymentMethodKind": "OBPOS_payment.cash",
  "obposSequencename": "lastassignednum",
  "obposSequencenumber": 108,
  "generateShipment": true,
  "deliver": true,
  "obposAppCashup": "3B39E21A2DD9D8B74A5C3FCB316DA1FA",
  "cashUpReportInformation": {
    "id": "3B39E21A2DD9D8B74A5C3FCB316DA1FA",
    "netSales": 124.38,
    "grossSales": 150.5,
    "netReturns": 0,
    "grossReturns": 0,
    "totalRetailTransactions": 150.5,
    "totalStartings": 0,
    "creationDate": "2015-11-20T11:47Z",
    "userId": "3073EDF96A3C42CC86C7069E379522D2",
    "cashTaxInfo": [
      {
        "id": "B0758DA95F40CDBF5D00366F9FDD4BAD",
        "name": "Entregas IVA 21%",
        "amount": 26.12,
        "orderType": "0"
      }
    ],
    "cashPaymentMethodInfo": [
      {
        "id": "B2578C25CFB99AB1BECE93776F201467",
        "paymentMethodId": "5EA2A7DEBB2A49A69550C7E3D8899ED5",
        "searchKey": "OBPOS_payment.card",
        "name": "Card",
        "startingCash": 0,
        "totalSales": 0,
        "totalReturns": 0,
        "totalDeposits": 0,
        "totalDrops": 0,
        "rate": "1",
        "isocode": "EUR",
        "newPaymentMethod": true,
        "cashManagements": [],
        "usedInCurrentTrx": false
      },
      {
        "id": "47BB0C5B65A0BEAB60C6DD4A099FE40B",
        "paymentMethodId": "63339A82A49A4AE0BCD9AC5929B0EA3B",
        "searchKey": "OBPOS_payment.cash",
        "name": "Cash",
        "startingCash": 154.1,
        "totalSales": 150.5,
        "totalReturns": 0,
        "totalDeposits": 0,
        "totalDrops": 0,
        "rate": "1",
        "isocode": "EUR",
        "newPaymentMethod": true,
        "cashManagements": [],
        "usedInCurrentTrx": true
      },
      {
        "id": "6B2107D1C38B71B3E79497AD77F73646",
        "paymentMethodId": "E11EBCB5CF0442618B72B903DCB6A036",
        "searchKey": "OBPOS.payment.usacash",
        "name": "USA Cash",
        "startingCash": 0,
        "totalSales": 0,
        "totalReturns": 0,
        "totalDeposits": 0,
        "totalDrops": 0,
        "rate": "0.76082",
        "isocode": "USD",
        "newPaymentMethod": true,
        "cashManagements": [],
        "usedInCurrentTrx": false
      },
      {
        "id": "A83165D80577068ADC656F7C87163E68",
        "paymentMethodId": "6E98C4DE459748BE997693E9ED956D21",
        "searchKey": "OBPOS_payment.voucher",
        "name": "Voucher",
        "startingCash": 0,
        "totalSales": 0,
        "totalReturns": 0,
        "totalDeposits": 0,
        "totalDrops": 0,
        "rate": "1",
        "isocode": "EUR",
        "newPaymentMethod": true,
        "cashManagements": [],
        "usedInCurrentTrx": false
      }
    ],
    "isprocessed": "N",
    "posterminal": "9104513C2D0741D4850AE8493998A7C8",
    "trxOrganization": "D270A5AC50874F8BA67A88EE977F8E3B",
    "transitionsToOnline": "0",
    "logclientErrors": "0",
    "averageLatency": 11.666666666666666,
    "averageUploadBandwidth": null,
    "averageDownloadBandwidth": null
  }
}

23646 - error ewi [^] (1,846 bytes) 2021-07-05 10:45 [Show Content] [Hide Content]

org.codehaus.jettison.json.JSONException: JSONObject["gross"] not found.
	at org.codehaus.jettison.json.JSONObject.get(JSONObject.java:360)
	at org.codehaus.jettison.json.JSONObject.getDouble(JSONObject.java:399)
	at org.openbravo.retail.autobom.hooks.preOrderLoaderHook.exec(preOrderLoaderHook.java:27)
	at org.openbravo.retail.autobom.hooks.preOrderLoaderHook$Proxy$_$$_WeldClientProxy.exec(Unknown Source)
	at org.openbravo.retail.posterminal.OrderLoader.executeOrderLoaderPreProcessHook(OrderLoader.java:727)
	at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:290)
	at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:201)
	at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:156)
	at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:88)
	at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:54)
	at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(OrderImportEntryProcessor.java:64)
	at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:372)
	at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:293)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0131193) hgbot (developer) 2021-08-19 03:58	Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/merge_requests/15 [^]

(0131205) hgbot (developer) 2021-08-19 08:15	Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/merge_requests/15 [^]

(0131206) hgbot (developer) 2021-08-19 08:15	Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom [^] Changeset: 75350a7ba33efbb7ffbd56b62ea56388a3315b7c Author: Rafael Queralta <rafaelcuba81@gmail.com> Date: 2021-08-17T16:25:48-04:00 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/commit/75350a7ba33efbb7ffbd56b62ea56388a3315b7c [^] Fixed BUG-47327: Check if the order is a layaway to create a BOM transaction --- M src/org/openbravo/retail/autobom/process/BOMProcess.java ---

(0131379) hgbot (developer) 2021-08-26 20:09	Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/merge_requests/16 [^]

(0131381) hgbot (developer) 2021-08-27 07:48	Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/merge_requests/16 [^]

(0131382) marvintm (manager) 2021-08-27 07:49	https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.autobom/-/commit/95ee0b9c082b46b1562fa71d915223972ee90d38 [^]

Issue History
Date Modified	Username	Field	Change
2021-07-05 10:44	santi_lozano	New Issue
2021-07-05 10:44	santi_lozano	Assigned To	=> Retail
2021-07-05 10:44	santi_lozano	Resolution time	=> 1627250400
2021-07-05 10:44	santi_lozano	Triggers an Emergency Pack	=> No
2021-07-05 10:45	santi_lozano	File Added: 23646 - producto configurado.png
2021-07-05 10:45	santi_lozano	File Added: 23646 - manufacturing configurado.png
2021-07-05 10:45	santi_lozano	File Added: 23646 - json ewi
2021-07-05 10:45	santi_lozano	File Added: 23646 - error ewi
2021-07-08 17:02	rqueralta	Assigned To	Retail => rqueralta
2021-07-08 17:02	rqueralta	Status	new => scheduled
2021-07-15 16:24	Practics	Issue Monitored: Practics
2021-08-19 03:58	hgbot	Note Added: 0131193
2021-08-19 08:15	hgbot	Note Added: 0131205
2021-08-19 08:15	hgbot	Resolution	open => fixed
2021-08-19 08:15	hgbot	Status	scheduled => closed
2021-08-19 08:15	hgbot	Note Added: 0131206
2021-08-26 20:09	hgbot	Note Added: 0131379
2021-08-27 07:48	hgbot	Note Added: 0131381
2021-08-27 07:49	marvintm	Note Added: 0131382