DBSync Cloud Workflow (iPaaS)

2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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.


Resolution : You needs to login to DBSync account>>Click on Development Studio>>Select the Project name>>Click on the Workflow(Example-Invoice to opportunity)>>Then in trigger section of Query  Switch to Advanced View>>Then replace the Query 

From 


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


To 

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.










  • No labels