Stock

Created by Travis Lander, Modified on Tue, 9 Jan at 10:29 AM by Travis Lander

Description

Create stock and adjust inventory quantities across warehouses in SoftLedger. Manage your physical inventory from Inventory>Stock:

See a summary of the number of Stock for all Items across all Warehouses.

See a list of all created Stock adjustments that involve adding or subtracting stock quantities for any Item in any Warehouse.

ID - Unique ID to identify the adjustment (can be used later to find if investigating cost basis errors).
Item - Click to view Item details.
Warehouse - Click to view Warehouse details.
#In Stock - Quantity of Stock on hand for this item at the Warehouse.
Journal - View the Journal created from this adjustment.
Type - One of 'adjustment', 'transfer', 'fulfill', 'receive', depending on what caused the adjustment in Stock.
Ref. - Reference to a linked document (Sales Order, Purchase Order).
Qty Adjusted - Positive or negative adjustment amount.
Running Qty - Amount in Stock at the time of that adjustment.
Currency - For a positive adjustment, the currency the price field uses.
Price - For a positive adjustment, the cost each Item was received at.
Cost Basis - For a negative adjustment, the cost basis and linked cost layers calculated for this adjustment.

Edit or Delete adjustments made from the Actions column on the far right of the table.

See a list of all transfer of Stock made from one Warehouse to another.

ID - Unique ID to identify the transfer (can be used later to find if investigating cost basis errors).
From Warehouse - Warehouse Stock transferred from.
To Warehouse - Warehouse the Stock was transferred to.
Item - Item transferred.
Date - Date of the transfer
QTY Transferred - Amount of stock transferred

Edit or Delete transfers made from the Actions column on the far right of the table.

Use this form to manually add or remove Stock from the inventory of a specific Warehouse.

Date - Date the Stock adjustment is made.
Posting Date - Date the adjustment will be posted to the inventory sub-ledger.
Quantity - Amount of Stock to adjust.
Price - Per Unit Price Stock was received at. If it is a negative adjustment, this is disabled as the cost basis is used.
Item - Item adjusted.
Warehouse - Warehouse Item is added to or removed from.
Adjustment Ledger Account - Ledger Account impacted by adjustment (e.g. Cost of Goods Sold).
Currency - For positive adjustments, the currency the price field uses.

Use this form to transfer Stock from one Warehouse to another.

Transfer Stock.png

From Warehouse - Warehouse to pick Stock to be transferred from.

Complete (default) - creates a negative adjustment for the FROM warehouse and a positive adjustment into the TO warehouse.
In Transit - will only create the negative adjustment for the FROM warehouse.

In order to add the positive adjustment for the TO warehouse, you will need to “complete” the transfer.

Both in transit and complete status transfers can still be edited and deleted.

Filters - Filter what appears in the table based on one or more fields available in the table.
Saved Views - You can create a set of filters that you would like to save to be able to quickly filter a table.
Column Selector - Hide and reveal extra columns and the number of rows visible in the table per page.
Export - Table data can be exported using the export button at the top of the table.