After Adding Fields to Line_items.js - Some Items are not saved

👨‍💻 Development Help
1

Hi all,

I’m using Suite in version 7.8.1 and i have added 29 custom fields to line_items.js.
Most of the fields come from aos_products after adding a product to the line_items.

All fields are in the AOS_Products_cstm and AOS_products_quotes_cstm available

I added all custom fields to the function insertProductLine into sqs_objects in line_items.js. Also i added them to the innerHTML like this:

   var bb = x.insertCell(10);
    bb.innerHTML = "<input type='hidden' style='width:1px;' class='sqsEnabled' autocomplete='off' type='text' name='product_manufacturer_c[" + prodln + "]' id='product_manufacturer_c" + prodln + "' maxlength='50' value='' title='' taindex='116' value=''>";

and at least to the function openProductPopup

Everything works fine. All Lines will be saved in the database and all lines are shown up in the Quotes and Invoives as well.

BUT i’m only able to save 10 line items. I can add as much as i want to the Quotes. But after saving the quotes only 10 lines are saved. Also without calculating the totals.
If i add and save only 9 lines, everything works perfekt. Totals will be calculated and all lines are saved in the DB.

If i delete one custom field from the function insertProductLine OR i uncomment one custom line from the innerHTML then im able to save 11 lines. and so on…

First i thought this might be a quite simple problem… But i’m not able to find this error. So maybe one of you are able to help me.

2

Hi buddy,
I am struggling for save custom field data in database.
I have no idea about save custom data.

One question is that, may I need to create custom field manually in database?

Please help me for saving custom data

3

Now I added dropdown from studio as well as in line_items.js file.

Now values are save in database but could not selected in edit mode

var z = tablebody.insertRow(-1);
z.id = ‘product_quote_form’ + prodln;

// valve type start
var type_opt = "Select typeBall Check ";

var a = z.insertCell(0);
a.colSpan = “2”;
a.style.color = “rgb(68,68,68)”;
a.innerHTML = " Type : ";

a.innerHTML = “Valve Type: “+ type_opt +””;

if (typeof currencyFields !== ‘undefined’){
currencyFields.push(“product_type_c” + prodln);
}

Please help me out from this