Ivy Lopez-Oracle

Hi @Aby James, Thanks for providing the steps! We appreciate you sharing your knowledge and expertise here in the community 😊 ---- Hi @Edwards_05, Please try the solution provided by @Aby James and let us know if it worked for you. I also remember @John Griffin providing similar steps in other threads. You can also check…

in How to remove Bill of Material from Assembly (Advanced BOM)? Comment by Ivy Lopez-Oracle Mar 23, 2023 10:50PM

Hi @Kedalene, If you just want to adjust the Value of the items, without affecting the Quantity, then you have these options: Use an Inventory Adjustment Worksheet - you can keep the same Quantity, and just adjust the Value, however, serialized/lot numbered items are not supported Use 2 Inventory Adjustments - 1st…

in How to Revalue Inventory without Standard Costing? Comment by Ivy Lopez-Oracle Mar 23, 2023 10:44PM

Glad it works! 😊

in How to remove duplicates when using NS_CONCAT on Events Saved Search? Comment by Ivy Lopez-Oracle Mar 23, 2023 3:38PM

Hi @PaulFleetwood, Thanks for reaching out to us in the NetSuite Support Community. Interesting question you have here. I tried it on my test account, but was unable to reproduce the behavior you mentioned. Can you send some screenshots of the Criteria tab, and also screenshots of the Event which is appearing multiple…

in How to remove duplicates when using NS_CONCAT on Events Saved Search? Comment by Ivy Lopez-Oracle Mar 23, 2023 3:29PM

Hi @Kedalene, If you are referring to the Inventory Cost Revaluation record (as shown in below screenshot), then yes, Standard Costing feature is a requirement for this. However, if you just want to revalue (change the value or quantity) your inventory, then perhaps you can use Inventory Adjustment or Inventory Adjustment…

in How to Revalue Inventory without Standard Costing? Comment by Ivy Lopez-Oracle Mar 22, 2023 7:19PM

You're always welcome, @Dallas H! 😊

in How to SEND EMAILS ACCORDING TO SCHEDULE on Last day of the month? Comment by Ivy Lopez-Oracle Mar 22, 2023 6:11PM

Hi @Joy Noreen Magoling-Oracle, What's something that you wish you knew sooner/earlier? Can be about NetSuite or about life in general. 😊

in AskAGuruLive with Joy about Supply Chain Management (March 22, 2023) Comment by Ivy Lopez-Oracle Mar 22, 2023 5:16PM

Hi @Christopher Williams, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Joahnna Given Uy-Oracle, @Jack Daryl Espiel-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get…

in How to show specific subsidiary Address on Invoice Comment by Ivy Lopez-Oracle Mar 22, 2023 3:30PM

Hey there @Edwards_05, Let me tag our experts in customization to see what they have to say. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, appreciate your insights on this one! 😊

in Is it possible to assign Customer Part Numbers to Kit Items? Comment by Ivy Lopez-Oracle Mar 21, 2023 6:34PM

Hi @Sue Campau, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and check if this is possible. Please allow them some time to investigate and get back to you. In the meantime, if any other members…

in Can we attach a file to a project record via an email? Comment by Ivy Lopez-Oracle Mar 21, 2023 3:20PM

Hi @Sean W, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our guru @Michelle Jabanes-Oracle to take a look at your question and provide you with insights. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts, insights, or…

in Why is Sandbox missing from my roles? Comment by Ivy Lopez-Oracle Mar 21, 2023 3:17PM

Hi @Alon2028-Oracle, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Elychelle Gulen-Oracle, @Dominica Sevilla-Oracle & @Katerina Winklerova-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back…

in How to show overpayment in an invoice? Comment by Ivy Lopez-Oracle Mar 21, 2023 3:12PM

Hi @Dallas H, Here's the revised search for your requirement on the email: For the search results, we can still use the same formula for the "Prev. Month" data. To get the data for the "Month before last month" or February, if you will run the search in April, then we just use -2 instead of -1 in the formula: Month before…

in How to SEND EMAILS ACCORDING TO SCHEDULE on Last day of the month? Comment by Ivy Lopez-Oracle Mar 21, 2023 2:42PM

For the Quantity On Hand, you can use the joining Item Fields. (Item: On Hand)

in How to create a Saved Search that shows assemblies that are below build point? Comment by Ivy Lopez-Oracle Mar 21, 2023 2:18PM

Hi @Mathias_Netsuite, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle, @Elychelle Gulen-Oracle & @Katerina Winklerova-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back…

in How to create a report that will display Bills that contain Billable Items? Comment by Ivy Lopez-Oracle Mar 20, 2023 3:30PM

