Hi All
I'm looking to sync all the Business Central Data into Dataverse so I can then ingest this data elsewhere. I have managed to set up the Dataverse connection successfully, however, I am struggling with the "Integration Table Mappings".
There are some set up straight out of the box, however, when I try to run a "Full Sync" on the Customer Entity, I get an error because its dependant on other tables to exist in the Dataverse first.
I have made the new table (I think Payment Method was one) however, when I go to create a new Table Mapping I can't pick Payment Method from the Table dropdown (which is Business Central) and I cant pick my Payment Method from the Integration Table dropdown (which is the Dataverse Tables).
If anyone could shed some light on how to properly set up Business Central to sync data to Dataverse, that would be brilliant. I have spent days looking into it all and end up chasing my tail.
P.S I am no expert in Dataverse or Business Central
