UBAQ Quantity Adjustment

Yahoo Archive
1

Thanks very much.

DMT seems to be the goto solution, although we would have to buy it, and learn it. Another recommendation is to use a User-Defined table and a script. Service Connect would have a learning curve to contend with as well.

I was not aware of the inherent limitations with UBAQs...very disappointing for a tool that seems to do what you want, until it doesn't, of course.

I certainly appreciate your help.

Paul

2
Good day all,
We are attempting to provide a mechanism to take a spreadsheet of material
inventory physically counted in the shop and adjusting that quantity en
masse via paste update into a UBAQ dashboard. I have been working on an
updateable BAQ based on a trace (hopefully attached) taken while making this
update to one material via Quantity Adjustment. The following Answerbook
excerpt provides some information concerning OnHandQty fields. I have been
targeting the PartBin.OnHandQty field to update via the UBAQ, but the BO
does not present the OnHandQty as an updateable field. This is confirmed by
support.
I look forward to any suggestions regarding approach and/or methodology to
allow for updates to OnHandQty from a list, instead of individually through
Quantity Adjustment.
Thanks in advance.

Summary: IM Questions about what tables store On Hand Qty and how they
are used.
Book: Support Solutions
Page: 13669MPS
PAGE: 13669MPS

PartBin.OnHandQty: Contains the On Hand quantity for a specific part in a
specific bin location within a warehouse.It is a subset to the PartWhse
table. These records are created in Part Maintenance when adding a Bin to a
Part, or through Part Transactions. Contains the Onhand quantity for a
specific part in a specific bin location within a warehouse. When the OnHand
quantity becomes zero the PartBin record is deleted. There should never be
any records that exist with a zero quantity onhand.

PartWhse.OnHandQty: This table stores a summary of PartBin.OnHandQty for the
warehouse where the bin is a nettable bin (WhseBin.NonNettable = NO). This
table is updated automatically when the PartBin is updated.

PartQty.OnHandQty: Similar to PartWhse, but updated separately, this table
stores a summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). This table is updated automatically
when the PartBin is updated.


Paul Welch
IS Technician
MGS, Inc.
178 Muddy Creek Church Rd
Denver, PA 17517
Office: (717) 336-7528
Mobile: (717) 725-0672
<http://www.mgsincorporated.com/> http://www.mgsincorporated.com



