2022
Issue 1 : There are few missing invoices from QuickBooks to Dynamics CRM
Description: Whenever you happen to notice few of missing Invoices in Dynamics CRM online, Due to web-connector schedule is off for few days or Web-Connector is turned off for server maintenance or any other reason then follow the below steps in resolution to get back those missing invoices.
select * from Invoice,Customer where Invoice.MaxReturned=100 and Invoice.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName
select * from Invoice,Customer where Invoice.MaxReturned=500 and Invoice.TxnDateRangeFilter.FromTxnDate= '2017-07-12' and Invoice.TxnDateRangeFilter.ToTxnDate= '2017-07-15' and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName
The FromTxnDate and ToTxnDate date should have Invoice dates for which the Transaction are missed in Dynamics CRM online.