pen one
09/21/2020, 4:37 PMbattk
09/21/2020, 4:39 PMbattk
09/21/2020, 4:39 PMpen one
09/21/2020, 4:41 PMpen one
09/21/2020, 4:42 PMpen one
09/21/2020, 4:44 PMfunction bkWeightCalc(type, name){
if ((type == 'recmachcustrecord_dims_so') && ((name == 'custrecord_dims_quantity' ) || (name == 'custrecord239'))) {
var qty = parseFloat(nlapiGetCurrentLineItemValue('recmachcustrecord_dims_so', 'custrecord_dims_quantity'));
var weight = parseFloat(nlapiGetCurrentLineItemValue('recmachcustrecord_dims_so', 'custrecord239'));
if (qty > 0) {
var ttlweight = qty * weight;
}
else {
}
nlapiSetCurrentLineItemValue('recmachcustrecord_dims_so', 'custrecord240', ttlweight);
}
};
pen one
09/21/2020, 4:45 PM/**
*@NApiVersion 2.0
*@NScriptType ClientScript
*/
define(['N/record','N/search', 'N/ui/dialog'], function (r,search,u) {
function fieldChanged2(context) {
var recCurrent = context.currentRecord;
if ((context.fieldId == 'custbody_select_contact_final')||(context.fieldId == 'custbody_select_venue_final')||(context.fieldId == 'custbody_select_agent_consol_final')||(context.fieldId == 'custbody_address_label_final')) {
var myContact = recCurrent.getValue({ fieldId: 'custbody_select_contact_final'});
var myVenue = recCurrent.getValue({ fieldId: 'custbody_select_venue_final'});
var myConsol = recCurrent.getValue({ fieldId: 'custbody_select_agent_consol_final'});
var myOther = recCurrent.getValue({ fieldId: 'custbody_select_other_customer_final'});
var myAddressId = recCurrent.getText({ fieldId: 'custbody_address_label_final'});
var addressSource = recCurrent.getText({ fieldId: 'custbody_final_address_source'});
var pickupAddress = recCurrent.getField({ fieldId: 'custbody_final_delivery_address'});
if (addressSource == "Select Via Contact Name") {
recCurrent.getField({ fieldId: 'custbody_select_venue_final'}).isDisplay = false;
var s = search.create({
type: search.Type.CONTACT,
columns: [
search.createColumn({name: "address"}),
search.createColumn({name: "entityid"}),
search.createColumn({name: "phone"})
],
filters : [['internalid', 'is', myContact]]
});
var pagedData = s.runPaged({pageSize: 1000});
// iterate the pages
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach( function(result) {
// you have the result row. use it like this....
var address = result.getValue('address');
var ctcname = result.getValue('entityid');
var ctcphone = result.getValue('phone');
recCurrent.setValue({ fieldId: 'custbody_final_delivery_address',value: address});
recCurrent.setValue({ fieldId: 'custbody_contact_final',value: ctcname});
recCurrent.setValue({ fieldId: 'custbody_final_contact_phone',value: ctcphone});
log.debug({
title: 'Contact Name',
details: ctcname
});
});
}
}
else
if (addressSource == "Select Venue / Advance Warehouse") {
var sv = search.create({
type: "customrecord_eym_show_venue",
columns : [
search.createColumn({name: "custrecord_eym_sv_full_address", label: "Venue Full Address"}),
search.createColumn({name: "custrecord_eym_sv_contactname", label: "Contact Name"}),
search.createColumn({name: "custrecord_eym_sv_contact_phone", label: "Phone"})
],
filters : [['internalid', 'is', myVenue]]
});
var pagedData = sv.runPaged({pageSize: 1000});
// iterate the pages
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach( function(result) {
// you have the result row. use it like this....
var venue = result.getValue('custrecord_eym_sv_full_address');
var venuectc = result.getValue('custrecord_eym_sv_contactname');
var venuephone = result.getValue('custrecord_eym_sv_contact_phone');
recCurrent.setValue({fieldId: 'custbody_final_delivery_address',value: venue});
recCurrent.setValue({fieldId: 'custbody_contact_final',value: venuectc});
recCurrent.setValue({fieldId: 'custbody_final_contact_phone',value: venuephone});
});
}
}
else
if (addressSource == "Select Agent / Consolidation Point") {
var sc = search.create({
type: "customrecord_eym_show_venue",
columns : [
search.createColumn({name: "custrecord_eym_sv_full_address", label: "Venue Full Address"}),
search.createColumn({name: "custrecord_eym_sv_contactname", label: "Contact Name"}),
search.createColumn({name: "custrecord_eym_sv_contact_phone", label: "Phone"})
],
filters : [['internalid', 'is', myConsol]]
});
var pagedData = sc.runPaged({pageSize: 1000});
// iterate the pages
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach( function(result) {
// you have the result row. use it like this....
var consol = result.getValue('custrecord_eym_sv_full_address');
var consolctc = result.getValue('custrecord_eym_sv_contactname');
var consolphone = result.getValue('custrecord_eym_sv_contact_phone');
recCurrent.setValue({fieldId: 'custbody_contact_final',value: consolctc});
recCurrent.setValue({fieldId: 'custbody_final_contact_phone',value: consolphone});
recCurrent.setValue({fieldId: 'custbody_final_delivery_address',value: consol});
});
}
}
else
if (myAddressId) {
var sd = search.create({
type: "customer",
filters:
[
["address.addresslabel","is",myAddressId],
"AND",
["internalid","anyof",myOther]
],
columns:
[
search.createColumn({name: "companyname", label: "Company Name"}),
search.createColumn({name: "internalid",join: "Address",}),
search.createColumn({name: "address",join: "Address",}),
search.createColumn({name: "attention",join: "Address",}),
search.createColumn({name: "addressphone",join: "Address",})
]
});
var pagedData = sd.runPaged({pageSize: 1000});
// iterate the pages
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach( function(result) {
// you have the result row. use it like this....
var othaddress = result.getValue({name: 'address',join: 'Address'
});
var othcontact = result.getValue({name: 'attention',join: 'Address'
});
var othphone = result.getValue({name: 'addressphone',join: 'Address'
});
recCurrent.setValue({fieldId: 'custbody_final_delivery_address',value:othaddress
});
recCurrent.setValue({fieldId: 'custbody_contact_final',value:othcontact
});
recCurrent.setValue({fieldId: 'custbody_final_contact_phone',value:othphone
});
});
}
}
/*End searches */
}}
return {
fieldChanged: fieldChanged2
};
});
scottvonduhn
09/21/2020, 4:46 PMbattk
09/21/2020, 5:38 PMbattk
09/21/2020, 5:38 PMscottvonduhn
09/21/2020, 9:20 PMscottvonduhn
09/21/2020, 9:21 PMscottvonduhn
09/21/2020, 9:22 PMscottvonduhn
09/21/2020, 9:24 PMrustyshackles
09/21/2020, 9:24 PMpen one
09/22/2020, 12:08 AM