19
The situation: a Dataverse connection between Dynamics 365 Sales and Dynamics Business Central is activated to transfer important data between the two systems. However, to utilize the full potential of Dynamics 365 Sales, some vital data is missing. After some research, it seems that the standard Dataverse connection, with the standard integration tables, is lacking important fields in existing integration tables or lacking important tables completely. For example, the following fields are missing:

- Customer No. in the standard CUSTOMER integration table
o All the fields from table 18 would be useful though

- Vendor No. in the standard VENDOR integration table
o All the fields from table 23 would be useful though

- Table 36 (Sales Header) is missing completely
o Sales Orders and Quotes need to be synchronized

- Table 7000 (Price List Header) and/with table 7001 (Price List Line) are missing completely
o Sales Prices need to be synchronized

It seems that there is no functional way to add/setup tables and/or fields in the standard integration tables in Business Central, besides creating a customized (developed) app. It would be very useful if a functional consultant could add tables/fields to the integration table list to be synchronized in the Dataverse connection
Category: General
STATUS DETAILS
Declined
Ideas Administrator

Thank you for reaching out. Your suggestion seems to be a duplicate of the following suggestion:  

Please add your valuable votes and comments to the suggestion above instead.

Sincerely,
Business Central Team