Total purchase amount by division
SQL query for Exact Online
Calculate the total purchase amount for each division.
SELECT Divisions.DivisionName, SUM(PurchaseEntries.Amount) AS TotalPurchaseAmount FROM PurchaseEntries INNER JOIN Divisions ON PurchaseEntries.Division = Divisions.ID GROUP BY Divisions.DivisionName
Exact Online data model
Transactiontype
View 2 columns
NameString
NumberInteger
Paymentmethods
View 2 columns
CodeString
NameString
Glaccounttype
View 2 columns
NameString
NumberInteger
Entitytype
View 2 columns
NameString
NumberInteger
Sales Invoices
Sales Invoice Lines
Purchase Invoices
Purchase Invoice Lines
G L Accounts
G L Classifications
Reporting Balance
Purchase Entries
Sales Entries
Goods Receipts
Item Charge Relation
Document Attachments
Documents
Accounts
Transaction Lines
Financial Periods
G L Account Classification Mappings
Payables List
Divisions
Items
Goods Deliveries Sync
Goods Deliveries
Goods Delivery Lines
Goods Delivery Lines Sync
Sales Orders
Sales Order Lines
Addresses
Aging Receivables List
Receivables List
Costcenters
Shop Orders
Workcenters
Time Transactions
Timed Time Transactions
Material Issues
Shop Order Routing Step Plans
Shop Order Material Plans
Purchase Orders
Purchase Order Lines
Warehouse Transfers
Warehouse Transfer Lines
Selection Codes
Account Classifications
Contacts
Cashflow Payments
Subscriptions
Subscription Lines
Subscription Types
Subscription Reason Codes
Receivables
Assets
Journals
Bank Accounts
Default Mailbox
Preferred Mailbox
Preferred Mailbox For Operation
Mailboxes
Mail Messages Sent
Mail Message Attachments
Units
Opening Balance After Entry
Deleted
Account Classes
Account Classification Names
Projects
Project Classifications
Cost Transactions
Cost Types
W B S Expenses
Cash Entries
Cash Entry Lines
Batch Numbers
Item Warehouse Storage Locations
Goods Receipt Lines
G L Accounts Bulk
Account Owners
Account Involved Accounts
Involved User Roles
Involved Users
Bulk Sales Orders
Bulk Sales Order Lines
Bulk Financial Transaction Lines
Bulk Sales Invoices
Bulk Sales Invoice Lines
Purchase Return Lines
Item Groups
Quotations
Quotation Lines
Stock Batch Numbers
V A T Codes
Banks
User Roles
User Roles Per Division
General Journal Entries
General Journal Entry Lines
Payment Terms
Events
Quotation Headers Sync
Quotation Lines Sync
Absence Registrations Sync
Absence Registration Transactions Sync
Leave Absence Hours By Day Sync
Leave Build Up Registrations Sync
Leave Registrations Sync
Schedule Entries Sync
Schedules Sync
Item Storage Locations Sync
Item Warehouses Sync
Serial Batch Numbers Sync
Stock Positions Sync
Stock Serial Batch Numbers Sync
Storage Location Stock Positions Sync
Purchase Item Prices Sync
Sales Item Prices Sync
Sales Item Prices
Recent Hours
Supplier Item Sync
Hours By Id
Bill Of Material Materials Sync
Bill Of Material Versions Sync
Material Issues Sync
Shop Order Material Plans Sync
Shop Order Purchase Planning Sync
Shop Order Routing Step Plans Sync
Shop Orders Sync
Shop Order Sub Orders Sync
Bank Accounts Sync
Employees Sync
Employees
Employment C L As Sync
Employment Contracts Sync
Employment Organizations Sync
Employments Sync
Employment Salaries Sync
Employment Tax Authorities General Sync
Project Planning Sync
Projects Sync
Project W B S Sync
Time Cost Transactions Sync
Purchase Orders Sync
Sales Price List Volume Discounts Sync
Subscription Lines Sync
Subscriptions Sync
Sales Order Headers Sync
Contacts Sync
Item Sales Prices
X M L Item Sales Prices
X M L National Holidays
Active Employments
Assembly Orders
Budgets
Budget Scenarios
Communication Notes
Departments
Employment End Reasons
Employment Internal Rates
Employment Organizations
Employments
Employment Salaries
Exchange Rates
G L Transaction Types
Invoice Terms
Item Assortment
Item Assortment Property
Item Warehouse Planning Details
Item Warehouses
Job Groups
Job Titles
Lead Sources
Payment Conditions
Planned Sales Return Lines
Planned Sales Returns
Project Budget Types
Project Hour Budgets
Project Planning
Project Planning Recurring
Project Restriction Employees
Project Restriction Items
Project Restriction Rebillings
Sales Price List Linked Accounts
Sales Price List Periods
W B S Activities
W B S Deliverables
Sales Price Lists
Warehouses
Returns
Project W B S
Project Time Transactions
Hour Cost Types
Sales Invoice Order Charge Lines
Sales Order Order Charge Lines
Quotation Order Charge Lines
Order Charges
Bank Entries
Bank Entry Lines
X M L Bill Of Materials
Aging Payables List
Costunits
Opportunities
Task Types
Service Requests
Tasks
Journal Status By Financial Period
Workflow Request Attachments
Cashflow Allocation Rule
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed