smurphy820_22074 Green Ribbon

Two thoughts come to mind not sure if this will give you what you are looking for. 1. use a MAX filter on the Date field that should only return the latest. 2. Group by entityID. then you should only get one record per entity meaning a lead and the resulting prospect share an entity ID and would be grouped together.

you will need two separate deployments for the script record. One deployment record for each record type you want the script to run on.

Try setting your currentInvoiceLine variable using this api currentInvoiceLine = nlapiFindLineItemValue(type, fldnam, val) It will search the sublist for a specific value in a field and return the line number. If you cannot use that, then to prove your code works or doesn't you could try hard coding the InvoiceID and line…

cgripp I would be very interested in hearing your results abou the shopping cart. I have a customer who is using Magento enterprise and we are currently working on the integration so any information you found/find may be helpful to us. Best,

This is not as easy as it sounds, but it is all possible. I am doing 90% of this for a client of mine who runs a seminar business. first things first. you want to be able to add Attendee that are not Full NS users to events. to events. I would go a step further and say you would want to track who has or has not attended…

if you share your calendar with someone in Calendar preferences, you can allow that person to edit your events. Its a manual process to share your calendar with each person but might it get you what you need?

I can see two ways to do this right off the top, One: I did a customization for a customer previously that I think would work for you here. Assuming each cow is its own item and I would use inventory items for this. So you purchase 5 Cows, 5 inventory Items are created Cow A Cow B Cow C Cow D Cow E You use these items to…

Are you referring to the revenue accounts? Moving sales from one income account to another? If you are we should talk, I am currently working a solution that may perhaps fit your need. If this is not what you mean please explain more.

I would create it as an inventory item with special order and then include that item in the assembly. this was you can track purchases of the item and handle the billing. And if there are returns or excess of this item you can track the "overstock" as inventory.

Eleran, Do you think that you could write out, in plain english how you determine your pricing for items? for instance, Items from Vendor A we market up X%, however customers of type 'z' purchasing items from vendor A receive a y% discount... It may be quite long to do that but if you can, I am sure your pricing could be…

Evan, This Thread answers a current question I have, my new question is has there been any progress on this?

The best way to handle this is with a before field edit Workflow. The Documentation of setMandatory says: "The method is only supported on scripted fields via the UI Object API." Meaning it will not work on fields that are builtin or added via SuiteBuilder.

that may be the that you didn't save it. It also could have been a Caching issue. Next that happens try A. Log out of NS completely B. Close all browsers C. Clear your Cache D. Login an check again thats actually pretty common.

I agree with Richi, that was my first though as well make sure you are looking at the same form. you may need to go in and edit the field name on each custom form as well as make sure your user groups are set to use the custom forms and not the default form for new records.

when you edit the Online customer form, there is a Workflow tab. On that tab you can specify how to handle duplicates, one of the options is to 'Always create a new lead' or 'Update the first matching record'. I think changing that option will get you headed in the right direction.

Perhaps look at your duplicate detection settings, see if what is set there to determine if a record is duplicate (i.e. email domain + Name/ID ) are also present on your online form?

if it is creating a Lead, that is the same record type as Customer so you are close.

You can do this with a SuiteFlow. Use a Create Record SuiteFlow (workflow) and set the field values when the item receipt is created. You will want to use an After Record Submit on Create. In that way you can also store the Custom Record ID on the Item Receipt as well to create the two way link. -Sean

Hi, Assuming this is a text field it does not harm your data to change the Max length. I tested this and it does NOT strip the extra characters or prevent you from saving an existing Customer record with the longer number if you need to edit the Customer data.

amccausland, I like your solution here. Question, do you think in the long term the number of records in the custom table will have an affect of the performance? Say, even if this table get to be a few hundred thousand records?

So I click or select a value in field "A" and the list in field "B" changes to reflect the options for the item selected in field "A"? I believe the problem is here that your HTML form is not dynamic by the nature of it being HTML. You are going to have to get your HTML form to reload with option A already selected perhaps…

Hi, Have you tried publishing your saved search and then using an inline HTML field or an iFrame to display the results? We are doing this for one customer to display their event schedule from NS on their Website. Sean

Can you elaborate on what you are trying to do?

Try this... (****untested) function CheckCustomerDeposit(depositSearchResults, salesOrder) { nlapiLogExecution('DEBUG', 'details', 'inside function'); var depositAmount = nlapiSearchRecord('customerdeposit',depositSearchR esults); if (depositAmount && depositAmount.length == 1) { nlapiLogExecution('DEBUG',…

I concur with j.j this looks like a client side script. However if it IS a server side script then you need to look at your deployment of that script to see if the CSV import context is selected. Even if you tell the CSV import to execute scripts, If the import context is not selected for that script it will not run.

I know this is an OLD thread but it bears updating... at this time Campaign response is scriptable Re: Answer Id: 63111

Hi, Thanks for the reply, What I am looking for is how to get the final URL (as if I was were going to type it into the browser myself), Is that available as property of the response object? If not how do I get it? do I have to build it myself? Sean

Hi, have you tried turning your search into a summary search and return a count of the internal ids. This way you will only return one record but it will give you a total count. Sean Murphy BMI Cloud Solutions

Hi Dan, Can you define what you mean by Name? What is the parent record type is it a custom record? If you are not looking for internalid, Record Type or the value in the NAME field. I am a bit confused as to what you want to return? Sean

This does seem like it should be a very rare event. if not perhaps you could re-evaluate the logic used to trigger the event to delay the update. Perhaps simply putting a delay in the logic will slow it down enough to avoid the collision. The other thought that comes to mind is a concept of an update queue. Basically its a…