You’re offline. This is a read only version of the page.
I'm trying to setup a bank file import (csv) and can't figure out how to get make the TableID available to map fields. I suspect this is a setup/configuration issue.
The bank file doesn't fit with the standard formats parsed with the Bank Export/Import setup, having separate Debit/Credit columns with no sum total. The solution is to simply bring in both columns, create a transformation that nets the two, and output that value to TableID(274):FieldID(9-Statement Amount).
I'm not able to do that as I can't make the TableID active in the new Data Exchange Definition. When I call the Field Mapping action, it spawns the map window but the Field Mapping object does not appear to be linking to the Line Definitions Code value (below). Instead the caption for the object is simply "Field Mapping", rather than Data Exchange Definition.Caption ∙ Line Definitions.Caption ∙ [TableID.Caption]
When we use the Bank Import/Export wizard, we do get an object that correctly links the Definitions to to the Mapping object. But trying to modify that results in it's own issues and bugs and seems to be more of a work-around than the actual solution.
What could be preventing us from either linking or activating the Field Mapping object to a new Data Exchange Definition? A setup config? Missing a tool like Dataverse connections? Insufficient profile/roles assigned to the user?
