I am receiving an error message when trying to run my integration for the destination mapping of a field (See code below). I believe its because the script is sending the values as a text instead of numbers. I have not written much vb but there must be a way to do this. My source file is an excel file with a debit and credit columns, however I can not rely on the totals of these columns, which is why I am trying to sum them in IM using vb.
DOC 1 ERROR: Error Executing Script 'Distributions.Debit Amount' Line 1: - Type mismatch: 'SourceFields'
DOC 2 ERROR: Error Executing Script 'Distributions.Debit Amount' Line 1: - Type mismatch: 'SourceFields'
VB Script:
CurrentField =SourceValues("ADP TRX Detail.Debit")+SourceValues("ADP TRX Detail.Credit"))
Any help would be much appreciated.