Nick Horowitz Green Ribbon

Try enabling the "Show Internal ID's" in your User Preferences, and then sort by the InternalID column. In theory they were created in ascending incremental order, so the internalID's should be ascending the same as the numeric portion of the name.

Maybe you could use the SQL Substr & Instr functions and extract the portion of the hierarchy from the string that you need and then group on that formula(text) field. The hierarchy string is separated by colons; you can count the colons. Or include a special character in the parent's name and then search for that special…

Here's a formula for the number of business days between a future date and today, where both are weekdays: trunc(({startdate}-trunc({today}))/7)*5 + mod({startdate}-trunc({today}),7) - case when to_number(to_char({startdate},'D')) < to_number(to_char({today},'D')) then 2 else 0 end Hope this helps. Thanks, -e Evan, do you…

Thanks Evan!

Evan, can a simple sql SELECT query inside the formula field do the trick? Can a sql stmt access the transaction table from inside an Item Search? How do you reference the other table in the sql statement? for example, SELECT DATE FROM TRANSACTIONS something like that?

If you conceptualize zipcodes as just a numeric value, as you have, then zipcodes run from 0 to 99999, so any of the zipcodes that begin with zero would necessarily be less than ten thousand. You should therefore still be able to use your formula. In your example, you would want 'Between' numeric values 15 and 1999. Right?…

Hey Jamie: Glad the formula worked for you. There is an enhancement request (old) already in existence to add the Shipping & Billing fields to the saved search filter. Open a ticket and ask that you be added to that enhancement request. And, then (separate step) go to the customer center and vote for the enhancement. They…

Jamie, there are 3 different variables for addresses in the Saved Search system. In general, you can access the fields from the one Default Bill To address, the fields from the one Default Ship To address, and then the fields from all the address records (this last option returns ALL the address records so you can get…

Put just this string in the formula field: CASE WHEN ({zipcode} BETWEEN '015%' AND '019%') THEN 1 ELSE 0 END Then choose Formula (Numeric) equals 1

Flash, there is a PDF manual showing all the tables & field names, and linkages between tables/fields. It is one of the standard manuals available in the help section. It should be viewable by all, but it maybe restricted only to those clients with ODBC access. Here is the link. It is entitled "Enterprise Reporting Views…

Well, the zipcode field is actually alphanumeric so it can hold Canadian and European postal codes which have alpha characters. But, since this seems to be a bug and NS is treating it like numeric, what about trying "zip < 9999" should be all the zipcodes less than 10000 which would be any zip begining with zero in the…

Yes, you are right, the leading zero is relevant. There is a thread in this user group with lot's of different examples of formula. Here is the link: https://usergroup.netsuite.com/users/showthread.php?t=5889&highlight=100+Ways+Formula+Fields Notice that some people are using the 'between' sql function, so it must be…

You could maybe include the InternalID in your search, and then filter on InternalID to break it up into chunks of 10K records. Or, maybe the CSV export allows more than 10K but less than 1 mil and you can chunk it that way. Evan do you know if the record limit on CSV exports is > 10K?

I tested Relationships > Customers > Search. I made sure the "Advanced Search" box is checked. I then picked "Zip" and "Starts with" and "0" and it DID work for me.

Gladstone, the much larger issue here, is that you should *NOT* have to be doing manual deferred income journal entries in order to compensate for NetSuite shortcomings!! If NS is truly GAAP compliant (GAAP is the United States Generally Accepted Accounting Principles), then NS should *NOT* be recognizing Income on…

They wouldn't even add DHL integration when DHL actually had a U.S. network with ground and air. Now that DHL closed all that down and is only doing international, there is no way NS will expend money of integrating. Therefore, I would recommend one of the third-party shipping solutions.

Does it matter? If USPS is cheaper, then let the customer choose it. If it is more expensive then they won't choose it because customers want the cheapest shipping. Wait I think you mean that you want to suppress UPS for APO and PO Boxes. That is a different problem. Make sure you put a warning somewhere on your website at…

Usually from the scale company you should be able to get programming instructions on how to create a custom sequence of characters which the scale sends to the keyboard port. For example, you may need something like: {tab}{tab}{tab}{weightvalue}{ENTER} I.E., you figure out the keys you would need to press on the keyboard…

Hi Malin. I can understand the rationale not to offer First Class Mail for international due to lack of tracking. But for domestic, it is a very economical option. Up to 13 oz. can be sent with First Class postage and it is much cheaper than Priority or Parcel Post. If it is a package/box or a rigid envelope, or > 3/4 in…

If you have at least 1 priority mail package in the batch, then you can schedule free pickup the next day of all your packages by your carrier. And then you can give him all your packages including the non-priority mail ones. But the PO will only do a free pickup for priority mail. Unless your carrier is cool (some are).…

Yes this is another tentacle of the same problem that Locations are serving multiple purposes that should have separate segments. The other example is employee's work location vs inventory location. If you aren't using NS Payroll, then the employee's work location uses the same Location segment....so now you have Inventory…

Customers expect to know the shipping charges upfront. So you will be at a huge comeptitve disadvantage. A couple suggestions. Change your shipping pricing to be like a lot of mail order companies where the charges are based on the amout of the order. You do some historical analysis, set your total ranges and shipping…

Rafe, please clarify.

That is called a drop-shipment or a special order. You code the inventory item as being available for drop ship or special order. Then on the Sales Order, you pick "drop ship" or "special order" on the line-item, and it will generate a drop ship or special order PO to the vendor linked to that line item on the Sales Order.…

You can fullfill a drop ship from the sales side or the purchase side of the house. Fullfilling one side automatically fullfills the other side of the house. I.E., you can Mark Shipped on the PO (which is the purchase side), or you can Fullfill it on the SO (which is the sales side).

Isn't there some type of config file that you need to create in a .BAT file and send that to the printer first to configure the printer? I've seen posts in the this UG about creating custom .BAT files to configure the label printer. Sounds like the printer is not recognizing the form feed character in the PNG file and is…

Or go the other way...instead of trying to give them a hyperlink that works specifically for their package. Instead just give them the tracking # and a general list of URL's where they can go visit to track the package themselves.

Add the 3rd party as a contact. Can you use the CC or BCC fields to sneak-in the 3rd party's address? Or shut-off the option in your user preferences to "Limit CC Field to Contacts & Employees", then you can put any address in the email.

Here is another thread I posted on a company that wants their name blank for blind drop shipping purposes! Read this post and I suggest a couple of areas to fiddle with to see if it affects the return address on the integrated shipping labels. https://usergroup.netsuite.com/users/showthread.php?t=4920

You can create a Contact that is not linked to any Company. They are just stand-alone Contacts. That being said, I don't know if they will show-up in your pick box. You'd have to test. What about puting the 3rd Party's email onto an Employee record. Employees do show-up in the filtered box. Since you only need 1 and you…