Item code / Name = Item Item description = Memo or Item Fields -> Description Sales Order number = Number

Those other type of transaction fields have been there for some time I believe. The name of the fields you need are dependant on the type of search you are running. What type are you using? Transaction, Item, Customer, something else? I would go with a Transaction search in this case, in which case your field names are…

Well, you'll need a saved search showing Invoices, Cash Sales and Sales Orders. In results, you can simply sum Quantity Committed - that ought to give you your values On Order. Foir items sold, it gets a bit tricker. You can't simply sum Quantity, because you don't want to grab the quantity from SOs. So what you need to do…

Nope, that's (another) one of those highly annoying things with reports. You can't get internal ID on there. If you really wanted, you could create a custom field and put a small script on your transactions to have the script write the internal id upon saving into the field. The custom field would then be available in…

You could create a Saved Search that looks at item System Notes to spot the price change, displaying before and after. The one (massive) flaw here is that ONLY base price is recorded. Other price level changes do not log any system notes.

For Transaction searches, you need to specify Main Line = True, otherwise you get 1 line of result per line item on a transaction.

thanks Oliver. Is there a list of explanations in help for every choice in the 'Criteria' and the 'Results' Tab?? Do you know the link? I don't believe there is any explanation. Most of the firls are straightforward - they are fields that appear on the records, so you just specify the value you'd like. A few fields are…

We ran afoul of this as well. Netsuite Support's answer was to create the search using a user that did not have Show Internal ID ticked in...

You can't make a Report but you can make Saved Searches.

I can help you with a scripting solution if you want to give me a call (I'm actually installing such a script as I type this). Actually, for a saved search, I think I'm wrong. I think I said the same thing yesterday and I verified, and couldn't do it. So I don't think that's a solution, sorry.

Hmm... I think "Formula (Numeric) is greater than 0 {quantity}-{quantityshiprecv}" will not be true if there is no quantityshiprecv at all, as that value will be blank, not 0. So x - blank is not greater than 0. Add a 'Or' clause to catch "{quantityshiprecv} is empty"

Hi, I tried playing a little with this. Unfortunatly I don't have time today to follow through to the end, but here's what I did find - You have a big problem with this sarch in that you want to see customers who DID NOT buy something. If they did not buy something, then there will not be a line of result for them... so…

You can achieve this using scripting, basically showing on the Kit record the Profitability of the item (profit/costs). I think you might be able to achieve this with a saved search, too, though for sure a saved search will not work with sub-kits.

You are correct. But try putting some filter on the Quantity Remaining, or Quantity Shipped columns, etc. The status may be misleading, but if Quantity Shipped = Quantity, then you'll know this line item was fully shipped.

While on a PC you simply have to double-click the .iqy file to get it to run in your Excel, on a Mac you must first open Excel, and then manually import your .iqy file. To import your Web Query, go to: Data->Get External Data->Run Saved Query, selecting you .iqy file. Should run just fine after that.

Err... I didn't need to use any special ODBC driver - it just sorta worked.

Hi, Yeah, I know what NS means by the solution below, but it's just not enough information. What we need, really, is the info that's on the "Reallocate Items" screen. On that screen, if you were to select a member item of a kit, you would see all the SOs where the parent kit is being sold and thus the member part is…

Well I imagine you could achieve this using the Netsuite Deferred Revenue functionality. Alternatively you could have a custom functionality that automatically creates the journals (would probably be much, much cheaper than buying the deferred revenue module in this case). Plan C is to do your Journals manually.

You are correct, the formula field only allows you to perform a calculation on 2 columns of your report, not constants or other such values. The only way to get what you want, other than switching to a Saved Search, would be to add a custom field on your records, and source it on the report.

Created From seems to really not work very well. I've noticed that if you have, say, a Fulfullment that does not fulfill ALL of the items from an SO, the Created From returns blank. Also, for some reason, when using a Search to list all transactions and the associated Created From, a result is returned for every line item…

Actually, there has been improvement. You can now access joins called "Billing Transaction..." as well as "Fulfilling/Receiving Transaction...", and you still have good old "Created From..." With some thought and lots of trial and error, you can get a pretty decent lifecycle Saved Search.

Sales Order- qty billed, qty fulfilled that includes the invoice and fulfillment numbers? Yeah, I'd see it as being grouped by SO, and then you see a list of fulfilments and invoices that were applied to this SO. I don't really care about quantities at this point, just what transactions are linked to the SO in question.

nlapiSearchRecord doe not, by itself, email anything out, even if you have a mailing schedule defined on the UI search definition. Thus, if you script a solution, you would need to use nlapiSendEmail to email your CSV results. Since you have to code this, you can code it to email out whenever and however you want.

Does my solution above not work in this case? Is it because you must upload the file on the vendor's server? You coul still use Saved Search emailing to have the CSVs dropped in your inbox every monday morning, then upload them on the server. You will need full-blown integration if you want to skip the manual upload to the…

You could do it just with a Search. On the Email tab, just schedule the results to be emailed out at whatever frequency you want. Results will be attached as a CSV.

No, this is not supported by NetSuite. It may be possible to some degree with customization (scripting).

Here is a bit of code showing how to seperate the SN from the bin: <#assign serialNumbers = "" /> <#list item.inventorydetail?split('<br />') as y> <#assign serialNumbers = serialNumbers + y?split(',')[0] /><#if y_has_next><#assign serialNumbers = serialNumbers + "," /></#if></#list> <p>Serial Numbers: ${serialNumbers}</p>…

No, it is not possible. It is possible with some fairly extensive customization.

Hmm. I would say using different Locations, but that might not work very well given your synch situation. Otherwise... might be tricky. You'd have to use scripting on order to flip the "Commit quantity" to false when the script detects you've busted the allow commitments. But I see a lot of difficulties doing this. My mind…

In this situation you would need to delete the Item Receipt. If you cannot or do not want to outright delete it, create an separate Inventory Adjustment to take the item out of stock.