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. ...

    • Error at MC "Not enough quantity available in In-transit warehouse" while receiving Stock Transfer

      For Internal Use Product Version: 6.5 Update 6 Problem statement: An issue occurring where customer has done a Stock transfer in SAP (marked as for store), it has integrated to iVend Enterprise, then replicated down to the store, the transfer is at ...