NetSuite Client Script fieldChanged using old item values









up vote
1
down vote

favorite












I made a simple client script following this logic: Once a new item is added or an item is changed to a new item, the Gross Margin will be auto calculated and added to the corresponding field for that item. The problem I am having is that fieldChanged is giving me the old (or undef.) sublist values for that item as if it hadn't changed yet. Is there a way to tell NetSuite to, after the item is changed, wait for its corresponding sublist values to update before populating the values with fieldChanged? Thanks!



function fieldChanged(context) 
var currentRecord = context.currentRecord;
var sublistName = context.sublistId;
var sublistFieldName = context.fieldId;
var line = context.line;

if (sublistName === 'item' && sublistFieldName === 'item')
var costrateestimate = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'costestimaterate');
var amount = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'amount');
var quantity = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity');
var grossPerc = Math.round((1-(costrateestimate/amount*quantity))*100);

log.debug("Gross Margin Calculated = 100 - ("+costrateestimate+" / "+amount+" * "+currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity')+") = "+grossPerc+"%");

currentRecord.setCurrentSublistValue(
sublistId: sublistName,
fieldId: 'custcol_gross_margin_perc',
value: grossPerc
);











share|improve this question

























    up vote
    1
    down vote

    favorite












    I made a simple client script following this logic: Once a new item is added or an item is changed to a new item, the Gross Margin will be auto calculated and added to the corresponding field for that item. The problem I am having is that fieldChanged is giving me the old (or undef.) sublist values for that item as if it hadn't changed yet. Is there a way to tell NetSuite to, after the item is changed, wait for its corresponding sublist values to update before populating the values with fieldChanged? Thanks!



    function fieldChanged(context) 
    var currentRecord = context.currentRecord;
    var sublistName = context.sublistId;
    var sublistFieldName = context.fieldId;
    var line = context.line;

    if (sublistName === 'item' && sublistFieldName === 'item')
    var costrateestimate = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'costestimaterate');
    var amount = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'amount');
    var quantity = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity');
    var grossPerc = Math.round((1-(costrateestimate/amount*quantity))*100);

    log.debug("Gross Margin Calculated = 100 - ("+costrateestimate+" / "+amount+" * "+currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity')+") = "+grossPerc+"%");

    currentRecord.setCurrentSublistValue(
    sublistId: sublistName,
    fieldId: 'custcol_gross_margin_perc',
    value: grossPerc
    );











    share|improve this question























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I made a simple client script following this logic: Once a new item is added or an item is changed to a new item, the Gross Margin will be auto calculated and added to the corresponding field for that item. The problem I am having is that fieldChanged is giving me the old (or undef.) sublist values for that item as if it hadn't changed yet. Is there a way to tell NetSuite to, after the item is changed, wait for its corresponding sublist values to update before populating the values with fieldChanged? Thanks!



      function fieldChanged(context) 
      var currentRecord = context.currentRecord;
      var sublistName = context.sublistId;
      var sublistFieldName = context.fieldId;
      var line = context.line;

      if (sublistName === 'item' && sublistFieldName === 'item')
      var costrateestimate = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'costestimaterate');
      var amount = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'amount');
      var quantity = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity');
      var grossPerc = Math.round((1-(costrateestimate/amount*quantity))*100);

      log.debug("Gross Margin Calculated = 100 - ("+costrateestimate+" / "+amount+" * "+currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity')+") = "+grossPerc+"%");

      currentRecord.setCurrentSublistValue(
      sublistId: sublistName,
      fieldId: 'custcol_gross_margin_perc',
      value: grossPerc
      );











      share|improve this question













      I made a simple client script following this logic: Once a new item is added or an item is changed to a new item, the Gross Margin will be auto calculated and added to the corresponding field for that item. The problem I am having is that fieldChanged is giving me the old (or undef.) sublist values for that item as if it hadn't changed yet. Is there a way to tell NetSuite to, after the item is changed, wait for its corresponding sublist values to update before populating the values with fieldChanged? Thanks!



      function fieldChanged(context) 
      var currentRecord = context.currentRecord;
      var sublistName = context.sublistId;
      var sublistFieldName = context.fieldId;
      var line = context.line;

      if (sublistName === 'item' && sublistFieldName === 'item')
      var costrateestimate = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'costestimaterate');
      var amount = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'amount');
      var quantity = currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity');
      var grossPerc = Math.round((1-(costrateestimate/amount*quantity))*100);

      log.debug("Gross Margin Calculated = 100 - ("+costrateestimate+" / "+amount+" * "+currentRecord.getCurrentSublistValue(sublistId: sublistName,fieldId: 'quantity')+") = "+grossPerc+"%");

      currentRecord.setCurrentSublistValue(
      sublistId: sublistName,
      fieldId: 'custcol_gross_margin_perc',
      value: grossPerc
      );








      netsuite suitescript suitescript2.0






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 9 at 20:19









      Nick

      227




      227






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          1
          down vote



          accepted










          Figured it out! I needed to use the postSourcing entry point instead of fieldChanged...






          share|improve this answer




















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













             

            draft saved


            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53232769%2fnetsuite-client-script-fieldchanged-using-old-item-values%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            1
            down vote



            accepted










            Figured it out! I needed to use the postSourcing entry point instead of fieldChanged...






            share|improve this answer
























              up vote
              1
              down vote



              accepted










              Figured it out! I needed to use the postSourcing entry point instead of fieldChanged...






              share|improve this answer






















                up vote
                1
                down vote



                accepted







                up vote
                1
                down vote



                accepted






                Figured it out! I needed to use the postSourcing entry point instead of fieldChanged...






                share|improve this answer












                Figured it out! I needed to use the postSourcing entry point instead of fieldChanged...







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 9 at 20:52









                Nick

                227




                227



























                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53232769%2fnetsuite-client-script-fieldchanged-using-old-item-values%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Use pre created SQLite database for Android project in kotlin

                    Darth Vader #20

                    Ondo