Thank you @John Griffin - Greatly appreciated

@John Griffin - Not sure I understood your last remark, could you please elaborate? Our goal is to create a report which will shot the TO which are still not fully fulfilled, however since this is a one to many case (we can have multiple IF for the same TO for the same line Item) this is tricky business. Do you have a…

@John Griffin - WOW, found a work around, I created an Identical search from transaction TYPE: Item Fulfillment and was able to extract all the data, it works!!!

Thank you @John Griffin for the checkup, one more question if I may, why am i unable to how the QTY Fulfilled? any Ideas, I see TO which were fulfilled byt in the search the QTY is showing false...TNX

Hi @Nicole Mendoza-Oracle - Just to clarify, the checkbox IS NOT TICKED and the error user is getting is colored in red mentioned that one or more credentials are incorrect, please try again, this is based on memory since I do have a screenshot for this. Thank you

Thank you @Kristoffer Viray-Oracle - could you kindly advise on the Saved search as well? thank you

Thank you @John Griffin unfortunately, this isn't working for me, It is showing the same values for both field, @Joy Noreen Magoling-Oracle - Could you please assist? BTW, I am not grouping my results as John, so that could be the reason, however I do need to. Also when testing just now, same results, thank you.

Thank you @Nicole Mendoza-Oracle for all your trouble. We were just able to establish the connection today and view all tables, thank you very much for all you assistance, I will be keeping this document.

Hi @Niks Blando-Oracle - I have read the article serval times and I am not sure how the setup should e done exactly, do mind sharing some screenshots of the setup on your end, both for custom field & saved search. BTW, since I do not want to confuse the users, would it be possible to have this field as a hidden field but…

Hi @Nicole Mendoza-Oracle , one last question if I may, when we are trying to connect NS to Rivery (ETL) we get the error below: Error: Failed to connect to Netsuite with: java.sql.SQLException: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]The NetSuite.com data source is no longer being updated…

Thank you @Nicole Mendoza-Oracle got this to work!

Thank you @nicole I am still looking this over. Will keep you posted once completed, happy holidays :)

Hi @Nicole Mendoza-Oracle, I hope that all is well. Could you please review my last questions? I am in desperate need of assistance with this and running into more and more road blocks as I moving along, thank you.

Thank you @Clarisa De Torres-Oracle - This report did the trick.

Hi @Nicole Mendoza-Oracle - Yes this has been helpful and a start, but I must say I am running into a very strange issue. All the connections I try for roles which I have modified as advised by NS articles to have the required permissions are not working, the connection test fails, HOWEVER when using the role which doesn't…

Thank you @Dominica Sevilla-Oracle - Surprisingly the there were no results for the search. Any ideas what I am missing here? Please see screenshots below, thank you.

@Nicole Mendoza-Oracle please see below the screenshot of what I have on my end, thank you for your feedback.

Hi @Nicole Mendoza-Oracle, thank you for your feedback, please see my answers below: I am using a Lenovo E14, not a MAC Yes, I get the message below, I am not sure why, I install it and when I try to run the EXE file, it is asking me if I want to uninstall it, not sure why. I am aware, I just want to point out the host as…

@eleran - Just tested this again and It worked, so thank you. This is so odd, I have done so many of these and also tested last and it didn't work. I hope I am not losing my here LOL :)

@eleran - I have tried this as well, but to me it doesn't make sense, also based on NS articles, this is how the set should be. the second of all 12 months. But I could be mistaken...open for anything, thank you

@Ivy Lopez-Oracle - works great, Thank you very much

Thank you @Michelle Jabanes-Oracle - Will give this a go.

Thank you @Ivy Lopez-Oracle - will give that a try

Thank you @Jack Daryl Espiel-Oracle - Working! this has been very helpful

Thank you @Ivy Lopez-Oracle, I would like to try and challenge you with something to see if it is possible. Eventually as I have mentioned our objective was to measure when the Vendor Price has been changed. So would it be possible to build a formula that compares todays price to yesterday, if nothing has changed then do…

Hi @Jack Daryl Espiel-Oracle, thank you for your response, based on the criteria's shared in the screenshots above, i would like to the data to pour out as to the table shared below. As to appose the current stage where the search is working great but all the data of the date is poring into one column, where I would like…

Thank you @Michelle Jabanes-Oracle - This has been upmost helpful. My last question would be, what are the best practices/efficient/quick way to create a pseudo-Administrator role? Since this is the role that cannot be customized, I am not sure which next vanilla role has as much permissions as an admin...

This is the case I have tried with no results (not error, simply blank). CASE WHEN {systemnotes.field}={custbody_as_po_sent_for_approval} THEN {systemnotes.date} END

Hi @Michelle Jabanes-Oracle, Thank you for the articles, I have reviewed all the documents I could find on the SSO set up and was not able to find out what I am missing here. I have addressed the question here after a lot of research and unfortunately was not able to find anything. As for the bulk update, thank you, I will…

Thank you @MathewB - I read this article already but I didn't find anything in regards to the setup I performed and the issue I am facing. Have you found something maybe I missed?