Share via

Item Table

  • Article

Specifies information about items in your inventory.

The Item table manages the inventory. For each item there is a card, on which you enter basic information, such as name, units of measure, inventory location, and unit price. Quantity changes in inventory are stored in the Item Ledger Entry table, and changes in inventory value are stored in the Value Entry table.

Each item must have a number for identification purposes. When you enter the number in Item No. fields elsewhere in the program (on a sales quote, for example), the program automatically uses the information associated with the number.

Before you can post purchases, sales, and inventory adjustments, you must set up links from the item card to the general ledger. This is done through inventory posting groups, general product posting groups, and the general posting setup.

The program can display items in two different windows:

All items must be set up in this table.

List of Fields in the Table

Field Location
Excise Prod. Posting Group Field, Item Table Excise
Capital Item Field, Item Table Excise
MRP Value Field, Item Table Excise
Assessable Value Field, Item Table Excise
PIT Structure Field, Item Table Excise
Fixed Asset Field, Item Table Income Tax
Declared Goods Field, Item Table Excise
MRP Price Field, Item Table Excise
Reverse Charge Applies Field, Item Table United Kingdom Local Functionality
Price Inclusive of Tax Field, Item Table Excise
Subcontracting Field, Item Table India Local Functionality
Inventory Valuation Field, Item Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Sub. Comp. Location Field, Item Table India Local Functionality
Lifo Category Field, Item Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Abatement % Field, Item Table Excise
Cost Regulation % Field, Item Table Spain Local Functionality
Res. Qty. on Service Orders Field, Item Table Service Management
Qty. on Service Order Field, Item Table Service Management
Excise Accounting Type Field, Item Table Excise
Next Counting Period Field, Item Table Warehouse Management Systems
Scrap Item Field, Item Table Excise
Last Phys. Invt. Date Field, Item Table Warehouse Management Systems
Put-away Unit of Measure Code Field, Item Table Warehouse Management Systems
Phys Invt Counting Period Code Field, Item Table Warehouse Management Systems
Special Equipment Code Field, Item Table Warehouse Management Systems
Last Counting Period Update Field, Item Table Warehouse Management Systems
Put-away Template Code Field, Item Table Warehouse Management Systems
Identifier Code Field, Item Table Warehouse Management Systems
Service Item Group Field, Item Table Service Management
Use Cross-Docking Field, Item Table Warehouse Management Systems
Freight Type Field, Item Table Inventory
Expiration Calculation Field, Item Table Inventory
Maximum Order Quantity Field, Item Table Inventory
Positive Adjmt. (LCY) Field, Item Table Inventory
Allow Invoice Disc. Field, Item Table Inventory
Rolled-up Material Cost Field, Item Table Inventory
Order Multiple Field, Item Table Inventory
No. Series Field, Item Table Inventory
Reserved Qty. on Sales Orders Field, Item Table Inventory
Country/Region of Origin Code Field, Item Table Inventory
Rolled-up Capacity Cost Field, Item Table Inventory
Budget Quantity Field, Item Table Inventory
Qty. on Prod. Order Field, Item Table Manufacturing
Item Disc. Group Field, Item Table Inventory
Low-Level Code Field, Item Table Inventory
Single-Level Capacity Cost Field, Item Table Manufacturing
Allow Online Adjustment Field, Item Table Inventory
Safety Lead Time Field, Item Table Inventory
Purch. Req. Release (Qty.) Field, Item Table Manufacturing
Duty Due % Field, Item Table Inventory
Purchases (LCY) Field, Item Table Inventory
Qty. on Purch. Order Field, Item Table Inventory
Item Tracking Code Field, Item Table Inventory
Net Invoiced Qty. Field, Item Table Inventory
VAT Prod. Posting Group Field, Item Table Inventory
Item Category Code Field, Item Table Inventory
Duty Code Field, Item Table Inventory
Reorder Quantity Field, Item Table Inventory
Net Change Field, Item Table Inventory
Budgeted Amount Field, Item Table Inventory
Price Unit Conversion Field, Item Table Inventory
Global Dimension 1 Filter Field, Item Table Inventory
Planned Order Release (Qty.) Field, Item Table Manufacturing
Trans. Ord. Receipt (Qty.) Field, Item Table Inventory
Price Includes VAT Field, Item Table Inventory
Res. Qty. on Job Order Field, Item Table Inventory
Planning Issues (Qty.) Field, Item Table Manufacturing
Standard Cost Field, Item Table Inventory
Serial No. Filter Field, Item Table Inventory
Variant Filter Field, Item Table Inventory
Positive Adjmt. (Qty.) Field, Item Table Inventory
Scheduled Receipt (Qty.) Field, Item Table Inventory
Negative Adjmt. (LCY) Field, Item Table Inventory
Units per Parcel Field, Item Table Inventory
Dampener Period Field, Item Table Inventory
Scrap % Field, Item Table Inventory
Reserved Qty. on Purch. Orders Field, Item Table Inventory
Negative Adjmt. (Qty.) Field, Item Table Inventory
Description 2 Field, Item Table Inventory
Qty. on Job Order Field, Item Table Inventory
Budget Profit Field, Item Table Inventory
Dampener Quantity Field, Item Table Inventory
Alternative Item No. Field, Item Table Inventory
Rounding Precision Field, Item Table Inventory
Res. Qty. on Asm. Comp. Field, Item Table Inventory
Prod. Forecast Quantity (Base) Field, Item Table Manufacturing
Routing No. Field, Item Table Manufacturing
Costing Method Field, Item Table Inventory
Inventory Posting Group Field, Item Table Inventory
Production Forecast Name Field, Item Table Inventory
Reserved Qty. on Prod. Order Field, Item Table Inventory
Replenishment System Field, Item Table Inventory
Rolled-up Cap. Overhead Cost Field, Item Table Manufacturing
Qty. on Asm. Component Field, Item Table Inventory
Net Weight Field, Item Table Inventory
Cost is Adjusted Field, Item Table Inventory
Single-Level Subcontrd. Cost Field, Item Table Manufacturing
Rel. Order Receipt (Qty.) Field, Item Table Manufacturing
Substitutes Exist Field, Item Table Inventory
Planning Receipt (Qty.) Field, Item Table Manufacturing
Last Date Modified Field, Item Table Inventory
Reserved Qty. on Inventory Field, Item Table Inventory
Order Tracking Policy Field, Item Table Manufacturing
Last Unit Cost Calc. Date Field, Item Table Inventory
Cost is Posted to G/L Field, Item Table Inventory
Planned Order Receipt (Qty.) Field, Item Table Manufacturing
Shelf No. Field, Item Table Inventory
Sales (Qty.) Field, Item Table Inventory
VAT Bus. Posting Gr. (Price) Field, Item Table Inventory
Date Filter Field, Item Table Inventory
Component Forecast Field, Item Table Manufacturing
Transferred (LCY) Field, Item Table Inventory
Res. Qty. on Prod. Order Comp. Field, Item Table Inventory
Indirect Cost % Field, Item Table Inventory
Duty Unit Conversion Field, Item Table Inventory
Qty. Assigned to ship Field, Item Table Inventory
Single-Level Mfg. Ovhd Cost Field, Item Table Manufacturing
Production BOM No. Field, Item Table Manufacturing
Qty. on Assembly Order Field, Item Table Inventory
Statistics Group Field, Item Table Inventory
Global Dimension 2 Filter Field, Item Table Inventory
Price/Profit Calculation Field, Item Table Inventory
Drop Shipment Filter Field, Item Table Inventory
Rolled-up Subcontracted Cost Field, Item Table Manufacturing
Vendor No. Field, Item Table Inventory
Rescheduling Period Field, Item Table Inventory
Purch. Unit of Measure Field, Item Table Inventory
Reorder Point Field, Item Table Inventory
Global Dimension 1 Code Field, Item Table Inventory
Qty. on Component Lines Field, Item Table Manufacturing
Reserve Field, Item Table Inventory
Tariff No. Field, Item Table Inventory
No. 2 Field, Item Table Inventory
Assembly Policy Field, Item Table Inventory
Scheduled Need (Qty.) Field, Item Table Inventory
Trans. Ord. Shipment (Qty.) Field, Item Table Inventory
Location Filter Field, Item Table Inventory
Single-Level Material Cost Field, Item Table Manufacturing
Discrete Order Quantity Field, Item Table Inventory
Lot Size Field, Item Table Inventory
Critical Field, Item Table Manufacturing
Transferred (Qty.) Field, Item Table Inventory
Purch. Req. Receipt (Qty.) Field, Item Table Manufacturing
Safety Stock Quantity Field, Item Table Inventory
COGS (LCY) Field, Item Table Inventory
Single-Level Cap. Ovhd Cost Field, Item Table Manufacturing
Cost of Open Production Orders Field, Item Table Inventory
Assembly BOM Field, Item Table Inventory
Purchases (Qty.) Field, Item Table Inventory
Commission Group Field, Item Table Inventory
Include Inventory Field, Item Table Inventory
FP Order Receipt (Qty.) Field, Item Table Manufacturing
Lead Time Calculation Field, Item Table Inventory
Time Bucket Field, Item Table Inventory
Unit List Price Field, Item Table Inventory
Planning Release (Qty.) Field, Item Table Manufacturing
Unit Price Field, Item Table Inventory
Profit % Field, Item Table Inventory
Global Dimension 2 Code Field, Item Table Inventory
Created From Nonstock Item Field, Item Table Inventory
Lot Accumulation Period Field, Item Table Inventory
Search Description Field, Item Table Inventory
Vendor Item No. Field, Item Table Inventory
Rolled-up Mfg. Ovhd Cost Field, Item Table Manufacturing
Inventory Value Zero Field, Item Table Inventory
Blocked Field, Item Table Inventory
Res. Qty. on Assembly Order Field, Item Table Inventory
No. of Substitutes Field, Item Table Inventory
Inventory Field, Item Table Inventory
Gen. Prod. Posting Group Field, Item Table Inventory
Durability Field, Item Table Inventory
Qty. on Sales Order Field, Item Table Inventory
Overflow Level Field, Item Table Inventory
Unit Volume Field, Item Table Inventory
Minimum Order Quantity Field, Item Table Inventory
Tax Group Code Field, Item Table Inventory
Res. Qty. on Outbound Transfer Field, Item Table Inventory
Comment Field, Item Table Inventory
Lot No. Filter Field, Item Table Inventory
Sales Unit of Measure Field, Item Table Inventory
Picture Field, Item Table Inventory
Manufacturer Code Field, Item Table Inventory
Sales (LCY) Field, Item Table Inventory
Gross Weight Field, Item Table Inventory
Res. Qty. on Req. Line Field, Item Table Inventory
Country/Region Purchased Code Field, Item Table Inventory
Automatic Ext. Texts Field, Item Table Inventory
Qty. Picked Field, Item Table Inventory
Lot Nos. Field, Item Table Inventory
Stockkeeping Unit Exists Field, Item Table Inventory
Qty. in Transit Field, Item Table Inventory
Maximum Inventory Field, Item Table Inventory
Last Direct Cost Field, Item Table Inventory
Application Wksh. User ID Field, Item Table Inventory
Bin Filter Field, Item Table Inventory
No. Field, Item Table Inventory
Description Field, Item Table Inventory
Product Group Code Field, Item Table Inventory
Serial Nos. Field, Item Table Inventory
Res. Qty. on Inbound Transfer Field, Item Table Inventory
Excise Prod. Posting Group Field, Item Table India Excise
Capital Item Field, Item Table India Excise
MRP Value Field, Item Table India Excise
Assessable Value Field, Item Table India Excise
PIT Structure Field, Item Table India Excise
Fixed Asset Field, Item Table India Income Tax
Declared Goods Field, Item Table India Excise
MRP Price Field, Item Table India Excise
Price Inclusive of Tax Field, Item Table India Excise
Subcontracting Field, Item Table India Local Functionality
Sub. Comp. Location Field, Item Table India Local Functionality
Abatement % Field, Item Table India Excise
Excise Accounting Type Field, Item Table India Excise
Scrap Item Field, Item Table India Excise
Flushing Method Field, Item Table Inventory
Base Unit of Measure Field, Item Table Inventory
Reordering Policy Field, Item Table Inventory
Manufacturing Policy Field, Item Table Inventory
Unit Cost Field, Item Table Inventory
Outputs (Qty.) Field, Item Table United States Local Functionality
Rel. Scheduled Receipt (Qty.) Field, Item Table United States Local Functionality
Rel. Scheduled Need (Qty.) Field, Item Table United States Local Functionality
Duty Class Field, Item Table United States Local Functionality
Consumptions (Qty.) Field, Item Table United States Local Functionality
WHT Product Posting Group Field, Item Table New Zealand Local Functionality
Sale blocked Field, Item Table Switzerland Local Functionality
Inventory Price Field, Item Table Switzerland Local Functionality
Purchase blocked Field, Item Table Switzerland Local Functionality
Location Code Field, Item Table Switzerland Local Functionality
No Stockkeeping Field, Item Table Switzerland Local Functionality
Description Field, Item Table Switzerland Local Functionality
Excise Prod. Posting Group Field, Item Table Excise
Capital Item Field, Item Table Excise
MRP Field, Item Table Excise
Assessable Value Field, Item Table Excise
PIT Structure Field, Item Table Excise
Fixed Asset Field, Item Table Income Tax
Declared Goods Field, Item Table Excise
MRP Price Field, Item Table Excise
Price Inclusive of Tax Field, Item Table Excise
Abatement Percentage Field, Item Table Excise
Excise Accounting Type Field, Item Table Excise
Scrap Item Field, Item Table Excise
Subcontracting Field, Item Table India Local Functionality
Sub. Comp. Location Field, Item Table India Local Functionality
Overhead Rate Field, Item Table Manufacturing

See Also

Reference

Inventory Posting Groups

Other Resources

Gen. Product Posting Groups
General Posting Setup.
How to: Set Up Items