Inventory Reporting
NetSuite reports are a powerful tool you can use to assess inventory at all stages of your inventory workflow.
You can view reports with inventory costs, stock levels, activity, valuation, revenue generated and profitability. Then, use the information from reports to identify successes and problems within each workflow process, as well as within the workflow as a whole.
For example, you can view reports that return this inventory data for the previous quarter:
-
inventory valuation rises each week
-
item sales revenue decreases each week
-
gross profitability of your top seller remains level
With this information, you can take action as necessary, changing processes that have created problems and maintaining processes that are successful:
-
High inventory values increase overhead and may cut your profitability.
You can investigate items that have a high percentage of total inventory value. Based on their costs and turnover rates, you may need to change your purchasing practices.
-
Sales revenue decreases can result from customer dissatisfaction caused by difficulties and delays during fulfillment.
You can investigate items that are frequently backordered and adjust their set reorder points and preferred stock levels.
-
A steady profitability on a popular item is a positive indication.
You can maintain the appropriate stock level and price point currently set on the item record. Because it is not problematic, you can focus your attention elsewhere.
When you can take action to make improvements as needed, you can execute more efficient management of your inventory.
It is important to track your inventory so you know what stock you have and what stock you need. Keeping the appropriate levels of stock on hand enables you to maintain a streamlined stock level, which results in reduced overhead. It also enables you to fulfill orders in a timely manner, which results in customer satisfaction.
You can use inventory reports to make regular assessments of stock quantities and identify your replenishment needs to maintain a streamlined inventory. You can also evaluate your overall inventory workflow.
First, determine the status of your inventory and identify your replenishment needs. Then, you can maintain optimum stock levels by purchasing or redistributing inventory as needed to maintain the ideal quantities.
You can use reports to assess your inventory and workflow. Reports can help you identify:
-
current stock status
-
items that are profitable or problematic
-
areas of the inventory workflow that are beneficial or detrimental
Then, you can respond to information in the reports by:
-
modifying replenishment to streamline stock levels
-
making changes to correct problems in the workflow
To view reports, go to the Reports tab. Inventory reports can be accessed under the Inventory/Items heading.
Links to all reports may not show on the Reports tab. The reports that are available depend on the role assigned to you. For example, an Administrator has access to more reports than a Sales Manager.
Reports can show current status of inventory items and backorders to help you find out what you need.
Inventory assessment can have two main goals: to determine your inventory level or to determine your inventory values. Assessing the level of your inventory tells you how much inventory you have. Assessing the value tells you how much your inventory is worth.
One report can help you make both assessments: Viewing the Stock Ledger.
Other inventory reports can be categorized by two main functions, inventory level assessment and inventory value assessment.
Inventory Levels
You can make an Inventory Level Assessments with Reports to determine if the quantities you are stocking on hand are the appropriate amounts.
-
The Viewing the Stock Ledger shows activity for items across a period. It is a tool for better understanding inventory SKU activity across classes, departments, and subsidiaries for multiple locations. For example, it can help identify inventory items that are slow-moving, fast-moving, or overstocked. It can help identify inventory investment strategies for planning.
-
The Physical Inventory Worksheet helps you take a physical count of your stock to be sure it matches the quantity in NetSuite.
-
Use the Current Inventory Snapshot Report to monitor inventory levels and determine ordering schedules. Determine a reorder point and preferred stock level, or identify overstocking on items.
-
The Inventory Back Order Report helps you find items that are committed on sales orders, but are not in stock. It also helps you analyze the replenishment process of your workflow. For items repeatedly on backorder, you may consider increasing the reorder point for that item.
-
The Inventory Activity Detail Report shows the quantity per transaction of inventory items. Use this report to identify trends in sales for items and make informed decisions about stocking your items.
-
Items that are pending fulfillment are committed to be sold, are in stock and are ready to ship to the customer. The Items Pending Fulfillment Report shows all open transaction lines on sales orders and can help you to process items to fulfill orders.
-
You need to know how quickly each product moves through inventory. It is not efficient to have large quantities of inventory sitting idle on your shelves. Inventory turnover measures item efficiency by examining how quickly you sell a product. The Inventory Turnover Report helps you assess stock level changes over time. This report lists the cost of sales, average value, turnover rate (or turn rate) and average days on hand for each inventory item.
Inventory Values
Inventory Value Assessments with Reports help you identify inventory value and profitability, as well as revenue generated by items.
-
The Viewing the Stock Ledger shows activity for items across a period. It is a tool for better understanding inventory SKU activity across classes, departments, and subsidiaries for multiple locations. For example, it can help identify inventory items that are slow-moving, fast-moving, or overstocked. It can help identify inventory investment strategies for planning.
-
The Inventory Profitability Report shows cost, revenue, and profitability information about your inventory. You can view this report to determine margins on your items and identify items that are most and least profitable. If you operate an online store with NetSuite, this report includes sales from your online store.
-
The Inventory Valuation Report summarizes the value of your inventory at a specific point in time. It can help you identify areas you can potentially use to streamline your inventory. For each inventory item, this report details item name, description, inventory value (in dollars), percentage of total inventory value and quantity on hand.
-
An Inventory Valuation Detail Report shows the transactions affecting the value of your inventory. This report is useful for troubleshooting costing problems with your items because it lists transactions that affect inventory assets.
-
An Inventory Revenue Report shows the total sales amounts for inventory items and overall revenue from your inventory items. You can identify an item that has low sales and is a poor contributor to your revenue total and may need to be discontinued. Pinpoint items with high sales and are good contributors to your revenue total to maintain the stock, marketing, and pricing of these items.
If you operate an online store with NetSuite, these reports include sales from your store.
-
An Inventory Revenue Detail Report shows the revenue generated by your inventory items for a particular period by sales transaction. Use this information to determine which items are successful items by finding items that generate high revenue and have a high gross profit percentage.
If you operate an online store with NetSuite, these reports include sales from your store.