Page 151 "Customer Statistics"

Base Application · Microsoft.Sales.Customer · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Customer Statistics
SourceTable	Customer
PageType	Card

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	CustomerSince	First Transaction Date	Specifies the date of the first transaction with the customer. from the table field
	Balance (LCY)	Balance (LCY)	Specifies the total amount the customer owes you, or you owe them, based on all sales and credits for the customer. A positive amount means they owe you, and a negative amount means you owe them. The amount isn’t necessarily due today though. The customer’s payment terms determine due dates. Select … from the table field
Sales	Outstanding Orders (LCY)	Outstanding Orders (LCY)	Specifies your expected sales income from the customer in LCY based on ongoing sales orders. from the table field
	Shipped Not Invoiced (LCY)	Shipped Not Invoiced (LCY)	Specifies your expected sales income from the customer in LCY based on ongoing sales orders where items have been shipped. from the table field
	Outstanding Invoices (LCY)	Outstanding Invoices (LCY)	Specifies your expected sales income from the customer in LCY based on unpaid sales invoices. from the table field
	Days Since Last Sale	`CalcDaysSinceLastSale()`	Specifies the number of days since the last sale was made to the customer.
General	Total (LCY)	`Rec.GetTotalAmountLCY()`	Specifies the payment amount that the customer owes for completed sales plus sales that are still ongoing.
	Credit Limit (LCY)	Credit Limit (LCY)	Specifies the maximum amount of credit that you extend to the customer for their purchases before you issue warnings. The value 0 represents unlimited credit. from the table field
	Balance Due (LCY)	`Rec.CalcOverdueBalance()`	—
	Invoiced Prepayment Amount (LCY)	`Rec.GetInvoicedPrepmtAmountLCY()`	Specifies your sales income from the customer based on invoiced prepayments.
This Fiscal Period	CustDateName[1]	`CustDateName[1]`	—
	Sales (LCY)	`CustSalesLCY[1]`	Specifies your total sales turnover in the fiscal year.
	Original Costs (LCY)	`CustSalesLCY[1] - CustProfit[1]`	Specifies the original costs that were associated with the sales when they were originally posted.
	Original Profit (LCY)	`CustProfit[1]`	Specifies the original profit that was associated with the sales when they were originally posted.
	Original Profit %	`ProfitPct[1]`	Specifies the original percentage of profit that was associated with the sales when they were originally posted.
	Adjusted Costs (LCY)	`CustSalesLCY[1] - CustProfit[1] - AdjmtCostLCY[1]`	Specifies the costs that have been adjusted for changes in the purchase prices of the goods.
	Adjusted Profit (LCY)	`AdjCustProfit[1]`	Specifies the profit, taking into consideration changes in the purchase prices of the goods.
	Adjusted Profit %	`AdjProfitPct[1]`	Specifies the percentage of profit for all sales, including changes that occurred in the purchase prices of the goods.
	Cost Adjmt. Amounts (LCY)	`-AdjmtCostLCY[1]`	Specifies the sum of the differences between original costs of the goods and the adjusted costs.
	Inv. Discounts (LCY)	`CustInvDiscAmountLCY[1]`	Specifies the sum of invoice discount amounts granted the customer.
	Inv. Amounts (LCY)	`InvAmountsLCY[1]`	Specifies the sum of amounts that have been invoiced to the customer.
	Reminder Amounts (LCY)	`CustReminderChargeAmtLCY[1]`	Specifies the sum of amounts that the customer has been reminded to pay.
	Fin. Charges (LCY)	`CustFinChargeAmtLCY[1]`	Specifies the sum of amounts that the customer has been charged on finance charge memos.
	Cr. Memo Amounts (LCY)	`CustCrMemoAmountsLCY[1]`	Specifies the sum of amounts that have been refunded to the customer.
	Payments (LCY)	`CustPaymentsLCY[1]`	Specifies the sum of payments received from the customer in the current fiscal year.
	Refunds (LCY)	`CustRefundsLCY[1]`	Specifies the sum of refunds paid to the customer.
	Other Amounts (LCY)	`CustOtherAmountsLCY[1]`	Specifies the sum of other amounts for the customer.
	Pmt. Discounts (LCY)	`CustPaymentDiscLCY[1]`	Specifies the sum of payment discounts granted to the customer.
	Pmt. Disc. Tol. (LCY)	`CustPaymentDiscTolLCY[1]`	Specifies the sum of payment discount tolerance for the customer.
	Pmt. Tolerances (LCY)	`CustPaymentTolLCY[1]`	Specifies the sum of payment tolerance for the customer.
	No. of Sales Docs.	`NumberOfSalesDocs[1]`	Specifies the number of sales documents for the customer.
	No. of Distinct Items Sold	`NumberOfDistinctItemsSold[1]`	Specifies the number of distinct items sold to the customer.
This Fiscal Year	Text001	`Text001`	—
	Sales (LCY)	`CustSalesLCY[2]`	Specifies your total sales turnover in the fiscal year.
	Original Costs (LCY)	`CustSalesLCY[2] - CustProfit[2]`	Specifies the original costs that were associated with the sales when they were originally posted.
	Original Profit (LCY)	`CustProfit[2]`	Specifies the original profit that was associated with the sales when they were originally posted.
	Original Profit %	`ProfitPct[2]`	Specifies the original percentage of profit that was associated with the sales when they were originally posted.
	Adjusted Costs (LCY)	`CustSalesLCY[2] - CustProfit[2] - AdjmtCostLCY[2]`	Specifies the costs that have been adjusted for changes in the purchase prices of the goods.
	Adjusted Profit (LCY)	`AdjCustProfit[2]`	Specifies the profit, taking into consideration changes in the purchase prices of the goods.
	Adjusted Profit %	`AdjProfitPct[2]`	Specifies the percentage of profit for all sales, including changes that occurred in the purchase prices of the goods.
	Adjustment Costs (LCY)	`-AdjmtCostLCY[2]`	Specifies the sum of adjustment amounts.
	Inv. Discounts (LCY)	`CustInvDiscAmountLCY[2]`	Specifies the sum of invoice discount amounts granted the customer.
	Inv. Amounts (LCY)	`InvAmountsLCY[2]`	Specifies the sum of amounts that have been invoiced to the customer.
	Reminder Amounts (LCY)	`CustReminderChargeAmtLCY[2]`	Specifies the sum of amounts that the customer has been reminded to pay.
	Fin. Charges (LCY)	`CustFinChargeAmtLCY[2]`	Specifies the sum of amounts that the customer has been charged on finance charge memos.
	Cr. Memo Amounts (LCY)	`CustCrMemoAmountsLCY[2]`	Specifies the sum of amounts that have been refunded to the customer.
	Payments (LCY)	`CustPaymentsLCY[2]`	Specifies the sum of payments received from the customer in the current fiscal year.
	Refunds (LCY)	`CustRefundsLCY[2]`	Specifies the sum of refunds paid to the customer.
	Other Amounts (LCY)	`CustOtherAmountsLCY[2]`	Specifies the sum of other amounts for the customer.
	Pmt. Discounts (LCY)	`CustPaymentDiscLCY[2]`	Specifies the sum of payment discounts granted to the customer.
	Pmt. Disc. Tolerance (LCY)	`CustPaymentDiscTolLCY[2]`	Specifies the sum of payment discount tolerance for the customer.
	Payment Tolerances (LCY)	`CustPaymentTolLCY[2]`	Specifies the sum of payment tolerance for the customer.
	No. of Sales Docs.	`NumberOfSalesDocs[2]`	Specifies the number of sales documents for the customer.
	No. of Distinct Items Sold	`NumberOfDistinctItemsSold[2]`	Specifies the number of distinct items sold to the customer.
Last Fiscal Year	Placeholder1	`Text001`	—
	Sales (LCY)	`CustSalesLCY[3]`	Specifies your total sales turnover in the fiscal year.
	Original Costs (LCY)	`CustSalesLCY[3] - CustProfit[3]`	Specifies the original costs that were associated with the sales when they were originally posted.
	Original Profit (LCY)	`CustProfit[3]`	Specifies the original profit that was associated with the sales when they were originally posted.
	Original Profit %	`ProfitPct[3]`	Specifies the original percentage of profit that was associated with the sales when they were originally posted.
	Adjusted Costs (LCY)	`CustSalesLCY[3] - CustProfit[3] - AdjmtCostLCY[3]`	Specifies the costs that have been adjusted for changes in the purchase prices of the goods.
	Adjusted Profit (LCY)	`AdjCustProfit[3]`	Specifies the profit, taking into consideration changes in the purchase prices of the goods.
	Adjusted Profit %	`AdjProfitPct[3]`	Specifies the percentage of profit for all sales, including changes that occurred in the purchase prices of the goods.
	Adjustment Costs (LCY)	`-AdjmtCostLCY[3]`	Specifies the sum of adjustment amounts.
	Inv. Discounts (LCY)	`CustInvDiscAmountLCY[3]`	Specifies the sum of invoice discount amounts granted the customer.
	Inv. Amounts (LCY)	`InvAmountsLCY[3]`	Specifies the sum of amounts that have been invoiced to the customer.
	Reminder Amounts (LCY)	`CustReminderChargeAmtLCY[3]`	Specifies the sum of amounts that the customer has been reminded to pay.
	Fin. Charges (LCY)	`CustFinChargeAmtLCY[3]`	Specifies the sum of amounts that the customer has been charged on finance charge memos.
	Cr. Memo Amounts (LCY)	`CustCrMemoAmountsLCY[3]`	Specifies the sum of amounts that have been refunded to the customer.
	Payments (LCY)	`CustPaymentsLCY[3]`	Specifies the sum of payments received from the customer in the current fiscal year.
	Refunds (LCY)	`CustRefundsLCY[3]`	Specifies the sum of refunds paid to the customer.
	Other Amounts (LCY)	`CustOtherAmountsLCY[3]`	Specifies the sum of other amounts for the customer.
	Pmt. Discounts (LCY)	`CustPaymentDiscLCY[3]`	Specifies the sum of payment discounts granted to the customer.
	Pmt. Disc. Tolerance (LCY)	`CustPaymentDiscTolLCY[3]`	Specifies the sum of payment discount tolerance for the customer.
	Payment Tolerances (LCY)	`CustPaymentTolLCY[3]`	Specifies the sum of payment tolerance for the customer.
	No. of Sales Docs.	`NumberOfSalesDocs[3]`	Specifies the number of sales documents for the customer.
	No. of Distinct Items Sold	`NumberOfDistinctItemsSold[3]`	Specifies the number of distinct items sold to the customer.
