So my update is that the following happened overnight: - "Value As of Date Above" numbers did NOT change - "Estimated Total Value DID change and now matches the sum of "New Value" minus "Value As of Date Above" - GL Impact now matches what is on the page of the inventory worksheet. What would be interesting to know from…

I'll wait until tomorrow AM to see if it sorts itself out, which sometimes happens, and will report back. But as of right now, it really is misleading the way the #s appear on the screen.

Is there any chance that the documentation will be adequate for crossborder movements? Or do I continue to "sell" my products at transfer prices. I have a Canadian warehouse, and it would be nice to handle it properly. Commercial invoices are a headache in any case. I have used the Sales Order function to generate them,…

Same deal with a vendor bill credit. Best they can offer is a screenshot / print from browser. Crazy.

We had the same problem. I had to design a custom record for transfer requests. From this i can print out a shipping manifest. Would you mind providing more details on how you did this? This is the type of thing I would be very interested in doing...

We need these items as well. Currently, we're using a print screen of the WT, which is a very poor work around. As well as, an "In-Transit" warehouse to serve as the holding warehouse. We third this request. Any hope that: a) this type of thing gets incorporated into the Summer 2007 release (along with the ability to…

There are two related enhancement requests: 56393, for a general transfer workflow including a transfer request, shipping step, etc.; and 39086, specifically regarding shipping paperwork for transfers. No guarantees at this point but this is something I'm strongly considering for next year's major release. This is a…

Thank you very much - that really helps. At the risk of asking one question too many, is it then possible to have Commit set to "Do not Commit" as a default? Thanks Don't think this is possible.

I'd suggest playing with the options on the Commit transaction column fields on the line items of the sales order itself, the Reallocate screen as mentioned, and the accounting preferences.

If you don't see a column "Commit", customize the form, go to Screen Fields - Columns. Look for Commit. Check it and place it where you want.

No, a kit is not a finished good itself. It's really a virtual bundle of individual finished goods, sold as one unit on the Order / Sales / Invoice / Revenues side. Meanwhile, on the fulfillment, CoGS, finished goods side, what the warehouse and the GL sees are the individual finished goods that make up the kit "wrapper".…

A couple of days ago, I copied directly from the history tab for the item and it said: Edit 12/31/2005 INVWK161 -347 0.00 -1,227.22 Edit 12/31/2005 INVWK161 979 0.01 9.79 Today I see: Edit 12/31/2005 Inventory Worksheet INVWK161 -979 1.26 -1,233.54 Edit 12/31/2005 Inventory Worksheet INVWK161 979 0.01 9.79 Boy am I…

A couple of days ago, I copied directly from the history tab for the item and it said: Edit 12/31/2005 INVWK161 -347 0.00 -1,227.22 Edit 12/31/2005 INVWK161 979 0.01 9.79 Today I see: Edit 12/31/2005 Inventory Worksheet INVWK161 -979 1.26 -1,233.54 Edit 12/31/2005 Inventory Worksheet INVWK161 979 0.01 9.79 Boy am I…

No, the inventory worksheet clearly said that the "Qty as of Date Above" (the before qty) was 979. I thus assume that, despite assurances that it would be fixed, that the before # is still unreliable on inventory worksheets. Correct?

I'm glad it will be fixed in October, but you know, it's incredibly frustrating that worksheets have never been workable during my entire experience with NetSuite (I guess post v11 they might be workable with e-'s fix, but I have to perform separate mass updates for my assemblies, items... ARGH!) In addition, while it is…

Under a PO / Item Receipt / Bill scenario & Advanced Receiving, I don't understand how I can go back and allocate landed costs for transactions prior to v11. Every time I try to edit a bill, it says "you cannot submit this form due to an unexpected error" (pop-up box - not the normal result unexpected error page).…

We do all of that externally. In v10 it is cumbersome (hopefully it will improve in v11), but here is how we start: 1. Create a dummy "super assembly" that contains all assemblies. Export this list every once in a while by clicking "Print" and then export to CSV. Then in Excel you will have a list of all your assemblies,…

So thanks to user elie, I was able to get backordered by location with this formula: nvl({quantity},0)-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) Yay!

So the ultimate answer was that the custom form did NOT have checked: Enable Field Editing on Lists Field ID: bextremeeditable I have no clue when this got introduced by NetSuite, but apparently this one form didn't migrate properly or got unchecked at some point (other custom forms do seem to have this checked). Just want…

Than you so much for the clarification. Worked. I guess I did not try every permutation ;) Cheers. Hello, For Hierarchical Inventory Locations, you simply use the actual Location Name (without the hierarchcy/parent). For example, if your Location is named Missouri : St Louis (i.e. St Louis is a sublocation of Missouri)…

This is super helpful to us. For hierarchical inventory locations, do you have any suggestions for how I do it? I have tried every permutation of: DECODE({inventorylocation}, 'Parent Location : Sub Location (Production)', {locationquantityonhand}) i.e., 'Parent Location : Sub Location (Production)' 'Parent Location:Sub…

you would typically do a formula, ({quantity}-{quantityshiprecv})*{rate}. Thanks, -e Following this logic, if the "aggregate amount" report field calculates something like this: SALES ORDER TOTAL - ({quantity}-{quantityshiprecv})*{rate}) ... then that would explain why the aggregate amount field is still incorrect - not…

I am trying to publish a saved search via "Publish Form" and can't get the results to come out with anything other than a dense list, paginated every 4 items. I have played with the Setup Web Site - Search tab - Search Form Item List Layout. But nothing modifies this dang default dense list layout.

Work on that enhancement (92491) is in progress and currently slated for the Spring 2008 Release. I'm no expert on this. I know Quicken uses OFX. I also know that companies like: Yodlee (www.yodlee.com) Mint (www.mint.com - which uses the Yodlee engine) Can, in a nanosecond, import all transactions from a checking or…

Your issue may be similar to one we ran into where when we had a couple of transactions that "straddled the new year" in the sense that the transaction date was on one side and the posting period was on the other. This made the bank rec especially confusing.

Just thought I would chime in. Had a similar problem that was driving me crazy. SITUATION - Custom Entity Field (happened to be check box type, but don't think that is relevant) - Applied to Customer Records PROBLEM - Not direct list editable in a list view of Leads SOLUTION - the check box needed to APPEAR on customer,…

This is not new. Have you considered using custom help fields next to the other fields to provide instructions? Thanks, -e Thanks for replying, e. Yes, we do use custom help. This is a great feature, but as I'm sure you can understand: 1. we'd love to be as much "in your face" to the order entry employees as possible (but…

Wasn't there acknowledgement about 18 months ago that, in customizing the discounts, that having the "Partner Discount" hard-coded as active and unable to be made inactive (or at least have it's name changed) was a problem? What's the current status? Can I inactivate the partner discount? What is the rationale for it's…

How smug was I customising the contact record using multiple select fields when we first got NetSuite A year in, my new fields are nicley populated with bags of data. How gutted am I that I have only just discovered that multiple select fields cant be used in the results tab of a search! :mad: Goddamn you NetSuite.....why…

same problem. Not working for me.