Table of Contents

Table Location

ID 14
Namespace: Microsoft.Inventory.Location

Properties

Name Value
Caption Location
DataCaptionFields 1,2
DrillDownPageID Page Microsoft.Inventory.Location."Location List"
LookupPageID Page Microsoft.Inventory.Location."Location List"
DataClassification CustomerContent

Fields

Name Type Description
Code Code[10]

Specifies a location code for the warehouse or distribution center where your items are handled and stored before being sold.
Name Text[100]

Specifies the name or address of the location.
"Default Bin Code" Code[20]
"Name 2" Text[50]
Address Text[100]

Specifies the location address.
"Address 2" Text[50]

Specifies additional address information.
City Text[30]

Specifies the city of the location.
"Phone No." Text[30]

Specifies the telephone number of the location.
"Phone No. 2" Text[30]
"Telex No." Text[30]
"Fax No." Text[30]

Specifies the fax number of the location.
Contact Text[100]

Specifies the name of the contact person at the location
"Post Code" Code[20]

Specifies the postal code.
County Text[30]

Specifies the state, province or county as a part of the address.
"E-Mail" Text[80]

Specifies the email address of the location.
"Home Page" Text[255]

Specifies the location's web site.
"Country/Region Code" Code[10]

Specifies the country/region of the address.
"Use As In-Transit" Boolean

Specifies that this location is an in-transit location.
"Require Put-away" Boolean

Specifies if the location requires a dedicated warehouse activity when putting items away.
"Require Pick" Boolean

Specifies if the location requires a dedicated warehouse activity when picking items.
"Cross-Dock Due Date Calc." DateFormula

Specifies the cross-dock due date calculation.
"Use Cross-Docking" Boolean

Specifies if the location supports movement of items directly from the receiving dock to the shipping dock.
"Require Receive" Boolean

Specifies if the location requires a receipt document when receiving items.
"Require Shipment" Boolean

Specifies if the location requires a shipment document when shipping items.
"Bin Mandatory" Boolean

Specifies if the location requires that a bin code is specified on all item transactions.
"Directed Put-away and Pick" Boolean

Specifies if the location requires advanced warehouse functionality, such as calculated bin suggestion.
"Default Bin Selection" Enum Microsoft.Warehouse.Structure."Location Default Bin Selection"

Specifies the method used to select the default bin.
"Outbound Whse. Handling Time" DateFormula

Specifies a date formula for the time it takes to get items ready to ship from this location. The time element is used in the calculation of the delivery date as follows: Shipment Date + Outbound Warehouse Handling Time = Planned Shipment Date + Shipping Time = Planned Delivery Date.
"Inbound Whse. Handling Time" DateFormula

Specifies the time it takes to make items part of available inventory, after the items have been posted as received.
"Put-away Template Code" Code[10]

Specifies the put-away template to be used at this location.
"Use Put-away Worksheet" Boolean

Specifies if put-aways for posted warehouse receipts must be created with the put-away worksheet. If the check box is not selected, put-aways are created directly when you post a warehouse receipt or production output.
"Pick According to FEFO" Boolean

Specifies whether to use the First-Expired-First-Out (FEFO) method to determine which items to pick, according to expiration dates.
"Allow Breakbulk" Boolean

Specifies that an order can be fulfilled with items stored in alternate units of measure, if an item stored in the requested unit of measure is not found. This feature is applicable only with directed put-away and pick locations.
"Bin Capacity Policy" Option

Specifies how bins are automatically filled, according to their capacity.
"Pick Bin Policy" Enum Microsoft.Warehouse.Activity."Pick Bin Policy"

Specifies how bins are automatically selected for inventory picks.
"Check Whse. Class" Boolean

Specifies if the warehouse class should be checked.
"Put-away Bin Policy" Enum Microsoft.Warehouse.Activity."Put-away Bin Policy"
"Open Shop Floor Bin Code" Code[20]

Specifies the bin that functions as the default open shop floor bin.
"Adjustment Bin Code" Code[20]

