Tom Dalton · Owner · Silver Medal

Evan, I appreciate your response, but I will admit that I didn't completely understand. We do have a number of inventory asset accounts in our COA. It sounds like you are saying that you must have only one inventory asset account and it must be the "correct one" with the "correct name" or else it won't show inventory…

Tracie, do you also use it to show LTL freight rates in your shopping cart? That is what we're after more than anything else. -Tom

This is not an option. I tend to set it somewhere in-between in this case. We have a large item that can be shipped in a 1,2 or 3-pack. Each quantity uses a different box. So, I use a 2-Pack box as my default. Shipping is a little high on 1pc sales. Shipping is a little low on 3-pc sales. Another downfall is kit items. If…

Ed, Do you display LTL rates in the shopping cart for our NetSuite store shoppers to view? Tom

This works <%=getCurrentAttribute('salesorder','shipaddress')%>, but it shows the address from the sales order. I need to grab the address from the fulfillment.

I tried NetSuite's UPS validation. All it does (for us) is show the error "Invalid license access number".

Bump. Anyone tried these?

Avalara's AvaTax software does too many other things that we don't need ...which prices it off of the list. I tried PCA predict today. It is off the list. It didn't work properly for us. Addresses weren't formatted correctly and in some cases it just had bad data (eg: wrong zip+4 number). I've emailed Pitney Bowes 3 times…

I found the bad news here... https://netsuite.custhelp.com/app/answers/detail/a_id/36630/kw/free%20shipping%20promotion It only works with INVENTORY ITEMS and Assembly items. It doesn't work with non-inventory items. Aaargg. Why??? :-(

I talked with OzLink. This is a Netsuite issue. They've seen it before. Workaround: on each fulfillment, click edit address…then, save the address without making any changes They also said to see proof of the issue, view source on a fulfillment page and you'll see that it doesn’t reflect the new address that was entered.…

OK. How do you set this up IF using the advanced promotions method that allows you to LIMIT free shipping to only the items that qualify? This is the version one where you use a generic "DISCOUNT ITEM" and put the shipping discount in under promotion--> {Discount Tab --> } --> ADD SHIPPING DISCOUNT This is NOT the version…

There were a lot of shortcomings. A key one for use was special pricing via UPS 100-weight and/or GFP pricing from UPS. Some of those features were only available in World-ship.

Yes. We've been doing this for years. You just have to use "multiple location inventory". Then create "virtual locations" for each drop-ship vender. Then set the items as using their corresponding "virtual location". Tom

It won't auto-pick the closest location. We have locations like: INV - Our warehouse - IL DS - Acme Widgets - CA DS - Spacely's Sprockets - NY DS - Cogswell Cogs - TX Only the first one is a real location. All with "DS" are drop-ship. We've also assigned each item a location. It is the most likely shipping location, but…

One item can have multiple venders, but from my understanding; Each item can only have one preferred location. The preferred location is used for web-store shipping calculations. I guess you could make multiple drop-ship items (with differing preferred locations) like "abc123-West-Coast-Warehouse" and…

Our Barcode scanner quit working with our netSuite forms. I'm not sure what changed. When we scan ...it drops numbers. So, 12345678 might scan as 1234568. 10 scans in a row might yield one good scan. I ordered a new scanner. Same issue. So, it wasn't the scanner. I increased the font size in our PDF form. Still, same…

Are there any new solutions to this missing feature in NetSuite? We have items that need to go by LTL Freight only. Customers order them with UPS as the method and are mad when we tell them TRUCK ONLY and the price is higher than what was on your order. NetSuite, why have a way to force a per-item shipping method in the…

Whoever thought of this has not appreciated the problem at all Ditto Very few people will want to split an order into two different shipments Ditto Also, unless I'm missing something, this new "Default Shipping Method" preference area has ZERO effect on the WebStore customers. The main reason we wanted an enhancement like…

OK, I guess it is time for "plan D". I've got a custom text field with the ID of {custbodyshipcarrier_cstm} The field applies to the fulfillment record. I need a formula so that {custbodyshipcarrier_cstm} will hold the shipping carrier NAME based on the tracking number. The first three letters of the tracking number can be…

OK, using the following formula (in a custom transaction body field) works... CASE WHEN {trackingnumbers} like '1ZY%' THEN 'UPS' WHEN {trackingnumbers} like 'YRC%' THEN 'Yellow Freight' END What is odd to me is that the field shows "ERROR: Field Not Found" when viewed in the item fulfillment record. The very same filed…

I tried using a custom non-stored text field with a formula value of {shipcarrier} and using the custom field in our email template still doesn't work. T

Yea, we got the "shipping method indicator" working in our account using a custom formula. The only real problem with our tracking number notification setup is that there is a separate email generated for each tracking number. So, an order with 10 packages ...the customer gets 10 emails.…

Is anyone else using fulfillment email templates with {shipMethod} or {fulfillingtransaction.shipmethod} with any success? Is there a different field that should be referenced? Thanks, Tom

I was wrong. They all say "Items that you've ordered have shipped via .". Yes, we do have a name/description for each shipping method. Thanks for the help. Any more ideas would be appreciated very much. -Tom

Thanks Matt! It is an "item fulfillment record" search. So, the filters are like this... Type = item fulfillment Tracking Number = is not empty Date Last Modified = is on 1 days ago Status = is Item Fulfillment:Shipped Location = is any of Warehouse 1, Warehouse 2 Main Line = is true Date Created = is on or after thirty…

I also just tried using {shipcarrier} and it doesn't work either.

Any ideas?

Maybe NetSuite can tell me why this only won't work in our account. T

{fulfillingtransaction.shipmethod} almost works. Now for "regular" shipments, I get... Items that you've ordered have shipped via UPS ground. The only problem is that our "integraded" UPS shipping method returns: Items that you've ordered have shipped via . So, we ship 50% integrated and 50% regular. So, half of our…

We are looking to be within a -10% to +10% margin for small package, +0% to +50% for truck and express shipments, on the average. The higher margins on truck and express reflects the higher costs associated with re-shipments (customer service buffer). That is the type of information I was looking for. We're trying to…