Table "Item Application Entry"
ID 339
Namespace: Microsoft.Inventory.Ledger
Properties
Fields
| Name |
Type |
Description |
| "Entry No." |
Integer
|
Specifies the number of the entry, as assigned from the specified number series when the entry was created.
|
| "Item Ledger Entry No." |
Integer
|
Specifies one or more item application entries for each inventory transaction that is posted.
|
| "Inbound Item Entry No." |
Integer
|
Specifies the number of the item ledger entry corresponding to the inventory increase or positive quantity in inventory.
|
| "Outbound Item Entry No." |
Integer
|
Specifies the number of the item ledger entry corresponding to the inventory decrease for this entry.
|
| Quantity |
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.
|
| "Item Register No." |
Integer
|
|
| "Posting Date" |
Date
|
Specifies the posting date that corresponds to the posting date of the item ledger entry, for which this item application entry was created.
|
| "Transferred-from Entry No." |
Integer
|
Specifies the item ledger entry number of the original inventory increase of the item if the item application entry originates from a transfer.
|
| "Creation Date" |
DateTime
|
|
| "Created By User" |
Code[50]
|
|
| "Last Modified Date" |
DateTime
|
|
| "Last Modified By User" |
Code[50]
|
|
| "Item No." |
Code[20]
|
Specifies the item number
|
| "Location Code" |
Code[10]
|
Specifies the location code
|
| "Variant Code" |
Code[10]
|
Specifies the variant code of the item.
|
| "Latest Valuation Date" |
Date
|
Specifies the latest valuation date of the item ledger entry.
|
| "Cost Application" |
Boolean
|
Specifies that the application entry should have the cost forwarded or simply included in an average cost calculation.
|
| "Output Completely Invd. Date" |
Date
|
|
| "Outbound Entry is Updated" |
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.
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemCreatedByUserName |
Text[50]
|
|
| SystemCreatedByFullName |
Text[80]
|
|
| SystemModifiedByUserName |
Text[50]
|
|
| SystemModifiedByFullName |
Text[80]
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
GetNextEntryNo
[InherentPermissions(TableData,339,r)]
procedure GetNextEntryNo(): Integer
Returns
GetLastEntryNo
[InherentPermissions(TableData,339,r)]
procedure GetLastEntryNo(): Integer
Returns
AppliedOutbndEntryExists
procedure AppliedOutbndEntryExists(InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean; FilterOnOnlyCostNotAdjusted: Boolean): Boolean
Parameters
| Name |
Type |
Description |
|
InbndItemLedgEntryNo
|
Integer |
|
|
IsCostApplication
|
Boolean |
|
|
FilterOnOnlyCostNotAdjusted
|
Boolean |
|
Returns
AppliedOutbndEntryExists
Obsolete
This element will become obsolete from version 28.0. Replaced with namesake procedure with "Item Application Entries Outb." as parameter.
[Obsolete(Replaced with namesake procedure with "Item Application Entries Outb." as parameter.,28.0)]
procedure AppliedOutbndEntryExists(var ItemApplicationEntries: Query "Item Application Entries"; InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean; FilterOnOnlyCostNotAdjusted: Boolean): Boolean
Parameters
Returns
AppliedOutbndEntryExists
procedure AppliedOutbndEntryExists(var ItemApplicationEntriesOutb: Query "Item Application Entries Outb."; InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean; FilterOnOnlyCostNotAdjusted: Boolean): Boolean
Parameters
Returns
AppliedInbndTransEntryExists
procedure AppliedInbndTransEntryExists(InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean
Parameters
| Name |
Type |
Description |
|
InbndItemLedgEntryNo
|
Integer |
|
|
IsCostApplication
|
Boolean |
|
Returns
AppliedInbndTransEntryExists
procedure AppliedInbndTransEntryExists(var ItemApplicationEntries: Query "Item Application Entries"; InbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean
Parameters
Returns
AppliedInbndEntryExists
procedure AppliedInbndEntryExists(OutbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean
Parameters
| Name |
Type |
Description |
|
OutbndItemLedgEntryNo
|
Integer |
|
|
IsCostApplication
|
Boolean |
|
Returns
AppliedInbndEntryExists
Obsolete
This element will become obsolete from version 28.0. Replaced with namesake procedure with "Item Application Entries Inb." as parameter.
[Obsolete(Replaced with namesake procedure with "Item Application Entries Inb." as parameter.,28.0)]
procedure AppliedInbndEntryExists(var ItemApplicationEntries: Query "Item Application Entries"; OutbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean
Parameters
Returns
AppliedInbndEntryExists
procedure AppliedInbndEntryExists(var ItemApplicationEntriesInb: Query "Item Application Entries Inb."; OutbndItemLedgEntryNo: Integer; IsCostApplication: Boolean): Boolean
Parameters
Returns
AppliedFromEntryExists
procedure AppliedFromEntryExists(InbndItemLedgEntryNo: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
InbndItemLedgEntryNo
|
Integer |
|
Returns
GetInboundEntriesTheOutbndEntryAppliedTo
procedure GetInboundEntriesTheOutbndEntryAppliedTo(OutbndItemLedgEntryNo: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
OutbndItemLedgEntryNo
|
Integer |
|
Returns
GetOutboundEntriesAppliedToTheInboundEntry
procedure GetOutboundEntriesAppliedToTheInboundEntry(InbndItemLedgEntryNo: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
InbndItemLedgEntryNo
|
Integer |
|
Returns
CheckAppliedFromEntryToAdjust
procedure CheckAppliedFromEntryToAdjust(InbndItemLedgEntryNo: Integer)
Parameters
| Name |
Type |
Description |
|
InbndItemLedgEntryNo
|
Integer |
|
CostReceiver
procedure CostReceiver(): Integer
Returns
Fixed
procedure Fixed(): Boolean
Returns
InsertHistory
procedure InsertHistory(): Integer
Returns
CostApplication
procedure CostApplication(): Boolean
Returns
CheckIsCyclicalLoop
procedure CheckIsCyclicalLoop(CheckItemLedgEntry: Record "Item Ledger Entry"; FromItemLedgEntry: Record "Item Ledger Entry"): Boolean
Parameters
Returns
GetVisitedEntries
procedure GetVisitedEntries(FromItemLedgEntry: Record "Item Ledger Entry"; var ItemLedgEntryInChain: Record "Item Ledger Entry"; WithinValuationDate: Boolean)
Parameters
OutboundApplied
procedure OutboundApplied(EntryNo: Integer; SameType: Boolean): Decimal
Parameters
| Name |
Type |
Description |
|
EntryNo
|
Integer |
|
|
SameType
|
Boolean |
|
Returns
InboundApplied
procedure InboundApplied(EntryNo: Integer; SameType: Boolean): Decimal
Parameters
| Name |
Type |
Description |
|
EntryNo
|
Integer |
|
|
SameType
|
Boolean |
|
Returns
Returned
procedure Returned(EntryNo: Integer): Decimal
Parameters
| Name |
Type |
Description |
|
EntryNo
|
Integer |
|
Returns
ExistsBetween
procedure ExistsBetween(ILE1: Integer; ILE2: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
ILE1
|
Integer |
|
|
ILE2
|
Integer |
|
Returns
SetOutboundsNotUpdated
procedure SetOutboundsNotUpdated(ItemLedgEntry: Record "Item Ledger Entry")
Parameters
SetInboundToUpdated
procedure SetInboundToUpdated(ItemLedgEntry: Record "Item Ledger Entry")
Parameters
IsAppliedFromIncrease
procedure IsAppliedFromIncrease(InbndItemLedgEntryNo: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
InbndItemLedgEntryNo
|
Integer |
|
Returns
IsOutbndItemApplEntryCostApplication
procedure IsOutbndItemApplEntryCostApplication(OutboundItemLedgEntryNo: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
OutboundItemLedgEntryNo
|
Integer |
|
Returns
SetSearchedItemLedgerEntry
Obsolete
This element will become obsolete from version 27.0. The optimization that used this function was obsoleted.
[Obsolete(The optimization that used this function was obsoleted.,27.0)]
procedure SetSearchedItemLedgerEntry(var ItemLedgerEntry: Record "Item Ledger Entry")
Parameters
SetCostApplication
procedure SetCostApplication(NewCostApplication: Boolean)
Parameters
| Name |
Type |
Description |
|
NewCostApplication
|
Boolean |
|
Events
OnBeforeFixed
[IntegrationEvent(False,False)]
local procedure OnBeforeFixed(ItemApplicationEntry: Record "Item Application Entry"; var Result: Boolean; var IsHandled: Boolean)
Parameters
OnSetInboundToUpdatedOnAfterSetFilters
[IntegrationEvent(False,False)]
local procedure OnSetInboundToUpdatedOnAfterSetFilters(var ItemApplicationEntry: Record "Item Application Entry")
Parameters
OnBeforeCheckCyclicProdCyclicalLoop
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckCyclicProdCyclicalLoop(var ItemApplicationEntry: Record "Item Application Entry"; CheckItemLedgerEntry: Record "Item Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry"; var Result: Boolean; var IsHandled: Boolean)
Parameters
OnBeforeCheckCyclicAsmCyclicalLoop
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckCyclicAsmCyclicalLoop(var ItemApplicationEntry: Record "Item Application Entry"; CheckItemLedgerEntry: Record "Item Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry"; var Result: Boolean; var IsHandled: Boolean)
Parameters
OnSetOutboundsNotUpdatedOnAfterSetFilters
[IntegrationEvent(False,False)]
local procedure OnSetOutboundsNotUpdatedOnAfterSetFilters(var ItemApplicationEntry: Record "Item Application Entry")
Parameters
OnCheckIsCyclicalLoopOnBeforeCheckCyclicForwardToAppliedInbounds
[IntegrationEvent(True,False)]
local procedure OnCheckIsCyclicalLoopOnBeforeCheckCyclicForwardToAppliedInbounds(CheckItemLedgEntry: Record "Item Ledger Entry"; FromItemLedgEntry: Record "Item Ledger Entry"; MaxValuationDate: Date; var IsCyclicalLoop: Boolean)
Parameters
OnCheckCyclicFwdToAppliedEntriesOnAfterCheckItemApplicationEntry
[IntegrationEvent(True,False)]
local procedure OnCheckCyclicFwdToAppliedEntriesOnAfterCheckItemApplicationEntry(CheckItemLedgerEntry: Record "Item Ledger Entry"; ToEntryNo: Integer; IsPositiveToNegativeFlow: Boolean; var IsCyclicalLoop: Boolean)
Parameters
See also