Write-offs: we do an inventory adjustment tagged to a specific income statement account Multiple Locations: If you have a website, remember that "available" inventory will include inventory of all of your non-conforming inventory locations. No way to specify a default webstore fulfillment location, or to exclude certain…

Ditto. Would love to work on solutions / best practices.

Would love an update on this. An example of being so close, yet so far. We often upgrade from USPS to FedEx at the time of shipping, and displaying the sales order shipping method would just cause confusion. Is there no tag to pull the shipping method from the item fulfillment?

Thanks. If we could: 1. have visibility of Address_ID as a Saved Search Results Column when doing a customer search 2. have visibility of Address_ID as a CSV import field ... then we would be able to manage updating of customer addresses pretty staightforwardly via excel. That would be huge.

Looking for it as well. Can't seem to figure this out out. Would love to be able to, as well as to update customer addresses once I know the address id.

Well, we would need something that would enable us to edit or update in a manner easier than having to go into the customer record and then find/edit the line item on the address tab. - CSV import was one idea - direct list editing on address line items would be another - you might think of yet another...

In v2007, you will be able to have Ship Date default based on: -a standard # of days + the sales order date -add a day if the order is placed after a shipping cutoff time -optionally skip Sat and/or Sun -skip user-defined shipping holidays. It is also possible to use SuiteScript to perform these and other more complex…

Hey, thanks for the info. Very helpful. I should start with saved searches more often. HOWEVER, interesting to note that: STATUS on saved search DOES NOT WORK for ESTIMATES !!!! - Choosing Status = "Estimate:Open" gives me Open and Expired Estimates. - Among the status options are "Estimate:Closed" which I don't think is a…

Ahh, thank you grasshoppa... Now I understand why it would be overstated.

Thanks, June, but: - which address in the customer record would Customer/Job: Address: State be pullling from, assuming there are multiple (say one billing and one shipping)? - why would a report based on Customer/Job: Address: State so dramatically overstate actual sales to the customer?

Rick, I think that is the theory of how NetSuite would (eventually) like to use the Customer/Job - Address Book - State, and it sounds like this is where evan is headed. However, they currently do not have a designation for one "Headquarters" or one "master" address. One idea NetSuite might consider is to have two address…

Brian and Evan, This is also a problem in v10, and is made worse when you're trying to get sales by state, expecting one customer name. If the customer has multiple ship-to addresses in different states, this is a major problem. Any thoughts on how to work around the limitation? Thanks, Rick Use Sales: Address: Shipping…

Surprised that selecting comparative reports has not been made easier in 2009.1. ALSO, I believe that there is a bug. When I do select "Same period from last YR", I do not get the period expected. For example, when I select Last Period (Mar 2009), the comparative period returns April 2008. Near as I can deduce, NetSuite…

Ditto. Default expense report insufficient. Why does it not follow the supposed standard and allow print screen customization? Bringing things up to standard should not be counted as an "enhancement".

In the Filter section of the basic Budget vs. Actual report, there is a standard line that is: Report Component - Customer/Job Field - Customer/Job: Name ... which, if you select a specific customer job at the bottom of the report, DOES line up the GL accounts correctly for budget and actual for that given customer. So…

I just dug into this and can't make it work either. You can specify a customer/job column from the Budget folder, and you can specify an Entity Name from the Income Statement folder, but there doesn't seem to be any way to have these two fields correlate to each other such that you can get a line with a customer and an…

The new built-in average cost field in 2007.0 respects location, whereas if you want the overall average cost across all locations, you can use the sourced value into a custom field. Thanks, -e That seems promising. Will I be able to source average cost for kits? Because this is the one type that we: - use all the time -…

There is average cost available to be sourced in but it is still limited. For example, location average cost is available in a search but not in a custom col field. Mark I have seen this. But I am not getting it to work well in a saved search. I try to filter by location, and then use location average cost, and: - it…

Just add a custom field that you use only on the kits. If the purchase price is empty, copy over the value from your custom field. Mark Encouraging, but I'm not exactly sure how this works in practice. I have a transaction column named CoGS, that sources from Item - Purchase Price. How would the hybrid custom field you are…

That seems promising. Will I be able to source average cost for kits? Because this is the one type that we: - use all the time - haven't as to yet been able to source historical cost #s on for the purposes of pulling into a sales order for calculating estimated profitability. Thanks, Help me out here... The average cost…

As quoted by elham in the "Execution Usage Limit! Argh!" thread: There is also a usage limit for making server API calls from client side which is 200 units. Oh well. I don't think "Oh well" is an acceptable answer (EDIT: Didn't mean an acceptable answer from you; meant that we shouldn't be content with throwing up our…

It would be nice if NetSuite could acknowledge this issue and at the very least let me know if they will "unhide" the purchase price field from Kits - displaying it just like on Assemblies. This would save me the hassle from having to create a duplicate purchase price field just so I could source from kits. I think that…

- member lines of a kit NOT loaded in a browser (member lines of an item group are) - assemblies DO have a summary cost. In practice, however, I don't know how to pull in the actual cost (from a build), but rather pull in the purchase price field value (which I plug in based on average historical cost), and use the…

Well, I share your sentiments, Tad. Things like item groups adding lines to a sales order but not triggering the validateLine javascript function are frustrating - and blow the whole idea of being able to calculate profitability per order out the window. Unfortunately, I have no insight into v11, as (1) we have not been…

can anyone chime in as to whether 2007.0 has improved ability to calculate profitability on estimates / sales orders? At a minimum, I am looking to open up the purchase price field on kits. Even better, boy it would be nice to be able to source fields that allows calculation of actual average cost/CoGS for all items on an…

So I cut it down to focus on the parts that apply to calculating gross margin. For a while pre-v11 we experimented with a post sourcing function, but that never worked. So here is what we have, which doesn't work for anything that involves kits. The other thing that we can't get to work is that we would like to net out…

Helpful suggestions. I could certainly work on this. Am I right in assuming that such a javascript would cycle through every line item, source the "purchase price" from each item every time the field is changed or the button is pressed? Is there a better way to "anticipate" what the CoGS # is going to to look like when the…

Just to supplement #1 above (why can't we edit posts, by the way?), we manually input the purchase price of assemblies into the purchase price field of each, based on the average cost as per a inventory value report. This way, for sales of assemblies we do get a reliable CoGS value populate the sales order.

In v10, we attempt to do some of this by creating a custom CoGS transaction column field at the line item level and use a javascript to calculate gross profit on the order. We have 4 fundamental problems with this approach, however: 1. CoGS: We sell all assemblies. There is no way we know of to have a field in an assembly…

I have just finished rewriting my GP calculations to run Client Side and it looks like there are processing limits here as well. It is barfing on a lookup after about 20 lines. (Yes I have cross posted to the "Execution Usage Limit! Argh! " thread as well) Does anyone know if there are any restrictions on the amount of…