My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Comments
-
Hi @Honey Soe, Why it’s greyed out: in NetSuite, Inventory Detail on a Sales Order only works for lot- or serial-numbered items, and only with Advanced Bin / Numbered Inventory Management enabled. It is also disabled when the line has no Location, or when the item or location isn’t set to Use Bins. Bin assignment on the…
-
Thanks, that makes it simpler. With one item per invoice, the item lines up with the whole invoice, so you can use the invoice’s open balance directly. In the bucket formulas, replace {amount} with {amountremaining}: Current: CASE WHEN {today} - {duedate} <= 0 THEN {amountremaining} ELSE 0 END 1–30: CASE WHEN {today} -…
-
HI , Use a transaction saved search on Item Receipts, with one formula that flags any line where a document is required but not received. Criteria: Type = Item Receipt Main Line = False Formula (Numeric) is equal to 1: CASE WHEN ({custcol_coc_required} = 'T' AND {custcol_coc_received} = 'F') OR…
-
Hi @TEN , Thanks for sharing. The error is clear: rows 3, 4 and 5 of the file have no amount in column 5, the transaction amount. Each bank line needs an amount. This usually happens when: those rows are opening or closing balance or summary lines, not transactions, the bank file splits amounts into Debit and Credit…
-
Hi @TEN , You don’t need to delete failed imports. The Banking Import History page is a log, and failed entries stay there for reference. The popup is just telling you about them. What to do: See the error. Click the + next to each failed import (ID 153 and 49). The details show what went wrong, for example a wrong date…
-
Hi, The standard A/R Aging report works at the invoice level, so it can’t split balances by item. The open balance belongs to the whole invoice, not to each line. The usual approach is a transaction saved search. Criteria: Type = Invoice Status = Open Main Line = False Item = your two items (also exclude tax and shipping…
-
Hi @Bee Yook, For van sales, a DSD (direct store delivery) SuiteApp is usually the best approach. NetSuite’s own POS (SuiteCommerce InStore) is built for fixed stores and isn’t a good fit for vans. setup: Each van as a NetSuite location. Load stock with transfer orders from the warehouse to the van, so van inventory is…
-
Hi @User_C3DOL, Since nothing changed on your side and manual waves still work, the mobile app is probably sending a “Released” status that NetSuite no longer accepts. Things to check: A recent upgrade. Check whether your account was just upgraded to 2026.2. If so, the WMS / SCM SuiteApp version may not match the new…
-
Hi @Mia Li, The Filter Site Option filters orders by website, not subsidiary, which is why “all” didn’t help. The limit is coming from one of two places. This test tells you which: Log in to the NetSuite Customer Center as that customer, outside the website, and open their transactions. If the other-subsidiary orders are…
-
Hi @user_5906, Your design is right. A few changes will make it reliable. 1. Keep the workflow running at Approved. The workflow instance must not end when the PO is approved, or edits won’t be caught. Make sure the Approved state has your transition back to Initiation, and that the workflow’s initiation includes Update…
-
Hi @User_QTJUL, The Labor Resources field on a routing operation is a single number, used for scheduling and capacity. NetSuite doesn’t split it into direct and indirect labor. Here are the usual ways to handle it: Separate them in costing. In the Manufacturing Cost Template assigned to the operation, add two cost lines…
-
Welcome! Here’s how to do it. Steps: go to Setup > Import/Export > Import CSV Records, then choose Import Type = Transactions and Record Type = Sales Order. Upload your file, map the fields, and run the import. Save the mapping so you can reuse it. 1 and 3. File format and multiple items: use one row per item line. Rows…
-
Hi @Ian Geertman, This error comes up for subsidiaries even after all dependent records are removed, so it’s usually something only NetSuite Support can fix on their side. Since the parent can’t be changed, I’d do this: Raise a case with NetSuite Support and include the ticket ID from the error (mw26ceu21kycrijp26glk). Ask…
-
Hi User_8DP9L, That’s expected behaviour. Saving the rebate transaction and its detail doesn’t create the accrual record. It’s created when the accrual process runs, which groups rebate transaction details by agreement, class, department, location and custom segment, and creates one accrual record per group. To get it…
-
Hi @Terry Callaghan, You’re not alone. Many “out of the box” accounts have scripts added during implementation or installed with SuiteApps. Here’s how to find and sort them: List the scripts. Go to Customization > Scripting > Scripts and add the API Version column, or filter on it. Anything on 1.0 or 2.0 needs attention.…
-
Hi Tom, With Main Line = True, the search only returns the order header, which has no item data. Switch it so you get exactly one line per order, the first one: On the Criteria tab: Main Line = false Line Sequence Number = 1, or use a Formula (Numeric) filter {linesequencenumber} equal to 1 On the Results tab, add Item…
-
Hi Ricard, Hi, here’s my understanding of how ARM handles this. 1. Is it supported? Not really. When an invoice is created from a sales order, ARM builds the revenue element from the sales order line, so the revenue dates come from that line. Copied invoices stay linked to the same line, so they bill against that one…
-
True
-
You’re welcome! 😊 Glad it helped.
-
Hi Kedalene, For a 1-cent overpayment, the simplest options are: Apply it to the next open invoice (recommended). On the same payment, tick invoice 2026000436 and enter 0.01 in its Payment column. The payment is fully applied, with no extra transactions. Leave it as unapplied credit. Save the payment with 0.01 unapplied,…
-
Hi T. Crocco, Here are some things to check, most likely first: Mobile Device Access permission. The NetSuite mobile app only works with roles that have this permission. Open the custom role (Setup > Users/Roles > Manage Roles), check that it’s still there, and add it if not. Login Audit Trail. Go to Setup > Users/Roles >…
-
You’re welcome! If this answered your question, please mark it as the accepted answer so others can find it. Good luck with the migration.
-
Hi Georgiev Nikolay, You can’t leave it on 2.x long term. Oracle lists @NApiVersion 2 .0 and 2.x as legacy annotation values, and support for them is expected to be removed in 2028.2. In 2028.1 those scripts start running as 2.1, and in 2028.2 the annotation itself is expected to stop working. Two more reasons to change it…
-
Your Welcome @Zeen
-
HI @Zeen The standard Trial Balance shows balances as of one period, so you need to customize the columns. On the report, click Customize, then Edit Columns. Select the middle Debit and Credit columns. Change their period to a range of Jul 2026 to Sep 2026. If your fiscal quarter is Jul–Sep, use “This Fiscal Quarter”.…
-
Hi User_QTJUL, If the failing URL has no cf=, the menu isn’t pointing to an old form, so you can ignore my earlier suggestion. NetSuite is trying to pick your default Transfer Order form and isn’t finding one it considers available. Two more things to check: Another preferred form. Filter Transaction Forms on Transfer…
-
HI User_ZWVM0, The record has a formula that divides by a field. On a few items that field is 0 or blank, probably because the REST import didn’t send it, and dividing by zero causes the error. Viewing a record calculates formula fields and saved-search sublists. Editing often doesn’t, so only view fails. To fix it: Find…
-
Hi @leannekane, As far as I know, there’s no way to turn it on. “Use Nexus Currency” only works for some reports, and BAS doesn’t seem to be one of them. Workarounds: If the Australian transactions are in AUD, build a saved search showing the tax amounts in transaction currency. That gives you the BAS figures in AUD. Or…
-
NetSuite allows only one vendor code per vendor per subsidiary on an item, so there’s no native way to store two codes for the same vendor. The usual options: A custom record (best practice). Create a “Vendor Part Number” custom record with Item, Vendor, Vendor Part Number and optional notes or UOM fields. Make it a child…