Issue material using external c# but JobNum does not allow nulls error

ERP 10
1

Hi,

I’m getting a JobNum does not allow nulls error when running the below code:

string pcTranType = "STK-MTL";
Guid pcMtlQueueRowID = new Guid("00000000-0000-0000-0000-000000000000");
string pCallProcess = "IssueMaterial";

SelectedJobAsmblDataSet selectedJobAsmblDataSet = new SelectedJobAsmblDataSet();
SelectedJobAsmblRow selectedJobAsmblRow = new SelectedJobAsmblRow();
selectedJobAsmblRow.Company = company;
selectedJobAsmblRow.JobNum = "156314";
selectedJobAsmblRow.AssemblySeq = 0;
selectedJobAsmblRow.SysRowID = new Guid("00000000-0000-0000-0000-000000000000");
selectedJobAsmblRow.RowMod = "";
selectedJobAsmblRow.Added();
selectedJobAsmblDataSet.Tables.Add();
selectedJobAsmblDataSet.Tables[0].Rows.Add(selectedJobAsmblRow);

IssueReturnDataSet issueReturnDataSet = issueReturnImpl.GetNewJobAsmblMultiple(pcTranType, pcMtlQueueRowID, pCallProcess, selectedJobAsmblDataSet, out string pcMessage);

Does anyone know what could be causing this error?

Thanks,
Matt

2

Should not RowMod be “U” or in this case of added row “A”?

3

Thanks Clint, I’ve found the solution and needed to modify RowMod later to update the quantity.

Solution was:

string pcTranType = "STK-MTL";
Guid pcMtlQueueRowID = new Guid("00000000-0000-0000-0000-000000000000");
string pCallProcess = "IssueMaterial";

SelectedJobAsmblDataSet selectedJobAsmblDataSet = new SelectedJobAsmblDataSet();
DataTable table = selectedJobAsmblDataSet.Tables[0];
DataRow dataRow = table.NewRow();
dataRow["Company"] = company;
dataRow["JobNum"] = "156314";
dataRow["AssemblySeq"] = 0;
table.Rows.Add(dataRow);

IssueReturnDataSet issueReturnDataSet = issueReturnImpl.GetNewJobAsmblMultiple(pcTranType, pcMtlQueueRowID, pCallProcess, selectedJobAsmblDataSet, out string pcMessage);
1 Like