Stock & Inventory
In your inventory, you may have stock items that belong to the same stock type and are different only for the colour or the size.
These stock items can share the same description or image. To copy the image or description from the parent stock item to the children, follow the procedure outline below.
You will first assign a description to the Parent stock item
1) Launch EVE and click Inventory
2) Go to the Stock Item and click Find
3) Complete a Stock Item Search, by Stock Type and Manufacturer.
4) Double click on the Parent stock item
5) Click on the EVE OnLine tab
6) Click on the Product Details tab
7) Enter the Parent stock item description
8) Save the record
9) Stay in the EVE OnLine tab and click the Links Tab
10 ) Select the record for each child item you wish to update and right click on the selection
11) Click on Copy Parent’s note to children ( or copy parent’s image to children if you wish to copy the image)
12) Click OK
Categories:
Stock & Inventory,
Updating Multiple Records
1. How to Create a Simple Equipment Package Sale
This video shows how to create a simple equipment package for sale:
2. How to create a flexible package of stock items forsale (Equipment)
This video shows how to create a flexible package of stock items for sale(equipment):
Category:
Stock & Inventory
2 stock items should be created.
One (the pack or multiple) for use with Purchases.
One (the individual) for Sale
Taking a length of rope as an example:-
So, first should be the full roll of rope at whatever length you might buy it in.
This should be marked on the Stock Levels tab as For PO:
Please note that clicking Forward will reveal pictures accurately if they don’t display properly here.
And should be the one used to order the rope.
The second should be the rope in the smallest increment they sell it in, whether ½ metre or 1 metre, say.
This should be marked as Maintain Stock Level but not For PO:
Flow is as follows:
1/ Order full roll of rope
2/ Check in rope when it arrives.
3/ Manually decrement the full roll by the number ordered. So, if ordered 2 rolls reduce no. in stock of full rolls by 2.
4/ Manually increment no. in stock of partial (e.g. ½ metre rope) stock item by whatever, in this example, is the length of 2 rolls of rope.
5/ Sell the ½ metre stock item to customers. Clearly, if the customer wants 20 metres, you sell 40 of this stock item.
6/ EVE will track sales of this stock item. When this ½ metre stock item reaches low level, reorder the full stock item and repeat the process.
(For profit and COGS sold report, the ½ metre stock item should have a cost price entered of whatever is the fraction of the overall cost that is the ½ metre proportion.)
Category:
Stock & Inventory
The best way to do a stock take is to go to Inventory and then select Inventory Count from the power bar at the bottom of the screen.
Then select the combination of supplier and stock type that you wish to count first and then select Finish.
Enter the new number in stock of the items
Selecting OK from the bottom of the screen when you have counted, say, all the fins in stock, will write these records back to each item on the database.
Category:
Stock & Inventory
You’ll be able to import from Excel into EVE by using the Excel import templates that are provided within the program. Using Customers as an example to serve for all: You can access these by going to, from the top menu in EVE, File / Import and then select Import from Excel and click Import
Please note that clicking Forward will reveal pictures accurately if they don’t display properly here
Highlighting Customers and then clicking the Show Template button
Will open Excel and that template.
These templates are, by default, contained within C:\Program Files\Integrated ScubaSystems\EVE\Import The key on the import is the structure of the Excel file – please do not change the titles of
the columns.
Mandatory data fields have red column titles – optional are coloured black.
Once your existing data is in the correct format you can then select the
Save As option and name the file as you wish.
Please note: we recommend you take a backup of your EVE database prior to import.
You can then import your data by going, again, to File / Import
from the top menu and then Import from Excel again and then highlight the data type – Customers, Suppliers etc. – and then select Import
By default this will open the Import folder previously mentioned though you can, of course, navigate to any other location where you have saved your Excel files.
You’ll find the process relatively simple.
You can download a video outlining the process at http://eve.issys.co.uk/files/EVE5Tutorials/EVE5-SimpleImport.exe
Pressing the Space Bar on your keyboard will stop and restart the video for you.
Category:
Stock & Inventory
You can import stock and inventory data from Microsoft Excel into EVE.
From the top menu in EVE go to File / Import then check the Import from Excel box and click on Import where you will then see:
You must ensure that the data in your Microsoft Excel spreadsheet is in the correct format before attempting to import it. A Microsoft Excel template (containing some example data) for is provided in the EVE import folder (C:\Program files\Integrated Scuba Systems\Import). You can view the template by clicking the Show Template button. The first row of each template contains column headers. Your file does not need to include all columns listed in the template. However, if your file does include a listed column, the column header in your file must exactly match the column header in the template (for example, your column containing the item description must have the text ‘Description’ in the first row).Columns in your file do not need to be in the same position as in the template. Before importing, EVE scans your file and locates the positions of each column based on the text in the f irst row. Some columns are mandatory and these columns are identified with a red header name. These are:
Description
StockNo
Manufacturer
StockType
Any row containing data in these columns will be im ported into EVE, regardless of whether there is any data in any of the other columns. Each row (after the header row) in your Microsoft Excel spreadsheet corresponds to one record to be imported. Each column in your Microso ft Excel spreadsheet corresponds to one attribute of the record (for example,Description, Manufacturer etc.). EVE will continue to import data until it encounters 10 consecutive blank rows. This means you can have a few blank rows in your file and EVE will just skip those rows and continue.
Once it has successfully imported a row, EVE writes an X to the first column of that row. This is so that if the import process is interrupted, it can be resumed at a later date from where it left off. All rows containing an X in the first column are skipped so the same data is not imported more than once. Be careful to ensure that the first column is blank before you start the process. It does not matter what the column header is. Column A therefore should be blank in the data file. The level of additional detail displayed may be decided by the Manufacturer in the case of those price lists supplied directly by the Manufacturer. Please ensure that you have the correct Cost Price Level indicated in EVE for any supplier prior to import. You’ll find this area in Inventory / Suppliers / Find and then
Search for the relevant supplier
Then go to the Details tab of the supplier record and enter the Cost Price Level – whether 1,2,3, etc. as appropriate. The Cost Price Level that you wish EVE to use by default should be set to the same as the appropriate Cost Price Level in the spreadsheet.
EVE allocates the Purchase Tax Band at the Stock Type level. You may wish to check that the Stock Types you have in EVE are associated with the correct Tax Band prior to Import. You can find this area in Inventory / Stock Types / Find and then Search for the appropriate stock type(s).
Handling Duplicates
You may encounter duplicates when importing data. Some types of data in EVE require that each record has one or more unique fields. For example, Stock Items must have a unique stock number and a unique barcode number – the stock number of an item must be different than the stock number of all other items and the barcode number must be different than the barcode number of all other items. If you try to import a record into EVE that would violate the uniqueness requirements, EVE will prompt you how you want to continue. In the figure below, a stock item record is being imported that has the same stock number as an existing item. You must tell EVE how to continue by choosing an option in the action section and optionally changing the value in one or more of the white fields. You can scroll down to see all fields on the original and import row.
Click Overwrite if you want to overwrite the existing record with data on the import record. You must decide what you want to happen if there is no data in a particular column on the import row. You can choose to update the corresponding column on the existing record to be blank or you can choose to leave the existing column alone.
The decision you make may depend on the circumstances: for instance, if you are importing a supplier stock list to update prices on Stock Items from that supplier, you will probably leave the No In Stock column blank on all rows in the import file. In this case you will not want to update the No In Stock on all existing records as this would wipe out all your stock levels.
Not all columns have the option of being handled th is way. For instance, columns that are mandatory can never have a blank value on the import record. EVE will put an icon next to column names for which this handling is valid beneath the query symbol. By default, the icon will be implying that the existing value will be left unchanged if the import value is blank. Click on the tick to change it if you want the existing value to be blanked out if the import value is blank.
When doing a stock item import it is possible that the record being imported has the same Stock No as one existing record and the same Barcode No as a different existing record. In this case, EVE will report that duplication errors have occurred on both stock # and barcode # and it will present both existing records to you as well as the import record (there will be two icons next to the existing item text showing a one and a two. Click on each icon to show the corresponding existing record). Be carefu l when handling this case – you will need to choose carefully whether you want to update the existing record(s) and/or the import record before resolving the duplicates.
Click Retry if you want to instruct EVE to try again to import the same record. There is no point in doing this unless you have made a change to the data in one of the white text boxes of the import item. For example, you could change the stock # so that it is no longer the same as any existing stock #s.
Click New if you want to instruct EVE to create a new record. Again, there is no point in doing this unless you have made a change to the data in one of the white text boxes of the import item – otherwise you will simply get another duplication error.
Click Abort to abandon the import process. All data already i mported will remain on the database.
Category:
Stock & Inventory
Barcode scanners must be keyboard wedge scanners in design – i.e. it simulates the action of entering data via a keyboard – though connection, can, of course, be vi a USB port or wirelessly.
If possible, we recommend purchasing a scanner that can be programmed with an F9 prefix (i.e. when you scan a barcode, an F9 is appended to the start of the barcode information before it is sent to EVE) – as then EVE will set focus to the Barcode field on the Invoice automatic ally.
Metrologic Voyager scanners – principally the MS9520/40 VoyagerCG – are used by many centres. You can see more on these at www.metrologic.com
Category:
Stock & Inventory
To synchronize all retail prices across multiple cost centers you need to use the Pricing Wizard.
Want to do all prices, go to File / Wizards / Pricing Wizard.
Want to first select items to update, then select them in Stock Item search grid, then select all, right click and select Update Multiple Retail Prices:
Category:
Stock & Inventory
If intending to use a dedicated barcode printer (recommended), the barcode printer we’d recommend would be a Zebra GX 420 t – see www.zebra.com or http://www.nationalbarcode.com/catalog/zebra/gx420t.htm
To configure the Zebra Printer go to Tools / Options / All PCs from the top menu in EVE and then click the Labels tab.
a/ select the Print Immediately option, and
b/ then click on to the EPL Label Layout(s) button.
Please note that clicking Forward will reveal pictures accurately if they don’t display properly here.
If you have different labels or wish to move things around then you can edit the settings as you see fit.
You’ll then need to test the resulting labels you print with your scanner.
For printing the labels please remember to use the EPL printer option.
Printing
Once the Print labels immediately… box is checked:
The method for printing is as follows:
Go to Inventory / Stock Items / Find and then enter the search criteria you want.
Right click on any item in the results and select Print Label(s)
Click on the EPL Printer tab
EVE will, by default, print the same number of labels as items that you have in stock.
Category:
Stock & Inventory
Updating Multiple Records
In your inventory, you may have stock items that belong to the same stock type and are different only for the colour or the size.
These stock items can share the same description or image. To copy the image or description from the parent stock item to the children, follow the procedure outline below.
You will first assign a description to the Parent stock item
1) Launch EVE and click Inventory
2) Go to the Stock Item and click Find
3) Complete a Stock Item Search, by Stock Type and Manufacturer.
4) Double click on the Parent stock item
5) Click on the EVE OnLine tab
6) Click on the Product Details tab
7) Enter the Parent stock item description
8) Save the record
9) Stay in the EVE OnLine tab and click the Links Tab
10 ) Select the record for each child item you wish to update and right click on the selection
11) Click on Copy Parent’s note to children ( or copy parent’s image to children if you wish to copy the image)
12) Click OK
Categories:
Stock & Inventory,
Updating Multiple Records