mg2017
04/03/2022, 11:58 PMconst item_count = current_record.getLineCount({
sublistId: 'item'
});
const tax_item = '28709';
var sugar_tax = 0.025;
var item_quantity_sum = 0;
var item_amount_sum = 0;
for (var i = 0; i < item_count; i++) {
const item_id = current_record.getSublistValue({
sublistId: 'item',
fieldId: 'item',
line: i
})
const add_tax = current_record.getSublistValue({
sublistId: 'item',
fieldId: 'custcol_add_sugar_tax',
line: i
})
if (add_tax == true) {
var item_quantity = current_record.getSublistValue({
sublistId: "item",
fieldId: "quantity",
line: i
});
var item_amount = current_record.getSublistValue({
sublistId: "item",
fieldId: "amount",
line: i
});
item_quantity_sum += parseFloat(item_quantity);
item_amount_sum += parseFloat(item_amount);
} else {
log.debug("Sugar Tax NOT Checked");
}
} //End Loop
log.debug("Insert Line");
log.debug({title: "Quantity Sum", details: item_quantity_sum});
log.debug({title: "Amount Sum", details: item_amount_sum});
current_record.insertLine({
sublistId: "item",
line: item_count + 1
});
current_record.setSublistValue({
sublistId: "item",
fieldId: "item",
line: item_count + 1,
value: tax_item,
});
current_record.setSublistValue({
sublistId: "item",
fieldId: "quantity",
line: item_count + 1,
value: 1,
});
const total_sugar_tax = item_amount_sum * sugar_tax
log.debug({title: "Total Sugar Tax", details: total_sugar_tax});
current_record.setSublistValue({
sublistId: "item",
fieldId: "amount",
line: item_count + 1,
value: total_sugar_tax
});
battk
04/04/2022, 3:21 AMmg2017
04/04/2022, 4:24 AMbattk
04/04/2022, 6:58 AMmg2017
04/04/2022, 8:43 AMbattk
04/04/2022, 8:44 AMmg2017
04/04/2022, 9:37 AM