Problem Clients often ask why a field (e.g., Custom Customer Field) appears in a Saved Search but not in a Standard Report. Cause Standard Reports use predefined datasets, while Saved Searches directly query record fields. Custom fields don’t always roll up into Reports. Solution Export the Saved Search to Excel. Use SuiteAnalytics Workbook to build… Continue reading Custom Report Missing Fields Available in Saved Search
Author: Sherin Jose
Financial Report Totals Do Not Match Saved Search Results
Issue/Problem Statement: Users noticed that the totals in the Income Statement report do not match the results generated from a Transaction Saved Search built on the same criteria. This discrepancy is creating confusion during financial reconciliation and month-end closing. Symptoms: Report shows higher or lower revenue totals compared to a saved search. Transactions visible in… Continue reading Financial Report Totals Do Not Match Saved Search Results
COA File Analysis in NetSuite (with Intercompany Transaction Considerations)
In a NetSuite OneWorld environment, the design and configuration of the Chart of Accounts (COA) directly impacts how transactions—including intercompany transactions (ICTs)—are processed and reported. A properly structured COA is essential to ensure that all subsidiaries can operate independently while still allowing for unified, consolidated financial reporting. 🔹 1. Understanding the Role of a Common… Continue reading COA File Analysis in NetSuite (with Intercompany Transaction Considerations)
Advanced Revenue Management (ARM) Process in projects
The Advanced Revenue Management (ARM) process in NetSuite is designed to automate and accurately manage revenue recognition in compliance with global accounting standards such as ASC 606 and IFRS 15. The ARM process begins with the configuration of service or product items in NetSuite, each linked to appropriate Revenue Recognition Rules that define when and… Continue reading Advanced Revenue Management (ARM) Process in projects
Inventory Out-of-Balance Across Locations
Problem: Inventory quantities show correctly at the item level, but detailed reports reveal inconsistent totals across locations. Cause: Transfer Orders were created but not received at the destination. Item Fulfillments were backdated before items were received into stock. Solution: Review pending Transfer Orders under Transactions > Inventory > Receive Transfer Orders. Identify and complete any… Continue reading Inventory Out-of-Balance Across Locations
Inventory Valuation Report Includes In-Transit Goods
Inventory valuation report totals include items not yet received physically at the warehouse. Root Cause: Items marked as “Shipped” from vendors are recorded via Item Receipt but not yet physically in stock. This is due to automated PO processing or drop-ship processes. Resolution Steps: Use Inventory Status or custom transaction saved searches to separate in-transit… Continue reading Inventory Valuation Report Includes In-Transit Goods
Consolidated Financial Report Omits Intercompany Eliminations
Business Context: A consolidated Balance Sheet report shows inflated receivables and payables between subsidiaries. Root Cause: Intercompany transactions (IC Sales/Purchases, Loans, etc.) are not being offset by elimination journal entries. Resolution Steps: Set up and review Elimination Subsidiary. Ensure elimination schedules are configured and run properly. Verify intercompany accounts are correctly mapped. Check that report… Continue reading Consolidated Financial Report Omits Intercompany Eliminations
Income Statement Includes Prior Period Adjustments in Current Period
Current period’s Income Statement unexpectedly includes transactions from prior periods. Root Cause: Backdated journal entries or adjustments were created and posted to a closed period, which NetSuite rolls forward into the next open period unless historical period adjustments are blocked. Resolution Steps: Identify and isolate backdated entries using GL Detail report. Configure Accounting Preferences to… Continue reading Income Statement Includes Prior Period Adjustments in Current Period
NetSuite Saved Search Formulas – Using Date in Saved Search Formulas
NetSuite Saved Searches are a data query tool that can have many advanced search filters and results display options. Searches can be saved and run on-demand in NetSuite to extract the latest information. NetSuite saved search results provide reporting and data tracking capabilities that can be used to analyze any type of information in NetSuite… Continue reading NetSuite Saved Search Formulas – Using Date in Saved Search Formulas
Inaccurate Inventory Tracking Across Multiple Locations
Solution in NetSuite: Real-Time Inventory Management: Use NetSuite’s Inventory Management module to track stock levels across all locations in real time. Enable the “Multi-Location Inventory” feature by navigating to Setup > Company > Enable Features > Items & Inventory and checking “Multi-Location Inventory.” Automated Replenishment: Set up demand-based replenishment rules under Lists > Supply Chain… Continue reading Inaccurate Inventory Tracking Across Multiple Locations