Yes, it makes sense to me. Would be good if this can be updated : SuiteAnswer 19397: Make Custom Record Types Appear as Available Source Lists When Creating Custom Transaction Fields. I did flag it with a single start and provided feedback.

Jarrod, Here is a screenshot of the Item Dataset on my test account.

Thanks an interesting feature Pauline. The first idea I was having was to use the {linesequencenumber} from the transaction lines.

Do you need to have the time schedule on both the Workflow (Basic Information) and on the Workflow Action? Maybe the workflow triggers at exactly 5:00:000 but by the time the Action condition is checked it does not meet that Action criteria 5:00:001 as the time has passed 5:00:000. Maybe Similar to Jcirocco I prefer to…

hi Jarrod, I had a similar issue. Check the naming of a few fields in Analytics on the left hand side. Location - accesses the fields of the location name, address etc Locations - accesses the inventory quantities that I was seeking. In one of my accounts Location was renamed by client to Warehouse and thus sometimes in…

Can I chip in with a simple method that worked for me. I used a Saved Search to trigger my Workflow. the Saved Search 'counted' "Internal IDs" of messages to get the number in Inbound and Outbound messages associated to a Transaction. In my case I only had to action upon receiving the first reply, so as soon as Incoming…

I have reviewed the SuiteAnswers articles you linked 10090: Custom Transaction Line Fields 10099: Setting Sourcing Criteria 10103: Sourcing and Filtering Examples These refer more to sourcing of native records and do not refer to sourcing of Custom Records, After reading your reply I went back again to read SuiteAnswer…

Jack, thanks for that detail. The wording that needs to be clarified for me is the naming of Source List selection. In my case the Custom Record was called "New Bikes" with three fields Bike Serials Number Bike Seat Type Nike Wheel Diameter When I add the Transaction Line Field I have called it Serial Number When I go to…

Here is a solution that worked to correctly calculate days between the two dates Math.round(((nlapiStringToDate({custbody_billing_period_to})-nlapiStringToDate({custbody_billing_period_from}))/86400000))+1

another idea consider enabling the standard functionality: Scenario Set Up preference to search for items using Display Name/Code instead of Item Name/Number when entering items on transactions. Solution 1. Navigate to Setup > Company > General Preferences 2. Look for Show Display Name with Item Codes 3. Enable the…

I'll take a punt on what you are wanting to see. My assumptions. You have Sales Orders which you then Invoice. At some time you then create RMA from the Invoice.When you write a search based on the SO, you cannot link to any RMA as it is a second join. The Invoices are a first join from the SO. Three approaches. 1. Via…

you wont be able to have a blank Income account on an item that is for "resale" subtype. NS would be checking for that well before it starts looking for transactions to change. a) Recreate similar items for Purchase only and then Inactive these incorrect items. Update your BOMS. or b) Use the Item Filter on your Sales…

I was hoping it was referring to a licence key management for software sales by a User to their customers ie Company 'Softwaregalaxy' sells software to users via their website. They issue a unique user code to each of their purchasers (who are not Netsuite customers). They want to generate that code from within Netsuite…

Sorry for the delay in responding. I did try the above suggestions as best I could and never got it to work. Unfortunately had to move onto other priorities.

I'm also a fan of this requirement. Would love to do a 'simple" sales report showing Rep sales for the month v rep quota. an then do a nice Analytics charts. I looked in 2020.1 Release Preview Quota >> Rep Customer >> Transaction Lines still doesn't create a dataset. fingers crossed for 2020.2

I sent this along and received the following error: SuiteScript 2.0 entry point scripts must implement one script type function. /** *@NApiVersion 2.0 *@NScriptType ClientScript */define(['N/ui/message'], function priceHeading(message) { var myMsg = message.create({ title: "My Title", message: "My Message", type:…

Hi @Mikko De La Fuente-Oracle I updated the code and when I upload the file I get " "Fail to evaluate script: All SuiteScript API Modules are unavailable while executing your define callback."

Regarding the slow response you should lodge that with Netsuite Support. I had the same issue and I understand it is a priority for them. If anything, reduce your un-required columns in your Dataset.

I agree with Eric's answer. I had this exact issue with a Werkato integration from Salesforce.

I would do this in the 'new' Netsuite Analytics functionality. I did a pivot table that looks like this, this summary in the Dev account shows a count by assigned and priority. Then once you have that you can collapse and drill down as you investigate; Here is a screenshot of Fields and Layout of the Pivot For the…

How about a custom field which concatenates the other item fields you want included. Then make that custom field available to Global Search. People can search in the top Global Search bar and just get the code without clicking through to the item, Just re-reading your post, I think you mean when you are entering a line…

This worked : messageSent = nlapiSendEmail(sender, receiver, mergeResult.getSubject(), mergeResult.getBody(), null, null, {transaction:tranid}, file, true); I was inspired by this article :

My message is sending - great, it attaches to the Employee record but doesn't attach to the transaction. I'm using this in a Workflow deployed script. var rec = new Array(); messageSent = nlapiSendEmail(sender, receiver, mergeResult.getSubject(), mergeResult.getBody(), null, null, rec['transaction']=tranid, file, true);…

I think I saw this coming in a future release. maybe it's in 2020.1 I do notice that Admiin/Full access roles can now at least View the Private searches of Users.

The employee will only see the subsidiary that their Role permission allows.For example An employee of Subsidiary B cannot make an Item available in Sub A (unless they have a role that allows both A&B)

When I attach it as a library on my 1.0 script file and try a deployment it give me ReferenceError: "Symbol" is not defined. (tf library#2) error It's a widely used google product which is accessible here : https://www.tensorflow.org/js/tutorials/setup

Sounds like it would be a great feature. Just as a data point: I also could not find that Permission available for setting on Roles. Also I did a wildcard search on a dummy Mass Update but nothing was returned with %own% there Good luck

Not too many replies coming your way so far. Maybe you could take inspiration from the Bill of Materials Advanced PDF standard file. The code there will print the items on the Work Order and will also then print additional assembly comonebts for assembled items. Maybe you could see if using a similar format will allow you…

I recently saw a script for a client that needed 100,000 records deleted. function deleteRecords(recType, searchResults, recIdColumn) { var context = nlapiGetContext(); var processedIds = []; if (searchResults) { for(var i = 0, y = searchResults.length; i < y; i++) { // get the values of columns needed in each row var…

I had a conflicting workflow which I removed. Seems to be OK now. Thanks for your note.