Tigran Shahnazaryan · CEO @ Novelance · Silver Crown

I can't provide sample codes as multiple variables would impact this customization. The best option is to work with a qualified NetSuite Consultant to build the necessary customization.

Say, you have Sales Rep 1, Sales Rep 2 and Sales Rep 3 on the record and you want to only make updates to Sales Rep 1 and Sales Rep 2. On the import template, you should have the corrected Sales Rep 1 and Sales Rep 2 + Sales Rep 3.

Hey @User_FP7X9, Did you try using the "Invoice Sales Orders" or the "Invoice Customers" processes? Those should always show the correct invoices that are eligible for invoicing.

Hey @Bee Yook, A Journal (or any record) can be created in NetSuite via integration in a few ways. The "HR Company Consultant" might not know how to do it as there is no "preferred method" of creating Journals. Often, it depends on whether the integration is direct or via iPaaS (e.g., Boomi), the authentication…

Hey @Siva Padidam, There are a few ways you can do that. Building a UE script is one option. You can also create two Vendor Forms and switch them via Workflow depending on the User/Role. One of the Vendor Forms can have a "view only" custom "Bank Details" sublist.

Hey @Jeanine 2022, I have used CSV import in the past to do that. You can refer to SuiteAnswer 33849 for additional guidance.

Hey @user1945860, Can you confirm the items that you shipped aren't Non-inventory? If you fulfill a Non-inventory Item, there won't be any GL impact on the Item Fulfillment. Another reason could be if the Item Fulfillment was created from a drop-ship order.

Hey Rhys, You can do that by customizing the mobile app and creating a custom Location field where you can control the visibility of required locations more granularly. Selecting the Location in the custom field will select the related Location in the native field in the background (the native field will be hidden).

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).