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 seperate 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. However modifying that layout has it's own issues and adding new data-exchange layouts is frequent work for us that we need to understand. What could be preventing BC from allowing us to correctly spawn the Field Mapping and link the TableID?
We have a new install of Business Central for a startup, not a conversion of a prior system.
