Rackbeat Inventory Purchase Price Adjustment : Netvisor

This help explains how to correct an incorrect or missing purchase price of a product in stock. This can be done either in the program or via a CSV file.

CONTENTS

Correction in the program
Correction via CSV file

If the purchase price of a product in stock is incorrect or has not been provided at all, below is guidance on how to correct this.

Correction in the program

1. Go to Stock > Stock transactions

2. Select "Create new stock transaction"

3. Select "Edit purchase price"

4. Select the desired product

The edit date is set to the day from which the change in purchase price is desired to be visible in the stock.
NOTE! If the product quantity is zero in the stock, the purchase price cannot be edited, and this will cause an error message. The same happens if there is a negative value available.

5. Enter the correct new purchase price in the Actual purchase price field from the edit date onwards. It is advisable to select inventory as the transaction type. If left empty, inventory will also be selected.
A value must be given in the Reason field for why the change was made.

6. Check the save and new field and press the "Edit purchase price" button.

7. Go to stock > stock transactions and search with draft status for "all transactions" or just this specific product and press "post" at the end of the row so that the change is saved in the stock.

Correction via CSV file

1. Go to Stock > Stock transactions

2. Select "Import data / Download data"
3. Save the example file and edit it.

4. Enter the date field for the day when the change is desired. Note the format, for example, the first day of june should be entered as 01.06.2024 (format the field as a text file in Excel so that leading zeros are not lost).
5. Enter the desired product code and in which stock it is.

6. Leave the Quantity field empty

7. Enter the correct new purchase price in the Cost price field.

8. Provide the desired reason.
9. Import this file into the program via the "Import data / Download data" button.

In the Transfer view, you can still delete extra fields.

However, the date, product code, stock, cost price, and reason must be included.

Go to stock > stock transactions and search with draft status for all transactions or just this specific product and press "post" at the end of the row so that the change is saved in the stock.

Keywords: Rackbeat stock, purchase price

This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.

Did you find it helpful? Yes No