Item Maintenance

The Item Maintenance template has the following fields, the table also includes any restrictions regarding the field inputs:

FieldRestrictions
Item Number*Max Characters:30
Item DescriptionMax Characters:100
Short DescriptionMax Characters:15
Generic DescriptionMax Characters:10
Class IdMax Characters:10
InactiveActive / Inactive
Item TypeItem type 1=Sales inventory; 2=Discontinued; 3=Kit; 4=Miscellaneous charges; 5=Services; 6=Flat fee Default is one on new record
Valuation MethodValuation method: 0=Any ITEMTYPE other than 1 or 2; 1=FIFO perpetual; 2=LIFO perpetual; 3=Average perpetual; 4=FIFO periodic; 5=LIFO periodic Default is one on new record
Sales Tax OptionsSales tax options: 1=Taxable; 2=Nontaxable; 3=Base on customers Default is one on new record
Tax Schedule IdMax Characters:15
Unit Of Measure Schedule IdMax Characters:10
Shipping WeightShipping weight; only used when ITEMTYPE=1, 2, or 3
Quantity DecimalsQuantity Decimals; DECPLQTY can equal 0, 1, 2, 3, 4, or 5; if ITEMTYPE=3, then DECPLQTY must be set to zero Default is zero on new record
Tax Community CodeTax community code; only used if the Enable Intrastat Tracking option is enabled in Company Setup Max Characters:30
Country OriginCountry origin; only used if the Enable Intrastat Tracking option is enabled in Company Setup Max Characters:6
Currency DecimalsCurrency Decimals; used for item if not registered for multi-currency or used for functional currency
Purchasing Tax OptionPurchasing tax option: 1=Taxable; 2=Nontaxable; 3=Base on vendors Default is one on new record
Purchase Tax Schedule IdMax Characters:15
Standard Cost
Current Cost
Note TextMax Characters:8000
Alternate Item 1Max Characters:30
Alternate Item 2Max Characters:30
Item TrackingItem tracking: 1=None; 2=Serial Numbers; 3=Lot Numbers Used when ITEMTYPE= 1 or 2 Default is one on new record
Lot CategoryMax Characters:10
Lot Expiration WarnLot Expiration Warn: 0 = no warning 1 = warnings enabled If this item is not lot tracked, the value of this element is not used.
Days Before Lot ExpiresDays Before Lot Expires: Valid entries equal 0 - 999. If LOTEXPWARN is 0 then LOTEXPWARNDAYS always defaults to 0.
Include In Demand PlanningInclude in Demand Planning; 0=Do Not Include; 1=Include Default is zero on new record
Minimum Shelf Life 1Minimum shelf life 1: Valid entries equal 0-9999 Use when ITMTRKOP=3 Default is zero on new record
Minimum Shelf Life 2Minimum shelf life 2: Valid entries equal 0-9999 Use when ITMTRKOP=3 Default is zero on new record
Allow Back OrdersAllow back orders: 0=Do not allow back orders; 1=Allow back orders Default is zero on new record
Warranty DaysWarranty days; valid entries equal 0-9999 Default is zero on new record
Abc CodeABC code: 1=None; 2=A; 3=B; 4=C Default is one on new record
User Category 1Max Characters:10
User Category 2Max Characters:10
User Category 3Max Characters:10
User Category 4Max Characters:10
User Category 5Max Characters:10
User Category 6Max Characters:10
Maintain History—Calendar YearMaintain history—calendar year: 0=Do not keep history; 1=Keep history Default is 0 on new record
Maintain History—Fiscal YearMaintain history—fiscal year: 0=Do not keep history; 1=Keep history Default is 0 on new record
Maintain History—TransactionMaintain history—transaction: 0=Do not keep history; 1=Keep history Default is 0 on new record
Maintain History—DistributionMaintain history—distribution: 0=Do not keep history; 1=Keep history Default is 0 on new record
Inventory AccountMax Characters:75
Inventory Offset AccountMax Characters:75
Cost Of Goods Sold AccountMax Characters:75
Sales AccountMax Characters:75
Markdown AccountMax Characters:75
Sales Return AccountMax Characters:75
In Use AccountMax Characters:75
In Service AccountMax Characters:75
Damaged AccountMax Characters:75
Variance AccountMax Characters:75
Drop-Ship Items AccountMax Characters:75
Purchase Price Variance AccountMax Characters:75
Unrealized Purchase Price Variance AccountMax Characters:75
Inventory Returns AccountMax Characters:75
Assembly Variance AccountMax Characters:75
Cost Of Goods Sold Account SourceCost of goods sold account source: 0=From component item; 1=From kit item Default is zero on new record
Standard Cost RevaluationManuf. System Max Characters:75
Applied - Material Fixed OHManuf. System Max Characters:75
Applied - Material Var. OHManuf. System Max Characters:75
Variance - LaborManuf. System Max Characters:75
Variance - Labor Var. OHManuf. System Max Characters:75
Variance - MachineManuf. System Max Characters:75
Variance - Mach. Fixed OHManuf. System Max Characters:75
Variance - Mach. Var. OHManuf. System Max Characters:75
Variance - MaterialManuf. System Max Characters:75
Variance - Mat. Fixed OHManuf. System Max Characters:75
Variance - Mat. Var. OHManuf. System Max Characters:75
WIP - MaterialManuf. System Max Characters:75
WIP - Material Fixed OHManuf. System Max Characters:75
WIP - Material Var. OHManuf. System Max Characters:75
WIP - LaborManuf. System Max Characters:75
WIP - Labor Fixed OHManuf. System Max Characters:75
WIP - Labor Var. OHManuf. System Max Characters:75
WIP - MachineManuf. System Max Characters:75
WIP - Machine Fixed OHManuf. System Max Characters:75
WIP - Machine Var. OHManuf. System Max Characters:75
CoGS - MaterialManuf. System Max Characters:75
CoGS - Material Fixed OHManuf. System Max Characters:75
CoGS - Material Var. OHManuf. System Max Characters:75
CoGS - LaborManuf. System Max Characters:75
CoGS - Labor Fixed OHManuf. System Max Characters:75
CoGS - Labor Var. OHManuf. System Max Characters:75
CoGS - MachineManuf. System Max Characters:75
CoGS - Machine Fixed OHManuf. System Max Characters:75
CoGS - Machine Var. OHManuf. System Max Characters:75
Inventory - Mat. Fixed OHManuf. System Max Characters:75
Inventory - Mat. Var. OHManuf. System Max Characters:75
Inventory - LaborManuf. System Max Characters:75
Inventory - Labor Fixed OHManuf. System Max Characters:75
Inventory - Labor Var. OHManuf. System Max Characters:75
Inventory - MachineManuf. System Max Characters:75
Inventory - Mach. Fixed OHManuf. System Max Characters:75
Inventory - Mach. Var OHManuf. System Max Characters:75
Selling Unit Of MeasureManuf. System Max Characters:75
Purchasing Unit Of MeasureMax Characters:8
Revalue Inventory For Cost VarianceMax Characters:8
Tolerance PercentageRevalue inventory for cost variance: 0=Do not revalue; 1=Revalue Default is zero on new record
Location Code
Price MethodLocation code; assigns site to item if it is not already assigned Max Characters:10
Price GroupPrice method: 1=Currency amount; 2=Percent of List price; 3=Percent of markup of current cost; 4=Percent markup of standard cost; 5=Percent margin of current cost; 6=Percent margin of standard cost Default is one
Use Item ClassFlag to have class setting roll down to elements that are not passed in; uses the ITMCLSCD class (Yes/Empty=No

Keep an eye on our social media for updates on changes coming to TitaniumGP. We hope to see you! Privacy Policy

link to LinkedIn
link to Facebook
link to Twitter
link to Instagram

Powered by BetterDocs