Can you set more than one criteria on a routing list? I want to look at the email address and the Inv Amt.
Thanks
Can you set more than one criteria on a routing list? I want to look at the email address and the Inv Amt.
Thanks
I believe only one is possible. In this case, it comes in handy to use a formula on your crystal report and make the text match the background to make it invisible to the eye but visible to APM.
This is the error I am getting when I try to email an AR Invoice using APM. I am guessing I have something set up wrong. My external email is working.
‘‘This key is already associated with an element of this collection’’
Below are the scripts I have accumulated doing APM. It is kind of like vb, so you can do lots of things.
They have a very complex example in the DL27AdminGuide document.
Have you contacted the APM help? They are very good with this.
Greg
SCRIPT TO VALIDATE EMAIL ADDRESS:
If InStr(PropertyValue, “@”) <> 0 Then
TextOut = PropertyValue
end if
SCRIPT TO VALIDATE FIELD W/LABEL to LEFT:
If InStr(PropertyValue, “Fax:”) <> 0 Then
TextOut = right(PropertyValue, len(PropertyValue) -5)
end if
SCRIPT TO VALIDATE FIELD W/LABEL ABOVE:
dim line
if instr(PropertyValue, “Vendor:”) then
if instr(PropertyValue,chr(10)) then
line = split(PropertyValue, chr(10))
TextOut = trim(replace(line(UBound(line)),chr(13),""))
End if
End if
SCRIPT TO VALIDATE FIELD W/LABEL to LEFT and email address:
If InStr(PropertyValue, “Email:”) <> 0 Then
PropertyValue = right(PropertyValue, len(PropertyValue) -5)
end if
If InStr(PropertyValue, “@”) <> 0 Then
TextOut = PropertyValue
end if
REMOVE AMPERSAND &
PropertyValue = replace(PropertyValue, “&”,“AND”)
PropertyValue = trim(PropertyValue)
If InStr(PropertyValue, “Method:”) <> 0 Then
TextOut = trim(mid(PropertyValue, (Instr(PropertyValue,":") +1)))
end if
If InStr(PropertyValue, “Authorized”) <> 0 Then
TextOut = trim(mid(PropertyValue, (Instr(PropertyValue,":") +1)))
end if
If InStr(PropertyValue, “Fax:”) <> 0 Then
TextOut = trim(mid(PropertyValue, (Instr(PropertyValue,":") +1)))
end if
If InStr(PropertyValue, “V-Code:”) <> 0 Then
TextOut = trim(mid(PropertyValue, (Instr(PropertyValue,":") +1)))
end if
If InStr(PropertyValue, “PO Number:”) <> 0 Then
TextOut = trim(mid(PropertyValue, (Instr(PropertyValue,":") +1)))
end if
If InStr(PropertyValue, “Email:”) <> 0 and InStr(PropertyValue, “@”) <> 0 Then
TextOut = trim(mid(PropertyValue, (Instr(PropertyValue,":") +1)))
end if
dim line
dim line1
if instr(PropertyValue, “Vendor:”) then
if instr(PropertyValue,chr(10)) then
line = split(PropertyValue, chr(10))
line1 = trim(replace(line(UBound(line)),chr(13),""))
TextOut = replace(line1, “&”,“AND”)
Please Confirm receipt and acceptance of Purchase Order {PO #} attached
You may have this PO entered as our reference number {OSAS PO}
Thank you.
{Buyer}
{Buyer Email}
PO Date {Order Date}
Invoices for {Date}
Attached are Invoice for {CustName} from {date}.
If you have questions please reply to this email.
Thank You,
Name
Company
@Kimberley, this error sounds like some sort of issue with the key rather than routing or emailing. Perhaps you’ve already used the invoice number as a key for another document type?
Yes I have. I have a document that have been formatted two different ways. I figured since it was identified differently it could use the same key.
thanks