tableInventoryofficial - Microsoftderived - from the source, no model text

Table 313 "Inventory Setup"

Base Application · Microsoft.Inventory.Setup

Across versions

  1. BC23present
  2. BC242 fields added
  3. BC251 fields changed
  4. BC262 fields changed, 2 procedures added
  5. BC278 fields added, 1 fields changed
  6. BC2852 fields changed, 2 procedures added
  7. BC292 procedures added, 1 fields changed
  8. BC30unchanged

Neighbourhood 29 connected objects and pages

Table 308 "No. Series" (relates to, 20 links)No. SeriesTable 232 "Gen. Journal Batch" (relates to)Table 348 "Dimension" (relates to)DimensionTable 80 "Gen. Journal Template" (relates to)Gen. Journal TemplateTable 99000851 "Production Forecast Name" (relates to)Production Forecast NamePage 461 "Inventory Setup" (pages and codeunits on it, 3 links)Inventory SetupCodeunit 5810 "Change Average Cost Setting" (pages and codeunits on it)Change Average Cost SettingCodeunit 5811 "Change Exp. Cost Post. to G/L" (pages and codeunits on it)Change Exp. Cost Post. to G/LPage 8645 "Costing Method Configuration" (pages and codeunits on it)Costing Method ConfigurationTable extension 5840 "Cost Adjmt. Inventory Setup" (extended by)Cost Adjmt. Inventory SetupCodeunit 24 "Inventory Setup" (event subscribers, 4 links)Inventory SetupCodeunit 6610 "FS Int. Table Subscriber" (event subscribers)FS Int. Table SubscriberCodeunit 99000861 "Mfg. Planning Integration" (event subscribers)Codeunit 24 "Inventory Setup" (calls)Inventory SetupCodeunit 27 "Confirm Management" (calls)Confirm ManagementCodeunit 5810 "Change Average Cost Setting" (calls)Codeunit 5849 "Avg. Cost Entry Point Handler" (calls)Avg. Cost Entry Point HandlerAnalyze data in lists with Copilot (preview) (Learn pages)Analyze list page and query data using data analysis (Learn pages)Create number series (Learn pages)Design details - Average cost (Learn pages)Design details - Changing costing methods for items (Learn pages)Design details - Inventory costing (Learn pages)Import Multiple Item Pictures (Learn pages)Register a new vendor (Learn pages)Register new customers by creating a Customer Card (Learn pages)Schedule jobs for adjusting & reconciling inventory cost (Learn pages)Set up general inventory information (Learn pages)Setting up inventory (Learn pages)

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.Setup · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 461 “Inventory Setup” (9 Learn pages), Page 8645 “Costing Method Configuration” (3).

Properties

