75,730
Integration Manager GP 9 9.00.0054 Why does this script: CurrentField.value = Abs(Sourcefields("SWS_AP_Header.VOUCHER_GROSS_AMOUNT")) Result in this error message? Variable uses an Automation type not supported in VBScript All I want to do is the get absolute value of a number.
*This post is locked for comments
Strangely enough, this worked:
CurrentField.value = Abs(Replace(Sourcefields("SWS_AP_Header.VOUCHER_GROSS_AMOUNT")," ","")
Even though the input field is defined as decimal(19,5) in the SQL table, I still had to strip away blanks. In all the years I have written integfrrations I have never had to do this before. Thanks for the tip.
Richard,
2 thoughts.
1) Are you sure that SWS_AP_Header.VOUCHER_GROSS_AMOUNT is a number and not a text type in the integration?
2) Try wrapping it in a variable.
Dim MyNumber
MyNumber = Abs(Sourcefields("SWS_AP_Header.VOUCHER_GROSS_AMOUNT"))
CurrentField.value = MyNumber
I quit asking Why a long time ago but sometimes this works with odd ball IM Script errors.
Mark
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (