Hello Everyone, Does anyone know of a way to either get the Lot Number Expiry Date from Transaction Inventory Detail (Line) record ? OR We store lot # in YYYYMMDD format, how can i convert this to DD/MM/YYYY in saved search?

Invalid expression. TO_CHAR({inventorydetail.inventorynumber},'DD/MM/YYYY')

And inventorydetail.inventorynumber gives what value?

Inventory number is your lot number, the expiration date is probably something like {inventorydetail.expirationdate}

that is not exposed onto the Saved Search.

You can try to use

TO_CHAR(TO_DATE({inventorydetail.inventorynumber},'YYYYMMDD'),'DD/MM/YYYY')

Is there a way to not have '- None -' show up on summary search results and just have an empty field like the normal results?

How can I calculate the hours between two date/time fields? Thanks in advance.

Is it possible to list out all of my bins, and the QTY of items in them? I cannot seem to do it via a bin search.

I do not believe you can do that in one search, the on hand values are not actually tied to the bin records

Anyone knows if there is a way to have a link in a search with dynamic values based in the environment. In other words is possible to know the environment(Sandbox or Production) from a search or search formula?

Unreal. Thanks Sandii.

Hi all, Chrome plugin for SuiteAnalytics Workbook export to SuiteScript was created. Enjoy! https://chrome.google.com/webstore/detail/netsuite-workbook-to-suit/egmkcpbmbcfenkfmphbfomegdckknnhj?utm_source=chrome-ntp-icon

Is thier a way to create a saved search with bins that are empty?

Hi Everybody, I have a question on a saved search on Transaction item lines. I know that on the first two lines of an Item Group, a certain field (Asset in this case) should be filled. So this is on the Item Group line itself and the second line in the group. See the first two lines in the screenshot. For some reason only for the first line of the item group the asset field is filled. With a saved search I can determine the second line for which the Asset is empty, but I cannot get the asset value from the first line. I would like to use that to do a csv update. Does anybody now how I can get this information in the saved search. Probably a formula is needed here. Good to know, the item group can be on any line number of the transaction. But always for the first line of the item group, the asset is filled, and for the second line it is not. Many thanks.

Hi All, I need to extract logs of a specific time of yesterday. Hence wrote a saved search on "Server Script Logs" type, with date as 24th feb 2020. But im struggling to extract the logs only between 2:00pm to 3:00pm. How do i achieve this using "Formula (Date) {time}>2:00". I tried and ended up with an error : Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit. Search: Server Script Log Search Formula: {time} > 2:00 Please suggest the best way to extract logs between 2:00pm to 3:00pm

Hello all. I am running the Open Purchase Orders Report (NetSuite Standard Report) and would like to add "Preferred Vendor" as a column/filter. The preferred Vendor is giving me list that has nothing to do with vendors (just numbers) Is it possible to do this or no because Preferred Vendor is a sublist on the item?

I have created a workbook report off a custom record, there's one field on the custom record that doesn't show up. All other fields are accessible except for this one field. Anyone encountered this issue?

Hi there! Is there a way to only use the US keyboard language? Right now we import rosters and foreign characters are allowed in. Can we prevent that somehow? An example would be: Ślachetka - The accent on the 'S' is an issue for searching for others.

@Shannan Brown i'm not familiar with rosters. if this is a csv import, you may want to just find and replace in Excel. netsuite has settings for foreign language/keymapping i'm sure, but it sounds like you have bad data coming in. making foreign characters not allowed would not clean up the data coming in.

I’m pretty upset that there is no week option when selecting a date hierarchy in new analytics

Props to you for actually using it. It's been so long since i've attempted anything in it. I even sat through training on it.

I am having issues with a formula and I might be going about it the rong way. I want to add a column to a saved search that shoes the 1 sublist item from a record based on a criteria that I define. Example: A saved search on Cases that gives me the latest message: I have tried the following formula: case when ((dense_rank () over (order by {messages.message} DESC)) =1) then {messages.message} else NULL end I noticed that this ranks the results in the saved search and not the messages sublist of cases. Does anyone have a solution/can tell me what I am missing?

Is there a way to find records which have had a certain field changed?

I am struggling with a formula to have a columns count for yesterday, MTD, YTD any help would be great

Hi all - We updated a workflow today and it is not respecting the new conditions. We waited a few hours in case it needed time to update, but it is still showing the old conditions on the workflow tab of the transaction record. Any idea why the workflow condition is 'stuck'?

one of our reports has been in the 'processing' state for more than 2 hours - is there a way i can kill this off?

is thier such an assembly build saved search report ?

You can certainly target that record type in a transaction saved search