New Stock Transaction

This guide describes how to create a new stock transaction in Netvisor and how the system automatically or manually processes stock transactions. Stock transactions affect product stock balances and stock value depending on the type of transaction recorded.

CONTENTS

• Stock entry
• Stock entry view function

To create a new stock transaction, go to: Products > Stock > New stock transaction

If the company has stock management enabled, the system makes automatic stock entries for products defined as stockable. Creating an invoice reduces products from stock, creating an order reserves products, and when a purchase order is marked as delivered, it makes a purchase entry in the stock. An offer does not make entries in the stock. 

Transactions can also be recorded manually. This is done via the new stock transaction link. First, select the type of transaction for the entry. 

Stock entry

• Reference: Enter a reference visible in stock management entries and reports. You can drill down into the specific stock entry from the reference information. Reference is mandatory.
• Specification: You can provide a desired specification for the transaction.
• Vendor: Select a vendor from the vendor register. This affects the product's unit price (purchase price) if a vendor-specific purchase price is set for the product. If a product is already added to the stock transaction row and the vendor is changed for the stock entry, Netvisor asks: Update vendor-specific or product-specific unit price for purchase rows? If the transaction is not targeted to any vendor, select unallocated as the vendor.

OK button means update. Cancel button means do not update.

• Delivery method: The list includes delivery methods established for the company. These can be added from the sales basic data and settings and delivery method tab.
• Stock transactions: Creating a stock transaction starts by selecting a product from the product list. The product must be established in Netvisor and must be a stockable product. The product can be searched by selecting from the list, searching by code, or name. If a default stock and possible shelf location are defined for the product, these appear directly on the stock transaction row. The stock can also be manually defined on the product row.
• Specification: You can provide a desired row specification for the specific transaction.
• Quantity: Enter the desired quantity of products. For example, how many products have arrived in stock. Netvisor can automatically fetch a value for this field, but it can be manually changed. In the row below, for example, the value 7 has automatically appeared. The product's stock quantity was -1, and 6 products were reserved for it, so the value is based on this information. 

• Purchase price: The product's purchase price appears in the field. Or if a vendor-specific purchase price is defined for the product and the specific vendor is selected as the stock entry vendor, then the vendor's purchase price is used. If the company does not have freight handling enabled, the purchase price field does not appear. The product's purchase price then appears in the unit price field. Purchase price affects the product's stock value, average price calculation, and further sales margin calculation. Remember to provide the correct price for the product to avoid future issues.
• Freight cost: If the company has added the freight cost feature, the field shows the freight cost price for the specific product.
• Unit price: Calculated using the formula Purchase price + freight. Unit price is the value taken to the stock report. If the company does not have freight handling enabled, only one input field named Unit price appears on the stock row. 
• Sum: The value is calculated using the formula Unit price * product quantity.
• Status: The field has the following options:
• Processed: The stock row affects the stock quantity. 
• Open: The row does not affect the stock quantity. For example, an order sets the status to open, which reserves the specific product. Also, a purchase order that has not yet been delivered will have the status open.
• Transaction type: Transaction types include Sales, Purchase, Inventory, Correction, and Stock transfer. If necessary, transaction types can be manually added to the company from the menu stock > stock transaction types. Detailed instructions on transaction types can be found in the Stock transaction types guide. Below is a general definition of different types:
  • Purchase: Used when stock transactions are created in connection with a purchase invoice or manual stock entry. This transaction type increases stock value and quantity.
  • Sales: Used when stock transactions are created in connection with a sales order or sales invoice. The transaction reduces stock quantity and value.
  • Inventory: Used when stock transactions are created, for example, during inventory. Inventory affects stock quantity.
  • Correction: Used when you want to correct stock value without affecting stock quantities.
  • Stock transfer: Used when you want to transfer goods from one stock to another.
• Delivery date: Provide the date when the stock entry arrived/left the stock.

The triangle symbol means the row is not linked. This can only appear if the company has batch-based stock handling enabled. 

You can delete a product row using the red X button.

You can add new transaction rows via the "Add new transaction rows" link and specify how many are added at once.

Stock entry view function

• Show columns: By clicking this button, you can select which information is displayed on stock transaction rows. The view updates when you click the "Update view" button. Displaying batch information requires FIFO calculation to be enabled in the company.

• Select the action to be performed on selected rows: Using the selection below the stock rows, you can update the following information for selected stock rows.
  • Change selected unit price by factor: Select desired rows and provide a factor in the adjacent display to update the unit price. The Execute button makes the change. Remember to save changes afterward.
  • From the menu, you can also select to change the delivery date, status, stock, transaction type, or quantity with the action.
  • Distribute freight cost to selected: Distributes the given freight cost evenly among selected rows. This requires the freight cost feature to be enabled.
  • If the company has batch handling enabled, existing links can be removed or added. 
  • From the menu, you can also select to delete selected rows with the action.

• Save button: Next to the button is an upward triangle selection, which opens the menu below.
  • Go to stock management homepage: The link takes you to the same view as clicking the products tab in the main menu.
  • Go to stock transaction reports: Takes you to stock management reporting, detailed in the Stock management reports guide
  • Batch-based reports: The link appears if the company has batch handling enabled. The link takes you to stock management reports, but directly to batch-based reports.
  • Create stock order: With this, you can create a stock order/picking list for warehouse personnel from the stock entry, available in Finnish, English, or Swedish. You can choose to hide price information, comments, possible barcodes, and batch numbers. To display price information, you must have read or edit rights to purchase price in sales and purchase ledgers. 
  • Create new stock transaction: The link allows you to create a new stock transaction. The function takes you to the new stock transaction creation page, but no information is visible yet.
  • Add products: The button takes you to the product register, where you can select desired products for the stock transaction.
  • Copy transaction: Creates a copy of an existing saved transaction.
  • Show deleted: Displays deleted stock transaction rows.
  • Save: The button saves additions/changes made to stock entries.

Keywords: Stock transaction, stock entry, stock management

Did you find it helpful? Yes No