Viewing Inventory Reports
You can use NetSuite reports to determine what has caused an inventory costing problem.
Inventory Valuation - This report lists 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 not entered, profitability calculations are not correct. You can use this report to identify the problem.
Cost of Goods Sold Register - A Cost of Goods Sold (COGS) account register lists item costs posted by transactions you enter. Each cost that posts is an expense incurred for purchasing 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, you can 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