Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

VI Cross Reference Customer Email to Customer Number

Posted By Lukas Medhus 14 days ago

I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to the sales order. How do I do that?

Parents

0 Kevin M 13 days ago

Untested Idea:

VI to a generic customer number, then do a script on the SO header table (post-validate on the email address) to query the customer table for that value, then override the CustomerNo at that point. VI results wouldn't likely show the results of the scripted customer # change, but it might work.

Or hire a Master Developer to come up with some Perform logic to do a lookup...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kevin M 13 days ago

Untested Idea:

VI to a generic customer number, then do a script on the SO header table (post-validate on the email address) to query the customer table for that value, then override the CustomerNo at that point. VI results wouldn't likely show the results of the scripted customer # change, but it might work.

Or hire a Master Developer to come up with some Perform logic to do a lookup...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 100

VI Cross Reference Customer Email to Customer Number

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING