3944633 Newbie

I believe nlapiSetFieldValue(fieldName, value, firefieldchanged) now requires fireFieldChanged parameter (true or false). About the main question, isn't the job record now a "job" type record not customer? Hope that helps.

Ususlly the login and password for beta are not the current one, but as of a few days or a week ago (beta is a snapshot of your data). I suggest using the login and password from before your last change of password and/or email. I hope that works for you. :)

Angela, Considered using a Server Side Script to set the credit limit to $0 if no credit limit is entered? It would be a pretty simple script. Good luck. :)

I do not believe you can add a column field there, unfortunately. Have fun! :)

Evan, Thanks for the clarification. :)

Try using the following in your script just after the function starts: if (nlapiGetFieldValue('customform') != X ) return; X is the internal ID of the custom Estimate form. This says don't run if the form is not the custom form. Hope that helps. :)

I believe the field is 'rate' unless I missed something. Hope that helps :)

To see the internal ID: Home > Set Preferences, Defaults section, Check "Show Internal IDs", Save. Go to Setup > Customization > Transaction Forms. The internal ID will be to the left of the form name. Hope that helps. :)

You can certainly script. I think setting the roles to allow only create on employees will be sufficiant. You might create a search and alert on any creation of employees and access for your/administrator review. all changes to employee would then be by Administrator or other role. If you need for Manager to also edit…

1) Modify the employee record form to a) remove the access tab (and other tabs), b) make fields viewable but not changeable, c) remove fields from the form that you don't want users to see, d) assign and restrict that form to the roles. This means access needs to be set up by admin only. 2) Alternatively, give the user…

Mark, I believe that permission is to see a list of cases. That list of cases appears on a task record that can be accessed from the employee center. Cases may be created from the employee center for internal support only (if that is turned on). This case however is linked to the employee (not a company) and if the case is…

Receiving POs requires a "full" license in NetSuite. No way around it. Hope that helps. :) =r

Mort, Sound like you have the right idea. Possibly use a custom list to store the serial numbers for now to prevent duplication. I have not found a way to link serials in version 11.x.x but version 2007 appears to have possibilities in this area. Check an item search for a new serial number linkage if you are on 2007.0.5.…

Nate, The only way I have found is to either come up with short words (Qty Ord.), set the column width in the form customization, or set the font size to very small in the PDF layout. Hope that helps. =r

Matt, In 11.0.6 add space between items at Setup > Company > Setup Printing, Fax & Email. Check Add Extra Space Between Items. Also there is another place to set item spacing, if someone else can remind me as I have blanked on where (getting old I guess). :) Hope that helps. =r

With a little work, you can get MS Excel to output XML to import into NS. Probably could with Access too. I have only done it with Excel. I created a macro to turn a spreadsheet into XML using Excel's built-in XML functionality. Alternately, there are tools you can buy to import in NS (i. e. the Agent). I have also used…

That would be a correct assumption based on what you have said. In the normal course of business Employee relationship is all that is needed. In the unlikely event that you need to give a "1099" to the employee (tracked and printed from NetSuite), the employee would need to be a Vendor also (that practice is somewhat…

If you are not using Payroll, you can pay Employees via Expense Report or Write Check transactions. Also, using Write Check transaction to give expense advances (when written to the Advances Paid G/L account) will appear as advances to apply in the Expense Report transaction. Hope that helps. :)

You can, but that would entail a script or a web services application (think $). Have fun!

Perhaps: 1) Create a custom checkbox field on the customer record called "Export" or something like that. 2) Create a csv file with the 1691 ids, one on each line. 3) Do a Customer update csv import, match on ID. Set custom field to true. 4) Create a search for Customers where "Export" = true with the field you want.…

You should have fun with this one. Basically, I believe that everything that is not view only is exportable. I may be mistaken, but if at least "create" level is available, you can export a list of that record. Also note that I can screen grab or screen scrape all the data on any screen/list/report I can see and paste it…

Sara, Also others have solutions. Epiphony has eXL (www.epiphony.net) and CELIGO (celigo.com) also has a solution. Also check Boomi (www.boomi.com). I understand from Paul that he is no longer selling The Agent. I'm not sure what these solutions cost. You can also create an Excel file that will create the Bills xml file…

Sara, Bills may be imported via xml import into NetSuite. Not too difficult. :D Also there is a program "The Agent" that will take a .csv file and export into xml for NetSuite. Good luck! :)

A Contact import wants the field "Contact" mapped (First Mid. Last) or the Internal ID to associate the custom field field with the record. I recommend mapping Internal ID. To get the Internal ID, add that field in your Contact search/list and export that. Hope that helps. :)

Sara, Email Paul at pforsyth@ncompasssolutions.com about "The Agent".

We have created several solutions to handle this. 1) email a text, Excel, or csv file to an email address such as orders@YourCompanyName.com, order is retrieved and processed, 2) process queries an external database, extracts order data, processes order, 3) process retrieves a csv/text file from an FTP site, extracts the…

You will be able to create a Group of Contacts that are based on Other Name type using a Contact Search where Company fields: Type = Other Name. Contacts attached to Other Name "Companies" will appear and Other Name "Individual" types will also appear in the Group. Be sure to set the Marketing preference to Soft Op-in on…

There is not a button to update open SO pricing that I am aware of, unless the SOs are memorized transactions. Update prices is allowed on memorized transactions. You will likely need to find the open SO lines via transaction search, download them, change the prices in the spreadsheet and import the new lines (overwrite…

On memorized transactions, it is a check box on the memorized transaction scheduling dialog, something like "Update Prices". Transactions > Management > Enter Memorized Transactions > List, then edit a memorized transaction. Re-importing/updating SOs is not so bad if your SOs only have a few items each. Hope that helps. :)

The following is a snippit of xml that imports 2 open invoices on 6/30/08. This asssumes an item "Opening AR Balances" exists that points to you A/R offset account as its revenue account. Each section enclosed between <request> sections is for 1 invoice. There are a number of programs that will produce this xml file (you…