Thanks for the replay. I also did the listed steps above and still get the error message.

It's a summary formula on MAX. When it runs it just throws an unexpected error.

jvoigt, it sounds like you may need a schedule script. What is updating the sublist? maybe you can add a function to that that will update the line-item count field.

jvoigt, this should be done with a client script that counts the items before saving the record and sets the transaction body field's value. Here is the code you will need. Additionally, you also need to replace item in the code with the name of your sublist. function clientSaveRecord(){ var lineCount =…

AGMNS, will these customers already have log in access to your webstore? Also, will they need separate pricing from everyone else? You will need a custom code field on the web store page, a custom tab for the customer to add the items you want them to see, and a custom role that is the only role to view the custom web tab.…

It sounds like you're using sitebuilder, which has less options then SCA. Will this solution need to be scalable to other customer?

dsplendore, did you configure the setup>accounting>credit card processing page in NetSuite? If so did you select the website and the supported payment methods? How long has the site been set live and are you using site builder or advanced?

I sent you a PM.

Hi, AGMNS are you using sitebuilder or SCA?

Hi, did you have any luck on this? I'm having the same issues as you. I reached out to NetSuite and will let you know if they come back with an answer.

Why don't you run the event on before user submit?

I agree with First NS. Except I would use jQuery as NetSuite pages reference the jQuery library. You can find the id by inspecting the element and use $j('example').hide(); in a page load client side script. Inbox me for more details.

Hi, You can't set prices on the item group record that are static; however, you can use a custom price level on the line level of the transaction. You might be able to create a custom item field and pull it on the item group record (component item view) that stores a custom price and then source that to the transaction.

Jason, what is this search being used for (i.e. dash board, weekly meeting, etc). You can run two separate reports in NetSuite then export them to excel and do a VLOOKUP. Also, you can create a view that displays the "last sales Activity" in the contact view on the customer record. I'll get back to you but I believe…

Jason, for a customization you can create a custom field of date for the contact record and then create a mass update. I would filter the criteria to include only contacts with a LSA value - for better processing. for the mass update fields set your new date field to a formula value of…

Jason, are you using the NetSuite Last Sales Activity Bundle?

Rick, the set up task is a header label and doesn't link to anything. You can go into the theme. After you're in the theme, look for the body tab click on it. Next scroll to the bottom where the footer template and add the code below. You will need to modify it to get the label you want. You will need to replace the text…

StephQ, I'm currently having this issue did you ever get it resolved?

Thanks for the feedback. I have an open case with NetSuite that is unresolved. I tried altering the code in the my account files but got nowhere. I will definitely look into the forms as we are using custom forms. I'll keep you abreast of any progress relating to this issue, thanks again.

Is this for suitecommerce advanced?

You should be able to pull the contacts by selecting contact fields in the results tab and including the name field for the contact record.

No, workflows don't have the ability to edit sublist. You should try 'rate' but don't you need to consider the quantities in the margins? The better solution would be something like this (rate * quantity) - (averagecost * quantity) / (rate * quantity) * 100. I only seen scripts for the solution your shooting for.

Do you used OneWorld?

Hi Eric, that's what my original plan is. I have to process batches of records with some of the batches being over 10k records a batch. I'm not sure that method is going to work. Maybe I'll pluck a JSON file with all the the external and internal id mappings. I can't believe NetSuite doesn't let you just use the externalid…

rsaunders, there is a configuration option on the results subtab of a saved search. check the "RUN UNRESTRICTED" check box and input the max number of search results in the adjacent field.

deleted

Thanks everyone. NetSuite has informed me that it's a current enhancement request to return more than 500 line items with the getLineCount function.

Hi fjannelle, Thanks for the response. One issue I found was that we aren't using advanced inventory/ BINs so the sub record method of setting the bins and quantity won't work. I read something that stated i needed to format the value as a string and pass it but that also is not working. The format I'm using is…

Thanks ironside, I will look into lodash and moment.

E-mail if you didn't get this resolved. I can walk you though the steps for creating this notification.