Call 1 (877) 638-7848 with your account number. You may have to wait for awhile but at least you can create a support case.

Yes - Illinois and Toronto

Have you been able to figure out away to build a search? We have been trying to access NetSuite account center for this and we are getting the compid error as well. We also filed a case and a defect was noted as being pretty low priority.

We recently created a simple suiteflow to update a custom timestamp on a sales order when a user clicks on a custom check box field. Let me know if any of the details can help you.

Our vote has been cast for this - now up to 182.

Have you considered using Lot Control on these items?

Have you tried creating a "customer inventory" part, purchase price set to $0, then purchasing/receiving the part from the customer (use a generic vendor for this purpose)? Then selling that part back to them for $0 along with your shipping charge and costs? That should net to a $0 g/l impact for the customer part aspect…

For our customers that require Physical counts (aka stocktake) we use Web Services apps to automate the process. They feed the app an CSV, and the app creates inventory Adjustments. Inventory Adjustments are NOT the same as Inventory Worksheets, but right now that's the best that can be done (while macro programs are neet,…

Did you every get the location box to work? Did this approach work for you?

I have the exact same problem with kits - would like to add a custom column for kit members for additional data that would be exclusive to that kit & line combination. Have been working with Netsuite for weeks to find a solution.

Nevermind my question. I now recall that lot controlled items do not and cannot appear on the inventory adjustment worksheet. Does this make any sense?

I would consider using a scheduled script to search for item records meeting criteria X. When it finds such a record then you could set the bin value.

Thanks for the solution Oliver. This was a big help for me today. It works great, I set mine up on a before load user event script with 'type' = 'create'. So everything defaults to '0' but the user can later change the value.

Thanks Oliver. I was afraid that would be the case. We have 1000's of items so I was hoping to streamline by using a logical grouping.

Thanks Laura - We used absolute value and that worked out well. I wanted to make sure that I just wasn't putting a band aid on something wrong within our account. Can anybody form Netsuite confirm that this situation is normal?

Although I haven't tried it in an email alert, you can create a Formula Field (Text) column in your search with a formula along the lines of: '<a href="https://system.netsuite.com/app/accounting/transactions/transaction.nl?id='||{internalid}||'">View Transaction</a>' This solution worked PERFECTLY. Thank you!

Hi, How did you enter in the Internal ID of the Price Level. {pricing.pricelevel1} is invalid. Thanks, Nathan... Hi Nathan, I'm using the following formula in a transaction search - it works great: Formula (Currency) {item.pricelevel32}

The internal ID worked perfectly. Thanks Evan.

Hello Mark.. Did you every figure out how to make this work? We want to also build a transaction search that shows a certain price level in the results. Can you explain how to use {item.pricelevelX}? Do I simply replace the "X" with the price level name or internal id?

Hi! We are looking to do get the last date an item was purchased on a search that shows only items currently in stock. I tried to use this formula but only recieved an error: Invalid expression message. I am not really good at searches or formulas so could you give me some further information. This is what I did: On…

Great. Thanks for the tip. I will give this a try.

When you tried sourcing the information onto the second custom transaction form did you enable 'store value' on the second field?

Finally found it in the help document .... [h=1]Table of Custom Field Type Descriptions[/h]

We did figure out that we could add the bill to address by placing <NLBILLADDRESS> in the templates>body section of the HTML form. Now, when we try to add {custentity4} or <custentity4> nothing appears for this on the html document. Any ideas?

I do source transaction body fields from both of these custom entity fields. However, one works and the other doesn't. This has got me thinking that it is probably related to scripting that we had done regarding the field in question. I have forwarded this thread to the scripting team. Thanks for your help!

Thanks for posting this question and the solution. This helped us with a similar problem!

Thank you Matrim. I have been using at the method (nested loop) demonstrated in SA#22385 for years however it only will work based upon sorting by internal id (that was the other part of the problem in that even within a UI search it times out). There seems to be some strange mapping on the pricing record that makes the…

Thanks for your responses! In addition to loading the sales order, which I will likely need to do in the end, I was able to use as well in my aftersubmit function: var pairedTrx = nlapiLookupField('salesorder',soID,'intercotransaction');

No I wish that we had but in the end we just figured out a way to stick a square peg in a round hole by using a script to accept a non-inventory item into a custom field on a sales order but then use a cross reference table to create a drop ship po for the item that the other subsidiary wants to see on their PO.

Thanks for the help fjannelle. You are correct in that the package tab can be deceiving. Your solution worked well. I would however would like to ask another related question. I would only like to set some fields only on the first package. I can't find anything in the records browser on this packaging tab. When I try to…