Inventory Corrections / Adjustments

Inventory corrections can be used to adjust the in stock figure for a product. This might be used to correct the quantity of an item after a stock take or to write-off damaged items.

Inventory corrections should not be used to add purchased inventory or remove shipped inventory - inventory should always be received into stock against a purchase order and removed from stock for sales by shipping goods-out notes.

Note that items received against a purchase order in error can also be unreceived rather than requiring a correction.

Accounting for corrections

When items are added or removed from inventory, an accounting journal is automatically posted in order to adjust the asset value of inventory.

Each in stock item has an asset value associated directly with it, therefore, when removing an item from stock the actual value of the specific item removed will be used. Since an item may have been received at different values over time, the inventory detail report is used so that you can select the item at the relevant value to be removed.

When adding items into stock the item value that will be used is taken from the default cost price list set at  Settings > Purchases > Purchase settings , but it can be manually edited during the process of adding the item.

The stock account (nominal) code that will be adjusted is selected directly from the product record. The opposite entry will be made to the account (nominal) code selected at  Settings > Company > Accounting: Nominal codes  as selected for  Stock corrections .

Related how to guides - Inventory

How to add inventory

The following steps can be used to increase inventory. This process should only be used to correct or adjust inventory, for example, after doing a stock take. To add purchased inventory it should always be received against a purchase order.

  1. Search for the product on the product list and click on the inventory level. In the pop-up window click on Add inventory for the relevant warehouse.
    add inventory1
    Alternatively, go to  Products > Add inventory  and search for the product (if multiple warehouses are in use ensure the relevant warehouse is selected also). Click  Add item .
  2. In the pop-up window enter the quantity to be added into stock and the value of a single item. This value will be used to create the accounting required to update the asset value.
    If warehouse locations are activated the location into which the items will be added is also displayed.
    add inventory
  3. Enter a reason for the adjustment. This will be recorded against the accounting journal.
  4. Click the Add items button to finish.

The inventory levels are immediately updated and an accounting journal posted to increase the current asset value using the cost value entered multiplied by the number of items added.

Tip : If you want to show a record of which SKU was updated in your General Ledger, then entering the SKU in the "Enter a reason for this adjustment" box is a good way of tracking this. This will show the SKU in the Details column in Reports > General Ledger .

Add remove stock

 

How to remove items from stock

The following steps can be used to decrease inventory. This process should only be used to correct or adjust inventory, for example, after doing a stock take. To remove sold inventory it should always be shipped against a sales order. If items were received against a purchase order by mistake then they may be unreceived .

  1. Search for the product on the product list and click on the in stock figure. In the pop-up window click on Edit/Remove inventory for the relevant warehouse.
    remove inventory
    Alternatively, go to  Products > Inventory detail  and search for the product (if multiple warehouses are in use ensure the relevant warehouse is selected also).
  2. The inventory detail report is displayed with the item listed once for each different value, purchase order or location it belongs to. Hover over the line that is to be changed to see the edit icon appear next to the in stock figure. Click on the edit icon .
    remove inventory2
  3. Enter the quantity to be removed - this must not be greater than the in quantity on hand for the item on that row of the product detail report.
  4. Enter a reason for the adjustment. This will be recorded against the accounting journal.
    remove inventory3
  5. Click the Remove items button to finish.

The inventory levels are immediately updated and an accounting journal posted to decrease the current asset value using the cost value of those items.

Tip : If you want to show a record of which SKU was updated in your General Ledger, then entering the SKU in the "Enter a reason for this adjustment" box is a good way of tracking this. This will show the SKU in the Details column in  Reports > General Ledger .

Add remove stock

 

How to update inventory levels by CSV (importing)

Inventory levels in Brightpearl can be updating in bulk by importing a CSV file.

Where a product is connected to a sales channel, those inventory levels will be updated on the sales channel where the inventory level has changed.

Follow these steps to update inventory levels by CSV:

  1. Create your file ready for import. This can be done by first exporting a list of your products and removing unwanted columns. Export your products from Products > List products .
    Howto Update inventory by CSV 1
  2. The import file must be a CSV file, and contain only, and all of, the following columns:
    Howto Update inventory by CSV 2
  3. Save the file as a CSV type file.
  4. Now import the file at Products > Update inventory by CSV . Make the following selections:
    Product ID :
    This is the Brightpearl product number assigned by Brightpearl when a product is created. It is displayed in an exported file of products and can be used to match items during an update.
    SKU :
    This is the Brightpearl product SKU. It can be used to match items during an update instead of using the Product ID. If it is blank it cannot be used for updating. SKUs can only be updated using the Product Import, not the inventory level import.
    - Quantity :
    The import can be used to adjust the current inventory level by this quantity (increase or decrease by this quantity) or to set it to the quantity in this field.
    Location :
    If warehouse locations is activated you will need to specify into which location the items are being added or from which to be removed. If it is not activated leave the fields blank.
    Item cost price :
    When increasing or decreasing inventory levels accounting entries are made to adjust inventory asset values. The accounting entries are made using the cost price of the product set here or from the 
    Match product by :
    SKU or Brightpearl ID. Both these columns are included in your file. If you don't have SKUs use the product ID.
    Quantity :
    Specify whether the file contains the actual quantity in stock, or a figure by which the existing inventory level should be changed by (e.g. 1, or -1, to increase or decrease by 1).
    Warehouse :
    Select the warehouse your are adjusting the inventory level in.
    Use cost price from :
    A cost price is required for making the accounting entries for each stock correction. The price can be taken from a price list or from the file.
  5. Browse for and select the CSV file to import.
  6. Click the Update inventory button to update the inventory levels. This cannot be reversed.

FAQs

I keep getting an error message saying, "Stock correction failed. Not enough on hand availability of product at specified location to perform stock correction". What do I need to do?

It is not possible to reduce your on hand stock quantity to below zero. Although your "in stock" quantity may be remain above zero if you were to reduce it, some of the stock may be allocated to sales orders and therefore your on hand level is less and would fall below zero. Take the following example:

In stock = 10

Allocated to sales orders = 9

On hand = 1

Import attempts to reduce by 5 and fails with the error.

You will need to un-allocate your stock before reattempting the import.

 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.