Good morning @Elychelle Gulen-Oracle I hope you had a nice weekend. That answer worked perfectly, thank you. Kind regards Oliver

Okay. I think I have it. It is using the internal ID of the custom classification. So logically speaking all I need to do is create the records in the order that the classifications were created, and the data should match up. Does that make sense? I don't know why I cannot do this by common name rather than ID, but it will…

Okay, another development. The amounts are not random. They are correct amounts but are just not associating with the right record. For example Record name - ONE - ITEM CLASSIFICATION - ONE - AMOUNT- 2000 Record name - TWO - ITEM CLASSIFICATION - TWO - Amount - 1000 When I look at the details of the search, 1000 and 2000…

Hi Kristoffer Thank you for your input. When I tried this it went back to being blank. Also when I tried removing the original filter 'Item Classification (Custom Column)' And left the Available filter as 'Internal ID' it is also blank. It seems only when the Available filter is set to 'Item Classification (Custom Column)'…

Okay I have an update. The field is now pulling through data. I needed to remove the filter from the Criteria tab and just leave it in 'Available Filters' for this to work. However the issue is not now fully resolved. The amounts being pulled through do not related to the record names. For example let's say I have a custom…

Hi Kristoffer I thought this might be the case. Thank you for letting me know. Fingers crossed the Enhancement comes soon. I will try to implement a workflow or script which achieves the result I want. Take Care Oliver

Good morning Kristoffer Apologies for not coming back to you sooner. You were 100% in your answer. The print buttons only print what is on the page, so the item fields you need to print have to be present, I added this one to my sales order form and it then showed on my picking ticket. Thank you so much for your help. Have…

Hi Mikko Yes, that looks like just the ticket. Thank you so much. Kind regards Oliver

Hi Srujana Did you ever get an answer to this? I am exploring integrating Google sheets with Netsuite at the moment. Cheers Oliver

Good morning Joy Thank you for your insightful reply. Yes, I believe you are correct and it is likely to be the outstanding POs without receipts which is the reason why no lead time is showing. I will proceed with this knowledge in mind. Thank you and have a wonderful day. Kind regards Oliver

Hi Dominica Thank you for your incredibly detailed reply. Yes, this solution worked perfectly and is a masterclass in how to run these reports. I am forever in your debt. Thank you and have an amazing day. Kind regards Oliver

Hi Joy Thank you very much for the detailed reply and the expansive nature of the answer. I will certainly take a look at voting for the enhancement and also the article on days to fuflil a backorder. Thank you for taking the time to put together this information for me. Kind regards Oliver

Hi Joahnna Thank you very much for your efforts and for the information. I will adjust the process accordingly. There's no need to apologise, it is a bit a convoluted process we are trying to implement anyway. Have a great weekend. Kind regards Oliver

Hi Joahnna Thank you for your message. Yes I will elaborate with screen shots, sorry if my answer was unclear. When I use this code: I get results like this: But what I am trying to do is deduct the total cost of these items combined from the figure 1949.98 However the report shows them on separate lines. I guess I am…

Hi Ivy Honestly not sure, it doesn't seem obvious where I would find our account type, the version information from the home page is below and doesn't seem to indicate OneWorld. However you are correct and the Inventory Adjustment method does work for entering serialized stock onto the system. Thank you for your time and…

Thank you @Ivy Lopez-Oracle I am very much a novice which is why I put things in the wrong fields, I have a great deal left to learn :-) Your answer was 100% correct as I knew it would be. My eternal gratitude to yourself and to John also. I think I was trying to apply this rule at a universal level rather than to each…

@JohnCirocco This is the lines on my results tab: DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),0,{quantity}) when I put the -nvl bracket around the quantity here it works to turn the negatives numbers positive but it also turns the positive numbers…

Hi John Thank you for the answer. When I put: Case when {type} = '%Assembly Build%' then ABS(nvl({quantity}, 0)) End In the Criteria Tab as per the below then when I run the search it comes back blank

Hello Ivy You have once again demonstrated your unstoppable genius! This solution were perfectly first time. Thank you so much, these forums are such a blessing. Have an amazing day. Kind regards Oliver

@Dominica Sevilla-Oracle The solution you proposed worked perfectly. This was a report instead of a saved search and the KPI worked as we wanted. Thank you so much everyone for all your input. A great community as ever. Have an amazing weekend. Kind regards Oliver

Thank you both for your guidance. I will be implementing these during the day today and I will report back and let you know how I get on, thank you! KR Oliver

Hi Mikko Thank you for coming back to me so fast. The report is a Sales Order Register, but knowledge of how to embed any report or saved search would be useful? Portlet refresh button would be preferable but browser refresh adequate. Thanks once again kind regards Oliver

okay, sorry, I got it, I changed it to: CASE WHEN {item.csegtdsl_subcat1} like '%Tape Media%' THEN NULL ELSE {fxrate} END and it worked. Thank you, have a great day everyone :-)

Hi Ivy I hope you are well. I am sorry to open this back up again but I have one last dilemma, I realised that rather than I long list I just needed to filter items prices from a certain category. So i changed the code to : CASE WHEN {item.csegtdsl_subcat1} IN (Tape Media) THEN NULL ELSE {fxrate} END but now it is saying…

Hi Ivy You are a genius, all works perfectly now, thank you so much for your wonderful help, blessed be. oliver

Hi Ivy Thank you so much for your help. however with the formula inputted I am still seeing the item rates, screenshots below, what am I doing wrong?

Thank you very much for the swift response :-)

Hi Ivy Probably a couple of dozen types of item. I just want the cell to be blank instead of showing the price. A couple of screenshots below:

Hi Erick Thank you for your answer. So I guess if I wanted to assign 2FA to just 1 person I would need to assign them a unique role and do it that way. Cheers. Oliver

Hi Jack If I'm honest I'm still working on it, can I can back to you over the weekend? It's been a very busy week here. Kind regards Oliver