Total supplier invoices per currency
SQL query for FortNox
Calculate the total supplier invoices for each currency.
SELECT currencies.name, SUM(supplierinvoices.amount) AS total_invoices FROM currencies JOIN supplierinvoices ON currencies.id = supplierinvoices.currency_id GROUP BY currencies.name
FortNox data model
Financialyears
Absencetransactions
Attendancetransactions
Accounts
Articles
Article Details
Company Information
Contracts
Currencies
Customers
Customer Details
Costcenters
Employees
Expenses
Incominggoods
Invoices
Invoice Details
Invoiceaccruals
Invoicepayments
Locked Period
Labels
Modesofpayments
Offers
Orders
Pricelists
Prices
Productionorders
Projects
Purchaseorders
Salarytransactions
Stockbalance
Stockpoints
Stocktaking
Suppliers
Supplierinvoices
Supplierinvoiceaccruals
Supplierinvoicefileconnections
Wayofdeliveries
Vouchers
Voucher Rows
Voucherseries
Account Charts
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