Add stock to Bins in Bulk

Back Top Prev Next Print

To add stock to bins in bulk, create a list of the stock in question, right click and select Export Procurement Data.

 

exportprocurement

 

This will export the data to a spreadsheet where you can update the bins

 

stockbin

 

Then import via Tools > Import Data and select Stock Location Procurement as the import destination.

 

importprocurement

 

Click Next. Select the Source File name and open the saved spreadsheet. Map the Source Field Name to the Destination Field Name if not already done.

 

To change Destination Field Name, from the drop down list in that column select the corresponding field in Jim2:

 

locfield

Example only

 

Click Next, then Load data to grid from source.

 

loaddata

 

When you load the data you will receive a warning that there are errors. Please ignore this warning.

 

Click Synchronise, (this step is important as it ensures everything is ok to bring in to Jim2.)

 

synchronise

Example only

 

impprocurement

 

Click OK. You will receive a pop up advising that the data test was successful.

 

Select Import data and you're done.

 

import1a

 

Further information

Allocate Stock to Bins