khultquist

That should work, although it's not robust: you could have an assembly with quantity on hand plus buildable qty. And the previous scenario isn't covered.

in Buildable Quantitie values -> Assembly/Build Item Records Comment by khultquist Jun 12, 2014 9:12AM

'buildable' is not a scriptable field, (not) shown here in the NS record browser. It's a calculated field based on available inventory, so you could recreate it with formulas.

in Buildable Quantitie values -> Assembly/Build Item Records Comment by khultquist Jun 2, 2014 1:11PM

I've never scripted a binworksheet, are you essentially trying to move inventory into various bins from a null bin location? If so, how did the inventory get loaded into NS to start, through a Inventory Adjustment (IA)? If so, I would just redo the IA to include the bin. Or you could attempt an Inventory Transfer / Bin…

in Scripting binworksheet Record Comment by khultquist Jun 3, 2014 2:45PM

Also, which column is causing problems, and what type of field is it? If it's a list/record field (a related record), you may need permissions there too.

in nlapiSearchRecord returns null for a custom role Comment by khultquist Jun 2, 2014 4:23PM

Since you need to report on it, my suggestion is to run a Scheduled Script as follows. [LIST] [*]Create your custom field of 'Buildable' for each assembly item [*]Script runs a search for all assembly items. Result Columns are 1) Internal ID, 2) Buildable, 3) Member Item, 4) Member Qty. Make sure your search iterates for…

in Buildable Quantitie values -> Assembly/Build Item Records Comment by khultquist Jun 10, 2014 12:03PM

Loop through with the results with a for loop in javascript. Examples are here The additional logic is needed because of this BOM scenario, shown indented Assembly Item A ..Inventory Item X ..Inventory Item Y ..Assembly Item B ....Inventory Item X ....Inventory Item Z If Assembly Item B has 0 quantity available, but is…

in Buildable Quantitie values -> Assembly/Build Item Records Comment by khultquist Jun 11, 2014 11:42AM

If Ayman's suggestion doesn't work, add some debugging lines using nlapiGetContext() and it's multiple methods, eg getPermission(name), getRole(), getName(), etc. This should shed some light on what's happening with you permission.

in Suitelet Item Permission Problem Comment by khultquist May 8, 2014 5:57PM

