Hi there. The following is from an NS sample script. I don't know if it's in the current documentation or how you'd find it otherwise: var filters = [ new nlobjSearchFilter('customer', 'pricing', 'is', 'X') // fill in your customer's internal id here ]; // set search return columns for pricing list search var columns = […

var itemid = nlapiGetLineItemValue('item', 'item', lineNumber); :)

I don't believe you can derive the h parameter. It's a security hash. You can however use the 1388 to get the file's url. The following is from a test case using the Java binding for wsdl. nsClient.setSearchBodyFieldsOnly(true); String fileId = props.getProperty("testLoadFileId"); RecordRef fileRef = new RecordRef(null,…

My suggestion would be to convert the list to a custom record. There's a checkbox for that on the list definition. It'll work the same in the GUI but you'll be able to search on it.

Sorry, I saw 12000 items in a custom list and my mind immediately shouted customRecord. I believe the following still works with a Java binding. ...String searchValue, GetSelectValueType type... GetSelectValueResult refs = client.getPort().getSelectValue(new GetSelectValueField(searchValue, type)); HTH

Hi Wiz, Please tell me you found the secret sauce to fixing this.

What's your application for this info? There are various ways to generate it. I don't know of one that doesn't require either scripting or exports but maybe Evan will chime in with some formula field magic. The easy way if you just want this occasionally would be to create a search that lists the top 100 items and a search…

If you are investigating an individual item you can use a detailed inventory valuation report on a single item to trace its stock status. You can of course do this for multiple items but I find the report pretty unwieldy when you start to add layers of detail. As far as I know there is no way to do this out-of-the box even…

It's possible as a report to see the inventory as of a date, not sure if that helps. If you really need it as a search, you could build a custom solution, I've made a similar one for summarizing SO quantities for historical purposes. It involves making a custom record that stores a item number, date, and quantity. Then a…

Hi Eric, this can be done a number of ways. If the customer needs to see this on the web store you can do it through a Scriptable Shopping Cart script. Otherwise you could do it with a User Event script. Basically you'd need to set up your account to charge separately for handling but you' leave handling as a flat charge…

We would like to charge a flat fee for each package shipped for a particular customer due to their specific demands for how the items are shipped. Does anyone have a clue if this is possible? I've read through a lot of NS's help center regarding handling and am having a little trouble figuring out how to do any of it.…

When you save the itemfulfillment record created with nlapiTransformRecord it will show up under the SO.

See this thread for code that'll do that. Just substitute "salesorder" for "transferorder". Workflows can also be used

We are trying to figure out the best way to do this in netsuite. What we need to do is have a generic part number (called "Printer") and when it is used on an order it will pull from a specific printer item (called "Epson-XXXX"). Is that even possible? We want to do this with serial parts. Seems that if we use KIT we…

Hello, First you need to link your PDF layout to one of the Packing Slip Layouts. Once you've done that there are a couple of ways you could proceed. One is you could link the Packing Slip layout customized above to a Sales Order Transaction form and then you can Fulfill, Save & Print. Otherwise just fulfill the orders and…

Hi John, Scriptable Cart/Scriptable checkout. They are the same thing.

Thanks. Hadn't use SCO Unix in long time and wondered what that had to do with it. Really wish you were closer to Toronto than Vancouver... I guess that dates you too. Other than coordinating meetings due to timezone differences location doesn't make that much difference these days. I've currently got customers scattered…

SCO certainly can be used to help solve shipping issues. I've used it for: [LIST] [*]custom freight calculations where the freight is calculated if a particular shipping method is selected. Methods are forced based on cart contents and shipping destination [*]returning lists of acceptable shipping methods based on cart…

Brett, For fear of appearing daft, what is SCO? no worries --> Scriptable Check Out. Easier than writing Scriptable Cart all the time. I thought it was a common term but it may be that I'm the only one who uses it. Oddly I still have a hard time not reading it as Santa Cruz Operation which probably dates me pretty well. :-)

I'm not a coder, can you explain this in layman's terms for me? Roughly it shows two different ways to search lot numbers with javascript. How did you want to be able to search lot numbers? You can do a saved search on "Inventory Numbers" though I thought you could also do this directly under Lists|Accounting.

I think they have been since at least the 2011.2 release: var x = nlapiSearchRecord('item', null, new nlobjSearchFilter('inventorynumber', 'inventorynumber', 'is', 'abc'), [ new nlobjSearchColumn('itemid'), new nlobjSearchColumn('quantityavailable', 'inventorynumber')]); x.forEach(function(it){…

Is there any way to block certain 'holiday' dates from being selected at the sales order level for the ship date? As there are many holidays throughout the year, our sales team has on occasion selected dates where we are closed. Does anyone know of an easy way to prevent dates from being selectable based on some sort of…

Whether this is the correct Netsuite behaviour or not I can't say but I'm pretty sure what you are trying to do is wrong. The shipping cost on the Sales Order is a value that you charge your customer and is revenue. The actual shipping costs you get charged by your carriers you don't even see until they bill you. It sounds…

John, You can set the handling formula on a per shipping item basis. Unfortunately you cannot set complex or conditional formulae. I have recently done a couple of jobs where I calculated complex freight rates using Scriptable Checkout (SCO). Basically you create shipping items with a flat rate of $0 and then in your SCO…

can't you do that with handling charges? You'd have to set them on each item individually and then set up your shipping item to use the items' handling charges.

I have this working for one customer but the scripting is fairly hideous since they wanted the checkbox on the address entry page. Basically you add a custom transaction body checkbox and then script the display of that on the site and, once the order has been placed, into the order's shipping address. Scriptable CheckOut…

We have integrated UPS and FedEx into our Netsuite shipping process. Does anyone know a way to create a shipment that is not as a result of an order. For instance, we want to ship items to a vendor for rework, and have the items returned. This would not be a return authorization. Since the item will probably remain in your…

That regular expression is testing that you have exactly 12 digits in the tracking number. If you have spaces at the beginning or end of the tracking number it won't work. You could test that by setting the regex to [CODE] else if((/^\s*\d{12}\s*$/).test(tn)) href = makeFedExLink(tn); [/CODE]

Actually the script uses an email template (generated normally) and it's own custom tags using @tagname@ instead of <NLCustomtagname> so the custom tags can be added to url parameters without being escaped by the rich text editor. IIRC one of the tags is @trackingnumbers@ which can be positioned as you like in your normal…

See my response to this thread. The code gives an example of making tracking number links for a custom email