Data template for importing inventory counting

Data template for importing inventory counting

Product version: 

6.5 Update 6/6.6

Problem statement: 

Data Template is required to use in iVend MC--> Inventory Transaction Screens such as inventory counting . 

Proposed solution:

Suggested to use the below format for Inventory Counting and also suggested to  check various format for different document which are available on below path.

C:\Program Files (x86)\CitiXsys\iVendRetail\ManagementConsole\Import Templates

//Normal Product: ProductId,Quantity //

100102,5
100103,6
100104,7

//Serial Product: SerialNumber,Quantity //
1001,1
1002,1
1012,1

//Batch Product: BatchNumber,Quantity //
B100,8
B101,9
B121,5

If Location is enabled: Suggested to use the below format for Inventory Counting if location is enabled

ProductID,Quantity ,,LocationID

Note : There are double comma(,,) before LocationID

Steps if any : 
NA

Constraints / scenarios:  
NA

    • Related Articles

    • Inventory Counting Manual CountingAndFile Upload

      Inventory Counting - Manual and File Upload In versions of iVend Retail 6.5 and above, the system allows users to perform physical stock counts of inventory products. It also enables the user to reconcile the system inventory against the actual ...

    • Inventory counting information not replicating to HO.

      Query: - Inventory counting performed at store doesn't replicated to HO server. Store database showing data in the table InvInventoryCount but the same table on HO database is empty. Answer: - We would like to inform you that the inventory counting ...

    • Enable the Print button on Inventory Counting

      Environment: iVend 6.6 Problem statement: Enable the Print button on Inventory Counting Resolution/Work Around: 1: Login in MC. 2: Click on Administration Tab >> Retail Configuration >> Document Print Profile. 3: Select Document Print Profile and ...

    • Require to make the inventory as Zero for particular store

      Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...

    • Unable to Validate Item Matrix template

      Introduction: This article will demonstrate how to resolve the issue of upload templates of Item Matrix in SAP by using the initialization tool, where maybe we can face the below error. Case Study: The below example is a case study where we are ...