Tigran Shahnazaryan · CEO @ Novelance · Silver Crown

NetSuite is an excellent system. Still, it can't do everything, and you sometimes need to integrate it with specialized 3rd party solutions. The right Integration Partner will make things easier!

The fields under the "Landed Cost" tab aren't accessible by Workflows. You would need a script to access those fields and to generate an "Error Message" if the amount isn't > $0.

Hey @Eunice_Rep, You should be able to get that if you create a "Vendor" Saved Search and display "Purchase Orders" via Transaction Join. You can't get that with the Transaction Saved Search, as the "Default Shipping Address" isn't on the Vendor Record, and the Saved Search can't access a 2nd level Join (Address…

Hey @Christine Gossman, The "End By" is used to specify when you want the scheduled emails to end. What is the "specific day each month"? You might be able to achieve that via Criteria + Daily Scheduled Emails. With the criteria, the Search would have results only on the required "day of the month", and then it will be…

Hey @ojn, Only the NetSuite Product Team knows why those tables are hidden from the Saved Searches. Most probably, the reason is technical (e.g., the way the table is structured in the back end prevents it from being accessed via Saved Search) We can't enable those tables to be available on Saved Searches. You should be…

Hey @User_S6FVQ, Do you enter the Landed Costs on Item Receipt lines or the header?

Hey @User_JQKEW, The "Marketing Automation" functionality in NetSuite isn't very robust. For example, you can't display campaign history from multiple contacts in the prospect campaign history tab. If you want to have more advanced Marketing Automation insights in NetSuite, I recommend using tools such as Mailchimp or…

Hey @Pallavi1903, You can do that via Mass Delete Script. Here are the steps on how to do that: https://suiteanswers.custhelp.com/app/answers/detail/a_id/79526/loc/en_US

Hey, I noticed you didn't check the "Perform Item Commitment After Transaction Entry" checkbox. Yes, without checking it, all commitments will be manual. If you want the commitments to be automated for SOs, WOs, TOs, and other transactions, check the "Perform Item Commitment After Transaction Entry" checkbox.

Thank you, Team!

Thanks. In the "Filter" section, replace the "Internal ID" with "Item : Internal ID" and see if it works.

Hey @Brian Finlay, Perhaps the easiest way is to do that via Saved Search as a Workflow action criterion. In the Saved Search, you can have something like: Formula (Numeric): Case When {today} - {Date 1} < 0 AND {today} - {Date 2} < 0 THEN 1 ELSE 0 END → (Equal to 0).

Hey @Martha Hakes, Can you share the screenshot of the Saved Search's Filter tab? The issue might be there.

Hey @User_8MM9H, It is not available natively. There is a solution called Netwrix (formerly Strongpoint) that does that. This solution regularly scans all of the metadata and XMLs related to Custom Objects and makes them reportable.

The issue you have might be caused by Open Waves linked to the orders. I assume you won't have this issue if you create test Work Orders with other items. If the issue isn't the Open Waves, then I would recommend contacting NetSuite Support and ask them to investigate.

Typically, the "Mine" parameter works, and I am unsure why it doesn't this time. Maybe there is a limitation regarding the Groups. Yes - the "Enhanced File Security" works only when the files are attached from the line. The main objective of this feature is to use it with the NetSuite Mobile App. When you take photos and…

If you find another way to do that, let me know.

Thanks for the clarification. No, that pop-up can't be customized to include additional fields as a look-up. You would need a custom field and some customization to show the required field in the pop-up. Alternatively, you can add the required fields to the Transaction, so you can see the values right after adding the item…

Did you make many changes to the custom field? Sometimes, NetSuite fails to update the changes, so a new field needs to be created. I replicated this in my Sandbox and set it to show two items, 400109 and 420168. With the above formula, each Sales Order correctly displays the relevant items: Sales Order 1 Sales Order 2

Hey @Febin Antony, You can do it via Saved Search, although you need some advanced formulas. Here is an example of such a report and a formula I used to give you an idea on how you need to do that: SUM(CASE WHEN ((to_char(to_date({trandate}),'MM')) = '12') AND (to_char(to_date({trandate}),'YYYY')) = '2024' THEN (({amount}…

Hey @SWSearcy, You should be able to do that via Workflow and using "Before Record Load" + "Set Field Display Type" = "Hidden"

Thanks for the update. In the results, can you try: Formula (Text) → Maximum and use this formula? REPLACE(NS_CONCAT(DISTINCT({item})),',',', ')

Hey @Martha Hakes, No, you need a script for that. The script will trigger on the native button press, open a pop-up to enter the mandatory information, and update the Sales Order on "Submit" (i.e., the Cancel might be clicked when the SO is in "View" mode).

Thanks. This might be happening because there can theoretically be multiple items that match the criteria. Or, the "Maximum" shows an empty value because of a "Tax Line" or something else. Can you check if the "Minimum" or "Group" produce any results? You can also have a temporary criteria that is filtered to, say, Line 2…

Hey @Julien Mi Electronics, When you search for the item using "%", doesn't it give you the required results? Here are the Preferences that impact the display of drop-down lists:

Hey @User_KAGURA, This might be related to the configuration or preferences related to the commitments. What is the configuration for item commitments? Also, are you using the Supply Allocation feature?

Hey @User_BD08X, If this is for Expense Reports, an "Enhanced File Security" preference automatically restricts folders to Expense Report employees. Otherwise, creating Groups for each employee and setting the "Restrict by Group" would be the primary option.

Is your search running on Main Line = True or Fales? If you could send screenshots of the Criteria, Results, and Filters, that would help with troubleshooting.

Hey @Andrea Barattini, NetSuite's current functionality doesn't prevent edits to "new Sales Orders only" when the Customer is On Hold. The only workaround is to remove On Hold, make the updates, and set the On Hold again.

Hey @Buckeye1497, Do you know if the "Item Status" is a native or custom field? In the Saved Search, there should be an "Inventory Location" join that might have the field you are looking for.