Specifies the code of the bin in which you record observed differences in inventory quantities.
"Always Create Put-away Line" Boolean

Specifies that a put-away line is created, even if an appropriate zone and bin in which to place the items cannot be found.
"Always Create Pick Line" Boolean

Specifies that a pick line is created, even if an appropriate zone and bin from which to pick the item cannot be found.
"Special Equipment" Option

Specifies where the program will first looks for special equipment designated for warehouse activities.
"Receipt Bin Code" Code[20]

Specifies the default receipt bin code.
"Shipment Bin Code" Code[20]

Specifies the default shipment bin code.
"Cross-Dock Bin Code" Code[20]

Specifies the bin code that is used by default for the receipt of items to be cross-docked.
"To-Assembly Bin Code" Code[20]

Specifies the bin in the assembly area where components are placed by default before they can be consumed in assembly.
"From-Assembly Bin Code" Code[20]

Specifies the bin in the assembly area where finished assembly items are posted to when they are assembled to stock.
"Asm.-to-Order Shpt. Bin Code" Code[20]

Specifies the bin where finished assembly items are posted to when they are assembled to a linked sales order.
"To-Job Bin Code" Code[20]

Specifies the bin where an item will be put away or picked in warehouse and inventory processes at this location. For example, when you choose this location on a project planning line, this bin will be suggested.
"Asm. Consump. Whse. Handling" Enum Microsoft.Assembly.Document."Asm. Consump. Whse. Handling"

Specifies the warehouse handling for consumption in assembly scenarios.
"Job Consump. Whse. Handling" Enum Microsoft.Projects.Project.Setup."Job Consump. Whse. Handling"

Specifies the warehouse handling for consumption in project scenarios.
"Base Calendar Code" Code[10]

Specifies a customizable calendar for planning that holds the location's working days and holidays.
"Use ADCS" Boolean

Specifies the automatic data capture system that warehouse employees must use to keep track of items within the warehouse.
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

RequireShipment

procedure RequireShipment(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

RequirePicking

procedure RequirePicking(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

RequireReceive

procedure RequireReceive(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

RequirePutaway

procedure RequirePutaway(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

BinMandatory

procedure BinMandatory(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

GetLocationSetup

procedure GetLocationSetup(LocationCode: Code[10]; var Location2: Record Location): Boolean

Parameters

Name Type Description
LocationCode Code[10]
Location2 Table Microsoft.Inventory.Location.Location

Returns

Type Description
Boolean

CheckEmptyBin

procedure CheckEmptyBin(LocationCode: Code[10]; BinCode: Code[20]; CaptionOfField: Text[30])

Parameters

Name Type Description
LocationCode Code[10]
BinCode Code[20]
CaptionOfField Text[30]

GetRequirementText

procedure GetRequirementText(FieldNumber: Integer): Text[50]

Parameters

Name Type Description
FieldNumber Integer

Returns

Type Description
Text[50]

DisplayMap

procedure DisplayMap()

IsBWReceive

procedure IsBWReceive(): Boolean

Returns

Type Description
Boolean

IsBWShip

procedure IsBWShip(): Boolean

Returns

Type Description
Boolean

IsBinBWReceiveOrShip

procedure IsBinBWReceiveOrShip(BinCode: Code[20]): Boolean

Parameters

Name Type Description
BinCode Code[20]

Returns

Type Description
Boolean

IsInTransit

procedure IsInTransit(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

IsProdConsumpWhseHandlingTypeWarehousePick

procedure IsProdConsumpWhseHandlingTypeWarehousePick(): Boolean

Returns

Type Description
Boolean

GetLocationsIncludingUnspecifiedLocation

procedure GetLocationsIncludingUnspecifiedLocation(IncludeOnlyUnspecifiedLocation: Boolean; ExcludeInTransitLocations: Boolean)

Parameters

Name Type Description
IncludeOnlyUnspecifiedLocation Boolean
ExcludeInTransitLocations Boolean

PickAccordingToFEFO

procedure PickAccordingToFEFO(): Boolean

Returns

Type Description
Boolean

SelectMultipleLocations

procedure SelectMultipleLocations(): Text

Returns

Type Description
Text

CheckInventoryActivityExists

procedure CheckInventoryActivityExists(LocationCode: Code[10]; SourceType: Integer; FieldCaption: Text)

Parameters

Name Type Description
LocationCode Code[10]
SourceType Integer
FieldCaption Text

CheckBinCode

procedure CheckBinCode(LocationCode: Code[10]; BinCode: Code[20]; BinCaption: Text; Number: Code[20])

Parameters

Name Type Description
LocationCode Code[10]
BinCode Code[20]
BinCaption Text
Number Code[20]

Events

OnAfterLookupCity

[IntegrationEvent(False,False)]
local procedure OnAfterLookupCity(var Location: Record Location; var PostCode: Record "Post Code")

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
PostCode Table Microsoft.Foundation.Address."Post Code"

OnAfterLookupPostCode

[IntegrationEvent(False,False)]
local procedure OnAfterLookupPostCode(var Location: Record Location; var PostCode: Record "Post Code")

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
PostCode Table Microsoft.Foundation.Address."Post Code"

OnAfterValidateCity

[IntegrationEvent(False,False)]
local procedure OnAfterValidateCity(var Location: Record Location; var PostCode: Record "Post Code")

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
PostCode Table Microsoft.Foundation.Address."Post Code"

OnAfterValidatePostCode

[IntegrationEvent(False,False)]
local procedure OnAfterValidatePostCode(var Location: Record Location; var PostCode: Record "Post Code")

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
PostCode Table Microsoft.Foundation.Address."Post Code"

OnBeforeValidateUseCrossDocking

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateUseCrossDocking(var Location: Record Location; xLocation: Record Location; CurrentFieldNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
xLocation Table Microsoft.Inventory.Location.Location
CurrentFieldNo Integer
IsHandled Boolean

OnGetLocationSetupOnAfterInitLocation

[IntegrationEvent(False,False)]
local procedure OnGetLocationSetupOnAfterInitLocation(var Location: Record Location; var Location2: Record Location)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
Location2 Table Microsoft.Inventory.Location.Location

OnBeforeWMSCheckWarehouse

[IntegrationEvent(False,False)]
local procedure OnBeforeWMSCheckWarehouse(var Location: Record Location; var IsHandled: Boolean)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
IsHandled Boolean

OnValidateBinMandatoryOnBeforeItemLedgEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnValidateBinMandatoryOnBeforeItemLedgEntrySetFilters(var Location: Record Location)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location

OnValidateBinMandatoryOnAfterItemLedgEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnValidateBinMandatoryOnAfterItemLedgEntrySetFilters(var Location: Record Location)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location

OnValidateBinMandatoryOnAfterWhseEntrySetFilters

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

Parameters

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

OnBeforeValidateCity

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateCity(var Location: Record Location; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
PostCode Table Microsoft.Foundation.Address."Post Code"
CurrentFieldNo Integer
IsHandled Boolean

OnBeforeValidatePostCode

[IntegrationEvent(False,False)]
local procedure OnBeforeValidatePostCode(var Location: Record Location; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
PostCode Table Microsoft.Foundation.Address."Post Code"
CurrentFieldNo Integer
IsHandled Boolean

OnBeforeIsBinBWReceiveOrShip

[IntegrationEvent(False,False)]
local procedure OnBeforeIsBinBWReceiveOrShip(Location: Record Location; BinCode: Code[20]; var Result: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location
BinCode Code[20]
Result Boolean
IsHandled Boolean

OnValidateBinMandatoryOnAfterCheckBins

[IntegrationEvent(False,False)]
local procedure OnValidateBinMandatoryOnAfterCheckBins(var Location: Record Location)

Parameters

Name Type Description
Location Table Microsoft.Inventory.Location.Location

See also