Gluon ERP AI Assistant

Returns customer payment/recovery history: a summary (collectionCount, totalCollected, averageCollection) and the collections, newest first. Use it for questions like when a customer last paid, how much they paid this month, recovery history, or which invoices a collection settled. Pass detailAccountIds for specific customers; pass NO customer to get every customer of the tenant. Optional fromDate/toDate (inclusive) and paymentMethod (Cash, Bank or Other). A collection is an approved receipt (collectionType Receipt) or an approved cash/bank voucher that credits the customer and belongs to no receipt (collectionType Voucher). Each row has detailAccountId, customerName, collectionId, collectionNo, date, amount, paymentMethod, referenceNo, allocatedAmount, unallocatedAmount (the amount still available to adjust against invoices, as in the Invoice and Advance Adjustment screen) and allocatedInvoices (the invoices or vouchers a receipt settled directly: documentType, invoiceNo, allocatedAmount).

Returns all matching delivery masters without pagination. Resolve names with search_customers and pass detailAccountIds (DetailAccounts.Id). Filters: DC date, orderIds, paymentStatus. Quantity is actual delivered quantity. amount, paidAmount and outstandingAmount are the full totals of distinct linked invoices, calculated as in get_customer_invoices. recoveredAmount is an alias for paidAmount. Shared invoice totals repeat on each linked delivery; do not sum delivery rows as unique receivables. Invoice links use DCDetailId. Missing order links do not prevent invoice valuation; missing invoice links return null amount/outstanding/status. A lone fromDate is an upper cutoff; dates filter deliveries, not payments.

Returns order fulfillment totals and pending delivery value. Resolve customer names with search_customers and pass detailAccountIds. No pagination. Cancelled orders are excluded. Closed orders retain actual quantities but have zero pending value. Delivery quantities use the reference order-status formula and may exceed ordered quantities. Date filters select order dates, not an as-of delivery snapshot. A lone fromDate is an upper cutoff.

Returns one invoice with items and collections for one invoiceId (SalesInfos.Id, as returned by get_customer_invoices) or exact invoiceNo. Both supplied must match; ambiguous invoiceNo requires invoiceId. invoice: gross (CurrencyTradePrice * Quantity), discount (gross minus amount), taxAmount, net (CurrencyRate * Quantity plus line taxes), paidAmount (sum of NewReceiptDetails.CurrencyGrossAmount by SaleInfoId), outstandingAmount, paymentStatus (Unpaid, Partially Paid, Paid). Same formulas as get_customer_invoices. items: one row per invoice line; lineTotal is gross for the invoiced quantity; orderedQuantity/deliveredQuantity/remainingQuantity belong to the linked sales-order line (null when the line has no order link) and are not limited to this invoice. collections: receipts allocated to this invoice, one row per receipt voucher. Missing invoice returns invoice=null, items=[], collections=[].

Returns summary and all matching invoices without pagination. Resolve customer names with search_customers and pass detailAccountIds (DetailAccounts.Id, never Customers.Id). Invoice amount is the previous sales net formula: CurrencyRate * Quantity plus line taxes. paidAmount sums NewReceiptDetails.CurrencyGrossAmount by SaleInfoId; outstandingAmount is amount minus paidAmount. Status is Unpaid, Partially Paid or Paid. Payments are current, not restricted to the invoice date range. A lone fromDate is an inclusive upper cutoff. overdueOnly requires outstanding > 0 and DueDate before the current SQL Server date.

Returns order and items for one orderId or exact orderNo. Both supplied must match; ambiguous orderNo requires orderId. Includes gross, line discount, net, ordered/delivered/remaining quantities. Missing order returns order=null and items=[]. Closed status does not imply full delivery.

Returns Gluon ERP customer sales order status including ordered, delivered, invoiced, returned and pending quantities.

Returns summary and all customer order rows without pagination. Resolve customer names with search_customers and pass detailAccountIds (DetailAccounts.Id, never Customers.Id). Net amounts include detail taxes. Status is the master status with Close overriding IsClosed=true. Filters apply to OrderDate; delivery quantities are current, using the reference order-status formula. A lone fromDate is an upper cutoff.

Returns totalSales and all matching products with quantity, net salesAmount, contribution percent, invoiceCount and lastPurchaseDate. Filters: account IDs, dates, product/category IDs; selectable sort. Net sales uses CurrencyRate * Quantity plus CurrencyTaxAmount. No pagination. Omitted filters include all matching tenant data. detailAccountIds are ledger IDs; never pass Customers.Id. A lone fromDate is an upper cutoff.

Returns detailed Gluon ERP customer profile information.

Ranks the customers of the tenant by a business metric. Use it for top or bottom customers by sales, highest outstanding, most returns or highest collection. Required metric; optional fromDate/toDate (inclusive; toDate is also the reference date for Overdue and DaysSinceLastPurchase, default today), direction (Top or Bottom), cityIds, areaIds, productIds and limit (for example 10; omitted = every customer). productIds limits the sales, quantity, profit, order, invoice and return metrics to those products; it does not apply to Outstanding, Overdue or CollectionAmount. Metrics: NetSales (CurrencyRate x Quantity plus tax), GrossSales (Quantity x CurrencyTradePrice), Quantity, InvoiceCount (invoices), OrderCount (sales orders), AverageOrderValue (NetSales / OrderCount), CollectionAmount (receipts allocated to the invoices of the period), Outstanding (invoice net of the period minus those receipts), Overdue (overdue amount from the account summary as of toDate), ReturnAmount (sales returns incl. tax), ReturnPercent (ReturnAmount / NetSales x 100), GrossProfit (batch quantity x (CurrencyRate minus CostPrice)), DaysSinceLastPurchase (days since the latest approved purchase invoice booked against the account as vendor). Returns metric, total (the sum over all customers; overall average or percent for AverageOrderValue and ReturnPercent; null for DaysSinceLastPurchase) and rankings with rank, customerId (customer record id), detailAccountId, customerName, customerCode, value and contributionPercent (share of total; null for non-additive metrics).

Returns outstanding receivables grouped into aging buckets plus totalOutstanding, using the same outstanding amounts as get_customer_receivables. Use it for questions like how old the receivables are or how much is overdue. Pass customerIds/customerId/customerName for specific customers; pass NO customer to get every customer of the tenant. Optional asOfDate (default today). Without agingTemplateId or agingTemplateName the default buckets are used: Current (not yet overdue, due today included), 1-30, 31-60, 61-90 and 90+ days overdue. With a template (see list_receivable_aging_templates) the buckets are that template's day ranges measured in days overdue, preceded by Current for documents not yet due; a bucket 'Outside template ranges' appears only if the template leaves a gap. Each bucket has label, fromDays, toDays (null when open ended) and amount; zero buckets are included. Bucket amounts add up to totalOutstanding unless template ranges overlap.

Returns the outstanding receivable documents (unpaid and partially paid invoices and customer debit vouchers) and their total, using the same rules as the Invoice Wise Receivables report. Use it for questions like what a customer still owes, which invoices are unpaid, or all outstanding documents. Pass customerIds/customerId/customerName for specific customers; pass NO customer to get every customer of the tenant (do not ask the user for a customer first). Optional asOfDate (default today). Each receivable has detailAccountId, customerName, documentType (Invoice or Voucher), invoiceNo, invoiceDate, dueDate, invoiceAmount, receivedAmount (receipts plus invoice adjustments and sales returns, never more than the invoice amount), outstandingAmount, daysOutstanding (asOfDate minus invoice date), daysOverdue (0 when not yet overdue) and status (Not Due, Due Today or Overdue). Only documents with more than 1 outstanding are listed. totalOutstanding is the sum of outstandingAmount.

Returns totalCount, totalAmount and all matching invoice rows, including gross/net amounts and product/invoice/customer discounts. One row per invoice, not product line. Net amount is CurrencyRate * Quantity plus CurrencyTaxAmount. Filters: account IDs, dates, product/category IDs and exact documentNo. No pagination. Omitted filters include all matching tenant data. detailAccountIds are ledger IDs; never pass Customers.Id. A lone fromDate is an upper cutoff.

