KCSF Bud Green Ribbon

From Administrator role: Transactions -> Inventory -> Adjust Inventory Worksheet -> Import Or maybe try this https://system.na2.netsuite.com/pages/setup/sample_csv/InventoryWorksheet_Template.csv

Yes, you can create a CSV for importing using the Inventory Adjustment Worksheet. Importing inventory adjustments via the regular CSV import tool is on the release notes for 2016.2 as well. 

Create a new thread if you want help from user group but please make sure to read all help/support documentation as well. (And I'm not sure precisely what your question is but don't know that I can help if its related to SuiteCommerce or Site Builder)

Yes thank you I also didn't realize that these fields were being utilized. This is effective for my use case (so cases where you don't need to also bring in data about the customers that do have transactions, aka no join). Also, seems that $0 transactions don't trigger the any of those 'Date of Last/First...' fields to be…

Any reason you couldn't just use Maximum as summary for quantity?

If the custom date field is storing the values then joining to the Created From record should give you access to sales order sublist? 

Well I am only just learning about bin management - but for some reason on some items the Purchasing/Inventory -> Bin Numbers sublist is empty while the Inventory Detail sublist has values for specific bins. That specific bin correlates to what is on hand in the location and also to what is available when you go to fulfill…

Thanks... ya I was actually considering trying that, just making sure I wasn't overlooking some more obvious solution. Might try it with a closed PO to keep the transaction joins the same type of record, then criteria would be Open POs OR this one closed PO. I'm no expert on what is best for load time of report....will…

This search without the PO information brings 50 rows. When I add in the PO criteria it knocks it down to 26. Need the minimum to be that 50. So its still not showing items that have no open POs? No grouping on the results tab and I am showing 1 purchase order field on the results tab (transaction type). Thanks for your…

Yes, of course. Maybe I am not explaining correctly. I want the list to be ALL items and to bring in PO info for any items (but not limited to) that have an open PO.

Yes, agreed. Chromebooks are also what we use. Probably under $100 these days. 

As in right-justification on the search results? If its an integer or decimal field I think it should be doing that already? Ours appear to do that. I don't know if you can modify that via SQL functions or not. 

We do pretty much exactly this with web services for our production schedule. PM me and we can tell you more about it?

Need more detail to really suggest anything specific...but if you are changing values on sublist while editing a PO you are definitely in the scripting arena. Can't access sublists in workflows. 

What are you grouping by on the results tab? I don't think this will work for each row and also the grand total at the bottom. It does work for me for different groupings of the rows (say, by item or by document number, date). Depending on how you are trying to view the date, I bet you could group it by something that…

Yes of course, that won't work. Try a formula field with summary type of average (or I think Max, Min, Sum would do the same): SUM({amount})/SUM({quantity})

Kristin, Seems pretty straightforward so maybe I am missing something. If you have gotten to the Rate average (using the Average summary grouping), the Quantity should be able to be grouped using the same Average summary type. Be sure to set Main Line = False on your criteria. The result you are wanting is a list of Items,…

You might try to use the 'Location Available' field instead of 'Available'. (We renamed Locations to Warehouses so I use 'Warehouse Available' when necessary). I haven't looked at this in a while, so curious how you are getting the Kit available quantity? It was a little tricky before, so we use a formula field grouped by…

Jessie, I am curious, so it is forcing a manual check of the Drop Shipment box on item receipts? Our experience would show that Netsuite recognizes, at a line level, which items on that RA are drop shipped. Testing one just now, that box is actually read-only for us. I searched for any Item Receipts created from…

I don't know for sure if you mean Vendor RAs or customer RAs, but I can think of no clean way to do this for Customer RAs. Vendor RA probably is more reasonable, could just use criteria that the Custom Form for the Created From record is the drop ship PO form. For customer RAs, if you are OK with custom fields then I would…

Item search for kits only with formula (Numeric) of (NVL(TRUNC({memberitem.quantityavailable}/{memberquantity},0),0)) and Summary Type of Minimum, also result fields Grouped by Item and Grouped by Member Item:Inventory Location shows one row for each location and the number of kits available in that location. I can help…

Set up a saved search that uses a single Summary on the quantity field (using integer Formula field for {quantity} and probably Negate function as well if you want the fulfillments to show as positive numbers). If you were to view the results of that search it would just show a grand total of all of the quantities summed…

You might just boil it down to the accounting side - any time inventory moves it would be affecting an Other Current Asset account (or in our case it does). So use that account type as a criteria and then include any transactions that decrease inventory - for us that is Item Fulfillments and Assembly Builds. Then use…

If you still need this - here is what works for me: CASE WHEN {type} = 'Kit/Package' THEN (NVL(TRUNC({memberitem.locationquantityavailable}/{memberquantity},0),0))ELSE NVL({locationquantityavailable},0)END The key is to then add a Grouped field for 'Member Item: Inventory Location" and use Minimum summary type for the…

I've recently done this is as a sublist on our item records. The only criteria I used are Posting = T and Account Type = Other Current Asset. Then the subtab filters to that item and shows all inventory affecting transactions - summing to the current on hand amount. If you are not using a subtab/sublist, but just a saved…

When I try to set the SS to group by my custom field, I am getting an error: 'The result field BO Created From cannot be grouped. Please edit the search and omit this field or use a different summary function.' Main line = T. The field is a List/Record with List of Transaction. Sourcing fields are empty. I'll go ahead and…

Got it working, thanks for your help. I didn't know their was a field to set on that custom sublist, but that is what I was looking for. I'll take this one off the list. :)

Evan, I can use Sales Order as the available filter, but the only records being returned are Item Fulfillments. So, the Created From column just references the SO that the IF is created from. I would like to be able to see a list of Customer Deposits within an IF transaction record. Should your suggestion allow me to bring…

Based on you other post, it looks like you are trying to set a value on the item record based on what is entered on a PO? I am not an expert on how to most efficiently do this but if my first sentence is accurate then you would maybe create a beforeSubmit user event script and deploy it on purchase orders. The function…

Or mass update, depending on the scenario. CSV import is remarkably efficient in NS, IMO so that's probably best.