Total purchases per division

SQL query for Exact Online

Get the total purchases amount for each division.

SELECT Divisions.DivisionCode, SUM(PurchaseEntries.AmountFC) AS TotalPurchasesAmount FROM PurchaseEntries JOIN Divisions ON PurchaseEntries.Division = Divisions.ID GROUP BY Divisions.DivisionCode

Exact Online data model

Table Transactiontype

Name: String
Number: Integer

Table Glaccounttype

Name: String
Number: Integer

Table Entitytype

Name: String
Number: Integer

Table Sales Invoices

Table Sales Invoice Lines

Table Purchase Invoices

Table Purchase Invoice Lines

Table G L Accounts

Table G L Classifications

Table Reporting Balance

Table Costunits

Table Purchase Entries

Table Sales Entries

Table Document Attachments

Table Documents

Table Accounts

Table Transaction Lines

Table Financial Periods

Table G L Account Classification Mappings

Table Aging Payables List

Table Payables List

Table Divisions

Table Items

Table Goods Deliveries Sync

Table Goods Deliveries

Table Goods Delivery Lines

Table Goods Delivery Lines Sync

Table Sales Orders

Table Sales Order Lines

Table Addresses

Table Aging Receivables List

Table Receivables List

Table Costcenters

Table Shop Orders

Table Workcenters

Table Time Transactions

Table Timed Time Transactions

Table Material Issues

Table Shop Order Routing Step Plans

Table Shop Order Material Plans

Table Purchase Orders

Table Purchase Order Lines

Table Warehouse Transfers

Table Warehouse Transfer Lines

Table Selection Codes

Table Account Classifications

Table Contacts

Table Cashflow Payments

Table Subscriptions

Table Subscription Lines

Table Subscription Types

Table Subscription Reason Codes

Table Receivables

Table Assets

Table Journals

Table Bank Accounts

Table Default Mailbox

Table Preferred Mailbox

Table Preferred Mailbox For Operation

Table Mailboxes

Table Mail Messages Sent

Table Mail Message Attachments

Table Opening Balance After Entry

Table Deleted

Table Account Classes

Table Account Classification Names

Table Projects

Table Project Classifications

Table Cost Transactions

Table Cost Types

Table W B S Expenses

Table Cash Entries

Table Cash Entry Lines

Table Batch Numbers

Table Item Warehouse Storage Locations

Table Goods Receipt Lines

Table G L Accounts Bulk

Table Account Owners

Table Account Involved Accounts

Table Involved User Roles

Table Involved Users

Table Bulk Sales Orders

Table Bulk Sales Order Lines

Table Bulk Sales Invoices

Table Bulk Sales Invoice Lines

Table Purchase Return Lines

Table Item Groups

Table Quotations

Table Quotation Lines

Table Stock Batch Numbers

Table V A T Codes

Table Banks

Table User Roles

Table User Roles Per Division

Table General Journal Entries

Table General Journal Entry Lines

Table Payment Terms

Table Events

Table Quotation Headers Sync

Table Quotation Lines Sync

Table Absence Registrations Sync

Table Absence Registration Transactions Sync

Table Leave Absence Hours By Day Sync

Table Leave Build Up Registrations Sync

Table Leave Registrations Sync

Table Schedule Entries Sync

Table Schedules Sync

Table Item Storage Locations Sync

Table Item Warehouses Sync

Table Serial Batch Numbers Sync

Table Stock Positions Sync

Table Stock Serial Batch Numbers Sync

Table Storage Location Stock Positions Sync

Table Purchase Item Prices Sync

Table Sales Item Prices Sync

Table Supplier Item Sync

Table Bill Of Material Materials Sync

Table Bill Of Material Versions Sync

Table Material Issues Sync

Table Shop Order Material Plans Sync

Table Shop Order Purchase Planning Sync

Table Shop Order Routing Step Plans Sync

Table Shop Orders Sync

Table Shop Order Sub Orders Sync

Table Bank Accounts Sync

Table Employees Sync

Table Employment C L As Sync

Table Employment Contracts Sync

Table Employment Organizations Sync

Table Employments Sync

Table Employment Salaries Sync

Table Employment Tax Authorities General Sync

Table Project Planning Sync

Table Projects Sync

Table Project W B S Sync

Table Time Cost Transactions Sync

Table Purchase Orders Sync

Table Sales Price List Volume Discounts Sync

Table Subscription Lines Sync

Table Subscriptions Sync

Table Sales Order Headers Sync

Table Contacts Sync

Table Item Sales Prices

Table X M L Item Sales Prices

Table X M L National Holidays

Table Active Employments

Table Assembly Orders

Table Budgets

Table Budget Scenarios

Table Communication Notes

Table Departments

Table Employment End Reasons

Table Employment Internal Rates

Table Employment Organizations

Table Employments

Table Employment Salaries

Table Exchange Rates

Table G L Transaction Types

Table Invoice Terms

Table Item Assortment

Table Item Assortment Property

Table Item Warehouse Planning Details

Table Item Warehouses

Table Job Groups

Table Job Titles

Table Lead Sources

Table Payment Conditions

Table Planned Sales Return Lines

Table Planned Sales Returns

Table Project Budget Types

Table Project Hour Budgets

Table Project Planning

Table Project Planning Recurring

Table Project Restriction Employees

Table Project Restriction Items

Table Project Restriction Rebillings

Table Sales Price List Linked Accounts

Table Sales Price List Periods

Table W B S Activities

Table W B S Deliverables

Table Sales Price Lists

Table Warehouses

Table Returns

Table Project W B S

Table Hour Cost Types

Table X M L Bill Of Materials

Magical SQL for Exact Online with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Total purchases per division

SQL query for Exact Online

Exact Online data model

Magical SQL for Exact Online with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?