13

We have thousands of customers that are inactive and would like a way to either not view them, mark them as inactive, or just not sync them over from Dynamics CRM. 

Category: General
STATUS DETAILS
Completed
Ideas Administrator

Thank you for your feedback. We released this feature as part of the functionality in Dynamics 365 Sales Integration. 

Integration Table Mappings page contains column Integration Table Filters. Clicking on this column will open filters applied when synchronizing customers (accounts) from D365 Sales to Business Central. Default filter for customer state is set to Active, which means only Active customers are synchronized.

To disable blocked Business Central customers from being synchronized, enter 'VERSION(1) SORTING(No.) WHERE(Blocked=FILTER(' '))' in Table Filter column in Integration Table Mapping page for CUSTOMER mapping. 
If you want to Inactivate customers in Business Central, you can use blocking functionality described here: https://docs.microsoft.com/en-gb/dynamics365/business-central/receivables-how-block-customers

 

Sincerely, 

Ivan Koletic

PM, Microsoft 


Comments

C

Discontinued Master Data app does this today :)

https://appsource.microsoft.com/en-gb/product/dynamics-365-business-central/PUBID.fenwicksoftware%7CAID.fg15%7CPAPPID.dce768b6-3e04-44b1-9761-a346828e8861?tab=Overview

#shamelessplug

Category: General

C

meaningful!

Category: General