Table "Inventory Setup"
Properties
| Name | Value |
|---|---|
| Caption | Inventory Setup |
| DrillDownPageID | Page Microsoft.Inventory.Setup."Inventory Setup" |
| LookupPageID | Page Microsoft.Inventory.Setup."Inventory Setup" |
| Permissions | TableData "Inventory Adjmt. Entry (Order)" = m |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Primary Key" | Code[10] | |
| "Automatic Cost Posting" | Boolean | Specifies if value entries are automatically posted to the inventory account, adjustment account, and COGS account in the general ledger when an item transaction is posted. Alternatively, you can manually post the values at regular intervals with the Post Inventory Cost to G/L batch job. Note that costs must be adjusted before posting to the general ledger. |
| "Location Mandatory" | Boolean | Specifies if a location code is required when posting item transactions. This field, together with the Components at Location field in the Manufacturing Setup window, is very important in governing how the planning system handles demand lines with/without location codes. For more information, see "Planning with or without Locations" in Help. |
| "Item Nos." | Code[20] | Specifies the number series that will be used to assign numbers to items. |
| "Automatic Cost Adjustment" | Enum Microsoft.Inventory.Costing."Automatic Cost Adjustment Type" | Specifies if item value entries are automatically adjusted when an item transaction is posted. This ensures correct inventory valuation in the general ledger, so that sales and profit statistics are up to date. The cost adjustment forwards any cost changes from inbound entries, such as those for purchases or production output, to the related outbound entries, such as sales or transfers. To minimize reduced performance during posting, select a time option to define how far back in time from the work date an inbound transaction can occur to potentially trigger adjustment of related outbound value entries. Alternatively, you can manually adjust costs at regular intervals with the Adjust Cost - Item Entries batch job. |
| "Cost Adjustment Logging" | Enum Microsoft.Inventory.Costing."Cost Adjustment Logging Level" | Specifies if you want to log cost adjustments runs. Disabled: No logging. Errors Only: The program will only log cost adjustment runs that have errors. All: The program will log all cost adjustment runs. |
| "Earliest Allowed Val. Date" | Date | Specifies the earliest date allowed for a Valuation Date on new value entries. If set, user-initiated postings with a Valuation Date before this date are blocked. System-generated entries such as cost adjustments, rounding, and expected-to-actual corrections are exempt. Leave blank to allow all dates. |
| "Current Demand Forecast" | Code[10] | Specifies the name of the relevant demand forecast to use to calculate a plan. |
| "Use Forecast on Variants" | Boolean | Specifies that actual demand for the selected demand forecast is nettet for the specified item variant. If you leave the check box empty, the program regards the demand forecast as valid for all variants. |
| "Use Forecast on Locations" | Boolean | Specifies that actual demand for the selected demand forecast is nettet for the specified location only. If you leave the check box empty, the program regards the demand forecast as valid for all locations. |
| "Combined MPS/MRP Calculation" | Boolean | Specifies if both master production schedule and material requirements plan are run when you choose the Calc. Regenerative Plan action in the planning worksheet. |
| "Prevent Negative Inventory" | Boolean | Specifies whether you can post a transaction that will bring the item's inventory below zero. Negative inventory is always prevented for Consumption and Transfer type transactions. |
| "Default Dampener %" | Decimal | Specifies a percentage of an item's lot size by which an existing supply must change before a planning suggestion is made. |
| "Default Safety Lead Time" | DateFormula | Specifies a time period that is added to the lead time of all items that do not have another value specified in the Safety Lead Time field. |
| "Blank Overflow Level" | Option | Specifies how the planning system should react if the Overflow Level field on the item or SKU card is empty. |
| "Default Dampener Period" | DateFormula | Specifies a period of time during which you do not want the planning system to propose to reschedule existing supply order's forward. This value in this field applies to all items except for items that have a different value in the Dampener Period field on the item card. When a dampener time is set, an order is only rescheduled when the defined dampener time has passed since the order s original due date. Note: The dampener time that is applied to an item can never be higher than the value in the item's Lot Accumulation Period field. This is because the inventory build-up time that occurs during a dampener period would conflict with the build-up period defined by the item's lot accumulation period. Accordingly, the default dampener period generally applies to all items. However, if an item's lot accumulation period is shorter than the default dampener period, then the item's dampener time equals its lot accumulation period. |
| "Variant Mandatory if Exists" | Boolean | Specifies whether a variant must be selected if variants exist for an item. This is the default setting for all items. However, the same option is available on the Item Card page for items. That setting applies to the specific item. |
| "Skip Prompt to Create Item" | Boolean | Specifies if a message about creating a new item card appears when you enter an item number that does not exist. |
| "Copy Item Descr. to Entries" | Boolean | Specifies if you want the description on item cards to be copied to item ledger entries during posting. |
| "Allow Inventory Adjustment" | Boolean | Specifies if you want to allow manual adjustment of the inventory in the item card. |
| "Invt. Cost Jnl. Template Name" | Code[10] | Specifies the name of the journal template to use for automatic and expected cost posting. |
| "Invt. Cost Jnl. Batch Name" | Code[10] | Specifies the name of the journal batch to use for automatic and expected cost posting. |
| "Transfer Order Nos." | Code[20] | Specifies the number series that will be used to assign numbers to transfer orders. |
| "Posted Transfer Shpt. Nos." | Code[20] | Specifies the number series that will be used to assign numbers to posted transfer shipments. |
| "Posted Transfer Rcpt. Nos." | Code[20] | Specifies the number series that will be used to assign numbers to posted transfer receipts. |
| "Copy Comments Order to Shpt." | Boolean | Specifies that you want to copy the comments entered on the transfer order to the transfer shipment. |
| "Copy Comments Order to Rcpt." | Boolean | Specifies that you want to copy the comments entered on the transfer order to the transfer receipt. |
| "Nonstock Item Nos." | Code[20] | Specifies the number series that will be used to assign numbers to catalog items. |
| "Outbound Whse. Handling Time" | DateFormula | Specifies a date formula that calculates the time it takes to get items ready to ship. The time element is used to calculate 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 a date formula that calculates the time it takes to make items available in inventory after they have been received. The time element is used to calculate the expected receipt date as follows: Order Date + Lead Time Calculation = Planned Receipt Date + Inbound Warehouse Handling Time + Safety Lead Time = Expected Receipt Date. |
| "Expected Cost Posting to G/L" | Boolean | Specifies if value entries originating from receipt or shipment posting, but not from invoice posting are recoded in the general ledger. Expected costs represent the estimation of, for example, a purchased item's cost that you record before you receive the invoice for the item. To post expected costs, interim accounts must exist in the general ledger for the relevant posting groups. Expected costs are only managed for item transactions, not for immaterial transaction types, such as capacity and item charges. |
| "Default Costing Method" | Enum Microsoft.Inventory.Item."Costing Method" | Specifies how your items' cost flow is recorded and whether an actual or budgeted value is capitalized and used in the cost calculation. Your choice of costing method determines how the unit cost is calculated by making assumptions about the flow of physical items through your company. A different costing method on item cards will override this default. For more information, see "Design Details: Costing Methods" in Help. |
| "Average Cost Calc. Type" | Enum Microsoft.Inventory.Costing."Average Cost Calculation Type" | Specifies how costs are calculated for items using the Average costing method. Item: One average cost per item in the company is calculated. Item & Location & Variant: An average cost per item for each location and for each variant of the item in the company is calculated. This means that the average cost of this item depends on where it is stored and which variant, such as color, of the item you have selected. |
| "Average Cost Period" | Enum Microsoft.Inventory.Costing."Average Cost Period Type" | Specifies the period of time used to calculate the weighted average cost of items that apply the average costing method. All inventory decreases that were posted within an average cost period will receive the average cost calculated for that period. If you change the average cost period, only open fiscal years will be affected. |
| "Allow Invt. Doc. Reservation" | Boolean | Specifies if you want to allow reservation for inventory receipts and shipments. |
| "Invt. Receipt Nos." | Code[20] | Specifies the number series from which numbers are assigned to new records. |
| "Posted Invt. Receipt Nos." | Code[20] | Specifies the number series from which numbers are assigned to new records. |
| "Invt. Shipment Nos." | Code[20] | Specifies the number series from which numbers are assigned to new records. |
| "Posted Invt. Shipment Nos." | Code[20] | Specifies the number series from which numbers are assigned to new records. |
| "Copy Comments to Invt. Doc." | Boolean | Specifies that you want to copy the comments entered on the inventory document to the posted document. |
| "Direct Transfer Posting" | Option | Specifies if Direct Transfer will be posted as Shipment and Receipt or as single Direct Transfer document. There are different restrictions associated with different modes, for example Directed Transfer document does not support partial posting. |
| "Posted Direct Trans. Nos." | Code[20] | Specifies the number series from which numbers are assigned to new records. |
| "Direct Transfer Posting Type" | Enum Microsoft.Inventory.Setup."Direct Transfer Posting Type" | Specifies if Direct Transfer will be posted as Shipment and Receipt or as single Direct Transfer document. There are different restrictions associated with different modes, for example Directed Transfer document does not support partial posting. |
| "Package Nos." | Code[20] | Specifies the number series that will be used to assign numbers to item tracking packages. |
| "Phys. Invt. Order Nos." | Code[20] | Specifies the number series that will be used to assign numbers to physical inventory orders. |
| "Posted Phys. Invt. Order Nos." | Code[20] | Specifies the number series that will be used to assign numbers to physical inventory orders when they are posted. |
| "Invt. Orders Package Tracking" | Boolean | |
| "Package Caption" | Text[30] | Specifies the alternative caption of Package tracking dimension that you want to use for captions for this dimension. For example, Size. |
| "Item Group Dimension Code" | Code[20] | Specifies the dimension code that you want to use for product groups in analysis reports. |
| "Inventory Put-away Nos." | Code[20] | Specifies the number series that will be used to assign numbers to inventory put-always. |
| "Inventory Pick Nos." | Code[20] | Specifies the number series that will be used to assign numbers to inventory picks. |
| "Posted Invt. Put-away Nos." | Code[20] | Specifies the number series that will be used to assign numbers to posted inventory put-always. |
| "Posted Invt. Pick Nos." | Code[20] | Specifies the number series that will be used to assign numbers to posted inventory picks. |
| "Inventory Movement Nos." | Code[20] | Specifies the number series that will be used to assign numbers to inventory movements. |
| "Registered Invt. Movement Nos." | Code[20] | Specifies the number series that will be used to assign numbers to registered inventory movements. |
| "Internal Movement Nos." | Code[20] | Specifies the number series that will be used to assign numbers to internal movements. |
| 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
GetRecordOnce
procedure GetRecordOnce()OptimGLEntLockForMultiuserEnv
procedure OptimGLEntLockForMultiuserEnv(): BooleanReturns
| Type | Description |
|---|---|
| Boolean |
AutomaticCostAdjmtRequired
procedure AutomaticCostAdjmtRequired(): BooleanReturns
| Type | Description |
|---|---|
| Boolean |
UseLegacyPosting
procedure UseLegacyPosting(): BooleanReturns
| Type | Description |
|---|---|
| Boolean |
GetComponentsAtLocation
procedure GetComponentsAtLocation(): Code[10]Returns
| Type | Description |
|---|---|
| Code[10] |
Events
OnGetComponentsAtLocation
[IntegrationEvent(False,False)]
local procedure OnGetComponentsAtLocation(var LocationCode: Code[10])Parameters
| Name | Type | Description |
|---|---|---|
| LocationCode | Code[10] |