Diagrams


Table

Inventory Posting Setup

DynamicsDocs.comInventory Posting Setup«Table 5813»Inventory Posting SetupLocation Code [PK]Invt. Posting Group Code [PK,NN]Inventory AccountInventory Account [Interim]WIP AccountMaterial Variance AccountCapacity Variance AccountMfg. Overhead Variance AccountCap. Overhead Variance AccountSubcontracted Variance Account«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...<Location Code><Invt. Posting Group Code><Inventory Account><Inventory Account (Interim)><WIP Account><Material Variance Account><Capacity Variance Account><Mfg. Overhead Variance Account><Cap. Overhead Variance Account><Subcontracted Variance Account>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Location Code Code10
2 Invt. Posting Group Code Code10 NotBlank: Yes
6 Inventory Account Code20
5800 Inventory Account (Interim) Code20
99000750 WIP Account Code20
99000753 Material Variance Account Code20
99000754 Capacity Variance Account Code20
99000755 Mfg. Overhead Variance Account Code20
99000756 Cap. Overhead Variance Account Code20
99000757 Subcontracted Variance Account Code20

Keys

# Fields
0 Location Code,Invt. Posting Group Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Subcontracted Variance Account G/L Account No. 1..n
Invt. Posting Group Code Inventory Posting Group Code 1..n
Location Code Location Code 1..n

Table Relations From Other Tables

From Table From Field