Ivy Lopez-Oracle NSC Guru

Hi @OliverK, Kindly try adding this formula in the Results tab of your Search: CASE WHEN {item.internalid} IN (406,504,1583,1591) THEN NULL ELSE {rate} END Just replace the numbers in the parenthesis to the Internal IDs of the items you want the Item Rate to be blank. You can also add more numbers, just separate them using…

Thanks for providing the screenshots! Let me test this first on my account and I'll get back to you as soon as I can.

Hi @OliverK, How many certain items do you need to filter out? What will be displayed on the report results for these certain items, if not the item rate? Also, it would be helpful if you can provide the Criteria and Results tab of the search that you have. This would help us in trying to test for a possible solution to…

Can't say for certain, but my guess would be that thr Inventory Status feature might have been turned on and off. Have you already filed a case with Support regarding this? They could further investigate this one if you file a case with them.

Hi there @JoshPNW, Not an expert in creating workflows, but you can try these formula, which works in Saved Searches: {companyfieldid} || 'some text' or CONCAT({companyfieldid},'some text') For example: CONCAT({project},'_Other Text Here) or {project} || '_Other Text Here' Result would be: Please note that while the…

There is no documented workaround for this one, unfortunately. It is possible to use International Shipping Items for UPS when the International Shipping preference is enabled under Setup > Accounting > Shipping > Preferences > Carrier Basics. However, there are some limitations, one of which is what I mentioned in my…

Hi @KNason76, Upon checking, AES/ITN Field is only supported when using FedEx for International shipments. There is currently an enhancement for USPS/UPS to have the ITN supported (Enhancement 382772). You can vote for this in the SuiteIdeas page. Apologies for the inconvenience this limitation may be causing you, but I…

Hi @Asher_123, It would depend on your business process, but here are some points of each that you can help you decide: Option 1: Remove them and then add them again with inventory adjustments Need to create 2 different inventory adjustments (on different dates) Will be able to do the adjustments even if the inventory…

You're welcome, @KaylaM! Glad I was able to help! ?

Hi @KaylaM, I managed to create both a Saved Search and a SuiteAnalytics Workbook (Pivot) for your requirement. Below are the details of each: Saved Search (Item) Criteria tab: Note: You can modify or set other criteria as needed. Results tab: Formula used: Jan - CASE WHEN ((TO_CHAR(TO_DATE({transaction.trandate}),'MM')) =…

Got it! Let me run some tests, and I'll get back to you as soon as I have a search or a workbook prepared. ?

Thank you for providing the details. I'm afraid that pulling the data on a per month basis in a report is not possible yet. We do have an enhancement related to this: Enhancement # 138533 - Reports > Ability to run any (or most) reports in matrix format, using any field as pivot columns You can vote for this in the…

Hi @KaylaM, Thanks for tagging me. Are you trying to create a report, saved search or analytics workbook? Kindly provide the details that you need to have in the shipping report, so I can test it out on my end. ?

Hi @User_R8KYJ, Did my previous comment help in your concern? If it did, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the same concern find the answer easier. Hope you…

Hi @FoxFoxFox, Did my previous comment help in your concern? If it did, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the same concern find the answer easier. Hope you have…

Hi @User_USRCP, Thank you for posting your concern here in our community! Allow me to tag @Michelle Jabanes-Oracle who will be helping you out on this one. To our other members, feel free to comment your insights in this thread.

Thank you for keeping us updated! Glad it now works as expected on your end. ?

You're welcome! Glad I was able to help! ?

If the item was over received, then shouldn't there have be a positive 0.02 in the bin instead of negative? Anyway, have you tried the same steps to resolve this?

Sounds good! Looking forward to hearing back from you. ?

Hi again @Biomerics_Admin, Did you watch the video I sent previously? If you have, then you might be confused, because the steps indicated there are sort of reversed, for your use case. I have reviewed the information you sent initially, and for your case, the Positive Adjustment should be done first before the Negative…

Thanks for keeping us updated! By the way, have you watched this video made by our guru @Joy Noreen Magoling-Oracle? This may help you resolve your issue on the mismatch. Additionally, you can also check SuiteAnswers 86524. Let us know if any of this helps, or if you need further assistance. -Ivy =========================…

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!