Hi @Casey_Long_, What do you mean by walking you through the process of creating the formulas? Have you replicated the saved search I provided? Did you have trouble adding the Formula fields? Or are you asking how did I come up with the formula or how to find the field IDs?

Thanks for the update, @Martha Hakes! Glad I was able to help. ?

Hi @Casey_Long_, I also tried to do this by customizing the Sales Orders Pending Fulfillment Report but I was unable to achieve the desired results. However, I have tested this in my account and here are the steps I did to create a Transaction Saved Search with the information that you need. 1. Go to Lists > Search > Saved…

Hi @Johnny Cash, Can you share the Criteria and Results tabs of your search? Have you tried using the Manufacturing Operation Task joining fields?

Hi @Martha Hakes, Were you able to check out this one? Let us know if you need further assistance with this. Hope you have a great day! -Ivy

Hi @srussell, Have you been able to test the workaround I provided previously? Did it work for you? If it did, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below my previous comment. This will also help other community members who might have the same concern find the answer easier.…

Hi @Tybrneryan, Glad to have you with us today and thank you for posting your concern here in the community! ? Allow us to check this one first, and we'll get back to you with our findings. Also tagging our guru @Joy Noreen Magoling-Oracle who will be able to help you out on this one. To our other members, feel free to…

Hi @srussell, Upon checking, the report requested is currently a system limitation. This has been requested in Enhancement # 87527: Reports > New Report > Create New Report > Quantity On Hand > Adding the Serial Number column shows you All Serial Numbers you have had On Hand and not just the Serial Numbers which are…

Hi @Biomerics_Admin, Currently, Back Ordered field on Transaction Saved Search is currently not available. This is logged in Enhancement# 158211: Transaction Search > Please add the "Back Ordered" field as an available filter and column of a Transaction search. You can vote for this in the Suiteideas page. As a workaround…

Hi @Martha Hakes, Note that we have removed the screenshot you initially uploaded. Moving forward, please make sure that screenshots do not contain sensitive information such as your account number, Regarding your concern, can you check the Sales Order form that they are using? Verify if the Enable Line Item Shipping is…

[UPDATE] Badges are already awarded to members with Support Type in their profiles as of today. Want to add this badge to your collection? Update your NetSuite Support Type on your profile page at https://community.oracle.com/netsuite/profile/edit.

Hi @Biomerics_Admin, Did any of my previous comments help on your concern? If it did, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped. This will also help other community members who might have the same concern find the answer easier. Hope you have a…

Hi @KNason76, Upon looking into this, I found out that the ability to pull up the needed components' information when using Advanced BOM feature is not yet available in the system. The Item Saved Search's Member Items fields on the Item Saved Search only work for the BOM Legacy Records. Here are some enhancements I found…

Hello @User_U1JVS, Thank you for posting another question here in our community! Looping in @Mikko De La Fuente-Oracle and @Erick Dela Rosa-Oracle who have the expertise regarding this one. To other members, feel free to comment your insights and suggestions on this as well.

Hi @User_U1JVS, Glad to have you back with us today and thank you for posting your concern here in our community! ? Tagging our gurus who will be able to help you out on this one: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas that can help? In the meantime, we'd like to request you to update your profile…

Hi @Biomerics_Admin, Usually, you can refer to the Records Browser or the Schema Browser or even the Records Catalog for a list of fields in records. However, for this one, it is thru testing in my account that I got this information. It seems that when you edit the Base Price of an item, the system notes log this change…

Hi @Biomerics_Admin, In an Item Saved Search, this is the Base Price. If you use the System Notes joining fields, this is the Rate field. Hope this helps. ? -Ivy ========================= 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…

Hi @ChrisH, I checked this on my standard test account and these are the options for USPS Real-Time Rate for the Shipping Items: Upon further checking, I found that First Class International is not currently available in Netsuite because there is no tracking #, i.e. no fraud prevention capability. If/when Endicia makes it…

Hi @User_H82PL, Were you able to check the SuiteAnswers articles I provided? If it was helpful to your concern, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below my previous comment. This will also help other community members who might have the same concern find the answer…

Hi @FoxFoxFox, Were you able to check the articles I provided in my previous comment? If it helped in your concern, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same question find the answer easier.…

Hi Dallas, I would just like to confirm -- in your CSV file, it only contains the Internal ID of the Transfer Order, is this correct? Can you please verify the status of these Transfer Orders? Kindly note the following when trying to close Transfer Order lines: A line on a transfer order cannot be closed if any quantity is…

Hi @Martha Hakes, Did my previous comment help in your concern? If it did, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the same concern find the answer easier. Hope you have a…

Hi @User_H82PL, You can use Quantity Pricing for your requirement. Please check the following SuiteAnswers articles for more information about this feature: 28152 - Using Quantity Pricing 28122 - Quantity Pricing Schedules Hope this information helps. -Ivy ========================= If you find this reply to your question…

Glad that it now works for you! ? Regarding your other question, it depends on if you want the cost on past transactions to be changed or not. If you backdate the worksheet, then the system will recalculate all posting transactions using the items you adjusted based on the cost that you entered. Creating the worksheet…

Hi @User_66058, Can you try using the Standard Inventory Worksheet form instead of the custom form? Per checking on my account, the Standard Inventory Worksheet form shows the Location field, and only when this field is populated does the item list show up in the Inventory Worksheet. Example: The Location field is blank…

Hi there @Biomerics_Admin, Thank you for creating another thread here in our community! @Jack Daryl Espiel-Oracle / @Kristoffer Viray-Oracle, any ideas on how to source this field? To our other members, feel free to comment your insights and suggestions on this as well.

Hi there @Karanjot Singh, Glad to have you with us today and thank you for posting your concern here in our community! Tagging here our experts in workflows -- @Jack Daryl Espiel-Oracle / @Kristoffer Viray-Oracle, any ideas how this can be achieved? To our other members, feel free to comment your insights and suggestions…

Hi again @Aniket-Silversky, I managed to find a test account with the same fields as yours and I can confirm that the field ID is the same {customer.pricelevel} so the formula I initially provided should be correct. Here's some more screenshots for your reference. Let me know if you got it working, or if you need further…

Hi @Aniket-Silversky, That's correct. Just click on the Customer Fields... then it should show a popup window with a dropdown list wherein you can select "Price Level". It will look like Customer : Price Level on your account once you have selected it. Please also use this field in the Formula (Numeric). I'm not sure if…

Hi @Aniket-Silversky, It should be under the Customer joining fields. The goal of the search I provided you is to compare the Price Level set on the Customer record and the Price Level that is selected in the item line of the Sales Order created. If they are different, then an email alert should be sent by the search. Let…