I'm having this same problem a year later!

You need to have keyed the check# on the Accept Customer Payment or the Cash Sale transaction in the Check# field and that will flow thru to the deposit slip (Note: on the Cash Sale, the Check# field is located up in the header area, it's NOT on the Payment tab, so you have to go hunting for it!)

Well, I can't even get the deposit slips to align properly (even with fiddling with the vertical & horiz offsets), so you're already ahead of me if your only problem is that the check# isn't printing.

You could write about 2 lines of Javascript to provide that validation (that LastName not Null)

It would be like that with the dot separating the other table name dot fieldname. You just have to get the correct table name & field name. Maybe Evan can chime-in here with a suggestion.

Here, Evan gave a formula that should do the trick, much cleaner than multiple case when statements: https://usergroup.netsuite.com/users/showthread.php?t=14674&goto=newpost

Here Evan has a cool formula: https://usergroup.netsuite.com/users/showpost.php?p=74186&postcount=3

There is an option somewhere whether to print the tax code, or not. You'll have to poke around, but I am sure there is an option to suppress it.

Not with normal forms modification. But you could probably write a script to validate the address fields and popup a UI warning box if they are empty. This would be very easy script to write. You may even be able to find a 3rd party script which would actually standardize and validate the address against the USPS database…

Or give us field-level security like salesforce.com

Ours doesn't do this, but our subsidiary uses GST so the taxes are on every line, not a blanket tax like in the US. So maybe US behaves differently than International/GST versions?

Create a Description type part and put the signature line text in there. Make this the last line item you add. Put the signature text in the Disclaimer or Message text fields, which are positioned at the bottom of the form. I am not sure if the Disclaimer and/or Message print on all pages of the form, or only on the last…

Are you talking about on a Sales Order, or on the Customer record address tab? These are different animals. NEW on the Sales Order will add a new address onto the Customer record address tab. CUSTOM on the Sales Order will put an address on that specific 1 Sales Order only and it will not be saved anywhere else. Why are…

You can't. Have your reps use the Email button to email the Quote PDF to the customer. Make sure the option is enabled to give an Email popup dialog box. Then you attach your terms & conditions PDF separately in the Email dialog box. Or, use the Disclaimer or Message area on the Quote and tell your customer that "Quote…

You can have a server-side script code that fires onPageLoad to do the query of the external database and populate the field before the page loads. Should be easy to do. If you uncheck save field on the custom field configuration page, then it will do the calculation each time that field is needed to be displayed. (This…

NetSuite uses Oracle as its database engine, so look on Google for any Oracle 9i reference and those should work in NetSuite. Evan, is that correct answer? Maybe NS could provide some links to the Oracle website right to the correct reference section?

Steve, first thing, is that not all tran types are exposed in WS. So you can't WS 100% of txns. I think this is it: nlapiSetFieldValue(fldnam, value, firefieldchanged, synchronous) The fieldname is called "customform" I think if that is null, then it uses the preferred form. If you set an actual value, then that actual…

Can't you sneak it into one of the company's unused address lines from Company Setup?

Try changing the preferred form to something else, saving, then changing it back to what you want, and saving. This will trigger whatever code they have behind the OnChange event and may fix the problem.

Here is the list of fields out of the ScriptSuite Reference Guide. These are the individual parsed fields: cashsale billaddress1 Billing Address 1 cashsale billaddress2 Billing Address 2 cashsale billaddressee Billing Addressee cashsale billattention Billing Attention cashsale billcity Billing City cashsale billcountry…

The phone# field in the address record only shows if you have Use Integrated Shipping function activated. That phone# is only used to print on FedEx or UPS labels. Yes, I agree it was stupid that they have the field and use it when printing the labels with the integrated shipping module, but then they don't use the field…

You can use a calculated field to contatenate the individual component fields of the address record. The fieldnames are in the docs, or they should be similiar to the fieldnames used in ODBC.

Can you just setup 2 different CC processors in NetSuite...then you assign the preferred CC processor to the customer record depending upon which website the customer was created from...and then it should work okay.... Or even easier, have your merchant bank set your merchant name to be your corporate name (for example,…

The merchant name is hard-coded by your merchant account acquirer. So you need 2 different MIDs for each name. There must be a way in NS to choose which account to use for each webstore.

Rick, also you have to be using one of these acquiring banks/processors for it to work: Supported processors: • American Express Direct • American Express Phoenix • Chase Paymentech Solutions • CyberSource Global Payment Service • FDI Global • FDMS South • GPN • OmniPay-Ireland

Currency drop-down worked fine for me. IE 6 on WinXPProSP2

NS can acutally use most of the set of Oracle 10g functions. NS only shows you a very small subset in the dropdown menu to pick the function. But actually many many more work just fine in NS. So if you do a Google search for Oracle 10g functions, you can find many more and just test them in the formula field manually to…

There are special HTML codes for Ampersand and some of the other special characters. The code for ampersand which you need to use in the URL is: & or the ASCII code: & #38; (remove the space after the ampersand--had to space it for NS UG) Reference: http://www.w3schools.com/HTML/html_entities.asp The EscapeXML function…

I would delete the J/E for the txns that are invoiced. That will be the easiest solution. Or you could write a more sophisticated import that creates separate files for J/E import, and a second file for Invoice import. You can import Invoices via the CSV import facility.

Why is the tax rate incorrect? That means your tax tables are not setup correctly. So you need to fix your tax tables so that the NS chooses the correct tax. If you are shipping mail order, then NS uses the zipcode of the ship to address to determine the tax rate per your tax tables. I think you may be able to override the…