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

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
Flushing Method Field, Item Table Manufacturing
Base Unit of Measure Field, Item Table Inventory
Reordering Policy Field, Item Table Inventory
Manufacturing Policy Field, Item Table Inventory
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
Type Field, Item Table Inventory
Excise Prod. Posting Group Field, Item Table Excise
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
Item Disc. Group Field, Item Table Inventory
Low-Level Code Field, Item Table Inventory
Capital Item Field, Item Table Excise
Allow Online Adjustment Field, Item Table Inventory
Safety Lead Time Field, Item Table Inventory
Duty Due % Field, Item Table Inventory
Purchases (LCY) Field, Item Table Inventory
Qty. on Purch. Order Field, Item Table Inventory
MRP Field, Item Table Excise
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
Assessable Value Field, Item Table Excise
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
Trans. Ord. Receipt (Qty.) Field, Item Table Inventory
PIT Structure Field, Item Table Excise
Price Includes VAT Field, Item Table Inventory
Res. Qty. on Job Order Field, Item Table Inventory
Standard Cost Field, Item Table Inventory
Serial No. Filter Field, Item Table Inventory
Variant Filter Field, Item Table Inventory
Fixed Asset Field, Item Table Income Tax
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
Declared Goods Field, Item Table Excise
Qty. on Prod. Order Field, Item Table Manufacturing
Scrap % Field, Item Table Inventory
Reserved Qty. on Purch. Orders Field, Item Table Inventory
Negative Adjmt. (Qty.) Field, Item Table Inventory
Single-Level Capacity Cost Field, Item Table Manufacturing
Purch. Req. Release (Qty.) Field, Item Table Manufacturing
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
MRP Price Field, Item Table Excise
Overhead Rate Field, Item Table Manufacturing
Res. Qty. on Asm. Comp. Field, Item Table Inventory
Costing Method Field, Item Table Inventory
Inventory Posting Group Field, Item Table Inventory
Stockout Warning 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
Qty. on Asm. Component Field, Item Table Inventory
Net Weight Field, Item Table Inventory
Planned Order Release (Qty.) Field, Item Table Manufacturing
Cost is Adjusted Field, Item Table Inventory
Price Inclusive of Tax Field, Item Table Excise
Substitutes Exist Field, Item Table Inventory
Last Date Modified Field, Item Table Inventory
Reserved Qty. on Inventory Field, Item Table Inventory
Planning Issues (Qty.) Field, Item Table Manufacturing
Last Unit Cost Calc. Date Field, Item Table Inventory
Cost is Posted to G/L Field, Item Table Inventory
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
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
Prevent Negative Inventory Field, Item Table Inventory
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
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
Reserve Field, Item Table Inventory
Tariff No. Field, Item Table Inventory
Prod. Forecast Quantity (Base) Field, Item Table Manufacturing
No. 2 Field, Item Table Inventory
Assembly Policy Field, Item Table Inventory
Routing No. Field, Item Table Manufacturing
Outputs (Qty.) Field, Item Table United States Local Functionality
Scheduled Need (Qty.) Field, Item Table Inventory
Rolled-up Cap. Overhead Cost Field, Item Table Manufacturing
Trans. Ord. Shipment (Qty.) Field, Item Table Inventory
Location Filter Field, Item Table Inventory
Single-Level Subcontrd. Cost Field, Item Table Manufacturing
Rel. Order Receipt (Qty.) Field, Item Table Manufacturing
Discrete Order Quantity Field, Item Table Inventory
Lot Size Field, Item Table Inventory
Planning Receipt (Qty.) Field, Item Table Manufacturing
Order Tracking Policy Field, Item Table Manufacturing
Planned Order Receipt (Qty.) Field, Item Table Manufacturing
Rel. Scheduled Receipt (Qty.) Field, Item Table United States Local Functionality
Transferred (Qty.) Field, Item Table Inventory
Safety Stock Quantity Field, Item Table Inventory
COGS (LCY) Field, Item Table Inventory
Component Forecast 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
Lead Time Calculation Field, Item Table Inventory
Single-Level Mfg. Ovhd Cost Field, Item Table Manufacturing
Time Bucket Field, Item Table Inventory
Unit List Price Field, Item Table Inventory
Production BOM No. Field, Item Table Manufacturing
Unit Price Field, Item Table Inventory
Rel. Scheduled Need (Qty.) Field, Item Table United States Local Functionality
Rolled-up Subcontracted Cost Field, Item Table Manufacturing
Profit % Field, Item Table Inventory
Global Dimension 2 Code Field, Item Table Inventory
Created From Nonstock Item Field, Item Table Inventory
Duty Class Field, Item Table United States Local Functionality
Qty. on Component Lines Field, Item Table Manufacturing
Abatement Percentage Field, Item Table Excise
Lot Accumulation Period Field, Item Table Inventory
Search Description Field, Item Table Inventory
Vendor Item No. Field, Item Table Inventory
Inventory Value Zero Field, Item Table Inventory
Blocked Field, Item Table Inventory
Single-Level Material Cost Field, Item Table Manufacturing
Res. Qty. on Assembly Order Field, Item Table Inventory
No. of Substitutes Field, Item Table Inventory
Critical Field, Item Table Manufacturing
Inventory Field, Item Table Inventory
Purch. Req. Receipt (Qty.) Field, Item Table Manufacturing
Single-Level Cap. Ovhd Cost Field, Item Table Manufacturing
Excise Accounting Type Field, Item Table Excise
Gen. Prod. Posting Group Field, Item Table Inventory
Durability Field, Item Table Inventory
FP Order Receipt (Qty.) Field, Item Table Manufacturing
Qty. on Sales Order Field, Item Table Inventory
Consumptions (Qty.) Field, Item Table United States Local Functionality
Overflow Level Field, Item Table Inventory
Planning Release (Qty.) Field, Item Table Manufacturing
Unit Volume Field, Item Table Inventory
Reverse Charge Applies Field, Item Table United Kingdom Local Functionality
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
Rolled-up Mfg. Ovhd Cost Field, Item Table Manufacturing
Scrap Item Field, Item Table Excise
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
WHT Product Posting Group Field, Item Table New Zealand Local Functionality
Gross Weight Field, Item Table Inventory
Res. Qty. on Req. Line Field, Item Table Inventory
Country/Region Purchased Code Field, Item Table Inventory
Subcontracting Field, Item Table India Local Functionality
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
Sub. Comp. Location Field, Item Table India Local Functionality
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
Res. Qty. on Service Orders Field, Item Table Service Management
Qty. on Service Order Field, Item Table Service Management
Unit Cost Field, Item Table General Ledger
Service Item Group Field, Item Table Service Management
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
Cost Regulation % Field, Item Table Spain Local Functionality
Inventory Valuation Field, Item Table Italy Local Functionality
Lifo Category Field, Item Table Italy Local Functionality

See Also

Reference

Inventory Posting Groups

Other Resources

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