Ivy Lopez-Oracle NSC Guru

Hi @liams, Just wondering if you were able to test the suggestion in my previous comment. Was it able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community…

Hi @User_O4547, Thank you for posting your question here and welcome back to NetSuite Support Community! ? Our gurus/members will look into your concern and reply to this thread for any updates. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Thanks for sharing your findings, @KaylaM! I'm sure other members who encounter the same situation will find this very useful! ?

You're very much welcome, Meherin! ? Hope you have a great day! -Ivy

Hi @Dallas H, Please try adding Main Line is false in the criteria of the search and check if the Sales Orders with Invoices (Paid in Full) still show in the results. I checked it on my end, and it seems that since the Main Line of the transaction has -None- as its Applying Transaction Type, the search still shows it in…

Thanks for the update! Glad that it worked for you! ?

Hi @Martha Hakes, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you…

Hi @Meherin, If there is a purchase order linked to the item line, then it is standard behavior that only the quantity in the linked purchase order will be committed, even if there is existing quantity available for the item. This behavior is documented in SuiteAnswers 28531: Special Orders can only receive commitment from…

Hi Tom, Upon checking my resources regarding your concern, I noted that this is still not available in the system. Here are some enhancements related to this: Enhancement # 76642 : Reports > Inventory/Items > Inventory Profitability > If Item Type filter = includes Kit > Please derive the cost from the component instead of…

Hi there @rburns515, Glad to have you back with us and thank you for posting your concern here in our community! Tagging my colleagues @Dominica Sevilla-Oracle and @Shamaine Chan-Oracle who will help you out on this one. Anyone else with ideas or suggestions, we encourage you to share them by commenting in this thread! ?…

Hi @liams, Based from the screenshots you sent, you are using an Item Saved Search. You can try adding a Formula (Numeric) field to your criteria to remove the duplicates: Formula: CASE WHEN {inventorynumber.location} = {serialnumberlocation} THEN 1 ELSE 0 END Also, if the main purpose of your saved search is to get the…

Hi @Hormese Paul, Per checking, emailing Work Orders is not available in native NetSuite. Because of this, the Message sublist is not available as well in this transaction. A related enhancement has been filed for the ability to email Work Orders. You can vote for Enhancement # 245173 or submit a new one in the SuiteIdeas…

Hi @Martha Hakes, If an Item/s are associated to a Distribution Network, the subsidiary of a Distribution Network under Lists > Supply Chain cannot be changed. All items associated should be edited to remove the Distribution Network before you can edit the subsidiary. To edit the Distribution Network in the Item Record,…

Hi @esabis, Thank you for posting again here in the community! Our gurus/members will look into your concern and get back with more information. @Michelle Jabanes-Oracle, any ideas about this? To all members, feel free to share your thoughts/insights.

Hi @Jay Schwausch, Thank you for creating another thread in our community! ? Let's see if any of our other members have experience with this. To our members who have insights about integrating BarTender with NetSuite, you are welcome to share your thoughts here!

Hi Tom, The formula I provided is for saved searches, which you initially mentioned in the subject of this thread and in your initial message. The IDs used in saved searches and analytics dataset sometimes varies. Anyway, thanks for sharing the formula you used for analytics dataset. ?

Thanks for updating us, Liz! Glad you were able to figure it out. ?

Hi @farrago, Kindly try formula: CASE WHEN {applyinglinktype} = 'Drop Shipment' THEN 'Drop Ship' ELSE 'Our Warehouse' END Let us know if it works for you. ? -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…

Hello @Liz Madrid, Just a follow up on this thread. Can you please explain what you mean by "input an inventory item under an existing inventory item"? Are you referring to making an existing item a "Subitem" of an existing inventory item? You can also provide some examples or screenshots, just make sure to hide any…

Thanks for sharing your thoughts in this @JohnCirocco! ? Hi @farrago, I agree with John. Using the Applying Link Type = Drop Shipment can give you the item lines with drop ship POs associated. Criteria tab: Results tab: The Purchase Order field and the Applying Transaction field in the results tab both shows the Purchase…

You're welcome, Nikka! Glad I was able to help you out. ?

Hi @Nikka Paula Castillo-Oracle, There isn't any way to do an import with only the new subsidiary in the csv file and be able to have both new and old subsidiaries selected in the item record. Whatever data you have in the csv file will replace the current value of the field in the item record. This means that if you have…

Hi @User_NZXO4, Glad to have you with us today and thank you for posting your concern here in the community! @Dominica Sevilla-Oracle and @Shamaine Chan-Oracle will be helping you out on this one. Kindly allow them some time to check on this and get back to you with updates. Anyone else who has insights regarding this,…

Hi @Kellyann, Glad you were able to get it! ? We'd appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you have a great day! -Ivy

Hi there @Liz Madrid, Can you please explain what you mean by "input an inventory item under an existing inventory item"? Are you referring to making an existing item a "Subitem" of an existing inventory item? You can also provide some examples or screenshots, just make sure to hide any confidential information.

Hi @Vernita, Have you had the chance to check SuiteAnswers 28531 or SuiteAnswers 67594? Also, we have a video explaining this behavior. You may want to watch it: Hope this helps! ? ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By…

Hi @Nikka Paula Castillo-Oracle, It is standard in the system that a user will not be able to remove the subsidiary from the item record if it already has existing transactions with that subsidiary. The error message will also be encountered even if you try to edit the item record in the UI. Also, since the Subsidiary…

If you are using a custom form, make sure that the Manufacturer fields are marked to Show in the Field Groups tab and the Fields tab of the Custom Entry Form: Also, kindly check if the International Shipping preference is enabled in your account: 1. Navigate to Setup > Accounting > Shipping 2. Go to Preferences tab…

Thanks for providing that information! Tagging my colleagues @Micah Timbol-Oracle and @Emilia Ironov-Oracle who have the expertise on this topic. If anyone else has any insights regarding this, feel free to comment on this thread!

Hi @KNason76, Can you confirm if you are referring to Bank Deposits or Customer Deposits? Kindly provide the navigational path or the steps to go to the make deposits screen so I can coordinate this to our guru who will be able to assist you better with this. ?