Found the trick. Don't import as 100 contacts of a company with each of the 100 contacts having a unique address, rather Import directly into the parent company.

I'm told this is not possible in NetSuite. Can you elaborate on your instructions? What "example file"? Thanks, Tom

Thanks for the tip. Unfortunately, our only reference number (in the vendor's CSV files) is the drop-ship PO number that was used on the drop-ship PO. It would be great if we could reference the drop-ship vendor's PO number in the CSV file and NS could match it up to the SO/fulfillment record that that drop-ship PO…

I'm told this is not possible in NetSuite. No Limits? -Tom

This would be a good example of a use for a new emailed data tool. With such a tool, we could email the tracking numbers to something like our-account@netsuite.com and it we would put a required identifier in the subject line (like "tracking-SO#12345") and we put the tracking number in the email body and NS would grab the…

I am also trying to figure out how to import UPS tracking numbers. Our drop-ship vendor emails us a daily CSV file with TWO columns. One column is the drop-ship PO number and the other column contains the UPS tracking numbers. Is it possible to import these tracking numbers so they land in the corresponding fulfillment? We…

Thanks Carl. I'm starting to get it.

Has anyone tried Avalara ? How is it? Are there alternatives to Avalara?

Alabama, Arizona, Connecticut, Iowa, Massachusetts, Minnesota, Oklahoma, Pennsylvania, Rhode Island, and Washington are all mandatory tax states in Amazon... it doesn’t matter if it’s merchant fulfilled or Amazon fulfilled.

It is a "how do you deal with this issue" question. There is nothing random about it. It is very specific. One time it was a pallet worth of goods that I was ordering to be drop shipped. I asked if i'd be paying sales tax if I sent the truck there to pickup the items and they never got an opportunity to look at the bill of…

Is this still the threshold... "$100,000 in sales or 200 individual transactions". From HERE Also, is it a different threshold for each state?

> if they have it on file they should not be charging tax I agree. They do not. They say... "if it ships to this list of states... it is now taxed... end of discussion". Ugh. This is a company with 900 million in annual sales and locations in over half of the sates. They say they know what they're doing and they're going…

We don't use "Fulfillment by Amazon". Amazon still collects sales tax for those states under the South Dakota vs Wayfair, Inc. deal! I don't know that NetSuite will be of any help, but I am curious how other ecommerce companies that ship from their own warehouse and sell both in a web-store and in Amazon might be dealing…

The channel does matter because some channels pay this tax for you. So, that makes this problem even more complicated since Amazon is collecting and paying this South Dakota vs Wayfair sales tax for a number of states. So, if we find a solution, we'd have to pull out the Amazon sales as "sales tax = already paid" when…

"Provides you almost limitless formatting options", but, not user friendly. Like most of NetSuite... need to read books or do online research for arcane code snippets to do what should be a simple change. I'd rather have a column header I could just click on to choose the sort order. Like my friend says when someone trades…

Is this still the case? We want to map each expense account to a specific department.

Was it possible with scripting? What about Expense Allocation Schedules... unrelated?

Yes, glad you asked. Limiting to downstream relationships seems week. -refund (this is the biggie and the most obvious omission) These would be nice... -sales order (yes, I know it is linked elsewhere..but for consistency it could be in the related records tab) -order fulfillment for "Created From Sales order" (indirectly…

Actually, after re-testing the latest version of the transaction Timeline. It isn't bad right out of the box. Bravo. Thanks, Tom

I was doing cash sale refund and not an invoice. In either case though, you give the customer their money back... but fool the system by putting zero on the quantity on the refund while maintaining the accurate dollar amount in the "amount column". This was just a way to keep NS from bringing the item back into inventory…

There is another way. From the cash sale, click refund. On the refund record, set the line item to zero, but put a dollar amount in for the item. Yes, NS accepts this type of line. So, if it defaults the refund to... [CODE]Item Quantity Rate Amount ----------------------------------------------------- Brass Widget 4 $5…

If you click drop ship to generate a PO, the item which has a different default vendor does not show up. Here is how it works for us. Before approving the SO, we set the vendors to the same (when default vendor isn't desired). There should be a little pull-down to pick the desired vendor for that SO (next to each line item…

We want to start a free shipping option. However, to protect our margins, I'd like to increase our prices before offering the deal. So, before it starts, we want to determine how much to mark-up every item. I don't want to do a flat rate... like add +10% to everything. I want to add a higher percent to heavy items and…

We have used both. We switched to eFax during a faxaway outage (sever years ago). We stayed with eFax because we never had any issues. T

TDG.danielc said what I would have said. It isn't features we wouldn't have had in the other systems. It is features that existed in those systems, but require very advanced IT skills to accomplish in NS.

I like the idea of Suiteflow. I tried Suiteflow. I couldn't figure it out. More examples would be handy. A book on the topic might help. I've got years of database experience (FileMaker), but no javascript. I would lump javascript in with "advanced IT skills". Anything project requiring knowing a new programming language…

Recently moved to netsuite - i thought our bookeeping fees would reduce. I also thought our IT fees would reduce via a cloud system. I spend more on developer projects now (to add features and fixes that are slow to come to NS) than I did using multiple locally hosted systems.

Change the parent's location will apply changes to the children if you click "apply to children" when saving. I don't know about CSV. I know you can't change a child item's location directly from the child item. It must be done through the parent.

I'm also looking how to find items missing prices in a particular "price level". In our case, i need to find items without anything entered into our "reseller price" level. Any help would be appreciated. Thanks, -T

And don't forget ponies. Everyone should have a pony.