Nick Horowitz Green Ribbon

Great! Glad you got it fixed finally!!

Check out this post: https://usergroup.netsuite.com/users/showthread.php?p=22571#post22571 My company offers even better pricing than PayPal's new plan (see above post). Special pricing for fellow NetSuite users.

Ok, I just tested this. Exactly as Evan described: NetSuite will list the Payment Methods that have the "Credit Card" box checked, REGARDLESS if the Payment Method record is marked as Inactive (I suppose this is a bug, but you can work around it). So, Brenda, so fix your problem, show the inactive records, edit them, and…

Yes, any acquirer who has access to First Data Nashville will work. Just tell Wells Fargo to set you up on FDMS Nashville platform, which will work with PayFlow. (Wells Fargo Merchant Services and First Data are a 50/50 joint venture)

Why don't you sign-up to accept Discover? It costs nothing unless you use it.

Actually, the only field that is necessary for interchange qualification, is the 5-digit billing zipcode. The rest of the address (street number and 9-digit zipcode) is for security purposes only, but does NOT affect the rate. The street name is not even used, only the numerical digits in the address. The CVV is for…

Brenda, according to Evan's post, you have to uncheck the "Credit Card?" box on the payment method records. So, go to: Accounting > Other Lists Choose "Payment Methods" in the drop down Make sure "Show Inactives" is checked. Now "EDIT" the Amex & Discover records. You will see the "Credit Card?" checkbox is checked on each…

Fergus, I am not clear on what form you want to put the fax # onto. Are you talking about printing-out a check onto plain paper instead of check stock and then faxing that to the bank to initiate direct BACS payment? If so, you can not modify the check layout. But, you may be able to sneak-in the fax number in the "memo"…

Hi David. I am working on a consulting project for a client right now cleaning-up 250 old transaction in IRNB. As Olivier explains, it is best to keep it clean in the first place by making sure your IR amount matches your Bill amount. If you're interested in some cheap accounting help to get yours cleaned up, contact me…

Malin, if a particular userid (emailaddress) has access to several different NS accounts, how do you tell the ODBC driver which account you want to access? Or is data rows from all the permitted accounts exposed and you must include companyid=12345 in every query?

Or you can do a journal entry to debit A/R and credit sales revenue make sure to put the Customer in the "Name" field on both JE lines. Then use the Accept Customer Payment function. You'll see your J/E and also the CM. Make a zero dollar payment amount, but check the J/E and the CM and save it, and then NetSuite will…

You could probably write a script to remove that item from the drop-down list based upon role and have it fire when the page loads.

Or see my post about using BETWEEN in a CASE statement. You could certainly use the range of 2 days to encompass the quarter or month. See posts #136 & #137: https://usergroup.netsuite.com/users/showthread.php?t=5889

gry, are you trying to find datecreated during this calendar month? Or do you really mean datecreated in the past 31 days (which could span 2 months, and even 2 years)? When you say 2-year date period, do you mean Dec 2009 thru Jan 2010, i.e., that is spans over newyears day? Pls clarify.

Enhancement 81019 - Email Templates> support attachments to templates

The TRUNC function will truncate the date to the level specified. In this example, this will always give you the first day of this month: Ex: 19-MAR-2010 would truncate to 01-MAR-2010 TRUNC({today},'MONTH') So then just use that in your filter. You may have to wrap this in a CASE statement to work-around the formula…

Jocelyn, 2 suggestions: (1) On the Credit Memo do the positive +1 quantity with the old wrong higher prices. Then on the next line do a negative -1 quantity with the new lower price (the negatiave qty is like re-selling the item on the CM). You sometimes have to fiddle with the line item machine to let you enter a negative…

Not possible directly in NS. But as Jim suggests, you could order pre-printed forms that have your T&C's preprinted boilerplate on the back. Or use your laser printer and run the form thru the laser printer a second time to print the T&C's on the back side from a Word file or PDF file. Or, buy the full version of Acrobat…

Can you somehow pass the author as a parameter in a GET string in the URL to the saved search?

Put it in one of the address lines of your company address

Hover your mouse over the hyperlink, and look at the id=### at the end of the URL string in the lower left corner of IE. That is the InternalID of the contact. You can lookup the contact using that id #.

What about using the "Related Items" tab on the item record, and you manually relate all the author's books to each other on that tab? I think the related items automatically presents suggested related items on the web page when you view the base item.

Yup. That's it.

Contacts are children of Customers. There is a new option that automatically creates a Customer with a Contact from a Lead record, so that may be what is happening to you causing 2 recs to be created. That is, if you have a Lead record that is set to an Individual radio button (not a company radio button), you would have…

Steve, the NS accounting data schema is modeled after QuickBooks. So in older NS versions, there was the same QuickBooks field that held a "space" for uncleared, "C" for "cleared" or "R" for "reconciled". You can still see this checkbox in the check register labelled the "CLR" column. You could go to the checkbook register…

Steve, if I understand you, you are posting 10 "Accept Customer Payment" transactions using WS? If that is the case, you have the choice on the Accept Customer Payment transaction whether to post that payment directly into your checking account (which must be what you are doing), -or- to put them into the Undeposited Funds…

we use the include netsuite.com Also note, some emails still come from their previous name netledger.com

Also, we used to have the older legacy Enterprise Reporting Views odbc access, which used the Putty encryption driver and the Oracle9i ODBC driver. Then MS SQL has a database copy wizard that we would use and it would copy every table from NS Oracle over to our local SQL. Worked very well and flawlessly. Great for backup…

Since 1099's are on cash flow basis, NS only includes checks in the totals (NOT A/P--only Checks or Bill Payments that have actually been issued). So you will have to use Write Check to actually write a check to this person. Run the 1099's. Then void the check. That should "fool" NS into including the amount in the 1099.

Also, NS has extensive change logging now in the System table. So in theory you could just query the System table and get 100% of field changes with old value, new value and customerID. So you could probably write something to do the synch this way (one way synching only, of course, i.e., pickup changes in NetSuite and…