Best Of
Re: Sandbox to Production
Hello,
I would also like to recommend that you consider leveraging SDF - SuiteCloud Development Framework projects to replicate custom objects from sandbox to sandbox and sandbox to production accounts.
You can reference the following SAs.
51669 - SuiteCloud Development Framework Tutorial
51622 - SuiteCloud Development Framework
Focus on the account customization project type.
Although this approach may seem daunting at first, I believe that you will find it quite efficient once you understand the solution and framework.
Best,
Todd Niedringhaus
Re: Unable to install bundle (537940) - Requires acceptance to Terms (TOS) but there is no accept button
Thank you Jervin,
In SB I still don't have the Installation Terms of Service Accept buttons, however I was able to install bundle 537941 (NetSuite Approvals Workflow). Per SuiteAnswers the 3-Way match is part of 537941.
I did not get the same error message when attempting to install 537941.
Customization/SuiteBundler/Search and Install Bundles
Possible anomaly?
Thank you for your response!
Regards,
Paula Courtemanche
Re: Enforce Minimum quantity Internally cannot be re-enabled?
- 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 should now be able to freely check or uncheck the SHOW box for the Enforce Minimum Quantity Internally field.
- Once you have it set to your liking, you can uncheck the SHOW box for Maximum Quantity again to hide it.
- Save the form.
Re: Is MFA really necessary for a community forum?
Hi @PaulFleetwood,
Good day!
Apologies if the Multi-Factor Authentication (MFA) is tedious but rest assured that our primary goal is to secure online accounts, sensitive data, and system from hackers by adding layers beyond just a password, stopping attackers who steal passwords via phishing or data breaches.
Again, apologies for the inconvenience on this.
Re: Update custom field on Matrix Item creation
NetSuite User Event (UE) scripts can trigger on matrix item records, but there are specific behaviors and potential pitfalls when creating or updating matrix parents and children. Matrix child creation often occurs as a background process during parent saves, which may not always reliably trigger UE scripts on the children.
Script Deployment Check
Deploy your UE script on the Inventory Item record type (internal ID: inventoryitem), as matrix items use this type for both parents (matrixtype: PARENT) and children (matrixtype: CHILD). Ensure the script is set to trigger on relevant events like beforeSubmit or afterSubmit for creates and updates—beforeLoad won't fire on new record creation.
Re: No GL Impact on Second Work Order Completion After Additional Work Order Issue (Average Costing) Qu
Hi @User_56FCN,
The behavior you are seeing is standard NetSuite behavior for Work Orders (WOs) using Average Costing and Work In Process (WIP). It is caused by how NetSuite reallocates costs across partial completions to ensure the total WIP is cleared correctly by the time the Work Order is closed.
- Why the 1st Completion Changed
- NetSuite uses a dynamic costing engine. When you created the 2nd Issue, the total cost pool for the Work Order changed. To maintain the "Average Cost" across the entire order, the system recalculated and updated the GL impact of the 1st Completion to reflect the new weighted average of all issued components.
- Why the 2nd Completion has no GL impact
- This happens when the 1st Completion already cleared the WIP balance available at that moment. If your Manufacturing Preferences are set to "Use Open WIP Amount," the system pulls all available WIP into the first completion it can. The GL impact for the 2nd unit often remains $0 until the Costing Engine finishes its background run or until the Work Order is Closed, which triggers the final "true-up."
- Allocation Logic
- In a WIP-enabled environment, NetSuite treats the Work Order as a single "bucket" for costs. When you issue components, their value is moved from Inventory to the WIP Asset account. When a completion is saved, NetSuite attempts to relieve that WIP bucket to value the finished assembly. Because you are using Average Costing the system doesn't "lock" the cost of the first unit; instead, it constantly re-averages the total cost of all issued components across all completed units. If you complete a unit before issuing all components, the system may pull the entire current WIP balance into that first unit. Once the remaining components are issued, the costing engine redistributes that total pool across both units, which updates the GL impact of the first completion and often leaves the second completion with a $0 impact until the final Work Order Close clears the remaining balance to a variance account.
Hope this helps!
Re: Close Requisition (Close button function)
In NetSuite, you are completely correct: there is no native, header-level "Close" button for Requisitions like there is for Purchase Orders. The standard native behavior is exactly what you described—you must edit the record, check the "Closed" box on the item lines, and save.
The reason your custom workflow "Close" button didn't work is due to a conflict with your validation workflow. If your validation workflow uses an action like Return User Error on Before Submit to prevent users from saving changes to an "Approved" requisition, it will also block your custom workflow from saving the record when it tries to automatically check those line-level boxes. Workflows trigger other workflows!
Here are the two best ways to solve this problem so you get a working "Close" button while keeping the record safe from manual edits.
Solution 1: Use a Hidden "Bypass" Checkbox
To make your Close workflow work, you need to tell your Validation workflow to "step aside" just for this specific action. You can do this by using a hidden checkbox.
Step 1: Create a custom checkbox
- Go to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
- Label it something like "Is Closing Requisition" (custbody_is_closing_req).
- Type: Check Box.
- Applies To: Requisition.
- Display Type: Hidden. Save it.
Step 2: Update your existing Validation Workflow
- Open your workflow that prevents edits on Approved requisitions.
- Find the Action that stops the edit (usually a Return User Error action).
- Edit that action and go to the Condition builder.
- Add a condition: Is Closing Requisition = False.
(This tells NetSuite: Prevent edits ONLY if the user isn't using our special Close button).
Step 3: Build your "Close Requisition" Workflow
- Create a new workflow for Requisitions.
- State 1: Add a New Action > Add Button. Label it "Close Requisition".
- Create a Transition from State 1 to State 2 that executes On Button Click (select your "Close Requisition" button).
- State 2: Add the following actions (Trigger On: Before Submit):
- Action 1 (Set Field Value): Set the hidden Is Closing Requisition field to Checked (True). (This bypasses your validation workflow).
- Action 2 (Sublist Action Group): Select the Item sublist.
- Inside the Sublist Action Group: Add a Set Field Value action. Choose the Closed field and set it to Checked (True).
- Action 3 (Go To Page): (Optional but recommended) Redirect the user back to the Requisition record so they see it is closed.
Thanks
Ramu
Re: How to Setup and Configure Workforce Planning in New NSPB
Hi Shelton, the Workforce Framework has not been yet being added to the Framework you are installing (last time I asked I was informed that maybe in Q1).
As we were having the same need as you, we got from NetSuite approval to download the Premium Suite Success Bundle, and we are working to integrate the Workforce rules and forms into our NSPB Financials so we can have the Workforce functionality adapted to our needs while it is officially added, but we are still in the process of making this work, as we are talking about integrating two different applications (the NSPB Suite Success and NSPB Financials).
This approach is not advisable if the Workforce "Framework" is soon to be launched, so better check with your NetSuite Account Manager.
If interested in knowing more about our approach, send me a DM.
Good luck.
Re: Community Articles: What Topic Would You Like to See Next?
SuiteAnalytics Datasets and Workbooks - common use-cases for roles and permissions, audit logs, transactions, and entities.
Re: Custom center tab
Not sure which Chevron you mean or which page you're looking at, sorry. Can you share a picture?
Otherwise, the way I would try to solve this is by editing the audience of the Center Tab.
Customization > Centers & Tabs > Center Tabs
Just make sure you're looking at the correct Center Tab as sometimes there are multiple named the same but for the different Center Types used by the Roles.
Dext3r








