SalesInvoiceTotal
Aggregated per-currency totals for sales invoices within a requested date range. One row per distinct “CurrencyIso” value found among the matching invoices; a currency with no matching invoices in the range produces no row.
SalesInvoiceTotalFields
ISO code of the currency this row aggregates. Taken from "CurrencyIso" of "SalesInvoiceListItem"; one row per distinct value found among the invoices in range.
Sum of "TotalGrossAmount" (see "SalesInvoiceListItem") across every sales invoice dated within ["From", "To"] whose "CurrencyIso" matches this row. The per-invoice values are summed unrounded; no per-invoice rounding is applied before summation.
Sum of "TotalNetAmount" (see "SalesInvoiceListItem") across every sales invoice dated within ["From", "To"] whose "CurrencyIso" matches this row. Summed unrounded, the same way as "TotalGrossAmount".
"TotalGrossAmount" minus "TotalNetAmount", computed once per currency group after both sums are formed. This is not the sum of the per-invoice VAT amounts, and neither "TotalGrossAmount" nor "TotalNetAmount" is rounded per invoice before the subtraction.
Number of sales invoices dated within ["From", "To"] whose "CurrencyIso" matches this row, counted over the same invoice set whose amounts are summed into "TotalGrossAmount" and "TotalNetAmount".
Was this page helpful?