Hi, In this post we are going to learn accessing workbook in script . We already cover Data Set and Workbook in our previous post, click on this link to read . To use workbook in script, you should use " N/query " module. We can query Workbook using Query APIs . Lets go to step by step process of using Query Module Step 1: Script should use " N/query " module and use query as parameter   ( You can use parameter name as you like) . Step 2: Copy workbook internal id. Step 3: Use "query.load" api and use internal id from step 2. var mLoadedquery= query.load({                         id: 'custworkbook_your_id_here'                     });  Step 4: Run loaded query  var resultSet = mLoadedquery.run(); Step 5: Access workbook column data in script. You can either iterator using iterator() or use for loo...

Hi All, If you print Payment Receipt and find that Address is not there , then reason may be there is no default billing address on customer record. What to Do: Go to Customer Record. Click On Address Tab and Add Default billing Address by clicking default checkbox . You can add default shipping also if you want . Save the record. Same you can do for Vendor Also . Thanks Abhi

Hi All, As we all know server side script can not run on client side, it means inside client script we can not use that, Some times we want to do some specific task and that need server side programming , now question is how to run server side api on client, I can tell you how to run server side script on client side, but this do not mean I am going to use Server Side api directly in client side and run. No this is not a case. As we all know Suitelets can be used for Showing data as well as transferring data. So we can use suitelets and using suitelet we can run our server side logic. For Example: you want to delete a file on click of a button, you want to use "nlapiDeleteFile" but this is server side programming, Now what you should do to achieve this functionality , write a suitelet where fid is parameter value, get value and delete that file and return appropiate methods. If it fails return false if pass return true. Do not forget to use try catch and inside catch return...

Hi, Are you getting error in Fixed Asset Module after new release, chances are that you did not configured role properly. What to Do: Add Permissions How to Add Permission: Go to Users/Roles -> Manage Roles -> Edit Custom Role ->Permissions ->Custom Record -> Add New Permissions FAM Asset Values=Full FAM Process=Full FAM Transaction Field Map=Full After these changes user can create Assets. Please let me know if you still see error or you have any better way to do this. Thanks Abhi

Hi All, Pupose: Create an Item Saved search that indicates whether an item is a matrix child -->Go to Lists > Search > Saved Searches > New -->Click on the Results tab > open Columns, add the Formula Text Field: Use Formula  "CASE WHEN {parent} is not null then 'Yes' else 'No' END"** You can give the Label you want or simply "Matrix Child " --Click Save & Run. You will see in search result those items which are Matrix Child will come as Yes and other will come as No. ** Netsuite uses PL/SQL for formula in Saved Searches. If you want return type as Text use Formula Text else you have to use other type of formula. Thanks Abhi

Hi All, Some times we want to show Bin Number on Picking Tickets but this functionality is not working for Advance PDF layout, Netsuite don't have this functionality so administrator need help of Developer for this. Procedure: Create a Custom Transaction Column Field on Transaction record Apply to the record type where you want lets say Sales Order Write a User Event Script which will get Bin Number from standard field and populate on new Traction Column Field , Apply User Event script to desired record type. Script will calculate Bin Number for each line and populate on custom traction column field. Have the Advanced PDF Layout for Picking Tickets print the custom column field. Please comment below if you have any query. Thanks Abhi

Hi All, When a custom record gets updated there are 2 fields which we need mostly, 1. Modified By 2. Modified Date if you check help notes there is no clear information about these 2 fields for custom record but these field exist for custom record also. If you need last modifed date and time use "lastmodified". if you need last modified by then use "lastmodifiedby" , If you are not able to find any standard field on custom record or any record then please comment I will try to help you in that. Thanks Abhi #Netsuite Guru