Skip to main content

Peliqan

Xero

Total Credit Notes

SQL query for Xero

Get the total amount of credit notes issued.

SELECT SUM(amount) AS total_credit_notes FROM CreditNotes

Xero data model

Xero
Accounts

Xero
Contacts

Xero
Credit Notes

Xero
Invoices

Xero
Items

Xero
Journals

Xero
Manual Journals

Xero
Payments

Xero
Payment Services

Xero
Purchase Orders

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.