Hello Chad, You can try creating an Item Saved Search. Navigate to Lists > Search > Saved Searches > New Select Item Under the Criteria tab, add Transaction Fields.. > Status > Sales Order : Pending Approval Then under the Results tab, add the following: Name | Summary Type: Group Transaction Fields... Quantity | Summary…

Thanks, Chad. You rock too! ❤ Enjoy the rest of the day and please stay safe. ?

Great! I'm glad it worked. ? As for the quantity, under the Results tab, add the field, Quantity. I hope this will work on your end too. ? ----------------------- If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your…

Thanks for checking, Chad. ? Under the Criteria tab, instead of Approval Status is Pending approval, can you try Status is Sales Order : Pending Approval? I hope this will work on your end. Thank you! ? --------------------- If you find this reply to your question as helpful, others with the same question might find it…

Hello Chad, I further check your concern. As per my understanding, you want to have a list of Items included on your Sales Orders which are in Pending Approval. Navigate to Lists > Search > Saved Searches > New Select Transactions Under the Criteria tab, add the following: Type is Sales Order Status is Sales Order :…

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…