Ivy Lopez-Oracle NSC Guru

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…

I searched for SuiteAnswers articles related to the error message you provided and came upon SuiteAnswers 42821. According to the article: User receives error that says "The subsidiary restrictions on this record are incompatible with those defined for account: XXX. Subsidiary access on this record must be a subset of…

Thanks for sharing your process, @JohnCirocco! Your input is always appreciated. ? ----- Hi @Dallas H, Since you are adding a new Landed Cost Template to the Item Record, what we need to do is to Add a new Landed Cost Template Mapping, instead of Updating an existing one. You can find the existing Landed Cost Template…

Hi @User_K4VC1, Have these items already been used in transactions? What role are you using? Is it a custom role or Administrator role? Also, can you send us a screenshot of the item record in edit mode? Just make sure to hide any confidential information.

Hi @User_K4VC1, Welcome to NetSuite Support Community and thank you for posting your concern here! ? For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so…

Hi @CatPhish, Welcome to NetSuite Support Community and thank you for posting your concern here! ? For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. Regarding your concern, I am tagging our Gurus who may be able to…

Hi @Dallas H, Please note that I have created this new thread regarding CSV Import for Landed Cost Template Mapping since this topic is different from the original thread you posted, which was about updating the Purchase Order via CSV. Allow me to test this one for a bit, then I'll send you the steps. ?

Hi Dallas, Is there no Landed Cost Template field available in the transaction/purchase order import? If you check my previous comment, I have provided the mapping for the transaction update import, which includes the Item Line Landed Cost Template field.. For easy reference, here is a screenshot of the mapping: The Landed…

You're welcome, Dallas! I'm always glad to help! ?

Hi Paul, If you use the Customer Saved Search, does it provide the complete list for you without timing out? The only problem you have with the Customer Saved Search is the Price not being shown in Sale Units, right? If so, can you provide the criteria you used on your Customer Saved Search? I'll try to further test and…

Hi @PaulFleetwood, Are you using Quantity Pricing Schedules? This might be the reason for the multiple lines in the search results. In the Pricing Saved Search, kindly try adding a Formula (Numeric) field in your criteria with this formula: CASE WHEN {customer.itempricinglevel}='Custom' AND {pricelevel} =…

Hi there @Hormese Paul, Have you checked SuiteAnswers 99471 - Packing Items into Cartons ? I have also checked in a test account, and in the Pack Station App, the users will be asked to select the Sales Order that they will pack. Upon selecting Sales Order/s, users will be shown a list of the items to be packed. At this…

Hi @paula.courtemanche, Upon further testing, I noted that using the Inbound Shipment to allocate the landed costs is also possible, even without the Supply Chain Management bundle. However, please note that the Landed Cost Templates are only available if the Estimated Landed Cost feature is enabled (this is part of the…

Hi Dallas, Just from the screenshots, I can't really see any difference between the items that could cause item 64646 to not be shown in the search. ? Can you verify if this item already has transactions for the location? Also, confirm if the other item has transactions as well. The next troubleshooting step would probably…

Awww, thanks Dallas! ? Showing the internal ID in the Purchase Order is possible by using a Custom Transaction Body Field. Here's what I did: 1. Go to Customization > Lists, Records, & Fields > Transaction Body Fields > New 2. Enter a Label 3. Type = Free-Form Text 4. Store Value = F 5. Applies To tab > check Purchase 6.…

Hi Dallas, For the Purchase Order: Internal ID, it should be the Internal ID of the Purchase Order that you are updating. May I ask if you are trying to add new lines or update existing line items in the Purchase Order? Can you try using the Internal ID of the Item for the mapping for Purchase Order Items: Item? Make sure…

Hi @User_OPUDV, That is unfortunate since the Scrap field is also not yet available in saved searches, so we can't compare it to other fields. If you are reviewing Work Order Close transactions, the only other workaround I can think of is to use the "Applied To Transaction" join fields to be able to get the quantity from…

Sounds good, Toanne! ? Let us know if you need further assistance with this.

Hi Toanne, I'm glad the information helped! ? We appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you have a great day! ? -Ivy

Hi @dle_35705, Thank you or creating another thread here in our community! ? I tested this on my end and was unable to find the "Taxable" field as well. Upon further checking, it seems that the field is not yet available in saved searches. This is tracked in Enhancement # 183917 - Ability to have the Taxable box available…