FortNox

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

FortNox
Table Wayofdeliveries

FortNox
Table Financialyears

FortNox
Table Suppliers

FortNox
Table Supplierinvoices

FortNox
Table Salarytransactions

FortNox
Table Projects

FortNox
Table Pricelists

FortNox
Table Modesofpayments

FortNox
Table Expenses

FortNox
Table Employees

FortNox
Table Currencies

FortNox
Table Contracts

FortNox
Table Orders

FortNox
Table Accounts

FortNox
Table Articles

FortNox
Table Customers

FortNox
Table Offers

FortNox
Table Invoices

FortNox
Table Invoice Details

FortNox
Table Vouchers

FortNox
Table Voucher Rows

Use SQL on all your SaaS data

Magical SQL for FortNox 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.

Peliqan Ask AI willl write your SQL queries from plain English

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.