My Stuff
Comments
-
For the HTML injection instructions earlier in this thread, we need a small adjustment. Since NetSuite keeps flip-flopping between the general and account-specific domains, you should use a relative reference to the bar code font. Instead of: '<style> @font-face { font-family: "Code39"; src:…
-
I see what happened. The new account-specific domains reverted overnight. Previously, our NetSuite URL was https://account.app.netsuite.com/. They went back to the old https://system.na2.netsuite.com/ URL. Since the new account-specific domain was referenced in my saved search, it no longer worked. I have updated the saved…
-
If you are using NetSuite Advanced Manufacturing, be careful with this. Advanced Manufacturing fails spectacularly when it encounters a BOM with phantoms (yeah, I know...how is that "Advanced"). To date, we have paid our integrators about $30k to write custom code to clean up the Advanced Manufacturing problem and allow us…
-
Check to see if their DKIM settings in NetSuite are correct. Go to Setup --> Company --> Email --> Email Preferences. Then, go to the Domain Keys tab. * If there is no DKIM entry, that's the place to start. * If there is a DKIM entry, test it. There's a button to do the test. E-mails that can be authenticated are…
-
I thought about this a bit more. There could be some scenarios where that suggestion doesn't work quite right. What if you run the search on September 30th? The result would jump back to July 30th (not July 31st). A more robust formula would be: LAST_DAY(ADD_MONTHS(TRUNC({today}, 'MONTH'), -2)) Hope I'm not too late!…
-
The -2 will only subtract 2 days. You'll want to incorporate the ADD_MONTHS() formula, something more like this: ADD_MONTHS(LAST_DAY(TRUNC({today}, 'MONTH')), -2) Also, if you are using LAST_DAY(), then the TRUNC() formula is redundant. So, you can simplify to: ADD_MONTHS(LAST_DAY({today}), -2) --Chris
-
We use RF-Smart at both of our facilities for all warehouse functions. At any time, there are: * 2-3 handhelds used for shipping * 2 handhelds used for receiving/put-away * 7-8 handhelds for work order picking * plus each one has a QLn410 mobile printers So, a lot of devices. They all run pretty quick. Nobody every has to…
-
Trying that now! Thanks for the pointers.
-
In the same boat there! Our experience with the NetSuite Professional Services team was simply terrible. The people they sent in were clueless about their own product and caused more harm than good--and charged us exorbitantly for the privilege! I just sent you a friend request, which will allow me to send a PM later. Once…
-
You don't need to limit the geography. I am also in metro Atlanta, but our favorite consultant is in Irvine, CA. That's one of the big advantages of a cloud-based ERP; physical location is no longer a barrier. The community forum isn't the best place to scout a consultant. Most of the members here are users who want to…
-
Good idea, @"JCirocco". Starting from the saved search that fails to e-mail, I: * Unchecked 'Send E-mails According to Schedule' * Ensured that I am the only recipient * Clicked 'Save & Email' Nothing came through. I created another saved search and made it as simple as possible: * Item saved search, with criteria to…
-
No luck: Robert Nedelkow-Oracle wrote:Chris Dobbins, a few things to consider: Enable the Send if No Results option on the Saved Search Email subtabI checked this box and saved the saved searchOnly one scheduled saved search can run at a time per user, with up to 200 concurrent scheduled saved searches per NetSuite…
-
Try the official Java site, https://java.com/en/download/manual.jsp On that page, you can find the latest versions for Windows, OSX, and Linux.
-
Using the standard Reminders dashboard item, you cannot alter the font size or weight. You could re-order the items in the reminders list to put more important items near the top.
-
We had the exact same request. Since Quantity and Rate are editable fields, Amount should always be calculated, right? Before we locked it down, our order entry team repeatedly overrode the Amount field and demonstrated that they couldn't do the math; we lost a lot of billable revenue. E.g. qty 7 x $13.50 ea = $84.50…
-
Thanks for keeping an eye on this ticket. After several false starts, the Expense Account was finally changed. --Chris
-
I believe you are using the RF-SMART solution, right? If so, consider turning on the Picked Bins option; it should do exactly what you want. From the RF-SMART help files: --Chris
-
From the menu at the top, go to Customization --> Scripting --> Scripted Records. Find Sales Order in the list. In the example below, you can see that we have 10 scripts + 5 workflows on our Sales Order. You can then check each script and see if it is affecting the shipping fields. I would start with the scripts that are…
-
If the shipping method and shipping item are populated on the sales order, making them appear on the item fulfillment should be automatic. Take one of those item fulfillments that is missing the shipping. Go to the System Information tab and check the Workflow History. Is anything overwriting any of the shipping fields? I…
-
If you simply want to send a statement to all past-due customers, you can do that: * First, make a saved search that will return all customers you want to include (i.e. those with a past-due balance). * Create a Dynamic Customer Group based on that saved search. Make sure to select the Billing Group option. * Go to…
-
I can answer the first part: * The deletion reason is NOT available if you do a saved search on Deleted Record table (I know; it should be there). * If you do a saved search on the Transaction Numbering Audit Log table, you can see the deletion reason. The customization you need is beyond anything I can help with. Maybe…
-
You can get a list of the tables and fields available by reviewing the NetSuite Records Browser https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_1/script/record/account.html Every saved search/report will have a different definition. Otherwise, they would all return the same result.
-
You can accomplish the same warning/confirmation by turning on the 'Use Deletion Reason' option (Setup --> Company --> Enable Features). This will require the user to acknowledge a pop-up and select a reason whenever deleting a record. That reason is recorded with the deletion. The built-in list of reasons is too short and…
-
Might need a community admin to look into why the link doesn't work and why you cannot see glinsaw_42224. In the interim, here's a copy&paste of his reply: There are several options to export them out of NetSuite NetSuite offers plugins for Eclipse and Webstorm that allows you to download the XML of the search. Eclipse…
-
Check out the resources that glinsaw_42224 posted earlier this week:
-
For issue #1, see if the ones which weren't updated are actually Leads/Prospects. Leads, prospects, and customers are all "customers", but sometimes you have to explicitly select them.
-
You could make a copy of the saved search before you edit it. On the existing saved search: * Change the search title (e.g. Saved Search_Backup_08-20-2019) * Hover over the blue Save button until the pop-up menu appears. Then, choose Save As. You will now have the original saved search and a copy under the new name. This…
-
Three things you can do: * On the item record, modify your view on the inventory detail. The default view has a filter for "On Hand is greater than 0". Just remove that criteria and save the alternative view. Back on the item record, you can choose between views depending on what you need to see. The new view will show all…
-
That does pose a difficulty. We could do the formula, but there are about 250 countries and it's not a static list. The 2-character codes works for us in some applications. Is the table that houses the cross-reference unavailable to users? Would best practice be to create a user-defined table?
-
The method you outlined is a good approach, especially if you use the memo field to explain why the change is being made. If the initial transaction of the lot number is in an open period, you can also edit that. Look for an Item Receipt or a Work Order Completion. If you change that initial transaction, make sure to also…