Lost Sales Transaction

The Lost Sales Transaction is used to get Lost Sales information for display. The request and response JSON strings are defined below.

Filters are optional:
If locationids are left blank – all locations for the member will be returned
If accountids are left blank – all accounts for the member will be returned
If utcbegintime is left blank – data will be returned for prior 30 days from utcendtime
If utcendtime is left blank – data will be returned from utcbegintime to current date
If both utcbegintime and utcendtime are left blank – data will be returned for prior 30 days from current date
If mfrcode is left blank – all mfrcodes for the member will be returned
If partno is left blank – all partno for the member will be returned

Request JSON Example (Version 1.0)

The following is an example of the JSON string that will be posted

{
   "lostsalerequest": {
      "version": "1.0",
      "utctime": "2014-07-04 11:00:26",
      "transid": "5038ab89-d86a-4c32-9206-ec50f7a40a02",
      "memberno": "1234",
      "username": "username",
      "password": "password",
      "filters": {
         "utcbegintime": "2015-10-18 00:00:00",
         "utcendtime": "2015-10-18 23:59:59",
         "accountids": "123456,112233,445566",
         "locationids": "branch1,branch2,branch3",
         "mfrcode": "HAS",
         "partno": "LF115"
      }
   }
}

Response JSON Example (Version 1.0)

The following is an example of the JSON string to be returned

{
   "lostsaleresponse": {
      "version": "1.0",
      "utctime": "2014-07-04 11:00:27",
      "transid": "5038ab89-d86a-4c32-9206-ec50f7a40a02",
      "status": "success",
      "errordescription": "",
      "filters": {
         "utcbegintime": "2015-10-18 00:00:00",
         "utcendtime": "2015-10-18 23:59:59",
         "accountids": "123456,112233,445566",
         "locationids": "branch1,branch2,branch3"
      },
      "lostsales": [
         {
            "locationid": "Branch1",
            "mfrcode": "HAS",
            "partno": "LF115",
            "username": "a123",
            "accountid": "123456",
            "qty": 1,
            "price": 17.8,
            "reasoncode": 3,
            "reason": "Price too High",
            "catregion": "Default",
            "utclogtime": "2015-10-18 09:16:31"
         },
         {
            "locationid": "Branch2",
            "mfrcode": "FEF",
            "partno": "LF115F",
            "username": "b123",
            "accountid": "112233",
            "qty": 1,
            "price": 1.8,
            "reasoncode": 3,
            "reason": "Price too High",
            "catregion": "Default",
            "utclogtime": "2015-10-18 19:21:13"
         }
      ]
   }
}