We are on CRM Dynamic 2013 Rollup 3 on SQL server 2012
When i do the drill down to order product and filter out all customers that have bought Product type managed service i only get 102 records out of the 542 records that should be there. I know this as i did a SQL download to verify the data with order numbers
and line items.
http://blogs.msdn.com/b/crm/archive/2008/12/29/poor-man-s-business-intelligence-for-microsoft-dynamics-crm.aspx
Can you explain why the exact same query as in the above link does not pull all the data back.......
Account to order to order product and filter only the product types that are managed service.
It should work and we need it to work to be able to add records to marketing lists. i don't particularly want to add 543 records manually and then go through all the line items and work out which new accounts have also bought managed services. It means that
anything that is product line based is a manual job to add the marketing lists. It also means that anyone doing advanced finds are not getting the correct information in their reports.
I would like the dynamic advanced find to work!!!
I am thinking this is a bug in the system.
Any help would be gratefully appreciated?
