[Ronald McVicar]

I am attempting to develop a SQL Query to show on a daily bases any “fails” we might have in our Sync from CRM (Microsoft Dynamics 365 for Sales Integration in Dynamics NAV ).  So in the Microsoft Dynamics 365 for Sales Integration in Dynamics NAV the CRM database uses the InvoiceBase table and syncs to NAV first at CRM Sales Agreements; and then in NAV these CRM Sales Agreements then get posted as NAV Sales Agreements.  I see the NAV Sales Agreements, but from the CRM Integration and viewing the “Fails” what are these?  Is NAV connecting directly to CRM for this view (list or page) inside of NAV?

i am attempting to identify the SQL Table name in NAV SQL Database to write a SQL Query for these failed integrations, so an accountant does not need to drill down in to (in and out) to see 5, 10 or 100 failed integrations.  i.e. here is the list of failed Sales Agreements from the CRM NAV Integration., etc.

——————————
Ronald McVicar, IT Software Mgr
NSP (Quality Meats)
nspproteins.com
——————————