Ivy Lopez-Oracle NSC Guru

Hi @User_82RRL, Glad to have you back with us today and thank you for posting your concern here in our community! Tagging my colleague @Leonard Mallare-Oracle who has the expertise on this. Anyone else with insights on this? Feel free to share them in this thread!

Thanks for the update, Chris!

Hi @ChrisH, Kindly try these formula: CASE WHEN(((CASE WHEN NVL({inventorylocation},0) = 'Location # 1' THEN {locationquantityavailable} ELSE 0 END) + (CASE WHEN NVL({inventorylocation},0) = 'Location # 2' THEN {locationquantityavailable} ELSE 0 END))-5) > 0 THEN (((CASE WHEN NVL({inventorylocation},0) = 'Location # 1'…

Hi there @User_6YI1X, Have you tested the workaround I provided in my previous comment? If you did and it worked for you, 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…

Hi @CDuf, Glad to have you with us today and thanks for creating another thread here in our community! ? I checked this as well in my standard test account, but was unable to find the feature for NetSuite Analytics Warehouse. It would be best to reach out to your account manager as this feature is something that needs to…

Hi there @Vernita, Thank you for creating another thread here in our community! ? Allow our gurus/members some time to check on this one. Let me also tag my colleagues who may be able to help out on this one: @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle / @Patrick Fresnosa-Oracle / @Micah Timbol-Oracle, any ideas that…

Hi @paula.courtemanche, I got the below details in the Oracle NetSuite Support Community Inbox: we are testing now and tweaking our process but this looks like it will work perfectly. I will respond yes tomorrow when I am online. For future communication, it would be better to reply to this thread instead of replying via…

You're welcome, @MSStoke! Glad I could help! ? By the way, it would be great if we will be able to recognize you through your profile picture. By uploading a profile picture, you can earn the Photogenic badge and earn points too. You may check Community Tip: Updating Your Profile to know how. Have a great day! -Ivy

Hi Philip, You can try adding an Alternate Date Range for the columns: You can check SuiteAnswers 8341 for more information on this. 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…

Figured out why this behavior is happening. The search is not pulling the quantity available if there are no transactions for the item during the date range that you specified. Anyway, kindly try these formula (also added a formula for returns and total sales): Location Qty Sold: CASE WHEN {transaction.location} =…

Is the behavior is still the same if you remove the custom field in the criteria?

Are there any other criteria you have in your search? Can you share the Criteria tab of your search as well?

Thanks for providing the screenshots, @MSStoke! At first glance, I noticed that an apostrophe (') is missing in the formula. It should be 'Location B' Can you provide an example item please? What is the expected results and what is the actual value in the results of the search?

Hi @MSStoke, What do you mean by "when I add to locations it doesn't seem to work"? Are you adding a new column for the 2nd location data or does the data need to be in one column only? Like (location A qty + location B qty)? You can also provide some screenshots of your Criteria tab and Results tab. You can also show us…

Hi @MSStoke, Kindly try these on your Item Saved Search: Criteria tab Formula (Numeric): CASE WHEN {inventorylocation} = {transaction.location} THEN 1 ELSE 0 END For the transaction date, select the date range Results tab Formula used: Location Qty Sold: CASE WHEN {transaction.location} = 'Location # 1' AND…

Hi there @user13588389, Thank you for posting your concern here in our community! Allow our gurus/members some time to check this first and we'll provide updates in this thread. To our other members, feel free to share your insights on this one. ?

Thanks for the mention, Katerina! --- Hi Holly, I also looked into this, but I was unable to find a way to get the PO lines and the bill in one line. This is because there is no link between the PO and the standalone bill, so we are unable to group them together and check the balances. I was thinking of creating a report…

Hi there @User_Z4XXD, Welcome to the community! We are glad to have you here with us! ? To get you started in the community, 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…

Hi @Carissa, Excluding Drop Ship items from Item Fulfillment is not possible in the system yet. Enhancement # 160932 is logged requesting for this functionality. You can vote for the enhancement in the SuiteIdeas page. I have tested this in my account and the only time that Drop Ship Items print in the Picking Ticket is…

Hi @User_6YI1X, I tested this in my account and got the same behavior. It seems that it is not possible to add Long Text and Rich Text type custom fields to Pivots in SuiteAnalytics Workbook. This is parallel to the behavior in Saved Searches that Long Text and Rich Text have the Summary Type grayed out. The standard…

Thanks for updating us that it works for you, @Toanne Termeer - van de Ven! Thanks as well for clicking "Yes" under my previous comments. ? If you have time, we also invite you to comment in the Introduce Yourself thread. Just tell us a little bit about yourself to earn a badge (and 100 points). Hope you have a good day as…

Hi @Toanne Termeer - van de Ven, I'm so glad this works for you! ? Here's the formula to see the difference between old and new values: TO_NUMBER(NVL({newvalue},0))-TO_NUMBER(NVL({oldvalue},0)) Since these fields are originally text fields, we need to first convert the values of the field to a number to be able to use them…

Hi @User_B2SDR, Did the provided information help in your concern? If it did, 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 @paula.courtemanche, Did the provided information help? If it did, 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 a…

Hi @ChrisH, Did the provided formula work for you? If it did, 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 a great day! ?…

Hi @Toanne Termeer - van de Ven, As I understand your concern, you are trying to get the values of the system notes in the Item Location Configuration record. Note that normally, when the Advanced Item Location Configuration is not enabled, it is not possible to track the changes made to the fields in the location sublist…

Hi Carissa, As documented in SuiteAnswers 63328: Drop Ship Items are designed not to appear in Picking Tickets because they do not get delivered to the Warehouse. There is no need to Pick them because they are delivered to the customer straight from the Vendor. Picking tickets also rely on the Committed Quantities from the…

Hi @KaylaM, When creating negative inventory adjustments (reducing quantity in a location), the est. unit cost field is greyed out and can't be edited. This is because the system will automatically calculate the cost of the negative adjustment once the transaction is saved. This behavior is also stated in SuiteAnswers…

Hi @paula.courtemanche, You can check SuiteAnswers 26826. This article discusses a suggested process on handling returns when an incorrect item is shipped to the customer. For easy reference, here is the process discussed in the article: Step 1. Put the item (correct) that was never sent back to inventory Create a Return…

Hi there @User_6YI1X, You can try these criteria in a Transaction Saved Search: Type = Work Order Item On Any Line = none of XXX (Select the specific Item) 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…