Ship to like this. It doesn’t come in automatically, but you should be able to link them like this.
Okay I’m good with that
which table is the salesman in? (I’m being lazy)
I was pulling it off of InvoiceHead
Is that that goofy ~ delimited list?
Yup.
Here’s what I was doing before:
inner join Erp.SalesRep as SalesRep on
InvcHead.Company = SalesRep.Company
And
Left(SalesRepList,4) = SalesRep.SalesRepCode
that’s the part I think was screwing you up the BAQ. I think we can get it though.
On your join type this in. (ignore the autofill)
3
edit something isn’t right with that… Trying to figure it out.
Yep That 's working!
Thank you!
Make sure you double check that. Maybe we have something different set up, but mine doesn’t seems to be working exactly right.
I got the correct name.
ok, mine isn’t returning any names for regular invoices. But it could be the way we have things entered. The names that come back are for credit memo’s mostly.
I had to use Left(InvcHead.SalesRepList,5). Ours aren’t all the same length.
Ours are all 4 digit
I think I’m good, now.
Thanks so much!
1 Like
looks like you are good to go then. If I do an or and can do both 4 and 5 and I get them all.