Contact Us

Hi All,

If you need any help in Netsuite or have any question related to netsuite,
Please contact us using below URL.






Click Here and Submit


Thanks
Netsuite Guru

Comments

  1. Hi, can you help me?
    Im new in SS2.0, Im trying to execute a search.
    But get error in next columns:
    -basecurrency
    -transactionnumber
    of a multi-book accounting transaction search
    Thanks in advance, are you from México??

    ReplyDelete
  2. Hi,
    I am from India,
    isbasecurrency is available in search,
    Can you provide your code so that I can reuse it, also on which record type your search is,
    is it on whole transaction record type or any particular like Sales Order, Invoice etc

    Thanks
    Abhi

    ReplyDelete
  3. Can you help me how to prepare for Foundation certification.

    ReplyDelete
    Replies
    1. Hi Ranga,
      I don't have questions for Foundation Certification , But I can suggest please go throw all topics mentioned in syllabus and there will be few question which have more than 1 answers. these are actually tough question.
      you can share any topic or question, I will try to answer.
      All D Best for Exam,

      Delete
  4. Sir i am an electronic student and from last 1 year working in Netsuite. Will you please write something on future for Netsuite sensing guys like me who are new to domain can get more clarity if we should make a career ahead in netsuite domain.

    ReplyDelete
    Replies
    1. Hi Gaurav,
      Sure I will write about one's future in Netsuite , also I want to assure you that you are in correct domain .
      Thanks for following me. You can download Android app(right now only android :) ). I am developing discussion panel also to keep everything in one place and get maximum benefit from it.

      thanks
      Abhi

      Delete
    2. Hi Gaurav,
      please have a look here. I will update this page frequently.

      Delete
  5. Need to load data into a suitelet tab on a field change. How it is possible?

    ReplyDelete
    Replies
    1. If I understand correctly , you want to load some data on field change into a tab which is created by Suitelet?
      You can also ask using android app if you are android user.
      click to download

      If I understand correctly, you can not do on field change but you can update suitelet to show on view mode and use values which are in fields and populate in suitelet tab.

      Please explain more if I am wrong in understanding question.

      I hope this will solve you problem.
      Thanks
      Abhi

      Delete
  6. Anyone know how to validate relationships betweeen customers and contacts. The relationship happens without having to save the form, and it doesn't trigger client side sublist changed or validation functions.

    Thanks

    ReplyDelete
    Replies
    1. Hi there,
      as you are writing CS on Customer record validations are not happening, deploy your script on Contact record, and use Company field for finding parent.
      let us know if this solve your problem.

      Delete
    2. Thank for reply,

      Tried record level scripts with no success. We have relationship sublists I am trying to validate when we click an 'attach' button which assigns the relationship between either a customer or contact. The relationship sublist ids seem to be contactroles or company, but the relationship occurs without validation and without having to save the form.

      Delete
    3. Hi Matt,
      thanks for explaining, as you are trying to use button which is on form (using native Netsuite functionality), it is not calling any of CS functions,
      I checked and found that there is a function "add_contact" which Netsuite is using so you can override/insert with your code.
      please see below below post for reference.
      http://netsuiteguru.blogspot.com/2016/10/how-to-open-alertdialog-box-on-clicking.html

      I hope this will solve your problem.
      let me know also

      Thanks
      Netsuite Guru

      Delete
    4. This comment has been removed by the author.

      Delete
    5. So I have it overriding the function in 1.0 scripts, but the args parameter is now undefined so it doesn't end up adding the contact.

      Delete
    6. you can remove args if not needed. please try after removing,
      I am happy that this logic is working for you. this is something out of box which Netsuite never suggest.
      Thanks
      Netsuite Guru

      Delete
    7. Yup, removing the args worked.

      Delete
    8. Its like its a seperate form inside the customer form for relationships. You can add contact even in the view mode of the customer form.

      Delete
    9. yes, that is why script is not getting triggered. so when we use our script to override function it add over logic on top of their logic.
      Happy that logic works for you.

      Delete
  7. Hi, I am sending multiple records in array through Json to create record in NetSuite using restlet but I am getting error "org.mozilla.javascript.Undefined@58f0ee50" while it is working fine with the single request.
    I am new in scripting so I don't know how can be resolve this.

    Below is my code:

    function search_data(datain)
    {
    var current_Subsidiary = nlapiGetSubsidiary();
    if (current_Subsidiary == 1)//1:"d.light Energy Pvt. Ltd."(India )
    {
    if (datain.recordtype == 'aggregatorsale')
    {
    if (datain.operation == 'create') {
    nlapiLogExecution('DEBUG', 'aggregatorsale create req', JSON.stringify(datain));
    var o_search_result = create_aggregatorsale(datain);
    nlapiLogExecution('DEBUG', 'create_aggregatorsale', datain.recordtype + ' o_search_result=====' + JSON.stringify(o_search_result));
    return o_search_result;

    }
    else{
    var o_search_result = update_sale(datain);
    nlapiLogExecution('DEBUG', 'update_sale', datain.recordtype + ' o_search_result=====' + JSON.stringify(o_search_result));
    return o_search_result;
    }

    }

    }
    }



    function create_aggregatorsale(datain) {
    nlapiLogExecution('DEBUG', 'create_aggregatorsale', JSON.stringify(datain));

    var rec = nlapiCreateRecord("customrecord_aggregator_sale",{ recordmode: 'dynamic' });

    rec.setFieldValue('custrecord_as_state', datain.state);
    rec.setFieldValue('custrecord_as_region', datain.region);
    rec.setFieldValue('custrecord_as_batch_date', datain.batch_date);
    rec.setFieldValue('custrecord_as_branchid', datain.brachid);
    rec.setFieldValue('custrecord_as_branch_name', datain.branch_name);
    rec.setFieldValue('custrecord_as_loanid', datain.loanid);


    var recId = nlapiSubmitRecord(rec, true, true);
    var o_succss_obj = new Object();

    if (recId > 0) {
    o_succss_obj.Message = "Created Sucessfully";
    o_succss_obj.recordid = recId;

    } else {
    o_succss_obj.Message = "Failed";
    o_succss_obj.recordid = null;
    }

    return responseObjectArray;

    }

    function update_sale(datain) {
    var rec = nlapiLoadRecord("customrecord_aggregator_sale", datain.recordId);
    rec.setFieldValue('custrecord_as_state', datain.state);
    rec.setFieldValue('custrecord_as_region', datain.region);
    rec.setFieldValue('custrecord_as_batch_date', datain.batch_date);
    rec.setFieldValue('custrecord_as_branchid', datain.brachid);
    rec.setFieldValue('custrecord_as_branch_name', datain.branch_name);
    rec.setFieldValue('custrecord_as_loanid', datain.loanid);


    var recId = nlapiSubmitRecord(rec);
    var o_succss_obj = new Object();

    if (recId > 0) {
    o_succss_obj.Message = "updated Sucessfully";
    o_succss_obj.recordid = recId;

    } else {
    o_succss_obj.Message = "Failed";
    o_succss_obj.recordid = null;
    }

    return o_succss_obj;

    }

    ------------------------------------------------------------------------------------------------------------
    Below is Json Request:

    [
    {
    "operation": "create",
    "recordtype":"salesorder"
    "state": "Maharashtra",
    "trandate": "09/09/2020",
    "custbody_cseg_dlight_branch": "25:04",
    "custbody_brnch_name": "Sonpeth",
    "custbody_loan_id": "5114509000011054"
    },
    {
    "operation": "create",
    "recordtype":"salesorder"
    "state": "Maharashtra",
    "trandate": "09/09/2020",
    "custbody_cseg_dlight_branch": "25:05",
    "custbody_brnch_name": "Digwara",
    "custbody_loan_id": "5114509000011053"
    }
    ]

    ReplyDelete
    Replies
    1. Hi Yogendra,
      Looklike issue is with accessing loop.
      Please check if script is able to read till last value in array.
      Add debug inside array loop and use try catch. that way even if it throw error , it will process remaining record.
      let us know once you test this way

      Delete
  8. I am new in scripting and don't know how can it be done. Can you please changes my script.

    ReplyDelete
  9. Hi Netsuite Guru,

    This inquiry is intended for your marketing team.
    Since NetSuite is one of your core areas of expertise, I was wondering if you would be interested in acquiring a targeted list of:
    1. NetSuite users
    2. MS Dynamics users
    3. Sage users
    4. SAP ERP users
    We can customize this target audience by company size, location, job titles (Finance, Accounting, ERP related users).
    Please send me an email so that I can send you detailed information on this.

    Greetings
    Paige Larson
    Demand Generation
    Global Database

    ReplyDelete

Post a Comment

Thanks for you message, please join us on Facebook and Linkedin