----------

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>8/26/2014 10:58:46:2700178 AM</localTime>
<executionTime>10</executionTime>
<parameters>
<parameter name='whereClauseSysRptLst' type='string' ><![CDATA[((PrintDriver='TEXT' AND (AutoAction = 'PRINT' OR AutoAction = 'PREVIEW')) OR (PrintDriver='CRYSTAL' AND (AutoAction = 'PRINT' OR AutoAction = 'AUTOPRT' OR AutoAction = 'PREVIEW' OR AutoAction = 'AUTOPRV')) OR (PrintDriver='EPIFIN' AND (AutoAction = 'PRINT' OR AutoAction = 'PREVIEW')) OR (PrintDriver='BARTENDER' AND (AutoAction = 'AUTOPRT' OR AutoAction = 'AUTOPRV')) OR (PrintDriver='EDI' AND AutoAction <> '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction = 'SSRSREADY')) AND WorkStationID ='MGS-RDP 3']]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool' ><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.ReportMonitorDataSet' ><ReportMonitorDataSet xmlns="http://www.epicor.com/Mfg/100/BO.ReportMonitor/ReportMonitor" /></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.SysMonitor</businessObject>
<methodName>GetTaskHistory</methodName>
<returnType>Epicor.Mfg.BO.SysMonitorTaskHistDataSet</returnType>
<localTime>8/26/2014 10:58:46:2880178 AM</localTime>
<executionTime>8</executionTime>
<parameters>
<parameter name='taskNumOfDays' type='int' ><![CDATA[5]]></parameter>
<parameter name='rptUserID' type='string' ><![CDATA[pwelch]]></parameter>
</parameters>
<returnValues>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.SysMonitorTaskHistDataSet' ><SysMonitorTaskHistDataSet xmlns="http://www.epicor.com/Mfg/100/BO.SysMonitor/SysMonitorTaskHist" /></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.WhseBin</businessObject>
<methodName>GetRows</methodName>
<returnType>Epicor.Mfg.BO.WhseBinDataSet</returnType>
<localTime>8/26/2014 10:58:52:2630211 AM</localTime>
<executionTime>169</executionTime>
<parameters>
<parameter name='whereClauseWhseBin' type='string' ><![CDATA[WareHouseCode='PW' AND BinNum='FD']]></parameter>
<parameter name='whereClauseWhseBinAttch' type='string' ><![CDATA[]]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool' ><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.WhseBinDataSet' ><WhseBinDataSet xmlns="http://www.epicor.com/Mfg/100/BO.WhseBin/WhseBin">
<WhseBin>
<Company>1</Company>
<WarehouseCode>PW</WarehouseCode>
<BinNum>FD</BinNum>
<Description>FAB Department</Description>
<NonNettable>false</NonNettable>
<Character01 />
<Character02 />
<Character03 />
<Character04 />
<Character05 />
<Character06 />
<Character07 />
<Character08 />
<Character09 />
<Character10 />
<Number01>0</Number01>
<Number02>0</Number02>
<Number03>0</Number03>
<Number04>0</Number04>
<Number05>0</Number05>
<Number06>0</Number06>
<Number07>0</Number07>
<Number08>0</Number08>
<Number09>0</Number09>
<Number10>0</Number10>
<CheckBox01>false</CheckBox01>
<CheckBox02>false</CheckBox02>
<CheckBox03>false</CheckBox03>
<CheckBox04>false</CheckBox04>
<CheckBox05>false</CheckBox05>
<SizeID />
<ZoneID />
<BinSeq>0</BinSeq>
<BinType>Std</BinType>
<CustNum>0</CustNum>
<VendorNum>0</VendorNum>
<Aisle />
<Face />
<Elevation>1</Elevation>
<MaxFill>0</MaxFill>
<PctFillable>100</PctFillable>
<InActive>false</InActive>
<Portable>false</Portable>
<Replenishable>false</Replenishable>
<SysRowID>c1e6c300-2ea4-87b2-e011-c2be55e4e317</SysRowID>
<SysRevID>0</SysRevID>
<AttrBinList />
<IsEmpty>false</IsEmpty>
<BitFlag>0</BitFlag>
<CustomerName />
<CustomerBTName />
<CustomerCustID />
<SizeIDDescription />
<VendorAddress1 />
<VendorCity />
<VendorDefaultFOB />
<VendorTermsCode />
<VendorAddress2 />
<VendorCountry />
<VendorName />
<VendorVendorID />
<VendorAddress3 />
<VendorCurrencyCode />
<VendorState />
<VendorZIP />
<WarehouseCodeDescription>Production Warehouse</WarehouseCodeDescription>
<ZoneIDZoneDesc />
<RowIdent>0x00000000038c64cc</RowIdent>
<RowMod />
<DBRowIdent>AAAAAAOMZMw=</DBRowIdent>
</WhseBin>
</WhseBinDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>NegativeInventoryTest</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:58:52:4610173 AM</localTime>
<executionTime>42</executionTime>
<parameters>
<parameter name='pcPartNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='pcWhseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='pcBinNum' type='string' ><![CDATA[FD]]></parameter>
<parameter name='pcLotNum' type='string' ><![CDATA[]]></parameter>
<parameter name='pcDimCode' type='string' ><![CDATA[LB]]></parameter>
<parameter name='pdDimConvFactor' type='decimal' ><![CDATA[1]]></parameter>
<parameter name='pdTranQty' type='decimal' ><![CDATA[0.24]]></parameter>
<parameter name='pcNeqQtyAction' type='string' ><![CDATA[]]></parameter>
<parameter name='pcMessage' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='pcNeqQtyAction' type='string' ><![CDATA[]]></returnParameter>
<returnParameter name='pcMessage' type='string' ><![CDATA[]]></returnParameter>
</returnValues>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>PreSetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:58:52:5060181 AM</localTime>
<executionTime>25</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod />
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='requiresUserInput' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod />
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
<returnParameter name='requiresUserInput' type='bool' ><![CDATA[False]]></returnParameter>
</returnValues>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>SetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:58:52:5430174 AM</localTime>
<executionTime>106.0003</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='partTranPKs' type='string' ><![CDATA[]]></parameter>
</parameters>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='RowMod' ><![CDATA[U]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.Lib.BOReader</businessObject>
<methodName>GetList</methodName>
<returnType>System.Data.DataSet</returnType>
<localTime>8/26/2014 10:58:56:2660178 AM</localTime>
<executionTime>70</executionTime>
<parameters>
<parameter name='boName' type='System.String' ><![CDATA[Reason]]></parameter>
<parameter name='whereClause' type='System.String' ><![CDATA[ReasonType='M']]></parameter>
<parameter name='columnList' type='System.String' ><![CDATA[ReasonCode,ReasonType,Description]]></parameter>
</parameters>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.WhseBin</businessObject>
<methodName>GetRows</methodName>
<returnType>Epicor.Mfg.BO.WhseBinDataSet</returnType>
<localTime>8/26/2014 10:59:05:8290193 AM</localTime>
<executionTime>15</executionTime>
<parameters>
<parameter name='whereClauseWhseBin' type='string' ><![CDATA[WareHouseCode='PW' AND BinNum='FD']]></parameter>
<parameter name='whereClauseWhseBinAttch' type='string' ><![CDATA[]]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool' ><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.WhseBinDataSet' ><WhseBinDataSet xmlns="http://www.epicor.com/Mfg/100/BO.WhseBin/WhseBin">
<WhseBin>
<Company>1</Company>
<WarehouseCode>PW</WarehouseCode>
<BinNum>FD</BinNum>
<Description>FAB Department</Description>
<NonNettable>false</NonNettable>
<Character01 />
<Character02 />
<Character03 />
<Character04 />
<Character05 />
<Character06 />
<Character07 />
<Character08 />
<Character09 />
<Character10 />
<Number01>0</Number01>
<Number02>0</Number02>
<Number03>0</Number03>
<Number04>0</Number04>
<Number05>0</Number05>
<Number06>0</Number06>
<Number07>0</Number07>
<Number08>0</Number08>
<Number09>0</Number09>
<Number10>0</Number10>
<CheckBox01>false</CheckBox01>
<CheckBox02>false</CheckBox02>
<CheckBox03>false</CheckBox03>
<CheckBox04>false</CheckBox04>
<CheckBox05>false</CheckBox05>
<SizeID />
<ZoneID />
<BinSeq>0</BinSeq>
<BinType>Std</BinType>
<CustNum>0</CustNum>
<VendorNum>0</VendorNum>
<Aisle />
<Face />
<Elevation>1</Elevation>
<MaxFill>0</MaxFill>
<PctFillable>100</PctFillable>
<InActive>false</InActive>
<Portable>false</Portable>
<Replenishable>false</Replenishable>
<SysRowID>c1e6c300-2ea4-87b2-e011-c2be55e4e317</SysRowID>
<SysRevID>0</SysRevID>
<AttrBinList />
<IsEmpty>false</IsEmpty>
<BitFlag>0</BitFlag>
<CustomerName />
<CustomerBTName />
<CustomerCustID />
<SizeIDDescription />
<VendorAddress1 />
<VendorCity />
<VendorDefaultFOB />
<VendorTermsCode />
<VendorAddress2 />
<VendorCountry />
<VendorName />
<VendorVendorID />
<VendorAddress3 />
<VendorCurrencyCode />
<VendorState />
<VendorZIP />
<WarehouseCodeDescription>Production Warehouse</WarehouseCodeDescription>
<ZoneIDZoneDesc />
<RowIdent>0x00000000038c64cc</RowIdent>
<RowMod />
<DBRowIdent>AAAAAAOMZMw=</DBRowIdent>
</WhseBin>
</WhseBinDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>NegativeInventoryTest</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:05:8490175 AM</localTime>
<executionTime>8</executionTime>
<parameters>
<parameter name='pcPartNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='pcWhseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='pcBinNum' type='string' ><![CDATA[FD]]></parameter>
<parameter name='pcLotNum' type='string' ><![CDATA[]]></parameter>
<parameter name='pcDimCode' type='string' ><![CDATA[LB]]></parameter>
<parameter name='pdDimConvFactor' type='decimal' ><![CDATA[1]]></parameter>
<parameter name='pdTranQty' type='decimal' ><![CDATA[0.24]]></parameter>
<parameter name='pcNeqQtyAction' type='string' ><![CDATA[]]></parameter>
<parameter name='pcMessage' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='pcNeqQtyAction' type='string' ><![CDATA[]]></returnParameter>
<returnParameter name='pcMessage' type='string' ><![CDATA[]]></returnParameter>
</returnValues>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>PreSetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:05:8580183 AM</localTime>
<executionTime>12</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='requiresUserInput' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
<returnParameter name='requiresUserInput' type='bool' ><![CDATA[False]]></returnParameter>
</returnValues>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='ReasonCode' ><![CDATA[PD]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='ReasonCodeDescription' ><![CDATA[Physical Discrepancy]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='RowMod' ><![CDATA[U]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>SetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:05:8750184 AM</localTime>
<executionTime>1298</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='partTranPKs' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
<returnParameter name='partTranPKs' type='string' ><![CDATA[08/26/14~39545~636482]]></returnParameter>
</returnValues>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='ReasonCode' ><![CDATA[PD]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='ReasonCodeDescription' ><![CDATA[Physical Discrepancy]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0' colName='RowMod' ><![CDATA[U]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>GetInventoryQtyAdj</methodName>
<returnType>Epicor.Mfg.BO.InventoryQtyAdjDataSet</returnType>
<localTime>8/26/2014 10:59:07:1780247 AM</localTime>
<executionTime>19</executionTime>
<parameters>
<parameter name='partnumber' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='uomCode' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>0</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod />
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.Part</businessObject>
<methodName>PartExists</methodName>
<returnType>bool</returnType>
<localTime>8/26/2014 10:59:07:2000195 AM</localTime>
<executionTime>12</executionTime>
<parameters>
<parameter name='partNumber' type='string' ><![CDATA[ST062]]></parameter>
</parameters>
<returnValues>
<returnParameter name='MethodReturned' type='bool' ><![CDATA[True]]></returnParameter>
</returnValues>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.Part</businessObject>
<methodName>GetList</methodName>
<returnType>Epicor.Mfg.BO.PartListDataSet</returnType>
<localTime>8/26/2014 10:59:07:2160199 AM</localTime>
<executionTime>14</executionTime>
<parameters>
<parameter name='whereClause' type='string' ><![CDATA[PartNum='ST062' BY PartNum]]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool' ><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.PartListDataSet' ><PartListDataSet xmlns="http://www.epicor.com/Mfg/100/BO.Part/PartList">
<PartList>
<PartNum>ST062</PartNum>
<PartDescription> 16 GA. ASTM 1011</PartDescription>
<SearchWord>11ga A56</SearchWord>
<TypeCode>P</TypeCode>
<Method>false</Method>
<NonStock>false</NonStock>
<ProdCode />
<ClassID>STL</ClassID>
<OnHold>false</OnHold>
<InActive>false</InActive>
<TrackLots>false</TrackLots>
<PhantomBom>false</PhantomBom>
<TrackSerialNum>false</TrackSerialNum>
<TrackDimension>false</TrackDimension>
<Company>1</Company>
<IUM>LB</IUM>
<PUM>LB</PUM>
<QtyBearing>true</QtyBearing>
<LotMfgBatch>false</LotMfgBatch>
<LotBatch>false</LotBatch>
<LotMfgLot>false</LotMfgLot>
<LotHeat>false</LotHeat>
<LotFirmware>false</LotFirmware>
<LotBeforeDt>false</LotBeforeDt>
<LotMfgDt>false</LotMfgDt>
<LotCureDt>false</LotCureDt>
<LotExpDt>false</LotExpDt>
<SysRowID>ced6cb79-3d05-16b2-e111-c37cd274d6b3</SysRowID>
<RowIdent>0x00000000042f24e0</RowIdent>
<RowMod />
<DBRowIdent>AAAAAAQvJOA=</DBRowIdent>
</PartList>
</PartListDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>GetInventoryQtyAdjBrw</methodName>
<returnType>Epicor.Mfg.BO.InventoryQtyAdjBrwDataSet</returnType>
<localTime>8/26/2014 10:59:07:2400224 AM</localTime>
<executionTime>13</executionTime>
<parameters>
<parameter name='partNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='wareHouseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='primaryBin' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='primaryBin' type='string' ><![CDATA[FD]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.InventoryQtyAdjBrwDataSet' ><InventoryQtyAdjBrwDataSet xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdjBrw">
<InventoryQtyAdjBrw>
<Company>1</Company>
<BinNum>FD</BinNum>
<OnHandQty>287</OnHandQty>
<NonNettable>false</NonNettable>
<WareHseCode>PW</WareHseCode>
<LotNum />
<WhseBinDesc>FAB Department</WhseBinDesc>
<StkUOMCode>LB</StkUOMCode>
<StkUOMDesc>LB</StkUOMDesc>
<BaseOnHandQty>287</BaseOnHandQty>
<BaseOnHandUOM>LB</BaseOnHandUOM>
<RowIdent />
<RowMod />
</InventoryQtyAdjBrw>
</InventoryQtyAdjBrwDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>CheckSN</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:07:2570218 AM</localTime>
<executionTime>6</executionTime>
<parameters>
<parameter name='partNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='warehouseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='serialNumbersRequired' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='serialNumbersRequired' type='bool' ><![CDATA[False]]></returnParameter>
</returnValues>
</tracePacket>




[Non-text portions of this message have been removed]
3
Incidentally, Version 9.05.702A
4
So sorry, forgot how attachments are handled.
5
Good Morning,

The data management tool (DMT) is useful for bulk update quantity adjustment.  Have you considered getting this?  We are on 9.05.702A and find DMT very useful for the qty adjustments as well as bulk fixes to part master data following auditing of part setups, and bulk method updates.

Nancy
6

Hi Nancy,

Thanks so much. We continue to consider DMT, while we try to leverage the existing software to do what we need it to do. It's a craw-sticker to have to add on (and spend more) to accomplish tasks as they arise.

Paul W.

7
Hi Paul,

I can relate to the thought "don't we pay enough for this already?!".  One other thought RE qty adjustment and why you are not able to adjust with the tables listed via updateable query.  Whenever quantity is added or taken away, there is an inventory value to this and I think that system needs to have associated parttran data to add/subtract the cost of the part from inventory.  I suspect that this is why the system is tying your hands with it.

nancy

8

Quite right Nancy,

Another observation is that the BO does math to see whether the adjustment is adding to or subtracting from OnHandQty via a separate method. So calling the InventoryQtyAdj method in the UBAQ BPM seems to be another dead end.

Thanks for the confirmation.

Paul W

9
DMT, it’s a really usefull tool from Epicor to update tables in mass. It’s
the Data Management Tool.














*Amélie Pelletier*


*Analyste Programmeur / Program analyst*






[image: cid:image001.jpg@01CD5525.2091A820]






*230, Boulevard Nilus-Leclerc*


*L'Islet, Québec (Canada)*


*G0R 2C0*


*Téléphone: 418-247-3986 ext. 2390*


*Fax: 418-247-7925*


*amelie.pelletier@... <brigitte.savoie@...>*


*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*










*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 27 août 2014 08:39
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] UBAQ Quantity Adjustment










Good day all,
We are attempting to provide a mechanism to take a spreadsheet of material
inventory physically counted in the shop and adjusting that quantity en
masse via paste update into a UBAQ dashboard. I have been working on an
updateable BAQ based on a trace (hopefully attached) taken while making this
update to one material via Quantity Adjustment. The following Answerbook
excerpt provides some information concerning OnHandQty fields. I have been
targeting the PartBin.OnHandQty field to update via the UBAQ, but the BO
does not present the OnHandQty as an updateable field. This is confirmed by
support.
I look forward to any suggestions regarding approach and/or methodology to
allow for updates to OnHandQty from a list, instead of individually through
Quantity Adjustment.
Thanks in advance.


Summary: IM Questions about what tables store On Hand Qty and how they
are used.
Book: Support Solutions
Page: 13669MPS
PAGE: 13669MPS


PartBin.OnHandQty: Contains the On Hand quantity for a specific part in a
specific bin location within a warehouse.It is a subset to the PartWhse
table. These records are created in Part Maintenance when adding a Bin to a
Part, or through Part Transactions. Contains the Onhand quantity for a
specific part in a specific bin location within a warehouse. When the OnHand
quantity becomes zero the PartBin record is deleted. There should never be
any records that exist with a zero quantity onhand.


PartWhse.OnHandQty: This table stores a summary of PartBin.OnHandQty for the
warehouse where the bin is a nettable bin (WhseBin.NonNettable = NO). This
table is updated automatically when the PartBin is updated.


PartQty.OnHandQty: Similar to PartWhse, but updated separately, this table
stores a summary of PartBin.OnHandQty for the warehouse where the bin is a
nettable bin (WhseBin.NonNettable = NO). This table is updated automatically
when the PartBin is updated.




Paul Welch

IS Technician
MGS, Inc.
178 Muddy Creek Church Rd
Denver, PA 17517
Office: (717) 336-7528
Mobile: (717) 725-0672
<http://www.mgsincorporated.com/> http://www.mgsincorporated.com


----------


<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>8/26/2014 10:58:46:2700178 AM</localTime>
<executionTime>10</executionTime>
<parameters>
<parameter name='whereClauseSysRptLst' type='string'
><![CDATA[((PrintDriver='TEXT' AND (AutoAction = 'PRINT' OR AutoAction =
'PREVIEW')) OR (PrintDriver='CRYSTAL' AND (AutoAction = 'PRINT' OR
AutoAction = 'AUTOPRT' OR AutoAction = 'PREVIEW' OR AutoAction =
'AUTOPRV')) OR (PrintDriver='EPIFIN' AND (AutoAction = 'PRINT' OR
AutoAction = 'PREVIEW')) OR (PrintDriver='BARTENDER' AND (AutoAction =
'AUTOPRT' OR AutoAction = 'AUTOPRV')) OR (PrintDriver='EDI' AND AutoAction

<> '') OR (PrintDriver='SSRS' AND AutoAction = 'PREVIEW' AND LastAction =
'SSRSREADY')) AND WorkStationID ='MGS-RDP 3']]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool'
><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned'
type='Epicor.Mfg.BO.ReportMonitorDataSet' ><ReportMonitorDataSet xmlns="
http://www.epicor.com/Mfg/100/BO.ReportMonitor/ReportMonitor"
/></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.SysMonitor</businessObject>
<methodName>GetTaskHistory</methodName>
<returnType>Epicor.Mfg.BO.SysMonitorTaskHistDataSet</returnType>
<localTime>8/26/2014 10:58:46:2880178 AM</localTime>
<executionTime>8</executionTime>
<parameters>
<parameter name='taskNumOfDays' type='int' ><![CDATA[5]]></parameter>
<parameter name='rptUserID' type='string' ><![CDATA[pwelch]]></parameter>
</parameters>
<returnValues>
<returnParameter name='MethodReturned'
type='Epicor.Mfg.BO.SysMonitorTaskHistDataSet' ><SysMonitorTaskHistDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.SysMonitor/SysMonitorTaskHist"
/></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.WhseBin</businessObject>
<methodName>GetRows</methodName>
<returnType>Epicor.Mfg.BO.WhseBinDataSet</returnType>

<localTime>8/26/2014 10:58:52:2630211 AM</localTime>
<executionTime>169</executionTime>
<parameters>
<parameter name='whereClauseWhseBin' type='string'
><![CDATA[WareHouseCode='PW' AND BinNum='FD']]></parameter>
<parameter name='whereClauseWhseBinAttch' type='string'
><![CDATA[]]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool'
><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.WhseBinDataSet'
><WhseBinDataSet xmlns="http://www.epicor.com/Mfg/100/BO.WhseBin/WhseBin">
<WhseBin>
<Company>1</Company>
<WarehouseCode>PW</WarehouseCode>
<BinNum>FD</BinNum>
<Description>FAB Department</Description>
<NonNettable>false</NonNettable>
<Character01 />
<Character02 />
<Character03 />
<Character04 />
<Character05 />
<Character06 />
<Character07 />
<Character08 />
<Character09 />
<Character10 />
<Number01>0</Number01>
<Number02>0</Number02>
<Number03>0</Number03>
<Number04>0</Number04>
<Number05>0</Number05>
<Number06>0</Number06>
<Number07>0</Number07>
<Number08>0</Number08>
<Number09>0</Number09>
<Number10>0</Number10>
<CheckBox01>false</CheckBox01>
<CheckBox02>false</CheckBox02>
<CheckBox03>false</CheckBox03>
<CheckBox04>false</CheckBox04>
<CheckBox05>false</CheckBox05>
<SizeID />
<ZoneID />
<BinSeq>0</BinSeq>
<BinType>Std</BinType>
<CustNum>0</CustNum>
<VendorNum>0</VendorNum>
<Aisle />
<Face />
<Elevation>1</Elevation>
<MaxFill>0</MaxFill>
<PctFillable>100</PctFillable>
<InActive>false</InActive>
<Portable>false</Portable>
<Replenishable>false</Replenishable>
<SysRowID>c1e6c300-2ea4-87b2-e011-c2be55e4e317</SysRowID>
<SysRevID>0</SysRevID>
<AttrBinList />
<IsEmpty>false</IsEmpty>
<BitFlag>0</BitFlag>
<CustomerName />
<CustomerBTName />
<CustomerCustID />
<SizeIDDescription />
<VendorAddress1 />
<VendorCity />
<VendorDefaultFOB />
<VendorTermsCode />
<VendorAddress2 />
<VendorCountry />
<VendorName />
<VendorVendorID />
<VendorAddress3 />
<VendorCurrencyCode />
<VendorState />
<VendorZIP />
<WarehouseCodeDescription>Production Warehouse</WarehouseCodeDescription>
<ZoneIDZoneDesc />
<RowIdent>0x00000000038c64cc</RowIdent>
<RowMod />
<DBRowIdent>AAAAAAOMZMw=</DBRowIdent>
</WhseBin>
</WhseBinDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>NegativeInventoryTest</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:58:52:4610173 AM</localTime>
<executionTime>42</executionTime>
<parameters>
<parameter name='pcPartNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='pcWhseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='pcBinNum' type='string' ><![CDATA[FD]]></parameter>
<parameter name='pcLotNum' type='string' ><![CDATA[]]></parameter>
<parameter name='pcDimCode' type='string' ><![CDATA[LB]]></parameter>
<parameter name='pdDimConvFactor' type='decimal' ><![CDATA[1]]></parameter>
<parameter name='pdTranQty' type='decimal' ><![CDATA[0.24]]></parameter>
<parameter name='pcNeqQtyAction' type='string' ><![CDATA[]]></parameter>
<parameter name='pcMessage' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='pcNeqQtyAction' type='string'
><![CDATA[]]></returnParameter>
<returnParameter name='pcMessage' type='string'
><![CDATA[]]></returnParameter>
</returnValues>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>PreSetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:58:52:5060181 AM</localTime>
<executionTime>25</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />

<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod />
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='requiresUserInput' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='ds' type='InventoryQtyAdjDataSet'
><InventoryQtyAdjDataSet xmlns="
http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod />
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
<returnParameter name='requiresUserInput' type='bool'
><![CDATA[False]]></returnParameter>
</returnValues>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>SetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:58:52:5430174 AM</localTime>
<executionTime>106.0003</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='partTranPKs' type='string' ><![CDATA[]]></parameter>
</parameters>
<paramDataSetChanges>

<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='RowMod' ><![CDATA[U]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.Lib.BOReader</businessObject>
<methodName>GetList</methodName>
<returnType>System.Data.DataSet</returnType>
<localTime>8/26/2014 10:58:56:2660178 AM</localTime>
<executionTime>70</executionTime>
<parameters>
<parameter name='boName' type='System.String'
><![CDATA[Reason]]></parameter>
<parameter name='whereClause' type='System.String'
><![CDATA[ReasonType='M']]></parameter>
<parameter name='columnList' type='System.String'
><![CDATA[ReasonCode,ReasonType,Description]]></parameter>
</parameters>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.WhseBin</businessObject>
<methodName>GetRows</methodName>
<returnType>Epicor.Mfg.BO.WhseBinDataSet</returnType>
<localTime>8/26/2014 10:59:05:8290193 AM</localTime>
<executionTime>15</executionTime>
<parameters>
<parameter name='whereClauseWhseBin' type='string'
><![CDATA[WareHouseCode='PW' AND BinNum='FD']]></parameter>
<parameter name='whereClauseWhseBinAttch' type='string'
><![CDATA[]]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool'
><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.WhseBinDataSet'
><WhseBinDataSet xmlns="http://www.epicor.com/Mfg/100/BO.WhseBin/WhseBin">
<WhseBin>
<Company>1</Company>
<WarehouseCode>PW</WarehouseCode>
<BinNum>FD</BinNum>
<Description>FAB Department</Description>
<NonNettable>false</NonNettable>
<Character01 />
<Character02 />
<Character03 />
<Character04 />
<Character05 />
<Character06 />
<Character07 />
<Character08 />

<Character09 />
<Character10 />
<Number01>0</Number01>
<Number02>0</Number02>
<Number03>0</Number03>
<Number04>0</Number04>
<Number05>0</Number05>
<Number06>0</Number06>
<Number07>0</Number07>
<Number08>0</Number08>
<Number09>0</Number09>
<Number10>0</Number10>
<CheckBox01>false</CheckBox01>
<CheckBox02>false</CheckBox02>
<CheckBox03>false</CheckBox03>
<CheckBox04>false</CheckBox04>
<CheckBox05>false</CheckBox05>
<SizeID />
<ZoneID />
<BinSeq>0</BinSeq>
<BinType>Std</BinType>
<CustNum>0</CustNum>
<VendorNum>0</VendorNum>
<Aisle />
<Face />
<Elevation>1</Elevation>
<MaxFill>0</MaxFill>
<PctFillable>100</PctFillable>
<InActive>false</InActive>
<Portable>false</Portable>
<Replenishable>false</Replenishable>
<SysRowID>c1e6c300-2ea4-87b2-e011-c2be55e4e317</SysRowID>
<SysRevID>0</SysRevID>
<AttrBinList />
<IsEmpty>false</IsEmpty>
<BitFlag>0</BitFlag>
<CustomerName />
<CustomerBTName />
<CustomerCustID />
<SizeIDDescription />
<VendorAddress1 />
<VendorCity />
<VendorDefaultFOB />
<VendorTermsCode />
<VendorAddress2 />
<VendorCountry />
<VendorName />
<VendorVendorID />
<VendorAddress3 />
<VendorCurrencyCode />
<VendorState />
<VendorZIP />
<WarehouseCodeDescription>Production Warehouse</WarehouseCodeDescription>
<ZoneIDZoneDesc />
<RowIdent>0x00000000038c64cc</RowIdent>
<RowMod />
<DBRowIdent>AAAAAAOMZMw=</DBRowIdent>
</WhseBin>
</WhseBinDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>NegativeInventoryTest</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:05:8490175 AM</localTime>
<executionTime>8</executionTime>
<parameters>
<parameter name='pcPartNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='pcWhseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='pcBinNum' type='string' ><![CDATA[FD]]></parameter>
<parameter name='pcLotNum' type='string' ><![CDATA[]]></parameter>
<parameter name='pcDimCode' type='string' ><![CDATA[LB]]></parameter>
<parameter name='pdDimConvFactor' type='decimal' ><![CDATA[1]]></parameter>
<parameter name='pdTranQty' type='decimal' ><![CDATA[0.24]]></parameter>
<parameter name='pcNeqQtyAction' type='string' ><![CDATA[]]></parameter>
<parameter name='pcMessage' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='pcNeqQtyAction' type='string'
><![CDATA[]]></returnParameter>
<returnParameter name='pcMessage' type='string'
><![CDATA[]]></returnParameter>
</returnValues>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>PreSetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:05:8580183 AM</localTime>
<executionTime>12</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='requiresUserInput' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='ds' type='InventoryQtyAdjDataSet'
><InventoryQtyAdjDataSet xmlns="
http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>

<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
<returnParameter name='requiresUserInput' type='bool'
><![CDATA[False]]></returnParameter>
</returnValues>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='ReasonCode' ><![CDATA[PD]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='ReasonCodeDescription' ><![CDATA[Physical
Discrepancy]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='RowMod' ><![CDATA[U]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>SetInventoryQtyAdj</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:05:8750184 AM</localTime>
<executionTime>1298</executionTime>
<parameters>
<parameter name='ds' type='InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></parameter>
<parameter name='partTranPKs' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='ds' type='InventoryQtyAdjDataSet'
><InventoryQtyAdjDataSet xmlns="
http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287.24</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>-0.24</AdjustQuantity>
<ReasonCode>PD</ReasonCode>
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>

<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription>Physical Discrepancy</ReasonCodeDescription>
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod>U</RowMod>
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
<returnParameter name='partTranPKs' type='string'
><![CDATA[08/26/14~39545~636482]]></returnParameter>
</returnValues>
<paramDataSetChanges>
<paramDataSet name='ds' useDataSetNbr='0' >

<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='AdjustQuantity' ><![CDATA[-0.24]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='ReasonCode' ><![CDATA[PD]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='ReasonCodeDescription' ><![CDATA[Physical
Discrepancy]]></changedValue>
<changedValue tableName='InventoryQtyAdj' rowState='Modified' rowNum='0'
colName='RowMod' ><![CDATA[U]]></changedValue>
</paramDataSet>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>GetInventoryQtyAdj</methodName>
<returnType>Epicor.Mfg.BO.InventoryQtyAdjDataSet</returnType>
<localTime>8/26/2014 10:59:07:1780247 AM</localTime>
<executionTime>19</executionTime>
<parameters>
<parameter name='partnumber' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='uomCode' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='MethodReturned'
type='Epicor.Mfg.BO.InventoryQtyAdjDataSet' ><InventoryQtyAdjDataSet xmlns="
http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdj">
<InventoryQtyAdj>
<Company>1</Company>
<PartNum>ST062</PartNum>
<WareHseCode>PW</WareHseCode>
<OnHandQty>287</OnHandQty>
<BinNum>FD</BinNum>
<AdjustQuantity>0</AdjustQuantity>
<ReasonCode />
<LotNum />
<Reference />
<UnitOfMeasure>LB</UnitOfMeasure>
<TransDate>2014-08-26T00:00:00-04:00</TransDate>
<ReasonType>M</ReasonType>
<SerialNoQty>0</SerialNoQty>
<TempSerialNo>0</TempSerialNo>
<ReasonCodeReq>true</ReasonCodeReq>
<AllowNegQty>false</AllowNegQty>
<LegalNumberMessage />
<StkUOMCode>LB</StkUOMCode>
<EnableSN>false</EnableSN>
<OnHandUOM>LB</OnHandUOM>
<TranDocTypeID />
<PartTrackSerialNum>false</PartTrackSerialNum>
<PartSellingFactor>1</PartSellingFactor>
<PartPricePerCode>E</PartPricePerCode>
<PartTrackDimension>false</PartTrackDimension>
<PartIUM />
<PartSalesUM />
<PartTrackLots>false</PartTrackLots>
<PartPartDescription> 16 GA. ASTM 1011</PartPartDescription>
<ReasonCodeDescription />
<WareHseDescription>Production Warehouse</WareHseDescription>
<WhseBinDescription>FAB Department</WhseBinDescription>
<RowIdent />
<RowMod />
</InventoryQtyAdj>
</InventoryQtyAdjDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.Part</businessObject>
<methodName>PartExists</methodName>
<returnType>bool</returnType>
<localTime>8/26/2014 10:59:07:2000195 AM</localTime>
<executionTime>12</executionTime>
<parameters>
<parameter name='partNumber' type='string' ><![CDATA[ST062]]></parameter>
</parameters>
<returnValues>
<returnParameter name='MethodReturned' type='bool'

><![CDATA[True]]></returnParameter>
</returnValues>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.Part</businessObject>
<methodName>GetList</methodName>
<returnType>Epicor.Mfg.BO.PartListDataSet</returnType>
<localTime>8/26/2014 10:59:07:2160199 AM</localTime>
<executionTime>14</executionTime>
<parameters>
<parameter name='whereClause' type='string' ><![CDATA[PartNum='ST062' BY
PartNum]]></parameter>
<parameter name='pageSize' type='int' ><![CDATA[0]]></parameter>
<parameter name='absolutePage' type='int' ><![CDATA[0]]></parameter>
<parameter name='morePages' type='bool' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='morePages' type='bool'
><![CDATA[False]]></returnParameter>
<returnParameter name='MethodReturned' type='Epicor.Mfg.BO.PartListDataSet'
><PartListDataSet xmlns="http://www.epicor.com/Mfg/100/BO.Part/PartList">
<PartList>
<PartNum>ST062</PartNum>
<PartDescription> 16 GA. ASTM 1011</PartDescription>
<SearchWord>11ga A56</SearchWord>
<TypeCode>P</TypeCode>
<Method>false</Method>
<NonStock>false</NonStock>
<ProdCode />
<ClassID>STL</ClassID>
<OnHold>false</OnHold>
<InActive>false</InActive>
<TrackLots>false</TrackLots>
<PhantomBom>false</PhantomBom>
<TrackSerialNum>false</TrackSerialNum>
<TrackDimension>false</TrackDimension>
<Company>1</Company>
<IUM>LB</IUM>
<PUM>LB</PUM>
<QtyBearing>true</QtyBearing>
<LotMfgBatch>false</LotMfgBatch>
<LotBatch>false</LotBatch>
<LotMfgLot>false</LotMfgLot>
<LotHeat>false</LotHeat>
<LotFirmware>false</LotFirmware>
<LotBeforeDt>false</LotBeforeDt>
<LotMfgDt>false</LotMfgDt>
<LotCureDt>false</LotCureDt>
<LotExpDt>false</LotExpDt>
<SysRowID>ced6cb79-3d05-16b2-e111-c37cd274d6b3</SysRowID>
<RowIdent>0x00000000042f24e0</RowIdent>
<RowMod />
<DBRowIdent>AAAAAAQvJOA=</DBRowIdent>
</PartList>
</PartListDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>GetInventoryQtyAdjBrw</methodName>
<returnType>Epicor.Mfg.BO.InventoryQtyAdjBrwDataSet</returnType>
<localTime>8/26/2014 10:59:07:2400224 AM</localTime>
<executionTime>13</executionTime>
<parameters>
<parameter name='partNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='wareHouseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='primaryBin' type='string' ><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='primaryBin' type='string'
><![CDATA[FD]]></returnParameter>
<returnParameter name='MethodReturned'
type='Epicor.Mfg.BO.InventoryQtyAdjBrwDataSet' ><InventoryQtyAdjBrwDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.InventoryQtyAdj/InventoryQtyAdjBrw">
<InventoryQtyAdjBrw>
<Company>1</Company>
<BinNum>FD</BinNum>
<OnHandQty>287</OnHandQty>
<NonNettable>false</NonNettable>
<WareHseCode>PW</WareHseCode>

<LotNum />
<WhseBinDesc>FAB Department</WhseBinDesc>
<StkUOMCode>LB</StkUOMCode>
<StkUOMDesc>LB</StkUOMDesc>
<BaseOnHandQty>287</BaseOnHandQty>
<BaseOnHandUOM>LB</BaseOnHandUOM>
<RowIdent />
<RowMod />
</InventoryQtyAdjBrw>
</InventoryQtyAdjBrwDataSet></returnParameter>
</returnValues>
<paramDataSetChanges>
</paramDataSetChanges>
</tracePacket>


<tracePacket>
<businessObject>Epicor.Mfg.BO.InventoryQtyAdj</businessObject>
<methodName>CheckSN</methodName>
<returnType>void</returnType>
<localTime>8/26/2014 10:59:07:2570218 AM</localTime>
<executionTime>6</executionTime>
<parameters>
<parameter name='partNum' type='string' ><![CDATA[ST062]]></parameter>
<parameter name='warehouseCode' type='string' ><![CDATA[PW]]></parameter>
<parameter name='serialNumbersRequired' type='bool'
><![CDATA[]]></parameter>
</parameters>
<returnValues>
<returnParameter name='serialNumbersRequired' type='bool'
><![CDATA[False]]></returnParameter>
</returnValues>
</tracePacket>


[Non-text portions of this message have been removed]








[Non-text portions of this message have been removed]
10

HI

I agree with Amiee - DMT is your better option. It is what the tool is for.

Particularly, if this is a one time update.


UBAQs are great but are tricky and limited.  It does not always allow updates to the tables (or fields)  you want to update.


if DMT is not an option, do you have Service Connect? This is also a viable option - plus by the look of your email, you already have a trace done.


Marianne Gizzi

Estes Group