Page 302 "Customer Entry Statistics"

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

Properties

Property	Value
Caption	Customer Entry 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
Date	Payment	`CustLedgEntry[1]."Posting Date"`	Specifies the amount that relates to payments.
	Invoice	`CustLedgEntry[2]."Posting Date"`	Specifies the amount that relates to invoices.
	Credit Memo	`CustLedgEntry[3]."Posting Date"`	Specifies the amount that relates to credit memos.
	Reminder	`CustLedgEntry[5]."Posting Date"`	Specifies the amount that relates to reminders.
	Finance Charge Memo	`CustLedgEntry[4]."Posting Date"`	Specifies the amount that relates to finance charge memos.
	Refund	`CustLedgEntry[6]."Posting Date"`	Specifies the amount that relates to refunds.
Document No.	Document No.	`CustLedgEntry[1]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`CustLedgEntry[2]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`CustLedgEntry[3]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`CustLedgEntry[5]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`CustLedgEntry[4]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`CustLedgEntry[6]."Document No."`	Specifies the number of the document that the statistic is based on.
Currency Code	Currency Code	`CustLedgEntry[1]."Currency Code"`	Specifies the code for the currency that amounts are shown in.
	Currency Code	`CustLedgEntry[2]."Currency Code"`	Specifies the code for the currency that amounts are shown in.
	Currency Code	`CustLedgEntry[3]."Currency Code"`	Specifies the code for the currency that amounts are shown in.
	Currency Code	`CustLedgEntry[5]."Currency Code"`	Specifies the code for the currency that amounts are shown in.
	Currency Code	`CustLedgEntry[4]."Currency Code"`	Specifies the code for the currency that amounts are shown in.
	Currency Code	`CustLedgEntry[6]."Currency Code"`	Specifies the code for the currency that amounts are shown in.
Amount	Amount	`-CustLedgEntry[1].Amount`	Specifies the net amount of all the lines in the customer entry.
	Amount	`CustLedgEntry[2].Amount`	Specifies the net amount of all the lines in the customer entry.
	Amount	`-CustLedgEntry[3].Amount`	Specifies the net amount of all the lines in the customer entry.
	Amount	`CustLedgEntry[5].Amount`	Specifies the net amount of all the lines in the customer entry.
	Amount	`CustLedgEntry[4].Amount`	Specifies the net amount of all the lines in the customer entry.
	Amount	`CustLedgEntry[6].Amount`	Specifies the net amount of all the lines in the customer entry.
Remaining Amount	Remaining Amount	`-CustLedgEntry[1]."Remaining Amount"`	Specifies the net remaining amount of all the lines in the customer entry.
	Remaining Amount	`CustLedgEntry[2]."Remaining Amount"`	Specifies the net remaining amount of all the lines in the customer entry.
	Remaining Amount	`-CustLedgEntry[3]."Remaining Amount"`	Specifies the net remaining amount of all the lines in the customer entry.
	Remaining Amount	`CustLedgEntry[5]."Remaining Amount"`	Specifies the net remaining amount of all the lines in the customer entry.
	Remaining Amount	`CustLedgEntry[4]."Remaining Amount"`	Specifies the net remaining amount of all the lines in the customer entry.
	Remaining Amount	`CustLedgEntry[6]."Remaining Amount"`	Specifies the net remaining amount of all the lines in the customer entry.
This Period	CustDateName[1]	`CustDateName[1]`	—
	Payments	`NoOfDoc[1] [1]`	Specifies the amount that relates to payments.
	Invoices	`NoOfDoc[1] [2]`	Specifies the amount that relates to invoices.
	Credit Memos	`NoOfDoc[1] [3]`	Specifies the amount that relates to credit memos.
	Reminder	`NoOfDoc[1] [5]`	Specifies the amount that relates to reminders.
	Finance Charge Memos	`NoOfDoc[1] [4]`	Specifies the amount that relates to finance charge memos.
	Refund	`NoOfDoc[1] [6]`	Specifies the amount that relates to refunds.
	Avg. Collection Period (Days)	`AvgDaysToPay[1]`	Specifies the time it usually takes to collect payment from the customer. The value is determined by subtracting the posting dates from the corresponding payment dates and dividing the total by the number of invoices.
	Largest Balance (LCY)	`HighestBalanceLCY[1]`	Specifies the largest balance that the customer has had.
This Year	Text000	`Text000`	—
	Payments	`NoOfDoc[2] [1]`	Specifies the amount that relates to payments.
	Invoices	`NoOfDoc[2] [2]`	Specifies the amount that relates to invoices.
	Credit Memos	`NoOfDoc[2] [3]`	Specifies the amount that relates to credit memos.
	Reminder	`NoOfDoc[2] [5]`	Specifies the amount that relates to reminders.
	Finance Charge Memos	`NoOfDoc[2] [4]`	Specifies the amount that relates to finance charge memos.
	Refund	`NoOfDoc[2] [6]`	Specifies the amount that relates to refunds.
	Avg. Collection Period (Days)	`AvgDaysToPay[2]`	Specifies the time it usually takes to collect payment from the customer. The value is determined by subtracting the posting dates from the corresponding payment dates and dividing the total by the number of invoices.
	Largest Balance	`HighestBalanceLCY[2]`	Specifies the largest balance that the customer has had.
Last Year	Placeholder2	`Text000`	—
	Payments	`NoOfDoc[3] [1]`	Specifies the amount that relates to payments.
	Invoices	`NoOfDoc[3] [2]`	Specifies the amount that relates to invoices.
	Credit Memos	`NoOfDoc[3] [3]`	Specifies the amount that relates to credit memos.
	Reminder	`NoOfDoc[3] [5]`	Specifies the amount that relates to reminders.
	Finance Charge Memos	`NoOfDoc[3] [4]`	Specifies the amount that relates to finance charge memos.
	Refund	`NoOfDoc[3] [6]`	Specifies the amount that relates to refunds.
	Avg. Collection Period (Days)	`AvgDaysToPay[3]`	Specifies the time it usually takes to collect payment from the customer. The value is determined by subtracting the posting dates from the corresponding payment dates and dividing the total by the number of invoices.
	Largest Balance	`HighestBalanceLCY[3]`	Specifies the largest balance that the customer has had.
Remaining Amt. (LCY)	Placeholder3	`Text000`	—
	Remaining Amt. (LCY)	`-TotalRemainAmountLCY[1]`	Specifies the amount that remains to be paid.
	Remaining Amt. (LCY)	`TotalRemainAmountLCY[2]`	Specifies the amount that remains to be paid.
	Remaining Amt. (LCY)	`-TotalRemainAmountLCY[3]`	Specifies the amount that remains to be paid.
	Remaining Amt. (LCY)	`TotalRemainAmountLCY[5]`	Specifies the amount that remains to be paid.
	Remaining Amt. (LCY)	`TotalRemainAmountLCY[4]`	Specifies the amount that remains to be paid.
	Remaining Amt. (LCY)	`TotalRemainAmountLCY[6]`	Specifies the amount that remains to be paid.
	Placeholder4	`Text000`	—
	Placeholder5	`Text000`	—

Events published

OnAfterGetRecordOnAfterCustLedgEntrySetFiltersCalcAmount(var CustLedgerEntry: Record "Cust. Ledger Entry") (integration): Raised after setting filters on customer ledger entries for amount calculation.
OnAfterGetRecordOnAfterCustLedgEntrySetFiltersCalcRemainingAmountLCY(var CustLedgerEntry: Record "Cust. Ledger Entry") (integration): Raised after setting filters on customer ledger entries for remaining amount calculation.
OnAfterGetRecordOnAfterCustLedgEntrySetFiltersCalcDaysToPay(var CustLedgerEntry: Record "Cust. Ledger Entry") (integration): Raised after setting filters on customer ledger entries for days to pay calculation.

Procedures

1 local procedures, no public ones.

Triggers

OnAfterGetRecord

Relations

source table Table 18 “Customer”

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)

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 Entry Statistics"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.