Outstanding payments
SQL query for Cin7 Omni
Identify outstanding payments that are yet to be received.
SELECT SUM(amount_due) AS total_outstanding_payments FROM sales_orders WHERE status = ‘unpaid’
Cin7 Omni data model
Adjustments
Branches
Branch Transfers
Bom Masters
Contacts
Credit Notes
Payments
Products
Product Categories
Production Jobs
Purchase Orders
Quotes
Sales Orders
Serial Numbers
Size Ranges
Stocks
Users
Vouchers
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