Hi @"Mat O2F"! Welcome back to the community! Let me check on this one as to the possible rootcause for these. Just to confirm, you are pertaining to the restock column as indicated per component of the kit right? May I know if the Advanced Bin Management has been enabled in your end? @"Herdi Rana-Oracle"

Shout out to @"coffeeguy" and @"markival"'s suggestions! The formula of @"markival" may actually be applicable in your end! I applied his formula for the following scenarios: Item 1Item 3Item 2Item 4Preferred Stock1111On Order1200Available0002Back Ordered1110 Upon applying his formula, the results are as follows: @"Herdi…

@"ksage", I found this SuiteAnswer that may be helpful. This is actually a saved search that recreates the Reallocate items page: Recreate Reallocate Items Page via Transaction Saved Search to Add More Fieldshttps://netsuite.custhelp.com/app/answers/detail/a_id/62611/kw/62611 I think you are pretty much spot on by…

Hi @"3963645" There are isolated instances wherein the balances in the Item records shows negative quantities (e.g. commitment and available) in which should not be the case. You are correct that, usually, these are caused by numerous editing of transactions as well as deleted transactions involved, causing the balances to…

Hi @"Kenny Wise", Let me check on this one for the possible reasons a specific work order is not showing in the tablet. On top of my head the filters set in the table (e.g. Start Production date, end production date, etc) may contribute to this behavior @"Herdi Rana-Oracle"

Glad to be of help @"Dallas H" @"Herdi Rana-Oracle"

Upon checking on our end, the ability to have a report or saved search in the core/standard functionality of NetSuite is still an enhancement. Note that changes of Quantity on Hand and the quantity available of the items is not being stored in any record which is why we cannot pull this information through a saved search.…

Just a quick verification @"Jay Schwausch", I noted that the label of your formula is Recommended Quantity to Order. So I assumed that the following are expected to be seen: * Available > Preferred Stock: value of the formula should be 0 * Available + On Order > Preferred Stock: value should be 0 * (Available + On Order) >…

Hi @"raymondand4", I was able to reproduce the same behavior on my end. Basically, the formula(numeric) cannot be exposed under the Available Filters tab > Show in Filter. Just as I've thought, the ability to add formula (numeric) as a filter is still an enhancement. This is logged under request 218066 Saved Search >…

Hi @"Christophe Tiers", Welcome to the community! Let us test/research on this matter and we will be providing our insights on this thread @"Herdi Rana-Oracle"

Hi @"raymondand4"! Based on my understanding, you would like to have your formula (numeric) to be available as your filter in the saved search. As far as I've known, this is still an enhancement. Nonetheless, let me double check on this one and see if this is possible @"Herdi Rana-Oracle"

Hi @"blink182", Welcome to NetSuite User Group! Can you confirm which specific item fields are you trying to pull out in your saved search? For instance, in the item record, the Primary Information pertains to all of these fields: Does the Product Shipping information pertain to these fields? @"Herdi Rana-Oracle"

Meherin, can you expound more why are you fulfilling the order from a location with no available quantity? The reason why it does not have a gl impact is because there are no on hand for the said location/subsidiary (hence 0 average cost as well for the item). The functionality of the Cross-subsidiary fulfillment is that…

I actually came up with the similar way to filter out the transactions with Ship to Complete = T and all of the lines are committed. Since you are filtering out all lines committed in an order (instead of a per line), You are correct to use the Summary criteria of the saved search.Thanks for sharing your testing! I…

Shout out to @"JohnCirocco"! Thanks for your input! Hey @"Kenny Wise"! John's input is actually valuable, you can set a obsolete date field so that once the transaction reaches the obsolete date, the new set of BOM will be used in your manufacturing transactions. If you opt to just completely remove the said component,…

Hi @"Meherin", Here are some points that you may want to check with regards to the non-posting of the Item Fulfillment: 1. Item shipped is a non-inventory item. 2. Item Fulfillment was created form a drop shipped order. 3. Inventory item was sold under water or has a negative inventory or zero/negative Average cost is…

Hi @"katherine_15328"! I am still checking on this one You are correct that Basic Demand Planning will only consider on a per location basis. Although there is also a Distribution Resource Planning (DRP) feature inclusive in the Demand Planning Module that would take into consideration the demand needs across all locations…

Hi @"Aaron Pelz", @"JohnCirocco"'s input is really valuable! As an additional information by the way, you may refer to this SuiteAnswer article that may also be helpful in your end Non-Inventory Items @"Herdi Rana-Oracle"

Hi @"carlyn", We apologize for the inconvenience this is currently causing you. Currently, the issue field for this 599185 was escalated to the highest level and we understand this is a very critical defect. Once you submit a case, Support will provide you updates about this defect. @"Herdi Rana-Oracle"

Basically, the following features would drive what items will be available in the page: * Assembly Items * Inventory * Serialized Inventory * Lot tracking So for instance, if Serialized Inventory item is not enabled, the said item type will not be available in the page. Of course this would also man that the said item type…

I have tested and double checked this one. Sorry, I was thinking of the manual source for the landed cost . You are correct with regards to the allocation of the landed cost with the source Other Transaction (hence directly linking the specific bill to the item receipt). This is still indeed an enhancement. Let us cast our…

Hi @"Kenny Wise"! If you are utilizing the basic assembly setup (meaning, Advanced Bill of Materials is not enabled), you may do this by Item Saved Search: * Navigate to Lists > Search > Saved Searches * Select Item * Under the Criteria tab, select the following: You may add other parameters to limit your search (e.g. to…

Hi @"jenluna" Just to confirm my understanding, you would like to associate one bill to multiple Item Receipts. So for instance, IR 1, IR 2 and IR 3 will all have Bill A as its landed cost am I correct? If this is the case, I believe this can actually be done. Allow me to test this first to provide you a detailed insight .…

Upon checking, the ability to restrict or to set specific permission per item type (instead of the generic Item permission) is still an enhancement. This is logged under Enhancement 137948 Add permissions for item type under the Items tab. Because of this limitation, the New Items page would show all of the item types…

Hi @"jenluna"! Let me check this on me end On top of my head, this page is driven by the feature enabled in the account, not necessarily by the roles/permissions granted to the user. I will be double checking on my end if this can be restricted based on the users' permissions @"Herdi Rana-Oracle"

Hi @"PaulFleetwood" Welcome back to the community! Let me check on this one on my end. Other users may also jump in the thread and share your thoughts! @"Herdi Rana-Oracle"

Here's what I did to reproduce the said behavior. I created a Work Order with an Item source of Purchase Order for its component. This generated a PO with the a quantity of 10, I changed this to only . I then received the said PO, for only 2 quantities: If I receive the remaining quantities in the PO, this will be…

Hi @"Rose D"! This is an interesting use case! Let me test this one out and see if this is possible in the core/standard design of NetSuite. Other users who have an idea on this matter? Let us know your thoughts! @"Herdi Rana-Oracle"

May I know if the record you are pertaining to is the Manufacturing Routing in the Netsuite instance? Or are you pertaining to the AM Workbench provided by the Advanced Manufacturing bundle? If you are referring to the Native Manufacturing Routing as seen in Lists > Supply Chain > Manufacturing routing, then the import…

Hi @"AJDavies"! Let me try the same scenario on my end. On top of, since the Item Source is Purchase Order, the commitment will be directly tied up with that of the Purchase Order quantity/received. I'll double check the behavior on my test account @"Herdi Rana-Oracle"