From the Tasks menu at the top of the screen, select Inventory Items. The
Maintain Inventory Items window displays. Or from the Navigator on the bottom
of the screen, select Inventory, then Maintain Inventory from the Task Folder.
Inventory item header fields are located above the folder tabs of the Maintain
Inventory Items window. This is where you enter lookup information about the
item such as item ID, name, short description for lists, item class (type of
inventory item), and item status.
#1. Inventory Item ID: This identifies the item in lookup lists. Enter an ID
of up to 20 alphanumeric characters for a new inventory item. You cannot use *,
?, or + in the ID code. Inventory items are listed numerically and
alphabetically by ID code, with numbers coming before letters. Remember that
the ID code is case sensitive, so that codes A1 and a1 are seen as two different
Inventory Items. (See separate Instructions for Formatting Inventory Item ID
numbers)
#2. Description: This description is the short description that appears in
the item lookup lists. You can enter longer descriptions that can be used in
sales or purchase transactions on the General tab.
(1) Manufacturer: = 1st three letters (ex: SEN = Sentex; BYA = Byan Systems)
or Material: = three letters (ex: Steel = STL, Aluminum = ALM). Then enter a {SPACE}.
(2) What it is: = 11 letters max - The type of Item it is:
(ex: CARD READER, OPERATOR, FLAT BAR, TUBING). Then enter a {COMMA) or {SPACE}
(3) MFG Part Number or Size: 13 character spaces. Use spaces, slashes,
or dashes (THIS DESCRIPTION SHOULD BE AN EASY WAY TO IDENTIFY THE ITEM). For
size example: IAFB143420 = 1/4 x 3/4 x 20' ALM FLAT BAR
#3. Item Class: This identifies the type of inventory item. Select an item
type from the drop-down list. Choose between non-stock, stock, description only,
assembly, service, labor, activity, or charge. Once an item class is
established (saved) for an inventory item, it cannot be changed.
Stock Item: If an item can be tracked for job costing purposes, then it is a
stock item. These items must be accounted for on your material expense tickets
for each job. If you can determine the quantity used for a specific job, then
it is a stock item. (ex: operators, card readers, flat bar, square tubing, etc.)
Non-Stock Item: If an item cannot be tracked for job costing purposes, then
it is a non-stock item. These items cannot be accounted for on your material
expense tickets for each job. If you cannot determine the quantity used for a
specific job, then it is a non-stock item. Also, all consumable items would be
non-stock items (ex: nuts, screws, rags, blades, drill bits, paint, gas, etc.).
An example of a non-stock item other than a consumable is Rentals.
NOTE: If you have any questions whether an item is stock or non-stock, please
see Larry, Trisha or JoAnne. Do not select any other Class without verifying
with Trisha or JoAnne.
#4. Inactive: If you no longer plan to use an inventory item, you can mark
the item as inactive. Once an inventory item record is inactive, Peachtree
displays a warning when you try to sell an inventory item.
Select the General Tab of the Maintain Inventory Items window to enter basic
information about the inventory item such as item ID, name, description, account
numbers, sales price and quantity on hand, and beginning balances, among other
things.
#5. Description: Default setting shows "for Sale" - The description that you
enter here will appear in Quotes, Sales Orders, Sales/Invoicing, that your
customers will see and in Receipts. You can enter up to 160 characters to
describe this item.
#6. Click on the hourglass and change to Description for Purchases. The
description that you enter here will appear in Purchase Orders,
Purchases/Receive Inventory, and Payments. You can enter up to 160 characters to
describe this item. However, if you leave this field blank, then the
aforementioned windows will default to the Description for Sales when you select
an item ID.
#7. Sales Price: This sets the pricing levels you sell an item to a customer.
Item sales price levels are set up when you select the price level button.
Enter the amount to appear on your quotes, sales orders, and invoices. You can
set up five pricing levels for each item. These prices are set by Management and Sales only.
#8. Unit/Measure: This defines one unit of measure for the item. For
example, a unit of measure can be each, case, barrel, and so on. This prints on
the Physical Inventory List report, the Item Price List report, Inventory Stock
Status Report, and the Inventory Valuation Report.
1. Unit cost per each - All Stock Items need to be measured by Each (1)
2. Cost per case, box / pallet - Non-Stock Items can be costed by the case,
etc.
3. Cost per foot (NOTE: all steel & aluminum 20', 24', etc. must have a cost
per foot and must be purchased by the quantity measurement of feet. DO NOT COST
"PER PIECE," AND DO NOT PURCHASE QTY'S BY PIECE)
#9. Item Type: You can use this to group like inventory items together. For
example, if you have a large warehouse, you may want to enter Electric for
electrical items and Plumbing for plumbing supplies. You can use this to filter
most Inventory reports.
Note: This field is case sensitive. If you enter "Electric" when filtering item
types in reports, inventory items that are identified as "electric" or
"ELECTRIC" will not be included. Keep everything in "Upper case".
ACCESS INVENTORY ITEM TYPES:
| 1. | | ACCESSCD | | (Device that determines admittance -access control device) |
| 2. | | ACCESSOR | | (Loop Detector, Safety Devices, Timers, etc.) |
| 3. | | CAMERAEQ | | (Video surveillance, camera security) |
| 4. | | CONTROLP | | (Assembly of Electronics) |
| 5. | | ELECTRIC | | (Moves power from point A to B) |
| 6. | | ELECTRON | | (Components within control panel/operator) |
| 7. | | HARDWARE | | (Nuts, bolts, etc) |
| 8. | | MECHLOCK | | (Locks that are not powered) |
| 9. | | MISCPART | |
| 10. | | OPERATOR | | (System - Gate operating Equipment) |
| 11. | | SUPPLIES | |
IRON INVENTORY ITEM TYPES
1. ALM (Aluminum Products)
2. FAS (Fasteners - Nails, screws, washers, nuts, bolts, etc.)
3. GAL (Liquid products sold by the gallon - paint, thinner, primer)
4. MISC (Glass, specialty items)
5. STL (Steel Products)
6. SUP (Bits, blades, gloves, glasses, rags, etc.)
#10. Location: You can enter up to 10 characters to describe the location
(Aisle1, Aisle2, Bin4, and so on). This appears on inventory reports and lists.
DO NOT USE AT THIS TIME!
SEE SEPARATE G/L - INVENTORY LISTS FOR DESIGNATIONS:
#11. GL Sales Account: Enter or select the income account you want Peachtree
to increase when you sell the item. All classes of inventory except for
description-only items require a sales account.
#12. GL Inventory Account: This account is used as the default account for
entering purchases. Generally, the account increases when you purchase more of
the item and decreases when you sell the item.
For Stock items only - enter the account that the inventory for this item is
charged to - either #12000 for Iron Material Inventory or #12050 for Access
Inventory.
For Non-Stock items only - Change this account number to match the Cost of Sales
Account below:
#13. GL Cost of Sales Account: For Stock items and Assembly items, enter the
cost account that will increase for the item when sold. When you enter purchase
non-stock items, this is the default expense account used.
#14. Cost Method: Peachtree offers three methods of costing for inventory:
Average Cost, LIFO (last in, first out) and FIFO (first in, first out).
Generally, all inventory items need to use the same costing method. Once you
select a costing type for an item and select Save, you cannot change it. ALL
ITEMS ARE TO USE "AVERAGE" COST METHODS.
#15. Last Unit Cost: This is our cost for purchasing the item. Do not round
off the costs. This indicates the latest unit cost amount associated with this
item. Once a purchase, payment, or adjustment (including beginning balances) is
made for an item, the last unit cost is updated.
Stock Items: You can enter a cost amount for new stock items. However, once a
purchase, payment, or adjustment is made for the item, the field becomes
disabled and is only updated by Peachtree Accounting. The amount is calculated
based on the item's costing method. This field is not available for assembly
items. Their cost is computed from the various components.
Non-Stock, Service, and Labor Items: You can enter an estimated cost or change
the displayed unit here. When you sell one of these item types, a cost entry is
generated based on the cost you enter.
#16. Item Tax Type: This is regulated by the Accounting Department. Leave at
#1 until further notice.
#17. Subject to Commission: When an item is subject to commission and is sold
through Sales/Invoicing, it is included in the Accounts Receivable Sales Rep
Report. This is regulated by the Accounting Department - Leave Blank.
#18. Quantity on Hand: This is a view-only field used for stock and assembly
items. It tracks the quantities sold in the Sales/Invoicing and Receipts
windows, quantities purchased in the Purchases and Payments windows, and
adjustments made in the Inventory Adjustments window.
#19. Minimum Stock: Enter the number at which you will typically reorder the
item. This is used only for stock and assembly items. For example, you can use
this when you run the Inventory Reorder Worksheet to filter the report by those
items that are below minimum quantity in the Net Quantity field. This helps
determine how much of which items you need to reorder.
#20. Reorder Quantity: This is the amount that you normally order of the item.
It is used only for stock and assembly items and appears on the Inventory Stock
Status Report and the Inventory Reorder Worksheet.
#21. Preferred Vendor ID: Enter your preferred vendor for this item by typing
the Vendor ID or use the hourglass to display a list of existing vendors. You
can filter items by their preferred vendor on the Inventory Reorder Worksheet.
#22. Beginning Balances: The Accounting Department regulates this and is
Password protected.