3951833 Green Ribbon

Actually I want to dynamically select fields on the order items page depending on the order. So for example one time I order I set the field to a certain value but another time I order I change the value to something else. I want to avoid opening up purchase orders as I lose the automation. Thanks.

Inventory worksheets don't work with lot numbers so we are stuck. One inventory adjustment left $470 in our old location. This is definitely a weak spot.

Looking at your search it seems like you are not using a "Transaction" search. If you try to recreate this using a "Transaction" search you will have the "Created From..." join and hopefully give you what you need.

I think Evan meant for you to use the Created From join. If you scroll all the way down the search filters there should be a "Created From..." join. In this join select type=Purchase Order as per Evan's suggestion. Is this what you tried?

The data in my account is now corrupted as we have scripts that set fields based on saved searches. NetSuite what were you thinking. I'm going to apply the patch but the damage is done and we can look forward to a couple of hundred hours of work over the next few months to go with NetSuite's change. Unbelievable.

Bump...I need this as well. Need to add a filter in a formula. Ideally the filter would be an available filter that can be set in the footer. Long shot? Say no...Please...

Never mind figured it out. My denominator needed a sum as well. Must be blurry vision..

Nice one JMUnderwood. I tested it and was also able to style my column. '<span style=background-color:yellow;>Test</span>' NetSuite please don't run any update that will break this.

Shouldn't that be OR contains

Thanks Wally. That didn't work either. I added it and the search returned no data.

Thanks everyone. Account # doesn't work. It is the same line repeating itself and thus the same account # repeating itself. I've been in situations before where lines repeated themselves due to something in the search result but this seems to be an oddball case. I guess I'm going to have to file a support case, which I was…

The same account repeats itself. In the first subset its account 4010 for the same value that repeats itself 5 times. The one pattern I did notice is that the number of lines in the search results correspond exactly to the number of invoices billed against the sales order(in one case 5 lines for 5 invoices, 1 line for 1…

Here's my search criteria: main line = f shipping line = f tax line = f type = sales order date is within this fiscal year item = filtered out a number of items Search results (pretty standard) Date Type Number Item Amount

No vendors attached. These are service items. Thanks.

I just tried that and it did not return the item on the line. My end goal is to determine what is the average price items are sold at on sales orders.

My filters are: Main line: F (as I want line info data) Shipping line: F Tax Line: F From the looks of it the number of lines that are showing seem to correspond to the number of invoices that are billed against the sales order. Why would these lines show up as I'm not asking for any data from the invoice? Is there a…

Look under formulas in searches in the help guide. You can use a decode to pull the amount for a particular department (class or lcoation) and sum the amounts to give you the total per department. To get the sum of the parent department (with all the childs) in one column, just add the decodes for each department together…

Never mind I found the answer. I can just sum the departments in a search using a decode. Seems like a long workaround.

Sorry nevermind. CASE WHEN {type} = 'Bill' THEN {amount} END+CASE WHEN {type} = 'Item Fulfillment' THEN {amount} END should be CASE WHEN {type} = 'Bill' THEN {amount} ELSE 0 END+CASE WHEN {type} = 'Item Fulfillment' THEN {amount} ELSE 0 END

I can't get two CASE WHENs to add? This doesn't work: CASE WHEN {type} = 'Bill' THEN {amount} END+CASE WHEN {type} = 'Item Fulfillment' THEN {amount} END but this does: DECODE({type},'Bill',{amount},0)+DECODE({type},'Item Fulfillment',{amount},0)

Any update on this I am getting the same error? When I have the two seperated they work fine, but when I divide I get an error. Thx.

That would make reports cleaner. I don't know why total shows up on the bottom when your using an average function?

Well ok then...Makes sense. Thanks Evan.

You may be able to do it with a suite let using the run as admin permission. It would take awhile to setup and there is no guarantee it would work. I think that you might be able to find some sample code for uploading files via script in the help guide but you may have to dig.

It's likely because your using the old version of the NetSuite forms. Your forms need to be upgraded to the new versions that came out in 2010. Check the help guide or the forum for more details about upgrading your forms.

Thank you Justin.

I'm not sure it is available through the Api. It should work using the DOM.

Thanks Evan.

Can you use scriptable cart with the SuiteCommerce API? For example if I trigger the addItem API, will that trigger a validateLine event using scriptable cart?

Nevermind. You can create the record which links it back to the SO.