Nick Horowitz Green Ribbon

Yes they are linked tables. You take the InternalId and go look that up in the other table.

Hi Greg, thanks for the explanation. So, back to your question... There are 2 fields on each transaction that are relevant to reconciliation: (1) There is a boolean Cleared? field that is True or False (2) There is a date field that holds the reconciliation report date that the txn is included in. If you look at the…

Hi gbills, First question, why are you depositing your cc txns directly into the checking account? You should be flowing them thru undeposited funds instead, and then making 1 single deposit each day for the day's cc receipts. That way you only get 24 deposits per month into the checking account which is manageable. You…

Blitz, could you post your code here for everyone. Your most recent approach to use the result of a saved search is much more efficient than getting SO's one-at-a-time. The web query method I was suggesting is an alternative. NS gives you a unique URL for your web query which gives the results of your saved search in CSV…

Greg, there is a trick I saw on this UG, which is you edit a transaction, and then look for the "e=T" in the URL string and change it to "xml=T" and it will show you the xml of the record which then you can see the correct field names use for WS calls. I did this on a txn, and found the names of these 2 fields:…

I don't know WS very well. There may be an option where you can ask WS to return to you the actual value, instead of the InternalID, on linked tables. But if not, then yes you will need to do separate calls. Maybe someone else from this UG can answer if such an option exists.

Back to the issue of why do you want free-form text? This is a very bad idea and you will regret it later! I reiterate: don't do free form text you will regret it later. If you have it as a drop-down, then NetSuite automatically only presents the relevant states for the country chosen. So you don't have to do any filtering…

Yes, there is a checkbox called "close" on each line-item. You have to "close" each unfilled line item, then the entire SO will go into Fullfilled status. Once all line items are either fullfilled or closed, there is nothing left and it goes into Fullfilled status.

Yes NetSuite does the mod 10 check on the credit card number to make sure it is valid. Weird, though, that it doesn't do it on the add, only on the update (this sounds like a bug!)

Hi Dave. You can use the Webservices api (which could be automated), smbXML (manual import), or CSV (manual import). You will need to create the Customer record first if it does not exist (as you said). Credit cards can NOT be stored in the Customer record via any of the automation methods. Sorry. (But you can put credit…

Hey Shawn, didn't realize they had added credit card fields to web services. This didn't use to be the case because of security concerns. So, that is great info -- I stand corrected.

Elham, actually there are 2 much older enhancement requests with a ton of votes, so this 150744 should be deleted: 122165 with 72 votes 23743 with 203 votes Note: FYI, the USPS offers an API where you can do address verification, and you can create the Delivery Confirmation barcodes, and you can calculate postage amount,…

I have a hunch you have to set the other relationship first, which will create a new record of the other type. Then try using duplicate detection to merge the new empty record with your existing record. For example edit Vendor called "Vendor1". Add a new other relationship for customer. Now you should have the new (empty)…

Unfortunately you cannot set this relationship through Web Services today. Please enter an enhancement request for this. Elham, has this capability to set CustomerOtherRelationships been added to Web Services as of 2014?

You have to import BOTH the CC# and the PNRef. The PNRef alone will NOT work as you have found. I agree this seems a stupid, risky design since the PNRef is unique and it's risky and causes potential PCI violation on your side since you have to store the full CC# in order to be able to pass it to NS, BUT that is how the…

I think NS only provides URLs for the 2 integrated shippping companies, UPS and FedEx, so I don't think you can specify a custom URL for other user-defined shipping methods. You could write a script that would concatenate the URL correctly and put it into a custom field on the IF record, and then just include that custom…

geosat, could you post your .bat file here....I'd really like to see it how you do it from a bat file....!

We're not upgraded to 2007 yet.

While we're on this topic, a few versions ago, NS installed some code that stopped populating "United States" in country in address records if the NS customer was also a US customer. Adding a country of "UNITED STATES" at the bottom of a US address just congests the mailing address text in a window envelope and the post…

Ed, there are a couple of approaches to this. In all cases, you will need to write a little middleware program to catch the callerID from the TAPI in Windows and then manipulate the IE window. (1) If you subscribe to NS's ODBC, you can definately do this. In fact most phone vendors have canned utilities which can do a SQL…

Here is a program I found using a Google search, which will run as a Windows service, it monitors the TAPI interface for CallerID, and it can launch a bat file!! I don't know the price. And when I tried to install it, I got an error that some OCX DLL was using an illegal section of memory space. BUT, this is the type of…

Thanks Geosat! That is awesome. A Google search of the Start command states that this will launch the default browser and navigate to the URL. Since you are using IE7 with tabbed browsing, it opens the new window on another tab in your existing instance of IE thus preserving the sessionID. This must be a unique…

Mark, almost every phone system today comes with a TAPI driver bundled with it. NetSuite has a TAPI DLL you need to download from NS and install on the PC. That DLL will allow NS to dial OUTBOUND with one click of a hyperlinked phone # in NS (IE only). NS's DLL talks to your vendor's TAPI driver. For Inbound, you have to…

So the code you provided below using the MS Soap object built into XP, won't work without the .NET DLL wrapped for COM object as well?

James, did you get your classicASP vbscript working? Do you have some sample vbscript code you could share?

Well, I'm not really sure how to answer that. The reason why is that I am using a cool tool called .NET WebService Studio which loads the WDSL, generates all the classes, and then you can graphically pick the different elements of the WDSL and it will contruct the SOAP message that is sent out over the wire, and also the…

There is a checkbox option in your user preferences to "Show InternalID" which will show you the InternalID. Then if you know the system's prefixing convention, you can figure it out. Otherwise, if you do an smbxml query, the result will include the handles if you include the xml tag to include handles. But, yes, I agree…

Actually, if you don't use a handle in your smbxml file, then the system assigns one automatically (and also via the UI). For Customer records, for example, it is the prefix "CUST" followed by the internalID. So you can figure it out by looking at NS's prefixing convention. BUT, if you assigned your own handles in the…

The InternalID that you can turn-on in your user preferences so you can see it in the UI, is the same InternalID that is used for WS. That's why they exposed it in the UI (to assist with design WS). Also, if you look in the URL, you will see the InternalID of the record you are trying to access will show as a GET parameter…

You may have an option activated which keeps track of multiple packages on an individual Item Fulfillment record, in which case you have to get the shippingcost from each child package record beneath the Item Fulfillment record, so you may just not be looking in the correct table in the report module to find the child…