Skip to content
+1-888-319-3663

COMMUNITY FORUM

Source contains separate column for each segment of the account

Tamara DeStefano asked 3 years ago
I am trying to pick up the account number based with a calculated field that combines three columns of the source data. Here is the calculation: return “_JOURNALACCOUNTCODE&”-“&_DEPARTMENT&”-“&_EMPL_REGION”. I’ve confirmed all three columns contain the correct number of digits and that they are valid in the GP company, yet, I am getting this error:
Error in ‘MsGpDestination’
Line ‘taPMDistribution_AB83FF4A-A994-45F9-B628-AA09000B33019’
Parameter ‘Account number’.
Parameter set value event.
Calculation column: ACCOUNTNUMBER : Conversion from string “_JOURNALACCOUNTCODE&” to type ‘Double’ is not valid.
Does anyone have any suggestions?
 
Thanks!
Answers
Lorren Zemke answered 3 years ago
Tamara,
You have too many quotes in you logic. Try the following
 
return _JOURNALACCOUNTCODE & “-” & _DEPARTMENT & “-” & _EMPL_REGION
If the column data for each segment is considered a number, you may have to do the folloiwing.
 
return _JOURNALACCOUNTCODE.ToString() & “-” & _DEPARTMENT.ToString() & “-” & _EMPL_REGION.ToString()
 

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