Inventory items are used to identify, count, and manage physical goods or materials held by a business for sale or production. They are used when entering line items in many transaction forms in Manager. Beyond being the foundation of quantity monitoring, they:
Inventory items are used for sale, purchase, and management of physical goods, because they support counting quantities on hand, monitoring stock movement, and calculating profitability. For commonly sold or purchased goods or services that are not managed in this way, use non-inventory items.
To use any inventory-related function in Manager, enable the Inventory Items tab. At the bottom of the left navigation pane, click Customize, check the box for Inventory Items, and click Update below the list:
In the Inventory Items tab, click the New Inventory Item button:
Complete the definition:
Item codecan be anything that helps find, sort, or categorize the item. This could be a stock-keeping unit (SKU) code, a model number, or a simple memory aid. It must be unique and should be short. Codes will appear on forms if they are used. Serial numbers are not acceptable item codes, because every unit of inventory would be treated as a separate product.
Item nameshould be a relatively brief, informative name for the inventory item. It will appear when searching for an inventory item to complete a line item. It will also appear on various management reports. If no further description of the item is entered,
Item namewill appear in the
Descriptionfield on completed forms, such as sales invoices.
Unit Nameis optional, but can be used to specify units by which the item will be sold, purchased, and counted. Only one unit name is allowed; if materials are purchased and sold in different units, either apply conversions before making entries or create separate inventory items and use production orders or inventory kits to handle the differences.
Purchase priceis the price at which the item is usually purchased. This can remain blank if prices vary from purchase to purchase. If a purchase price is entered, it will be automatically populated into purchase-related forms, but can be edited.
Sales priceis the price at which the item will be sold. Leave blank if the sales price frequently changes. If a sales price is entered, it will appear automatically on sales-related forms, but can also be edited.
Descriptionfield is for more comprehensive information. Its contents, if present, will appear on finished forms in place of
Item name, so it should also adequately identify the item, not simply add detail. Anything a customer or supplier should see can be placed into this field.
Production stageappears only when the Production Orders tab is enabled and the first production order has been entered. The default entry is 1. Higher integer numbers can be entered when a finished item requires other items to be produced or purchased first.
Production stages ensure final inventory item costs added to Inventory on hand properly include the current average costs of all input inventory items by executing production orders in the correct sequence. They also help prevent confusing automatic entries when production orders drawing on the same inventory item are entered on the same day.
More details about production stages is found in another Guide.
Divisionif the inventory item will be accounted for as an asset of a single division of the business.
Control accountif you want the inventory item to be reported under a custom control account rather than the default Inventory on hand account. The control account must be created first.
Tax Codecan be selected.
Starting balancequantity, inventory location, and average cost can be transcribed. Starting balances can be set for every inventory location that has been defined.
Track quantity to receivecheckbox determines whether goods receipts are required to manage the inventory item.
Track quantity to delivercheckbox determines whether delivery notes are required to manage the inventory item.
Several accounts are activated automatically when the Inventory Items tab is enabled and the first inventory item is created. By default, inventory transactions will post to these:
For many businesses, these are sufficient. But for businesses wishing to further divide inventory accounts, two checkboxes indicate whether sales prices or costs of the inventory item should be posted to custom accounts created by the user. When these are checked, fields appear for non-standard account designation. Such custom accounts must be created first in the chart of accounts:
Custom income accountis where sales prices will be posted when an inventory item is sold, either through a sales invoice or receipt.
Custom expense accountis where the current average cost of an item will be posted when it is sold, transferring its cost from the Inventory on hand asset account.
Click Create to save the inventory item. The inventory item will be visible in the Inventory Items tab:
Inventory items can be used for:
When completing most of these forms, an
Item field will appear at the left end of line items whenever any applicable inventory or non-inventory items have been defined. To use an inventory item, click on the dropdown box of the
Item field. Or, begin typing the
Item Code or
Item Name in the field to take advantage of the autosearch capability. When an inventory item has been selected, all its parameters will automatically be filled for the line. Either cost price or sales price will be used, depending on the type of form. Anything can be edited except specified accounts:
Inventory items can be updated when required, such as when a price change occurs. In the Inventory Items tab, click Edit for the item to be changed:
Edit the item as desired and click Update. Existing forms using the inventory item will not be modified. Only future forms will be affected.
If the inventory item is no longer needed, it can be deleted as long as it has never been used. But Manager will not allow inventory items to be deleted if they have been used. In that case, check the box, and the inventory item will no longer be available.
If an inactive inventory item becomes useful again, scroll to the bottom of the inventory item list, where you will see the item’s name in light grey text. Click Edit next to the item’s name:
Uncheck the box and the item will once again be available. Remember to click Update when finished editing.