Manage inventory - Part 1 Introduction

Inventory comprises goods held by a business for sale or production. It does not include fixed assets, such as equipment or buildings. Nor does it include tools or consumable supplies used during operations. The value of inventory is an asset, because it can generate future income. Therefore, it appears on a company’s balance sheet.

So inventory must be counted and valued. It must be tracked as it is produced, bought, or sold. Manager includes many features to help manage inventory. Some are essential; others are optional. Program behavior changes, depending on which tools are used. This Guide explains how various tools and capabilities interact so you can decide which to use in your situation. It is divided into three parts: Introduction, Continuation, and Conclusion. You are reading Part 1 Introduction.

The three parts of this Guide do not furnish detailed, step-by-step instructions for enabling functional tabs, completing transaction forms, or generating reports. Those can be found in other Guides, to which hyperlinks are provided. Instead, they focus on relationships between the inventory management features of the program:

Purchase orders and sales orders are not included in this discussion because they are not actual financial transactions and have no impact on inventory. They are convenient shortcuts for recording orders to suppliers or from customers. And they can by copied to other transactions that affect inventory. But in the current version of Manager, purchase orders do not adjust inventory availability or backorder status. Nor do sales orders commit inventory to a particular customer or future sales transaction.

All three parts of this Guide illustrate various aspects of inventory management using an example company, Brilliant Industries. Brilliant Industries sells electric lamps and lamp parts at wholesale. It is not required to collect or pay any taxes on sales or purchases in its jurisdiction. Brilliant has 6 different items in inventory and assigns 3-digit item codes:

38 PM

Brilliant currently has two customers and two suppliers:

56 PM AND 08 PM

So far, Brilliant Industries has enabled just three tabs related to inventory management (Reports is always enabled for all businesses):

  • Customers
  • Suppliers
  • Inventory Items

Purchasing inventory

Inventory can be purchased with purchase invoices or cash payments.

Brilliant Industries buys an initial stock of inventory via a combination of purchase invoice and cash payment. ACME Distributing presents its sales invoice upon delivery of the merchandise. So as soon as Brilliant enters the corresponding purchase invoice, the items are considered to be in stock. Edison Electrical Supply sells only over the counter. So Brilliant’s owner leaves Edison’s warehouse with purchased items in hand, having written a cheque on the spot.

Brilliant enables the Purchase Invoices tab. The Bank Accounts and Bank Transactions tabs were enabled when the company’s bank account was established. The two transactions are entered as below:

21 PM

31 PM

Since all transactions were complete when they were entered, there is no need for Brilliant Industries to enable the Goods Receipts tab. The Inventory Items list shows the results of the two purchases:

Inital Purchase item list

Producing inventory

When inventory items are produced in-house, production orders record consumption of resources and output of new finished goods.

Brilliant Industries can buy finished table lamps from ACME Distributing. But it can also produce them from parts purchased from various suppliers. It decides to manufacture a batch of 3 table lamps. So it enables the Production Orders tab and enters the following production order:

38 PM

The inventory listing shows the increase in finished table lamps, as well as reductions in the three items that went into production. Also notice that average cost of table lamps has declined because of the production order. The cost of input items for a lamp (87.00 + 24.35 + 3.25 = 114.60) plus labor (75.00 / 3 = 25.00) is less (139.60) than the purchase cost of a finished lamp (195.00). In other words, Brilliant Industries can assemble table lamps itself for less than it can buy them, potentially allowing more profit:

Post Production Order Inventory

Also note that total value of inventory has risen because of the 75.00 labor cost to manufacture 3 lamps. The company now has more invested in its inventory. But it can also sell that same inventory for much more because of the value added through manufacturing operations.

Selling inventory

Inventory can be sold with sales invoices or cash receipts.

Brilliant Industries sells products to Bob’s Hardware. It enables the Sales Invoices tab and records the sale on the following sales invoice:

Sales Invoice

It also sells 1 case of LED bulbs to Lumen Lighting for cash, and enters that transaction as a receipt. Quantities on hand have decreased for table lamps, 60 Watt bulbs, and LED bulbs:

Post Sales Inventory List

Because the goods were delivered immediately and either accompanied by a sales invoice or a cash receipt, Brilliant Industries did not use the Delivery Notes tab. Manager treated all inventory movements as having happened immediately.

Understanding backorders

When you have sold more inventory items than you own (have on hand) the situation is described as a backorder. That term is somewhat misleading, because additional stock has not necessarily been ordered. This situation shows up in Manager as negative inventory quantities. The negative quantity indicates how many units of the inventory item must be purchased or produced to satisfy existing sales.

If Brilliant Industries had sold 3 cases of LEDs to Lumen Lighting in the previous example, a backorder situation would exist, because only 2 had been purchased and were on hand. The inventory list would show a quantity on hand of -1:


Inventory reports

Four reports became available when the Inventory Items tab was enabled:

Brilliant Industries began the year with no inventory, made initial purchases, produced some lamps, and made sales. Its Inventory Value Movement report is shown below. Notice that only the 2 cases of LEDs actually delivered are included; the backordered merchandise will not appear until more are purchased and delivered:

Inventory Value Mvmt

Brilliant Industries’ matching Inventory Quantity Movement report is below. Note the backordered LED near the bottom of the list:

Inventory Qty Movement

Brilliant Industries sold only 3 different items during the reporting period, so only those show on the Inventory Profit Margin report:

Profit Margin

Brilliant Industries’ full current price list is show below:

Price List

Brilliant adds a custom field for inventory categories. It filters the report for Finished lamps, with a corresponding title:

45 AM

The resulting report appears below:

08 AM

Because Inventory Value Movement and Inventory Quantity Movement reports are related to transactions within a specified time period, they will not necessarily reflect total value or quantities of inventory on hand. That information can be obtained by drilling down on the Inventory on hand account in the Summary tab or by clicking on the Inventory Items tab. Both resulting lists can be exported to a spreadsheet program.



Subscribe to Updates

Subscribe to our newsletter and get exclusive product updates you won't find anywhere else straight to your inbox.

© 2017 - Based in Sydney, Australia but providing goodness globally