This article explains how to track stock balances on items in Next, including how to manually update stock quantities and how invoicing affects those balances. It also covers the Stock Value List report, detailing its available columns and the calculations used to determine stock balance, withdrawn uninvoiced quantities, corrected stock balance, and stock value.
In Next, you have the option to track stock balance on items. Keep in mind that this feature is not comparable to a full inventory management system.
To get started, enter the stock balance for each article manually or through the import in Price List. When an article is pulled from the price list into a project or work order and then invoiced, the stock balance is reduced. Note that the reduction only happens when you lock the invoice — manual changes to invoice lines do not affect the stock balance.
When you purchase an article, you manually enter the change in the Stock Balance Change column. For example, if you purchased 100 pieces, enter 100. If you need to adjust the stock balance downwards, enter a negative value — for example, -50 to reduce it by 50 pieces. Once you enter a value and save, the Stock Balance is updated and the Stock Balance Change field is cleared. In the example shown in the image below, the Stock Balance will become 199 after saving, and the Stock Balance Change field will be blank.
Price list article view; note the highlighted Lagersaldo and Ändra lager columns.
Stock Value List
There is a report called the Stock Value List, available in Price List, that shows your articles and their stock balances. For an article to appear in the list, it must have a stock balance entered. Articles where the stock balance column is empty will not be shown. It doesn't matter which price list the article comes from. The Stock Value List is sorted by article number in descending order.
Columns of the Stock Value List
Stock Balance = Specified amount - invoiced amount
Withdrawn Uninvoiced = The number that has been reported on a project or work order but has not yet been invoiced. Note that this also includes order lines in invoice drafts (not locked invoices).
Corrected Stock Balance = Stock Balance - Withdrawn Uninvoiced
Stock Value = Cost/unit * Corrected Stock Balance