BC Observatoryunofficial, made by waldo
tableInventoryofficial - Microsoftderived - from the source, no model text

Table 339 "Item Application Entry"

Base Application · Microsoft.Inventory.Ledger

Open in Claude339.mdSource on GitHub

Across versions

  1. BC23present
  2. BC242 procedures added, 2 events added
  3. BC258 procedures changed, 2 procedures added
  4. BC265 fields added, 3 procedures added
  5. BC279 procedures added, 1 procedures removed
  6. BC2813 fields changed, 6 procedures added
  7. BC29unchanged
  8. BC301 procedures removed

Neighbourhood 10 connected objects and pages

Table 32 "Item Ledger Entry" (relates to, 7 links)Item Ledger EntryTable 46 "Item Register" (relates to)Item RegisterTable 5802 "Value Entry" (relates to)Value EntryPage 506 "Item Application Entries" (pages and codeunits on it, 3 links)Item Application EntriesCodeunit 5849 "Avg. Cost Entry Point Handler" (calls)Avg. Cost Entry Point HandlerCodeunit 703 "Find Record Management" (calls)Find Record ManagementCodeunit 9500 "Sequence No. Mgt." (calls)Sequence No. Mgt.Table 32 "Item Ledger Entry" (referenced by)Item Ledger EntryTable 83 "Item Journal Line" (referenced by)Item Journal LineRemove and reapply item entries (Learn pages)Remove and reapply item entr…

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Learn documents this table through its pages: Page 506 “Item Application Entries” (1 Learn page).

Properties

Property Value
Caption Item Application Entry
DataClassification CustomerContent
Permissions TableData “Item Application Entry” = rim, TableData “Item Application Entry History” = ri

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Entry No. Δ BC28 Integer Specifies the number of the entry, as assigned from the specified number series when the entry was created.
2 Item Ledger Entry No. Δ BC28 Integer Specifies one or more item application entries for each inventory transaction that is posted. TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
3 Inbound Item Entry No. Δ BC28 Integer Specifies the number of the item ledger entry corresponding to the inventory increase or positive quantity in inventory. TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
4 Outbound Item Entry No. Δ BC28 Integer Specifies the number of the item ledger entry corresponding to the inventory decrease for this entry. TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
11 Quantity Δ BC28 Decimal Specifies the quantity of the item that is being applied from the inventory decrease in the Outbound Item Entry No. field, to the inventory increase in the Inbound Item Entry No. field.
20 Item Register No. + BC26 Integer — TableRelation Table 46 “Item Register” (Item Register); not editable
21 Posting Date Δ BC28 Date Specifies the posting date that corresponds to the posting date of the item ledger entry, for which this item application entry was created.
23 Transferred-from Entry No. Δ BC28 Integer Specifies the item ledger entry number of the original inventory increase of the item if the item application entry originates from a transfer. TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
25 Creation Date DateTime —
26 Created By User Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
27 Last Modified Date DateTime —
28 Last Modified By User Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
101 Item No. + BC26 Δ BC28 Code[20] Specifies the item number FlowField: lookup(“Item Ledger Entry”.“Item No.” where(“Entry No.” = field(“Item Ledger Entry No.”))); not editable
102 Location Code + BC26 Δ BC28 Code[10] Specifies the location code FlowField: lookup(“Item Ledger Entry”.“Location Code” where(“Entry No.” = field(“Item Ledger Entry No.”))); not editable
103 Variant Code + BC26 Δ BC28 Code[10] Specifies the variant code of the item. FlowField: lookup(“Item Ledger Entry”.“Variant Code” where(“Entry No.” = field(“Item Ledger Entry No.”))); not editable
111 Latest Valuation Date + BC26 Δ BC28 Date Specifies the latest valuation date of the item ledger entry. FlowField: max(“Value Entry”.“Valuation Date” where(“Item Ledger Entry No.” = field(“Item Ledger Entry No.”))); not editable
5800 Cost Application Δ BC28 Boolean Specifies that the application entry should have the cost forwarded or simply included in an average cost calculation.
5804 Output Completely Invd. Date Date —
5805 Outbound Entry is Updated Δ BC28 Boolean Specifies that the cost of the related outbound item entry is already updated. If the field is selected, then the cost adjustment routine will not try to update any previous related outbound entries.

Keys

  • Key1: Entry No. (clustered)
  • Key2: Posting Date, Inbound Item Entry No., Item Ledger Entry No., Outbound Item Entry No., Cost Application
  • Key3: Outbound Item Entry No., Item Ledger Entry No., Cost Application, Transferred-from Entry No.
  • Key4: Transferred-from Entry No., Cost Application
  • Key5: Inbound Item Entry No., Outbound Item Entry No., Cost Application
  • Key6: Item Ledger Entry No., Output Completely Invd. Date
  • Key9: Inbound Item Entry No., Transferred-from Entry No., Item Ledger Entry No.
  • Key10: Inbound Item Entry No., Item Ledger Entry No., Outbound Item Entry No., Cost Application

