Viewing Inventory Reports
You can use NetSuite reports to find out what caused an inventory costing problem. The Inventory Valuation report shows the on-hand quantity and total value of each inventory item.
To view the item Inventory Evaluation report:
-
Go to Reports > Inventory/Items > Inventory Valuation..
-
To identify a problem transaction and correct it, click the on-hand quantity.
-
On the Detail page, select a date range to display costing calculations for transactions during that period.
For example, an inventory adjustment might be recorded with zero cost. Because the item cost is missing, profitability calculations may be incorrect. You can use this report to identify the problem.
The Cost of Goods Sold (COGS) Register lists item costs posted by transactions you enter. Each cost that posts is an expense for buying the items you sell. You can use the COGS account register to find transactions that affect your COGS account. For example, if you know the date of an incorrect COGS posting, open the COGS register to find the transaction.
To see the COGS register:
-
Go to Lists > Accounting > Accounts.
-
In the Account column, click name of the COGS account you want to see.
The report may take a few minutes to load.
Related Topics
- Setting Inventory Costing Preferences
- Costing Methods
- Selecting a Default Cost of Goods Sold (COGS) Account
- Inventory Costing and Assembly Items
- LIFO/FIFO Inventory Costing and Advanced Receiving
- System Cost of Goods Sold Adjustments
- Inventory Costing Recalculations
- Troubleshoot Inventory Costing
- Cost Accounting Status on Item Records
- Item Return Costing
- Group Average Costing
- Standard Costing
- Item Costing