John Griffin Silver Trophy

Hi @Mikko De La Fuente-Oracle, I have a custom button that runs a script to extract information from the selected record. Currently, I have the information displayed on the screen via an alert. Is there a simple way via script to export this information in XML format and automatically print on a network printer? Thanks,…

@KNason76, I went back and tested this again and these steps will prepare the BOM records for deletion. CSV IMPORT FILE - blank column for BOM field NetSuite Import Template Settings After running this import, I was able to run the mass deletion tool on the associated BOM record to delete it. Please let me know if you want…

@KNason76, So you still need to delete a number of BOMs from your system with the mass deletion tool, but are not able to because they are still associated with Assemblies - correct?

Hi @KNason76, Please see the response below. Since you already have a BOM associated with the Assembly Item, you will need to overwrite the sublist data. The MASTER DEFAULT field cannot be updated via CSV after you have already associated the BOM. I also would not try to update both the MASTER DEFAULT and DEFAULT FOR…

Hi @KNason76 , I updated my original post in this thread to clarify the CSV import file set up. And to help anyone else in the future, including a link here to the other discussion that has complimentary information. John

Hi @KNason76, As @Ivy Lopez-Oracle mentions at the top of this thread, my comments in your original posting, https://community.oracle.com/netsuite/discussion/comment/16787745#, should have taken care of allowing you to delete the BOMs with Techfino's Deletion tool. Looking back over that post, I see that I could have been…

Hi @Janis001, In general, NetSuite allows you to convert Non-Inventory Items to Inventory Items. Otherwise, you cannot convert between these 6 types of Assembly and Inventory items; you will need to either create them with completely different numbers or rename the existing items so that you can then reuse their names to…

Hi @Rumaysa Mirza, You're welcome. John

@User_ML5H4, The only other thoughts I have are to verify that the Item Source on the BOM for components is set to STOCK and that the destination location's Supply Type is Purchase for the items transferring from another location. Maybe revisit the Supply Plan Definition to ensure all the appropriate Locations are…

Good luck Janis. Also keep in mind if you need Lot Numbered or Serialized Assemblies. John

@User_ML5H4, I am not certain that it will work, but the setup below solve the issue. The transfer from A to B uses the Planning Item Category from the Item's record, and the transfer from B to C uses the Item Number. In this scenario, Location C would be driving demand. I am using this approach for a similar setup and it…

Hi @User_ML5H4, Just to clarify; is any additional processing performed on Product 123 at Locations B & C that adds/changes its configuration? If so, does the Name/PN change? John

Please take a look at the attached and let me know if I can clear anything up. Also, note that when replacing an Inventory item with a new Assembly item, the historical data remains with the original item, so I usually add a note to to the Communication tab of both the new and old records pointing to each other to aid in…

How long has NetSuite been live? Do you have any transactions in NetSuite against the Inventory items that you sell and are going to make in house? This makes a difference in how you approach changing them to an Assembly item. For your last question, most likely you will create a BOM for each configuration. The overall…

Having only used Advanced BOM, I am not familiar with how the old "Legacy BOM" was set up or worked. My understanding is that the old way was not very robust. So it sounds as though you have items that are actually Assemblies set up as Inventory items? Approximately how many? If you want to set up an example Assembly item,…

Does the Manufacturing tab on your Assembly item look anything like the screenshot below?

Hi @User_6YI1X, Are there items on the SO that are unallocated/uncommitted in inventory? And is the SO location set up for the same location where the items are located? Since you were able to create and save the SO, I do not think Calculate Shipping is causing an issue. John

Hi @Janis001, Are you using Advanced Bill of Materials? John

I confirmed that the Warn and Block setting does not prevent a user from creating a duplicate Sales Order. At least on the first occurrence, the user is warned and must make a conscious decision to create a duplicate number, but note that the user has the option to select a checkbox to not show the warning again. For this…

Hi @HertsChris, From what I am seeing, the only sure way to avoid duplicate Sales Order numbers is to uncheck the Allow Override box. This SuiteAnswer below indicates that Sales Order transactions are not affected by the Warn and Block setting. I can try to confirm this in my system when I get a chance later if you want.…

Hi @User_MC441, Glad you were able to resolve the issue. Have a great day, John

Hi @HertsChris, Is the Allow Override checkbox checked or unchecked for Sales Order Documents? See screenshot below of Set Up Auto-Generated Numbers. Regards, John

Hi @ChrisH, Has the default transaction form been modified? John

Hi @User_MC441, From my experience, Negative adjustments via CSV must be done separately from positive adjustments and the template for negative adjustments must use the "Bin" field and not the "To Bins" field. Likewise, the "Issue Inventory Number" field must be used and not the "Receipt Inventory Number" field. I would…

Hi @Tom Dalton, I am not sure if you are using Advanced BOM or not, but I routinely import BOM Revisions using the components' itemid field (just named Item in the template below). When I run into this error, it is usually caused by the item not existing yet - since my data is coming from a separate PLM system, I have to…

Great! Glad it worked.

Hi @Dirk Nieuwkamp, Try clicking on the deployment you are showing, select Edit, verify your saved search is listed under the Parameters tab, set date and time to run under the Schedule tab, and then select Save and Execute. I included a screenshot of one of my deployments below for reference. Please let me know how you…

Hi @eleran, I have a number of items set up as EACH for Primary Stock Unit and PK10 for Purchase Units because one vendor sells and prices them in packs of 10. When creating a PO, PK10 and its pricing are the default. If I purchase from an alternate vendor who sells and prices the same item as EACH, I change the UOM and…

Hi @Dirk Nieuwkamp, I have successfully used this great mass deletion tool that is offered for free from Techfino. It will probably work for the records you want to delete. The NetSuite Bundle ID and a link to more info on the tool are directly below. Bundle # 251197 https://www.techfino.com/blog/netsuite-mass-delete-tool…

Hi @Mark Dotson, I believe you first need to go Manage Roles and for the roles in question see what Item forms they are assigned to use. Then go to Entry Form Customization to see if the Item360 subtab is enabled. If the screenshots below represent the general path to follow. Let me know if any thing needs clarification.…