NSC | How to Create a Report or Saved Search of Transactions Affecting the Average Cost of an Item

Joy Noreen Magoling-Oracle

Scenario: There are instances when users  need to create a report or saved search to show any transactions that affect the average cost of an item.

Solution: NetSuite has a standard report, Inventory Valuation Detail Report, which shows the transactions affecting the value of the inventory. This lists transactions that affect inventory assets and may be useful for troubleshooting costing problems. To generate this report, navigate to Reports > Inventory/Items > Inventory Valuation > Detail.

Another option would be to create a Saved Search to show the affecting transactions. Let's say, for example, users need to identify those transactions which have 0 value and causes the average cost of the items to be incorrect. To do this,

1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Click Transaction
3. Search Title: Enter Title
4. Click Criteria 
5. Click Standard

Filter:

Note: Always click Add once Filter is selected and adjusted.

•  Select Type

Description: Select Assembly Build, Assembly Unbuild, Credit Memo, Inventory Adjustment, Inventory Worksheet, Item Fulfillment, Item Receipt

Note: You may add or remove transaction type as necessary.

• Select Main Line

  • Description: Select No

• Select Rate

  • Description: Select Equal To
  • Value: Enter 0.00

• Select Formula (Numeric)

  • Formula: Enter case when {quantity} > 0 then 1 else 0 end
  • Value: Enter 1

6. Click Results

7. Click Columns

8. Click Remove All

9. Add the following fields:

Note: Fields may be removed or added as necessary.

10. Click Save & Run