Yes we have read through those but unfortunately the folks we are dealing with have not dealt with NetSuite

My name is Sean. * Located in Arizona * I have been working in NetSuite for 5 years as a User, and for 3 years as a full-time developer * ERP, OneWorld, focusing on SuiteScript customizations, Suitelets for advanced reporting * I love mountain biking, rock-climbing, and NetSuite! Sean, Where in Arizona? I am in Phoenix…

Just saw this so sorry I am late to the party... I am located in a little town called Apache Junction, Arizona which is 40 miles from Phoenix. I currently am just a Senior NetSuite admin but came from the consulting side of the fence after doing 18 implementations. Mostly ERP, Analytics (Power BI/Satori Reporting), Demand…

Thank you for your post @"JCirocco", and welcome to the new community! Appreciate your participation on the old user group and happy to have you join us here. I never realized how much effort goes into making homemade bacon, but done right, it can be a real treat. Here's the Canadian version: 1 gallon water 1 1/2 cups…

My apologies, I saw Inventory Count, but my brain saw Inventory Worksheet...

I know this is not a NetSuite solution but if you have no other options, you could have each person key the data into Excel docs, merge the data and do a CSV import.

Debbie, Fulfillments (And Receipts and Transfer Orders) are strange in that they return 3 lines PER line on a sales order. 1) Is for the join back to the SO and gives the proper Qty 2) Is the line that represents the Credit to the Inventory Asset account(based on the GL setup on the item record) 3) Is the line that…

Forgot to Mention if you want the sales amount, you need to use the Account = NULL as those are the Fulfillment Lines that join back to the sales order Here is the criteria to get Empty Account Here is a screen shot of my test search for the Applied to fields for results

To filter just to the COGS account in a fulfillment search, you can use the "Account fields.." Join and use Type = Cost of Goods FYI - If you want to get the selling price from the sales order, you can use the Applied To fields... Join and get Item Rate or Amount for the revenue

Make sure you filter the lines to his your COGS account only (there are normally 3 lines for each Sales Order Line) then your "value" is the Amount (Debit).

If you are referring to the "General Ledger" report, I believe that you do not have access to that field because the line being reported is the SUM of the lines on that transaction for that account. 

Instead of using the Custom Field, your search can use the formula to retrieve the same value which can also be used to calculate the Amount unbilled Unreceived quantity = {quantity}-nvl({quantityshiprecv}, 0) Amount Unbilled = ({quantity}-nvl({quantityshiprecv}, 0)) * {rate}

OK, I think I may have figured it out but would like confirmation as I cannot find this in SuiteAnswers. In order for an item to be available through the Customer Center: 1) The Display in Webstore box must be checked 2) The item must have a price for the Price Level the Customer has assigned

Kenny, Yes (see the last part of my comment above - "I seem to remember that you need to update with 1 component first with the Clear Sublists set to yes, then add the rest of the components with Clear Sublist=No") If you import with Clear Sublists=Yes, then for every line in the CSV it clears, so line 2 clears the line…

I know I answered this in the old forums but cannot find the thread here At one of my old customers, we did this with a Custom Record and scripting If I recall, the custom record was similar to: Vendor ID (because we purchased the same item from multiple vendors and they did not all give qty breaks) Item Break Qty Unit…

Correct, you would need a scheduled workflow then to store the value in another field (unstored fields ARE available in workflows) if you want to do any manipulation

Not sure if you are using the fields on the Location Record for "Make Inventory Available" or "Make Inventory Available in Web Store" If you are (for instance using "Make Inventory Available in Web Store") Create a custom item field for available using an item search Criteria: Inventory Location : Make Inventory Available…

Rachel, Is this created from a sales order? If yes, Is the sales order the same? Also, both fields are available for input. Is a user enters a rate and ALSO an amount, then they would see this warning: If they click OK, then you will get the miss matched values

One option is to set the Obsolete Date field on the components. Not sure if this applies to Advanced BOMs) If they were created incorrectly and just want to "fix", you can do a CSV import and use the CSV Import Advanced Option to Clear Sublists. Try in your sandbox OR if you do not have a sandbox, create a new "test"…

Well, If 1 requirement was to NOT create inventory, then no, it would not accrue quantities.

If you will not be using these items in a BOM/Assembly, just make them Non-Inventory Items for Purchase so you can add them to a PO.

Yes, @"michoel" has a great one for seeing the data on forms (in place of doing &xml=T) called netsuite-field-explorer And @davidsmith Has the Script export as well as a great one calls Show Field IDs where you can search a form for either a field ID or a field label and it will find anywhere on a form even if you are not…

Yes, definitely. If you use chrome, definitely check out the chrome plugin called "NetSuite Saved Search Code Export". You can create the search (using you and/or logic), save and run to verify what you created. Then go back to edit mode and there will be an "Export to Script" link in the top right. It will pop up a window…

GreaseMonkey is the one we used when I was at a previous company and even created something similar to the reconcile bank statement WAY before Netsuite had a suiteapp.

There is also a non-netsuite way if that is not possible. Check out the plug ins (depends on browser) GreaseMonkey and TamperMonkey

When using the Administrator role (and other highly privileged roles) , that person needs to log in with the Admin role and go to the settings portlet on the home page and use the option "Manage Access Tokens"

Yes. You would need to create a saved item search that will retrieve only the 15 items. Then on the Customize form page, under Sublist Fields, select the saved search in the Item Filter drop down.

One item with different units of measure.

Martha, We have a customized Inventory Activity report we use when this happens. Almost ALWAYS, it is a rogue Inventory Adjustment to add items back into inventory when A) the quantity On Hand was zero and B) The Inventory Adjustment did not have a Value for the adjustment. Just customize the Inventory Activity Detail and…

Here is what we do (works for us...) We have a custom item field for Case UPC code so we can report that to the customers on ASNs and Invoices. We have a workflow that will populate a custom transaction line field with the proper UPC. If the selling Unit of measure is Case, then we populate the custom Case UPC, If the…