Microsoft Dynamics 365 for Sales Integration in Dynamics NAV

  • Microsoft Dynamics 365 for Sales Integration in Dynamics NAV

    Posted by Ronald L McVicar Jr on December 5, 2022 at 4:59 pm
    • Ronald McVicar

      Member

      December 5, 2022 at 4:59 PM

      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
      ——————————

    Ronald L McVicar Jr replied 3 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Microsoft Dynamics 365 for Sales Integration in Dynamics NAV’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!