Ivy Lopez-Oracle

Hi @User_2LD8N, I checked my resources regarding this one and it seems that it is currently a system limitation to add the Issued Step field in a saved search. This was previously filed as Issue # 443481 but was already closed since it is not yet possible to be addressed. The Product Manager mentioned that they can't…

in BOM search Comment by Ivy Lopez-Oracle Jun 30, 2023 8:57PM

You're welcome, @User_SN7F6. Glad I could help! 😊

in Shipping fee added to Invoice when it shouldn't Comment by Ivy Lopez-Oracle Jun 30, 2023 8:33PM

Hi @User_SN7F6, Based on my testing on my standard test account, if the Shipping Method was changed manually in the IF, the shipping cost doesn't automatically recalculate. You would need to click the Calculate icon to recalculate the shipping cost. As for via Suitelet, unfortunately, I am unable to test that since that is…

in Shipping fee added to Invoice when it shouldn't Comment by Ivy Lopez-Oracle Jun 30, 2023 6:56PM

Hi @User_SN7F6, Normally, the shipping information is carried over from the Sales Order to the Item Fulfillment. However, I read the scenario/illustration you previously provided and noted that the IFs have different Shipping Method than the SO. How do you change the Shipping Method on the IFs? Is this being done manually…

in Shipping fee added to Invoice when it shouldn't Comment by Ivy Lopez-Oracle Jun 30, 2023 5:43PM

Hi @User_IOZ5E, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 include PO Number data in FedEx integrated labels? Comment by Ivy Lopez-Oracle Jun 30, 2023 2:10PM

Hi @nag_m, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 create an Invoice for Partner? Comment by Ivy Lopez-Oracle Jun 30, 2023 2:09PM

Hi @User_2LD8N, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 It is possible to transfer a fixed asset to a customer while being able to track it? Comment by Ivy Lopez-Oracle Jun 30, 2023 1:53PM

Hi @User_DATN1, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 Edit the BOM layout printing from work order Comment by Ivy Lopez-Oracle Jun 30, 2023 1:50PM

Hi @Edwards_05, Were able to try modifying the available Material Shortage or the Material Issue saved searches to meet your requirement?

in Advanced Manufacturing Shortage Bin Report Comment by Ivy Lopez-Oracle Jun 29, 2023 10:21PM

Hi @User_2LD8N, You can try this transaction search if this will work for you: Criteria > Standard tab: Criteria > Summary tab: Formula Used: CASE WHEN {memo} LIKE '%LandedCost1%' OR {memo} LIKE '%LandedCost2%' OR {memo} LIKE '%LandedCost3%' OR {memo} LIKE '%LandedCost4' THEN 1 ELSE 0 END Note: Replace "LandedCostX" with…

in Create List of Item Receipts with No Landed Cost Comment by Ivy Lopez-Oracle Jun 29, 2023 10:15PM

Hi Tigran, Appreciate you sharing your insights on this! --- Hi @User_SN7F6, Per SuiteAnswers 24084: The shipping cost transferred to the invoice is coming from the Item Fulfillment not from the Sales Order. The shipping cost on the Item Fulfillment is the actual cost. The Sales Order is only an estimate and the actual…

in Shipping fee added to Invoice when it shouldn't Comment by Ivy Lopez-Oracle Jun 29, 2023 9:14PM

Hi @User_7NK3Q, You can try this Transaction Saved Search: Criteria tab: Note: I only added Type = Work Order since you mentioned you wanted to include WOs that are not yet completed/closed. If you add Main Line = T, then this won't work since details of the Work Order Issue are linked to the component lines. Results tab:…

in Work Order Details Report Comment by Ivy Lopez-Oracle Jun 29, 2023 9:03PM

¡Se acabó el tiempo! ✨ La respuesta correcta y su explicación figuran a continuación: Respuesta correcta: C Explicación: La sintaxis de la función CONCAT es CONCAT(char1, char2). Esta fórmula concatena char1 y char2 en una cadena. La función CONCAT solo puede unir 2 campos o texto a la vez. Necesitaría hacer varios CONCAT…

in 28 de junio de 2023 | Pregunta de la semana Comment by Ivy Lopez-Oracle Jun 29, 2023 6:00PM

Time's up, everyone! ✨ Kindly see details below for the correct answer and its explanation: Correct Answer: C Explanation: The syntax for CONCAT function is CONCAT(char1, char2). This formula concatenates char1 and char2 into one string. The CONCAT function can only join 2 fields or text at a time. You would need to do…

in June 28, 2023 | Question of the Week Comment by Ivy Lopez-Oracle Jun 29, 2023 6:00PM

Hi @User_MU9BN, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be checking your question and we'll get back to you as soon as possible. --- In the meantime, you might be interested in participating in our Question of the Week. You only have until June 29, 2PM ET to comment on your answers…

