I'm trying to perform some business logic that is dependent on the 'billcountry' and 'shipcountry' on a transaction. This logic needs to be user configurable, therefore we have created a custom record which has a custom field which references the Country list. Now, i'm trying to match the 'billcountry' or 'shipcountry' value from the transaction with the records in my custom record by the Country list on the custom field.
The problem i'm getting here is this: I get different information from the 2 locations:
Custom Record: getText = Full country name (e.g. Ireland)
Custom Record: getValue = Internal ID value (e.g. 102)
Transaction: getValue = ISO country code (e.g. IE)
Transaction: getText = null
On top of that, the list of Country that is available for custom fields is sort of a record because it shows up in the list of Source records when creating another custom field, however there are no available fields to select from the Country record. So, it looks like all i get is the ID or the Name.
Has anyone dealt with this in the past? If so, how can you create these custom fields and match them up to the 'billcountry' or 'shipcountry' fields on the transaction?
Any help is appreciated. Thanks.