John Griffin Silver Trophy

Hi @Marie4455, I recommend checking out TechFino's Mass deletion script ( Bundle ID 251197). I have used it on several types of records with great success. Additional info is available at the link below. https://www.techfino.com/blog/netsuite-mass-delete-tool Hope this helps, John

Hi @Vismay Barot, This is not a limitation when using Advanced Bill of Materials. You would need to transition away from the Legacy Bill of Materials to accomplish what you are trying to do. You can vote for enhancement 61460, but it has been around for 12 years with only 30 votes, so I would not look for any movement on…

Are you using Advanced BOM or Legacy BOM? John

Is this Serialized Assembly Item inactive? If you have multiple subsidiaries, is it authorized in this subsidiary? These are the only two things that immediately come to mind. John

Hi @Vismay Barot, Yes, a non-serialized Assembly BOM may contain both serialized and non-serialized assembly and inventory items. John

Hi @Adam W, Are you using Advanced BOM? If so, I use a search to export the BOM Revsion detail and can share the set up if that helps you out. John

Hi @knlekash, Just a thought, but try using one or the other of Internal or External item id, but not both. Happy New Year! John

Hi @User_A6I53, The accounting periods may not have been set up yet. In the screenshot below clicking on Manage Accounting Periods displays the existing accounting periods and gives an option to set up additional periods. Happy New Year! John

Hi @Vishnu M, Here is an Excel example using the VLOOKUP function to look for BINs from the BINs list to see if they exist in the BIN ON Hand list. Let me know if I need to provide any clarification. John

Hi Andrea, Did you get a chance to see if an income account is specified for these items? John

Here are the steps to extract the needed information from NetSuite. Navigate to Bins and select the icon to export the results to Excel. You may need to create a custom view to add the Inactive Field so any inactive Bins can be excluded from the comparison in Excel. Create an Item Search and export the results to Excel Let…

Hi @Vishnu M, I do not know of a single search to accomplish this. You will probably need to export a list of the active BINs to Excel and compare that to the exported results from a search that contains all BINs with a quantity on hand. I can provide more detail if you want or need it. John

I think the last comment/question is the most probable. I should have looked earlier, but here is SuiteAnswers ID that addresses this. https://suiteanswers.custhelp.com/app/answers/detail/a_id/68444/loc/en_US John

Also, is the Income Account specified under the non-inventory item's Accounting tab? John

A couple more thoughts: Is yours a One World Account with multiple subsidiaries? If so, are these items authorized in the sales order's subsidiary? Under the the non-inventory items' Preference tab, what is the status of the Can be fulfilled/received checkbox? I do not think this is a factor, but just curious since…

Are you receiving an error message when trying to add the non-inventory items to the sales order, or are they just not presented as an option? John

Hi @Rizwan_MRK, I recommend checking out TechFino's Mass deletion script ( Bundle ID 251197). I have used it on several types of records with great success. Additional info is available at the link below. https://www.techfino.com/blog/netsuite-mass-delete-tool Good luck, John

Hi @Andrea Barattini, I have not had a problem adding Non-Inventory items on a sales order, regardless of what other items are on it. Just a thought; are your subtypes for these items either For Sale or For Resale? John

Hi @User_OGQAD, Purchasing/Inventory > Location > Bin Numbers is the only place I know of to designate the preferred BIN of an item. The check box, Preferred (per Location), is available for CSV import, so mass updating the preferred BIN for items is possible. Hope this helps, John

Hi @Nickey, Below are screenshots of a search I use, that may get you started. John

Hi @User_S6FVQ, From a purchase order, select Customize at the upper right of the page and then Customize Form. This will present a page showing which form and templates are being used for that PO. On another tab navigate to Customization>Forms>Transaction Forms to find the form (most likely it will be marked as the…

Hi @User_4XNM2, From the item page (Lists>Accounting>Items) go to the Sales/Pricing tab and then edit the Price Levels sublist. John

Hi @KNason76, I have done this on select customers' item fulfillments and I think it should be the same. If you cannot disable the higher level setting, you probably need to remove the email address from the PO either manually or via workflow. John

The answer below was in response to a question by @User_BCZRO that was split out by @Tris Mendoza-Oracle to the link below. https://community.oracle.com/netsuite/english/discussion/comment/16875777#Comment_16875777 Hi @User_BCZRO, If you are using Advanced Bill of Materials that utilizes BOM Revisions (as opposed to Legacy…

Hi @Drewmich, If you have another administrator, they will need to use the User Access Reset tool to RESET 2FA SETTINGS for your email address. Someone with core administrator privileges may also be able to reset it. Aside from that, unless you saved backup codes when you set up 2FA, you will probably need to contact…

Hi @KNason76, I have not had time to work on this and my shipping department continues to create the CofC outside of NS. I am thinking along the same line as you describe. Or just incorporating the CofC statement into the existing packing slip, since most customers will accept that in lieu of a separate document. Now that…

Hi @Meherin, I believe this is controlled under Setup>Accounting>Accounting Preferences>General, under the Classifications banner. The mandatory setting is system wide and cannot be changed to non-mandatory only on the inventory adjustment form. Hope this helps, John

Hi @User_I4Z2V, On Import Assistant step 2, select OVERWRITE SUBLISTS so your new data completely replaces the existing sublist data. Make sure you are selecting only the records and sublist you want to update. If you have not performed this type of update before, try it on a couple of records first, or better yet in your…

Hi @Rebecca Carter, Have you tried using {item.locationquantityonorder}, {item.locationquantityonhand}{item.locationquantityavailable}? John

Hi @Angelica Mae Segador-Oracle, Yes, the latest suggestion is a viable alternative, had one of the address fields not worked in setting up the condition otherwise. John