Adding to the GlobalMessage Script
Alyson Van Alstyne asked 10 years ago
I am updating the batch post date for RM transactions using the GlobalMessage script, but need to add the restrition to integrate only documents with document amount <>0 The following will validate, and the postdate calculation works , but docs with $0 amounts still come in. Is it possible to do this in the create transaction node restriction?
'Beginning of script
GlobalMessage=_POSTDATE_CALC
if _DOCAMNT<>0 then
return true
else
return false
end if
'end of script
Answers
Best Answer
Ruaan Jonker answered 10 years ago
Ruaan Jonker answered 10 years ago
Hi
C# is case sensitive where VB is not.
So you need to make sure that the case matches the actual case of the column.
Remove the column from the script and drag it accross again.
In our later versions we convert all columns to upper case as this was an issue in the past.
Regards,
Ruaan
C# is case sensitive where VB is not.
So you need to make sure that the case matches the actual case of the column.
Remove the column from the script and drag it accross again.
In our later versions we convert all columns to upper case as this was an issue in the past.
Regards,
Ruaan
Hi Alyson
The script you specify above will work :
[quote=]if _DOCAMNT<>0 then
return true
else
return false
end if[/quote]
You need to add this to the restriction on the line item. (Map Setup / Mapping / Restriction)
Regards,
Ruaan
I am trying to do something similar, where i am adding a restriction in my line mapping. Only issue is when i do it in c# it gives me the error:
"the name _columnname does not exist in the current context"
vb works fine but c# doesnt seem to take the source column names. any idea?
Regards,
tq