My Stuff
Hello Community! Josh Maxwell, a User Experience Researcher for NetSuite Foundation has fun a question for you. Imagine for a moment that NetSuite had an assistant like Alexa or Siri. What would you ask of your NetSuite assistant? Use this survey link to share your top questions to the assistant.
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Comments
-
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. 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