The client needs to create IF, Invoice and Payment Records from sales orders. The sales order details was given in CSV file and Inventory setup was need to do in IF.
/**
* @NApiVersion 2.1
* @NScriptType MapReduceScript
*/
define(['N/record', 'N/search','N/file','/SuiteScripts/Jobin and Jismi/RLPL-143 IF_INV_Payment Automation/papaparse.min.js'],
/**
* @param{record} record
* @param{search} search
*/
(record, search,file,papa) => {
/**
* Defines the function that is executed at the beginning of the map/reduce process and generates the input data.
* @param {Object} inputContext
* @param {boolean} inputContext.isRestarted - Indicates whether the current invocation of this function is the first
* invocation (if true, the current invocation is not the first invocation and this function has been restarted)
* @param {Object} inputContext.ObjectRef - Object that references the input data
* @typedef {Object} ObjectRef
* @property {string|number} ObjectRef.id - Internal ID of the record instance that contains the input data
* @property {string} ObjectRef.type - Type of the record instance that contains the input data
* @returns {Array|Object|Search|ObjectRef|File|Query} The input data to use in the map/reduce process
* @since 2015.2
*/
const getInputData = (inputContext) => {
try{
var uploadFile = file.load({id:28255923});
var file_contents = uploadFile.getContents();
log.debug("file contents", file_contents);
var newValue = papa.parse(file_contents, {
header: true,
skipEmptyLines: true
});
log.debug("newValue", newValue)
return newValue.data.map(el => {
el.customRecInternalId = 1;
return el
});
}
catch(e){
log.error("error@getInput",e)
}
}
/**
* Defines the function that is executed when the map entry point is triggered. This entry point is triggered automatically
* when the associated getInputData stage is complete. This function is applied to each key-value pair in the provided
* context.
* @param {Object} mapContext - Data collection containing the key-value pairs to process in the map stage. This parameter
* is provided automatically based on the results of the getInputData stage.
* @param {Iterator} mapContext.errors - Serialized errors that were thrown during previous attempts to execute the map
* function on the current key-value pair
* @param {number} mapContext.executionNo - Number of times the map function has been executed on the current key-value
* pair
* @param {boolean} mapContext.isRestarted - Indicates whether the current invocation of this function is the first
* invocation (if true, the current invocation is not the first invocation and this function has been restarted)
* @param {string} mapContext.key - Key to be processed during the map stage
* @param {string} mapContext.value - Value to be processed during the map stage
* @since 2015.2
*/
// const map = (mapContext) => {
// }
/**
* Defines the function that is executed when the reduce entry point is triggered. This entry point is triggered
* automatically when the associated map stage is complete. This function is applied to each group in the provided context.
* @param {Object} reduceContext - Data collection containing the groups to process in the reduce stage. This parameter is
* provided automatically based on the results of the map stage.
* @param {Iterator} reduceContext.errors - Serialized errors that were thrown during previous attempts to execute the
* reduce function on the current group
* @param {number} reduceContext.executionNo - Number of times the reduce function has been executed on the current group
* @param {boolean} reduceContext.isRestarted - Indicates whether the current invocation of this function is the first
* invocation (if true, the current invocation is not the first invocation and this function has been restarted)
* @param {string} reduceContext.key - Key to be processed during the reduce stage
* @param {List<String>} reduceContext.values - All values associated with a unique key that was passed to the reduce stage
* for processing
* @since 2015.2
*/
const reduce = (reduceContext) => {
try{
let result = JSON.parse(reduceContext.values);
log.debug("result",result)
let docNum= result['Document Number'];
log.debug("docNum",docNum)
if(docNum == 'SOFIBE41430'){
let InternalId = result['Internal ID'];
let ifRec= record.transform({
fromType: record.Type.SALES_ORDER,
fromId: InternalId,
toType: record.Type.ITEM_FULFILLMENT,
isDynamic: false,
});
let salesRec = record.load({
type: 'salesorder',
id: InternalId
});
let date= salesRec.getText({fieldId: 'trandate'})
log.debug("ifRec",ifRec);
let lineCount = ifRec.getLineCount({sublistId: 'item'});
log.debug("line count",lineCount);
let lotNumber = ''
for(let i=0;i<lineCount;i++){
let item= ifRec.getSublistValue({sublistId: 'item',fieldId: 'itemname',line: i});
log.debug("item",item);
let itemChild1 = result['Child Item 1'];
let itemChild2 = result['Child Item 2']
let itemChild3 = result['Child Item 3']
let itemChild4 = result['Child Item 4'];
let itemChild5 = result['Child Item 5'];
if(item == itemChild1){
lotNumber = result['Lot Number Child 1'];
}else if(item == itemChild2){
lotNumber = result['Lot Number Child 2'];
}else if(item == itemChild3){
lotNumber = result['Lot Number Child 3'];
}else if(item == itemChild4){
lotNumber = result['Lot Number Child 4'];
}else if(item == itemChild3){
lotNumber = result['Lot Number Child 5'];
}
let inventoryDetail = ifRec.getSublistValue({
sublistId: 'item',
fieldId: 'inventorydetailavail',
line: i
});
if(inventoryDetail !='F'){
log.debug("inventoryDetails",inventoryDetail);
let subRec= ifRec.getSublistSubrecord({
sublistId: 'item',
fieldId: 'inventorydetail',
line: i
});
let quantity = ifRec.getSublistValue({
sublistId: 'item',
fieldId: 'quantity',
line: i
})
log.debug("subREc",subRec);
let subLine=subRec.getLineCount({
sublistId: 'inventoryassignment',
})
log.debug("sublistLne",subLine+" item :"+item);
//for(let j=0;j<subLine;j++){
let invent=subRec.setSublistText({
// sublistId: 'inventoryassignment',
// fieldId: 'issueinventorynumber ',
// line: j
sublistId: 'inventoryassignment',
fieldId: 'issueinventorynumber',
text: lotNumber,
line: 0
});
subRec.setSublistValue({
// sublistId: 'inventoryassignment',
// fieldId: 'issueinventorynumber ',
// line: j
sublistId: 'inventoryassignment',
fieldId: 'quantity',
value: quantity,
line: 0
});
log.debug("invent",invent)
//}
}
}
ifRec.setText({fieldId: 'trandate',text: date})
let ifRecId= ifRec.save();
log.debug("ifRecId",ifRecId)
let invoiceRec = record.transform({
fromType: record.Type.SALES_ORDER,
fromId: InternalId,
toType: record.Type.INVOICE,
isDynamic: false,
});
invoiceRec.setText({fieldId: 'trandate',text: date})
let invId = invoiceRec.save();
log.debug("invId",invId)
let custRec = record.transform({
fromType: record.Type.INVOICE,
fromId: invId,
toType: record.Type.CUSTOMER_PAYMENT,
isDynamic: false,
});
custRec.setText({fieldId: 'trandate',text: date});
custRec.setValue({
fieldId: 'account',
value: 122
})
let custId= custRec.save();
log.debug("custId",custId)
}
}
catch(e){
log.error("error@reduce",e)
}
}
/**
* Defines the function that is executed when the summarize entry point is triggered. This entry point is triggered
* automatically when the associated reduce stage is complete. This function is applied to the entire result set.
* @param {Object} summaryContext - Statistics about the execution of a map/reduce script
* @param {number} summaryContext.concurrency - Maximum concurrency number when executing parallel tasks for the map/reduce
* script
* @param {Date} summaryContext.dateCreated - The date and time when the map/reduce script began running
* @param {boolean} summaryContext.isRestarted - Indicates whether the current invocation of this function is the first
* invocation (if true, the current invocation is not the first invocation and this function has been restarted)
* @param {Iterator} summaryContext.output - Serialized keys and values that were saved as output during the reduce stage
* @param {number} summaryContext.seconds - Total seconds elapsed when running the map/reduce script
* @param {number} summaryContext.usage - Total number of governance usage units consumed when running the map/reduce
* script
* @param {number} summaryContext.yields - Total number of yields when running the map/reduce script
* @param {Object} summaryContext.inputSummary - Statistics about the input stage
* @param {Object} summaryContext.mapSummary - Statistics about the map stage
* @param {Object} summaryContext.reduceSummary - Statistics about the reduce stage
* @since 2015.2
*/
const summarize = (summaryContext) => {
}
return {getInputData, reduce, summarize}
});