I want to create a saved search where I can go back and check the item where the price level value is blank as of that day so I can update in next time.

Thanks for the response, any way or suggestion to fetch the records in saved search or report? Currently not using the suite analytics books , but trying to do the changes with the UI thing

Thanks for the response but still the same results and not align with expected results. Also I have tried with the empty but the item itself is not even considering to fetch in the search. But we are getting the Item if the price level as 0.0 Thanks Chandanesh

Hi @Jeanne Padilla-Oracle , thanks for the response. And yes , I'm looking for the Account description as you mentioned in the screenshot for the account. Currently By Account Name I can search but I want to search by the Account Description. Do find the version here : Please let me know if you need any further details

@Shorin Rio Daa-Oracle thanks for the feedback, yes I have followed your approach as per the first answer and I'm using only the Item name,document number, Item description,date,qty sold and total revenue. I dont have the problem with the report , instead I cannot see all the Parent Item names in the filter(parent item…

Hi @ Gregz-OracleThanks for the response and appreciate the time you have taken to check this. I'm using the same role to access the Netsuite UI and the API request. I can fetch the result for all the other records and transactions but not sure why I couldn't able to get the location data with item record results. P.S.: I…

No, I want to fetch the location details for the Inventory item as I attached the screenshot above, but with the API I cannot get them. I can see the location data in the Netsuite for the Item record. I really appreciate any help you can provide.

Hi, @Richard James Uri-Oracle thanks for the response, I'm not getting any results for the Location, so querying the null/ empty array won't get me anything and I have tried it already but ended up with no result for the location. Is there any other way to fetch the location data/details for the items in Netsuite with the…

Hi All, Thanks for the suggestion I have solved the issue by adding the require and related List and Transaction options to the role.

Please search with the keyword " Sales Reps " you should be able to find the list of sales reps existing in the system.

Hi @Jervin Nicholas Teopengco-Oracle, Please find the below image for reference It's not there in any of the record

Hi @ Jervin Nicholas Teopengco-Oracle , no I want the static text field such as Deposit Due, Due upon Shipping and Shipped, not invoiced. I want these status texts to appear on each purchase order transaction. Please let me know how I can do that or any suggestions. Thanks in advance

@Jervin Nicholas Teopengco-Oracle Static field is meant to be the Status field in the above screen where you have 3 different values for the field and then you need to render them for each transaction. How to get them in the report or saved search? Thanks for the help

Yes, I have created a saved search as the report, which will have the same Item name (Format) and Line ID. Then while updating used the SO order number and the Line ID of the Item. This approach worked for me.

Hey as per we are working with the Netsuite data in the PowerBI, You cannot directly access any data from Netsuite instead, you need to go with the Allow Web query option with the link, you can import the data in PowerBI easily. The catch over here is that if the data is too large you cannot get it all at once(Not more…

Hi @Angela Bayliss would the above formula give the Quantity shipped? How to get the Open units? Any idea on this? Thanks for the swift response

JOURNAL ENTRIES

I have created the saved search by following the steps suggested, the problem with that is it's fetching all the customer data instead of only the specific customer which the user opens it. Ex: If a Customer opens the link then should be able to see only the data respective for Customer A. same way when B opens should be…

@Able Wilson, I have created the custom saved search but how do we set the same report with the same customer whenever they open? Now I have created it for the one customer and it reflects only that customer report in all the customer dashboard

@Jeremy Guimaras -Oracle The suggestion which you given for a specifc customer but I need to maintain the same report for all the customer and open it respectively. Any idea on that?

Hi @tech work if you are an admin and have the option to add the portlet link, then right-click on the top right there you will find the option to personise the portet and there you can able to see the option to add a link or add a saved search or report snapshot ,etc

@Able Wilson thanks for the response but I have created the different Saved report and not the saved search. How do we add that here to the Customer dashboard? Also, can you tell me if there's a way to add the link to it anywhere on this screen? Thanks in advance Chandanesh

@Able Wilson how do we set the same for all the customers? Thanks for the response

Hi, and @Able Wilson Thanks for the response, Have figured out whats the issue is by myself. Below is the insights: If the Item is used more than once in any of the Sales orders we also have to give the Line ID so it differentiates between which we are updating. 2. The Item name is not in the right format as per the…

Hi, I'm facing the same issue while am updating the revise ship for the item in the Sales order. If I use the Item name and Internal ID it gives: Record has been deleted since you retrieved it error. If I remove the Internal ID it gives this error: Ambiguity error on logical key multi-match. Any way to fix this and it was…

Hi @Elychelle Gulen-Oracle, thanks for the response, let me reiterate the issue again. As per the above screenshot which is attached, the Item group gets the different date and all other items have the different dates (Expected receipt date). Why is that happening? Also, I have tried to change the vendor to Item group but…

Hi @Angelica Mae Segador-Oracle we are not using any of the workflow, also for the revise ship date we are updating this field using CSV based on the item availability. Thanks

Hi @Niks Blando-Oracle We have a field called Revise Ship date in the Sales order and we have the Expected Ship date. Both are two different fields, Revise Ship date for items in SO For the same item when I click on the Special order button to create the PO,it navigates to the PO screen with a different date as in below…

Hello @Tristan Joy Mendoza-Oracle Thanks for your comments , If you see the standard cost of the item at location "on the water" is 243.27 and purchase price is 262.77 ,but only variance amount should go to the purchase variance account right. but in our case all the amount is moving to variance account ,I have attached…

@Niks Blando-Oracle We have searched the Internet and the Oracle community for help or some blogs to implement / Configure the FIFO in the Netsuite by switching it from Standard costing, but unfortunately, there is no documentation/blog isn't available. So if someone had implemented/configured it would be helpful to have…