Ivy Lopez-Oracle · SCM Guru · Red Diamond

Glad you were able to resolve the issue. Thanks for updating this thread, @KNason76! ?

You're welcome, @User_EGVUA! ? Let us know if you need further assistance with this. We'd also appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern.…

Hmmm.. Maybe it's because the thread was created based on your comment on another thread (split) and it's not visible to you since you technically did not create this. Anyway, thank you so much for confirming that it worked! I'll just mark my previous comment as correct for you, so if other members have the same concern,…

Hi @markival, Just a quick update on this thread. I tried to create an item saved search for this with the criteria Location Available is less than 1 and I made sure to mark the Send Email Alerts When Records Are Created/Updated preference in the Email tab of the Search, Whenever I created a transaction to make the…

Hi @Dallas H, Just wondering if you have been able to test this on your end. We'd appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. -Ivy

Hi @JoshPNW, Are you referring to the Inventory Activity Detail report under Reports > Inventory/Items? If so, you can customize this report to show the Location. Here are the steps: 1. Go to Reports > Inventory/Items > Inventory Activity Detail > Customize 2. In the Edit Columns tab > Add Fields portion, expand the…

Glad I could help, Dallas! ?

Sounds good, Paula! Let us know how it goes. ?

Hi Dallas, Great job on figuring out the Criteria causing the issue in the search! ? Thank you as well for sharing the result of your additional tests. It helped me come up with a possible solution. Add this in the criteria of your search: By adding parenthesis and an OR in between these criteria, the system should now…

Hi @KNason76, I'm glad that the Supply Type field is now showing on the record. Are you receiving an error message when you create an Inventory Adjustment? What is the exact error message you receive? Please check the Related Records of the Item and check if there is an Inventory Cost Revaluation record dated on or before…

Thanks for helping us out with this one, @John Griffin! ? Hi @Toanne Termeer - van de Ven, the cost you are seeing now might have something to do with the Machine Resources and Labor Resources you have set in your Manufacturing Routing record. I noticed that in the initial screenshots you sent, the values of those fields…

Hi @User_EGVUA, Just curious, is there a reason why you use the count of the Name field instead of Internal ID field as basis for your results? I replicated the search in my test account and thought I'd share with you my what I noticed: I found that if you use the Summary Type = Count for the Name field, it only counts the…

Re: Supply Type field Is the Advanced Item Location Configuration enabled or had been enabled in the account? Do you have Demand Planning feature available in the account? Has this been enabled/disabled before? ---- Re: Inventory Adjustment for the Standard Costing Item Are you receiving an error message when you create an…

I checked in another test account without the Demand Planning feature, and it still shows up. Can you check if the Allow Purchase of Assembly Items preference is enabled in your account? You can find this under Setup > Accounting > Accounting Preferences > Order Management tab > Purchasing section. If this is not yet…

Hi @KNason76, It should be in the Locations sublist of the item record, under the Purchasing/Inventory Tab. Can you share a screenshot of this sublist in your account? Just make sure to hide any confidential information.

Hmmm.. This means that the formula isn't the problem either, since all the items are showing up. Next step in troubleshooting this is to add the other criteria in the "Jenn - Available" search to your "Dallas test" search one by one. Save & Run the search each time you add a new criteria, and check if the results will show…

That's a lot of items! What I meant was to add the criteria to the existing ones in your "Dallas test for stock out" search. Kindly include the Internal ID criteria too: Internal ID is XXXX (Enter the internal ID of the 3 items on the saved search, and the item which is not showing up) Then check if it will show 4 items,…

The formula seems to be working fine... Next, try to add this criteria still in your "Dallas test for stock out search": Then run the search and check if there will still be 4 items in the results or if item 700FLD will be removed.

Hi Paula, Just wanted to check if you were able to test if the landed cost in the inbound shipment is still not allocated properly when scripts or workflows are undeployed.

Hi Dallas, Don't worry, I'll try my best to troubleshoot this with you, but if we still can't figure out what is causing the behavior, then creating a Support case might be our only option. ? Anyway, since it doesn't seem like the other criteria is the cause, then let's check the formula. Kindly add these columns to the…

Hi Dallas, Sorry for not being clear. What I meant was to check in the results of the "Jenn - Available Inventory is below Safety Stock Calgary" search if the item will now show up. The reason for this is because when I tested a custom checkbox in my account, if I set the criteria filter to false, those with blanks still…

Hi Dallas, Kindly try going to the item record, then retoggle the custom field so that it will show "No" in the search results. Then check if the item will now show in the search results.

Hi @Toanne Termeer - van de Ven, You mentioned you have already entered the Standard Cost in the Items. Are you also done with Revaluing Standard Cost Inventory?

Hi @Dallas H, Please note that I have created another thread for your other concern about CSV Import for Landed Cost Template Mapping. You can check out the thread here: Let's use this new thread to discuss further about your concern. ?

Hi @Hormese Paul, Thanks for clarifying your concern. I have checked the documentation we have and noted the "Manually Packing Orders and Printing Packing Lists" topic in the WMS User Guide. The Pack Orders page displays a list of orders to be packed, and you can select the order or items you need to pack from this list.…

Hi Paul, You can always try raising this with Support. However, note that based on my tests, the Pricing saved search shows the correct prices of the items based on the Sales Unit. It is the Customer saved search which shows the prices in the Base Unit. This has previously been identified as a standard behavior of the…

Hi Paul, I have tested this extensively on my standard test account, but unfortunately, I was unable to find any workaround using a Customer Saved Search. I tried using the Pricing join fields in the Customer Saved Search results, but the items with Custom Pricing Level were not showing up in the Pricing join fields…

Hi @markival, Can you share with us the criteria and results tab of the search you created so we can test it out on our end as well? If you will be sending screenshots, please make sure that confidential information are hidden. Also, kindly confirm in the Email tab of the saved search if the Send Email Alerts When Records…

That is weird. ? The only instances I was able to replicate the behavior of the Subsidiary field in Edit mode was: if there was a Workflow which made the Subsidiary field into an Inline Text field if there was a Subsidiary selected in the Restrict View in the Preferences Since you have mentioned that both cases were not…

Hi Inna @User_K4VC1, I got the below details in the Oracle NetSuite Support Community Inbox: Thank you so much. - We do not want to change account subsidiary (which is also gray) – it is correct. We need to change item subsidiary which is wrong. - There is no Non-Inventory Part record in the list - Unfortunately, we are…