How to import inventory adjustments

See this guide on how to create adjustments manually:
How to create regulations
Guide to general setup of import in Rackbeat:
Import in Rackbeat

If you have many adjustments, it can save time to import them instead of creating them manually. This is especially relevant for, e.g., stocktaking, inventory counts, general updates of cost prices, or transferring inventory data to integrations via webhooks.

Table of Contents

• General
  
  • Mandatory fields for import
  • Overview and description of possible fields for importing adjustments
• Import of adjustment by quantity
• Import of adjustment by cost price
• Import of adjustments with FIFO

---

General

Whether you use your own file or ours, it is important that the format imported is of type .CSV (CSV UTF-8 (comma separated)).

If you experience errors during import – see here

When importing adjustments, the following fields are mandatory:

• Date

• Product no.

• Location (for quantity adjustments)

• Quantity or Cost price

  • Note both cannot be updated simultaneously under the Average Inventory Value cost principle, and require 2 separate imports

  • With FIFO, quantity and cost price must always be specified simultaneously (read here)

• Reason

Complete overview of possible fields for importing adjustments and description:

• Date: Written in the format (DD.MM.YYYY). The date the adjustment affects inventory. Note it is only possible to do backdated adjustments.

• Product no: Number of the product or the bill of materials you adjust.

• Location: Number of the location you adjust quantity on.

• Quantity: The amount you adjust by. Relative adjustment determines whether inventory is added to or adjusted to the actual quantity.

• Relative adjustment: Here you choose whether you adjust by add/remove, or overwrite the quantity in stock.

  • Add/remove: Insert "1" in the column for Yes to Relative adjustment.

  • Overwrite quantity: Insert "0", or leave column empty for No to Relative adjustment.

• Cost price: The new cost price per unit you adjust.

• Reason: Specify the reason for the adjustment. This is shown on the item card and in the Transaction report, allowing you to search or sort by reason later on.

• Adjustment Type: Here you select the adjustment category. See an overview of your categories via the link here. If the column is empty, the status category will be used.

• Serial: For quantity adjustments on items with serial number control, the serial number being adjusted must be specified.

• Batch: For quantity adjustments on items with batch control, the batch number being adjusted must be specified.

• Variation 1: If the product is assigned a variation group, the variation must be specified for quantity adjustments. Write the name of variation 1 in the variation group here.

• Variation 2: Write the name of variation 2 in the variation group here.

---

Import of adjustment by quantity

When importing stock quantity, you must have the following columns:

• Date
• Product no
• Location
• Quantity
• Reason
• Relative adjustment

Example:

Example applies for average inventory value. See here for FIFO.

---

Import of adjustment by cost price:

When importing cost prices, you must have the following columns:

• Date
• Product no
• Cost price
• Reason

Example:

---

Import of adjustments with FIFO

Adjustment using FIFO (First In, First Out)
If you use FIFO as cost price principle, you must always specify a cost price when adjusting quantity.
Read more here: Average cost price vs. FIFO (First In, First Out)

It is possible to adjust the cost price without specifying quantity, but not vice versa – you cannot adjust quantity without also specifying cost price.

The purpose of FIFO is that each inventory quantity can have its own unique cost price.
Note: When you adjust the cost price, it will overwrite all existing cost prices registered on the product.

If you want the same product to appear with different cost prices in stock, you must first reset the quantity and then adjust both quantity and cost price separately for each cost price.

Example of quantity adjustment: