khultquist

I sent you a private message.

in Need Work Order Build SuiteScript Comment by khultquist Aug 23, 2011 6:39PM

A shipping label isn't a record, so I don't think it's possible using nlapiPrintRecord. from NS help: nlapiPrintRecord(type, id, mode, properties) type {string} [required] - Print operation type. Can be any of the following: TRANSACTION STATMENT PACKINGSLIP PICKINGTICKET BILLOFMATERIAL

in nlapiPrintRecord - Print Shipping Label Comment by khultquist Jul 7, 2011 2:44PM

You need to use have the line number in there too. The example in help is wrong... nlapiGetLineItemField(type, fldnamm, linenum) Use this function to obtain sublist (line item) field metadata. Calling this function instantiates the nlobjField object, which then allows you to use all the methods available to nlobjField to…

in Sales Order items sublist Comment by khultquist Jul 7, 2011 4:27PM

It needs to be at the very end, it tells NS that the saveRecord function has been validated.

in Script stopping Item Receipt record from saving??? Comment by khultquist Jun 24, 2011 10:18AM

You need a "return true;" statement at the end.

in Script stopping Item Receipt record from saving??? Comment by khultquist Jun 24, 2011 9:13AM

Are the field names case sensitive? reminderType and reminderMinutes Also this is in the help section: Restricting Time Entry on Tasks Unless the Web services user is an administrator or the employee specified on the task, the user will not be able to set the reminderType and reminderMinutes fields on a Task record. If the…

in nlapiCreateRecord('task') Comment by khultquist Jul 5, 2011 3:44PM

If you get this to work keep us posted. I have a similar script that automates bins on the fulfillment form, the script looks for cases where only one bin contains inventory. Since lot numbers aren't accessible via script (or at least they weren't when I wrote the script), I didn't automate that part... I hadn't considered…

in Extract Lot and Expiration Dates Comment by khultquist Jun 2, 2011 11:21AM

I think that's it, Thanks!, I copied the function from nlapiGet... case sensitive!

in Help with sublist GetLineItemText Comment by khultquist Jan 20, 2011 5:12PM

Here's the code with formatting // function to fill in bins if only one bin has stock function automatebins() { // step through line items, check if line is fulfilling, if yes then procede var noOfItemCount = nlapiGetLineItemCount('item'); for (var t = 1; noOfItemCount != null && t <= noOfItemCount; t++) { var…

in Help with sublist GetLineItemText Comment by khultquist Jan 20, 2011 3:21PM

Got it, thanks for your help.

in Add button in View Mode (again^2) Comment by khultquist Jan 27, 2011 10:35PM

Yes I've tried both, same error. And alert (current_item.getAllLineItemFields('binnumber')) returns valid fields of binnumber, onhand, etc., so the fields are correct... It just doesn't recognize these methods, I've searched through the help files and there are lots of examples that show it used the same way.

in Help with sublist GetLineItemText Comment by khultquist Jan 20, 2011 4:09PM

KOTNUtil seems to be a function that loops through all the items in some field or search results, since Brett didn't include it I just rewrote that section. In my case I'm using a custom record and stepping through lines.

in Any way to script inventory transfers? Comment by khultquist Aug 7, 2012 10:26AM

Brett - thanks for the code! I've got a similar business use to Raul Cardenas: we 'receive' items when they ship from Germany, and then 'transfer' them when they arrive in Mexico 5 weeks later.

in Any way to script inventory transfers? Comment by khultquist Jul 18, 2012 11:03AM

Ah thanks!

in nlapiTransformRecord Sales Order - Invoice with billing schedule Comment by khultquist Jun 21, 2012 1:01PM

Did you ever get this resolved? I'm having the same problem, I get the error Type: Scheduled Function: transform_so Error: INVALID_INITIALIZE_REF You can not initialize invoice: invalid reference 159543. The status of this SO was 'Pending Billing' so there's no problem there, and the script actually made an invoice, but…

in nlapiTransformRecord Sales Order - Invoice with billing schedule Comment by khultquist Jun 21, 2012 12:47PM

tzvig Here's a little more of the code, you can see how the files are loaded // search the customer's folder var file_filters = []; file_filters[0] = new nlobjSearchFilter('folder', null, 'is', folder); var file_results = nlapiSearchRecord('file', null, file_filters); if (file_results) { // step thru files for (var b = 0;…

in Search for file in file cabinet Comment by khultquist Mar 2, 2016 9:29AM

Glad to help. I use nlapiLoadFile() to get the file loaded, then use .getName() .getValue() etc. Here's a snippet of live code. // search the customer's folder var folder = 12345; var file_filters = []; file_filters[0] = new nlobjSearchFilter('folder', null, 'is', folder); var file_results = nlapiSearchRecord('file', null,…

in Search for file in file cabinet Comment by khultquist Sep 13, 2016 6:56PM

It's not referenced in the SuiteScript Records Browser, but you can search for files. I have a few scripts that search for files, here's a snippet of one: ... // search the customer's folder var file_filters = []; file_filters[0] = new nlobjSearchFilter('folder', null, 'is', folder); var file_results =…

in Search for file in file cabinet Comment by khultquist Apr 8, 2014 12:13PM

This list of item types needs to be in NS documentation Assembly Description Discount DwnLdItem EndGroup GiftCert Group InvtPart Kit Markup NonInvtPart OthCharge Payment Service ShipItem Subtotal TaxGroup TaxItem

in Proper syntax for 'anyof' and multiple values in nlobjSearchFilter Comment by khultquist Mar 12, 2013 4:02PM

That did the trick... I set the Customer's language to English US and the emailed PDF was correct. Thanks for the tip.

in Transaction PDF - Column Labels are Different Print vs Email Comment by khultquist Mar 11, 2019 4:27PM

Thanks for the reply. I see that option under 'Printing Type: Advanced', but this form uses 'Printing Type: Basic' and there doesn't appear to be a way to select different templates. Maybe it's as simple as changing to Advanced and creating a new layout, but I'm not sure what else that will effect.…

in Transaction PDF - Column Labels are Different Print vs Email Comment by khultquist Mar 11, 2019 3:44PM

What about a client script button that uses nlapiCopyRecord()?

in Copy Sales Order Comment by khultquist Apr 3, 2017 9:05AM

We use both methods (depending on who setup the customer). I prefer the sub-customer method, even though there is redundant info loaded into shipping addresses. To make address changes easier, maybe you could enable inline editing, run a search, then copy/paste?

in Multiple customer locations with billing to headquarters Comment by khultquist Jul 20, 2015 10:57AM

I didn't know about Update Purchase Price from Most Recent Purchase"... interesting. If you have scripting capabilities, you could also write a quick script for Bills/Receipts that compares the transaction rate to the item price, and updates item price if necessary. There's a lot of ways to do this, you could prompt the…

in Item Pricing updates for vendor invoices Comment by khultquist Nov 13, 2014 3:00PM

My suggestion then is to default to 'Pending Fulfillment', and then have a small script or workflow that finds newly created International orders and automatically changes the status to 'Pending Approval'

in how to put a payment hold on a single sales order rather than a customer Comment by khultquist Jun 18, 2014 10:27AM

Sales Order Approval would be the easiest way to control this.

in how to put a payment hold on a single sales order rather than a customer Comment by khultquist Jun 17, 2014 10:14PM

We use it, it works well for exactly the situation that you describe - holding off on a single order until all requirements are met.

in how to put a payment hold on a single sales order rather than a customer Comment by khultquist Jun 18, 2014 9:08AM

Blaine's idea sounds like the right way to do it. You have a process that doesn't fit neatly into the defined transactions, so a custom record is the way to go.

in Split a Purchase Order among Multiple Vendors Comment by khultquist Nov 26, 2013 12:00PM

We ran into similar problems. The solution for us was to automate (user event script) the invoice transaction upon saving the fulfillment. The transactions always have the correct date and period. Also insures a 1:1 between fulfillment and invoice.

in Sales and Cost Mismatch (Shipped not Invoiced) Comment by khultquist Oct 16, 2013 7:25PM

We don't run into that problem, but something similar on the PO side. Our POs and can't be received into a sub-location after 2012.2 because of bin errors. It forced a few minor changes, I didn't bother to open a ticket. Sounds like something changed with bins/locations/transactions. Out of curiosity, what is your…

in Not able to bill sales orders shipped from multiple warehouses Comment by khultquist Oct 2, 2012 4:43PM

MFA for Oracle Community

khultquist Red Ribbon

Comments