Page 5823 "G/L - Item Ledger Relation"
Base Application · Microsoft.Inventory.Ledger
Across versions
- BC23-30present
Neighbourhood 1 connected objects and pages
Base Application · Microsoft.Inventory.Ledger · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | G/L - Item Ledger Relation |
| SourceTable | G/L - Item Ledger Relation |
| PageType | List |
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 |
|---|---|---|---|
| Control1 | Posting Date | ValueEntry."Posting Date" |
Specifies the posting date that represents the relation. |
| Item No. | ValueEntry."Item No." |
Specifies the item number that represents the relation. | |
| Source Type | Format(ValueEntry."Source Type") |
Specifies the source type that represents the relation. | |
| Source No. | ValueEntry."Source No." |
Specifies the source number that represents the relation. | |
| External Document No. | ValueEntry."External Document No." |
Specifies a document number that refers to the customer’s or vendor’s numbering system. | |
| Document Type | Format(ValueEntry."Document Type") |
Specifies the type of document. | |
| Document No. | ValueEntry."Document No." |
Specifies the document that represents the relation. | |
| Document Line No. | ValueEntry."Document Line No." |
Specifies the document line number. | |
| Description | ValueEntry.Description |
Specifies a description of the document that represents the relation. | |
| Location Code | ValueEntry."Location Code" |
Specifies the location of the item. | |
| Inventory Posting Group | ValueEntry."Inventory Posting Group" |
Specifies the inventory posting group that represents the relation. | |
| Gen. Bus. Posting Group | ValueEntry."Gen. Bus. Posting Group" |
Specifies the general business posting group that represents the relation. | |
| Gen. Prod. Posting Group | ValueEntry."Gen. Prod. Posting Group" |
Specifies the general product posting group that represents the relation. | |
| Source Posting Group | ValueEntry."Source Posting Group" |
Specifies the source posting group that represents the relation. | |
| Item Ledger Entry Type | Format(ValueEntry."Item Ledger Entry Type") |
Specifies the item ledger entry type that represents the relation. | |
| Item Ledger Entry No. | ValueEntry."Item Ledger Entry No." |
Specifies the item ledger entry number that represents the relation. | |
| Valued Quantity | ValueEntry."Valued Quantity" |
Specifies the valued quantity that represents the relation. | |
| Item Ledger Entry Quantity | ValueEntry."Item Ledger Entry Quantity" |
Specifies the item ledger entry quantity that represents the relation. | |
| Invoiced Quantity | ValueEntry."Invoiced Quantity" |
Specifies the invoiced quantity that represents the relation. | |
| Cost per Unit | ValueEntry."Cost per Unit" |
Specifies the cost per unit that represents the relation. | |
| User ID | ValueEntry."User ID" |
Specifies the user who created the item ledger entry. | |
| Source Code | ValueEntry."Source Code" |
Specifies the source. | |
| Cost Amount (Actual) | ValueEntry."Cost Amount (Actual)" |
Specifies the sum of the actual cost amounts posted for the item ledger entries | |
| Cost Posted to G/L | ValueEntry."Cost Posted to G/L" |
Specifies the amount that has been posted to the general ledger. | |
| Cost Amount (Actual) (ACY) | ValueEntry."Cost Amount (Actual) (ACY)" |
Specifies the actual cost amount of the item. | |
| Cost Posted to G/L (ACY) | ValueEntry."Cost Posted to G/L (ACY)" |
Specifies the amount that has been posted to the general ledger shown in the additional reporting currency. | |
| Cost per Unit (ACY) | ValueEntry."Cost per Unit (ACY)" |
Specifies the cost per unit for the ledger entry. | |
| Global Dimension 1 Code | ValueEntry."Global Dimension 1 Code" |
Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | |
| Global Dimension 2 Code | ValueEntry."Global Dimension 2 Code" |
Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | |
| Expected Cost | ValueEntry."Expected Cost" |
Specifies the estimation of a purchased item’s cost that you record before you receive the invoice for the item. | |
| Item Charge No. | ValueEntry."Item Charge No." |
Specifies the number of the related item charge. | |
| Entry Type | Format(ValueEntry."Entry Type") |
Specifies the entry type that represents the relation. | |
| Variance Type | Format(ValueEntry."Variance Type") |
Specifies the type of variance, if any. | |
| Cost Amount (Expected) | ValueEntry."Cost Amount (Expected)" |
Specifies the expected cost amount of the item. Expected costs are calculated from yet non-invoiced documents. | |
| Cost Amount (Expected) (ACY) | ValueEntry."Cost Amount (Expected) (ACY)" |
Specifies the expected cost amount of the item. Expected costs are calculated from yet non-invoiced documents. | |
| Expected Cost Posted to G/L | ValueEntry."Expected Cost Posted to G/L" |
Specifies that the expected cost is posted to interim accounts at the time of receipt. | |
| Exp. Cost Posted to G/L (ACY) | ValueEntry."Exp. Cost Posted to G/L (ACY)" |
Specifies the expense cost that was posted. | |
| Variant Code | ValueEntry."Variant Code" |
Specifies the item variant, if any. | |
| Adjustment | ValueEntry.Adjustment |
Specifies the cost adjustment. | |
| Capacity Ledger Entry No. | ValueEntry."Capacity Ledger Entry No." |
Specifies the ledger entry number. | |
| Type | Format(ValueEntry.Type) |
Specifies the type of relation. | |
| G/L Entry No. | G/L Entry No. | Specifies the number of the general ledger entry where cost from the associated value entry number in this record is posted. from the table field | |
| Value Entry No. | Value Entry No. | Specifies the number of the value entry that has its cost posted in the associated general ledger entry in this record. from the table field | |
| G/L Register No. | G/L Register No. | Specifies the number of the general ledger register, where the general ledger entry in this record was posted. from the table field |
Actions
| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Value Entry | Dimensions | View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history. | |
| General Ledger | Open the general ledger. | ||
| Processing | Find entries… | Find entries and documents that exist for the document number and posting date on the selected document. (Formerly this action was named Navigate.) |
Procedures
1 local procedures, no public ones.
Triggers
OnAfterGetRecord
Relations
- source table Table 5823 “G/L - Item Ledger Relation”
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: "G/L - Item Ledger Relation"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.