Need a way to avoid sending central warehouse records to channel db so more customers can be addressed especially if they use offline mode which would double the space needed for INVENTDIM and INVENTDIM_Tracking table.

Launch AX client.

Retail > Setup > Retail scheduler > Channel integration > Channel database

In the channel database form, select HOUSTON and click Full data sync > 1040 Products

in sql management studio, open channel db and look at INVENTDIM table.

Actual result :

In customer environment, INVENTDIM  and INVENTDIM_Tracking tables take around 5GB and the whole db consequently reach the SQL Express 10 GB limit.

most records are related to their central warehouse