Importing sales statistics records

Select sales statistics excluded divisions

Select Data Import > Sales statistics excluded divisions), you can define divisions that will be excluded from statistics through Sales statistics excluded divisions.

Import sales statistics

Start the import for SalesStatistics.

Set SalesStatistics stored procedure to run on a schedule

When getting sales statistics data from M3 BE table OSBSTD these data are stored in the staging table LCLM.CLM_HUB_OSBSTD. To transfer these data to the CLM table LCLM.SalesStatistics, you need to run the stored procedure LCLM. Move_CLM_HUB_OSBSTD. You can run this manually, but note that you are recommended to create a scheduled job for this stored procedure.