Ivy Lopez-Oracle

Hi @Chad C, Regarding your question on "why Multiple Units of Measure is needed for Ship Central", I have coordinated this internally but unfortunately, all I got was that as of 23.1 release, it is needed and they will evaluate more in depth for the next release. Anyway, I also wanted to check in if you were able to…

in Why is Multiple Units of Measure feature required in Ship Central? Comment by Ivy Lopez-Oracle May 15, 2023 5:41PM

Hi @Tom Dalton, Were you able to check the comments above? Let us know if any of them help in your concern, or if you need further assistance on this one.

in How to create a Saved Search that will show Cost of Goods Sold per Sales Order? Comment by Ivy Lopez-Oracle May 15, 2023 5:28PM

Hi @scottr_25506, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to Global Search fields of Inbound Shipment record? Comment by Ivy Lopez-Oracle May 15, 2023 3:13PM

Hi @Brian D-Oracle, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to Restrict Certain Vendors from Certain Roles? Comment by Ivy Lopez-Oracle May 15, 2023 2:49PM

Thanks for your insights @Brian Stisser! --- Hi @Tom Dalton, Aside from the points made by Brian, note that the COGS for Drop Ship orders are recognized in the PO's Bill (2 levels away from the SO record, so we can't pull it in a search). You can try to use this formula if this will work for you: CASE WHEN…

in How to create a Saved Search that will show Cost of Goods Sold per Sales Order? Comment by Ivy Lopez-Oracle May 12, 2023 8:22PM

Hi @Chad C, I have checked available resources and documentation, but was unable to find any relation between enabling the Multiple Units of Measure and not being able to create Inventory Adjustments. Try to perform initial troubleshooting like: logging out, then logging back in clearing browser's cache use incognito mode…

in Why is Multiple Units of Measure feature required in Ship Central? Comment by Ivy Lopez-Oracle May 12, 2023 2:52PM

No worries, @Ivan Babiichuk. Just let us know as soon as you can. 😊

in How change return ship via and integrated return label fields in IF Comment by Ivy Lopez-Oracle May 12, 2023 2:11PM

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

in How to execute workflow for department on Employee Center Comment by Ivy Lopez-Oracle May 12, 2023 1:48PM

Hi @User_M4JOC, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to resolve error Invalid subsidiary reference key X for entity Y" in credit card upload Comment by Ivy Lopez-Oracle May 12, 2023 1:29PM

Hi @Ivan Babiichuk, Were you able to test this? Let us know if you need further assistance.

in How change return ship via and integrated return label fields in IF Comment by Ivy Lopez-Oracle May 11, 2023 3:48PM

Hi @Theo_NS, Thanks for reaching out to us in the NetSuite Support Community. Please give some time for the gurus/members to check on this and update this thread for any findings. In the meantime, you might be interested to participate in our weekly quiz. You only have until 2 PM EST today to share your answer and…

in How to Add Public Holiday to Time by Employee Report? Comment by Ivy Lopez-Oracle May 11, 2023 1:28PM

Hi @User_ZCWF3, Have you checked my previous comment? Let us know if you need further help on this.

in How to include running total and current value in saved search? Comment by Ivy Lopez-Oracle May 10, 2023 5:50PM

Hi @User_ZCWF3, Can you clarify what you want to show in the search results? Is it the current quantity on hand of an item? If so, then you can try using these fields: Using these will pull the data from the item record's current quantity available or on hand. If this doesn't work for you, then we would appreciate if you…

in How to include running total and current value in saved search? Comment by Ivy Lopez-Oracle May 8, 2023 10:41PM

Hi @Tom Dalton, You can try these Saved Searches documented in SuiteAnswers and check if any of these will work for you: 79559 - Saved Search > Show per Line Item COGS amount from Item Fulfillment and per Line Item amount from Sales Order 72008 - Saved Search> Display Sales Order related COGS amount 43130 - Show COGS…

in How to create a Saved Search that will show Cost of Goods Sold per Sales Order? Comment by Ivy Lopez-Oracle May 8, 2023 10:21PM

Hello @kmd_14170, Have you tried what @Tiru Chembeti mentioned in his comments? Let us know if it worked for you or if you still need help on this. --- Thanks as always @Tiru Chembeti for sharing your knowledge in our community!

in How to zero out inventory in a location? Comment by Ivy Lopez-Oracle May 8, 2023 10:01PM

