but remove all the text from the Label if you want to hide it in the UI I FORGOT about this neat trick! Thanks so much for the reminder. That worked wonders, I already had the field set up. As for the quantity, I wound up using: ${item.quantity - item.quantityfulfilled}. It works so far, though I receive an error when…

nic kcd - you can add custom column transaction fields to Advanced PDFs no problem, yup. Just refer to its script ID in your template.

Thanks for the responses, guys. Sadly, neither idea worked. david.smith, as John notes, inventorydetail requires Advanced Bin Management, which we aren't using. [ATTACH=CONFIG]n415050[/ATTACH] There's an example - the "Bin #" column is my custom field w/ script, which works on any non-Kit item. The two columns next to it…

Glad you figured it out nic kcd !

Hmm, what does the error say? Also, what is your surrounding code?

michoel - thanks, I implemented your function and adapted it to my formula, it looks good and I get no error. Thanks!

I am also trying to do this. tgrimm I wound up taking your approach, but we also use Kit Items and have the Accounting Preference set to "Display Kit Items on Transactions", so all the components show, and we need our warehouse to see which bins the components are in (something that the basic PDF handled no problem).…

Trimtab Consultants, a NetSuite Partner, is the leading provider of WalkMe for NetSuite. We have a library of maps. See more at http://trimtabconsultants.com/walkme-netsuite/ Thanks! Interesting video. Still interested in hearing from anyone here who has used this.

tswilson21 - no, I never did find a solution, and I have since left the company I was with who was requesting that. Sorry I couldn't be of more help!

Of course, thank you ashishshukla

OK, so I got my phone today and installed Netsuite for Android and I can log in as any role accept Admin. Admin is supposed to have all permissions. It is not in the list of roles for editing. What do I do now? eleran - go to your user / employee record, and under Access -> Global Permissions, add the permission for…

A custom record would work, but as you say you'd need to do a sort of 'join', or lookup, to get the freight code value. I believe this can only be accomplished via script. It is a relatively simple script at least, for what it's worth.

I think that you don't want Sales Order : Status, but rather just "Status" as your condition. I do think it's OK to be on the workflow instead of the action.

Can you provide screenshots of how you have your WF set up?

Looks like you want your definition to be "On Create" AND "On Update" (On Update is what is used when editing an existing transaction).

I notice that the workflow is in Testing mode - I assume you're testing it out while logged in as whatever role you have set as the condition? It will only work for you if it is in Testing mode, so other users would not be able to test. Beyond that, I'd need to see some screenshots of the workflow and action definitions,…

I have to admit, I'm not sure what else could be going on. At this point I'd try removing things just to see if I could get it working (however improperly), to identify where the issue might lie. The first thing I might try is changing the status from "Testing" to "Released", if that won't mess things up too bad for your…

Instead of "Sales Order : Status", try just "Status" (don't select anything in the "record" column) in your conditions (you'll need to do this in both your workflow AND action definitions). The idea here is that you are already on the Sales Order record, so you don't need to "join" to another record to access it. The join…

Gabby yes - NetSuite's Suitescript APIs are written/based in JavaScript, so you'll need a developer to help you out. You'll need to provide them access to your NS via a user license as well (or at least to a sandbox, which you may or may not have purchased with your NS license). What you're asking to do here is relatively…

Hi Gabby - unfortunately you cannot use workflows to control/interact with SUBLISTs (such as Items) - to control these you must use a script. Workflows can only interact with MAIN or BODY level fields on a form/record. One way around this, which may or may not work for you, is to have your workflow triggered by a SAVED…

The "Expected Close Date" is set after the form loads, on a bit of a delay. My team wanted it cleared but still mandatory so that they would be forced to set it themselves. I managed to accomplish this by setting the field value to the aforementioned formula of '' (two single quotes), but the KEY is to set the Trigger On…

I'm in Buffalo, NY so not too far from the Ohio border - it's about 3 hours to Cleveland or so. Probably wouldn't be able to make any weekday meetups or anything, but maybe I could come to the occasional event.

There may be something with Distribution Resource Planning? I do not know if there is or not as I haven't had that module - I can tell you that the standard Demand Planning module doesn't have the minimums you are referring to, we had that module before and then ended up turning it off when we realized it wouldn't work for…

You should be able to apply a workflow so that it gets triggered even via auto-generate transactions created by NetSuite.

You could accomplish this via workflow, I think - create a custom field on your item record called "Minimum Work Order Qty" or something, then create a workflow to source that onto the workflow record and overwrite the qty to build field, if the two are different (you'll need to use a formula to basically round up to the…