You are viewing limited content. For full access, please sign in.

Question

Question

FORMS List Fields with Look Ups intermittently do not load

asked on January 27, 2017

This is intermittent and we simply need to Reload / Reconnect to the URL and it will Work.

I know there are a number of fixes in Update 1 regarding Look Up Fields but we have those updates.

I have experienced this at / for other implementations.

We do use an extensive number of Look Ups for  PO Form to pull in Suppliers, Cost Codes, etc.. using a combination of straight Look Up Rules, Views and Stored Procedures just wondering if there are any suggestions, common issues that may be causing this. 

Can not confirm or deny issues being reported in 9.2.1 as no current feedback but definitely now with 10.1.0.619. This Form was built is the 9 so using Java for calculations etc has not been rebuilt.

Perhaps could it be anything in the Java Code?

0 0

Replies

replied on January 27, 2017

$(document).ready(function() {

  $('.poassignradio input').on('click', function() {

     $('.pohidden input').val($(this).val()).trigger('change');

  });
  
});
// Set Tax Rate
$(document).ready(function() {

  $('.province input').on('click', function() {

     $('.taxrate input').val($(this).val()).trigger('change');

  });

});
// Calulate Item Cost and Subtotal for Line Items
$(document).ready(function () {
    $('.cf-table-block').on('blur', 'input', sumtotal);
    $('.subtotal').on('blur', 'input', sumtotal);
    $('.province').on('click', 'input', sumtotal);
    $('.province').on('blur', 'input', sumtotal);
    function sumtotal() {
        var sum = 0;
        var vtax = 0;
        var vtotal = 0;
        $('.cf-table-block tbody tr').each(function () {
            var s = 0;
            var p = 0;  
            p = parseNumber($(this).find('.price input').val());
          $(this).find('.price input').val((p).toFixed(2));
            s = parseNumber($(this).find('.price input').val()) * parseNumber($(this).find('.quantity input').val());
          $(this).find('.itemsubtotal input').val((s).toFixed(2));
            sum += s;
        });
        $('.itemsubtotal input').attr('readonly', 'True');
        $('.subtotal input').val((sum).toFixed(2));
        $('.subtotal input').attr('readonly', 'True');
        vtax = parseNumber($('.taxrate input').val()) * parseNumber($('.subtotal input').val());
        $('.tax input').val((vtax).toFixed(2));
        $('.tax input').attr('readonly', 'True');
        vtotal = parseNumber($('.tax input').val()) + parseNumber($('.subtotal input').val());
        $('.total input').val((vtotal).toFixed(2));
        $('.total input').attr('readonly', 'True');
    }
    function parseNumber(n) {
        var f = parseFloat(n); //Convert to float number.
        return isNaN(f) ? 0 : f; //treat invalid input as 0;
    }
});
$(document).ready(function () {
   function autofill() {
    $('.autofill').trigger('click');
  } 
  
  $('.lookupCondition').change(autofill);
  
});
  

0 0
replied on January 27, 2017

 

 

0 0
replied on January 27, 2017

Really a due diligence at the customers request to see if their are any obvious gotchas.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.