Ivy Lopez-Oracle · SCM Guru · Red Diamond

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.

In my test account, the Item Receipt I created also doesn't have a GL Impact, but it is still showing in the report. You can find the Inventory Valuation Report by navigating to Reports > Inventory/Items > Inventory Valuation Report > Detail. This functions similar to the Inventory Activity Detail Report, but also shows…

You can check the following SuiteAnswers articles for more information regarding this report: 28022 26403 In troubleshooting this, please check the following as well: Is this the only item receipt not showing? Does the Item Receipt have a GL Impact? Are other transactions for this item showing in the report? Is the Item…

Hi Prtk, It will give you null values if the Class field is blank on the Item Record. Do you want to have a text populate the column instead of a blank? You can do this by adding a Formula (Text) field with the formula: NVL({item.class},'NoClass') As for the Internal ID of the Class, you can add another Formula (Text)…

Hi @User_DPITI, Have you tried adding the Item: Class field in the Results tab of your search? If you add this field to your transaction saved search, then it should pull the value of the Class field in the item record. Let us know if this works for you or if you need further assistance with this. ? -Ivy…

Hey there @User_FZNHI, Can you try this formula: CASE WHEN {internalid} <> {custbody_trandid} THEN 1 ELSE 0 END If this doesn't work, then kindly provide some screenshots of your custom field setup so we can further test in our account. ? -Ivy ========================= If you find this reply to your question as helpful,…

I am not able to reproduce the behavior in my test account. Even when the location in the item line and header level of the Item Receipt is different, it is still showing in the Inventory Activity Detail Report. Have you tried to set the Location filter of the report to -All-? Is it still not showing? Based on the…

Please check the Date Range in the report and make sure that the Item Receipt Date is within the range. Also try checking if the location set on the Item Receipt is the same, or included in the location filters of your report (if any).

Hi @Strategit_Shunta4, On the Item Receipt, please check if the ‘Restock’ checkbox is marked. Based on SuiteAnswers 9147 - Receiving a Customer Return: Check the Restock box to return this item to your inventory. Your inventory reflects the increased count of the returned item and the value of your inventory is also…

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…