Hi @User_CTUW2, I think the Internal ID is taking precedence over the External ID and since the new records do not have an Internal ID, they are getting lumped together. If you have assigned External IDs to the existing records, I would try mapping only the External ID field. Alternatively, I would map only the PO # field.…

Sam, Addressing the lack of an item revision level was one of the first customizations we made at NetSuite implementation. We created a Custom Item Field that is populated with the current revision of all Inventory and Assembly items. The custom field was then added to all transaction form templates. When we have a…

Hi @Dext3r, I may be off base here, but your description leads me to believe you are processing the purchase of the assembly item via Outsourced Manufacturing, which unless you are having outside operations performed on components you are providing the vendor, is not needed. I would check the state of the ALLOW PURCHASE OF…

Great! Glad we found a solution. John

Brian, Have you tried using only 1 import file? Realizing I cannot see this set up in my system, it seems that since you are not trying to create new member items, the optional file is not needed. Are you able to map column Y in your primary file, that contains the existing member item, to the member item field? John

Brian, I do not have a way to check this, but SuiteAnswer #68142 may be of help. While it is discussing replacing components, at step 8 you can select Add instead of update and ignore steps 9 and 10. The subsequent steps concerning file set up and mapping should be the same for adding or updating.…

I almost asked that question first in my original comment and after seeing your files they did not appear consistent with Advanced BOM. I do not have experience with Legacy BOM and do not have any suggestions as to the action you should take to resolve this issue. My apologies if I have wasted your time. John

Brian, are you using Advanced BOM, that utilizes a BOM and BOM Revisions? (As opposed to Legacy BOM).

Hi @Brian Finlay, Can you share screenshots of your import templates and your import mapping? Are you trying to associate a common BOM/BOM Revision to multiple Assemblies? If so, check that the BOM is set to Available for all assemblies. If you are associating individual BOMs with each Assembly Item, having the same single…

Hi @User_M4JOC, Are you attempting to import the BOM and the BOM Revision at the same time? Although this can be accomplished, over time, I have found using a two step approach works well. I import the BOM, associating it with the Assembly first and then import the BOM Revision, associating it with the BOM. Can you share…

Hi @ImeldaSanchez, You should see this under Billing Information. John

The path is Set UP>Company>Locations, which presents the list of locations to choose to edit.

Hi @Jason_W, The USE BINS feature is also controlled at the location level. It sounds as though your production inventory locations have their USE BINS checkbox checked. Hope it is that simple for you. John

Hi @Rhys Gottwald, As a point of reference, I tested this with a non-admin role in my system and did not have to switch to the Outsource PO form to be able to save the PO. I looked around some and there is nothing obvious to change that would control the behavior you are seeing. John

Hi @ Rhys Gottwald, Even though NetSuite displays the warning, You have selected an outsourcing vendor. In order to use outsourced manufacturing you need to switch to an outsourcing form," you are able to keep the default form and proceed with a non-outsourced purchase. John

Hi @User_EPWHS, The first question to answer is whether or not you want to continue to stock the individual parts or not. If yes, it is best to create separate work orders that will run concurrently. The machine run times are not an issue, but you would need to either reduce each routings set up time by half or take the…

Hi @Alejandro G, I believe the best way to bring your system back to the pre-transaction state is to deleted the adjustment transactions in the reverse order of how they were originally entered. John

Hi @Alejandro G, The first screenshot is for the negative adjustment and the second is for the positive adjustment. If you have a mixture of Lot/Serial items and non-Lot/Serial items, Enter NULL in the Lot/Serial field of the non-Lot/Serial items. If you are not dealing with any Lot/Serial items, you can remove those…

Hi @Alejandro G, While you are awaiting @Niks Blando-Oracle's response, here is more information that may help you with setting up the templates for CSV Inventory Adjustments. When dealing with files containing SN/Inv Number data, positive and negative adjustments must be imported separately and correctly mapped to the…

Hi @User_YRQLO, I believe this is still a system limitation and I have utilized a pair of inventory adjustment CSV import transactions to first remove the items from the existing BIN and then add them to the new BIN. This could also be accomplished by temporarily transferring the items via CSV import to another Location…

I would try removing access from all 3 ex-employees, if not already done. Then go to Set Up>Company>Billable Components and on the Billable Components tab, for Full Licensed Users, see if the Provisioning History and Component Usage quantities look correct. John

Hi @kkuhn, In edit mode from the Access tab within Manage Users, you should be able to uncheck the Give Access checkbox for one of the ex-employees and then edit/check the Give Access box on the new employee record. John

Hi @Navaran Ali, Please take a look at the discussion below that shows the set up for importing BOM Revisions having multiple components.. It utilizes two import files linked by a common "BOM Name" field. Please let me know if that does not answer your question. John

Hi @User_TXI1Z, The inventory adjustment in step 2 is a positive adjustment of quantity 2 that only increases the Location On Hand quantity. The inventory adjustment in step 4 is a negative adjustment of quantity 2, removing the quantity from both Location and Bin on hand quantities. Here are a couple more discussions that…

Hi @User_TXI1Z, On the item record, uncheck USE BINS and save the record. Then inventory adjust in a quantity of 2 of the item. Next, check USE BINS on the item record and save the record. Lastly, inventory adjust out the quantity of 2 using the Bin and Inventory numbers. That should take care of it. John

Hi @Vernita, Do any work orders exist for the Assembly that did use this Revision? Are there any planning records for the Assembly? Just some thoughts, John

Hi @Vernita, I really do not believe you need a routing. I think the absence of start and end dates is causing the error, in that the planning function does not know when to expect the supply. If you create the outsourced purchase order and allow the system to create the associated work order, the dates you enter on the PO…

Hi @Andrew Altringer, From what I have seen, the MRP module correctly plans across the Outsourced locations provided the Outsourced Manufacturing module is set up correctly, with a separate Inventory Location for each Outsource Vendor, the Replenishment Method and Planning Item Category fields set on the item records of…

Hi @Wellyntong, Try Primary Units Type. John

Hi @Vernita, Can you also post screenshots of the work order's Outsourcing tab and the shampoo bottle's, item record's Inventory Management data? I am not sure if it is just these examples, but the PO and WO do not have their outsource manufacturing location and production start and end date fields populated. Has this been…