Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hey @Gavrah Rabba, Natively, NetSuite can't do that. You can achieve that via customization.

Hey @skenyon, You should be able to get it via "System Notes v2" that you can build via Analytics Workbook https://suiteanswers.custhelp.com/app/answers/detail/a_id/1011816/loc/en_US

Hey @Rhys Gottwald, Can you confirm that "Location" isn't mandatory? Yes, you can customize the mobile app to remove Page Elements (e.g., Location). Here is the guide with details: https://suiteanswers.custhelp.com/app/answers/detail/a_id/102936/loc/en_US

Hey @User_BQX47, Did you try this approach? https://suiteanswers.custhelp.com/app/answers/detail/a_id/79424/loc/en_US

Hey @User_WA9MO, You can certainly have something in the name (e.g., FG or $0) to identify Free Goods. The best, however, would be to create a custom checkbox on the Item Record (e.g., called Free Goods) to make it easier to report which Items are free. Also, with the checkbox, you can display it on the Sales Order and…

Hey @User_1W277, That's an area that isn't well documented by NetSuite. The best option would be to create a support case and request help. You can also advise them to create a SuiteAnswers Article or official documentation with the missing information.

Hey @KNason76, Try the following: Formula (text): REGEXP_REPLACE({your_field_id},'1|2|3|4|5|6|7|8|9|0', '')

Hey @Honey Soe, When the cost is known at the time of Item Fulfillment, NetSuite may generate a Cost of Sales adjustment, if applicable. Because the cost wasn't recorded at the time of Item Fulfillment, NetSuite didn't have a need to post a Cost of Sales adjustment. Many NetSuite processes rely on transaction dates, and…

Hey @User_LBSJG, Are you not seeing GL Accounts when creating Journal Entries? Please provide more details/screenshots to help with troubleshooting.

Hey @Shuja Zaka, At a minimum, you need to have the standard Manufacturing Module to create and process Work Orders.

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}…