Total purchases by supplier
SQL query for Cin7 Core
Get the total purchase amount for each supplier.
SELECT supplier.name, SUM(outgoinginvoice.amount) AS total_purchases FROM supplier JOIN outgoinginvoice ON supplier.id = outgoinginvoice.supplier_id GROUP BY supplier.name
Cin7 Core data model
Attribute Set
Bank Accounts
Brands
Carriers
Chart Of Accounts
Crm Opportunity
Crm Leads
Customers
Customer Templates
Customer Credits
Deals
Discounts
Disassembly List
Finishedgoods List
Fixed Asset Type
Journal
Locations
Money Task List
Payment Terms
Price Tiers
Products
Product Attachments
Product Availability
Product Categories
Production Order List
Production Resource List
Production Workcenters
Purchase List
Sale List
Sale
Ship Zones
Stock Adjustment List
Stock Take List
Stock Transfer List
Stock Transfer Lines
Suppliers
Supplier Deposits
Tax List
Templates
Transactions
Units
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