Stock up

<< Click to Display Table of Contents >>

Stock up

Navigation:  Dotypos Cloud > Item panel > Warehouses >

» Available only in Dotypos FULL and higher. «

 

In the item Warehouses » Stock up you will find an overview of performed stock ins, by default sorted according to date. Click in the pop-up menu 01 to choose the warehouse you want to stock in. Products will then be stocked in with the button Stock up 03. Use the buttons 06 to look into the details of the performed warehouse operations or to save the details in a .pdf file. Use the button Update 07 to stock in other products into an already finished stocking in. Use the button 02 to limit the stock in to a selected date or time period. To set the time period, have a look at this chapter.

Export the whole overview with the buttons 04 to an Excel table or a .csv file. In the case of every stock in, click on the supplier 05 and open its properties.

clip0874

 

uziv_tip_icon

You can also perform a batch stock in by importing an electronic delivery note. You can find more information about this option in this chapter.

top

How to stock in products

1_icon

In the item Warehouses » Stock up , click on the button 01 Stock up (see the figure above). This opens the page with product stock in options.

 

2_icon

In the product stock in page use the pop-up menu to 01 filter the displayed products pursuant to the selected category. Use the button 02 to select the products to stock in. The selected products will be moved to the right-hand side, where they can be modified. The moved products on the right side “fade out,” so you can easily recognize what was moved for stocking in.

clip0875
 

3_icon

From the pop-up menu 03 select the potential supplier to be assigned to all stocked products. By turning on the switch 04 you can also stock in with a backdate. However, for products stocked in with a backdate there must not exist any more recent stocktaking.

Switch Adjust purchase price 05(if enabled) includes the entered purchase price in the average purchase price of the product. With every product add to the field 06 the stocked in quantity and save the changes by clicking on Stock in in the bottom part of the page.

Note:
Purchase price means the product purchase price per sold unit. For example, when you stock in 10 one-liter wine bottles, you just stock in the price for a 1-liter bottle. However, if you stock in 0.7-liter bottles, you have to recalculate the purchase price to one liter and then insert the recalculated price.

If you enter a negative quantity to be stocked in (e.g. -10), you are making a correction and the entered quantity will be deducted from the quantity of the relevant product in stock.

Any product you do not wish to stock in can be removed using 07.

The batch import of products with the help of a template 09 is described in the guide below.

The buttons Recalculate sales price and Just notify 08 are related to the check, or automatic calculations of the set margin. For more information, see the chapter Settings and using of margins.

 

uziv_tip_icon

You can also stock in directly on the page with the product overview. You can find this sequence in this chapter.

You can continue stock in later. By continuing stock in, the same supplier and same invoice number are preset, so the items stocked in will be added to the same stock in report.

top


How to perform a batch stock in of products

Dotypos also allows the stocking in of products in bulk using the import file. Electronic delivery notes from more suppliers are also supported.

1_icon

Click on the button Import 01 to display the import options on the page. If you have the import file ready, upload it with the button Browse...04. If you import the stock in list from the supported suppliers, do not forget to select the right supplier from the pull-down menu 02. So Dotypos recognizes the file structure from this supplier and performs the stock in. It is important that products in the cash register have the same EAN code as the products being stocked in.

The following suppliers are currently supported:

PEAL

Quanto

ČAS

Makro order and Makro invoice

EUROCASH

 

If you are importing for the first time or you are not sure about the format of the import table, download the template sablona.csv 03 and fill out the table accordingly (a description of the individual fields can be found under the picture below). Select this saved table with the button Browse...04.

clip0876

 

2_icon

After selecting a CSV file 01, click on the button Upload 02 and the items in the import file will be shown in the bottom part of the page 03 for further editing. When you are done, stock in the items using the button Stock up 04.

clip0877

 

poznamka_icon

When importing a stock in, Dotypos verifies whether products in the file for stock in correspond with products in the cash register. If they do not correspond, a dialog with unpaired products is displayed. In this dialog, unpaired products can be stocked in to current products (you can search them and then use the button Assign to stock in/assign to a product) or created as new products and then the unpaired (unknown) items can be stocked in to newly created products. You have to assign the unpaired products to a new or existing product.

clip0878

 

poznamka_icon

How Dotypos calculates the purchase price?

nakupnicena

Note: Dotypos does not use FIFO to calculate the purchase price.

top


Description of import file columns

When importing stock in, the products in the cash register are paired on the basis of ean, plu, externalid or productid. So when a product is found in the cash register by one of these criteria, it will be stocked in using data in the next columns of the import file.

The stock in import checks duplicate items. When a duplicate item in the import file is found, an error message will be displayed.

Import file for batch stock in of products

ean

product code

plu

product code

externalId

external product ID (selected by the customer, can be found in product details).

productId

product ID (system-generated, can be found in product details).

price

Purchase price excluding VAT

priceSum

Total purchase price

priceSell

Sale price

quantity

Product quantity

The required items are marked in bold, other items (data) are optional. The only mandatory field is either ean, plu, externalId or productId. If the product cannot be found by ean, it is looked for by plu, then by externalId and productId.

 

The import file can look like this:

2017-06-19_170904

 

dulezite_sdeleni_icon

Please remember that products cannot be imported with the disabled option Deduct from stock.

clip0879

 

uziv_tip_icon

The guide on how to correctly import a .CSV file into MS Excel can be found here.

top


How to display a list of corrections?

The warehouse correction list (write-offs) displays the total value of written-off items. In the upper bar, select LIST OF CORRECTIONS 01 and after selecting a warehouse 02 and setting the time frame 03 the list of the performed corrections will be displayed. If you want to display the details of the selected correction, click on the button Detail 04. The selected correction can be saved in a .pdf file.

clip0880

 

uziv_tip_icon

Warehouse corrections are also displayed in the warehouse report Warehouse operations.

top