Hi @dle_35705, Glad to have you with us today and thank you for posting your concern here in the community! ? Let me tag our guru with expertise on this topic, @Jeff Pineda-Oracle, so that he can work with you on this concern. To our other community members, feel free to comment your ideas or suggestions on this thread.

Hello @jmack_admin, Glad to have you with us today and thank you for posting your concern here in the community! ? I have already coordinated your concern to our gurus who specialize on this topic, @Pauline Joy Cac-Oracle and @Jack Daryl O Espiel-Oracle and they will get back to you for any updates or if additional…

Hi @User_KVW5F, Welcome to the community! ? Glad to have you with us today and thank you for posting your concern here! I have already coordinated your concern to our guru who specialize on this topic, @Shamaine Chan-Oracle and she will get back to you for any updates or if additional information is needed. In the…

Hi Chris, Thank you for clarifying the needed results. To achieve this, you can use a Formula (Currency) field instead with the formula:{inventorydetail.quantity}*{rate} then just set the custom label to Amount. Let me know if this works for you. ? ====================================== If you find this reply to your…

Hi @PaulFleetwood, Thank you for posting your concern in our community! I have already coordinated this with gurus who specialize in Workflows, @Jack Daryl O Espiel-Oracle and @Pauline Joy Cac-Oracle. Please allow them some time to check on this and they will get back to you for updates or if any additional information is…

Hi @PaulFleetwood, Glad to have you back with us today and thank you for creating another thread in the community! ? Kindly allow our gurus who specialize on workflows to check on this first and they'll get back to you with updates or if they need further information. Hi @Pauline Joy Cac-Oracle and @Jack Daryl O…

Hi Chris, Have you tried adding a summary type to the results? This way the duplicates can be grouped together.

Hi Dallas, I checked on it but it seems that it is not yet possible to do both in the system. I found Enhancement # 256617 which is requesting for the ability to set Fixed Lot Size even if the Lot Sizing Method is Periods of Supply. Apologies for the inconvenience this limitation may be causing you, but I hope this…

Thanks Micah! Hi @Dallas H, Have you tried changing the Lot Sizing Method of the item record to Periods of Supply? You can then set the following fields: Periods of Supply Type = Interval Periods of Supply Increment = 90 When you select Periods of Supply as the Lot Sizing Method, the Supply Plan would generate aggregated…

Thanks Emi! Hi Chris, I tried this as well on my standard test account and I was able to reproduce the same behavior. I even tried using the Transaction Serial/Lot Numbers field, but the results were the same. Upon further checking, I found out that the reason for this is because on the Item Receipt, the Lot Number is…

Hi @ssilveri777, Glad to have you with us today and thank you for posting your concern here in the community! ? I have coordinated this with @Shamaine Chan-Oracle, our guru who specializes on this topic as she will be checking on this and will reply to the thread for any updates or should additional details be needed. To…

Hi Liz, Thanks for creating another thread here! ? Glad that you were able to figure it out! Let us know if in case you need further assistance with this. Have a great day! -Ivy

Thanks for clarifying that, KF! For COL1, you can use a Formula (Numeric) field with the formula: CASE WHEN {inventorylocation} = 'Location Name' THEN (NVL({locationquantityonhand},'0')) ELSE 0 END Then for COL2, you can reverse the logic of the formula and make it so that the main WH will show 0 while the other locations…

Hi KF, Have you tried adding Inventory Location as a Criteria in your saved search? Once you add the criteria, the results will show only the specific location you select in the criteria. ==================== If you find the reply to your question as helpful, others with the same question might find it helpful as well. By…

You're welcome, @rburns515! ?

You're welcome, Dung Le! Glad I was able to help out! ?

Hi Johnny, You can check the following SuiteAnswers articles: 70289 - Inventory Balance Search 70290 - Inventory Detail Search 8467 - Creating Saved Searches for Bin Numbers To further illustrate where these searches are used, let's refer to the Inventory Detail tab of the Item Record: Each of the subtabs on this tab uses…

Hi @rburns515, NetSuite has an Inventory Count feature which allows users to enter regular periodic counts of on-hand item quantities to maintain inventory accuracy. (See SuiteAnswers 28061 - Setting Up Inventory Count) To use this feature, first define the Next Count Date and your intended Count Interval in days on an…

Hi @Kenny Wise, You can change the Default Item Fulfillment Stage by going to Setup > Accounting > Shipping: Hope this helps! ? ====================================== 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 answer…

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!