dansteg_29768 Green Ribbon

We accomplished this by creating a separate search and have it displayed as a sublist. Works well. Our goal was to eliminate non-relevant fields for our sales reps, hide warehouses that do not have QTY in stock, so that that our users have a clean list to work off of.

I've noticed that NetSuite also allows users to save various record types without specifying a bin (when using bin controlled items). Credit Memos, Inventory Transfers and Item Receipts are the tree transaction types that come to mind. I actually put some scripts in place to require that the bin field be mandatory, since…

Does the unit cost look correct on the adjustment? For serialized or lot controlled inventory, the actual cost is stored at the lot level, which will take some time to "settle" as Olivier stated. You may want to check your receipts (for that specific lot) to find out what the lot was received in at. I have not yet found a…

If you see yourself doing this for more than one search, you may want to create a custom field on the item record "Last Sales Activity". Have a scheduled script run nightly that looks at searches all invoices from that day and returns all items, grouped. Then cycle through the items and update the custom field with the…

Setting criteria of "IS LOT NUMBER ITEM" to "YES" would provide you with what you're looking for.

Thanks, I'll see if I can work with that. Appreciate the response.

For example, I cannot figure out how to get any values to populate with addresses, let alone have them filtered by the selected vendor/entity. var shipToSelect = form.addField('custpage_shiptoselect', 'select', 'Ship To', 'addressbook');

That's what I was thinking too. Just hoping that there is a way to simply pass the value. At least I know I'm on the right track with that thought! Thanks.

'Location' on a customer/entity? Unless it's a custom field, I don't believe it exists natively. If it does, ahumprey's response will work perfectly. In my use-cases, Customers are typically related to a their sales rep's location. so instead of pulling the 'location' from the customer, pull the 'salesrep' from the…

It looks like I managed to get it working. For anyone else looking to do the same, I followed the answers from this stackoverflow post. Basically: - On the scheduled script, create a new parameter. In my case, I've given it an ID of 'custscript_swa_custom_recID' - On the User Event script, create an array to hold your…

Thanks for those links, ironside, I'll be looking into those later today. I'm still a pretty amateur developer, but can catch on quickly. Olivier, it looks to me like that will simply merge the two result sets and only include the internal ID in the new object. In the new object, I still need to include include "columns"…

I'm familliar with the first two methods, but was not aware of the XML parameter. Excellent! I was just a little thrown off on how you referred to it as "TRANDOC.BPRINTEDPICKINGTICKET", rather than printedpickingticket, which is what I see when I get the field ID. I believe you're referring to Advanced Inventory.

Essentially, what I'd like is an empty page that I can build on, while still using SuiteScript.

Need more info. How are you trying to add these lines? It could be that a lineInit, field change or line validation are interfering with each other, causing an infinite loop.

Hmmm. I guess I am not familiar with Suitelets enough to use external links. Would the form reside on a different server and use a RESTlet to call back the Suitelet, or how does that work?

I'm sorry, I was looking at the search within my script. In my case, I am using a similar function inside of a Suitelet, which works with no problem: recId = orderResults[i].getId(); orderRec = nlapiLoadRecord('salesorder',recId,{recordmode:'dynamic'}); orderRec.setFieldValue('orderstatus','B');…

Thanks northern_brewer. I see your problem there... I actually just saw something on Friday that might be related (or at least I was hoping it was). In the past, I had a script that I needed to run whenever "Approve Order" was clicked, but could not find out how to have my script execute on that event. I just saw something…

Thanks for the quick response. I was thinking of going that route if this did not work. I have run into other situations in reporting where I was not able to easily identify drop ship sales orders. Your suggestion may be the best solution that will probably end up being used for various other functionality. Thanks!

I have a similar script that runs and it works fine. It looks like you have to refer to different fields. Try this: nlapiSetFieldValue('status', 'SalesOrd:B'); That should do it. I believe in User Event scripts, you can also just tell it nlapiSubmitField. This can help to reduce usage limitations so that you're not opening…

I've built something similar from within a saved search. The link I'm using is the following: https://system.netsuite.com/app/accounting/print/hotprint.nl?regular=T&sethotprinter=T&template=121231&whence=&printtype=pickingticket&trantype=salesord&label=Sales%20Order&id='||{internalid}||'" target="_blank"> What this does,…

Try changing your filter to look at either 'internalid' or 'recordid'. Depending on which ID you are actually looking for. Your search's syntax also looks incorrect with "...cat_l ist'" (looks like there is a space in there.

That "Did you ever know that you're my hero" song is playing my head right now. THANKS! That worked. I'm relatively new to SuiteScript, let alone JavaScript. Actually just started a month or two ago with SuiteScript, so all of my JavaScript knowledge is built off that. Really comfortable with the API, but once I dive into…

Thank you Sandra. I will give this a try. I was hoping it could be accomplished through a SuiteScript, but this will also work. Thanks!

As for your first question though...I have no idea how to get a button on a customer form to go to the actual Suitelet. Still new to Suitelets. If you find out, please post it here. Also, I'm wondering how to have multiple buttons on the Suitelet form and execute code based on which button is clicked. If anyone know how,…

I just started messing around with these myself and found little to no reference on how to get it going, but I finally got it working. What really helped me is the following link: http://www.mindfiresolutions.com/Create-Form-Using-Suitelet-2110.php You'll have to do the following: - Create a new Suitelet script within…

The way we have this set is that we have the Header location (main line) default to the user's location when the form loads (Client Side script). We then have the script default the line level field, based off of the Main Line, each time a Line Initiation trigger occurs. Works well and allows the user to change the value…

I think you'll want to dig into the "System Notes" join. You should be able to simply set the criteria to: (System Notes : Date) is after 5/31/2015 Under your results: (System Notes : Date) Summary Type = Maximum (will display the latest entry in system notes) Then you can pull in whatever other information you'd like from…

I'm not sure what the business process is here, but here is my suggestion: Are the items always On Hand in these bins or this more to allow bin transfers without having to edit the item record and add the bin, when it is introduced to a "new bin". If the latter, I would create a user event script for your bin transfers…

Voted. Hope to see this enhancement come to light sometime soon. It would greatly improve efficiency in the warehouse and help automate some tedious receipt processes.

You'll probably want to start learning how to create your own searches and reports, so that you can create them on-demand, rather than waiting for a third-party to create them for you and update them every time you need a change. We have several "power users" in our company that know how to create reports, but I've also…