Following your instructions, I used the suggested syntax, but unfortunately, it didn't resolve the issue as anticipated. The specific error message I'm receiving is "Search error occurred: Invalid or unsupported search," which occurs when I include "AND Item.custitemcustitemcolor = 210" in the where clause of the query.…

Thanks, @Niks Blando-Oracle This matter is resolved. I have another query that is linked to this but already following it on another thread with the subject "Query Regarding Allocated Stock in Supply Planning Workbench" and the detail is " I am reaching out to discuss an observation regarding the Supply Allocation feature…

Thanks, @Joy Noreen Magoling-Oracle. I am reaching out to discuss an observation regarding the Supply Allocation feature in our system. As you know, this feature displays key metrics such as Quantity on Hand, Quantity Allocated, Quantity Committed, and Available Quantity, as illustrated in the attached screenshot: However,…

Thanks, @Richard James Uri-Oracle Please see the below code for your reference as the error is the same : " SELECT T1.matrixoptioncustitemcustitemcolor,T1.custitemcustitemcolor,T1.id,T2.custbody_sale_order,T1.custitemcust_process_group FROM manufacturingTransaction T0 INNER JOIN Item T1 ON T0.assembly=T1.ID INNER JOIN…

I'm encountering an issue when attempting to allocate Lot Number Items for my Transfer Orders and would appreciate your assistance. Here's the process I follow: I navigate to Transactions > Order Management > Allocate Orders. I then select 'Transaction Type' as 'Transfer Order' and enter the specific 'Order No', which is…

Hi @Michelle Jabanes-Oracle , your reply seems irrelevant, may be you have typed in a wrong window.

Thanks, Michelle Jabanes-Oracle, Upon further review, I noticed that the permissions weren't added in my setup, yet they still appear in Menu. I suspect this might be related to the Accounting Center Type. If this functionality isn't currently available in NetSuite, it might be a worthwhile enhancement to consider.

Thanks, @Angelica Mae Segador-Oracle Yes, I have explored the above links but these do not answer my query to find/get custom fields from the Inventory Detail section while creating the Workbooks for lot items.

Thanks @Niks Blando-Oracle. Yes, you are right that we want to join two different types of saves searches "Planned Orders" and "Transactions" No, "Planned Orders" is a saved search type that NetSuite offers.

Thanks @Michelle Jabanes-Oracle. The permission table for the standard A/P Clerk role, as displayed in previous image, doesn't include the "Customer" or any customer-related navigation menus and reports. However, in our instance, these options are unexpectedly visible. This seems to be an abnormal behavior, and I'm seeking…

hi @Shrinivas K , have you found this solution? if anyone knows the solution then please share it.

Thanks @Joy Noreen Magoling-Oracle for your reply. I am currently experiencing a challenge while working with two datasets that I've created and joined based on transaction types. For clarity: Dataset 1: This filters Transfer Order Types. Dataset 2: This filters Work Orders. Both datasets are effectively joined based on…

Thanks @Angelica Mae Segador-Oracle for your reply. As I mentioned earlier it's a standard workflow from the suite bundle, please find the screenshot below.

Thanks @Niks Blando-Oracle for your reply. I want to create a link between the "Planned Orders" Saved search with the Transactions type saved search to manage and visualize our Planned Orders in conjunction with their corresponding transactions. Detailed steps on establishing a link between Planned Orders Saved Search and…

Thanks @Jervin Nicholas Teopengco-Oracle for your reply. I need to create a custom column in sublist that spans multiple columns as shown in above image i.e. Item Field List showing multiple columns when we expand open the list purchase order form. Creating a custom column list having multiple columns (showing Employee…

Richard James Uri-Oracle thanks for your reply. We have encountered a SuiteScript error that we could use your expert advice on. Our aim is not to create a record; instead, we're retrieving data from Item Receipt upon changing the Item Receipt number field, utilizing the code provided below. var subrec =…

It's not providing any option even in the standard workflow available in bundle id: 240841 "NetSuite Approvals Workflow.".

I have clicked the Yes button. It answers my question as this feature is not yet supported but I would like to know the roadmap of it as it's an essential feature of other Analytical tools.

I have created two datasets and linked them together. Now, I have created pivot tables, and they are working fine. However, when I attempt to add a column from one dataset, the other dataset gets removed from the option list when I select 'Simple Table' from the options.

Hi @Angelica Mae Segador-Oracle, Hopefully, this finds you well. We have thoroughly examined the standard default approval workflow alongside the bundle id: 240841 "NetSuite Approvals Workflow." Furthermore, we have ventured into customizing our own workflow to meet our specific requirements but we have not found any…

@Ivy Lopez-Oracle Thanks. Can someone provide the solution to my question?