Hi There
I am trying to use a map reduce script to create a sales order record using the values from a saved search
The script appears to work correctly until it gets to the reduce stage.
There, all of the log debug parts of the script return a value other than the last one of :
if (salesOrderId) {
log.debug("Sales Order ID", salesOrderId);
} else {
log.debug("Failed to create Sales Order");
This does not log anything at all
The rest of the script
* @param {MapReduceContext.reduce} context
*/
function reduce(context) {
log.debug("reduce context", context);
var values = context.values;
log.debug("context.values", values);
var entity = context.key;
log.debug("context.key", entity);
log.debug("values.length", values.length);
for (var i = 0; i < values.length; i++) {
var jsonStr = values[i];
log.debug("jsonstr", jsonStr);
var entityData = JSON.parse(jsonStr);
var salesOrderRec = record.create({
type: record.Type.SALES_ORDER,
isDynamic: true,
});
log.debug({
title: "salesOrderRec",
details: salesOrderRec,
});
for (var entity in entityData) {
if (entityData.hasOwnProperty(entity)) {
//If the condition entityData.hasOwnProperty(entity) evaluates to true, it means that the current property('entity') belongs directly to the entityData object, and further operations can be performed on it.
var items = entityData[entity];
for (var j = 0; j < items.length; j++) {
var itemData = items[j];
// Access individual values and set them as variables
var item = itemData.item;
var quantity = itemData.quantity;
var rate = itemData.rate;
var amount = itemData.amount;
var taxamount = itemData.taxamount;
var taxcode = itemData.taxcode;
log.debug("item:", item);
log.debug("quantity:", quantity);
log.debug("rate:", rate);
log.debug("amount:", amount);
log.debug("taxamt:", taxamount);
salesOrderRec.setValue({
fieldId: "entity",
value: entity, // set customer ID here
});
salesOrderRec.setSublistValue({
//set item field
sublistId: "item",
fieldId: "item",
line: j,
value: item,
});
salesOrderRec.setSublistValue({
//set item field
sublistId: "item",
fieldId: "taxcode",
line: j,
value: taxcode,
});
salesOrderRec.setSublistValue({
sublistId: "item",
fieldId: "quantity",
line: j,
value: quantity, /
});
salesOrderRec.setSublistValue({
sublistId: "item",
fieldId: "rate",
line: j,
value: rate, /
});
salesOrderRec.setSublistValue({
sublistId: "item",
fieldId: "taxamt",
line: j,
value: taxamt, /
});
salesOrderRec.commitLine({
sublistId: "item",
});
var salesOrderId = salesOrderRec.save();
if (salesOrderId) {
log.debug("Sales Order ID", salesOrderId);
} else {
log.debug("Failed to create Sales Order");
}
}
}
}
}
}