Yup I noticed that the return from GetNextSN modified those two elements so that’s the only reason I added those overrides in there.
Look here:
You run GetNextSN
don’t get the data you want ?
change some, run CreateSerialNumRange
then run GetNextSN again with probably the wrong data above
// Gets the next serial number based on the format for the part number passed in
string nextBaseSN = String.Empty;
string snPrefix = String.Empty;
string nextFullSN = String.Empty;
bool snCounterMax = false;
selectedSerialNums.GetNextSN(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant, out nextBaseSN, out snPrefix, out nextFullSN, out snCounterMax);
// Temporary hard coding for testing purposes...
selectedSerialNumbersTS.SNFormat[0].SNFormat = "99999";
selectedSerialNumbersTS.SNFormat[0].HasSerialNumbers = false;
// Create multiple serial number temporary records in the Selected Serial Numbers dataset
selectedSerialNums.CreateSerialNumRange(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, jobAsmbl.RequiredQty, startSerial, sourceRowID, String.Empty, currPlant);
// Gets the next serial number based on the format for the part number passed in
nextBaseSN = String.Empty;
snPrefix = String.Empty;
nextFullSN = String.Empty;
snCounterMax = false;
selectedSerialNums.GetNextSN(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant, out nextBaseSN, out snPrefix, out nextFullSN, out snCounterMax);
what happens if you change it to this ?:
// Gets the next serial number based on the format for the part number passed in
string nextBaseSN = String.Empty;
string snPrefix = String.Empty;
string nextFullSN = String.Empty;
bool snCounterMax = false;
selectedSerialNums.GetNextSN(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant, out nextBaseSN, out snPrefix, out nextFullSN, out snCounterMax);
// Create multiple serial number temporary records in the Selected Serial Numbers dataset
selectedSerialNums.CreateSerialNumRange(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, jobAsmbl.RequiredQty, startSerial, sourceRowID, String.Empty, currPlant);
1 Like
The data going in to GetSNFormat should have been:
<SNFormat>203-100009</SNFormat>
<HasSerialNumbers>true</HasSerialNumbers>
That’s what the trace says
what did your data look like just before your call ?
1 Like
specifically the return from “GetSerialNumFormat”
1 Like
Hello!
So the data going into GetSerialNumFormat is an empty Tableset, but includes input params, here is the snippet from the trace:
<parameters>
<parameter name="ds" type="Erp.BO.SelectedSerialNumbersDataSet">
<SelectedSerialNumbersDataSet xmlns="http://www.epicor.com/Ice/300/BO/SelectedSerialNumbers/SelectedSerialNumbers" />
</parameter>
<parameter name="partNum" type="System.String"><![CDATA[N00983203-1]]></parameter>
<parameter name="xrefPartNum" type="System.String"><![CDATA[]]></parameter>
<parameter name="xrefPartType" type="System.String"><![CDATA[]]></parameter>
<parameter name="xrefCustNum" type="System.Int32"><![CDATA[0]]></parameter>
<parameter name="plantID" type="System.String"><![CDATA[MfgSys]]></parameter>
</parameters>
The return from GetSerialNumFormat, via the trace was:
<returnParameter name="ds" type="Erp.Tablesets.SelectedSerialNumbersTableset">
<SelectedSerialNumbersDataSet xmlns="http://www.epicor.com/Ice/300/BO/SelectedSerialNumbers/SelectedSerialNumbers">
<SNFormat>
<Company>401</Company>
<Plant>MfgSys</Plant>
<PartNum>N00983203-1</PartNum>
<NumberOfDigits>5</NumberOfDigits>
<SNMask></SNMask>
<SNBaseDataType>INTEGER</SNBaseDataType>
<SNFormat>203-100009</SNFormat>
<LeadingZeroes>true</LeadingZeroes>
<SNPrefix>203-1</SNPrefix>
<SNMaskSuffix></SNMaskSuffix>
<SNMaskPrefix></SNMaskPrefix>
<SNLastUsedSeq></SNLastUsedSeq>
<HasSerialNumbers>true</HasSerialNumbers>
<SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
<BitFlag>0</BitFlag>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackLots>true</PartTrackLots>
<PartTrackSerialNum>true</PartTrackSerialNum>
<PartTrackDimension>false</PartTrackDimension>
<PartSalesUM>EA</PartSalesUM>
<PartIUM>EA</PartIUM>
<PartSellingFactor>1.00000000</PartSellingFactor>
<PartPartDescription>Precision Part, Machined, 83mm</PartPartDescription>
<SerialMaskMaskType>0</SerialMaskMaskType>
<SerialMaskMask></SerialMaskMask>
<SerialMaskExample></SerialMaskExample>
<SerialMaskDescription></SerialMaskDescription>
<RowMod></RowMod>
</SNFormat>
</SelectedSerialNumbersDataSet>
</returnParameter>
The return from my custom code is (JSON format):
"GetSerialNumFormat return":{
"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":[
]
}
Also I removed those two override lines (where I was manually setting the SNFormat and HasSerialNumbers.
Thank you for the help!
Well it’s not completely empty, and your code is passing in the correct ts with the sn format applied from
GetSerialNumFormat
I assume you also got rid of the second call to GetNextSN ?
And last, I’m unclear, is it working now ?
1 Like
I did not get rid of the 2nd call to GetNextSN, I figured I should follow the trace exactly and it had the second call in there. But no I still get the ttSerialNoAssign record not found.
I’m sorry, I was reading the trace wrong.
Post your data for the following:
selectedSerialNums.CreateSerialNumRange
2nd selectedSerialNums.GetNextSN
also now that I’m looking at it, I have a question, you are trying to add new rows, and then format them.
That’s what GetNextSN does…
1 Like
Excuse me, CreateSerialNumRange
1 Like
Basically, I am trying to automate what the user does via the Serial Number Assignment form. So I’m just following the trace exactly to try and replicate the process in the uBAQ bpm. I hope that answers your question, let me know if not though.
Here’s the data:
CreateSerialNumRange:
{
"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":[
]
}
GetNextSN:
{
"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":[
]
}
Ok, well you can leave the entire bottom portion off where you are adding new rows.
That’s not how you do it.
You get the next serial number with
GetNextSN
It returns:
nextBaseSN = the next in the series
snPrefix = your prefix
Then you run
CreateSerialNumRange
pass it your format and empty dataset with the parameters
baseBeginNum = nextBaseSN I assume or wherever you need to start from
NumToAdd = how many you want
call GetNextSN again with tableset and just the part to add the rows
then call SetSerialNoAssign
1 Like
Just to clarify, when you are referring to the foreach loops right? I added them in because the SelectedSerialNumbersTableset within the SerialNoAssignTableset was empty and was throwing an error. I can remove them though and run it so you can see what is occurring. Let me make the changes and run the process and I’ll provide the output. Thank you!
Should look more like this:
// Gets the next serial number format based on the part number passed in.
selectedSerialNums.GetSerialNumFormat(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant);
// Gets the next serial number based on the format for the part number passed in
string nextBaseSN = String.Empty;
string snPrefix = String.Empty;
string nextFullSN = String.Empty;
bool snCounterMax = false;
selectedSerialNums.GetNextSN(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant, out nextBaseSN, out snPrefix, out nextFullSN, out snCounterMax);
//Look here!!
startSerial = nextBaseSN;
//jobAsmbl.RequiredQty should be how many serials you want
// Create multiple serial number temporary records in the Selected Serial Numbers dataset
selectedSerialNums.CreateSerialNumRange(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, jobAsmbl.RequiredQty, startSerial, sourceRowID, String.Empty, currPlant);
// Gets the next serial number based on the format for the part number passed in
nextBaseSN = String.Empty;
snPrefix = String.Empty;
nextFullSN = String.Empty;
snCounterMax = false;
selectedSerialNums.GetNextSN(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant, out nextBaseSN, out snPrefix, out nextFullSN, out snCounterMax);
// Validates the job number, assembly sequence and part number. Also validates the part is serial tracked.
// Updates the SerialNo table and the Part table for the SN Format fields. Calls the SNTran create subroutine
string oprCmpWarning = String.Empty;
serialNoAssign.SetSerialNoAssign(ref serialNoAssignDS, false, out oprCmpWarning);
//debugMsg("Serial No Assign TS", serialNoAssignDS);
1 Like
Ahh ok sorry I may not have been clear above. So, the system picks the next start SN#, but my management wants the serial to match the lower level part. So the lower level part starts at 80053 but the system wants the next serial to start at 900##. So instead of using the system generated start #, I pull the start serial # from the lower level part serial. That way when the system prefixes it, the upper part will be 203-180053. So from what you are saying above, I don’t need the first GetNextSN call since I am computing the start serial number myself. I do need the next call though, correct?
I don’t know if there are any restrictions on generation, as we don’t use them, but I would assume you are correct.
Pull out the first GetNextSN and use my code above with nextBaseSN as your start number
I mean use your start number as the baseBeginNum
in your code it’s startSerial lol
Now that I’m looking at it, you can probably skip the second GetNextSN too, but I am unsure
I think you can go directly from CreateSerialNumRange to SetSerialNoAssign
Btw I appreciate you working with me on this very much!
So took out the code we discussed above:
// Gets the default values for the Serial number assignment screen. Also populates the Selectedserialnumbers table for the job.
bool TrackSerialNo = false;
var serialNoAssignDS = serialNoAssign.GetSerialNoAssign(jobNum, assemblySeq, String.Empty, 0, out TrackSerialNo);
// Get our Source Row ID from our serial number tableset
var sourceRowID = serialNoAssignDS.SerialNoAssign.Select(m => m.SysRowID).FirstOrDefault().ToString();
// Create a reference to the selected serial numbers for use
var selectedSerialNumbersTS = new Erp.Tablesets.SelectedSerialNumbersTableset();
// Gets the next serial number format based on the part number passed in.
selectedSerialNums.GetSerialNumFormat(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, currPlant);
// Create multiple serial number temporary records in the Selected Serial Numbers dataset
selectedSerialNums.CreateSerialNumRange(ref selectedSerialNumbersTS, upperLevel.PartNum, String.Empty, String.Empty, 0, jobAsmbl.RequiredQty, startSerial, sourceRowID, String.Empty, currPlant);
// Validates the job number, assembly sequence and part number. Also validates the part is serial tracked.
// Updates the SerialNo table and the Part table for the SN Format fields. Calls the SNTran create subroutine
string oprCmpWarning = String.Empty;
serialNoAssign.SetSerialNoAssign(ref serialNoAssignDS, false, out oprCmpWarning);
After running, I got:
Business Layer Exception
ttSerialNoAssign record not found.
Exception caught in: Epicor.ServiceModel
Error Detail
============
Correlation ID: ac1f1d41-c22e-42ef-9306-6e34d44155c7
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()
Now, just to note, taking out my foreach loops has the Serial No Assign tableset looking like:
{"SelectedSerialNumbers":[],"SerialNoAssign":[{"ColumnNames":0,"Company":"401","JobNumber":"000012","AssemblySeq":0,"PartDescription":"Precision Part, Machined, 83mm","SerialNoQty":0.0,"PartNum":"N00983203-1","JobQty":15.00000000,"SysRowID":"9f655539-5fc7-452e-8056-38f96aaef0ce","RowMod":"","SpecifiedProperties":"7wA=","UserDefinedColumns":{}}],"SNFormat":[],"ExtensionTables":[]}
Putting back my foreach loops to re-test with them back in there, but still removing the GetNextSN, I still got the same BL error:
Business Layer Exception
ttSerialNoAssign record not found.
Exception caught in: Epicor.ServiceModel
Error Detail
============
Correlation ID: 0cdb37c8-2c60-44dd-a3e7-a7a29f6a999e
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()
And the Serial No Assign tableset now looks like this:
{
"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":[
]
}