John Griffin Silver Trophy

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

Hi @Wee Ming, "Have you tried using this saved search condition trigger on After Record Submit and Event Type as Create ? I have used SS condition for newly created records before and the trigger on need to be after record submit." That makes sense; I will keep that in mind the next time I use a SS condition. Thank you for…

Hi @Wee Ming, The Transfer Order is using the standard Ship To addressee field, although it is not a stored address and is entered from the custom option of the drop down list. I revised the formula to use {shipaddressee} which also evaluated to FALSE. I went back to the Condition Visual Builder to go through the available…

Hi @User_VZ83X, It will help in troubleshooting if you can provide examples of your templates and field mapping. The information below may be helpful. Inventory Adjust Multiple File Set UP When dealing with files containing SN/Inv Number data, positive and negative adjustments must be imported separately and correctly…

Hi @Wee Ming, Since this was not among the formulas I already used, I tried the formula, INSTR(NVL({addressee},0),'Transf')=0, which also evaluates to FALSE. Thank you for your suggestion and please let me know if you think of anything else. John

Hi @Angelica Mae Segador-Oracle, I am trying to set the value of a transfer order’s custom body field with specific text when the transfer order addressee is a specific entity. As a higher level check, without the condition, the workflow will update the custom field on any transfer order that is created or edited. With the…

Hi @katherine_15328, Within website setup there is a checkbox to show the cookie consent banner. When checked, the banner is displayed at the top of the landing page and covers the Login and Register buttons until clicked to close the banner. The only control you have over this function is to display it or not. John

Hi @User_Z8QTG, You need to edit the employee record of the employee that left to free up the license. On the Access tab of the employee record, remove the check from the Give Access box. You may then check this box on the other employee's record. John

@Nickey, I do not have an answer. Our use case is mainly to facilitate return and repair of product, without processing a CM. We just close the RMA and ship the customer owned product back out on a $0 SO. John

@Nickey, I believe the register is a running record that is not cleared. Only the status is updated to Closed. John

Hi @Nickey, From your description, it appears the CM was created outside of the RMA. From within the RMA record there is a refund button that creates the associated CM. Alternatively, you can just close the RMA. Hope that helps, John

@User_EIUIZ, The custom template does not; only the standard template. John