KCSF Bud

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

in Opening Balance of Item Inventory Comment by KCSF Bud Sep 19, 2016 12:16PM

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.

in Opening Balance of Item Inventory Comment by KCSF Bud Sep 16, 2016 1:03PM

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)

in Opening Balance of Item Inventory Comment by KCSF Bud Sep 19, 2016 7:21PM

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…

in Customers with no sales Comment by KCSF Bud Jan 16, 2019 9:46AM

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

in Filter transaction search to only display max value Comment by KCSF Bud Jun 21, 2018 1:34PM

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

in Saved Search from Item Fulfillments does not pull sublist values from Sales Order Comment by KCSF Bud Aug 27, 2018 3:21PM

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…

in Transaction Search - Bin on Hand Comment by KCSF Bud Jun 19, 2018 2:50PM

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…

in Item - Transaction joins Comment by KCSF Bud Oct 9, 2017 12:44PM

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…

in Item - Transaction joins Comment by KCSF Bud Oct 6, 2017 2:50PM

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.

in Item - Transaction joins Comment by KCSF Bud Oct 9, 2017 11:58AM

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

in Display Saved Search results on Warehouse TVs Comment by KCSF Bud Nov 4, 2016 2:53PM

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.

in Set Field Value for Item Search Result Comment by KCSF Bud Oct 28, 2016 9:17AM

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

in Display Saved Search results on Warehouse TVs Comment by KCSF Bud Nov 4, 2016 1:03PM

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.

in Set Field Value for Item Search Result Comment by KCSF Bud Oct 25, 2016 11:20AM

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…

in Trying to get to the average selling price on sales orders on a saved Search Comment by KCSF Bud Feb 23, 2017 3:21PM

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})

in Trying to get to the average selling price on sales orders on a saved Search Comment by KCSF Bud Jul 24, 2016 10:15PM

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,…

in Trying to get to the average selling price on sales orders on a saved Search Comment by KCSF Bud Jul 21, 2016 6:33PM

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…

in Saved search for Kit/Package Availability per location Comment by KCSF Bud Oct 23, 2015 12:00AM

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…

in Return Authorization - Drop Ship check box Comment by KCSF Bud Nov 27, 2015 3:23PM

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…

in Return Authorization - Drop Ship check box Comment by KCSF Bud Nov 25, 2015 11:33AM

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…

in Saved search for Kit/Package Availability per location Comment by KCSF Bud Feb 22, 2016 11:51AM

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…

in All of an item sold by Month Comment by KCSF Bud Nov 10, 2015 7:28AM

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…

in All of an item sold by Month Comment by KCSF Bud Oct 23, 2015 12:19AM

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…

in No visibility to number of "Kits" available. Comment by KCSF Bud Oct 23, 2015 12:53AM

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…

in Actual stock impact Comment by KCSF Bud Feb 25, 2014 11:32PM

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…

in Sublist filtered by custom field Comment by KCSF Bud Feb 24, 2014 2:24PM

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

in Saved search within Item Fulfillment Comment by KCSF Bud May 7, 2013 3:36PM

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…

in Saved search within Item Fulfillment Comment by KCSF Bud May 7, 2013 3:11PM

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…

in Set Field Value for a custom field Comment by KCSF Bud Oct 25, 2016 1:02PM

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

in Set Field Value for a custom field Comment by KCSF Bud Oct 25, 2016 11:12AM

KCSF Bud Green Ribbon

Comments