Total expenses by cost unit
SQL query for Exact Online (Private app)
Calculate the total expenses for each cost unit.
SELECT Costunits.Name, SUM(GLAccounts.Amount) AS TotalExpenses FROM Costunits JOIN GLAccounts ON Costunits.ID = GLAccounts.CostunitID WHERE GLAccounts.Amount < 0 GROUP BY Costunits.Name
Exact Online (Private app) data model
Transactiontype
View 2 columns
NameString
NumberInteger
Glaccounttype
View 2 columns
NameString
NumberInteger
Entitytype
View 2 columns
NameString
NumberInteger
Divisions
Accounts
Sales Invoice Lines
Items
Costunits
Addresses
Bank Accounts
G L Accounts
Sales Invoices
Purchase Invoices
Purchase Invoice Lines
G L Classifications
Reporting Balance
Purchase Entries
Sales Entries
Document Attachments
Documents
Transaction Lines
Financial Periods
G L Account Classification Mappings
Aging Payables List
Payables List
Goods Deliveries Sync
Goods Deliveries
Goods Delivery Lines
Goods Delivery Lines Sync
Sales Orders
Sales Order Lines
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
Default Mailbox
Preferred Mailbox
Preferred Mailbox For Operation
Mailboxes
Mail Messages Sent
Mail Message Attachments
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 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
Supplier Item Sync
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
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
Hour Cost Types
X M L Bill Of Materials
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