JohnCirocco · Sr. NetSuite Administrator · Silver Trophy

We used to use Bartender from Seagull Scientific to do custom labels. Cheap and easy to use. You would need to export data to CSV if you don't have ODBC

Assume we will create when customer record is setup for the loan (when live and new load added) or through CSV during initial load of loans from their old system

Is there a method you use to see what the balance is or if the payment is late?

We used Kits and did not have an issue. If we wanted to see how many of the individual units were sold, whether in a "case size" kit, we just ran our reports over fulfillments instead of kits. Since we also had many true kit items as it was, using kits made it so customers only purchase in set quantities with discounts.

ibudimir, I am not sure of what the GL impact should be as they are a new customer and we are trying to determine the best way to handle loans to customers. My preference was to have it treated like a gift card/certificate where we could see the GL liability for the loan. My initial thought was to have a custom record with…

What about using Department field on Sales Orders as a sales channel? It then becomes a sub-account in GL. That is the method we use and have not had an issue doing P&L by channel.

I would ask the customer to have his IT person set up an email group and he can control who gets the emails. Just sayin'

An option you have it to use the Units of Measure. For instance if you need multiples of 50, create a unit of measure called "50" based upon eaches. Have your purchase and stock quantities set to use eached if that is how you buy, but use the "50" U/M for sales unit. Now you might have issue with the line item have a…

sorry, cannot think of a workaround. good luck

You could place an entry in the host file that blocks the NetSuite domain. Add the following on the computer to the host file system.netsuite.com 127.0.0.0

If all the PCs inside your networks have the same external address then you can use the same external IP address, you can use Company IP Address Rules to restrict the PCs. I use web site (don't laugh...) www.ipchicken.com to view what my external addresses are. This is the address your router/firewall uses to talk to the…

Ah, assumed you had static address since it is a business. You would have to change this each time the address changed.

Not sure what you mean? Did you try the host file change? When you say within the office, are the other PCs still on the same network, just different part of building?

I just took 2 of my test customers and merged them using the oldest as the master and my create date on the system notes did not change. When doing your saved search to determine created date, try using the "System Notes..." field on the entity record and you should be OK.

Bug. Best way to put it. You can remove the pop-up at Hone -> Set Preferences -> Transactions -> Inventory Level Warnings=Unchecked

In case anyone is following this thread OR needs to come up with a way to set an alert for low stock level on an item. As many of us have found an alert email does not get triggered on an item record if the inventory quantity is changed because the trigger is on the item. So I tried to trigger the alert on the transaction…

Just make sure that you have properly set your reorder points (in this case to 23) manually and this will work. Item of note... we have found that new items do not calculate a reorder point automagically until they have had history at least as long as the system inventory default value Order Analysis Interval. see <setup>,…

Sorry, duplicate submit of above...

Each item can be manually configured for unique reorder point, preferred stock level. You can also have system calc the preferred stock level to have a specific number of days of supply. The key is every item can have unique settings.

Mine is set at workflow level to After Submit as well as on the Workflow Action List

If you didn't want to use script I believe this could also be done via workflow using the new Sublist Action Group. Workflow initiated on Create when Created From is Empty. I do not have Advanced Taxes on but I am able to Check the Taxable box for all line items.

The users role was Administrator and I finally found that the user needs to login and go to Settings on the home page.

Bump... Any thoughts out there?

Not really sure if this helps you at all BUT the search type Inbound Shipment can join out to the Item Receipt and Purchase Order tables

Well, If you want it to be available in a saved search, you can create a second customer field that is stored and then have a scheduled work flow to set the Stored field from the value in the non-stored field.

This can actually be done using a Saved Search and a Custom Non-Stored field based on that search

Once you create a search with the results you want, making sure you check the search definition bux Available as Sublist Customization -> Forms -> Sublists will allow you to attach you search to an existing tab on a kit or assembly (you select) form. Click the item tab - select your search - Give it a label - Select the…

We have created a new sublist search with the fields we needed and added that to a custom tab on the Kit & Assembly forms.

Not sure if this helps but Marty just posted this to his blog... http://blog.prolecto.com/2017/01/01/learn-how-to-dynamically-post-netsuite-content-to-wordpress/

Darren, It was a demo by Evan at 2 sessions that I was at (Partner Session and the General Keynote) where he showed multiple level joins and then the last was the straight SQL. They initially announced a total rewrite of Reporting and Searches back in 2014 then we go to see last May. I am REALLY hoping that it is at least…