Ivy Lopez-Oracle

Hi @Niki Harvan, For your first concern about the Transfer Price being always 0, can you check the item record if there is a Transfer Price set up? Here's the field help of the Use Item Cost as Transfer Cost in the Transfer Order: Note that it says: The transfer price defaults to show the value in the Transfer Price field…

in Need transfer order packing slip with transfer price listed for customs Comment by Ivy Lopez-Oracle Jun 9, 2023 5:18PM

Thanks for the update, @Nickey! Glad it works for you now. If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. This will also help other community members who might have the same concern find the answer easier.…

in Items with no movement Comment by Ivy Lopez-Oracle Jun 9, 2023 4:52PM

Hi @User_IJB6M, 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 AP AR Intercompany Balancing REport Comment by Ivy Lopez-Oracle Jun 9, 2023 3:14PM

Hey there @Dallas H, Good to see you here again! I have internally coordinated this question to our gurus who specialize in Promotions. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in Buy more and save promotion Comment by Ivy Lopez-Oracle Jun 9, 2023 3:04PM

Hi @User_NZ9RW, 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 find where something is committed easily Comment by Ivy Lopez-Oracle Jun 9, 2023 3:00PM

HI @Katelyn M Martin, 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 Why Shipping Address will not populate in Workflow Email using the {shipaddress} field reference? Comment by Ivy Lopez-Oracle Jun 9, 2023 2:52PM

Hi @User_JJC0O, Per checking our resources on this one, it seems that this is currently the standard behavior and an enhancement has been logged related to this: Enhancement # 191277: Lists > Search > Saved Search > New > Transactions with Criteria of Standard and Summary, and Results have Summary Type, will not send an…

in Send email alert on an Item Alias Saved Search that uses Summary type Comment by Ivy Lopez-Oracle Jun 9, 2023 2:41PM

Hi @Nickey, I agree with what @Brian Stisser suggested. I tested it on my end, and it worked. Here's some screenshots of the sample search I tested, just in case you need it: Criteria > Standard tab (I only added Type = Inventory Item, but you can add other criteria as needed) Criteria > Summary tab Formula used: CASE WHEN…

in Items with no movement Comment by Ivy Lopez-Oracle Jun 8, 2023 11:08PM

Hi @Preethi Kondur, I think you're on the right track with Item Pricing, Group Pricing and Price Levels. Here's an article that discusses what will default in the Sales Order when the Customer Name has been selected: 27011: Default Price and Price Level used in the Sales Orders I don't think custom records are needed…

in Multiple Item Pricing Comment by Ivy Lopez-Oracle Jun 8, 2023 9:55PM

Hi @JarebCoupe, That is actually standard behavior if you are using the field joins and the results have different values. @Estee's suggestion is right. You can use Summary Type = Group in your Results. Additionally, you can try using the NS_CONCAT formula to show the Sales Team Members in only one row/line. Here's a…

in Is it possible to have a roll-up Transaction search (not show by line item)? Comment by Ivy Lopez-Oracle Jun 8, 2023 9:28PM

You're welcome, @CDuf! I'm glad I could help. 😉

in What is the Formula to get a substring from text box field? Comment by Ivy Lopez-Oracle Jun 8, 2023 4:27PM

Hi @CDuf, Try this formula: REGEXP_SUBSTR({email}, '[^@]*$') I also wrote a discussion article about this recently. Here's the link if you're interested:

in What is the Formula to get a substring from text box field? Comment by Ivy Lopez-Oracle Jun 8, 2023 4:19PM

Hi @JarebCoupe, Thanks for reaching out to us in the NetSuite Support Community. Try adding the Criteria: Main Line = Yes or True If this does not work for you, then we'd appreciate if you can provide more details like screenshots of the Criteria tab and Results tab of your search, and what your expected results are so we…

in Is it possible to have a roll-up Transaction search (not show by line item)? Comment by Ivy Lopez-Oracle Jun 8, 2023 3:19PM

