Using VBScript to concatenate text and field value

(0) Share

Report

Posted on by Community Member

Hi all and thank you for your support.

I have a source field entitled "Cash", and whenever "Cash">0, I need to set the Payables Cash Entry window's Document No. field to "WIRE" concatenated with Payables Cash Entry window's Payment Number field. Below is my current script (after dozens of various similar attempts) that is not working when I input this script into the Document No. Rule in IM.

If SourceFields("Cash")>0 Then

DestinationFields("Document No.") = "Payment Number"
Else
DestinationFields("Document No.").SetToDefault
End If

Note that the specific table I am working with is PM10000 and the field names are CDOCNMBR (Document No.) and CAMPMTNM (Payment Number).

Thank you very much for your assistance!

Patrick

*This post is locked for comments

I have the same question (0)