There is a setting on item record "Can be fulfille/received" but there is no such thing on expenses or accounts. In fact the expenses and accounts should be non receivable by default, but NetSuite is doing just the opposite. It is difficult to understand why would anyone want to receive expenses ? which is an exception…

Everything was perfect and document followed. Apparently there are many undocumented fields like alternate depreciation Id, which is a record generated by system and needs to be mapped for all alt dep history. Finally resolved. Thanks all for the help.

this is the map and the csv file data, both - hope someone sports something unsual here

thanks @Emilia Ironov-Oracle @Mikko De La Fuente-Oracle @Erick Dela Rosa-Oracle The saved search is a summary search, yes I have got the template values and able to print non-summarized search results to pdf using renderer. Issue is to print summarized result from the search which is grouped by customer and sum by amount

Hello, I am trying to print search results to a pdf, and using the code from netsuite documentation, but it does not seem to work, var renderer = render.create(); renderer.templateContent = xmlStr; renderer.addSearchResults({ templateName: 'result', searchResult: results }); it seems that i am missing something here, can…

Hi Robert, There are some major issues with this interface listed below - a. Search bar is not always seen and difficult to locate b. Search results do not show up (search does not seem to be getting the desired results or very few and mostly no results) c. Links on the solutions (created in old user group) are broken

anothe thing missing is the ability to aggregate, group, summarize on the data tab. any way that we can do it ?

Hi @"michal.hrncirik" Can you please elaborate and explain if I can export my workbook data to a csv or excel ??

any progress on code completion for ss2 yet ? its been 4 years now

use Multiple Dependent Dropdown Lists check suiteAnswer Id: 10093

You can create cutsom field of list type in address record (e.g. your own countries) and use it

awesome job eric

For a bag ful of seeds , I would rather use batch numbers and input quantity of each bag in weight, this way i can track the bag as a batch and also enter partial quantity to be consumed in each batch and also pick reports by batch, serial number is more applicable to each single unit e.g. laptop, monitor, phones etc.

Appreciate your help. Thanks. Suitelets are server scripts, alert won't work. for calling a suitelet, check the below documentation. nlapiSetRedirectURL(type, identifier, id, editmode, parameters) This API is supported in user event and Suitelet scripts. You can use nlapiSetRedirectURL to customize user workflows within…

Item is one, what you need is count of transactions for that item, so add one column in search and select Transaction->internal ID with summary as count, you will see the number of transactions in that column, hope this helps.

create a saved search on customer - in filters select birthdate on today - this will list all customers having birthday on any day (variable) e.g. on nov 20 it will list all customers with birthday on nov 20 and the next day on nov 21 will show all with birthdate on nov 21

also the summary criteria is in 2 lines, you can rather put it in a single filter as - Maximum Transaction : Date is within 12/31/2015 and 1/1/2017

Yes, I remember null search filters were valid earlier but no longer working now. As far as using UI created saved search in code is pretty useful. This allows us to change the search e.g. filters, columns etc. without having to change the code all the time and just load it. Its pretty nifty implementation.

its not weird. its native netsuite behavior. in case you use a field in column or filter and the transaction does not exist at all for the customer it will not show up. e.g. i used a workflow field in column of a saved search, than the results only show which have the workflow record else they dont show up. theoritically…

the only troubling point is identifying all points through which he can enter the record and plugging them - and the before load will not work in search results where they will be able to see all records (though they will not be able to open these) -

thanks for all your help. #cdelacruz - this formula is pretty close but will not allow to set filter to last week automatically and will need changing formula. I will try and tune this and post if it works. thanks.

Build a transaction saved search and set type as Invoice in filters, Add another filter select -> Customer (Main Line) Fields and Sub Of (this specifies the parent) and select the parent here , this will show all invoices for customers who have that as parent, you can also set this on available filters to make it dynamic,…

great cdelacruz exactly i was looking for perfect. many thanks :)

it is pretty simple -> Goto Highlight If -> Select Formula Numeric -> Type formula ( {quantityavailable} - {reorderpoint} ) + {quantityonorder}) and below select Less than equal to , enter zero. This will do it. Hope this helps

why not use the field 'is reversal' this returns T for all reversal entries and F for all normal JEs.

You can create a custom field that can display values derived from summary saved search results. Each summary search field displays a rollup value for a selected search results field; this value is dynamically calculated each time a form containing the summary search field is displayed. For example, you can use a summary…

TO_CHAR({datecreated}, 'MON') - this is tested and working, returns 'JAN' etc. for months, hope this helps. Formula type should be text

there can be only one default shipping addres or a default billing address : for identifying total address create a save search on customer record - select address fields - in the criteria you can give a summary Count of Address > 2 (to list out all addresses more than 2)

yes, good news is that it can be done and I have resolved this successfully by using the dense rank / rank functions. Here is a bit of code to help : you can group ship date and partition by internal id.

simple solution is goto ->home>set preferences>general select checkbox 'only show last sub entity' this should solve it all around