Actually if you use fulfillments only as an invoice of an Inventory Item also would have a fulfillment. Are you looking to run the search for a single item at a time or get a list of items with all the sales? If 1 item at a time could do invoices where item="12345" OR Member item="12345" If trying to run a list of items,…

THANKS Alex! How about the results of '{locationquantityavailable}' (in single quotes) displaying as (nullif(round(itemlocationmap.ronhandavail/nvl(stockunit.mconversionrate,1),5),0)) Never seen that before. Hope all is well and thanks again.

Sorry, the original question was just about the kits. I was never able to get a single Search export to include both Kits and non-Kit items. We ran as 2 separate and fed them to amazon in seperate batches.

If you include {applyingtransaction} in the results, do any appear?

For some reason it will not let me view screen shots. Have you tried going into the formula builder and selecting the fields from there? Quantity Available was listed for me on the field selector as Available and Quantity Committed was just Committed.

You can calculate using saved search. We have multi-location and bins turned on so in the criteria we include only Member Item : Inventory Location = our primary warehouse. Group by Item Name/code of the kit. Then select Formula Numeric, summary type Minimum and use the formula:…

FLOOR((NVL({quantityavailable},0)-NVL({quantiycommitted},0))/{memberquantity}

We do this today for our kits and assemblies under a sublist tab on our inventory and assembly items as either can be a part of a kit. Criteria: Type=Kit/Package, Assembly/Bill of Materials Inactive=False Results: Name Display Name Type Member Item Member Item: Display Name Member Quantity Filters: Component Item with Show…

Really???? You may have just saved my sanity. Will try tomorrow. Thanks.

Setup -> Company -> Enable Features In Enable Features: Company tab, scroll down to "Data Management" First entry

Ours turned out to be a DKIM record we added to our MX records. NetSuite sends the emails as coming from my domain but their IP address of their servers does not refer to our domain so google rejected. We have temporarily removed the records.

Robert, Thanks VERY much!

Yes. When I select filter I receive only one record (correctly) as the example it only has had one price. Also added a filter for UPC code in place of alternate number and the same results happen. If I filter on UPC, the the correct result are returned but if I enter netsuite number the results are still doubled.

OK, So instead of looking at transactions and seeing what items are on it I decided to look at items and then to see what Sales Order transactions they had. Same exact results are happening. Criteria: Transaction: Type - Sales Order Transaction: Date - 9/1/2012 through 9/30/2012 Transaction: Status - Sales Orders: Billed…

Do the search over the sale and use amount fulfilled? When looking at fulfillments you are not really fulfilling the kit, but the members. The Sales Order lists what was sold (the kit) and should give you the expected results.

If looking for the number of line items, group on sales order, mainline no, taxline no, cogs line no and shipping line no. Create a formula(numeric) field with a formula of just "1" and use count on summary. If looking for total quantity, use above but substitute the quantity field for the formula and sum that.

My search that I use is with Main Line=No because we have different margin targets for different product line. Revenue is Amount Cost of goods is Est. Extended Cost Margin is a formula = ({amount}-{trancostestimate})/{amount}

Kelly, Sorry it took so long to reply. Was at RetailAnywhere training last week. Thanks so much for the solution. I had never used DeCode before. Now that I know what it can do I might be very dangerous now... My last problem may not be solvable. We have a significant number of drop ship items that do not show up on the…

Kelly, Awesome. Never noticed the Transactions... join or used it before. Giving it a shot now. Thanks VERY much for the example!

I am still recovering from the conference. Great time, great people and learned a lot. Cannot wait for suitecommerce... Ok, the GL entries are definitely going to cause a snag but first things first. It is my understanding that for inventory items the cost comes from the average cost value of an item. Cannot remember if…

What I would like is to have a summary level (lets say customer sales totals) drill down to a summary level of items sales dollars. Then the ability to drill into that.

So simple yet Brilliant.

This is perfect for Excel because of formulas (especially date formulas). Start by doing a saved search and I assume you are creating sales orders directly from NetSuite storefront or manually entered, so include the date value from the system notes which also includes the time stamp. On criteria, select System Notes :…

Yes, unfortunately if doing in a saved search you get different results than if you are starting with a "View". To replicate, try this. Go to: https://system.netsuite.com/app/accounting/transactions/transactionlist.nl?Transaction_TYPE=SalesOrd and click "Edit View" in bottom right.On the available filters tab, go and add…

To see if an item is a matrix child, you can use the parent field on results. If not empty it is a child matrix item. Do not know how to designate parent.

We have a saved search giving us the top items over the last month. The user does have the ability to change the date range as well as sort by quantity or dollars. Criteria: Type is Sales Order Date is within previous one month Main Line is false Status is none of Sales Order:Cancelled, Sales Order:Closed Shipping Line is…

Rafe, Actually I believe they only DO go to admins. I just asked a couple of users who get production emails if they receive any with Beta in the subject and they said no. Also I receive them to my email and they have the original users name in the subject. Now if you are creating emails based upon a script and not just…

I created a custom field on the item record called Purchase Unit Divisor and then in my saved search results use a CASE statement. CASE WHEN {custitem_purch_unit_divisor} IS NULL THEN 1 ELSE {custitem_purch_unit_divisor} END) Every night I have a saved search alert the item team when they have entered an item with Units…

Interesting... I just tried to change my search to use your code. If I have a Formula(Numeric) of COALESCE(TO_NUMBER(REGEXP_SUBSTR({purchaseunit},'[[:digit:]]+')),1) it returns either 1 or the number just as you state. Now if I want to get a "cost per each" and just divide the purchase price by the above formula I get a…

I tried yours and got an error but got me close. {lineid} was invalid for me but this worked: Formula (Text) Count CONCAT({internalid}, {line}) Glad I followed this thread...