Skip to content


Adding to the GlobalMessage Script

Alyson Van Alstyne asked 9 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


if _DOCAMNT<>0 then
return true
return false
end if

'end of script

Ruaan Jonker replied 9 years ago

Hi Alyson

The script you specify above will work :

[quote=]if _DOCAMNT<>0 then

return true


return false

end if[/quote]

You need to add this to the restriction on the line item. (Map Setup / Mapping / Restriction)


gp_usr replied 9 years ago

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?


Best Answer
Ruaan Jonker answered 9 years ago

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.


If you would like to submit an answer or comment, please sign in to the eOne portal.