Inventory Posting Setup

DynamicsDocs.comInventory Posting Setup«Table 5813»Inventory Posting SetupLocation Code [PK]Invt. Posting Group Code [PK,NN]Inventory AccountDescriptionUsed in Ledger EntriesInventory 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]DescriptionUsed in ItemsUsed in Value Entries«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....<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


# Name Type
1 Location Code (Location Code) Code10
2 Invt. Posting Group Code (Invt. Posting Group Code) Code20 NotBlank: Yes
6 Inventory Account (Inventory Account) Code20
20 Description (Description) Text50
40 Used in Ledger Entries (Used in Ledger Entries) Integer Editable: No
5800 Inventory Account (Interim) (Inventory Account (Interim)) Code20
99000750 WIP Account (WIP Account) Code20
99000753 Material Variance Account (Material Variance Account) Code20
99000754 Capacity Variance Account (Capacity Variance Account) Code20
99000755 Mfg. Overhead Variance Account (Mfg. Overhead Variance Account) Code20
99000756 Cap. Overhead Variance Account (Cap. Overhead Variance Account) Code20
99000757 Subcontracted Variance Account (Subcontracted Variance Account) Code20


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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field