Ivy Lopez-Oracle NSC Guru

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…

Hi there Paul! For your 1st question about excluding specific locations, are you referring to Auto Calculate Re-order Point And Preferred Stock Levels, as documented in SuiteAnswers 73031? Per checking my resources, I noted that it is currently not possible to exclude specific locations. This is a system limitation and is…

Under the Criteria Tab Summary subtab, add: Summary Type = Sum Field = Formula (Numeric) Description = is 1 Formula = CASE WHEN ((SUM({quantity})+MAX(NVL({item.locationquantitybackordered},0)))-(MAX(NVL({item.locationquantityavailable},0))+MAX(NVL({item.locationquantityonorder},0)))) > 0 THEN 1 ELSE 0 END Let me know if…

Hi Roberto, I understand that you are creating a transaction saved search for Inventory Adjustments and need the Location of the transaction to show as the result. You mentioned that you used a joining field for this. Is this field called "Fulfilling/Receiving Transaction : Location"? Please note that this joining field is…

Here are the added/modified formula on the Results tab: Qty Backordered: MAX(NVL({item.locationquantitybackordered},0)) Needed Qty: case when ((SUM({quantity})+MAX(NVL({item.locationquantitybackordered},0)))-(MAX(NVL({item.locationquantityavailable},0))+MAX(NVL({item.locationquantityonorder},0)))) > 0 THEN…

Glad that we're on the right track! ? Here are the columns you can add to the Results tab of the search: For the Item Display Name and Item Type, you can find this in the Item Fields joining field on the drop down. Again, here's the formula I added/changed: Qty On Order: MAX(NVL({item.locationquantityonorder},0)) Needed…