Back
  Inventory Setup Procedures

e-mail info@peachesandpride.com
 
 

  SETTING UP NEW INVENTORY ITEMS SETTING UP NEW INVENTORY ITEMS

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.

Maintain Inventory Item Header Fields

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.

Inventory Item "Description" Format (30 characters max): Use spaces, slashes, or 
dashes:
	(1)		(2)					(3)
	XXX (space)	XXXXXXXXXXX(comma)(space)	XXXXXXXXXXXXX

(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.


For information regarding this site e-mail webmaster@peachesandpride.com