Hello @Ivan Babiichuk, I noticed in the sample screenshots you provided, the existing Item Fulfillment was already set to Packed status while the new Item Fulfillment you created was in Picked status. This behavior might have something to do with the Shipping Label Creation Stage preference under Setup > Accounting >…

in How change return ship via and integrated return label fields in IF Comment by Ivy Lopez-Oracle May 8, 2023 9:56PM

Hi @Kitin Basilla, Just wanted to check in if you were able to see the possible solution provided in my previous comment. 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 the…

in How to create a Saved Search for Assemblies with Back Orders and related Work Orders? Comment by Ivy Lopez-Oracle May 5, 2023 1:27PM

Since the result you want to show is a text value, you should go with Formula (Text) field.

in Is there a way to convert dates to show only month? Comment by Ivy Lopez-Oracle May 4, 2023 2:18PM

Hi @User_M4JOC, Thank you for posting your question in the NetSuite Support Community. Try this: TO_CHAR({insertdatefieldhere},'MONTH') You can check SuiteAnswers 50499 about more information on using TO_CHAR function.

in Is there a way to convert dates to show only month? Comment by Ivy Lopez-Oracle May 4, 2023 1:58PM

Hi @Clement K., Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to allocate Sales to Royalties, Marketing? Comment by Ivy Lopez-Oracle May 4, 2023 1:21PM

Hi @User_C6XDE, 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 her insights. Please allow some time to investigate and get back to you. In the meantime, if any other members have any thoughts, ideas, or…

in How to set Default Case Email to Current User? Comment by Ivy Lopez-Oracle May 3, 2023 2:12PM

Hi @Chad C, Per checking, the ability for the sales data to roll up to the parent is still logged as enhancements: Enhancement # 64021 : Allow the ability to customize the Sales by Customer Summary report to only show Parent Customers with all job/subcustomer sales figures rolled up into the Parent Customer Enhancement #…

in How to define 3rd party shipping by ship to address Comment by Ivy Lopez-Oracle May 2, 2023 9:33PM

Hi @Kitin Basilla, You can try this Transaction Saved Search: Criteria tab: Formula used: case when {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) > 0 then 1 else 0 end Results tab: Formula used: Assembly Item Back Ordered Qty: {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) Total Qty…

in How to create a Saved Search for Assemblies with Back Orders and related Work Orders? Comment by Ivy Lopez-Oracle May 2, 2023 9:20PM

Hi @kmd_14170, You're in the right track with using Inventory Adjustments or Inventory Adjustment Worksheet. The error you're getting is usually due to entering New Qty = 0 with New Value of greater than 0. In that case, before saving the Inventory Worksheet, please make sure/review each item with New Qty = 0 that the New…

in How to zero out inventory in a location? Comment by Ivy Lopez-Oracle May 2, 2023 8:28PM

Hi @Dallas H, I just wanted to touch base and see if you had a chance to check out the previous comments. If any of them were helpful, we'd really appreciate it if you could take a moment to click "Yes" on "Did this answer the question?" This helps others with the same question find the answer quickly, and you'll earn…

in Why is Assembly Item not showing Components in Item Receipt? Comment by Ivy Lopez-Oracle May 2, 2023 4:02PM

Hi there @Paul Salkeld, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to update the Entity ID of the Customer Record? Comment by Ivy Lopez-Oracle May 2, 2023 1:22PM

Hi @User_MEMX1, Welcome to the NetSuite Support Community! We're glad to have you with us today and thanks for posting your question here. 😊 Have you tried checking the Cash Basis preference under the More Options > Additional Options of your report?

in How can I produce client value reports on a cash basis, if we are accrual? Comment by Ivy Lopez-Oracle May 1, 2023 2:13PM

Hi @User_F6209, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in Exporting data from PBCS Comment by Ivy Lopez-Oracle May 1, 2023 1:29PM

Hi @Dallas H, I agree with what @Tiru Chembeti said. You can use Item Groups to see the components at the PO level. Assembly Items are designed to be Built, or purchased as a whole Assembly. That being said, on a PO, it is standard behavior that only the Assembly Item is shown, not the components. Components of Assemblies…

in Why is Assembly Item not showing Components in Item Receipt? Comment by Ivy Lopez-Oracle Apr 28, 2023 7:16PM

Hi @Camila O, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to help you with your concern. Please allow them some time to investigate and get back to you. In the meantime, if any…

in Is it possible to login via Google SSO's link without being logged into my email? Comment by Ivy Lopez-Oracle Apr 28, 2023 1:55PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments