Receipt REST call "A Valid Our Quantity is required."

Epicor ERP 10
,
1

I’m getting this error message on the updateEXT method using REST.

    Response Body
    {
      "returnObj": {
        "BOUpdError": [
      {
        "TableName": "RcvDtl",
        "ErrorLevel": "Error",
        "ErrorType": "Exception",
        "ErrorText": "A Valid Our Quantity is required.",
        "ErrorSysRowID": "00000000-0000-0000-0000-000000000000",
        "SysRowID": "c446ed31-7876-4312-9695-03e796153744",
        "RowMod": ""
      }
    ],
    "ExtensionTables": []

This is the input code I’m using.

{
  "ds": {
  "RcvHead": [
      {
        "Company":"xxxxx",
		"PackSlip":"200048",
		"PurPoint":"",
		"VendorNum":18,
		"ShipViaCode":"EG"
      }
    ],
		"RcvDtl": [
      {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700DR",
        "WareHouseCode": "MQ",
        "BinNum": "4901A1",
        "OurQty": "28.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 1,
		"ReceiptType": "P",
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":82.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700MR",
        "WareHouseCode": "MQ",
        "BinNum": "4901A2",
        "OurQty": "26.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 2,
		"ReceiptType": "P",
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":45.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700CH",
        "WareHouseCode": "MQ",
        "BinNum": "4902A1",
        "OurQty": "23.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 3,
		"ReceiptType": "P",
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":75.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700NS",
        "WareHouseCode": "MQ",
        "BinNum": "4902A2",
        "OurQty": "72.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 4,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":35.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700THF",
        "WareHouseCode": "MQ",
        "BinNum": "4903A1",
        "OurQty": "27.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 5,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":98.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700TR",
        "WareHouseCode": "MQ",
        "BinNum": "4903A2",
        "OurQty": "27.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 6,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":26.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700TT",
        "WareHouseCode": "MQ",
        "BinNum": "4905A1",
        "OurQty": "26.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 7,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":25.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700FHF",
        "WareHouseCode": "MQ",
        "BinNum": "4904A1",
        "OurQty": "20.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 8,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":115.00,
        "PORelNum": 1
        
      },
	  {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 1,
		"PartNum": "AN700FR",
        "WareHouseCode": "MQ",
        "BinNum": "4904A2",
        "OurQty": "21.00",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 9,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":34.00,
        "PORelNum": 1
        
      }
	  
    ]
    
		
  
  },
  "continueProcessingOnError": true,
  "rollbackParentOnChildError": true
}
2

I think there is a field called:
InputOurQty

That is what you need to populate

1 Like
3

I’m still getting the “A Valid Our Quantity is required.” error

4

That’s the only place I see it

image
image859×144 10.1 KB

Did you add and populate InputOurQty in all records you are passing?

1 Like
5

I tried to pass one line with ourqty and inputourqty. I still received the error.

{
  "ds": {
  "RcvHead": [
      {
        "Company":"xxxxx",
		"PackSlip":"200048",
		"PurPoint":"",
		"VendorNum":18,
		"ShipViaCode":"EG"
      }
    ],
		"RcvDtl": [
      {
		"Company": "xxxxx",
        "VendorNum": 18,
        "PurPoint": "",
        "PackSlip": "200048",
        "PackLine": 0,
		"PartNum": "AN700DR",
        "WareHouseCode": "MQ",
        "BinNum": "4901A1",
        "IUM": "EA",
		"PONum": 200048,
        "POLine": 1,
		"ReceivedTo":"PUR-STK",
		"DocScrVendorUnitCost":82.00,
        "PORelNum": 1,
		"VendorQty":0,
		"OurQty":28,
		"InputOurQty":28
        
      }
	  
    ]
    
		
  
  },
  "continueProcessingOnError": true,
  "rollbackParentOnChildError": true
}
6

The error after you added InputOurQty is different.

“ErrorText”: “A Valid Supplier Quantity is required.”

You need to specify VendorQty

1 Like
7

Are the UpdateExt methods still expecting a RowMod = ‘U’/‘A’ ?

1 Like
8

I don’t think so, it uses the values passed to find existing records, if it exists it tries to update it and if not it tries to create a new one.