Ivy Lopez-Oracle NSC Guru

Hello there @User_92YNP, I checked my resources on this, but unfortunately found no specific documentation on the error message you provided. Since the message said that it is caused by a "database not open" error, then it might have something to do with the connection. It could possibly be your internet connection or the…

Hi @Mark_BRIT, Per checking, Workbook Tables, Pivots, and Charts are available to be exported. Are you referring to a different functionality?

Can you also try searching for Inventory Adjustments/Inventory Transfers which used the item, but did not use bins? You can create an Inventory Valuation Report for the item, and add the Transaction Bin Numbers column in the report, so that you can easily check which transactions used bins.

Hi there @Biomerics_Admin, Thanks for posting another question here in our community! Can you check the system notes on the item record if the Use Bins checkbox has been marked and unmarked? There might be a deducting transaction that used the item when the Use Bins checkbox was unmarked. You can try creating the Saved…

Hi @User_4BKFI, I have tested the formula you provided on my test account, and it works as expected for me. Transaction search results: Not sure why it gives a blank for you, but can you try to recreate the search, and include only the Customer Part Number and Formula (Text) fields in the results? Also, try setting the…

Hi there @User_UJBUD, Thanks for posting another question here in our community! Kindly allow our gurus/members to check on this, and we'll get back to you with our findings. To anyone else who has any idea, feel free to reply to this thread!

Hi @User_UJBUD, 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…

Hi @User_4BKFI, Glad to have you with us today and thank you for posting your concern here in our community! Allow us to check and test this on our end, and we'll update you of our findings. Anyone else with an idea regarding this? Let us know by commenting in this thread!

Hi @Joe Klotzle, Thanks for posting again here in the community! Tagging our gurus who will be able to assist you with this: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas? To our other members, feel free to share your insights as well.

Hi @Biomerics_Admin, By design, NetSuite considers all adding transactions for the last purchase price. Hence, the last purchase price will be derived not only on a receipt of an item but also by Inventory Adjustments and Transfers that increased the inventory. It is currently a system limitation to exclude the following…

Hi @Kathy W, We have received your message in the community Inbox. The reason why there was no "Yes" is because you initially created a discussion thread. I have converted it into a question thread now. Please check if you can now see the “Did this answer your question?” portion below the comment/s. Thank you! -Ivy

I'm glad that it worked! In case you encounter this again, here's what you need to do to get the URL: Using a user/role which does not get the error, go to the List view of the record (for example, Transactions > Inventory > Adjust Inventory > List) Change the view to a custom view Change it back to Default Copy the URL…

Hi Kathy, Using the user/role experiencing the error, try pasting this after the account number in the URL:…

Hi @User_LWYVY, Glad to have you with us today and thank you for creating another thread here in our community! ? Please allow some time for the gurus/members to check this one out for you and give updates for any findings. To our other members, feel free to share your insights or ideas that can help.

Currently, we only have the Schema Browser, Records Browser and Connect Browser that documents the fields. If a field is not exposed in these, you can request an enhancement for the specific fields to be exposed. I had a look at the Schema Browser and Connect Browser, and I noticed that fields with RecordRef type in the…

Hi @FoxFoxFox, Thank you for posting another thread here in our community! ? You can try the Schema Browser. You can check SuiteAnswers 11017 for more information about this. Hope this helps! ? -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it…

Glad it works for you now! Thanks for keeping this thread updated! ?

Hi @User_R8KYJ, You can try using a Formula (Text) field to get a text value of the Rate. Since it is a text value, it will not show the total. 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.…

What is the exact error shown when you use the formula you provided previously? When I tried it, using {internalid} worked on my end as expected. If you can share the Criteria and Results tab of your search, it would be much appreciated so we can also test it in our end.

Hi Tom, What formatting do you need? Can you provide an example?

On my test account, I tried the formula you provided and it worked for me. I had Type = Purchase Order in the Criteria of the search. If you have set the Criteria to Type = Sales Order, then you can try this formula: '<a href="/app/accounting/transactions/purchord.nl?id=' ||{applyingtransaction.internalid}|| '&whence=">'…

In the Criteria of the search, what is the Type of transaction?

Hi @nag_m, Thank you for posting another question here in our community! Tagging our gurus who can help you out on this one. @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, need your expertise here. ? To our other members, feel free to comment your ideas or insights here.

Hi there @User_12IEI, Welcome to the community! ? 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 this. Visit the NetSuite Support…

Hey there @Christophe Tiers, You can also pull the Related Transactions in Saved Searches. You can use the Joining Fields of Applying Transaction or Applied To Transaction to get the needed information. Related Transactions - Next => Applying Transaction Related Transactions - Previous => Applied To Transaction You said…

Hi there @Aniket-Silversky, Unfortunately, what you are requesting is a known system limitation which is requested in: Enhancement # 84689 - Provide the ability to convert inventory items to lot numbered inventory items and vice versa You can vote for this in the SuiteIdeas page. The proposed alternate solution is to…

Thank you for the information and screenshots provided! That is odd. Was the Inventory Status feature enabled and disabled on your account? Since there is no related documentation on this behavior and I am unable to reproduce this in my test account, I can't say for certain that what you pointed out is the cause, but it is…

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

Hi Prtk, The Class Name associated with the Item should be pulled when using the Item: Class field. I noticed on the screenshot you provided that there is a value populating in the Item: Class field in the results of your search. Is this not the values you expect to be pulled? Or do you need only Freight and not Hardware:…

Hi Prtk, If you use the Class: Name field, it would pull the value of the Class set on the transaction. Kindly check if the transaction has a value on the Class field, in both line level and the item level, or if it is blank.