Hi @"Jay Schwausch", I would suggest an Item Search for this: 1. Lists > Search > Saved Searches > New > Item. 2. Criteria tab: * Type | Assembly/Bill of Materials * Is Serialized Item | Yes 3. Under the Results tab, you may choose which fields you want to pull up. Commonly they would be the item name, description,…

Hi @"Martha Hakes", May I know how this search is returning incorrect data? Which field in the Results tab? @"Ina Pablo-Oracle"

Hi @"Wahabt", To be able to search for items even if only a partial UPC Code is entered, navigate to Home > Set Preferences > Analytics tab, set Popup Search Uses Keywords = False and Save. Enter the first part of the UPC code for this to work. Let me know how this works! @"Ina Pablo-Oracle"

Hi @"3967101". The usual reason for bin and location quantity mismatches is when the Use Bins preference is turned on and off in between posting transactions (you can check this in the System Notes/Information tab on the Item Record). This means that there are instances when inventory-deducting transactions were pulled…

Hello K @"3968939", Reorder Point is the stock level at which a new order for the item needs to be placed, or build more of this item. While the Preferred Stock Level is his is the optimum quantity to maintain in stock of an item. The ideal quantity is the amount you need to fulfill orders in a timely manner without either…

Hey there @"lilywu", After further checking, I found Enhancement #197145 Transactions > Inventory > Bill Of Materials Inquiry > ability to enter a quantity and have a 'forecast' of quantities just like when entering a work order. that addresses your question. You may go ahead and vote for this enhancement in SuiteIdeas.…

Hi @"Aya Ito", For cancelling shipments - if you're using shipping integration - you may call the carrier to cancel the tracking number. Then you may go ahead and remove the tracking number in the Item Fulfillment and set the status back to Picked. If you have to “unpick” or cancel the picking of the items, you must edit…

Hi @"lisaham", Can you compare in your Sandbox and Production environments if the ADVANCED BIN/NUMBERED INVENTORY MANAGEMENT feature is enabled? (Setup > Company > Enable Features > Items & Inventory > Inventory) The Use Bins checkbox is shown in environments that have this feature turned on. Thanks! @"Ina Pablo-Oracle"

Hi @"Martha Hakes", May I know what type of item this is? @"Ina Pablo-Oracle"

Hi @"3968939", There is a data type discrepancy on the expected return values of the formula. I noticed on your condition that on the first value: (CASE WHEN {parent} is null THEN '' else '0' END), the expected returned value is a text value while on the second value: {quantityavailable}, the expected returned value is…

Hi @"tsheetz", The only way of transferring in/out of bins is manually (as already discussed by Jack, auto-bin transfer is still an Enhancement). I would advise filing a case to Support especially if all or most of your inventory items are affected. Even though the turning off and on of bins is a usual case for customers,…

Hi @"PaulFleetwood", You can sell or display your items at different prices to different customers in your website. You could use this to offer lower prices to repeat customers, for example. With Multiple Pricing enabled: • Custom prices autofill for transactions. • You can set higher margin pricing for cash sale…

Hi @"golfergav", Can you try the following: 1. Navigate to Lists > Search > Saved Searches > New 2. Select Transaction 3. On the Criteria tab, set the following filters: * Type = Sales Order * Main Line = False * Tax Line = False * Shipping Line = False * Status = Sales Order;Partially Fulfilled, Sales Order:Pending…

Hi @"golfergav", For my reference, what would then be the Status of the Item Fulfillment that needs to be considered in the service level? @"Ina Pablo-Oracle"

Hi @"George Williams"! If you have verified that no Sales Orders (in the Reallocate Items page) or Work Orders are causing the backorder quantities for this item, I would suggest creating a case to Support because there are some instances that the backend tool failed to run the necessary tests or updates for this item.…

Hi @"cgieselman"! The ability to show the quantities from an assembly build is not possible to be shown on the Inventory Turnover report. There is an enhancement request filed for this to become available in the future. There is no workaround for this. Per my understanding, I think this is the rationale behind this: Take…

Glad to help!

Hey there @"Nikolay Georgiev", For Seasonal Analysis Interval, the computation will be based from last year and the months moving forward. For example, the computation was made on 10/11/2019, and the Seasonal Analysis Interval was set to 3 months, it would start computation from 10/11/2019 and consider the months of…

Hi @"farrago", This capability is not yet possible. It's still covered by Enhancement #64307: Matrix item creation for Kit/Package and Item group is not available. This option should be available for all item types. In addition, upon checking, no alternate solution is available for this too. You may use the SuiteIdeas page…

Hi @"katherine_15328"! May I know what's selected under your Fulfillment Preferences? Please go to Setup > Accounting > Accounting Preferences > Order Management tab > Fulfillment Section > Fulfill Based on Commitment.

Under the Criteria tab of your search, can you try adding the following: Fulfilling/Receiving Transaction...fields> Status : is Picked Combining with Erick's suggested search, your Criteria tab should now have the following fields: Let me know if I missed anything. @"Ina Pablo-Oracle"

Would you prefer that upon creation of the IF, the status would be defaulted Shipped? If that's the case, you can always modify the Item Fulfillment default status by going to Setup > Accounting > Shipping > Default Item Fulfillment Stage. Selecting the Shipped as the default status will combine the Picked, Packed, and…

Hi @"HighCom David"! Can you try the following: Under Results tab of your Transaction Search > Columns subtab, insert: * Field: Formula (Currency) * Summary Type: Maximum * Formula: {item.pricelevelX} * Custom Label: enter the name of the price level ** Where X is the internal id of the Price Level. Let me know how this…

Hi @"Marvhoah", It's the standard behavior that when you create an Inventory Count where Count Bins with Zero Quantity = T, the count will include the bins that were once associated to the item and were used in transactions - even if the bins are not associated to the item anymore. If you're not using the non-associated…

I agree with enabling the preference Global Search Auto Suggest too. (Home > Set Preferences > Analytics tab > Search section) Provided that this preference is not enabled, for us to be able to search Names with ampersand, we have to add at least one quotation mark (") in the beginning or end of the Name that we type in…

Hi @"lisaham", Setting up Phantom Items in NetSuite requires the enabling of the features Assembly Items and Work Orders: Setup > Company > Setup Tasks > Enable Features (as an Administrator), > Items & Inventory and then check the following boxes: * Assembly Items * Work Orders After they are enabled, phantom assembly…

Hi @"Kenny Wise", If what you want to see in the item report are the values of your inventory - based on transactions per subsidiary - the Inventory Valuation report would be best for this. 1. Go to Reports > Inventory/Items > Inventory Valuation. 2. On the Footer section of the report, you have the option to filter your…

I agree with Chris on this. A saved search is usually an alternative or a way to work around the limitations for NetSuite Reports. Refer below for a saved search you can create to show the lot quantities for a specific date: 1. Navigate to Lists > Search > Saved Searches > New > Transactions 2. On the Criteria tab >…

Hi @"slamm", Just a slight modification to Erick's search parameters: To specifically send the alert to the Sales Rep in your S/O - instead of adding their names one by one in the Recipients tab - you could start by adding the field Sales Rep in your Results tab. Then under the Email tab > Recipient from Results subtab >…

You are correct. The only difference is with how your company uses the discussed item types. In general, these items use Expense/Income accounts and that they can all be fulfilled or received (under the Preferences tab on the Item Record > Can Be Fulfilled/Received checkbox) @"Ina Pablo-Oracle"