Dominica Sevilla-Oracle Blue Diamond

Hello Chad, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

Hello @User_NZBD4, Welcome to NetSuite Support Community! ? Thank you for creating this thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other users, feel free join in the discussion as well. ?

Hello Melissa, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

Hello @MSStoke, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

Hello @FoxFoxFox, Good day! Hope you are well. ? Under the Results tab of the Saved Search, can you try utilizing the Summary Type = Count? You can add the field Internal ID and set its Summary Type to Count. Make sure that the Summary Type for other fields are populated as well. Below are screenshots for your reference.…

Hello Daniel, Good day! ? As per my understanding, you want to create a Saved Search similar to AR Aging and AP Aging, am I correct? If so, under the Results tab of the Saved Search please try adding the following: Field: Formula (Currency) | Summary Type: Sum | Formula: case when trunc({today})-{duedate} between 1 and 30…

Hello Shawn, Good day! ? Kindly check the steps below and see if it is feasible on your end. Under the Address tab of the Customer record, you can add the Billing Address and Shipping Addresses. You can mark the Default Billing checkbox to the Corporate you are referring to. Then, when creating a transaction, an example is…

Hello Chris, Good day! Hope you well. ? Upon further checking, there's an Enhancement filed regarding the relationship of Line Level, Class, and Assembly Items. It is logged as Enhancement 281919 Assembly Builds does not respect line level Classifications (Department, Class & Location). What I can think of as an alternate…

Hello @User_XMEU5, Welcome to NetSuite Support Community! ? Thank you for creating this thread. ? Can you please further clarify the Transaction Detail Report you are referring to? We appreciate if you can send sample screenshots of it. Kindly cover confidential information on the screenshots you'll provide. Allow our…

Hello @User_SZ0C3, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

Hello @User_SZ0C3, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

Hello @ChrisH, I consulted this with the team who have expertise on the subject matter and I am advised that Commission calculates with the following setup: > Based on = Sales > Per = Monthly > Categorized by = Commissionable Item Search (Criteria = Assembly Item) > Flat Rate = 3% I hope this helps and will work on your…

Hello @ChrisH, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

Hello @User_LYJBH, Good day! Thank you for creating this thread. ? It is by design that to approve a Vendor Bill, the user must at least have a permission of Bills = Edit. Enhancement 240001 Roles & Permissions > Ability to approve vendor bill transactions by assigning the Vendor Bill Approval permissions with Bills…

Hello @CDuf, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

You're welcome, Oliver! Glad that we were able to help. ❤ Thank you for your feedback. Thanks to @JohnCirocco too for sharing insight on this concern. ? Enjoy the rest of the day and please stay safe! ?

Hello Daniel, Good day! Thank you @Matrim for sharing your insight on this. ? This is to confirm that what Matrim provided works. Under the Results tab of the Saved Search, use Applied To Transaction Fields... Document Number instead of Applied To Transaction, and this will display the desired behavior. Hope this will work…

Hello Oliver, Good day! I am glad that the formula worked on your end. ? Noted that you created a thread for this concern, Show all items. Let's wait for our Gurus to reply on that thread as they have the expertise on Item records. Hoping for your understanding on this. Also, we love to hearing feedback from you. It is…

Hello Irene, Good day! Hope you are well. ? I would just like to follow up on this concern. Can you confirm if using {CURRENT_DATE} instead of {CURRENT DATE} worked on your end? Your feedback are highly appreciated. By marking “Yes” on the “Did this answer your question?” if you find the comment/s helpful, you’ll be able…

Thank you for your kind thoughts about the Community, Oliver. We appreciate it. ❤ When you add this formula on the Results tab, it will create a new column on the result of the Saved Search. This column will not be blank as it will display either the value of Items Quantity Committed or 0 if it's null. After testing this,…

Hello Oliver, Kindly check the responses on this thread - Return 0 for null value in saved search, and see if it will achieve the expected behavior for this concern. Thank you! ?

Hello Oliver, Good day! Thank you @JohnCirocco for your suggestion. ? Under the Results tab of the Saved Search, add the field - Formula (Numeric), then on the Formula field add NVL({item.quantitycommitted}, 0). With this formula that John suggested, it means that if there's a value on the Quantity Committed then it will…

Hello @Tybrneryan, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?

You're welcome, @Hormese Paul. Thanks for your understanding on this. ?

Hello Daniel, Good day! Thanks again. @JohnCirocco. ? And John is right.. again. ? To display Vendor Invoice Number and Item Amount, scroll down to Applying Transaction Fields... then you can select: Transaction Number Amount Item Rate To learn more about Transaction Saved Search join fields, you can check these…

Hello @Hormese Paul, Good day! ? Upon checking on your concern, Electronic Bank Payments SuiteApp is not compatible with the Vendor Payments preference and is still logged in Enhancement 545485. Currently, there's no alternate solution or workaround documented for the said issue. To request or vote for an Enhancement,…

This is noted, Oliver. ? May I ask for screenshots of the Criteria and Results tab of your Saved Search? Kindly cover confidential information on the screenshots you'll provide. Allow me to further check and run more tests on this. Thank you! ?

Hello @jmack_admin, Good day! Hope you are well. ? Do you find any comments for this concern helpful? Your feedback is highly appreciated. By marking Yes on the "Did this answer the question?" question, it will tag the comment as Accepted Answer. With this, it will also help other members of the community that might…

Hello Oliver, Good day! ? Based on my understanding, you want to create a Saved Search that will display Sales Orders that have particular Items. 1. Go to Lists > Search > Saved Searches > New 2. Select Transaction 3. On the Criteria tab > Standard subtab, add the following : Type = is any of Sales Order Date = Select a…

Hello @Sjöbeck, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Thank you so much! To other users, feel free join in the discussion as well. ?