. I'm not very familiar with inventory management in NetSuite as my specialty is more in services, but I have a question related to inventory. In my GL, my inventory account shows a value of $1,375,000. I confirmed this with a saved search, getting the same result. However, the amount doesn't match in an inventory valuation report custom without filter Normally inventory valuation = amount of stock in GL no? How is this discrepancy possible? Does NetSuite dynamically calculate an average cost based on my inventory costing method? And not in GL ? Not make sens for me we also have a problem generating an inventory valuation report it crashes every time even in schedule

Check if you have any Journal Entries posted on Inventory Account

Not just Journals but anything that posts directly to the inventory GL account without using an inventory item like Credit Card Charge (Expenses sublist), Credit Card Refund (Expenses sublist), Check (Expenses sublist), Bill (Expenses) Bill Credit (Expenses), Deposit, Expense Report, etc.

Thanks for yours answers

@Marc - For sure check JEs on the Inventory GL accounts as that is always one of the first things I check. You can create a transaction search and filter the criteria on the Inventory accounts and then like @Luis said you would filter = True all the different Non-Inventory item types and see what was posted to their. I would also review ALL the posting account you have setup starting with the Company Default postings and then the Item record. Since you are using Average Cost it is crucial to update the Transfer Order setting to use Average Cost for the transfer of your inventory or else you are going to have some major issues.

Hey I compared a saved search with the transactions that impact my stock account and the valuation report. I don't understand why transactions like bill credit don't show up on my inventory valuation report. Yet this is an item that is used.

@Marc - So normally your Vendor Credit would be the child record to the record: Vendor Return Authorization. You would create the VRA from the PO# line(s), then the Shipping/Receiving Dept. would create an IF to ship goods back to Vendor, and then the Vendor would issue a Credit Memo once the goods were received. Therefore, your Vendor Credit record is not affecting your inventory movement it would be the Item Fulfillment that you returned/shipped the goods back on. Vendor Return Authorization (RMA) > Item Fulfillment > Vendor Credit