Page 304 "Item Entry Statistics"

Base Application · Microsoft.Inventory.Item · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Item Entry Statistics
SourceTable	Item
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	Receipt	`ItemLedgEntry[5]."Posting Date"`	Specifies item ledger entries that are related to purchase receipts.
	Purchases	`ValueEntry[1]."Posting Date"`	Specifies item ledger entries that are related to purchases.
	Positive Adjustment	`ItemLedgEntry[3]."Posting Date"`	Specifies item ledger entries that are related to positive adjustment through an inventory journal.
	Shipment	`ItemLedgEntry[6]."Posting Date"`	Specifies item ledger entries that are related to sales shipments.
	Sales	`ValueEntry[2]."Posting Date"`	Specifies item ledger entries that are related to sales.
	Negative Adjustment	`ItemLedgEntry[4]."Posting Date"`	Specifies item ledger entries that are related to negative adjustment through an inventory journal.
Document No.	Document No.	`ItemLedgEntry[5]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`ValueEntry[1]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`ItemLedgEntry[3]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`ItemLedgEntry[6]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`ValueEntry[2]."Document No."`	Specifies the number of the document that the statistic is based on.
	Document No.	`ItemLedgEntry[4]."Document No."`	Specifies the number of the document that the statistic is based on.
Quantity	Quantity	`ValueEntry[5]."Valued Quantity"`	Specifies the total quantity of items in the entry.
	Quantity	`ValueEntry[1]."Invoiced Quantity"`	Specifies the total quantity of items in the entry.
	Quantity	`ItemLedgEntry[3].Quantity`	Specifies the total quantity of items in the entry.
	Quantity	`-ValueEntry[6]."Valued Quantity"`	Specifies the total quantity of items in the entry.
	Quantity	`-ValueEntry[2]."Invoiced Quantity"`	Specifies the total quantity of items in the entry.
	Quantity	`-ItemLedgEntry[4].Quantity`	Specifies the total quantity of items in the entry.
Unit Amount	Unit Amount	`UnitAmount[5]`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`UnitAmount[1]`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`UnitAmount[3]`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`UnitAmount[6]`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`UnitAmount[2]`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`UnitAmount[4]`	Specifies the value per unit on the item ledger entry.
Discount Amount	Amount	`ValueEntry[5]."Discount Amount"`	Specifies the net amount of all the lines in the item entry.
	Amount	`ValueEntry[1]."Discount Amount"`	Specifies the net amount of all the lines in the item entry.
	Amount	`ValueEntry[3]."Discount Amount"`	Specifies the net amount of all the lines in the item entry.
	Amount	`-ValueEntry[6]."Discount Amount"`	Specifies the net amount of all the lines in the item entry.
	Amount	`-ValueEntry[2]."Discount Amount"`	Specifies the net amount of all the lines in the item entry.
	Amount	`-ValueEntry[4]."Discount Amount"`	Specifies the net amount of all the lines in the item entry.
Amount	Amount	`ValueEntry[5]."Cost Amount (Actual)"`	Specifies the net amount of all the lines in the item entry.
	Amount	`ValueEntry[1]."Cost Amount (Actual)"`	Specifies the net amount of all the lines in the item entry.
	Amount	`ValueEntry[3]."Cost Amount (Actual)"`	Specifies the net amount of all the lines in the item entry.
	Amount	`ValueEntry[6]."Sales Amount (Actual)"`	Specifies the net amount of all the lines in the item entry.
	Amount	`ValueEntry[2]."Sales Amount (Actual)"`	Specifies the net amount of all the lines in the item entry.
	Amount	`-ValueEntry[4]."Cost Amount (Actual)"`	Specifies the net amount of all the lines in the item entry.
Date	Next Receipt	`PurchOrderLine[1]."Expected Receipt Date"`	Specifies information for the next expected receipt of the item.
	Last Receipt	`PurchOrderLine[2]."Expected Receipt Date"`	Specifies information about the last receipt that was posted for the item.
	Next Shipment	`SalesLine[1]."Shipment Date"`	Specifies information about the next shipment that is expected for the item.
	Last Shipment	`SalesLine[2]."Shipment Date"`	Specifies information about the last shipment that was posted for the item.
Order No.	Order No.	`PurchOrderLine[1]."Document No."`	Specifies the number of the order that the item was handled on.
	Order No.	`PurchOrderLine[2]."Document No."`	Specifies the number of the order that the item was handled on.
	Order No.	`SalesLine[1]."Document No."`	Specifies the number of the order that the item was handled on.
	Order No.	`SalesLine[2]."Document No."`	Specifies the number of the order that the item was handled on.
Quantity	Quantity	`PurchOrderLine[1].Quantity`	Specifies the total quantity of items in the entry.
	Quantity	`PurchOrderLine[2].Quantity`	Specifies the total quantity of items in the entry.
	Quantity	`SalesLine[1].Quantity`	Specifies the total quantity of items in the entry.
	Quantity	`SalesLine[2].Quantity`	Specifies the total quantity of items in the entry.
Unit Amount	Unit Amount	`PurchOrderLine[1]."Direct Unit Cost"`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`PurchOrderLine[2]."Direct Unit Cost"`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`SalesLine[1]."Unit Price"`	Specifies the value per unit on the item ledger entry.
	Unit Amount	`SalesLine[2]."Unit Price"`	Specifies the value per unit on the item ledger entry.
Qty. on Order	Qty. on Order	`PurchOrderLine[1]."Outstanding Quantity"`	Specifies the quantity on the order that the item was handled on.
	Qty. on Order	`PurchOrderLine[2]."Outstanding Quantity"`	Specifies the quantity on the order that the item was handled on.
	Qty. on Order	`SalesLine[1]."Outstanding Quantity"`	Specifies the quantity on the order that the item was handled on.
	Qty. on Order	`SalesLine[2]."Outstanding Quantity"`	Specifies the quantity on the order that the item was handled on.

Procedures

2 local procedures, no public ones.

Triggers

OnAfterGetRecord

Relations

source table Table 27 “Item”

Documented on Microsoft Learn

Set Up Bank Data Conversion

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