REST API Exception: ttInventoryQtyAdj record not found

Epicor ERP 10
1

I went through the trace on an Inventory Quantity Adjustment.

I posted the following to SetInventoryQtyAdj:

{
“ds”: {
“InventoryQtyAdj”: [
{
“Company”: “300”,
“PartNum”: “10000030”,
“WareHseCode”: “51REG1”,
“OnHandQty”: 12,
“BinNum”: “MZ-11-01”,
“AdjustQuantity”: -2,
“ReasonCode”: “KANBAN”,
“LotNum”: “”,
“Reference”: “SWAGGER”,
“UnitOfMeasure”: “EA”,
“TransDate”: “2018-06-06T13:11:46.39Z”,
“ReasonType”: “M”,
“SerialNoQty”: 0,
“TempSerialNo”: 0,
“ReasonCodeReq”: true,
“AllowNegQty”: false,
“LegalNumberMessage”: “”,
“StkUOMCode”: “EA”,
“EnableSN”: false,
“OnHandUOM”: “EA”,
“TranDocTypeID”: “”,
“PCID”: “”,
“SysRowID”: “00000000-0000-0000-0000-000000000000”,
“ReasonCodeDescription”: “”,
“MYImportNum”: “”,
“PartTrackLots”: false,
“PartTrackDimension”: false,
“PartSalesUM”: “EA”,
“PartPricePerCode”: “E”,
“PartSellingFactor”: 1,
“PartTrackSerialNum”: false,
“PartIUM”: “EA”,
“PartPartDescription”: “FLO PAD 3 PORT ASSM C/W WEAR PLATE GRAY SURESEAL”,
“WareHseDescription”: “Regina Warehouses 175 & 144”,
“WhseBinDescription”: “Regina Bin MZ-11-01”,
“RowMod”: “”
}
],
“LegalNumGenOpts”: [],
“SelectedSerialNumbers”: [],
“SNFormat”: []
}
}

{“HttpStatus”:500,“ReasonPhrase”:“REST Api Exception”,“ErrorMessage”:“ttInventoryQtyAdj record not found.”,“ErrorType”:“Ice.BLException”}

Any help would be greatly appreciated.

2

For reference I did:

  1. FindPart
  2. GetInventoryQtyAdj
  3. GetInventoryQtyAdjBrw
  4. NegativeInventoryTest
  5. PreSetInventoryQtyAdj
  6. SetInventoryQtyAdj
3

RowMod needs to be U (or A)

1 Like
4

U or A mean Update and Add or ?

5

Look in the Epicor trace I don’t know which one your need for a Quantity Adjustment, but it needs to be set. That’s probably why EPicor can’t find the record it only looks at (Modified or Added rows)

6

Thanks - I didn’t have the trace dataset options set so I wasn’t seeing this part of the trace. It was set to U.

7

Jose - This worked for me.
How would we be able to determine this naturally through the REST swagger page? I would’ve never been able to figure this out.

8

You just neeed to look at the Epicor Trace to figure out what needs to be set it isnn’t a swagger issue. Its an Epicor Issue, trace is your friend.

2 Likes