The foreach loops have got to go. They are not how this is done.
let’s step by step
write out the values of all variables going into CreateSerialNumRange as well as the dataset going into and out of it
Specifically
upperLevel.PartNum,
jobAsmbl.RequiredQty,
startSerial
sourceRowID
and the dataset before the call, and after the call
selectedSerialNumbersTS
Thanks! Here are the variables you wanted, please note after the trace I created, I did build new jobs using the same parts for my automation/uBAQ testing, that is why the serials start at 80066. Also the person who setup the masking accidently added an extra 0 in the prefix, hence the 080066, but we manually removed the proceeding 0 when setting up the lower level part serial number assignment.
Inputs for CreateSerialNumRange:
upperLevel.PartNum: N00983203-1
jobAsmbl.RequiredQty: 15.00000000
startSerial: 080066
sourceRowID: 9f655539-5fc7-452e-8056-38f96aaef0ce:
“\r\n”
Selected Serial Numbers tableset before call:
{
"SelectedSerialNumbers":[
],
"SNFormat":[
{
"ColumnNames":0,
"Company":"401",
"Plant":"MfgSys",
"PartNum":"N00983203-1",
"NumberOfDigits":5,
"SNMask":"",
"SNBaseDataType":"INTEGER",
"SNFormat":"203-100009",
"LeadingZeroes":true,
"SNPrefix":"203-1",
"SNMaskSuffix":"",
"SNMaskPrefix":"",
"SNLastUsedSeq":"",
"HasSerialNumbers":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"BitFlag":0,
"PartPricePerCode":"E",
"PartTrackLots":true,
"PartTrackSerialNum":true,
"PartTrackDimension":false,
"PartSalesUM":"EA",
"PartIUM":"EA",
"PartSellingFactor":1.00000000,
"PartPartDescription":"Precision Part, Machined, 83mm",
"SerialMaskMaskType":0,
"SerialMaskMask":"",
"SerialMaskExample":"",
"SerialMaskDescription":"",
"RowMod":"",
"SpecifiedProperties":"/5f/Bw==",
"UserDefinedColumns":{
}
}
],
"ExtensionTables":[
]
}
Selected Serial Numbers tableset after call:
{
"SelectedSerialNumbers":[
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180066",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080066",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180066",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180067",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080067",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180067",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180068",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080068",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180068",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180069",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080069",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180069",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180070",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080070",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180070",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180071",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080071",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180071",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180072",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080072",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180072",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180073",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080073",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180073",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180074",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080074",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180074",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180075",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080075",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180075",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180076",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080076",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180076",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180077",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080077",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180077",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180078",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080078",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180078",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180079",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080079",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180079",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180080",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080080",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180080",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"RowSelected":false,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"Ax8xEg==",
"UserDefinedColumns":{
}
}
],
"SNFormat":[
{
"ColumnNames":0,
"Company":"401",
"Plant":"MfgSys",
"PartNum":"N00983203-1",
"NumberOfDigits":5,
"SNMask":"",
"SNBaseDataType":"INTEGER",
"SNFormat":"203-100009",
"LeadingZeroes":true,
"SNPrefix":"203-1",
"SNMaskSuffix":"",
"SNMaskPrefix":"",
"SNLastUsedSeq":"",
"HasSerialNumbers":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"BitFlag":0,
"PartPricePerCode":"E",
"PartTrackLots":true,
"PartTrackSerialNum":true,
"PartTrackDimension":false,
"PartSalesUM":"EA",
"PartIUM":"EA",
"PartSellingFactor":1.00000000,
"PartPartDescription":"Precision Part, Machined, 83mm",
"SerialMaskMaskType":0,
"SerialMaskMask":"",
"SerialMaskExample":"",
"SerialMaskDescription":"",
"RowMod":"",
"SpecifiedProperties":"/5f/Bw==",
"UserDefinedColumns":{
}
}
],
"ExtensionTables":[
]
}
Is the mess up with the serial with the proceeding 0 causing the issue you think?
pass
<SNFormat>99999</SNFormat>
<HasSerialNumbers>false</HasSerialNumbers>
TO CreateSerialNumRange
when you get the dataset out of it, pass it directly to setSerialNoAssign
do true and check the warning as well
serialNoAssign.SetSerialNoAssign(ref serialNoAssignDS, true, out oprCmpWarning);
Unsure
How would I pass the dataset to SetSerialNoAssign without the foreach loops copying the data to the setserialno tableset?
It’s the same dataset you should be passing all along
serialNoAssign.SetSerialNoAssign(ref selectedSerialNumbersTS, true, out oprCmpWarning);
Oh I see what you are saying. They datasets are identical other than the name.
I’d try to cast it if it gives you trouble
I can bring up a code window later and try
Yeah it complains saying:
Cannot convert type ‘Erp.Tablesets.SelectedSerialNumbersTableset’ to ‘Erp.Tablesets.SerialNoAssignTableset’
shot in the dark
serialNoAssign.SetSerialNoAssign(ref (Erp.Tablesets.SerialNoAssignTableset)selectedSerialNumbersTS, true, out oprCmpWarning);
We posted at the same time xD, just so you get the notification, I attempted that but the compiler gave me an error: Cannot convert type ‘Erp.Tablesets.SelectedSerialNumbersTableset’ to ‘Erp.Tablesets.SerialNoAssignTableset’
Put your copies back in and check to make sure this part is correct
<SerialNoAssign>
<Company>401</Company>
<JobNumber>000010</JobNumber>
<AssemblySeq>0</AssemblySeq>
<PartDescription>Precision Part, Machined, 83mm</PartDescription>
<SerialNoQty>13</SerialNoQty>
<PartNum>N00983203-1</PartNum>
<JobQty>13.00000000</JobQty>
<SysRowID>whateveritssupposedtobe</SysRowID>
<RowMod></RowMod>
</SerialNoAssign>
Also, could you send me your bpm/baq ?
Hey good catch, so the JobQty was 15.00000000, but SerialNoQty was 0.0. That would be why it is failing right? Should I manually set that value?
I messaged you the source code to the uBAQ. The uBAQ takes in the following inputs:
So yeah I manually set the SerialNoQty to 15, still same error 
Ok, let’s fix this.
First off this trace is entirely too big.
Run a trace again with write full dataset & write response data only.
Create 2 serials.
Use the same part and job for your code.
Also let’s just create two.
// Setup our service calls
var serialNoAssign = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.SerialNoAssignSvcContract>(Db);
var selectedSerialNums = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.SelectedSerialNumbersSvcContract>(Db);
//Try this copy procedure
var selectedSerialNumbersTS = new Erp.Tablesets.SelectedSerialNumbersTableset();
var serialNoAssignTS = new Erp.Tablesets.SerialNoAssignTableset();
foreach(var ssRow in selectedSerialNumbersTS.SelectedSerialNumbers)
{
var nRow = serialNoAssignTS.SelectedSerialNumbers.NewRow();
foreach(var col in selectedSerialNumbersTS.SelectedSerialNumbers.Columns)
{
nRow[col.ColumnName] = ssRow[col.ColumnName];
}
}
foreach(var ssRow in selectedSerialNumbersTS.SNFormat)
{
var nRow = serialNoAssignTS.SNFormat.NewRow();
foreach(var col in selectedSerialNumbersTS.SNFormat.Columns)
{
nRow[col.ColumnName] = ssRow[col.ColumnName];
}
}
Erp.Tablesets.SerialNoAssignRow snaRow = (Erp.Tablesets.SerialNoAssignRow)serialNoAssignTS.SerialNoAssign.NewRow();
//Fill with real values
snaRow.Company = "bla";
snaRow.JobNumber = "bla";
snaRow.AssemblySeq = 0;
snaRow.PartDescription = "whatever";
snaRow.SerialNoQty = 2;
snaRow.PartNum = "whatever";
snaRow.JobQty = 2;
snaRow.SysRowID = Guid.Empty; //Obviously not
snaRow.RowMod = "U";
//Edit because I forgot
serialNoAssignTS.SerialNoAssign.Add(snaRow);
I added in the code:
var serialNoAssignTS = new Erp.Tablesets.SerialNoAssignTableset();
foreach(var ssRow in selectedSerialNumbersTS.SelectedSerialNumbers)
{
var nRow = serialNoAssignTS.SelectedSerialNumbers.NewRow();
foreach(var col in selectedSerialNumbersTS.SelectedSerialNumbers.Columns)
{
nRow[col.ColumnName] = ssRow[col.ColumnName];
}
}
foreach(var ssRow in selectedSerialNumbersTS.SNFormat)
{
var nRow = serialNoAssignTS.SNFormat.NewRow();
foreach(var col in selectedSerialNumbersTS.SNFormat.Columns)
{
nRow[col.ColumnName] = ssRow[col.ColumnName];
}
}
Erp.Tablesets.SerialNoAssignRow snaRow = (Erp.Tablesets.SerialNoAssignRow)serialNoAssignTS.SerialNoAssign.NewRow();
snaRow.Company = "401";
snaRow.JobNumber = "000012";
snaRow.AssemblySeq = 0;
snaRow.PartDescription = "Precision Part, Machined, 83mm";
snaRow.SerialNoQty = 2;
snaRow.PartNum = "N00983203-1";
snaRow.JobQty = 2;
snaRow.SysRowID = serialNoAssignDS.SerialNoAssign.Select(m => m.SysRowID).FirstOrDefault(); // Using the SysRowID from serialNoAssign.GetSerialNoAssign above
snaRow.RowMod = "U";
debugMsg("Serial No Assign TS", serialNoAssignTS);
But the output is:
{"SelectedSerialNumbers":[],"SerialNoAssign":[],"SNFormat":[],"ExtensionTables":[]}
I got it, needed to add the Add(nRow) to the foreach loops. But as you can see below, still the same issue. So I am going to have the employee I work with fix the serials and setup a new job set with a smaller serial count.
So the output of Serial No Assign TS is:
{
"SelectedSerialNumbers":[
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180066",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080066",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180066",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180067",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080067",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180067",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180068",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080068",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180068",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180069",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080069",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180069",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180070",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080070",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180070",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180071",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080071",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180071",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180072",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080072",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180072",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180073",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080073",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180073",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180074",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080074",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180074",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180075",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080075",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180075",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180076",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080076",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180076",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180077",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080077",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180077",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180078",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080078",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180078",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180079",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080079",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180079",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
},
{
"ColumnNames":0,
"Company":"401",
"SerialNumber":"203-180080",
"Scrapped":false,
"ScrappedReasonCode":"",
"Voided":false,
"Reference":"",
"ReasonCodeType":"",
"ReasonCodeDesc":"",
"PartNum":"N00983203-1",
"SNPrefix":"203-1",
"SNBaseNumber":"00000000000000080080",
"SourceRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce",
"TransType":"",
"PassedInspection":false,
"Deselected":false,
"KitWhseList":"",
"RawSerialNum":"203-180080",
"KBLbrAction":0,
"KBLbrActionDesc":"",
"PreventDeselect":false,
"XRefPartNum":"",
"XRefPartType":"",
"PreDeselected":false,
"poLinkValues":"",
"SNMask":"",
"NotSavedToDB":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"RowMod":"A",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
"RowSelected":false
}
}
],
"SerialNoAssign":[
],
"SNFormat":[
{
"ColumnNames":0,
"Company":"401",
"Plant":"MfgSys",
"PartNum":"N00983203-1",
"NumberOfDigits":5,
"SNMask":"",
"SNBaseDataType":"INTEGER",
"SNFormat":"203-100009",
"LeadingZeroes":true,
"SNPrefix":"203-1",
"SNMaskSuffix":"",
"SNMaskPrefix":"",
"SNLastUsedSeq":"",
"HasSerialNumbers":true,
"SysRowID":"00000000-0000-0000-0000-000000000000",
"BitFlag":0,
"PartPricePerCode":"E",
"PartTrackLots":true,
"PartTrackSerialNum":true,
"PartTrackDimension":false,
"PartSalesUM":"EA",
"PartIUM":"EA",
"PartSellingFactor":1.00000000,
"PartPartDescription":"Precision Part, Machined, 83mm",
"SerialMaskMaskType":0,
"SerialMaskMask":"",
"SerialMaskExample":"",
"SerialMaskDescription":"",
"RowMod":"",
"SpecifiedProperties":"////Dw==",
"UserDefinedColumns":{
}
}
],
"ExtensionTables":[
]
}
Running the code, I got:
Business Layer Exception
ttSerialNoAssign record not found.
Exception caught in: Epicor.ServiceModel
Error Detail
============
Correlation ID: e34c6b3f-9a30-496a-a682-88e85673c5a2
Description: ttSerialNoAssign record not found.
Program: Erp.Services.BO.SerialNoAssign.dll
Method: SetSerialNoAssign
Line Number: 605
Column Number: 17
Table: ttSerialNoAssign
Field: RowMod
Client Stack Trace
==================
at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Ice.Proxy.BO.DynamicQueryImpl.GetList(DynamicQueryDataSet queryDS, QueryExecutionDataSet executionParams, Int32 pageSize, Int32 absolutePage, Boolean& hasMorePage)
at Ice.Adapters.DynamicQueryAdapter.<>c__DisplayClass45_0.<GetList>b__0(DataSet datasetToSend)
at Ice.Adapters.DynamicQueryAdapter.ProcessUbaqMethod(String methodName, DataSet updatedDS, Func`2 methodExecutor, Boolean refreshQueryResultsDataset)
at Ice.Adapters.DynamicQueryAdapter.GetList(DynamicQueryDataSet queryDS, QueryExecutionDataSet execParams, Int32 pageSize, Int32 absolutePage, Boolean& hasMorePage)
at Ice.UI.App.BAQDesignerEntry.BAQTransaction.TestCallListBckg()
at Ice.UI.App.BAQDesignerEntry.BAQTransaction.<>c__DisplayClass223_0.<BeginExecute>b__0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
The code was missing serialNoAssignTS.SerialNoAssign.Add(snaRow); and that was it!! It ran successfully!!! YOU ROCK!
Now to figure out the serial matching…
Yay!
Now that I can’t help you with at all. I have no idea how that works lol.
I tried to set up my pilot for serials last night to help with the other and I got lost as @#$%
Glad you got it!
