I'm sure there's an enhancement request. In the mean time you can create a saved item search with no criteria, results of Name Member Item:Name Member Quantity and a footer filter of Member Item:Name

From the SO you can get fulfillment COGS: {fulfillingtransaction.cogsamount} invoice amount: {billingtransaction.amount}

Very possible. Since you are new let's get you off on the right foot... don't even start with reports; go straight to saved searches. You'll want a transaction search, with type = sales order, status = all open SO types, etc etc.

Hey John - If I'm understanding this right, since the number of 'Main lines' equals the number of packages, then you could just sum the main lines. In other words, remove the package count from the summary and count only number of main lines. If that doesn't work you could add a formula column CASE WHEN {*package count*} >…

I've had that happen too. I can usually work around it by removing all filters, saving, re-adding the filters, and then check the 'Show in Footer' box for each.

I think this makes sense... when main line = true, that means that it's not a line from the order, its the order itself; and then if you set criteria of Item=DVD-MR-Raiders, you will get no results. I would try Type is Cash Sale Item is DVD-MR-Raiders Date is within 1/1/2011 and 7/15/2011 and then note what apapia says…

Use a text formula like this: CASE WHEN {quantityavailable} IS NULL THEN "Available to Order" ELSE CASE WHEN {quantityavailable} > 0 THEN "In Stock" ELSE "Available to Order" END END And this might work (not sure how NULL is handled): CASE WHEN {quantityavailable} > 0 THEN "In Stock" ELSE "Available to Order" END

If you have a possibility of null, then you need to set your condition for 'IS NULL' CASE WHEN {divisor} IS NULL THEN 1 ELSE {divisor} END

I set the 'function' to 'round' and this is what I see Date Percent 7/16 96 7/17 94 7/18 95 Total 95.23809523809524 The 'function' doesn't round 'summaries' for me

As our old IT contractor said, "Could you just not do that?" :) Sounds like a bug to me, as a work around: on the search result, what if you replace the Customer Name with a formula. The formula would strip out the non-alpha character(s), or maybe the formula could prepend a blank space. Then use this formula to 'Sort By'.

We have the same problem. I remember reading in another thread that rounding summaries is not possible.

This started happening to me today, it's a saved search that was working fine for months and now it sends duplicates. I inspected the email headers and both emails have the same data, except for receiving ip address and time stamps off by 1 second. There are no "specific recipients" on my saved search, only "recipients…

You might want to look into both Kits and Groups. [HR][/HR][h=1]Kit/Package Items[/h] Kits or packages let you create individually-sold items that are collected from other items. To learn more, see Groups, Assemblies and Kit/Packages. You can add description, inventory, non-inventory, other charge, service, kit, gift…

It sounds like you are entering Sales Orders through a transaction form in the UI... if so, a simple method would be to add a short client script to the form to automatically select the location per line.

What step in your process is cumbersome? And are you using the standard Drop Shipping in NetSuite?

I thought about getting a printer with email-to-print functionality (for example HP ePrint), and have a script send to the printer address. Never got around to building it though.

I add the estimated weight (in lbs) to Sales Orders via custom fields and script [LIST] [*]custom transaction body field {custbodyestimated_weight} [*]custom transaction column field {custcol_item_weight}, sourced from the item weight [*]custom transaction column field {custcolitem_weight_unit}, sourced from the item…

We are doing exactly this (except with some scripts on a VM monitoring the email and spooling it to the printers). If you are interested I am happy to share more details. We're implementing a custom, paperless pick ticket this year. Thanks for the info though.

I would reach out to a developer (there are lots here or you can find them online) and see if there's something already built that you can use/customize.

That's pretty much what Lot Numbers are for, differentiating inventory. But since you are using the same Lot Number, you are essentially telling NetSuite that they are indistinguishable. The only option I can think of is to create a custom Item Number field (a custom field on the Lot Number record) that subdivides or…

I have many custom fields in my Transfer Orders and most show on the form, but for some reason you cannot customize the Columns on the form! The fields that do show are are 'Free Form Text', 'Decimal Number', 'Date'. But it appears that 'Text Area' will not show. What type of field are you trying to add? Can you change it…

I've run into quantity discrepancies between bins, locations, and many times. It is usually one of these situations: [LIST] [*]A record was deleted that caused a negative quantity (most common). For example, an inventory adjustment of is made to add stock, then a fulfillment depletes the stock. Then the inventory…

Not sure about how to do this with SQL but with scripting it's pretty straightforward. JS has a built-in day of the week function, and there are lots of examples online like this.

It would take a bit of work, but you could create a button to launch a script to build an xml page, then convert to pdf using nlapiXMLToPDF

Not sure if there's a simple setting to do it, but you could create a saved search or script to send an email alert whenever a new message is created, and filter it to be for transaction type = item fulfillment.

This would be a very straightforward script. Create a custom checkbox field on customer record. Then create a user event script on invoice records, type=create, aftersubmit. The script would lookup the customer value, and if it's checked, then close the so.

You're welcome... you will want to read up on user event scripts here. And you can get a list of functions here.

Ideally you could add a checkbox on the TO item receipt called "adjust losses". When the user receives the TO and checks the box, a script would run and do the remaining receipt and inventory adjustment.

Scripts would be easiest, but since that's out could you write from the fulfillment to the sales order with a workflow? Then source the invoice value from the SO.

Is your goal to keep blank bin pick tickets from being printed? Or is your goal to keep from fulfilling on the receiving dock?