Ivy Lopez-Oracle NSC Guru

Hi @Biomerics_Admin, Thank you for being with us today and for posting your question here! Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings. @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle, any ideas? To anyone in the community who might have an idea, feel…

Hi there @User_NOMCY, Welcome to the community and thank you for posting your concern here. ? Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings. If you can share some screenshots as well, that would definitely help us in investigating this one. Also, you may…

You're welcome, Bee! Glad I could help! ?

The error might be happening because there are some lines in the search that are returning "invalid" when trying to convert the string to a date. For example, the lot number is WSA-20231025-20211325, so the system pulls 20211325, and tries to convert it to a date. 13/25/2021 is an invalid date. Also, are there lot numbers…

Hi there Bee @User_IE7NG, I've tested this one out, and I've come up with these Formula: If using Formula (Text): (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),5,2)) || '/' || (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),7)) || '/' || (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),1,4)) If using Formula (Date):…

Hi @eleran, Thank you for creating another thread here in our community! ? @Leonard Mallare-Oracle will be assisting you with this one. Anyone else experiencing a similar scenario? Feel free to comment here.

Hi @User_VSPJE, Welcome to the community! We are glad to have you here with us! ? To get you started, we recommend the following: Update your profile, add a profile picture and preferred username so other members can address you properly moving forward. You can check out Community Tip: Updating Your Profile! on how to do…

You're welcome! Glad I could help, @RichardMc! ?

Hi @RichardMc, Have you tried using the Document Number/ID or the Transaction Number/ID fields?

Hi Nahir, Please be informed that after further checking, I was able to verify that you can only use current on hand of the item using saved searches and not the beginning nor end on hand on a specific date. You mentioned in your initial post that the formula is: Sell through rate = total units sold per day / (units on…

Hi there @Wendy_M, Thank you for posting again here in the community! ? Please allow some time for the gurus/members to check on your concern and get back with more information. Hi @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Leonard Mallare-Oracle, any thoughts on this one? To everyone, feel free to share your…

Hi @Jay Schwausch, At this time, there is no preference yet on setting the Default Replenishment Method in items. We have an existing enhancement requesting for this feature: Enhancement # 239015: Have a preference to set a default Replenishment Method You can vote for the enhancement in the SuiteIdeas page. As for your…

Hi @Biomerics_Admin, You can refer to SuiteAnswers 61670: Impact of Accounting Preference Void Transactions Using Reversing Journals to Inventory-Affecting Transactions for further details. This article shows a list of inventory affecting transactions which can be voided, and Item Receipt/Item Fulfillment are not part of…

Hi @Biomerics_Admin, I got the below details in the Oracle NetSuite Support Community Inbox: Greetings Ivy, Thanks for the prompt response, I don’t see the void button on Inventory Adjustment is that a feature? Or a particular module? I will need to file the enhancement requests for the other ones. Thanks. For future…

Hi @KNason76, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other users, feel free join in the discussion as well. ?

Hi @Biomerics_Admin, For Inventory Adjustments, you can Edit, then click Void. However, there is no option like this for the other transactions that you mentioned. I did find some enhancements requesting for this functionality: Enhancement # 312004: Transactions > Allow users to void or reverse an item fulfillment or item…

Hi @kaj710, I have checked on your concern and noted that the ability to limit the quantity to be built on a WO Completion based on the quantity committed to the WO or the quantity in a WO Issue is not yet available in the standard NetSuite UI. I came across an enhancement request related to your requirement: Enhancement #…

Glad to know that the issue is now resolved on your end, Colleen! Thank you for updating this thread as well! ?

Hi @CDuf and @andyns, Per status.netsuite.com, the issue is now resolved. Please confirm if you are now able to log in.

You're welcome, @Daniel V! Glad I could help! ?

Hi @CDuf, The urgency level assigned Defect # 648894 is the highest level - U1. We understand this is a very critical defect. Our management and engineering teams have been contacted to investigate and work on a resolution – we will keep you posted on the progress of the investigation. You can also check…

Hi @CDuf, Thank you for posting here in our community. There is a recent defect related to your concern: Issue # 648894 - Unable to access Netsuite There is also another update, upon checking status.netsuite.com: Customers in all regions may be unable to load netsuite.com. Please use…

Hi @User_J9SD6, Was my previous comment able to help in your concern? If so, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below my previous comment. This will also help other community members who might have the same concern find the answer easier. Hope you have a great day! -Ivy

Hi @Daniel V, Here's the formula: NVL2({inventorydetail.inventorynumber},NULL,ROUND(({costestimate}/{quantity}),2)) Hope this helps! ? -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 “Did this answer your…

Hi @Daniel V, You can use this formula: NVL2({inventorydetail.inventorynumber},ROUND(({costestimate}/{quantity}/1.39062717),2),NULL) Let us know if this 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…

Thanks for sharing the formula you used, @farrago! ?

Hi there @MJ NCO, Glad to have you with us today and thank you for posting your concern here in our community! Let me tag our Gurus who will be helping you out on this one. @Michelle Jabanes-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle any ideas? To our other members, feel free to share your insights on…

Hi @farrago, Try using a Formula (Text) field with this formula: '<a href = "https://XXXXXXX.app.netsuite.com/app/accounting/transactions/salesord.nl?id=' || {createdfrom.internalid} ||'">' || {createdfrom}|| '</a>' Just replace the XXXXXXX with your account number. Let us know if this will work for you. ? -Ivy…

Based on SuiteAnswers 21335, the behavior that the Purchase Price automatically changes when the item is updated happens when the Item record has a Preferred Vendor with a currency different from the Base Currency. If the Preferred Vendor on the Item record is a foreign vendor, the Purchase Price field will show in the…

This preference is not related and should not affect the purchase cost of the items if the items are updated thru saved import.