Specifications
Chapter 5. Inventory
150 Dim11
3 HAND TOOLS 6 NON-COMMODITY INVENTORY
You will see the use of groups quite frequently throughout the system. Whenever
you see it, it refers to the first 2 digits of the item number specifying a major
category of items. The most significant uses of groups are:
1. Sales Analysis by Group Report - shows the sales, cost, and margin by
group.
2. Sales Analysis Reports by various entities:
w Customer Class by Group - shows what different types of customers
are buying by group.
w Assigned Sales Rep by Group - shows what assigned salesmen are
selling by group (can be used to figure commissions).
w Written By Sales Rep by Group - shows what written by salesmen
are selling by group.
w Customer by Group - shows what individual customers are buying by
group.
3. General Ledger Distribution - organize financial statements to show
sales and cost of sales by inventory group.
4. Matrix and bid pricing.
5. Spiff (sale) pricing.
6. Suggested orders.
Sections
Sections can further subdivide similar items within each group. The second two
digits of the item number represent the section. You can have up to 99 sections
per group. Most inventory reports are subtotaled by section and then by group.
The short description sometimes represents a section.
Sections are useful to break down groups such as dimensional lumber because
there are many types and grades of lumber. For example, group 51,
DIMENSIONAL LUMBER, might have the following sections:
SECTION DESCRIPTION
01 STUDS-DIM.
03 DOUG FIR-DIM.
05 HEM FIR-DIM.
07 FIR LARCH-DIM.
09 SPRICE/PINE/FIR-DIM.
11 SO. YELLOW PINE-DIM.
13 WHITE WOOD-DIM.
15 MIXED SPECIES-DIM.
17 STRESS RATED-DIM.
99 MISC. DIMENSIONAL