Property Value
Caption Inventory Setup
DataClassification CustomerContent
Permissions TableData “Inventory Adjmt. Entry (Order)” = m

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 Primary Key Δ BC26 Code[10] —
2 Automatic Cost Posting Δ BC28 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 c…
3 Location Mandatory Δ BC28 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 “P…
4 Item Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to items. TableRelation Table 308 “No. Series” (No. Series)
30 Automatic Cost Adjustment Δ BC28 Enum “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 pur… enum Enum 30 “Automatic Cost Adjustment Type”
31 Cost Adjustment Logging + BC24 Δ BC28 Enum “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. enum Enum 5801 “Cost Adjustment Logging Level”
32 Earliest Allowed Val. Date + BC28 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 date…
35 Current Demand Forecast + BC27 Δ BC28 Code[10] Specifies the name of the relevant demand forecast to use to calculate a plan. TableRelation Table 99000851 “Production Forecast Name” (Microsoft.Manufacturing.Forecast.“Production Forecast Name”.Name)
36 Use Forecast on Variants + BC27 Δ BC28 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.
37 Use Forecast on Locations + BC27 Δ BC28 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.
38 Combined MPS/MRP Calculation + BC27 Δ BC28 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.
40 Prevent Negative Inventory Δ BC28 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.
41 Default Dampener % + BC27 Δ BC28 Decimal Specifies a percentage of an item’s lot size by which an existing supply must change before a planning suggestion is made.
42 Default Safety Lead Time + BC27 Δ BC28 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.
43 Blank Overflow Level + BC27 Δ BC28 Option Specifies how the planning system should react if the Overflow Level field on the item or SKU card is empty. OptionCaption: Allow Default Calculation,Use Item/SKU Values Only
44 Default Dampener Period + BC27 Δ BC28 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,…
45 Variant Mandatory if Exists Δ BC28 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.
50 Skip Prompt to Create Item Δ BC28 Boolean Specifies if a message about creating a new item card appears when you enter an item number that does not exist. DataClassification SystemMetadata
51 Copy Item Descr. to Entries Δ BC28 Boolean Specifies if you want the description on item cards to be copied to item ledger entries during posting. DataClassification SystemMetadata
60 Allow Inventory Adjustment Δ BC28 Boolean Specifies if you want to allow manual adjustment of the inventory in the item card.
180 Invt. Cost Jnl. Template Name Δ BC28 Code[10] Specifies the name of the journal template to use for automatic and expected cost posting. TableRelation Table 80 “Gen. Journal Template” (Gen. Journal Template)
181 Invt. Cost Jnl. Batch Name Δ BC28 Code[10] Specifies the name of the journal batch to use for automatic and expected cost posting. TableRelation Table 232 “Gen. Journal Batch” (if (“Invt. Cost Jnl. Template Name” = filter(<> ‘’)) “Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Invt. Cost Jnl. Template Name”)))
5700 Transfer Order Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to transfer orders. TableRelation Table 308 “No. Series” (No. Series)
5701 Posted Transfer Shpt. Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to posted transfer shipments. TableRelation Table 308 “No. Series” (No. Series)
5702 Posted Transfer Rcpt. Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to posted transfer receipts. TableRelation Table 308 “No. Series” (No. Series)
5703 Copy Comments Order to Shpt. Δ BC28 Boolean Specifies that you want to copy the comments entered on the transfer order to the transfer shipment.
5704 Copy Comments Order to Rcpt. Δ BC28 Boolean Specifies that you want to copy the comments entered on the transfer order to the transfer receipt.
5718 Nonstock Item Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to catalog items. TableRelation Table 308 “No. Series” (No. Series)
5790 Outbound Whse. Handling Time Δ BC28 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.
5791 Inbound Whse. Handling Time Δ BC28 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 + Saf…
5800 Expected Cost Posting to G/L Δ BC28 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 cost…
5801 Default Costing Method Δ BC28 Enum “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 c… enum Enum 28 “Costing Method”
5804 Average Cost Calc. Type Δ BC28 Enum “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 averag… enum Enum 5804 “Average Cost Calculation Type”; NotBlank
5805 Average Cost Period Δ BC25 Δ BC28 Enum “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 f… enum Enum 5806 “Average Cost Period Type”; NotBlank
5849 Allow Invt. Doc. Reservation Δ BC28 Boolean Specifies if you want to allow reservation for inventory receipts and shipments.
5850 Invt. Receipt Nos. Δ BC28 Code[20] Specifies the number series from which numbers are assigned to new records. TableRelation Table 308 “No. Series” (No. Series)
5851 Posted Invt. Receipt Nos. Δ BC28 Code[20] Specifies the number series from which numbers are assigned to new records. TableRelation Table 308 “No. Series” (No. Series)
5852 Invt. Shipment Nos. Δ BC28 Code[20] Specifies the number series from which numbers are assigned to new records. TableRelation Table 308 “No. Series” (No. Series)
5853 Posted Invt. Shipment Nos. Δ BC28 Code[20] Specifies the number series from which numbers are assigned to new records. TableRelation Table 308 “No. Series” (No. Series)
5854 Copy Comments to Invt. Doc. Δ BC28 Boolean Specifies that you want to copy the comments entered on the inventory document to the posted document.
5855 Direct Transfer Posting Δ BC28 Δ BC29 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. obsolete Pending 29.0; #if not CLEANSCHEMA31; OptionCaption: Receipt and Shipment,Direct Transfer
5856 Posted Direct Trans. Nos. Δ BC28 Code[20] Specifies the number series from which numbers are assigned to new records. TableRelation Table 308 “No. Series” (No. Series)
5857 Direct Transfer Posting Type + BC29 Enum “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. enum Enum 314 “Direct Transfer Posting Type”
5860 Package Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to item tracking packages. TableRelation Table 308 “No. Series” (No. Series)
5875 Phys. Invt. Order Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to physical inventory orders. TableRelation Table 308 “No. Series” (No. Series)
5876 Posted Phys. Invt. Order Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to physical inventory orders when they are posted. TableRelation Table 308 “No. Series” (No. Series)
5877 Invt. Orders Package Tracking + BC24 Δ BC26 Δ BC27 Boolean — obsolete Removed 27.0; #if not CLEANSCHEMA27
6500 Package Caption Δ BC28 Text[30] Specifies the alternative caption of Package tracking dimension that you want to use for captions for this dimension. For example, Size.
7101 Item Group Dimension Code Δ BC28 Code[20] Specifies the dimension code that you want to use for product groups in analysis reports. TableRelation Table 348 “Dimension”
7300 Inventory Put-away Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to inventory put-always. TableRelation Table 308 “No. Series” (No. Series)
7301 Inventory Pick Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to inventory picks. TableRelation Table 308 “No. Series” (No. Series)
7302 Posted Invt. Put-away Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to posted inventory put-always. TableRelation Table 308 “No. Series” (No. Series)
7303 Posted Invt. Pick Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to posted inventory picks. TableRelation Table 308 “No. Series” (No. Series)
7304 Inventory Movement Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to inventory movements. TableRelation Table 308 “No. Series” (No. Series)
7305 Registered Invt. Movement Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to registered inventory movements. TableRelation Table 308 “No. Series” (No. Series)
7306 Internal Movement Nos. Δ BC28 Code[20] Specifies the number series that will be used to assign numbers to internal movements. TableRelation Table 308 “No. Series” (No. Series)

Keys

  • Key1: Primary Key (clustered)

Events published

Trigger event subscribers

Procedures

  • GetRecordOnce()
  • OptimGLEntLockForMultiuserEnv(): Boolean
  • AutomaticCostAdjmtRequired(): Boolean
  • UseLegacyPosting(): Boolean + BC26
  • GetComponentsAtLocation(): Code[10] + BC27
  • SyncDirectTransferPostingOptionToEnum(DirectTransferPostingOption: Option) + BC29 (internal)
  • SyncDirectTransferPostingEnumToOption(DirectTransferPostingEnum: Enum "Direct Transfer Posting Type") + BC29 (internal)

Plus 5 local procedures.

Relations

Pages and codeunits on this table

Extended by

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

AT, CH, DE, RU

Deprecations

  • procedure SyncDirectTransferPostingEnumToOption: guarded (#if not CLEAN29)
  • procedure SyncDirectTransferPostingOptionToEnum: guarded (#if not CLEAN29)
  • field Invt. Orders Package Tracking: Removed 27.0 (#if not CLEANSCHEMA27), “Temporary setup to enable/disable package tracking in Phys. Inventory Orders”
  • field Direct Transfer Posting: Pending 29.0 (#if not CLEANSCHEMA31), “Replaced by field 5857 “Direct Transfer Posting Type” of type Enum “Direct Transfer Posting Type”.”

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: "Inventory Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources