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
-
I agree with @Emil T.. We're still unable to picture out exactly what your requirement is on this one. We'd appreciate it if you can provide sample scenario of your use case so we can better understand your concern. By the way, RM - Raw Materials FG - Finished Goods WIP - Work In Process
-
Thanks for your insights on this one @Emil T.! ? ---- @KNason76, let us know if any of the provided solutions work for you or if you have further concerns on this one.
-
Hi @OliverK, As documented in SuiteAnswers 10101: You cannot combine aggregate and non-aggregate SQL functions in the same formula definition. For example, if you create a formula using an aggregate function, then all the functions in the definition must either be aggregate functions or listed in a GROUP_BY clause. CASE is…
-
Unfortunately, I don't think we can have this as a number format since we have some text characters (currency sign and parenthesis) in the result of the formula.
-
Hi @Razan Saleh, Were you able to check what I suggested in my previous comment? Or did you proceed in filing a Support Case on this one?
-
You might need to adjust the currencies in the formula to reflect the Currencies in your account. You can check this by navigating to Lists > Accounting > Currencies.
-
It should be Formula (Text). Sorry, I forgot to include what type of formula field to use.
-
Hi @Benjamin Paul - USA, I don't quite understand your requirement of "calling out" an item, so maybe you can further explain it? You might also want to take a look at Phantom Assemblies (SuiteAnswers 51546) if this is close to what you were looking for.
-
Hi @User_YQ8ZX, I see that you have also posted about this before in this another thread: In the other thread, you were also advised to submit a case to support so that they may further check what could be causing the discrepancy as this may be a potential issue on your account. It's the best course of action to take for…
-
Keith, In your other comment, you mentioned "feature" and disabling it. I discussed about the Multiple Shipping Routes feature since the Enable Item Line Shipping checkbox in transactions is only available if this feature is enabled. Also stated in SuiteAnswers 9291: If you disable this feature, all transactions display…
-
The Multiple Shipping Routes feature allows you to ship to several different addresses and use different shipping methods on the same transaction, so in disabling this feature, you will no longer be allowed to do so. Aside from this, there is no other documented effect of disabling this feature in general, however, it is…
-
Hi @Keith Boatner, Per checking, this is the current behavior of the system and we do have an existing enhancement request related to this one: Enhancement # 627405 : When a Field is Edited on Sales Order it Unset / Resets the Address or Other Fields per Line System Notes Based on my tests, here's the difference when the…
-
Hi @KNason76, WIP is enabled in my environment as well, since I have Work Order Issue transaction record as well. Anyway, I did some testing on my end for a Saved Search which will get the WO Qty and the Qty Issued to date. Btw, the Qty Issued to date is also shown as "Used In Build" column on the WO. Here's the…
-
Hi @Vernita, Can you try this formula: CASE WHEN {type} IN ('Credit Memo','Payment') AND {fxamountremaining}*-1 < 0 THEN '(' || (CASE WHEN {currency} = 'USD' THEN '$' WHEN {currency} = 'British pound' THEN '£' WHEN {currency} = 'Canadian Dollar' THEN '$' WHEN {currency} = 'Euro' THEN '€' WHEN {currency} = 'Ruble' THEN '₽'…
-
@KNason76, I tried the saved search on my test account, and was able to pull the Qty from the WO lines. I used SAID 68488 like you mentioned. Here are some screenshots for reference: Note: I did not add the Summary Criteria, since there is no difference of Qty Issued and Qty Consumed in my test account. Here's the result…
-
You can try removing that criteria, and check if it will provide the needed results.
-
Hi @KNason76, You can use the Applied To Transaction : Quantity field, then set the Summary Type to Maximum to get the Quantity from the WO component item lines. Try this on your end, then let us know if this works for you. -Ivy ========================= If you find this reply to your question as helpful, others with the…
-
Hello @Razan Saleh, You can check what is set on the FedEx Dropoff Type field in your FedEx Registration in NetSuite: Setup > Accounting > Shipping > Carrier Registration tab > click Account Number for your FedEx account I Accept = T FedEx Dropoff Type = Regular Pickup Click Submit You can try the other Dropoff Types to…
-
That is correct, since the item lines will be greyed out already, and there is no option to add new item lines when the status is set to "Built".
-
Hi @Benjamin Paul - USA, I tested this one on my end and noted that when the status of the Work Order is already 'Built', replacing the item or adding new item line is no longer allowed. This is currently the standard behavior of the system. To be able to add item lines, you need to set the Work Order status to 'In…
-
Hello @User_IJB6M, Have you tried the suggestion in my previous comment? Let us know if you need further assistance with this one.
-
WOW! 3 Months! This is amazing @Tiru Chembeti! ?
-
Hello @User_EVVPG, To see the linked inbound shipment record from the purchase order record, under Items subtab, you may see a Quantity on Shipment transaction column in the item line. If you'll click on the quantity link you'll get a pop up window with details of the Inbound Shipment. When you click the Shipment Number,…
-
Hello @User_IJB6M, If enabling WIP is not feasible for you, then you might consider creating Other Charge for Purchase or Service for Purchase items that would represent the labor/overhead cost, then add these items as components of the assembly. That way, you'll be able to record the costs that you need. Hope this helps.…
-
Hi @SanjeevV, Were you able to check my previous comment? Let us know if you need further assistance on this one.
-
Hi @Razan Saleh, Were you able to check my previous comment? Let us know if it was able to help in your concern, or if you need further assistance with this.en different shipping cost between NS and Fedex Comentario por Ivy Lopez-Oracle Jun 28, 2022 11:49PM
-
Hello @Razan Saleh, It seems that this is a duplicate of the other thread that you posted: Let's continue our discussion there.
-
Hi there @Razan Saleh, Thank you for posting your question here in our community! Can you check what is set in the FedEx Rates Type under Setup > Accounting > Shipping > Preferences? In this field, you can select the type of rates you want to show and charge your customers. This preference applies to domestic rates only.…
-
Hi there @SanjeevV, Thank you for posting your concern here in our community! Can you clarify please what you mean by "current outstanding demand based on what is not fulfilled on our sales order for this location"? I think this one is already represented by the Location Back Ordered, since it is outstanding and not yet…
-
Glad I was able to help! ?