Dynamics Community Forum Thread Details

Business Central Table Integration Custom Field

I have made a new field in Dynamics 365 CRM Account entity called VatID and I am currently adding it to the Integration Table for Business Central Customer.

I used altpgen.exe in my visual studio code terminal to generate a table extension for Business Central CRM Account table. This is the site I used: Custom Integration with [!INCLUDE[cds_long_md](../includes/cds_long_md.md)] - Business Central | Microsoft Docs

The problem is that the fields generated inside the table extension for CRM Account are outside the range defined in my app.json file. Some have field Id values above 200 and below 300 and some have field values a little above 10000.

When I try to publish my extension the publish fails with an explanation that the field Ids are not in the correct range from 50000 to 99999. If I change the range so that it matches the range defined in my app.json and try to publish the publish still fails but the error message changes to Package deployment failed due to the following error(s): Failure status code ServiceUnavailable .

I need the Account table extension because I am using the new field as a property in my Integration Field mapping method inside my AL code.

How do I modify Account table extension so that publish to BC succedes?

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS