Table of Contents

Table "Warehouse Entry"

ID 7312
Namespace: Microsoft.Warehouse.Ledger

Properties

Name Value
Caption Warehouse Entry
DrillDownPageID Page Microsoft.Warehouse.Ledger."Warehouse Entries"
LookupPageID Page Microsoft.Warehouse.Ledger."Warehouse Entries"
Permissions TableData "Warehouse Entry" = ri
DataClassification CustomerContent

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.
"Journal Batch Name" Code[10]

Specifies the name of the journal batch, a personalized journal layout, that the entries were posted from.
"Line No." Integer

Specifies the line number of the warehouse document line or warehouse journal line that was registered.
"Registering Date" Date

Specifies the date the entry was registered.
"Location Code" Code[10]

Specifies the code of the location to which the entry is linked.
"Zone Code" Code[10]

Specifies the code of the zone to which the entry is linked.
"Bin Code" Code[20]

Specifies the bin where the items are picked or put away.
Description Text[100]

Specifies a description of the warehouse entry.
"Item No." Code[20]

Specifies the number of the item in the entry.
Quantity Decimal

Specifies the number of units of the item in the warehouse entry.
"Qty. (Base)" Decimal
"Warehouse Register No." Integer
"SIFT Bucket No." Integer

Specifies an automatically generated number that is used by the system to enable better concurrency.
"Source Type" Integer

Specifies the table number that is the source of the entry line, for example, 39 for a purchase line, 37 for a sales line.
"Source Subtype" Option

Specifies the source subtype of the document to which the warehouse entry line relates.
"Source No." Code[20]

Specifies the number of the source document that the entry originates from.
"Source Line No." Integer

Specifies the line number of the source document that the entry originates from.
"Source Subline No." Integer

Specifies the source subline number of the document from which the entry originates.
"Source Document" Enum Microsoft.Warehouse.Journal."Warehouse Journal Source Document"

Specifies the type of document that the line relates to.
"Source Code" Code[10]
"Reason Code" Code[10]

Specifies the reason code, a supplementary source code that enables you to trace the entry.
"No. Series" Code[20]

Specifies the number series from which entry or record numbers are assigned to new entries or records.
"Bin Type Code" Code[10]
Cubage Decimal

Specifies the total cubage of the items on the warehouse entry line.
Weight Decimal

Specifies the weight of one item unit when measured in the specified unit of measure.
"Journal Template Name" Code[10]

Specifies the name of the journal template, the basis of the journal batch, that the entries were posted from.
"Whse. Document No." Code[20]

Specifies the number of the warehouse document from which this entry originated.
"Whse. Document Type" Enum Microsoft.Warehouse.Journal."Warehouse Journal Document Type"

Specifies the type of the document from which this entry originated.
"Whse. Document Line No." Integer
"Entry Type" Option

Specifies the entry type, which can be Negative Adjmt., Positive Adjmt., or Movement.
"Reference Document" Enum Microsoft.Warehouse.Setup."Whse. Reference Document Type"
"Reference No." Code[20]
"User ID" Code[50]

Specifies the ID of the user who posted the entry, to be used, for example, in the change log.
"Variant Code" Code[10]

Specifies the variant of the item on the line.
"Qty. per Unit of Measure" Decimal

Specifies the number of base units of measure that are in the unit of measure specified for the item on the line.
"Unit of Measure Code" Code[10]

Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.
"Serial No." Code[50]

Specifies the serial number.
"Lot No." Code[50]

Specifies the lot number assigned to the warehouse entry.
"Warranty Date" Date
"Expiration Date" Date

Specifies the expiration date of the serial number.
"Package No." Code[50]

Specifies the package number assigned to the warehouse entry.
"Phys Invt Counting Period Code" Code[10]
"Phys Invt Counting Period Type" Option
Dedicated Boolean
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

InsertRecord

Obsolete

This element will become obsolete from version 27.0. This function is deprecated. Concurrent warehouse posting is always on.

[Obsolete(This function is deprecated. Concurrent warehouse posting is always on.,27.0)]
procedure InsertRecord(UseLegacyPosting: Boolean)

Parameters

Name Type Description
UseLegacyPosting Boolean

InsertRecord

[InherentPermissions(TableData,7312,r)]
procedure InsertRecord()

GetNextEntryNo

[InherentPermissions(TableData,7312,r)]
procedure GetNextEntryNo(): Integer

Returns

Type Description
Integer

GetLastEntryNo

[InherentPermissions(TableData,7312,r)]
procedure GetLastEntryNo(): Integer

Returns

Type Description
Integer

ClearTrackingFilter

procedure ClearTrackingFilter()

CopyTrackingFromWhseEntry

procedure CopyTrackingFromWhseEntry(WhseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

CopyTrackingFromWhseJnlLine

procedure CopyTrackingFromWhseJnlLine(WhseJnlLine: Record "Warehouse Journal Line")

Parameters

Name Type Description
WhseJnlLine Table Microsoft.Warehouse.Journal."Warehouse Journal Line"

CopyTrackingFromNewWhseJnlLine

procedure CopyTrackingFromNewWhseJnlLine(WhseJnlLine: Record "Warehouse Journal Line")

Parameters

Name Type Description
WhseJnlLine Table Microsoft.Warehouse.Journal."Warehouse Journal Line"

SetCalculationFilters

procedure SetCalculationFilters(ItemNo: Code[20]; LocationCode: Code[10]; VariantCode: Code[10]; WhseItemTrackingSetup: Record "Item Tracking Setup"; ExcludeDedicatedBinContent: Boolean)

Parameters

Name Type Description
ItemNo Code[20]
LocationCode Code[10]
VariantCode Code[10]
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"
ExcludeDedicatedBinContent Boolean

SetSourceFilter

procedure SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)

Parameters

Name Type Description
SourceType Integer
SourceSubType Option
SourceNo Code[20]
SourceLineNo Integer
SetKey Boolean

SetTrackingFilterIfNotBlank

procedure SetTrackingFilterIfNotBlank()

SetTrackingFilterFromBinContent

procedure SetTrackingFilterFromBinContent(var BinContent: Record "Bin Content")

Parameters

Name Type Description
BinContent Table Microsoft.Warehouse.Structure."Bin Content"

SetTrackingFilterFromBinContentBuffer

procedure SetTrackingFilterFromBinContentBuffer(BinContentBuffer: Record "Bin Content Buffer")

Parameters

Name Type Description
BinContentBuffer Table Microsoft.Warehouse.Structure."Bin Content Buffer"

SetTrackingFilterFromItemTrackingSetupIfRequired

procedure SetTrackingFilterFromItemTrackingSetupIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

SetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired

procedure SetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

SetTrackingFilterFromItemTrackingSetupIfRequiredIfNotBlank

procedure SetTrackingFilterFromItemTrackingSetupIfRequiredIfNotBlank(WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

SetTrackingFilterFromWhseEntry

procedure SetTrackingFilterFromWhseEntry(FromWhseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
FromWhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

SetTrackingFilterFromReservEntryIfNotBlank

procedure SetTrackingFilterFromReservEntryIfNotBlank(ReservEntry: Record "Reservation Entry")

Parameters

Name Type Description
ReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

SetTrackingFIlterFromItemFilters

procedure SetTrackingFIlterFromItemFilters(var Item: Record Item)

Parameters

Name Type Description
Item Table Microsoft.Inventory.Item.Item

SetTrackingFilterFromItemTrackingSetupIfNotBlank

procedure SetTrackingFilterFromItemTrackingSetupIfNotBlank(WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

TrackingExists

procedure TrackingExists(): Boolean

Returns

Type Description
Boolean

Lock

procedure Lock()

SetTrackingFilterFromWhseEntryForSerialOrLotTrackedItem

procedure SetTrackingFilterFromWhseEntryForSerialOrLotTrackedItem(FromWhseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
FromWhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

Events

OnAfterClearTrackingFilter

[IntegrationEvent(False,False)]
local procedure OnAfterClearTrackingFilter(var WarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnAfterCopyTrackingFromWhseEntry

[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromWhseEntry(var WarehouseEntry: Record "Warehouse Entry"; FromWarehouseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
FromWarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnAfterCopyTrackingFromWhseJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromWhseJnlLine(var WarehouseEntry: Record "Warehouse Entry"; WarehouseJournalLine: Record "Warehouse Journal Line")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WarehouseJournalLine Table Microsoft.Warehouse.Journal."Warehouse Journal Line"

OnAfterCopyTrackingFromNewWhseJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromNewWhseJnlLine(var WarehouseEntry: Record "Warehouse Entry"; WarehouseJournalLine: Record "Warehouse Journal Line")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WarehouseJournalLine Table Microsoft.Warehouse.Journal."Warehouse Journal Line"

OnAfterSetTrackingFilterFromBinContent

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromBinContent(var WarehouseEntry: Record "Warehouse Entry"; var BinContent: Record "Bin Content")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
BinContent Table Microsoft.Warehouse.Structure."Bin Content"

OnAfterSetTrackingFilterFromBinContentBuffer

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromBinContentBuffer(var WarehouseEntry: Record "Warehouse Entry"; BinContentBuffer: Record "Bin Content Buffer")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
BinContentBuffer Table Microsoft.Warehouse.Structure."Bin Content Buffer"

OnAfterSetTrackingFilterFromReservEntryIfNotBlank

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromReservEntryIfNotBlank(var WarehouseEntry: Record "Warehouse Entry"; ReservEntry: Record "Reservation Entry")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
ReservEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

OnAfterSetTrackingFilterFromItemFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemFilters(var WarehouseEntry: Record "Warehouse Entry"; var Item: Record Item)

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
Item Table Microsoft.Inventory.Item.Item

OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromItemTrackingSetupIfRequiredIfNotBlank

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfRequiredIfNotBlank(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup")

Parameters

Name Type Description
WarehouseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
WhseItemTrackingSetup Table Microsoft.Inventory.Tracking."Item Tracking Setup"

OnAfterSetTrackingFilterFromWhseEntry

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromWhseEntry(var WhseEntry: Record "Warehouse Entry"; FromWhseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
FromWhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnAfterSetTrackingFilterIfNotBlank

[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterIfNotBlank(var WhseEntry: Record "Warehouse Entry")

Parameters

Name Type Description
WhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"

OnAfterTrackingExists

[IntegrationEvent(False,False)]
local procedure OnAfterTrackingExists(WhseEntry: Record "Warehouse Entry"; var IsTrackingExists: Boolean)

Parameters

Name Type Description
WhseEntry Table Microsoft.Warehouse.Ledger."Warehouse Entry"
IsTrackingExists Boolean

See also