It seems like the default layout is like that whenever I enter a new address.

If you select the Use Permissions checkbox, then it DOES restrict permissions to only those specified, and you have to specify each role to grant permissions. Exactly... meaning if I have 50 user roles, I have to specify each role. Without restrict the user roles, they can search through the Global Search My goal is to NOT…

I have not been to many countries but ... can someone tell me which country is using the layout that I just mentioned for mailing?

For example, SELECT A.ID, A.needCertificate, B.ID, B.point FROM A LEFT JOIN B ON A.ID = B.ID WHERE A.needCertificate = 'YES' AND B.point > 10 How can I utilize the formula (text) in the criteria and results to make the search work like the SQL? All NetSuite experts, Hope someone can give me some tips how I can script the…

Hi, I am a problem because the joint has to include "all" from A and those with (matched ID/none) from custom records B But in NetSuite search, it shows only the records with matched ID, it does not show A if custom record B does not exist. Yet, I need to see A with "null" B on the result even though B does not exist. Hope…

All NetSuite experts, Hope someone can give me some tips how I can script the formula in a customer search for the following issue. A customer search already shows all of the customerID(A) who need certification. then I need to join this search with the same customerID(B) on a custom record, with some extra criteria…

Krish0nan's tip is great, unfortunitely migration of HR process at my work did not start because the numbers of Cost & Benefit did not look great to us. True thing is you need to consider the volume of the applicants you are expected and compare the volume againt the works you plan to input for this new HR process. If your…

Thanks for the tip, it is surprisingly helpful. But I am confused with one step you mentioned. How do you make an online submitted "CASE" become a "LEAD" ?? I thought a "LEAD" is a customer record. Other than the confusing step, I can tell you guys use a lot of scripts to copy the applicants data and paste into Employee…

Thanks a lot. I just check our Support Preference, and I can see that an online case can create a new "LEAD".... I think that is great, otherwise all of the applicant data will be going to the same dummy customer's record. Therefore, indeed, making a new LEAD is better. But I still want to double check with you. Without a…

Import/Export will allow you overwrite department. You need to use transcation internal ID as the primary index on matching. I was wondering if I could use mass update to update Sales Orders, Invoices, Cash Sales, & Credit Memos with certain criteria. I have actually set up the mass update search however the department…

I think you need to extrat the internal ID of a customer entity, and you can use the ID for linking of subrecord (phone call) and its related customer record. You can get the customer internal ID from the address bar when you view a customer record in NetSuite. I want to use the Internal ID to make sure the Phone Call is…

You probably need to do some filtering on system note table. Narrow your search on the table by record type, the record type should be Opportunity record. Filter system note "type" to "change", select MAX on the date, from here you should be able to filter more to see what you wanted. I have the ODBC connector so I have…

Importing of Address book in NetSuite is very tricky business.... you need to do a lot of testing of many scenarios on importing criteria to know what criteria you need to select when you want to ADD or Update customer entity ID needs to be the primary index on matching, then by selecting default billing, default shipping,…

how about not "any" files but a specific file name passed through the URL address on a suitelet script? Oh no, that is going to be impossible. Huge security issue. Can you imagine if browsers had the ability to pick up any file from your computer and read it? You will need to code a Web Services app if that is truly what…

Anyone knows what happened to this CSV automation ? Did it released ? Yes, WS is the best option right now. I would like to gauge general interest in automated CSV import processes. Please file enhancement requests and provide information on your use cases, including what kind of security you would like in place, if this…

Hi Olivier, Yes I found some programming tips on HELP related to triggering CSV import. Yet, I could not find any samples that allow Suitelet script pick up a CSV file at any directories. It seems like I have to upload the file manually. Do you know any commands that can do the auto local pickup and upload? Yup. There are…

what is the period of your fiscal year? This is a default setting that NetSuite have your latest fiscal year period opened.

Actually, each employee (NetSuite user) record has "File" and "User Note", you could have these for storing files and note taking... Record type works but using the built-in tools should be the first of your consideration. Hi All, after I create the "Record Type", how will I access it? I would need to create a form to…

Yep, record type is my favorite in NetSuite. Hi all, I am fairly new to NS. I was wondering if there is a way to have "Notes" on a per user account. I am giving support to internal users within the organization and ALL THE TIME I have to bring some special item number, or some special customer, or some special vendor, etc…

very true, custom record has a better permission and control settings. System notes are pretty handy to many users, but from memory unfortunately NS does not allow you to define different access to system notes & notes, only notes. So I think maybe what you want is a custom record.

Do you have any options to use HTML control on your web/cart? If you do, mark up the shipping method by using HTML control / custom fields first, then use event script to bring in the value and update the actual shipping method in NetSuite Hi, Is there a way to display one special shipping method based on cookie value in…