Hi Liz, Glad to have you back and thank you for posting your concern here in the community! ? Please check the Shipping Item or Shipping Method that you are using on the Sales Order. If the Shipping Rate on the Shipping Item is set to By Item, then shipping cost in the Sales Order is computed based on the shipping cost on…

Hi Johnny, I got the below details in the Oracle NetSuite Support Community Inbox: Ivy That worked. Thank you very much. I am getting a warning message at the top of the page WARNING Please select an item type before enabling editing What does this mean? Thanks, Johnny Burch For future communication, it would be better to…

Hi there @Jjzwang, Glad to have you with us today and thanks for posting your question here in the community. @Camille Cagalingan-Oracle, need your expertise on this. ? To our members, feel free to share your thoughts regarding this.

Thanks Emi! Hi K, As documented in SuiteAnswers 9291, enabling the Per-Line Taxes on Transactions preference is required when you have a US Nexus. Please note that the preference will just give you an option to assign different tax codes on a per-line basis instead of only 1 tax code applied to the whole transaction. More…

Hi @User_2I30C, The List View has a sticky feature and the previous saved search used as View mode when pulling up the item list might have had an invalid formula or summary, hence the error message when trying to pull up the item list again. To be able to use the correct saved search when viewing the item list, you must…

Thanks Erick! Hi Bill, Is the Shipping Integration feature enabled on your account? The Schedule B Number, Schedule B Quantity and Schedule B Code are related to the Shipping Integration for International Shipping. In order to see the fields on the Item saved search, the Shipping Label Integration feature needs to be…

Hi @Sonics, I was not able to reproduce what you reported on my test account. The only time that the item with 'Needed Qty' = 0 appeared on the Saved Search was when there was no formula in the Criteria tab Summary subtab. Please ensure that the Saved Search has this: Formula: CASE WHEN ((SUM(CASE WHEN {status}='Planned'…

Hi @dbetlow, Glad to have you with us today and thanks for creating another thread in the community! ? If you are exporting the items via Saved Search, then this is currently the standard behavior of the system. I did find some enhancements related to this behavior and you can vote for these enhancements via the SuiteIdeas…

You're welcome, Paula! Once you enable the Demand Planning feature and have further questions and clarifications, feel free to create a new thread here and we'll be happy to help! ?

We are getting the Quantity On Order from the Item Record, so unless there are issues with the Quantity on the Item Record, it should show the correct values. Anyway, did you input the formula in the Criteria tab > Summary subtab? Let me try to reproduce this scenario on my end and I'll let you know my findings.

Thanks Pauline! Hi Paula, The Demand Planning feature is actually part of the Demand Planning Module, which is an Add-On module, so you need to contact your Account Manager to have it provisioned to your account. For the documentation, you can check the following SuiteAnswers articles: 28065 - Setting Up Advanced Inventory…

Hi Ruth @User_OPUDV, When you say "restrict inventory to certain locations", do you mean limiting the locations shown on the Location sublist under Purchasing/Inventory tab of the item record? If so, then this might fall under Enhancement # 361371 - Ability to associate Items to Location Records. You can vote for this by…

Hi David, Per checking, this is a system limitation which is currently logged in Enhancement # 67751. You can vote for this enhancement via the SuiteIdeas page. There is no documented workaround for this, so I'm reaching out to our community -- if anyone has come up with a possible alternate solution for this, you may…

As for your 2nd question: Also, I cannot figure out why work status has to be changed from planned to released in edit mode by way of manual selection after creating a work order. I checked my resources on the possible reason for this, but I was unable to find any documentation stating the reason behind this behavior. It…

Thank you for creating another thread here in our Community, @Amir Alinaghian-Oracle! To our members, we appreciate your input on this! ?

Hi @JCronin, I got the below details in the Oracle NetSuite Support Community Inbox: Confirming will not save on Inventory items and Assembly items. The note is in SuiteAnswers, it is not an error. Customer has 10 scripts and 32 WorkFlows on the Assembly/BOM record and does not have a Sandbox. I have read through all of…

Hi Martha! Regarding converting Serialized Items to Inventory Items, this 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 enhancement via the SuiteIdeas page. The workaround for this is to…

Hi Harry, apologies for the late revert on this. I tested this in my standard test account, but I am not able to reproduce the behavior that the Projected Value is changing upon save of the transaction. What I noted was that the Projected Value field on a work order completion displays the cost of the assembly, not…

Hi Sonics, I have tested this in my standard test account and here's what I came up with. You can create another transaction saved search and test if this will work for you: In the Criteria tab > Standard subtab: Note that the Use Expressions checkbox is marked and there are parenthesis used. Here are the formula used:…

You're welcome, Natalia! Let's wait if other members have found a workaround for this. Fingers crossed! ? Also, if you or the consultants manage to come up with the report, we would appreciate if you can share it here with the community. ?

Since this is a transaction saved search with Criteria = Status is Work Order:Planned, then when you click on the item, it will show the list of Planned Work Orders for the item. As for the detailed transactions of the back ordered quantity, this will not show in the Saved Search since we are only sourcing the data from…

Hi @JCronin, Thank you for posting your concern here in the community! Just to confirm -- the quantity pricing is not saved on Assembly Items and Inventory Items? Are there any scripts or workflows on the Assembly/Inventory Item record? Have you tried saving the Quantity Pricing on the Items with the scripts/workflows…

Hi Sarah! Usually, when there is quantity under the Inventory Detail tab, but is not reflected on the Location sublist of the item record or on the Inventory Valuation report, then there might be a location and lot number mismatch on the item. Here are some SuiteAnswers articles which may help you resolve your concern:…

The main difference of AIM and Demand Planning is: AIM uses Reorder Points and Preferred Stock levels to get the suggested quantity to be ordered on the Order Items page Demand Planning uses demand plan and supply plan records to track anticipated supply and demand Demand Planning is one of the pre-requisites to use the…

Hi Venkat, Usually, revaluation of inventory can be done by creating Inventory Adjustment Worksheet. This transaction allows users to set a new value while keeping the same quantity of the item. However, Inventory Adjustment Worksheets only support regular inventory items and does not yet support Lot Numbered or Serialized…

Seasonal Demand assumes that an item's demand fluctuates during specific times of the year thus, a flat historical calculation of demand is not accurate enough. So instead of looking at the last X number of months, NetSuite looks forward X months (a user-defined "season") from the current date in the previous year and…

Try adding these on the Criteria: Item : Is Phantom | is false Item : Preferred Vendor | is not -None- Let me know if this works for you or if there is anything else you need to add. ? ====================================== If you find this reply to your question as helpful, others with the same question might find it…

Hi Nairoff, Thank you for posting your concern here in the community! Tagging my colleague @Camille Cagalingan-Oracle as she is the expert on this topic. ? To other users who may have insights with regard to this, feel free to add your comments by replying to this thread.

Thanks Erick! Hi Natalia, I did some testing here to check if it is possible to customize the Inventory Valuation Report to show Inventory Status. Currently, this is not possible since Inventory Status is not an available field to be added in the Report Builder page. This system limitation is being tracked in Enhancement #…

Hi @Martha Hakes, Glad to have you back with us in the community and thanks for starting another discussion here! ? Just to give an insight on how the system works in tracking serialized inventory: When selling or fulfilling serialized items, users will be asked for the serial number on the posting sales transactions such…