Ramkumar Natchimuthu Red Ribbon

I got the date when the pricing was updated by using the 'Summary Type' as 'Maximum' When I checked the saved search result for an item that has the latest date of the pricing update, I could see the date value I needed. Thanks for your help again.

Hello @User_ZCWF3 & @Tigran Shahnazaryan, Thanks for your suggestions. Both the options suggested by you work fine, and I can get the date value now. Sorry for the delay in acknowledging the solution. The suggestions work perfectly as long as there hasn't been any update to the pricing. If there have been any changes to…

Hello @Tigran Shahnazaryan , Apologies, if I wasn't clear in my original post. This is an item search that needs to include the date when the pricing was initially set. Hence, I am trying to capture it from the system notes information of the inventory item. Regards, Ram

Hello @Tigran Shahnazaryan , Thanks for the response. I have now closed the case statement using the 'End', but the result is still the same.

Brilliant. That fixed the issue. Thank you very much for your help, @Elychelle Gulen-Oracle :) The final formula and the output are below:

Hello @Elychelle Gulen-Oracle, Thanks for the suggestion. I tried the following iterations of it, but everything ended up with this error message. I am unsure where I am going wrong. Formula1 ({name})||'|'||({displayname})||'|'||({custitem_f5_item_status})||'|'||(case…

Hi @Elychelle Gulen-Oracle, Please find below the snapshot of the formula: I am trying to get the result in the following format, and hence the '|' instead of space: Regards, Ram

Hello @Elychelle Gulen-Oracle , Thanks for your response. Unfortunately, the suggestion didn't fix the issue. I am still getting the other price values as 0 when concatenated.

Hello Robert @rnedelkow-Oracle, Thank you very much. I can now add/upload snapshots to my responses. Regards, Ram

Please note that I was able to do so earlier, as you could see in my previous community discussions. How to remove decimal point in Saved search? — Oracle NetSuite Support Community How to enable CSV job status alerts? — Oracle NetSuite Support Community

Hello @Micah Timbol-Oracle , Thanks for your response. I am unable to attach a jpeg file either.

Hello @Brian Stisser , Thanks for your help again. I couldn't get it working using the format mask, but I found another way to separate the decimals and concatenate them as required for the report. I truncated the currency value to separate the integer part TRUNC({baseprice}) I derived the decimal part using the formula x…

Thanks @Brian Stisser for the suggestion. SUBSTR works fine except when the price starts and ends with a '0'. For example: If the price is 10.00, the integer part is fine, but the fraction part is returned as 10 too. If the price is 0.01, the fraction part is fine, but the integer part is returned as 01 too. If the price…

Update: I found that the currency value converts as a number when I concatenated it with another column, but the formula drops the numbers after the decimal point if it is a '0'. For example, in the snapshots below, the currency value of $989.00 is converted as 000000989, but it should be 000098900. The currency value of…

Hello @Joy Noreen Magoling-Oracle, Thanks for your response. Yes, this is a saved search, and the snapshot in my query is a part of the result I am getting. I have provided a snapshot of the criteria for this saved search. Regards, Ram

Hello @Nicole Mendoza-Oracle, Thank you very much for your detailed response. I will give it a go and update the thread at the earliest. Kind Regards, Ram

Hello @Nicole Mendoza-Oracle, Thanks for your response. I haven't given this a try, as I need to familiarise myself with using scripts. Could you please refer me to articles on using/deploying scripts? Regards, Ram

Hello @Patrick Fresnosa-Oracle, Thanks for your response. The suggested solution didn't help as the files are imported by the system, and csv job runs through a script. The users who upload a csv file manually are getting the response you mentioned. Currently, I am relying on the Job status screen to identify the ones that…