Returns summary and all matching sales returns without pagination. Resolve names with search_customers and pass detailAccountIds (DetailAccounts.Id). Filters: return date and productIds. Each return has returnId, returnNo, date, invoiceNo (original invoice(s) from the return lines' invoice links; comma-separated if several, null if unlinked), quantity and amount. Return amount is net: SalePrice * Quantity (or, when that is null or <= 0, Quantity * TradePrice minus DiscountAmount) plus line TaxAmount. productIds counts only matching return lines. summary: returnCount, returnQuantity, returnAmount (exactly the rows returned) and returnPercentOfSales = returnAmount / net sales * 100 over the same customers, dates and products, where net sales uses CurrencyRate * Quantity plus CurrencyTaxAmount as in get_customer_invoices; null when there are no sales. A lone fromDate is an upper cutoff.

Returns metric, groupBy, total, average, change percentages, trend points, highestPeriod and lowestPeriod. Filters: account IDs and dates. Metrics: NetSales, GrossSales, Quantity, InvoiceCount; groups: Day, Week, Month, Quarter, Year. Optional comparison to the preceding equal number of calendar days. No product/category filters. No pagination. Omitted filters include all matching tenant data. detailAccountIds are ledger IDs; never pass Customers.Id. A lone fromDate is an upper cutoff.

Returns a ledger-style customer statement for a date range from approved ledger vouchers: customerName, openingBalance (before fromDate), totalDebit, totalCredit, closingBalance (opening + debit - credit) and all transactions in date order with date, documentNo, documentType, description, debit, credit and runningBalance. Pass customerId/detailAccountId (or customerName) for one customer; pass no customer to get every customer of the tenant (totals are summed, each transaction carries detailAccountId and customerName, runningBalance is per customer). fromDate defaults to 30 days before toDate and toDate to today. No pagination.

Returns a compact Gluon ERP customer summary.

Lists the choices needed to create an expense: companies (companyId), currencies (currencyId) with baseCurrencyId, stations (stationId), expense accounts (accountId), Cash/Bank pay-from accounts (accountId, accountType) and payment types. Call it before create_expense to look up ids by name.

Returns compact Gluon ERP inventory totals and top products.

Returns Gluon ERP aging and outstanding receivable information.

Lists the choices needed to create a PDC (post-dated cheque): companies (companyId), currencies (currencyId) with baseCurrencyId, stations (stationId), bank names (bankNameId), active lockers (lockerId), cost centers (costCenterId) and cheque types. Call it before create_pdc to look up ids by name. Use search_customers to find the customer detailAccountId.

Lists the choices needed to create a customer receipt: companies (companyId), currencies (currencyId) with baseCurrencyId, stations (stationId), Cash/Bank deposit accounts (accountId, accountType) and payment types. Set includeBanks / includeEmployees / includeInvoices (invoices need companyId, currencyId, customerDetailAccountId) only when the user wants a bank, employee or invoice. Call it before create_customer_receipt to look up ids by name. Use search_customers to find the customer detailAccountId.

Returns paged recent Gluon ERP sales invoices with PII minimization.

Returns paged Gluon ERP sales invoice and detail rows with optional filters, pagination and aggregate output.

Returns compact Gluon ERP sales totals for a date range and optional sales filters.

Returns the authenticated Gluon ERP tenant subscription status.

Lists configured Gluon ERP receivable aging templates.

Resolves Gluon ERP sales filter names such as customer, company, station, cost center, product, employee, manager or warehouse into tenant-safe IDs.

Primary customer resolution tool: use when the user provides a name/code without a verified ID. Supports title search, exact customer IDs/codes, salesperson IDs, city/area IDs or names and Active/InActive status. Filters combine with AND; list values with OR. Returns totalCount and all matching customers. Ask which customer when multiple matches exist. customerId means Customers.Id; use detailAccountId for ledger reports. Does not support region/territory/channel or salesperson-name filters.