Hi @Sharon Hirsc, Thanks for reaching out to us in the NetSuite Support Community. We have notified our gurus about your question and they will be checking in soon. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in Purchase in Each, Sell in Case (unit of measure) Comment by Ivy Lopez-Oracle Mar 20, 2023 3:19PM

Hi Sean, I did try these Criteria on my end, and got only the quantity of assembly items on Work Orders with Released status. If this does not work for you, then it would really help if you can share some screenshots here so we are able to further visualize the behavior happening on your end. You can also share examples of…

in How to create a Saved Search that shows assemblies that are below build point? Comment by Ivy Lopez-Oracle Mar 17, 2023 10:15PM

Hi @Nickey, Per checking, it is currently not possible to remove the link between Special Order transactions. There is a related enhancement # 390014 which you can vote for in the SuiteIdeas page. At this time, there is no documented alternate solution. However, I did some tests on this and the easiest workaround I can…

in How do I break the link between a PO and WO Comment by Ivy Lopez-Oracle Mar 17, 2023 10:01PM

Hi Dallas, I 🤣d at the 🤯 emoji. 😂 Anyway, for your first concern about sending an email at the end of each month, It seems this is not possible since an error is received when we try to schedule a monthly event after the 28th: The workaround for this is to set a schedule to send an email at the 1st of every month instead,…

in How to SEND EMAILS ACCORDING TO SCHEDULE on Last day of the month? Comment by Ivy Lopez-Oracle Mar 17, 2023 7:10PM

Hey there @Dallas H, Appreciate you posting a new question and linking the related one. 😊 Can you specify what search type you opted to use? Is it the Item Search or the Transaction Search? Let me know so I can proceed with testing. Thanks!

in How to SEND EMAILS ACCORDING TO SCHEDULE on Last day of the month? Comment by Ivy Lopez-Oracle Mar 17, 2023 4:07PM

Hi @Ken Zhang-Oracle, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Katerina Winklerova-Oracle and @Micah Timbol-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back to you. In the meantime,…

in Why is the Bank balance empty in the Match Bank Data page? Comment by Ivy Lopez-Oracle Mar 17, 2023 3:17PM

Hi @Mathias_Netsuite, Currently, we can only assign 1 GL account per item. Per checking my resources, I found there are existing enhancements requesting for this functionality: Enhancement # 178114: OneWorld>Accounting>Accounting Preferences>Items/Transactions: Ability to set default accounts per subsidiary. Enhancement #…

in Is it possible to post on different GL account per Item per Subsidiary? Comment by Ivy Lopez-Oracle Mar 17, 2023 2:23PM

Hi @Dallas H, Just wanted to check in if you were able to see the possible solution provided in my previous comments. If it was helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock…

in How to create a Saved Search to show the First Time a new Item has been Received? Comment by Ivy Lopez-Oracle Mar 16, 2023 10:19PM

Hello @Sheene Lim-Oracle, Let us know if further assistance is needed with this. If none, we would greatly appreciate it if you can click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock the Answer Accepter badge.

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 16, 2023 10:18PM

Hi @Owen Ramirez Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle & @Clarisa De Torres-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back to you. In the meantime, if any…

in Is there a way to identify B2C and B2B customers for OSS Scheme in Suitetax? Comment by Ivy Lopez-Oracle Mar 16, 2023 3:39PM

Hi @Nickoletta Gounaris, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Katerina Winklerova-Oracle & @Micah Timbol-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back to you. In the meantime,…

in How to map custom field when importing new Journal Entries through CSV? Comment by Ivy Lopez-Oracle Mar 16, 2023 3:38PM

Hi @Katelyn M Martin, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle, @Elychelle Gulen-Oracle & @Katerina Winklerova-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back…

in How to implement Inline Purchase Order Approval Functionality in a Saved Search? Comment by Ivy Lopez-Oracle Mar 16, 2023 2:56PM

Hi Sean, Let us know if you need further assistance with this.

in How to create a Saved Search that shows assemblies that are below build point? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:19PM

Hi @Varonis inc., I hope you're doing well! I just wanted to check in and see if you had a chance to look at the possible solution I provided in my previous comment. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?" It's a quick and easy way to let us know that the solution worked…

in How to Edit a transaction line description? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:18PM

Hi @User_C6XDE, I hope you're doing well! I just wanted to check in and see if you had a chance to look at my previous comment. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?" It's a quick and easy way to let us know that the solution worked for you. Plus, it helps others with the…

in What Permissions are needed for a Custom Role to Access WMS Mobile App (bundle# 445891)? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:17PM

Ivy Lopez-Oracle NSC Guru

Comments