Nice, thanks for the tip!

No, I haven't used the excel query before. That sounds promising. Are you talking about this, Excel Web Query (/app/help/helpcenter.nl?fid=section_N745334.html)?

Hmm, I did that but the results look saved search specific rather than for reports? Are you thinking of saved searches and just calling them reports (We do the same thing here actually). This particular one is an actual report though, "Reports -> Saved Reports", they seem to be a different beast all together than "Reports…

Thanks for the reply. I think I'll look further into trying to duplicate the report results using the workbook/query feature.

Thanks for replying. That's a good check but I do have the log level set to debug. I do see the log with the 'type' title but the message is blank. I tried changing the log to this out of curiosity log.debug('type', '*' + JSON.stringify(query.Type.SHIP_ITEM) + '*'); With that I get the log message *undefined*. That's…

Hmm, the records I'm using are both custom records created by a 3rd party. If I do the same thing with a kit using an item and member item fields it works as expected. This formula when searching an item returns 1 row with a sum of the component ids (I just used the component internal id because it was an easy number to…

Thanks for the suggestion. I went with a restlet but exactly what you said otherwise. Good enough until we can convert the rest over to 2.0.

I tried changing, adding and removing criteria but no luck. Was worth a shot though thanks.

A good thought but I just tested it and that is blocked too. It's possible to code it but when the code executes it throws this error code: "CANT_UPDATE_ACCTNG_PRDS" description: "You cannot update accounting periods using SuiteScript or Web Services. Go to Setup > Accounting > Manage G/L > Manage Accounting Periods." So…

Thanks for the response. I'll post if we come up with something.

Nice, thanks for the update!

FYI, Looks like sandboxes purchased prior to 2016 do not include the developer accounts.

Let me ask a different question. What are people using Dev accounts for? After Suite World I was under the impression that they should be used for project development which would then progress through sandbox to production. Is this how people are using their dev accounts? They completely mimic their normal environment in…

Anyone? Seemed like a lot of people were using them at Suite World.

That removed all the formatting, sorry.

Mandry you can you system notes to search changed fields. Our customers don't change much but here's an example of a search that gets the last time an item had a checkbox set to False. Should be basically the same for customer. var itemSearch = nlapiSearchRecord("item",null, [ ["upccode","startswith","630870195843"],…

Old post but in case it helps someone. One of our developers stumbled on this book by Matt Dahse. It's a well written book with lots of good info but it also includes a framework to debug map/reduce scripts using the debugger. https://leanpub.com/netsuitedevelopment No idea who Matt is but we've used the map/reduce testing…

Nice, I missed that in the release notes. That will be nice, 50MB disappears pretty quick.

Thanks for the suggestions, did some prototyping and we're going with the custom record. Created basically a key/value pair record to store the config data. Then we created 1.0 and 2.0 “loaders” that retrieve the data and convert it to a javascript object that replicates our existing structure (from a javascript library…

In this case I was able to use formulas, grouping and summary functions to bring my saved search results down to 35,000. Try 1: Loop through the results in the input phase and create an array. Result: This worked and allowed me to create an array to pass to the map phase. The size ended up just over 10Mb so I have a…

Thanks, looking forward to seeing this tool continue to grow.

I tried a work around with using a workflow field and got closer but still missing something. My multiple select field from the record is called _custom_email_list (contains a multiple select of employees). I created a new workflow field to store a temporary value I could then use in an email cc field. I tried populating…

Unfortunately no. We're still in the implementation phase and our NetSuite expert was unable to help either. In our case this was to track implementation details and we just went with a different solution. I am worried this is going to come up again at some point in the future though.