Viewing the Stock Ledger
The Stock Ledger report helps you manage inventory by showing activity for items over a period. It is a tool you can use to better understand inventory activity across classes, departments, and subsidiaries for multiple locations, For example, stockrooms, warehouses, and retail stores. It can help identify inventory items that are slow-moving, fast-moving, or overstocked. It can help identify inventory investment strategies and planning, as well as improve the effectiveness of item promotions.
For example, on the report, you can define a time period from November 1st to November 30th. The report displays the following item data for the defined period:
-
What was the beginning count of inventory on hand at the start?
-
What were all inputs that came in?
-
What were all outputs that went out?
-
What was the final count of inventory on hand at the end?
In accounts that use the Multiple Units of Measure feature, quantities displayed on the Stock Ledger report are in stock units.
The Stock Ledger report returns data on inventory items and assembly items.
To use the Stock Ledger report, you must have the Inventory feature enabled in your account.
If you use the Multiple Units of Measure feature, quantities are displayed in stock units.
If the Multi-Currency feature is enabled in your account, values on this report are displayed in the primary currency of your account.
In NetSuite OneWorld, values are displayed in the primary currency for your subsidiary.
To view the stock ledger:
-
Go to Reports > Inventory/Items > Stock Ledger.
A message appears indicating that your report is loading. The status bar indicates the progress as your report loads. You can click Cancel Report to stop the report from loading.
-
Make selections in the following fields in the footer of the report to define the data returned by the report:
-
Define a date range using one of the following:
-
Make a selection in the Date field.
-
Make selections in the From field and the To field.
-
-
If you use NetSuite OneWorld, the Subsidiary Context field enables you to filter the report data by subsidiary.
-
Make a selection to display data for a different subsidiary.
By default, the report displays data for the top-level, or root-parent, subsidiary.
-
Select an option appended with (Consolidated) to display data for all child subsidiaries of the consolidated parent subsidiary.
After you have selected a subsidiary context, this selection is maintained each time you rerun the report, until you change the subsidiary context again.
-
-
If you use the Multi-Book Accounting feature, make a selection in the Accounting Book field.
-
Click Refresh to apply your selections and reload the report.
The Stock Ledger report can also be customized. For example, your account includes many combinations of items and locations. You can customize the report to filter the results and reduce the time required to generate the report. For details, read Report Customization.
Data is displayed using the following columns:
-
Location
-
Description
-
Class
-
Department
-
Subsidiary
-
Beginning Inv Qty On-Hand – Inventory quantity as of the From date
-
Beginning Average Cost – Average cost calculated as (Beginning Inv On-Hand Value / Beginning Inv Qty On-Hand).
This calculated average can be different from the item cost recorded for the item. The cost displayed is determined by the period dates specified and can change across the time horizon. NetSuite provides an average cost for a point of reference.
Note:If the item uses Group Average costing, note the following. The As Of date on at least one Balance Location Costing Groups Accounts bulk process must equal the From date of the Stock Ledger. This is to ensure the location account values to be accurate for the report. For details about the Balance Location Costing Groups Accounts bulk process, read Balance Location Costing Group Accounts.
-
Beginning Inv On-Hand Value – Inventory Asset Account balance as of the From date
-
Receipts – Sum of quantities on item receipts, standalone bills, assembly builds, and work order completions between the From date and To date. This value represents all inputs received into inventory.
-
Other Inv Inputs – Sum of quantities on customer returns, positive inventory adjustments, positive inventory transfers, and positive inventory worksheet adjustments between the From date and To date. This value represents all non-receipt inputs that added inventory.
-
Total Input Quantity – Sum of Receipts quantity and Other Inv Inputs quantity
-
Value of Inputs – Sum value of inventory account transactions associated with the Total Input Quantity
-
Last Receipt Date – Date of the most current receipt transaction between the From date and To date. This is the date of the most recent receipt input. If the most recent receipt is outside the selected period, the column is blank.
Assessing this date can help you determine how active an item is for the duration of the selected time period.
-
Sales – Sum of quantities of cash sales, standalone invoices, and item fulfillments between the From date and To date. This value represents all sale outputs from inventory.
-
Other Inv Outputs – Sum of quantities of assembly unbuilds, work order issues, negative inventory adjustments, negative inventory transfers, and negative inventory worksheet adjustments. This sum is between the From date and To date. This value represents all non-sale outputs from inventory.
-
Total Output Quantity – Sum of Sales and Other Inv Outputs quantities
-
Value of Outputs – Sum of inventory account transactions associated with the Total Output Quantity
-
Last Sales Date – Date of the most current sales transaction between the From date and To date. This is the date of the most recent sale output. If the most recent sale is outside the selected period, the column is blank.
Assessing this date can help you determine how active the item is for the duration of the selected period.
-
Ending Inv Qty On-Hand – The total ending quantity calculated as [Beginning Inventory Quantity On Hand + (Total Input Quantity – Total Output Quantity)].
-
Ending Average Cost – The total ending average cost calculated as (Ending Inv On-Hand Value / Ending Inv Qty On-Hand).
Note:If the item uses Group Average costing, note the following. The As Of date on at least one Balance Location Costing Groups Accounts bulk process must equal the From date of the Stock Ledger. This is to ensure the location account values to be accurate for the report. For details about the Balance Location Costing Groups Accounts bulk process, read Balance Location Costing Group Accounts.
-
Ending Inv On-Hand Value – The total ending average value calculated as [Beginning Inv On-Hand Value + (Value of Inputs – Value of Outputs)] .