John Griffin Silver Trophy

Hi @User_HRB8G, Yes, you can import new BOM Revision records as shown below. Header (Primary)File Setup CompDetail(Linked) File Setup Import Assistant Setup You may want to use the internal IDs of your Bill of Materials and Bill of Materials Revision instead of BOM Name and Revision Name in your import templates and file…

Glad it got you headed in the right direction. John

Not at all intuitive - opposite of normal file save conventions. Glad to help out. John

Hi @PeteLawson, You need to change the SEARCH TITLE before selecting Save As. This assigns a new ID to the new search, leaving the original in tact. John

Hi @Dext3r, I would start with including both Main Line and Tax Line equal to "is false" in the selection criteria. Hope that helps some. John

Hi @Tiffany Haslerud, I use a Bill of Materials Revision saved search for this, set up as shown below. Without any additional filters set, the search should return the current revision for all of your assemblies and their components, which can then be exported. Hope this helps. Let me know if any clarification is need. John

Hi @User_WWNS5, This discussion may help you. John

Hi @User_RWSI5, You should find what you need at Setup/Company/Auto-Generated Numbers. John

@User_6YI1X, Glad you found the information helpful. John

Hi @User_6YI1X, This sounds like a use case for Outsourced Manufacturing. The discussion below may be beneficial to you. Please let us know if you have additional questions. John

Hi Fabs, Glad you were able to resolve the issue. Best Regards, John

Hi @BM136, Check in Set up/Accounting/Set Up Shipping to see if UPS is set as your Default Shipping Carrier. If so, temporarily change it to FedEx and those options should be available for selection. Best Regards, John

Hi @User_D4XL9, My first thought, is that there may be a date issue. I would compare the work order dates and the BOM/Revision dates to ensure the new serialized assembly is in effect. John

Hi @User_D4XL9, My experience is that you must use multiple files to perform CSV Imports of Serial/Lot Number detail. Here is my documentation of how this is performed using 3 CSV files. Note that positive and negative adjustments must be performed separately. Please let me know if any clarification is needed. John

Hi @User_HWW8S, This should be on the Linked Forms tab when customizing the sales order form. John

Good to hear you got it worked out! John

Hi @User_IQB52, If you have not already done so, you can look to see if it is somehow allocated to something else. Transactions/Order Management/Reallocate Items. John

Glad it worked out Rick. John

As a point of interest... I made no changes to my files or mapping and re-ran the same test I did last week and everything imported as expected. John

Good luck! John

Hi @Dext3r, Just a couple of thoughts on this. Within the Item records, do you have a Preferred Vendor indicated? This may help some by limiting the planning function suggestions to the Preferred Vendors on the first pass. I do not know if a third party application is available for NetSuite, but some type of EDI set up…

Hi @Amberleask, The address should be pulling from the Addresses Tab under Setup/Company/Company Information. John

Hi @JoshPNW, Here is a simple CSV Import that works for this. As you mentioned, auto calculate must not be checked. Also, if you have lot or serial numbered items, they will need to be imported separately with the appropriate item type. Let me know if you need more detail. John

The supporting documents are file attachements In this scenario, only the top level assembly item is listed. John

@Dext3r, If you already have a standard PO form and PDF template for Inventory Items, they will work for an Assembly Item you are purchasing complete, with the vendor supplying its components. That is assuming you do not need to show the component detail, which is not required from a system standpoint unless you are…

Hi @Dext3r, Are you simply purchasing a complete assembly from a vendor, or are you supplying some or all of the components to the vendor for an outsourced assembly build? John

Hi @Joy Noreen Magoling-Oracle, Can someone confirm that we should be able to import multiple BOM Revision records; either creating new revisions or replacing the existing component sublist? I am fairly certain the templates I have used for some time, successfully performed in the past. At this time, my templates will…

Hi @Rick Cobb_2, Thank you for sending the file and field mapping screenshots in response to my PM. I do not see an issue with your set up, so I performed some testing on my end and found that the templates I have used for years do not work when importing multiple BOM Rev records. They work fine with one record, but only…

Hi @User_IOZ5E, You should be able to change this by navigating to Set up / Accounting / Shipping and then modifying the Reference fields on the Preferences tab. Best Regards, John

I may have added confusion in my initial answer, where I erroneously said "To Bins", but immediately went back in and edited it to "Bins." I thought I caught it soon enough, but you probably already received an email notification. I probably should have annotated what was edited... John