in The EFT file format is not changing the date when a new file is generated Comment by Ivy Lopez-Oracle Jun 29, 2023 1:46PM

Hi @RichardMc, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be checking your question and we'll get back to you as soon as possible. --- In the meantime, you might be interested in participating in our Question of the Week. You only have until June 29, 2PM ET to comment on your answers…

in How to Customize Form to Show Field from Related Table Comment by Ivy Lopez-Oracle Jun 29, 2023 1:38PM

Hi @GabrielaMari, Thanks for reaching out to us in the NetSuite Support Community. Per checking, we do have FEFO Lot Assignments bundle ID 279508. However, this is not yet applicable to Work Orders. This is currently logged as Enhancement # 659825: FEFO Lot Allocation > Ability to use this when processing Work Orders. You…

in Lot assignment bundle Comment by Ivy Lopez-Oracle Jun 29, 2023 1:31PM

Hi @Edwards_05, You can try modifying the available Material Shortage or the Material Issue saved searches to meet your requirement. To access these, go to Advanced Manufacturing > Planning Reports.

in Advanced Manufacturing Shortage Bin Report Comment by Ivy Lopez-Oracle Jun 28, 2023 9:58PM

Hi @User_SN7F6, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 Shipping fee added to Invoice when it shouldn't Comment by Ivy Lopez-Oracle Jun 28, 2023 1:33PM

Hi @User_Q1DPO, Unfortunately, there is no documented workaround or alternate solution for this yet. You can reach out to your developers or your account manager for a customized scripting solution to your requirement.

in import update for Additional field lot number Comment by Ivy Lopez-Oracle Jun 27, 2023 9:07PM

Hi @Kellyann, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be checking your question and we'll get back to you as soon as possible. In the meantime, you might be interested in participating in our Pop Quiz. You only have until June 27, 3:29PM EDT to comment on your answers and…

in How do I make the customers zip code searchable? Comment by Ivy Lopez-Oracle Jun 27, 2023 2:04PM

Hi @BM136, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be checking your question and we'll get back to you as soon as possible. In the meantime, you might be interested in participating in our Pop Quiz. You only have until June 27, 3:29PM EDT to comment on your answers and earn rewards!…

in How to generate 941 Report? Comment by Ivy Lopez-Oracle Jun 27, 2023 1:59PM

Hi @User_1I8SP, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be checking your question and we'll get back to you as soon as possible. In the meantime, you might be interested in participating in our Pop Quiz. You only have until June 27, 3:29PM EDT to comment on your answers and…

in Can you create a workflow that triggers a "Log Phone Call" form to pop up after saving a Sales Order Comment by Ivy Lopez-Oracle Jun 27, 2023 1:51PM

Hi @Paul Salkeld, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be checking your question and we'll get back to you as soon as possible. In the meantime, you might be interested in participating in our Pop Quiz. You only have until June 27, 3:29PM EDT to comment on your answers and…

in How to reference recurring amount in Suite Billing using Script? Comment by Ivy Lopez-Oracle Jun 27, 2023 1:11PM

Hi @User_Q1DPO, Per checking, this is currently a system limitation and an existing enhancement request has been logged for this: Enhancement # 160685: CSV Import > Item > Serialized/Lot Numbered Inventory Item > To be able to import custom item number/standard fields on the Serial Number/Lot Number Record You can vote for…

in import update for Additional field lot number Comment by Ivy Lopez-Oracle Jun 26, 2023 10:24PM

Hi @JCronin, I checked my resources on this but didn't find any documented workaround. However, I found these existing enhancements that you can vote for: Enhancement # 492366: Advanced BOM = T > Item Saved Search > Be able to expose Current Revision components when pulling Assembly Items Enhancement # 504102: Costed Bill…

in Advanced BOM costing solution Comment by Ivy Lopez-Oracle Jun 26, 2023 9:37PM

Do you still need help with this? If so, let us know what specific issues you have or need help with.

in Work Order Details Report Comment by Ivy Lopez-Oracle Jun 26, 2023 8:17PM

Hi @User_2D608, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 confirm Inventory movement for a Sales Order/Item Fulfillment? Comment by Ivy Lopez-Oracle Jun 26, 2023 3:38PM

Hi @Preethi Kondur, Thanks for reaching out to us in the NetSuite Support Community. Our gurus will be 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 pull Base Price on line item Comment by Ivy Lopez-Oracle Jun 26, 2023 3:02PM

Hi @Edwards_05, Upon checking my resources, I found out that this is not yet possible in the standard NetSuite Account and is logged under: Enhancement # 252217 - Manufacturing > Work Order Completion > Please expose Operation, Quantity and run time fields to transaction searches and/or reports. You can go…

in Work Order Reporting Comment by Ivy Lopez-Oracle Jun 23, 2023 9:14PM

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments