Ivy Lopez-Oracle · SCM Guru · Red Diamond

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…

Hi @User_LYA61, Glad to have you with us today and thank you for posting your concern here in our community! ? Allow me to tag my colleagues who will be able to help you out on your concern: @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle / @Michelle Jabanes-Oracle, any insights on this one? Other members who have ideas,…

Hi Maurice, Glad to have you with us today! ? Our gurus who handle this type of concern will be reviewing your post and will reply to this thread for any updates. To other members who might have ideas, feel free to join this thread!

Can you share a screenshot of an Item Record > Inventory Locations sublist of another item (DCH273P2DHO) which is showing on the results of the search? Also, kindly add Inventory Location Available in the search results and try to run the search again. Send a screenshot of this as well. I just want to compare the…

Hi Dallas, Have you checked if the item meets the other criteria, like the Vendor Name, Vendor Code, Special Order/Drop Ship, Inactive and other custom checkboxes? Also, I have edited the screenshots you provided in your previous comment and removed the URL part of the browser. This is because the URL contains your account…

Hi Toanne, Can you check the Schedule Inventory Costing preference in your account? You can find it in Setup > Accounting > Inventory Costing Preferences. Verify if the costing is running every hour or on a custom schedule. You can check SuiteAnswers 65659 for more information about this. Regarding the GL Impact changed by…

I'm glad it helped! ? Kindly refresh the thread. There should be a Did this answer the question? and "Yes" link at the bottom of the comment. ?

Hello @paula.courtemanche, Was my previous comment able to help with your concern? If so, 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.…

Hello @rburns515, Was my previous comment able to help with your concern? If so, 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…

Hi @User_QHG6U, Have you been able to try out the saved search in SuiteAnswers 32302 or in the related thread? Let us know if it worked for you or 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 my previous comment that helped…

Hello @User_OPUDV, Were you able to try out the workaround provided in my previous comment? Let us know if it worked for you. We'd also 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…

Hi @PaulFleetwood, Have you tried using a Pricing Saved Search? This type of saved search has join fields for both the Customer record and Item record. I tried it, and it seems that the Pricing search gives the correct price based on the Sales Unit. You can also check out this thread which is related to the Pricing Saved…