Events published

  • OnBeforeFixed(ItemApplicationEntry: Record "Item Application Entry"; var Result: Boolean; var IsHandled: Boolean) (integration)
  • OnSetInboundToUpdatedOnAfterSetFilters(var ItemApplicationEntry: Record "Item Application Entry") + BC24 (integration)
  • OnBeforeCheckCyclicProdCyclicalLoop(var ItemApplicationEntry: Record "Item Application Entry"; CheckItemLedgerEntry: Record "Item Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry"; var Result: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeCheckCyclicAsmCyclicalLoop(var ItemApplicationEntry: Record "Item Application Entry"; CheckItemLedgerEntry: Record "Item Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry"; var Result: Boolean; var IsHandled: Boolean) + BC26 (integration)
  • OnSetOutboundsNotUpdatedOnAfterSetFilters(var ItemApplicationEntry: Record "Item Application Entry") + BC24 (integration)
  • OnCheckIsCyclicalLoopOnBeforeCheckCyclicForwardToAppliedInbounds(CheckItemLedgEntry: Record "Item Ledger Entry"; FromItemLedgEntry: Record "Item Ledger Entry"; MaxValuationDate: Date; var IsCyclicalLoop: Boolean) + BC25 (integration)
  • OnCheckCyclicFwdToAppliedEntriesOnAfterCheckItemApplicationEntry(CheckItemLedgerEntry: Record "Item Ledger Entry"; ToEntryNo: Integer; IsPositiveToNegativeFlow: Boolean; var IsCyclicalLoop: Boolean) + BC25 (integration)

Procedures

  • GetNextEntryNo(): Integer + BC26
  • GetLastEntryNo(): Integer Δ BC26
  • AppliedOutbndEntryExists(InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean; FilterOnOnlyCostNotAdjusted: Boolean): Boolean + BC27 + BC27
  • AppliedOutbndEntryExists(var ItemApplicationEntries: Query "Item Application Entries"; InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean; FilterOnOnlyCostNotAdjusted: Boolean): Boolean + BC27 + BC27 (obsolete 28.0: Replaced with namesake procedure with “Item Application Entries Outb.” as parameter.)
  • AppliedOutbndEntryExists(var ItemApplicationEntriesOutb: Query "Item Application Entries Outb."; InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean; FilterOnOnlyCostNotAdjusted: Boolean): Boolean + BC27 + BC27
  • AppliedInbndTransEntryExists(InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean + BC27
  • AppliedInbndTransEntryExists(var ItemApplicationEntries: Query "Item Application Entries"; InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean + BC27
  • AppliedInbndEntryExists(OutbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean + BC27 + BC27
  • AppliedInbndEntryExists(var ItemApplicationEntries: Query "Item Application Entries"; OutbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean + BC27 + BC27 (obsolete 28.0: Replaced with namesake procedure with “Item Application Entries Inb.” as parameter.)
  • AppliedInbndEntryExists(var ItemApplicationEntriesInb: Query "Item Application Entries Inb."; OutbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean + BC27 + BC27
  • AppliedFromEntryExists(InbndItemLedgEntryNo: Integer): Boolean
  • GetInboundEntriesTheOutbndEntryAppliedTo(OutbndItemLedgEntryNo: Integer): Boolean
  • GetOutboundEntriesAppliedToTheInboundEntry(InbndItemLedgEntryNo: Integer): Boolean
  • CheckAppliedFromEntryToAdjust(InbndItemLedgEntryNo: Integer)
  • CostReceiver(): Integer
  • Fixed(): Boolean
  • InsertHistory(): Integer
  • CostApplication(): Boolean
  • CheckIsCyclicalLoop(CheckItemLedgEntry: Record "Item Ledger Entry"; FromItemLedgEntry: Record "Item Ledger Entry"): Boolean
  • GetVisitedEntries(FromItemLedgEntry: Record "Item Ledger Entry"; var ItemLedgEntryInChain: Record "Item Ledger Entry"; WithinValuationDate: Boolean)
  • OutboundApplied(EntryNo: Integer; SameType: Boolean): Decimal
  • InboundApplied(EntryNo: Integer; SameType: Boolean): Decimal
  • Returned(EntryNo: Integer): Decimal
  • ExistsBetween(ILE1: Integer; ILE2: Integer): Boolean
  • SetOutboundsNotUpdated(ItemLedgEntry: Record "Item Ledger Entry")
  • SetInboundToUpdated(ItemLedgEntry: Record "Item Ledger Entry")
  • IsAppliedFromIncrease(InbndItemLedgEntryNo: Integer): Boolean
  • IsOutbndItemApplEntryCostApplication(OutboundItemLedgEntryNo: Integer): Boolean
  • SetSearchedItemLedgerEntry(var ItemLedgerEntry: Record "Item Ledger Entry") + BC24 Δ BC26 − BC30 (obsolete 27.0: The optimization that used this function was obsoleted.)
  • SetCostApplication(NewCostApplication: Boolean) + BC26

Plus 21 local procedures.

Relations

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

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.

Recent changes

Countries that replace it

RU

Deprecations

  • procedure SetSearchedItemLedgerEntry: Pending 27.0 (#if not CLEAN27), “The optimization that used this function was obsoleted.”
  • procedure AppliedInbndEntryExists: Pending 28.0 (#if not CLEAN28), “Replaced with namesake procedure with “Item Application Entries Inb.” as parameter.”
  • procedure AppliedOutbndEntryExists: Pending 28.0 (#if not CLEAN28), “Replaced with namesake procedure with “Item Application Entries Outb.” as parameter.”

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

Evidence 1 sources