Tables Microsoft Great Plains
2010 and MS Dynamics GP 10
- IV00101 – Item Master
- IV00102 – Item Quantity Master
- IV00103 – Item Vendor Master
- IV00107 – Item Price List Options
- IV00108 – Item Price List
- IV00118 – Item Cost Change History
- IV00200 – Item Serial Number Master
- IV00300 – Lot Number Master
- IV00301 – Lot Attribute Master
- IV10000 – Unposted/Work Transactions (Main Table)
- IV10001 – Unposted/Work Transactions (Detailed Table)
- IV10002 – Serial and Lot Number Work
- IV10200 – Purchase Receipts (Main Table)
- IV10201 – Purchase Receipts Detail (Detailed Table)
- IV10300 – Unposted Stock Count (Main Table)
- IV10301 – Unposted Stock Count (Detailed Table)
- IV30101 – Sales Summary History
- IV30102 – Sales Summary Period History
- IV30200 – Transaction History (Main Table)
- IV30300 – Transaction Amounts History (Detailed Table)
- IV30301 – Transaction Amounts Detail History
- IV30400 – Serial and Lot Number History
- IV30500 – Distribution History
- IV30600 – Lot Attribute History
- IV30700 – Stock Count History (Main Table)
- IV30701 – Stock Count Line History (Detailed Table)
- IV40400 – Item Class Setup
- IV40201 – U of M Schedule Setup (Main Table)
- IV40202 – U of M Schedule Detail Setup
- IV40600 – Item Category Setup
- IV40700 – Site Setup
Bill of Materials Tables:
- BM00101 – Bill of Materials Header
- BM00111 – Bill of Materials Component
- BM10200 – Assembly Transaction (Main Table)
- BM10300 – Assembly Component (Detailed Table)
- BM10400 – Assembly Serial/Lot
- BM30100 – Assembly Batch History
- BM30200 – Assembly Transaction History (Main Table)
- BM30300 – Assembly Component History (Detailed Table)
- BM30400 – Assembly Serial/Lot History
- BM40100 – Bill of Materials Setup
Inventory Transaction Document Types:
- 1 – Inventory Adjustment
- 2 – Variance
- 3 – Inventory Transfer
- 4 – Purchase Receipt
- 5 – Sales Returns
- 6 – Sales Invoices
- 7 – Assembly
- 8 – Inventory cost adjustment from POP Shipment (transaction source GLTRX)
- 11 – Inventory cost adjustment from POP Invoice (transaction source POIVC)
Inventory Valuation Methods:
- 1 – FIFO Perpetual
- 2 – LIFO Perpetual
- 3 – Average Perpetual
- 4 – FIFO Periodic
- 5 – LIFO Periodic
GP Item Types:
- 1 – Sales Inventory
- 2 – Discontinued
- 3 – Kit
- 4 – Misc Charges
- 5 – Services
- 6 – Flat Fee
RCRDTYPE (Record Type) Column in IV00102 Table:
- 1 – Overall record (total for all sites)
- 2 – Site record
ORDERPOLICY (Order Policy) Column in IV00102 Table:
- 1 – Not planned
- 2 – Lot for Lot
- 3 – Fixed Order Quantity
- 4 – Period Order Quantity
- 5 – Order Point
- 6 – Manually Planned
ITMVNDTY (Item Vendor Type) in Column IV00103 Table:
- 1 – Primary Vendor
- 2 – Non-primary Vendor
Quantity Types:
- 1 – On Hand
- 2 – Returned
- 3 – In Use
- 4 – In Service
- 5 – Damaged
Decimal Places:
- 1 – 0
- 2 – 1
- 3 – 2
- 4 – 3
- 5 – 4
- 6 – 5
TAXOPTNS and Purchase_Tax_Options (Tax Options in GP):
- 1 – Taxable
- 2 – Nontaxable
- 3 – Base on customer / vendor
ITMTRKOP (Item Tracking Option IN GP):
- 1 – None
- 2 – Serial Numbers
- 3 – Lot Numbers
PRICMTHD (Price Method):
- 1 – Currency Amount
- 2 – % of List Price
- 3 – % Markup – Current Cost
- 4 – % Markup – Standard Cost
- 5 – % Margin – Current Cost
- 6 – % Margin – Standard Cost
KTACCTSR (Kit COGS Account Source):
- 0 – COGS accounts from component items
- 1 – COGS account from kit
PSTGSTUS (Posting Status IN GP) Column in IV10000 Table:
- 0 – New Transaction
- 1 – Unposted
- 2 – Posted
- 3 – Posted with Error
Source Indicator Column in IV10000 Table:
- 1 – (none)
- 2 – Issue
- 3 – Reverse Issue
- 4 – Finished Good Post
- 5 – Reverse Finished Good Post
- 6 – Stock Count
- 7 – Field Service – Service Call
- 8 – Field Service – Return Material Authorization
- 9 – Field Service – Return to Vendor
- 10 – Field Service – Work Order
- 11 – Project Accounting
STCKCNTSTTS (Stock Count Status):
- 1 – Available
- 2 – Started
- 3 – Entered
SMRYTYPE (Summary Type):
- 1 – Calendar
- 2 – Fiscal
Account Indexes:
- IVIVINDX – Inventory On Hand
- IVIVOFIX – Inventory Offset
- IVCOGSIX – Cost of Goods Sold
- IVSLSIDX – Sales
- IVSLDSIX – Markdowns
- IVSLRNIX – Sales Returns
- IVINUSIX – In Use
- IVINSVIX – In Service
- IVDMGIDX – Damaged
- IVVARIDX – Variance
- DPSHPIDX – Drop Ship Items
- PURPVIDX – Purchase Price Variance
- UPPVIDX – Unrealized Purchase Price Var
- IVRETIDX – Inventory Returns
- ASMVRIDX – Assembly Variance
PCHSRCTY Column in IV10200 Table
- 1 – Adjustment
- 2 – Variance
- 3 – Transfer
- 4 – Override
- 5 – Receipt
- 6 – Return
- 7 – Assembly
- 8 – In-Transit
The tables related to the Inventory, Finance and Sales modules in the Dynamics GP.
Here you can create the content that will be used within the module.
Recent Blogs
Why Shopify and NetSuite Integration is Crucial for Your eCommerce Success
Why Shopify and NetSuite Integration is Crucial for Your eCommerce Success Author Category Share The digital transformation of commerce is accelerating. According to Gartner, by 2025, a...
Streamlining eCommerce Business with Adobe Commerce (Magento) and NetSuite Integration
Streamlining eCommerce Business with Adobe Commerce (Magento) and NetSuite Integration Author Category Share In the ever-evolving world of commerce, managing eCommerce operations can feel...
B2B e-commerce – How Home Depot is leading the game
B2B eCommerce – How Home Depot is leading the game Author Category Share The home improvement industry has undergone a remarkable transformation, and at the heart of this change is the rise...