My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges

Nick Horowitz Green Ribbon

Comments

  • On the Sales Order, you pick "Drop Ship" or "Special Order" on the line item and that creates a linked Purchase Order to the vendor for just that item. Called a Drop Ship PO or Special Order PO. You have to code the item as being available for Drop Ship (DS) or Special Order (SO) purposes (checkboxes on Item record). The…
    in Vendor Drop Ship Email out Comment by Nick Horowitz Nov 18, 2009 5:15PM
  • Chris, in your client there is a way to show all the tables. Sometimes the best way is just to poke around in those actual table schema, because the docs aren't always up-to-date. Also you will find that not all fields are exposed in ODBC, and often there is inconsistency between what fields are exposed in Saved searches,…
    in Where do I find the Tracking number in ODBC? Comment by Nick Horowitz Nov 3, 2009 4:27PM
  • Can we backup and ask why are you picking & packing so many months before shipping? The IF is not designed to have that kind of long lag. Also the COGS expense will be in the period of the IF which is many months before you Inovice the customer which is when the revenue gets recognized. So you have a GAAP mismatch on…
    in Picked and Packed now in a locked period - Can't Ship Comment by Nick Horowitz Oct 31, 2009 12:59PM
  • There IS a default for the Shipping Carrier. It is under Setup > Accounting > Shipping. Change the default there and then it will default to More and those of you who don't use UPS will be happy. As for why they did this change, your anger needs to be directed at UPS. UPS has very strict legal requirements that UPS…
    in Shipping Carrier = more. We don't need it! Comment by Nick Horowitz Nov 13, 2009 1:21AM
  • If you have dimensions set on your items, it may be calculating a dimensional weight
    in Ups Shipping Calcs Are Overstated Comment by Nick Horowitz Nov 5, 2009 9:28PM
  • If you say not all your shipping options are appearing when you toggle UPS vs More, then that is a UI bug. There was a UI bug with these symptoms, but it was fixed. So if you are still experiencing it, then make sure to take detailed notes on the steps you took that caused the menu to not load all the options, and open a…
    in Shipping Carrier = more. We don't need it! Comment by Nick Horowitz Nov 18, 2009 1:17PM
  • Yes you do. Go edit your Shipping Items. If you check "Use Integrated Shipping" and pick a UPS method then it will show under UPS. See my other post on this UG with a screenshot: https://usergroup.netsuite.com/users/showpost.php?p=99333&postcount=4 Or, if choose the radio button for real-time rate and pick a UPS method, it…
    in Shipping Carrier = more. We don't need it! Comment by Nick Horowitz Nov 13, 2009 1:25AM
  • Bushra, this is the limit on the USPS Customs form. There is only space for 5 items on the Customs form. How do you propose that NS solve this problem if the USPS form is not expandible? Melissa, how does the USPS solve this on their Click-N-Ship website? Do they merely print out 2nd and 3rd customs form pages until all…
    in "International USPS fulfillments allow a maximum of 5 unique items per package..." Comment by Nick Horowitz Oct 24, 2009 11:54PM
  • Maybe do it the other way around. I.E., put the order on the end-user customer record, with the Bill-To the Reseller? Or use the Partner feature and make the Reseller the Partner.
    in Delivery Address Comment by Nick Horowitz Sep 6, 2009 5:05PM
  • Ask your UPS rep to sign you up for UPS "Quantum View". With Quantum View, you can view all outbound (and inbound) activity on your UPS acct on the UPS Quantum View website.
    in UPS Integrated Shipments do not appear on my UPS online account Comment by Nick Horowitz Nov 23, 2008 10:17PM
  • Nope. Be careful not to screw it up next time.
    in Delete FedEx package from shipping list Comment by Nick Horowitz Nov 15, 2008 11:33PM
  • Can't you fiddle with the status of the SO so it won't show in the To Be Fullfilled Queue until you put the correct status on the SO to be fullfilled? Also, as long as you're getting authorizations at the time of placement, does it really matter if you fullfill before you bill? There is no risk to you to fullfill first and…
    in Fulfill ONLY when billed Comment by Nick Horowitz Oct 28, 2008 12:25AM
  • Erik, glad that worked!! And, yes the BAT file would have a destination different printer port name if it were a networked printer versus a local printer connected to LPT1 port.
    in UPS Label printer always prints 2 labels when I only need 1 Comment by Nick Horowitz Oct 20, 2008 1:48PM
  • Erik, ok it sounds like there is an extra form feed being sent to the UPS printer. Again, check your .BAT file to make sure there is only 1 line in there: COPY %1 LPT1 And no other commands or extra line feeds (use Notepad). Then next thing is your UPS printer has a sensor that will sense the gap between labels on the…
    in UPS Label printer always prints 2 labels when I only need 1 Comment by Nick Horowitz Oct 19, 2008 2:17PM
  • From the fly-over help popup for Vendor Name field: If your vendor uses a name for this item that is different from the name you use, you can enter up to 60 characters as the vendor's name for this item here. The vendor's name for this item prints in the Item column of purchase forms. If you do not enter a vendor name, the…
    in Item on Drop Ship PO Displays Vendor Comment by Nick Horowitz Jul 2, 2008 3:10PM
  • You can probably do this in NS, but you'll have to write your own custom JavaScript code and use server-side and client-side js capabilities to customize NS to achieve this result. I would find yourself a good Javascript programmer/consultant with NS experience.
    in Choose Warehouse Location Based on Ship To State Comment by Nick Horowitz Jul 8, 2008 7:21PM
  • Per Visa & MasterCard rules and your merchant agreement, you are not allowed to charge the customer's card UNTIL the product has shipped. V & MC do not want the cardholder funding the wholesale cost of the item. Since you already received an authorization on the SO, there is no risk of shipping out an item and the card…
    in Drop Ship PO Workflow - Email PO after SO is billed Comment by Nick Horowitz Jun 30, 2008 1:29PM
  • That is probably the Vendor's Item Number (i.e., there is a field on the item record that holds the sku that your vendor uses on their parts--so the drop ship po is showing your vendor his sku for the part you are ordering from him) Did you populate the correct data into the Vendor's Part# field on your item record? If you…
    in Item on Drop Ship PO Displays Vendor Comment by Nick Horowitz Jul 2, 2008 3:07PM
  • Yes I agree that everyone fudges but technically it is a violation of your merchant contract. FYI, V/MC auths are valid for 30 days. It's just that after 7 days, the transaction with downgrade to nonqual. So your butt is covered financially for up to 30 days. (Your gateway may have a shorter timeframe set for denying…
    in Drop Ship PO Workflow - Email PO after SO is billed Comment by Nick Horowitz Jun 30, 2008 1:53PM
  • I assume you have a UPS-provided thermal printer? If so, disconnect the power, hold down the button on the printer, reconnect the power, and it will go thru a self-test/reboot mode.
    in ELP Printer Comment by Nick Horowitz Jun 30, 2008 1:45PM
  • Per V & MC rules, an authorization is valid for 30 days. That means you can submit a Delayed Capture for up to 30 days after the date of the Auth and it will not be chargedback for no authorization. However, after 7 days the transaction will downgrade to nonqual. That being said, some gateways, and I believe PayPal Web…
    in Drop Ship PO Workflow - Email PO after SO is billed Comment by Nick Horowitz Jul 3, 2008 2:34PM
  • Wrong. The Item Fullfillment-IF debits COGS Expense and credits Inventory, but it doesn't post until it's in a SHIPPED status. When you Bill the Sales Order (i.e., create the Cash Sale or Invoice) that credits Income and debits A/R. These pieces are split (possibly in 2 different accounting periods) which is NOT gaap…
    in pick/pack/ship - G/L entry. Comment by Nick Horowitz Feb 23, 2008 6:33PM
  • You can probably do this with a Transaction Saved Search easier than ODBC. But basically look for the CreatedFrom field--this will the the Sales Order. The IF's CreatedFrom will point back to the SO. And then the Cash Sale or Invoice's CreatedFrom will point back to the same SO. So you have the SO as the common link, then…
    in pick/pack/ship - G/L entry. Comment by Nick Horowitz Feb 25, 2008 2:23PM
  • Well you didn't make clear what you wanted. A lot of mail order companies automatically send a return label on EVERY outbound shipping just so that customer will have a label if they want to return it. If you send out a return label with every outbound order then you'll have an open RA for every outbound order that you'll…
    in return shipping labels? Comment by Nick Horowitz Nov 2, 2009 1:43PM
  • UPS has a service called A.R.S. called automated returns system. You set this service up on your UPS acct, and UPS gives you a roll of preprinted ARS labels. Then you just tear one of those preprinted ARS labels from the roll and throw it in your box. Problem solved. You probably seen these with HSN or the cell phone…
    in return shipping labels? Comment by Nick Horowitz Nov 1, 2009 2:16PM
  • Try ordering something from OfficeDepot or Staples, and make sure they use their in-house delivery trucks and don't just ship it UPS. Those guys have a 3rd party solution that does this. You can ask the guy when he comes who the vendor is, or just look at his handheld device. Symbol or MetroLogic must have such an animal…
    in Signature Capture for Proof of Delivery Comment by Nick Horowitz Oct 13, 2009 6:44PM
  • Nope. But you can create a Saved Search on Transactions, and extract the Bill To address (you can pick the individual parsed fields, or you can pick one long concatenated string separated by commas--I use the parsed) into an Excel XLS or CSV file and then use that as input for a label mailmerge in MSWord. Easy solution.…
    in Mailing Labels Comment by Nick Horowitz Jul 20, 2007 11:45PM
  • Or alternatively you could create a custom drop-ship PO form with the amount and total removed per Evan's line of thinking and change the title to "Packing Slip".
    in Packing Slip Question Comment by Nick Horowitz Aug 8, 2006 12:54PM
  • Hmm...What you need is to create some type of report from NS to show you the stats used to create the Airbill. You should be able to pull the shipping fields from the IF record and put them onto a report. (Or, you may have to create a saved search instead). Then you can use that to audit your FedEx bills. As for FedEx, on…
    in FedEx/UPS Shipping Register?--Is there one? Comment by Nick Horowitz Jul 24, 2006 10:20AM
  • The passing thru of the shipping costs to the customer is completely unrelated to receiving the bill from FedEx. The expense debits from the FedEx bill and revenue credits from the Invoice I believe flow thru the same Income account called "Shipping Fees" (or whatever you have named it), but other then that, they are not…
    in FedEx/UPS Shipping Register?--Is there one? Comment by Nick Horowitz Jul 25, 2006 11:13AM