Mi contenido
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Staying Connected During the Holidays
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Comentarios
-
Hi @User_NC62U, If you are using a Transaction Saved Search, then you can get the Customer Name by using the fields Name, Main Line Name, or Customer (Main Line): Name. For the Order Number, you can use either Document Number or Transaction Number. Hope this helps. -Ivy ========================= If you find this reply to…
-
Hi @Benjamin Paul - USA, Per checking my resources, I noted that the specific error message that you mentioned is not a standard error by the system. Please check your account for any scripts or workflows that might be causing this error message.
-
Hi @User_1CGRH, Currently, there is no standard report that would generate an aging on Serialized Inventory Items which is requested under Enhancement 134988. You can vote for it in the SuiteIdeas page. As a possible workaround, you can try to create the saved search that is documented in SuiteAnswers 37214 & 73370. Anyone…
-
Thanks for the update, @OliverK! Glad that it is now working as needed on your end. ?
-
Hi @User_6CZJG, Did you add the formula in the Criteria > Standard subtab or in the Summary subtab? If you add it in the Standard subtab, it will return an error since this does not support formulas with Summary Types included such as SUM, MAX, MIN, COUNT. That said, try adding the formula in the Criteria > Summary subtab…
-
Hi Oliver, You mentioned in a previous comment that you wanted to concatenate the results per Sales Rep, which is what the formula I provided is doing. Based on your most recent comment, what you are looking for basically is to have the Actual Accounts divided by the Target Accounts column on your saved search. I reviewed…
-
Hi Oliver, Can you elaborate on what you meant with "column is showing a column for each sales rep in every cell rather than just 1 for 1"? Do you need it to compute like 'Actual Accounts' / 'Target Accounts'? If so, what is the formula you used for these columns?
-
Hi @Julien Mi Electronics, I don't think a function similar to vlookup is available for Saved Searches, but still I did some tests on your requirement and here's the saved search that I came up with: Criteria > Standard Criteria > Summary Formula: CASE WHEN MAX({quantitybackordered}) < MAX({quantityavailable}) THEN 1 ELSE…
-
Hello @Julien Mi Electronics, For your requirement, we need to add a Summary Criteria with this formula: MAX(nvl({item.quantityonorder},0))-SUM({quantity}-nvl({quantityshiprecv},0)-nvl({quantitycommitted},0)) Then we need to add Summary Types to the fields in the Results tab: Here's a sample of the result of the search:…
-
Hi @User_1K0CO, Try this in a Formula (Currency) field with either Maximum, Minimum, Average or Sum as the Summary Type: SUM({debitamount})/SUM({quantity}) Let us know if this works for you. -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it…
-
Hi @OliverK, The specific formula I provided will only work in a Formula (Text) fields since there are text characters (space and pipe symbol) in the end result. Here's the modified formula to show the number as percentage: ROUND((COUNT(CASE WHEN {salesrep} = 'XXXXX' AND {mainline} = '*' AND {type} = 'Invoice' THEN…
-
Thanks for your suggestions, @Steve Barrett! --- Hi @OliverK, I still don't get how you want it to be shown in the results of your search. Can you provide an example? You can use excel or something similar to illustrate your desired results. If you want it to show as a total, then maybe you can try adding the plus sign…
-
Hi @Keith Boatner, There is a related enhancement to this which is filed under Enhancement # 659671: ATP based upon longest lead time of missing component(s). You can vote for this enhancement via the SuiteIdeas page. There is no documented workaround for this yet, but I'm also interested if anyone has come up with an…
-
Hi @Dirk Nieuwkamp, The Warehouse role is using a custom Center with custom Center Categories and custom Center Links which is why the Generate Inventory Report is accessible via that navigational path. For Administrators, there is no standard navigational path to get to this page, but you can create a custom Center Link…
-
Hi @User_GE47I, Let us know if you have further questions on this one.
-
Glad I was able to help! ?
-
Hi @Vernita, It seems that is the standard behavior when using a Formula (Text) field and the result is a decimal number that is less than 0. I did a simple test on my account that proves this: Results tab: Results page: To have the 0 before the decimal, try using Formula (Currency) or Formula (Numeric) field. If that is…
-
Hi @Dwight Schrute, Try this: CASE WHEN {shipcountry} IN ('United States','Canada','Mexico') AND {custcol_as_expecteddeliverydate}-{custbody_as_final_ml_ts} < 14 THEN 'North America - IN SLA' WHEN {shipcountry} IN ('Brazil','Chile','Guatemala','Dominican Republic','Argentina','Peru','Colombia','Puerto Rico','Costa…
-
Hi @User_GE47I, When Inventory Items are entered into the system via Item Receipts, then the cost that will be added to the Inventory Asset Account will be the rate that is set on the line of the Item Receipt. By default, this rate is copied from the Purchase Order, but it can be manually changed in the Item Receipt. When…
-
Hi @Julien Mi Electronics, Here is a discussion I previously posted about using Summary Criteria in Saved Searches: Hope this helps. ? -Ivy
-
Hi @kfluk, In a Formula (Text) field, use this formula: TO_CHAR('<a href=https://' || 'system.netsuite.com/app/common/item/item.nl?id=' ||{internalid}|| '&e=T>Edit</a>')||' | '||TO_CHAR('<a href=https://' || 'system.netsuite.com/app/common/item/item.nl?id=' ||{internalid}|| '>View</a>') The Summary Type should be Maxiimum.…
-
Hi Oliver, Sorry, still quite not getting how you want it to be shown in the results of your search. Can you provide an example? You can use excel or something similar to illustrate your desired results.
-
Hi @User_Z9B3J, As mentioned in another thread, this is currently a system limitation from FedEx itself. Their max commodities declared using FedEx WebServices is 20. We currently have this documented as Enhancement # 191767: Item Fulfillment > to be able to process orders using FedEx International with Shipping Label…
-
Hi @User_Z9B3J, This is currently logged as Enhancement # 191767: Item Fulfillment > to be able to process orders using FedEx International with Shipping Label Integration even if the order has more than 20 line items. You can vote for this in the SuiteIdeas page. At this time, the only documented workaround is to process…
-
Hi Oliver, Happy Friday to you as well! Just wanted to clarify -- do you want to add the results for all the 6 members? Also, I noticed that on one statement, it is divided by 30, while the other is by 20 only. Is this correct?
-
Hi Oliver, I tried it on my end, and the formula you provided works. Can you elaborate on what you meant by "chain these statements together"? You can also provide some screenshots of the exact formula and the error that you encounter.
-
Hi @kfluk, Try this in a Formula (Numeric) field: CASE WHEN {inventorylocation} IN ('Warehouse','Location # 1') THEN {locationquantityonhand} ELSE 0 END Note that the Summary Type should be set to SUM. As documented in SuiteAnswers 66963: When the Make Inventory Available = F, it will prevent the users from adding/using…
-
Hi @Dallas H, Have you tried the Inventory Profitability report? The Inventory Profitability report shows cost, revenue, and profitability information about your inventory. You can use this report to view and analyze profitability of your items. To see an inventory profitability report, go to Reports > Inventory/Items >…
-
You can try this: COUNT(CASE WHEN {salesrep} = 'XXXXX' AND {mainline} = '*' THEN {number} END)/30 This will count the number of transactions for the sales rep you specified.
-
It is stated in SuiteAnswers 9291: (Multiple Shipping Routes feature) If you disable this feature, all transactions display only one shipping address and shipping method. Since the Enable Line Item Shipping preference in transactions is only available if the Multiple Shipping Routes feature is enabled, then the effect is…