Ramu Komireddy_9891 · Senior Oracle Netsuite Functional Consultant · Bronze Trophy

If this insight helps you please accept my answer.

Hi @User_CN4QU Even though you have successfully reversed the GL impact and changed the Asset Status back to Depreciating, the Asset Summary Report in the FAM module doesn't just look at the current status or the GL. The report relies on the background FAM tables—specifically the FAM - Depreciation History records and the…

Hi @Wishal44 When you use a Standard Frequency schedule (like Monthly or Annually) on a $0 Sales Order line, NetSuite's engine calculates the billing mathematically: (Total Line Amount / Number of Periods). Because the engine recognizes that a period needs to be billed, it pushes the line to the "Next Bill" queue,…

Hi @Audrey G. NetSuite has a system-generated, native Retained Earnings account (Account Type = Retained Earnings). In NetSuite's architecture, this specific system account is the hardcoded final destination for rolling over Net Income at year-end. You cannot substitute a custom Equity account to replace the native…

Hi @User_JKLFU can you please check the below points, Since you have already verified that Enable Mobile Printing is checked globally, the foundation is correctly laid. However, NetSuite WMS requires a few additional interconnected records to be set up before it will actually display the "Print Label" button on a specific…

Hi @Mariela S. As of March 2026, the new NetSuite Connector for Outlook is finally officially available and can now be downloaded directly from the Microsoft Marketplace / AppSource Availability & Rollout Details: Where to find it: You can search for "NetSuite Connector for Outlook" in the Microsoft AppSource/Marketplace.…

Hi @User_CN4QU If you are using NetSuite OneWorld and your COP subsidiary rolls up to a parent subsidiary that uses USD as its base currency, you can easily view the standalone COP financials translated into USD: Open your standard Profit and Loss report. At the bottom of the screen, change the Subsidiary Context to…

Hi @User_1L16T The reason you are only seeing 2 GL impact lines depends entirely on whether you are entering an AR Customer Invoice (Sale) or an AP Vendor Bill (Purchase). Here is what you need to know and the exact setups required: Scenario 1: You are entering an AR Customer Invoice (Sales) If this is a sales transaction…

B. transaction_lines.item_id = items.item_id

Hi @User_1L16T In NetSuite’s tax engine, if a Tax Group's net rate is 0% (e.g., +20% and -20%), the system calculates a net tax amount of 0. Because the calculated tax is 0, NetSuite optimizes the transaction by assuming no tax is owed and completely skips posting any tax lines to the General Ledger. To get your expected 2…

Hi @nsteresa For POs that are approved and waiting to be received: Look for Purchase Order : Pending Receipt in the Status filter.

Hi @Elizabeth Vance Here is the step-by-step guide to building this search: Step 1: Create the Search Go to Reports > Saved Searches > All Saved Searches > New. Select Transaction as the search type. Step 2: Set the Criteria You want to isolate the exact line items that are debiting your Work In Process (WIP) account for…

Hi @User_JKLFU If mobile printing is not enabled at the application level, the print elements will not render on any WMS pages. Navigate to Setup > Custom > Mobile Applications (or go to your SCM Mobile App Settings). View your primary mobile application (e.g., SCM Mobile or WMS). Ensure that the Enable Mobile…

Hi @User_CGU6V Set Defaults on the Vendor Record If the majority of bills for a specific vendor always go to the same expense account, you can set this to default natively, completely bypassing the need for Bill Capture to "guess" or learn it. For Expense Accounts: Go to the Vendor Record -> Financial subtab -> Account…

Hi @Brad R In NetSuite, standard functionality explicitly allows you to link Cash Sales to a Support Case, along with Sales Orders, Invoices, Purchase Orders, Estimates, and a few others. If you are only seeing Sales Orders and Invoices when you click "Search Transaction" on a Case record, it is almost certainly due to…

Hi @Roger Medina - EPM4NS Implementing NetSuite Planning and Budgeting (NSPB) — which is built on the robust Oracle EPM (Enterprise Performance Management) architecture — is a massive step up from managing FP&A in Excel. For a retail organization with an "IKEA-style" model (which implies large-format stores, diverse…

Hi @Elina Kourouzidou Do you want any document for entire data migration process for 5 yrs?

Hi @Bill Quinn standard/item cost on RMA item receipts posts to the Customer Return Variance Account (replacing COGS), not just the variance. The field acts as a dedicated COGS replacement for returns, posting the entire cost (e.g., standard cost) against Inventory Asset debit.​ GL example: Dr. Inventory Asset $X (cost),…

Hi @Elina Kourouzidou the ultimate workaround is to stop NetSuite from generating "floating" backorders in the first place. If you fix the data entry at the source, your standard Current Inventory Snapshot report will work perfectly with the Back Ordered column added. You can easily force users to select a Location on…

A Period Offset

Hi @Elina Kourouzidou Here is exactly why this is happening: 1. The "Inventory Back Ordered Report" (Transaction-Based) This standard report is driven by Transactions (the Sales Orders themselves). It essentially asks the system: "Show me all approved Sales Order lines where the quantity is greater than what has been…

Hi @Angel mariya T. P. if you satisfied with my insights, please accept my answer.

Hi @Elina Kourouzidou if you satisfied with my insight, can you please accept my answer.

Hi @Bill Quinn if you satisfied with my insight, can you please accept my answer.

Yes

Hi @Kedalene Here is the step-by-step guide to building this Saved Search: Step 1: Create a New System Note Search Navigate to Reports > Saved Searches > All Saved Searches > New (Administrator role required). Scroll down the list of record types and select System Note. Step 2: Define the Criteria Under the Criteria tab…

Hi @Elina Kourouzidou Based on standard NetSuite functionality, there is no out-of-the-box workaround to dynamically generate and attach related records (like Customer Statements or Payment Receipts) directly from the standard Invoice Email UI without first saving them to the File Cabinet. The standard "Email" button…

Hi @Elina Kourouzidou This insight for data migration of 5years data will help you! Migrating five years of historical transactional data (2021–2026) from one NetSuite environment to another—especially with Multi-Book and Multi-Currency enabled—is one of the most complex ERP projects you can undertake. Because of…

Hi @Elina Kourouzidou if you are satisfied with my insight, please accept my answer.

Hi @Wishal44 What is "Location Default Cost" (item.locationcost)? In NetSuite, when you have Multi-Location Inventory and Per-Location Costing enabled, the cost of an item can vary depending on which warehouse/location it is in. The Location Default Cost is a specific, manually entered field found on the Item Record (under…