In re-reading your question, I believe you want to subtract a day from today, not add one... I would change the code to function saveSOCheck() { // Validate due date var despatchDueDateValue = nlapiGetFieldValue('custbody_despatch_due_date'); var despatchDueDate = nlapiStringToDate(nlapiGetFieldValue('custbody_des…

in Date comparison Comment by khultquist Apr 25, 2014 10:00AM

What's happening is that a js date object is more than the date, it also includes time. Using nlapiStringToDate, a mm/dd/yyyy value is converted to a js date, with a time of 0:00 (12 midnight) Using new Date(), you will capture the current time of the current date, which will always be greater than nlapiStringToDate. The…

in Date comparison Comment by khultquist Apr 25, 2014 9:26AM

Sounds like this is a User Event script, so you can use nlapiGetOldRecord() to load the old record, then find the parent from that object. https://system.netsuite.com/help/helpcenter/en_US/Output/Help/SuiteCloudCustomizationScriptingWebServices/SuiteScript/RecordAPIs.html#bridgehead_N3030453

in Get parent record of deleted custom record in server side script? Comment by khultquist Apr 14, 2014 5:11PM

It's running after submit, so you can't change the record... unless you reload the record, and then resubmit it. As it's written, it shouldn't work for create or edit.

in uncheck a box Comment by khultquist Apr 21, 2014 6:29PM

This would be best done with Custom Forms. Simply pick the fields on the form(s) and set them to Mandatory.

in User Event Script for Before Record Load Comment by khultquist Mar 31, 2014 8:30PM

There are at least 2 ways to get more than 1000 records. I use this one all the time.

in How to expand on maximum of 1000 records in suitelet Comment by khultquist Mar 14, 2014 8:59AM

you have a typo, maybe that's the problem? return fales;

in Getting Type error on saverecord function Comment by khultquist Feb 18, 2014 5:02PM

Maybe consider doing it thru scripted searches and csv. You could pull all of your data through searches (low governance), crunch the data in a script, and save the updates to a csv file in a specific folder in your file cabinet. Then a separate scheduled script takes over which looks for files in that folder, launches a…

in Strategies for dealing with long running tasks Comment by khultquist Feb 18, 2014 3:14PM

Do you use nlapiCommitLineItem(type) after all changes? Also there are some client script functions that address 'firefieldchange' maybe that would work... I know this is a user event but you might consider testing as a client script. Can you post the whole script or the portion of the function that is in question.

in User event Script doesnt recalculate Comment by khultquist Feb 17, 2014 10:44AM

Sublists updating are tricky. I've run into problems with changing customers, and the sublists act erratically. To debug this, I would temporarily change this script to loop twice -- first loop sets the item and units, plus set the price level to 'custom' and the rate to 0. Second loop sets the price back to the original…

in User event Script doesnt recalculate Comment by khultquist Feb 17, 2014 3:28PM

Hi Ken - I would suggest you rebuild this as a scheduled script (which has 10x the governance of suitelet). The scheduled script can be run and have the resulting pdf files emailed to a user for printing, or saved to a file cabinet folder... or even better it could email directly to customers if that works in your business…

in Need Help with script Governance work around Comment by khultquist Feb 7, 2014 2:39PM

Hi Dan - if you need to show an alert, then you must use a Client Script. Alternatively you could use a send an email alert with a User Event script, but you will not be able to interact with the user interface. You can determine if it's a new record by using nlapiGetRecordId. From the NS help: nlapiGetRecordId() Use this…

in Before Submit Function vs Saved Record Comment by khultquist Jan 7, 2014 10:25AM

function sb_onPageInit(type) { var vend = nlapiGetFieldValue('vendor.inactive') if(type == 'copy' && vent = 'true'){ alert("The PO you are copying has an inactive vendor"); } should be function sb_onPageInit(type) { if(type == 'copy'){ var entity = nlapiGetFieldValue('entity'); var isinactive = nlapiLookupField('vendor',…

in check to see if vendor is inactive Comment by khultquist Jan 6, 2014 2:46PM

A saved search will still show values if 'store value' = F

in Modify script to add prefix to Internal ID Comment by khultquist Dec 23, 2013 2:06PM

That's correct, 'fulfillment' record doesn't have 'shipdate', instead use 'date'. The 'salesorder' record uses either the first or last 'fulfillment' 'date' as the 'shipdate'.

in retrieve array of Item Fulfillment records by given date Comment by khultquist Dec 22, 2013 5:55AM

Are you using a custom field for the 'modified internal id'? If so, you could do this without a script. Make your custom field a SQL formula, uncheck the 'store value' box.

in Modify script to add prefix to Internal ID Comment by khultquist Dec 23, 2013 1:12PM

try removing your filters, add them to your columns. Then add debug in the results loop to see what the status and ship date are nlapiLogExecution('DEBUG', 'description', value)

in retrieve array of Item Fulfillment records by given date Comment by khultquist Dec 21, 2013 1:54PM

Ah you are using 'Pick Pack and Ship' option... I think you are on the right track then with system notes, but you will need to debug that. I've never tried scripting a system notes search, but I'd start out with doing the same debug as before by moving the expression from your filter to your column. Also in your last…

in retrieve array of Item Fulfillment records by given date Comment by khultquist Dec 23, 2013 10:27AM

Hi jkelly, try use a lookup to determine if it's serialized. This will be faster and save unnecessary steps of loading entire records, and maybe fix your issue of loading the wrong record type. Old Code: if( itemType == "NonInvtPart") item_rec_type = "noninventoryitem"; if( itemType == "Assembly") item_rec_type =…

in The record type [] is invalid Comment by khultquist Dec 5, 2013 5:50PM

That seems excessive, especially for the beforeload user event... that runs server side so it should be much faster. Some other options: a beforesubmit user event, an aftersubmit user event, or make a template quote (with the two standard items on it) and create new quotes from that by copy.

in Can't we add more than one line on Page init function? Comment by khultquist Dec 10, 2013 5:58PM

A really simple user event script would do it function before_load(type, form){ var current_context = nlapiGetContext(); if (type == 'create' && current_context.getExecutionContext() == 'userinterface'){ nlapiSetFieldValue('generateintegratedshipperlabel', 'T'); } } Load this into your script folder, create a user event…

in How to automatically check (select) "Integrated Shipping Label" box ? Comment by khultquist Nov 27, 2013 2:55PM

Try replacing 'QQQ' with something else for testing, like 'testQQQ' I suspect that you already have an itemid with this value.

in Error Creating InventoryItem: Items you have requested in the record have been delete Comment by khultquist Nov 26, 2013 10:30AM

What about mandatory fields? Try nlapiSubmitRecord(item_obj, true, true); to ignore mandatory

in Error Creating InventoryItem: Items you have requested in the record have been delete Comment by khultquist Nov 26, 2013 7:45PM

MFA for Oracle Community

khultquist Red Ribbon

Comments