This guide helps you perform inventory in Rackbeat, allowing you to set the desired quantity and price in the inventory. Inventory can be done either directly in the program or using a CSV file.
CONTENTS
- Resetting inventory for a specific product
- New inventory entry
- Inventory entry using a CSV file
- Example of inventory
In the Reporting > Valuation report, you can see the inventory quantity and value of a product/products on a desired day. If there are corrections needed, an inventory entry must be made to correct the situation. The inventory quantity shows in which warehouse the specific product is located.
Resetting inventory for a specific product
You can reset the inventory by going to Inventory > Inventory transactions.
Correction in the program
Select "Create new inventory transaction".
- Select the desired product and edit the quantity. You can search for the product and retrieve products from a specific warehouse through the product's extended search. The edit date will be the day the change is saved in the inventory. This can be done retroactively.
- Select the warehouse where the specific product is located, if this does not come directly when selecting the product.
- The In stock field shows the current inventory quantity.
- Enter a zero value in the Actual quantity field, which will reset the inventory quantity.
- Select "inventory" as the inventory transaction type and enter text about the change in the reason field.
- Finally, save by clicking the Edit quantity and value button.
To save the change permanently, go to the inventory transaction screen and click "record" for the specific change line.
New inventory entry
- After resetting the inventory, make a new inventory entry for the same product.
- Enter the correct quantity in the Actual quantity field, indicating how much of the product is in stock.
- Press "Edit quantity and value" to save the change.
In this case, the correct quantity is 10 units, and when entering the information, you can also provide a new purchase price, resulting in an inventory value of purchase price * quantity. In this case, 10*20 = 200 €
Finally, confirm the change line from the inventory transactions view by clicking "Record".
By searching for the previously selected warehouse events in the Reporting > Valuation report, you can check that there are 10 units of the product in stock, and the value is 200.
Inventory entry using a CSV file
- You can perform inventory using a CSV file by going to Inventory > Inventory transactions.
- Select "Import data / Download data".
3. Download the template file to your computer through this.
If the initial inventory has been imported, and in the future, this will be used to correct the balance, the columns also need "balance correction" to ensure the quantity is correct. 1= added to the existing 0= existing quantity is overridden by the file's quantity. If left empty, the effect is the same as 0. Required fields: Date, Product code, Warehouse (numeric), Quantity, Balance correction, Cost price.
- First, enter the date in Excel; it's advisable to format the field as text initially to prevent the possible leading zero from disappearing. The date is entered in the format dd.mm.yyyy, e.g., 26.06.2024
- For the product, enter the product code. This can be found in the number field on the product card.
- In the Warehouse field, enter the warehouse number value, which can be found in Inventory > Locations.
- Enter a zero value in the Quantity field, which will reset the inventory quantity.
- The Cost price field does not matter in this case, regardless of the value.
- Enter the desired reason in the Reason field, e.g., "inventory correction".
- Write Inventory as the inventory transaction type.
Example of inventory
1. Save the data in Excel and import the data by going to Inventory > Inventory transactions > Import data / download data.
2. In the Select files section, retrieve the file saved in Excel.
3. The view below opens, where you can leave fields out if necessary. In this example, no fields need to be left out
4. Press the Import button
5. Record the inventory transaction line
6. The inventory is zero for the specific product
7. Import the new correct quantity and purchase price (Cost price) from Excel. As an example, quantity 15, purchase price 10
8. Import the file
9. Note! The line must be remembered to be confirmed
10. Finally, there are 10 products in stock, priced at 15 €, and the inventory value is 10*15 = 150 €
Keywords: Rackbeat inventory, inventory management, inventory transactions, inventory value, inventory reset
Did you find it helpful? Yes No
Send feedback