Perform other inputs and outputs by importing file

Since the window "Other entries" or "Other exits", you select the menu "File / Import from file".

A window "Import Movements" opens.

From this window, you can import stock movements from text files. This can for example be useful if you want to reproduce entries or exits that you were given via a spreadsheet like Excel, or if you want to get out of control from your website E-commerce, ...

Enter the details of import

You must first specify on which warehouse you wish to make the movement.

Then, choose the case of an entrance or exit.

If you have chosen to manage the used items, you can select if a file of new or used items.

By default, the program will read the reference section in the first position of the line of the file, and the amount of movement in the second. These positions may be specified by you indicating the number thereof in the boxes "Reference" and "Quantity" respectively.

You must also specify what will be the column separator to interpret the file. If your quantities contain decimals, also specify the decimal separator.

All these choices are saved, you will not have to enter it each time.

Then select the file using the button "... .

Upload file

Then click the button "Import".

The program will read the file based on the information you have entered, the lines beginning with the # symbol will be ignored.

Line by line, the program will search the item on the basis of the reference line. It will conduct research at three levels:

Firstly, it will search the item on the basis of its reference "Stock It Easy", simply called "Reference" in the program. To do this, it will automatically complete the reference read from 0 to the left to reach a 6-digit number, eg "12" will be interpreted as "000012."

If the item is not found on the reference, the search will be performed identically on the item reference section.

Finally, if the reference section is not found, the search will take place on the reference supplier.

To help you visualize how to reference the article was found, the reference found for an item is highlighted in green.

It is important to note that research on item number or reference provider can bring a meaningful result if you enter any unique references for your article database, otherwise the first item whose reference is found will be displayed.

If the item is not found, it will be highlighted in red.

If you specified an output of stock, import the file will see the stock available, taking into account the amounts outstanding out, if the stock is insufficient to meet the output line is highlighted in red and an error message assigned.

If your item is found "sleeping", but it will be displayed highlighted in red and impossible to change, this movement can not be saved.

If the item is an item composed, it will be displayed highlighted in red and impossible to change, this movement can not be saved. It is however expected to improve the use of this function to such items.

It is also foreseen in the near future to manage the tracking and monitoring criteria (Lots, use by date and date of optimal use) managing such automatic output first in first out (FIFO).

The imported file is copied to the subdirectory synchro / archive of the application.

Change the quantities imported

At this stage, no movement of stock is still registered in Stock It Easy, you can still line by line, go to modify the quantity read from the file. If you chose to import a release, the new quantity entered will be reassessed to determine if the stock is sufficient for the requested output. If you do not want to record the movement of a section of the file, simply enter 0 in the quantity column.

Changes made to the screen does not alter the original file or the saved file.

Recording stock movements

Click the Save button.

The lines without error message and having a quantity > 0 will be recorded as input or output of stock. This action is therefore final.