AnalyticsData WarehousingETL

Microsoft Dynamics Nav SQL Queries

By 21 April 2020No Comments

As part of our ERP query series we bring you Navision / Microsoft Dynamics Nav / Dynamics 365 Business Central the new name for the latter. The schemas are all pretty close and there are many tables and but there are a few core ones that are always used in ETL / BI Analytics projects.

Here are the SQL Queries that you can use in your data projects. You can also download directly from https://github.com/thedatacrew/Navision-SQL-Queries

  1. Customer Ledger Transactions Query
  2. Customer Parameters Query
  3. Customers Query
  4. General Ledger Query
  5. Inventory Query
  6. Invoice Items Query
  7. Invoice Ledger Query
  8. Invoice Query
  9. Product Query
  10. Purchase Invoice Line Query
  11. Sales Order Line Query
  12. Sales Quotation Line Query
  13. Supplier Ledger Transactions Query
  14. Supplier Parameters Query
  15. Suppliers Query

If you want to get more info on Navision’s tables and schema head over to https://dynamicsdocs.com/

CustomerLedgerTransactionQuery.sql

CustomerParameterQuery.sql

CustomerQuery.sql

GeneralLedgerQuery.sql

InventoryQuery.sql

InvoiceItemQuery.sql

InvoiceLedgerQuery.sql

InvoiceQuery.sql

ProductQuery.sql

PurchaseInvoiceLineQuery.sql

SalesOrderLineQuery.sql

SalesQuotationLineQuery.sql

SupplierLedgerTransactionQuery.sql

SupplierParameterQuery.sql

SupplierQuery.sql

Follow me