Barcode scanned in quantity column while creating a stock transfer , causing integration falilure

Barcode scanned in quantity column while creating a stock transfer , causing integration falilure

This KB is for Internal Purpose Only for CitiXsys

Environment :

iVend 6.6 with SAPB1

Problem Statement :

Record stuck in integration monitor. Showing below error.

System.Exception: DI:Quantity falls into negative inventory  [WTR1.ItemCode][line: 16] en ReplicationSBOIntegrationWinSer.IntegrationObjects.InventoryStockTransfer.CreateInventoryStockTransfer(DataRow[] objDataRow, DataSet objDataSetSerialBatch, Direction From, Direction To, String iVendSBOSTNumber, Boolean IsGoodReceiptST, DataRow[] objDataRowUserDefinedFields)
   en ReplicationSBOIntegrationWinSer.IntegrationObjects.Transactions.Replicate(Direction From, Direction To, Int32 DatasetRowID)
   en ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean& Retried)


Cause :

If in any stock transfer customer scan the barcode in quantity by mistake .so it is generating millions of negatives for customer.

Symptoms :

NotApplicable

Resolution/Work Around :

Need to update Stock transfer detail with Quantity,QuantityOpen,QuantityShipped,UOMQuantity,UOMQuantityOpen,UOMQuantityShipped ,also need to update InStockQuantity, AvailableQuantity in warehouse ( Main warehouse , Retail warehouse , Intranset warehouse.

update InvStockTransferDetail set Quantity='1.00000',QuantityOpen='1.00000',QuantityShipped='1.00000', UOMQuantity='1.00000',UOMQuantityOpen='1.00000',UOMQuantityShipped='1.0000' where StockTransferKey='Enter stock transfer key'
and linenumber='enter the line number'
update InvInventoryItem set InStockQuantity=0,AvailableQuantity=0 where ProductKey='Product key' and WarehouseKey='warehouse key'

Recommendations /Suggestion : 

Need to take backup of data before update.

    • Related Articles

    • Duplicate Stock Transfer Shipment

      Environment: iVend 6.5 Update 6 Problem Statement: While making a Stock Transfer receipt on receiving store MC, the user noticed that Stock Transfer Shipment is duplicated. Proposed Solution: CheckPoints: Check If stock Transfer Shipment Series is ...

    • iVend Stock transfer insufficient quantity in intransit

      Problem Statement: At the time of stock transfer customer was facing insufficient quantity in intransit - but the stock at intransit was showing sufficient on View InventoryEnvironment: 6.5 Update 6 integrated with SAP 9.2. Symptoms: User was not ...

    • UDF (No Barcode field) on Stock transfer receipt screen.

      Environment iVend Version 6.6 With SAP B1 9.2 Problem Statement There is no Barcode field on Stock transfer receipt screen (Screen to receive stocks from retail warehouse) in SAP B1 as shown below so we tried to create a UDF in table of stock ...

    • Data not populating in UDF on Stock Transfer Receipt document

      Environment: iVend Retail 6.6 7989 SAP Business One 9.3 Problem Statement: Barcode not not showing while creating the stock transfer receipt. Symptoms: It was checked that the Marketing Document UDF “Stock Transfer Receipt” was not integrate. ...

    • Integration: Stock Transfer Cancelation

      Environment iVend 6.5 Update 6 and 6.6 with SAP B1 9.2 Problem Statement Created Stock Transfer from SAPB1 General warehouse to iVend Retail Store ( which is not initialized or inactive) and user want to cancel it so that inventory can be revert back ...