khultquist Red Ribbon

I hear what you're asking, about the counting unique... but how do you have 'fulfillment' with a 'backorder'? If you need a count of SO with backorders, that's an easy summary search. If you need a count of fulfillments created from SO w/ current backorders, that too can be done in a summary search.

For your first formula, average sales quantity per week, is this a summary search? In your second formula, you are dividing by 0.

Well you have to re-think how this will work, you need to summarize the first formula before dividing into the second formula. As far as I know you can't use a summarized value inside a search. A really simple way to do it is to add the 'Qty Available' to the summary search, and choose 'Maximum' as it's summary type. Then…

Once you have it as a Javascript date, you can convert it back to a string in another format. http://stackoverflow.com/questions/1056728/formatting-a-date-in-javascript

Here's a clip from one of my scripts, it shows how to split the date string and turn it into a js date. It was setup for mm/dd/yyyy, you could adjust it for dd/mm/yyyy. var startdate = nlapiGetFieldValue('date'); var startdateparts = startdate.split('/'); startdate_js = new…

You could have a 0 in the denominator (proposal)

I remember reading somewhere that search terms have to be more than 3 characters

What Olivier is referring to is NetSuite's terminology for different trigger points/locations/times for scripts. It's pretty well documented here, and if you drill in deep enough you'd find the 'after submit' here . It's worth the read if you are going to script things like transfer orders, fulfillments, etc.

I believe your problem here is that locationquantityonhand is a read only field. To change any item's quantity, you need to create or edit a transaction (Item Receipt, Inventory Adjustment, etc), not edit the item record.

Thanks for the reply Evan. How would I set the field value, I have no way of looking up the name of the current user if he is restricted to a subsidiary...

There is a manufacturing module that has MRP. I've haven't seen it so I can't comment on it, but I can tell you that when we started our NS account it was sold by a 3rd party and was $$$$, so I built my own custom MRP report with ODBC and Excel.

Script queues reset at 12:00 am, so on the 27th this one is no longer running. It won't start until the 26th of next month. You can setup 6 deployments -- one each for the 26th, 27th, 28th, 29th, 30th, and 31st. I would assume that the last 3 are ignored in February, you might want to confirm that.

jokell In your post that you wrote ${item.binnumber} but we use ${item.binnumbers}, plural. Not sure if that's a typo or not... based on al3xicon's input it probably doesn't matter, but worth a look.

I don't know if this is relevant to Pick Tickets, but we use an Advanced Form for Bill of Materials and we do show the Bin numbers: [CODE]<#if record.item?has_content> <table class="itemtable"><!-- start items --><#list record.item as item><#if item_index==0> <thead> <tr> <th colspan="1" style="width:…

We use a custom field (transaction column field) that has the logic in SQL. We call it "Qty to Pick". If you do something similar in your account, you should be able to access it in Freemarker with a single field.

The difference is that it also searches other cloud-based sites for your data that you have allowed. So from one search box (or from the address bar in chrome) you can search your accounts in google apps and netsuite and linked in, etc.

KCSF Bud it seems like you could add a second Formula Numeric to check if this transaction made locationonhand drop below locationreorderpoint formula 1: locationreorderpoint > locationonhand formula 2: locationreorderpoint < locationonhand + quantity* *where quantity is a positive value on that transaction item

david.lyle np, glad to help! The second formula will only work on transaction saved searches, when immediately sending an email alert. I haven't tried or tested it myself, so I'm not exactly sure of the syntax or if it will even work for multi-line transactions.

You should be able to do the comparison with a SQL formula, something like this [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"Capture.PNG","data-attachmentid":438036}[/ATTACH]

Have you considered using a scheduled script? If you can tolerate a ~15 minute gap between create and edit, you can get completely remove any UI impact.

It's tough to get a standard field to initiate the way you want. One strategy I've used is [LIST] [*]create a custom field that you can initiate the way you want [*]hide the standard field on all forms [*]create a simple script/workflow (beforesubmit) that syncs the two fields [/LIST]

Interesting problem... This is kind of roundabout, but what about making a custom checkbox on the record, let's call it 'Record was updated'. Anytime the record is edited, this checkbox is checked automatically (by script or workflow, beforesubmit). Then have a workflow evaluate only orders with the checkbox checked,…

Look at the html source code of the page, if the button has an id=something then you can change it's properties with scripting. We use this to highlight some fields on order fulfillments: for (var t = 1; noOfItemCount != null && t &lt;= noOfItemCount; t++) { obj =…

If you have the Light Manufacturing Module, I would recommend using a Work Order. There might be other modules that support Work Orders too.

That's in the script record in NetSuite.

One immediate problem you have is that you are working with nlapiGetOldRecord, which is not allowed to be resubmitted. I would suggest you turn this into a 'Before Submit' script and then you can check the logic, and prevent it from being submitted if necessary.