Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @YYF, I tested this out in my standard test account, but I was unable to get it to work for the kit items. Upon further checking, I noted that this may currently be a system limitation. I found Enhancement # 29512 - User would like the cost of an item to populate to the screen when entering member items into kits, and…

Hi @Liz Madrid, I created a new thread about your new concern. Please note that best practice is to create a new thread for a new question. This is so other members who might have the same concern can easily find the thread. For this new question about a report for customer name and class name, I have coordinated this with…

Hi @Ancana, Upon checking our resources regarding this, I noted that this is not yet possible in the system. There is an existing enhancement requesting for this functionality: Enhancement # 144538 - Transactions>line items>requesting the ability to add Move Up/Move Down buttons to arrange order of items on a Transaction…

You're welcome, Liz! I'm glad we were able to make it work! ?

To resolve this, please add an Expense account to the field mapping. It should now look like this: I tested this on my standard test account and noted that system allows creating Non Inventory Items for Resale even if the expense and income accounts are blank. There will be a pop up message that says: "You must specify…

Can you show the error message in the screenshot please? ? You can adjust the width of the column in excel to show the error message.

Can you click the CSV Response link please? It should download a file which will show why it did not import successfully.

Hi Liz, Please make sure to check the following: 1. Use the correct Internal ID 2. Use the correct item type in the Import Assistant 3. Ensure that the import was successful by going to Setup > Import/Export > View CSV Import Status. It should look like this: ====================================== If you find this reply to…

Hi Liz, You can select the account directly from the Import Assistant. You can refer to steps 3-5 I mentioned in my previous comment. ====================================== 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 this…

Thanks Shamie! Hi @Liz Madrid, Here's how you can update the income account of the items via CSV Import: 1. Create your CSV File with at least the Internal ID of the items you will update 2. On Step 2 of the Import Assistant, make sure you select Update, then click Next 3. On the Field Mapping, add the Income Account…

Hi @User_QTNHA, First of all, welcome to the community! ? Glad to have you with us today! Let me tag our gurus with the expertise on this topic. @Emilia Ironov-Oracle and @Micah Timbol-Oracle, any ideas regarding this? To our other members, feel free to comment your insights on this thread!

Hi Lina, Glad to have you back with us today! Are you experiencing this only in the NetSuite Support Community website? If possible, please send a screenshot of the pop up message you received. Anyone else experiencing this behavior?

Thanks Jeff! Hi @Ancana, Converting Inventory Items to Non-Inventory Items is not yet possible in the system. The ability to change Item Type (except non-inventory->inventory, which is supported) is logged in Enhancement # 88100. You can vote for this enhancement via the SuiteIdeas page. The workaround for this is to set…

Hi Jenny, Currently, changing COGS and Asset Account in Transactions is not yet possible in the system. The standard behavior is that the COGS and Asset accounts used in transactions are those set on the item record. Since the account is linked to the item, it will be used to post the COGS and Asset accounts accordingly…

You're very much welcome! ?

Hi @katherine_15328, Glad to have you back with us today and thank you for posting your concern here in the community! The error might be because the ELSE value is a numeric and you are using a Formula (Text) field. To fix this, use a Formula (Numeric) field and use this formula: CASE WHEN {name} = '12333' THEN 25 ELSE…

Hi Dung Le, It is true that multi-level joining fields in saved searches is not yet supported by the system. There is an enhancement logged for this system limitation and you can vote for it in the SuiteIdeas page: Enhancement # 125071 - Saved Search: Support multiple levels of Join or Sub-queries What I can suggest for…

Hi Paul, Thank you for creating another thread here in our community! ? Allow me to test on my end if this is possible in a saved search. May I also know what type of saved search you are currently using?

Hi Lily, Thanks for providing the additional information! Allow me to tag our SCA Guru, @Jeff Pineda-Oracle, who will further assist you with your concern. To our other members, feel free to share your ideas about this one.

Hi Lily, How are you? Glad to have you with us today! ? Can you check on the item record on what field the "associated image" is in? I checked on my standard test account and the only fields I was able to find was the Store Display Image and the Image URL. Per checking, these fields are related to the ITEM DISPLAY IMAGE…

Hi Dung Le, May we know what exact information from the item record you would like to get?

Hi Ted, thanks for providing the additional information! Allow me to tag my colleague @Camille Cagalingan-Oracle who has expertise regarding taxes. Any ideas regarding this, Camille? ?

Hello @tbstout2, Glad to have you back with us today and thank you for posting your concern here in the community! ? What item type are you using for the Consumables (for resale and not resale)? There is actually a Taxable checkbox in the Item Record > Accounting tab > Tax/Tariff section. If this checkbox is marked, the…

Hi @MJ NCO, Thank you for posting your concern here in the community! May I ask if this is only happening to a specific user or are multiple users affected? Usually we would advise clearing browser cache, incognito mode, trying different browsers or devices since these are the common troubleshooting steps. However, since…

Hi @AJDavies, Glad to have you back with us today and thank you for posting your concern here in the community! Allow me to tag my colleague @Camille Cagalingan-Oracle who has the expertise in this topic. To other members in the community, feel free to comment your ideas/suggestions that might help on this concern.

Hi @dle_35705, Glad to have you with us today and thank you for posting your concern in the community! I agree with Pierre's comment. The Criteria should be Main Line = False in order to display the details of the line items in a saved search. As also mentioned, you can add the following criteria to filter out the non-item…

Hi @User_BLJ1M, Welcome to the community! Thank you for posting your concern here. ? Let me tag my colleague, @Michelle Jabanes-Oracle , who has the expertise in this area. She will further assist you with this one. To our community members, please feel free to comment your ideas and suggestions about this.

Hi @User_5EJ2T, Welcome to the community! Thank you for posting your concern here. ? Converting Inventory Items to Lot Numbered Inventory Items is not yet possible in the system. The ability to change Item Type (except non-inventory->inventory, which is now supported) is logged in Enhancement # 88100. You can vote for this…

Hi @Johnny Cash, I tested this on my end, and I found that you can use the Inventory Detail saved search to show the information you require. To create the saved search: 1. Go to Lists > Search > Saved Searches > New 2. Select Inventory Detail 3. On the Criteria tab, add your required filters. Mine was simple and looked…

Hi @Sonics, I think that in this particular search, we won't be able to get the quantity on the main line of the Work Order since one of the Criteria we have is Main Line = False. Note that if you set the status of that Work Order to Released, then the quantity on the main line should reflect as Qty On Order on the Item…