Page 10041 "Sales Invoice Stats." (US)

US country layer · Microsoft.Sales.History · captioned “Sales Invoice Statistics” · BC29-30 · source at ea08af5e · facts from BC29

An object of the US localization, not part of W1.

Properties

Property	Value
Caption	Sales Invoice Statistics
SourceTable	Sales Invoice Header
PageType	ListPlus

Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).

Group	Control	Shows	ToolTip
General	Amount	`CustAmount + InvDiscAmount`	Specifies the transaction amount.
	Inv. Discount Amount	`InvDiscAmount`	Specifies the invoice discount amount for the entire sales document. If the Calc. Inv. Discount field in the Sales & Receivables Setup window is selected, the discount is automatically calculated.
	Total	`CustAmount`	Specifies the total amount less any invoice discount amount and exclusive of VAT for the posted document.
	Tax Amount	`TaxAmount`	Specifies the tax amount.
	Total Incl. Tax	`AmountInclTax`	Specifies the total amount, including tax, that has been posted as invoiced.
	Sales ($)	`AmountLCY`	Specifies the sales amount.
	Original Profit ($)	`ProfitLCY`	Specifies the profit, expressed as an amount, that was associated with the sales order when it was originally posted.
	Adjusted Profit ($)	`AdjProfitLCY`	Specifies the difference between the amounts in the Amount and Cost fields on the sales order.
	Original Profit %	`ProfitPct`	Specifies the profit, expressed as a percentage, that was associated with the sales order when it was originally posted.
	Adjusted Profit %	`AdjProfitPct`	Specifies the adjusted profit of the sales order expressed as a percentage.
	Quantity	`LineQty`	Specifies the item quantity.
	Parcels	`TotalParcels`	Specifies the number of parcels on the document.
	Net Weight	`TotalNetWeight`	Specifies the net weight of items on the sales order.
	Gross Weight	`TotalGrossWeight`	Specifies the gross weight of items on the document.
	Volume	`TotalVolume`	Specifies the volume of the invoiced items.
	Original Cost ($)	`CostLCY`	Specifies the original cost of the items on the sales document.
	Adjusted Cost ($)	`TotalAdjCostLCY`	Specifies the adjusted cost of the items on the sales order.
	Cost Adjmt. Amount ($)	`TotalAdjCostLCY - CostLCY`	Specifies the adjusted cost of the sales order based on the total adjusted cost, total sales, and unit cost.
	BreakdownTitle	label	—
	BreakdownAmt[1]	`BreakdownAmt[1]`	Specifies for the Sales Tax Breakdown: Print Description from Tax Jurisdiction and value
	BreakdownAmt[2]	`BreakdownAmt[2]`	Specifies for the Sales Tax Breakdown: Print Description from Tax Jurisdiction and value
	BreakdownAmt[3]	`BreakdownAmt[3]`	Specifies for the Sales Tax Breakdown: Print Description from Tax Jurisdiction and value
	BreakdownAmt[4]	`BreakdownAmt[4]`	Specifies for the Sales Tax Breakdown: Print Description from Tax Jurisdiction and value
Content	Subform	part Sales Tax Lines Subform	—
Customer	Balance ($)	`Cust."Balance (LCY)"`	Specifies the customer’s balance.
	Credit Limit ($)	`Cust."Credit Limit (LCY)"`	Specifies the customer’s credit limit.
	Expended % of Credit Limit ($)	`CreditLimitLCYExpendedPct`	Specifies how must of the customer’s credit is used, expressed as a percentage of the credit limit.

Events published

OnAfterCalculateSalesTax(var SalesInvoiceLine: Record "Sales Invoice Line"; var SalesTaxAmountLine: Record "Sales Tax Amount Line"; var SalesTaxAmountLine2: Record "Sales Tax Amount Line"; var SalesTaxCalculationOverridden: Boolean) (integration)
OnAfterGetRecordOnAfterSalesInvLineLoopIteration(var SalesInvoiceLine: Record "Sales Invoice Line"; SalesInvoiceHeader: Record "Sales Invoice Header"; var CustAmount: Decimal; var AmountInclTax: Decimal; var InvDiscAmount: Decimal; var CostLCY: Decimal; var TotalAdjCostLCY: Decimal; var LineQty: Decimal; var TotalNetWeight: Decimal; var TotalGrossWeight: Decimal; var TotalVolume: Decimal; var TotalParcels: Decimal) (integration)

Triggers

OnAfterGetRecord

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Sales Invoice Stats."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A US country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.