John Griffin Silver Trophy

@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.…

Within Template Setup you are actually changing the Title field and saving it.

No, one save from within Change ID, one save from within Template Setup, and a final Save As for the entire template form. As long as the last save is a Save As, your original form is safe. The first two saves for Change ID and Template Setup are not committed until you save the entire form. Hope that clears up the…

This worked for me, I had to essentially perform a save 3 times; from within Change ID, from within Template Setup, and then to save the main form using Save As. This created a new copy and left the old intact, without receiving any alerts about overwriting the file. I am not sure why it is not working for you. John

Did you get the alert when trying to Save As in the last step?

@Janis001, From your original custom form, try clicking on the Change ID button and change the ID first. Then click on the Template Setup button and change the template name. And then choose Save As. John

Good afternoon, This appears to be a program glitch. The Save As function appears to be retaining the existing Form ID and does not allow you to change the Form ID during the Save As. John

Hi Keith Boatner, I do not know that it is the best approach, but I chose to name the BOMs the same as their associated Assembly Items and restricting the BOM to the Assembly; maintaining a one-to-one relationship. In global search, this show up as: The BOM Revisions are named A, B, C, etc... This might give you an idea…

Good luck Eklon. John

Glad you may be able to use the tool, Eklon. I am not familiar enough with Asset records to offer more specific advice. However, I usually approach this type of mass manipulation by breaking out a few records to test the entire process before committing to the entire population. And even then it may be prudent to process…

Hi @Eklon Eleuterio, I am aware of a great mass deletion tool that is offered for free from Techfino. I have not used it for the same purpose as your inquiry, but it may be just what you are looking for. The NetSuite Bundle Id and a link to more info on the tool are directly below. Bundle # 251197 Hope this helps, John