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
- Customer Ledger Transactions Query
- Customer Parameters Query
- Customers Query
- General Ledger Query
- Inventory Query
- Invoice Items Query
- Invoice Ledger Query
- Invoice Query
- Product Query
- Purchase Invoice Line Query
- Sales Order Line Query
- Sales Quotation Line Query
- Supplier Ledger Transactions Query
- Supplier Parameters Query
- Suppliers Query
If you want to get more info on Navision’s tables and schema head over to https://dynamicsdocs.com/[/vc_column_text][vc_column_text]
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