Lifetime (since)	CustSinceDate	First Transaction Date	Specifies the date of the first transaction with the customer. from the table field
	Sales (LCY)	`CustSalesLCY[4]`	Specifies your total sales turnover in the fiscal year.
	Original Costs (LCY)	`CustSalesLCY[4] - CustProfit[4]`	Specifies the original costs that were associated with the sales when they were originally posted.
	Original Profit (LCY)	`CustProfit[4]`	Specifies the original profit that was associated with the sales when they were originally posted.
	Original Profit %	`ProfitPct[4]`	Specifies the original percentage of profit that was associated with the sales when they were originally posted.
	Adjusted Costs (LCY)	`CustSalesLCY[4] - CustProfit[4] - AdjmtCostLCY[4]`	Specifies the costs that have been adjusted for changes in the purchase prices of the goods.
	Adjusted Profit (LCY)	`AdjCustProfit[4]`	Specifies the profit, taking into consideration changes in the purchase prices of the goods.
	Adjusted Profit %	`AdjProfitPct[4]`	Specifies the percentage of profit for all sales, including changes that occurred in the purchase prices of the goods.
	Adjustment Costs (LCY)	`-AdjmtCostLCY[4]`	Specifies the sum of adjustment amounts.
	Inv. Discounts (LCY)	`CustInvDiscAmountLCY[4]`	Specifies the sum of invoice discount amounts granted the customer.
	Inv. Amounts (LCY)	`InvAmountsLCY[4]`	Specifies the sum of amounts that have been invoiced to the customer.
	Reminder Amounts (LCY)	`CustReminderChargeAmtLCY[4]`	Specifies the sum of amounts that the customer has been reminded to pay.
	Fin. Charges (LCY)	`CustFinChargeAmtLCY[4]`	Specifies the sum of amounts that the customer has been charged on finance charge memos.
	Cr. Memo Amounts (LCY)	`CustCrMemoAmountsLCY[4]`	Specifies the sum of amounts that have been refunded to the customer.
	Payments (LCY)	`CustPaymentsLCY[4]`	Specifies the sum of payments received from the customer in the current fiscal year.
	Refunds (LCY)	`CustRefundsLCY[4]`	Specifies the sum of refunds paid to the customer.
	Other Amounts (LCY)	`CustOtherAmountsLCY[4]`	Specifies the sum of other amounts for the customer.
	Pmt. Discounts (LCY)	`CustPaymentDiscLCY[4]`	Specifies the sum of payment discounts granted to the customer.
	Pmt. Disc. Tolerance (LCY)	`CustPaymentDiscTolLCY[4]`	Specifies the sum of payment discount tolerance for the customer.
	Payment Tolerances (LCY)	`CustPaymentTolLCY[4]`	Specifies the sum of payment tolerance for the customer.
	No. of Sales Docs.	`NumberOfSalesDocs[4]`	Specifies the number of sales documents for the customer.
	No. of Distinct Items Sold	`NumberOfDistinctItemsSold[4]`	Specifies the number of distinct items sold to the customer.
Control1904230801	Placeholder2 obsolete Pending 27.0; #if not CLEAN27	`Text001`	—

Events published

OnAfterSetDateFilter(var Customer: Record Customer) (integration): Raises an event after setting the date filter on the customer record for statistics calculation.

Procedures

5 local procedures, no public ones.

Triggers

OnAfterGetRecord

Relations

source table Table 18 “Customer”

Extended by

Page extension 6489 “Serv. Customer Statistics”

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 358 “DateFilter-Calc” (2 calls: OnAfterGetRecord → CreateAccountingPeriodFilter, OnAfterGetRecord → CreateFiscalYearFilter)
Codeunit 5836 “Cost Calculation Management” (2 calls: OnAfterGetRecord → CalcCustActualCostLCY, OnAfterGetRecord → NonInvtblCostAmt)

Countries that replace it

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Customer Statistics"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.