Scripting

Has anyone done a script for v2016 so that when a Sales Order is entered and the CONFIRM TO CONTACT has been entered, it fills the email field with the email in the contact table for that person??? It seem ridiculous that you select a contact, but then you have to reenter the email....or am I missing something???

Check with @DanBurleson

And it is Sage that is ""missing something""...

I wanted to tackle this soon too. If someone who has done this before can at least confirm how to link out to the AR Contact table using the three key fields, that would help me. I've only practiced the link out to CI_Item on Item Code from SO/PO Entry but never have linked on more than one field.

@NicoleRonchetti Have you done this before? I thinks so... maybe.

Lol... yes. I sorta did. I actually found it on Sage City. Let me look for it.....

See attached. This would be added as a column post validate on the confirm to field in SO Header

Thanks Nicole!!! and I dont feel that stupid...since others were looking for it too....

This is fantastic - thanks, Nicole! I look forward to trying it out!!

I sent this onto Diane Coffman as she is in charge of ""quick win"" enhancements. This is her response. **We changed it once as a defect and made the masses angry so we reversed it back. There needs to be an option to default from customer, contact, or ship to address. I put it in the Quick Win pile.**