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 @Dallas H, Was my previous comment helpful in your concern? If it was. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. Doing so will help other community members who might have the same concern find the answer easier and you will also get closer to earning…
-
Hi @Tybrneryan, Let us know if adding the formula helped in your search, or if you need further assistance on this one.
-
Hi @ChrisH, Here is the Item Saved Search that I came up with to cater to your requirement: Criteria tab: Note: You can add other filters as necessary. Results tab: Formula used: Price Level 1: CASE WHEN {pricing.pricelevel} = 'Price Level 1' THEN {pricing.unitprice} END Average Rate (Price Level 1): CASE WHEN…
-
Hi @NitinEOH, I tested this on my account, and the Average Cost was populated when I entered the WO Completion. Can you check if there is an Average Cost for the components? Also, please verify that the costing calculation is completed. See SuiteAnswers 84614 for information on Ways to Check if there Is Costing Still…
-
Hi Dallas, If this is an Item Saved Search and you want to get the Quantity per location, then you can use the field {inventorylocation} instead of {transaction.location}. Since you use {transaction.location}, then your search will check if that item has a transaction with the specified location, and it will get the…
-
That's weird. When I tried your formula on my account, it seems to work fine. Anyway, try adding this in a Formula (Numeric) field: CASE WHEN {rate} < {customer.itempricingunitprice} THEN 1 ELSE 0 END
-
Can you try adding the Customer/Project: Pricing Item field to the Results tab of your search, then send the screenshot again?
-
Hi @Tybrneryan, Try to add a Formula (Numeric) field in your Criteria, and use this formula: CASE WHEN {item} = {customer.pricingitem} THEN 1 ELSE 0 END Hope this helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this comment. This will also help other…
-
Hi @Dallas H, For your 1st question, the error is caused by a missing closing parenthesis in your formula. Refer to the image below to see where it should be placed: You can also try this formula and use Summary Type = Sum: CASE WHEN {transaction.location} IN ('Edmonton Warehouse','Calgary Warehouse') THEN…
-
Hi @User_GE47I, I tested this on my end, and confirmed that the Sales Description is the one being pulled for Sales Orders and BOMs: Item Record Sample Sales Order Sample BOM Revision However, please note that in order for this to populate in the Description field of the SO or BOM, the item should have it already populated…
-
Hi @Ian_H, Thank you for posting your concern here in our community! ? Allow our gurus/members to check on this on and we'll keep you posted on updates. Also tagging my colleagues who can help you out on this one: @Patrick Fresnosa-Oracle / @Micah Timbol-Oracle, any ideas? To our other members, feel free to comment your…
-
Hi @User_C36Z7, There is a list in SuiteAnswers 27995 that discusses the transaction types sourced for projection calculations when Sales Forecast method is used. The transaction types are: invoice estimate opportunity sales order item fulfillment cash sale Since Transfer Order is not included, then it is not considered as…
-
Hi there, Were you able to check on this one? If my previous comment was able to help in your concern. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that was helpful. Doing so will help other community members who might have the same concern find the answer…
-
Hi @3ric, Were you able to check on this one? If it was able to help in your concern. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that were helpful. Doing so will help other community members who might have the same concern find the answer easier and you…
-
Hi @PaulFleetwood, There is a Costing Method that is available for Serialized Items only. This is called Specific costing. An example of this is documented in SuiteAnswers 70609. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this…
-
Thanks for the update, Liz! I'm glad that you were able to do the imports successfully. ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…
-
Yes Liz, it's correct.
-
Hi Liz, Then you can use the either the Base Price or the Purchase Price and map it to the Price field.
-
Hi Liz, I'm glad that you got that part done now! ? For the List Price, that was the just the column header in my CSV file when I did the import on my end. Do you have the Price per item for your SOCORRO CONTRACT Price Level? Is it the same as the Base Price/Purchase Price?
-
Glad that you now have the report/search that you need. ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same concern find the answer easier…
-
Is that the complete list? If the job status said that 190 of 190 records imported successfully, then the items in your CSV file should have been added to the customer record. You can refresh the customer record again, or try to clear cache, log out and log back in to check if the customer record has updated. To check how…
-
Oh, Assembly Build and Work Order Issue are Types of Transactions, not items. Please refer to the screenshot I provided in my previous comment. I added them under the Type filter, not Item: Type.
-
Hi Liz, You have the correct mapping, but please make sure that Internal ID is selected for the Item internal ID field. Click the pencil icon, then select Internal Id in the dropdown.
-
Did you perhaps rename these records? I checked on my account, and these are showing under Type:
-
Hi @Liz Madrid, Since you are importing the Customer Record, pls refer to the steps I provided in my previous comment -- under the section "B. Import Items and Price Level in Customer Record" Kindly double check your mapping.
-
Hi @KR Mike, If your account just has "Assembly", then it means that Advanced BOM is enabled on your end. As long as the items are in Item Fulfillments, then it will be counted in the search. If you want to also count how many times the items are included in Assembly Build or Work Order Issue transactions, then you can add…
-
Good morning, Liz! There is no attachments in your comment, only a screenshot. You can send it to me via Private Message if you want.
-
Hi Dallas, Glad that you figured out the culprit! I ran a few more tests on this one and I think the reason for this behavior is because the Wave # (Applying Transaction) is found in the Shipping Line, while the Expected Receipt Date is on the Item Line and the Receiving Line, but not the Shipping Line. See example below:…
-
Hi Liz, Once you get export results of the search to a file format you can open in MS Excel, then you can use the VLOOKUP or XLOOKUP function in MS Excel to get the Internal ID and/or Item Name of your 200 items. You can use the Part Number (from your vendor's spreadsheet) and the Display Name (from the Saved Search…
-
Thanks for that clarification. Can you create this Item Saved Search please, then export the results? Criteria tab: Preferred Vendor = EPD Results tab: Internal ID Name Display Name If you can send me the exported file from the Saved Search, and your spreadsheet with the list of the 200 items, then I can help you create…