Hi there, You should be able to accomplish this with a transaction search. I would think filters like: Posting = True Main Line = False Location = {location you care about} Type = {transactions that remove inventory such as Item Fulfillment, Inventory Adjustment, etc} And then you should be able to set an email schedule…

Hi Amanda, One thought - on your last two formulas, remove the "else 0" portion. This is adding extra zeros to your data set, dragging down the average (I think).

Hi ssilveri777, Are you using "Formula (Numeric)" or "Formula (Currency)"? If the former, just flip it to the latter and your issue is solved.

AmandaFlynn I just tried this and see that the sublist is paginated by the hundred (and does not appear you can change this). My list is sorted by Item Name, however this appears to be one of those pages that has "sticky" changes. I just tried re-sorting by clicking on "Description", leaving the page, and returning. When I…

Hi Jebin, You will likely need a script to grab the related Item Fulfillments and stamp the Invoice record with this data. There is no direct link between an IF and an Invoice unfortunately. We've had several clients ask for this kind of functionality before. Happy to help out if you need an assist getting this sorted. Mark

Thanks pcutler - problem is, that won't let them fulfill.

Yup, you can show the results in a sublist on a form. You cannot "dynamically" reload the content of the sublist unless you use an editor/inline editor. I typically just use a static list and silently POST back to the suitelet.

cusenj10 Workflow Action scripts leverage all of the same API's that other NetSuite script types use. Do you have any experience with JavaScript or SuiteScript? The NetSuite help files on the topic are extensive, but they can be overwhelming to anybody new to coding in general. And as a public service announcement, a…

Hi MChammaTX, We have used the email capture plug-in with great success for several projects. I can't speak specifically to sandbox, but we do not have any issues in Production.

Matrim You are exactly right. You could put a client script on the form so that any time one of the filters changes you reload the page so that you mimic the standard search page behaviour. But I always found that behaviour a bit annoying :)

Hi Avej, NS will not allow you to change the subsidiary on a customer once the customer has transactions/projects associated with it. Your best bet is to inactivate the customer, then create a copy and attach them to the proper subsidiary. Otherwise you have to unlink all of the existing transactions/projects. You cannot…

Can you post a screenshot or two of the workflow you currently have in place? Also, are you talking about a Custom Segment on the body level of the transaction or the line level?

Hi JP_112, Unfortunately, you can't add a custom button to the saved search screen. Your best workaround would be to run the search via script, display the results as a list, and then add your button. Should end up with the same functionality.

There is a documented limitation of the file handling API's. In SS1 you can only go up to 10MB. In SS2, if you read/write by line, you can read/write a file of any length so long as the line you are working on is under 10MB. Personally, I would start to re-examine the architecture of the integration. For instance, can you…

Hi Nate, Quantity Available is not a stored field on the item record, so monitoring it for changes can be quite tricky. You'd likely have two options. The first, as you eluded to, would be to deploy against any transaction type that can impact quantity available. The second would be some sort of scheduled script that takes…

That's the one we are eyeing at the moment, but so far we are hitting some snags. Appreciate the input though!

Hi Andrea, It sounds like you're already on the right track if you are successfully able to disable auto-commitment and, instead, commit items manually. Yes, you can script the SO to auto-commit only certain order types, certain item types, or just about any other logic you would like. This would be a pretty…

connect@textileswest.org I'm also a Mac guy but using the Command key works for me. Do you have any type of software installed on your Mac that intercepts/manipulates keyboard input? That could screw with things. Also, can you provide an example of a specific field you cannot multi select?

Hi Mark (what a great name!), I can think of two things that you could do. Note that I'm not exactly thrilled with either of them, but it beats being stuck in "Processing" limbo or manually uploading 10k files: 1.) Web services can handle files. You could use a local tool (Node?) or a cloud-based tool (Boomi?) to read the…

I'm a +1 on cpolanish question. I, and many of our customers, are experiencing the same issue. Started around the same time as well.

mchen Your best bet to get something similar to that would probably be through a custom search tool. Your ask is not very difficult so it would be a small job for any competent coder. We'd be happy to explore this further with you as we help lots of other NS users with similar requests.

mchen Yes you are. Your best bet will likely be using some formulas and SQL in your criteria. The complexity of the SQL will depend on how congruent your naming conventions are. If they are always LL-NNN then this will work: [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"search criteria for…

Hi John, You can definitely use phone fields for international numbers. The only thing to watch out for is the max length. Depending on which record and which field you are using, the max lengths can be different. The typical length is 22 characters. Phone number fields can bark if you put too few characters in, but not if…

Phone number formatting is set at the Company and Subsidiary (if you have OneWorld) levels. If you go to Setup -> Company -> General Preferences you will see the preferred phone number format for your instance as a whole. If you go to Setup -> Company -> Subsidiaries you can set the phone format on the Preferences ->…

We had a customer that exceeded their initial database allotment. This was mainly with custom records of a certain type, as they built a web app that used NS as the back end. There were no issues with listing/accessing records. There were a handful of searches that started timing out in the UI (usually with multiple,…

tkansara You are correct in that setting the concurrency to 1 will limit the speed, since you only have one "processor" working on your script at a time. However, having 2 (or more) processors engaged could produce a situation where two orders try to requisition the same inventory at the same time. This would cause an…

vkwanengage There is no way to modify the default "Export to CSV" button's behaviour on a saved search. If you want the search results to be able to be pushed over SFTP via a button your only option would be a scheduled script or suitelet. I'm curious - what is your use case for pushing search results to SFTP on demand?…

Hey tkansara - Welcome to the SS2 revolution! Map/reduce is a great tool and I like to hear that others are using it. You raise a valid point here about "collisions" from multiple threads hitting the same record at the same time. You can get around this if you set the M/R Concurrency Limit to 1. This will ensure there is…

jackbrown391 The sublist you are referring to is actually a list of child "Time" records. You may want to check out the Time record entry in the records browser.

karenn You have two different tools at your disposal. The first is only applicable if this is a form you are generating with a Suitelet. In this case, you can setup a field group, set the field group to be a single column, and add all of your fields to that field group. If you are adding fields to a standard form (ie…