Hi @Rhys Gottwald, 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. If any other members have any thoughts, insights, or suggestions, we encourage them to share them with you. --- In the meantime, you might be…

in How to edit Cart Putaway Sort Sequence? Comment by Ivy Lopez-Oracle Jun 8, 2023 3:12PM

Hi @Sivasubramaniam, 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 Why are we Getting SSS_INSTRUCTION_COUNT_EXCEEDED error in Map/ Reduce script? Comment by Ivy Lopez-Oracle Jun 8, 2023 2:52PM

Hi @strijul, 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 "you do not have privileges to view this page" error on Bill Payment File Generation? Comment by Ivy Lopez-Oracle Jun 8, 2023 2:49PM

Hello @User_YMWNR, Just wanted to check in if you were able to see the previous comments on this thread. If any of them were 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 Answer…

in inventory received not billed Comment by Ivy Lopez-Oracle Jun 7, 2023 10:32PM

Hello @User_5L9JT, 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…

in By Products Comment by Ivy Lopez-Oracle Jun 7, 2023 10:23PM

Hi @RobSpector, 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 Saved Search that lists items with out transactions associated with them Comment by Ivy Lopez-Oracle Jun 7, 2023 10:22PM

Hello @User_SN7F6, @Jordan Craig is correct. Here's the details of the enhancement: Enhancement # 183000: To be able to track changes in the Shipping Cost field in the transaction records via the system notes. You can vote for this in the SuiteIdeas page.

in Shipping Cost field not returned in System Notes Comment by Ivy Lopez-Oracle Jun 7, 2023 10:18PM

Hi @Greg Ebel, 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 put borders in every cell - Advanced PDF/HTML Template Comment by Ivy Lopez-Oracle Jun 7, 2023 3:28PM

Hi @User_D0HJA, 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 the error while working on Assemblyitem through RESTLet? Comment by Ivy Lopez-Oracle Jun 7, 2023 1:59PM

Hi Dallas, So you are saying that it is displaying the correct COUNT of the orders which is 639, but it is just the total amount showing incorrectly? If so, can you try to use {amount} instead of {totalamount} in the formula?

in Previous Transaction search not totaling correctly Comment by Ivy Lopez-Oracle Jun 6, 2023 7:12PM

Hi Dallas, can you also show the Item: Type in the list? (just to be sure) Also, are you able to provide the list of the 639 orders in the current search? (Try drilling down the search, or removing the summary types then extract as XLS file. You can also create a new saved search with the same criteria and use the # Orders…

in Previous Transaction search not totaling correctly Comment by Ivy Lopez-Oracle Jun 6, 2023 5:31PM

Hi @tech work, It seems you already have an open question with the same concern: One of our gurus is already checking on it. We'll be closing this thread as a duplicate. Let's use the original thread for any updates moving forward.

in Why am I receiving Error while creating work order from sales order Comment by Ivy Lopez-Oracle Jun 6, 2023 3:25PM

Hi @User_W3GAA, Thanks for reaching out to us in the NetSuite Support Community. Can you confirm if this Product Group record is something custom or part of a bundle on your account?

in How can I find the list of parent product groups? Comment by Ivy Lopez-Oracle Jun 6, 2023 3:19PM

Hi @User_YMWNR, 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 check imported Bank Transactions? Comment by Ivy Lopez-Oracle Jun 6, 2023 2:46PM

Hi @filippo.blengini, 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 Report Webquery Number format Comment by Ivy Lopez-Oracle Jun 6, 2023 2:39PM

Hi @H3NO5, Thanks for reaching out to us in the NetSuite Support Community. Our gurus @Patrick Fresnosa-Oracle & @Clarisa De Torres-Oracle are currently checking your question and will get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them…

in How is the tax determination of services and Regular goods inside Europe? Comment by Ivy Lopez-Oracle Jun 6, 2023 2:29PM

Hi @Jordan Craig, 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 Date Picker in Online Form Comment by Ivy Lopez-Oracle Jun 6, 2023 2:25PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments