Nick Horowitz Green Ribbon

Jay, did you fiddle with my suggestions? Pls report back if they worked. Another UG member is getting null null in their company name on FedEx.

Jason, that is a brilliant idea to edit the .EPL file. I never thought that far outside of the box--but it's a great idea--thanks for sharing.

Yes, I have learned the trick to force the query to run at the server and just send the results across the wire, than to pull the whole dataset to the client and then run the query (which is really slow as you point-out). NS's Oracle server is obviously able to run the query much faster with much more horsepower than…

Long, maybe I am missing something here, but in this specific example you have provided, the sub-query is first pulling all the columns and rows from the TRANSACTIONS TABLE, then from that universe it is then returning just the TRANSACTION_ID. So wouldn't this SQL command produce the same result? SELECT TRANSACTION_ID FROM…

I tried some testing with MSAccess. First of all, if you want to be able to see the SYSTEM_COLUMNS table in MSAccess, you need to set the Access option called Tools>Options>View Tab>System Objects. (This will also show the normally hidden MSAccess system tables in your tables view in Access). The SYSTEM_xxx tables are all…

Can you try using MSAccess to do the SQL query using the SQL Specific>Pass Thru option in Access? (That runs the query on the server). I.E., I'm wondering if this is a limitation of your client or of the ODBC driver. Because most ODBC drivers do allow for a "pass-thru" treatment where it will pass the SQL string verbatim…

Yes, I got Excel to show them per your suggestion. For everyone's benefit, to show them in MSAccess, here is the procedure: if you want to be able to see the SYSTEM_COLUMNS table in MSAccess, you need to set the Access option called Tools>Options>View Tab>System Objects. (This will also show the normally hidden MSAccess…

Open a Support ticket. That is an Oracle database error.

Metavante Billpay is already integrated with NetSuite. It is included free in your base subscription. Metavante sends out paper checks with your MICR on the bottom (they don't steal the float from you). See instructions in NetSuite for activating Online Billpay on one of your checking accounts (you only get 1 account).…

Yes that is annoying. I think that field is "sticky" per user. So once you uncheck it, I think it sticks to that next time by default. The Onload event solution would definately work.

Use ACCEPT CUSTOMER PAYMENT and apply it to the J/E. The balance from your J/E is sitting in A/R (make sure on your J/E that you put the customer's name in the "Name" field of the A/R line of the J/E or else it won't show-up when doing the accept cust pymt)

Bill, I sent the product mgr an email asking him to fix the descripton of 59114

Yes it will kill the link. The only way to link, is to go back to the Estimate and spawn a new SO from the EST by clickicking New:Sales Order That will link it for sure. Just realize that the SO will pre-fill with everything from the Estimate (which is by design). (It is unusual to have 2 SO's from 1 EST)

I think another work around was to copy the SO. Change the payment method on the new SO to cash or check (i.e., a non-credit card payment type). Save it. That strips-off all the CC data fields. Then re-edit it and change the payment method back to one of the CC methods.

This is just another idea that you may research. B2B Gateway has a very nice EDI integration with NetSuite which is fully integrated now that NS offers webservices. The EDI system supports payments to vendors via ACH and Wire (and I think international wire). You may contact them and ask them if they have some type of…

You configure the action you want taken on each AVS response with your gateway. All the gateways offer this as a security option. So it is NOT Netsuite that handles this. So tell your gateway you want value "X" to return a decline to NetSuite then NS treats it just like any other declined credit card. It is your…

The 'Copy' function literally copies every single field on the record, including all the payment data from the first SO! I have opened an enhancement/bug fix on this years ago, but no luck! Maybe you can track it down in the support center and add yourself to it. Anyhow, the work-around is to temporarily turn on the cool…

Here is the form from the Payflow Processor Setup manual for Elavon (Page 17 in the PDF): https://cms.paypal.com/cms_content/US/en_US/files/developer/ProcessorSetupGuide.pdf NOVA (Elavon) Complete this form and fax it to PayPal services at 303-395-2851. Once the form is received, your account is updated, and you will…

I don't think the failed txns are stored in NetSuite. You would have to get it from the Payflow gateway admin panel.

Miguel, did my work-around work? You really should be storing the credit card on the customer record in your scenario of multiple subsequent orders. The CC stored on the customer record will auto-fill onto SO's and CS's. It would be nice if NS had a feature where you couly copy the CC from an SO or a CS up to the customer…

You can talk to your gateway provider and ask them to change your configuration settings to stop declining mismatched AVS. This is an option you have set at your gateway. In fact, V & MC do not decline mismatched AVS. But a lot of gateways offer this as a value-add service where V & MC will grant approval, yet the gateway…

NS does offer one gateway that supports multi-currency: RBS WorldPay. The PCI rules in the credit card industry are very clear that CVV may not be stored in any database. It may only exist transiently during the authorization process and then must be destroyed/discarded. So, yes, you must re-enter CVV every time. But think…

Yes very easy. Who is your current processor?

Yes, you're right the wording is not correct. If you save the CC to the customer record, then it will pre-fill when you change it from Cash back to a CC method. This goes to my enhancement idea that there be a button to copy the CC info from an SO up to the customer record (just like they have a function to copy a sales…

Hi Bill. The CSC disapperaing is a known bug I reported like 2 years ago. The workaround is to change the payment method to a non-creditcard method (like Cash). Save it. Then edit it, and change it back to a creditcard method. The CSC should reappear. Hopefully the CC# and ExpDate won't blow-out when you change the payment…

Set Preferences > Transactions > Basic > Auto-Fill Transactions

Ok, below is a list of the acquirers/processors which are connected to Payflow Pro. So, Elavon/Nova is on the list, so you are good. Call Elavon and ask them if they are a reseller of the Payflow Pro gateway and can sell it to you for a bundled price. If not, then tell Elavon you will be using the Payflow Pro gateway and…

Earthdog, why not just use a NetSuite gateway? It is the simpliest solution here. The gateways NS offers are processor agnostic. So you can keep your current merchant account acquirer (for example if you have good rates with them), and just have the gateway deliver the transaction to your acquirer. If you are using Payflow…

Note you are NOT allowed to store the CVV2 number in any database!!! This is a massive violation of PCI rules, and you can be fined thousands of dollars. So do NOT create a custom field for this!!! NetSuite has CVV2 processing built-in which is PCI-compliant already. NetSuite collects the CVV2 value, sends it to the…

Stephen, "Customer Code" is used by Purchasing Cards. Some terminals are smart enough to only prompt for this on Purchasing Card BIN ranges (the BIN is the first 4-6 digits of the account number used to identify the card issuing bank). But NS prompts on all transactions if you have "Enable Level 2 Processsing" option…