Ramu Komireddy_9891 · Senior Oracle Netsuite Functional Consultant · Silver Medal

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…

@Elina Kourouzidou you are absolutely on the right track with the underlying logic! If NetSuite doesn't know where an inventory action is taking place, it cannot update the location-specific inventory reports.

Edit the Purchase Order (PO490). Go to the item line and scroll to the right. Select the matching Target Subsidiary Select the matching Target Location Save the Purchase Order. Refresh your Current Inventory Snapshot report. You should now see the 1,440 accurately reflected in the On Order column.

Hi @Elina Kourouzidou When this feature is active, NetSuite stops using the standard line LOCATION to calculate the "On Order" bucket. Instead, it relies strictly on the TARGET SUBSIDIARY and TARGET LOCATION fields to know where the inventory is ultimately destined. Because those fields are empty, the system doesn't know…

Even that will also works…!

Hi @Angel mariya T. P. Background Processes: Matrix option expansions (adding children) are handled by NetSuite's internal single-purpose processes that bypass standard script triggers. Use a Scheduled Script or Workflow instead for post-creation updates.

Hi @Elina Kourouzidou In your NetSuite account has the Centralized Purchasing and Billing (or Cross-Subsidiary Fulfillment) feature enabled?

Hi @Wishal44 A Standalone Invoice is created entirely from scratch (not generated from the SO, and not copied from a linked invoice). Because it lacks the internal system link to the Sales Order, it does not update the SO's billed quantity, nor does it interact with the Billing Schedule. It serves purely as a financial…

On the far left of that sublist, there is an Edit link next to each Invoice line (e.g., next to Invoice #INVAU000689). Click that Edit link. This will open the underlying custom record for that specific line (called the Rebate Transaction Detail or RTD). On that record, you will see the blank Achieved Rebate Amount field.…

Hi @Paul Reading Edit your Custom Entry Form. Find the Maximum Quantity field (the row directly above) and check the SHOW box to temporarily make it visible. This should "un-lock" the row for Enforce Minimum Quantity Internally. On the Enforce Minimum Quantity Internally row, uncheck the SAME ROW AS PREVIOUS box. You…