Ivy Lopez-Oracle

Hi @User_NG5TG, Here's the revised formula based on the recent one you provided: SUM({tranestgrossprofit})/SUM(NULLIF({amount}-NVL({taxtotal},0),0))

in Accumulated (Not Average!) GP % by Sales Rep Comment by Ivy Lopez-Oracle Oct 11, 2023 1:20PM

Hi @User_JPTT1, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Vendor Preferences (Send Transactions VIA) Comment by Ivy Lopez-Oracle Oct 10, 2023 4:14PM

Hi @Jay Schwausch, Try the following: In the Results tab, use Name field only instead of Bill of Materials : Revision : Name In the Criteria tab, add the ff to get only the active revisions: Effective Start Date is on or before today Effective End Date is not on or before today Hope this helps!

in Why does bom export have items from different revision Comment by Ivy Lopez-Oracle Oct 9, 2023 9:55PM

Hi @OliverK, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in Collapase/Expand buttons not in exported report Comment by Ivy Lopez-Oracle Oct 9, 2023 4:31PM

Hi @Shubham_Singh, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Emergency||SCA Website|| Global Search issue? Comment by Ivy Lopez-Oracle Oct 9, 2023 4:12PM

Hi @User_J6WYT, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Inventory status not working as we want Comment by Ivy Lopez-Oracle Oct 9, 2023 3:55PM

Hi @Paul L. Walker, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case…

in How can a Customer Deposit be Fully Applied when the Payment Amount is more than the Applied amount? Comment by Ivy Lopez-Oracle Oct 9, 2023 3:53PM

Hi @User_BMWKP, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Connector Amazon FBA Shipping Charges Comment by Ivy Lopez-Oracle Oct 9, 2023 3:32PM

Have you tried setting the Demand Transaction Sorting Options under Setup > Order Management > Supply Allocation? Also, can you share details of the Allocation Strategy set on the order?

in Reallocate Order Item not selecting future Orders by default Comment by Ivy Lopez-Oracle Oct 5, 2023 10:04PM

Hi @Jay Schwausch, Let us know if you need further help on this by providing the steps to reproduce the behavior you mentioned.

in Why does bom export have items from different revision Comment by Ivy Lopez-Oracle Oct 5, 2023 9:56PM

Hi @User_UY6JW, Were you able to check @Paulene Lomeda-Oracle's comment? If it was helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock the Answer Accepter badge. If you still need…

in NSPB OPex prior year actuals is pulling Prior year before last Comment by Ivy Lopez-Oracle Oct 5, 2023 9:51PM

Hi @Chandanesh, I don't think your requirement is possible in the system yet. Per further checking, I did find some existing enhancement requests related to it: Enhancement # 339208: Assembly Matrix > Ability to assign unique components on different matrix option combinations during initial creation of the matrix item…

in Create the Matrix (Assembly) in netsuite Comment by Ivy Lopez-Oracle Oct 5, 2023 9:48PM

Hi @User_FZNHI, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In the…

in How to create a Custom Field that will total all of the Purchase Prices in the Item sublist? Comment by Ivy Lopez-Oracle Oct 5, 2023 5:04PM

Hi @markival, Per checking, there is currently no inventory aging report in NetSuite. This system limitation has already been requested in: Enhancement # 44650: Ability to generate an Inventory Aging Report that displays historical on hand quantities and the age of these quantities at a specified date range You can vote…

in Saved Search or report which returns Inventory Status aging Comment by Ivy Lopez-Oracle Oct 5, 2023 2:28PM

Hi @GSONI, Per SuiteAnswers 108951, the Costed Bill of Materials SuiteApp requires a NetSuite OneWorld account. You can also check SuiteAnswers108952: Prerequisites for Installing Costed Bill of Materials.

in Bill of Materials Inquiry Comment by Ivy Lopez-Oracle Oct 5, 2023 1:34PM

Hi @Panadick, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in How to hide Create New button in Opportunities? Comment by Ivy Lopez-Oracle Oct 4, 2023 3:44PM

Hi @Jay Schwausch, Can you provide more details on the exact steps you are doing when trying to export BOMs?

in Why does bom export have items from different revision Comment by Ivy Lopez-Oracle Oct 4, 2023 3:16PM

Hello, Per checking some related cases on this one, it seems this error is received because NetSuite only generates recommendations to reallocate for line items that have not been fully allocated. This is also implied on SuiteAnswers 93624: "The Sales Order, Items subtab displays how late the order is and how much…

in Reallocate Order Item not selecting future Orders by default Comment by Ivy Lopez-Oracle Oct 3, 2023 10:13PM

Congratulations, @Tigran Shahnazaryan! 🎉

in TOP CONTRIBUTOR FOR SEPTEMBER 2023! Comment by Ivy Lopez-Oracle Oct 3, 2023 4:43PM

Hi @kfluk, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in Audit problem - Obtain Cost of Goods Sold Comment by Ivy Lopez-Oracle Oct 3, 2023 4:37PM

Hi @User_HWW8S, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Custom List VIew Comment by Ivy Lopez-Oracle Oct 3, 2023 3:48PM

Hi @User_4R80Z, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in NON-DEDUCTIBLE Feature - Countries eligible for feature Comment by Ivy Lopez-Oracle Oct 3, 2023 3:33PM

Hi @JDKru, Were you able to check my previous comment? Let us know if it worked or if you need further assistance.

in FEFO Permission Error Comment by Ivy Lopez-Oracle Oct 2, 2023 9:55PM

Hi @User_NG5TG, Were you able to check my previous comment? Let us know if it worked or if you need further assistance.

in Accumulated (Not Average!) GP % by Sales Rep Comment by Ivy Lopez-Oracle Oct 2, 2023 9:55PM

Hi @User_V5KBL, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Maximum Number of Tasks/Milestones on a Project Comment by Ivy Lopez-Oracle Oct 2, 2023 4:08PM

Same with saved searches, this is not possible in Analytics as well. As mentioned, there is the new Costed Bill of Materials SuiteApp that you can check. If that is not feasible for you, then the next best thing is to reach out to your developers or to your Account Manager for possible engagement with our ACS or…

in Bill of Materials Inquiry Comment by Ivy Lopez-Oracle Oct 2, 2023 2:43PM

Hi @User_NG5TG, Based on the formula you provided, can you try if this will work: Formula: SUM({tranestgrossprofit})/SUM(NULLIF({netamountnotax},0)) Summary Type: Maximum

in Accumulated (Not Average!) GP % by Sales Rep Comment by Ivy Lopez-Oracle Sep 29, 2023 6:36PM

Sorry to hear that. However, other than this SuiteApp, there isn't anything else we can provide as this is not possible in saved searches. You can reach out to your developers or to your Account Manager for possible engagement with our ACS or Professional Services team for a customized solution for you.

in Bill of Materials Inquiry Comment by Ivy Lopez-Oracle Sep 29, 2023 6:15PM

Hi @CDuf, Try adding Item: Type is not Item Group in the Criteria. This should remove the parent item line (Item Group) but still show the components on the order.

in How to remove "End of Group" line from a transaction saved search? Comment by Ivy Lopez-Oracle Sep 29, 2023 6:10PM

You can vote and add your comments for Enhancement # 213226 in the SuiteIdeas page.

in Why is UPS SurePost not integrated into Netsuite Comment by Ivy Lopez-Oracle Sep 29, 2023 5:57PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments