Inventory

Inventory

Related Pages
Part Product Transfer Order
Accounting
Cycle Count Increasing Inventory Cycle Count Decreasing Inventory Scrapping Inventory Adding Initial Inventory

The Inventory module, located in the Materials group, displays parts as well as their quantities, locations, and tracking information. Inventory can be viewed, added, deleted, moved, and modified from within the Inventory module.

Module buttons

Cycle allows inventory quantities to be adjusted with a cycle count.

Add allows new inventory to be added and the cost to be set.

Email opens a window to compose an email. If the module's default report is specified, the PDF report will be attached. Email can be configured on the Email tab tab of the Settings module.

Print sends the default module report to the printer.

How To opens this article in a web browser.

Refresh reloads whatever is currently open in the module.

Search

The search panel in the Inventory module displays parts as well as the part description and the quantity on hand. The search parameters can be used to filter the list or find a specific part.

• Basic search - To perform a basic search, enter the part number (or a portion of it) in the Part Number field and then press the Search button or the Enter key. The Description and Location fields can also be used to search. By default, only parts that are in stock are included. To see parts with a zero quantity, use the Advanced Search.
  
• Advanced search - Click the Advanced Search button to see more search parameters. To include parts with a zero quantity, select Show parts with no on hand inventory. Enter any fields on the General, Tracking, or Custom tabs and then click Search.
  

Move inventory

Follow the steps below to move inventory from one location to another location.

1. Open the part to be moved in the Inventory module.
2. Highlight the desired location and click the Move button located on the component toolbar to the right.
   
3. Enter the quantity, end location, and any required tracking information and then click OK to complete the move.

An inventory move can also be performed using the import.

Adjust tracking information

Tracking can be edited in the Inventory module. For example, an incorrect serial number can be edited. Follow the steps below to adjust tracking information.

1. Open the part to be adjusted in the Inventory module.
2. Highlight the desired location and click the Tracking button located on the component toolbar to the right, or double-click the line item.
   
3. Tracking that has already been committed will have a icon. Click any field to make the desired changes and then click OK.
   

Cycle count

A cycle count is used to increase or decrease inventory in Fishbowl. Typically, the cycle count feature is used while performing a physical inventory count, but may also fulfill other company needs. A cycle count can be performed using any of the following methods.

• The Cycle button on the module toolbar.
• The Cycle button on the component toolbar to the right.
• The Cycle Count Data import.

Using the Cycle button on the module toolbar

Follow the steps below to adjust inventory quantities using the Cycle button on the module toolbar.

1. Click the Cycle button on the module toolbar.
2. Select the Part and Location that will be adjusted, and then click Next.
3. Adjust the quantity to the correct amount. If there is a quantity of 50 in the location, then changing the quantity to 51 will add 1 to this location.
   
4. Enter any required tracking information or any optional information such as a Note, Customer/Job, or QB Class.
5. Click Finish to complete the cycle count wizard.

Using the Cycle Count button on the component toolbar

Follow the steps below to adjust inventory quantities using the Cycle button on the component toolbar to the right.

1. Open the part that will be cycled and highlight the location line item that will be adjusted.
2. Click the Cycle button located on the component toolbar to the right.
3. Adjust the quantity to the correct amount. If there is a quantity of 50 in the location, then changing the quantity to 51 will add 1 to this location.
   
4. Enter any required tracking information or any optional information such as a Note, Customer/Job, or QB Class.
5. Click Finish to complete the cycle count wizard.

See Also

Cycle Count Inventory Increase: The Accounting Process

Cycle Count Inventory Decrease: The Accounting Process

Add inventory

Adding inventory increases the total quantity and allows for cost adjustments to be made. Follow the steps below to add inventory.

1. Click the Add button in the Inventory module.
2. Select the part and location and then click Next.
3. Enter the quantity to add. If there is a quantity of 50 in the location, then entering a quantity of 13 will increase the total to 63.
   
4. Enter the unit cost and any other applicable information
5. If the part has tracking, enter the required tracking information. To automatically enter tracking information (serial numbers, revision levels, lot numbers, dates, etc.) click any of the Auto buttons.
   .
6. Once all the desired information has been entered, click the Finish button.

Inventory can also be added through the import.

See Also

Adding Initial Inventory: The Accounting Process

Scrap inventory

Scrapping inventory reduces the total quantity, and is often performed when inventory has been damaged or destroyed. Follow the steps below to scrap inventory.

1. Open the part that will be scrapped and highlight the applicable location line item.
2. Click the Scrap button located on the component toolbar to the right.
3. Enter the quantity that will be scrapped. If there is a quantity of 10 in the location, then scrapping 3 will result in a total of 7.
   
4. Enter any required tracking information or any optional information such as a Note, Customer/Job, or QB Class.
5. Click Finish to complete the scrap wizard.

See Also

Scrapping Inventory: The Accounting Process

Modify the average cost or total cost

Follow the steps below to edit a part's average cost or total cost.

1. Double-click the desired part in the Inventory module
2. Click the Edit button located to the right of the current cost.
   
3. Modify either the Average Cost or the Total Cost, and the other cost will be automatically calculated.
4. When the desired changes have been made, click OK.

Average costs can also be modified using the import.

View costing details

• To view a part's costing details, load the part in the Inventory module and then click the Costing tab.
• Part cost is set as inventory enters Fishbowl.
  1. When a part is purchased, the final part cost is determined in the Receiving module.
  2. When manually adding inventory, the part cost is entered in the Unit Cost field.
  3. When cycling inventory in, the new inventory will receive the current cost that is listed on the Costing tab of the Inventory module
  4. If a part is manufactured, the costs of the raw goods are used to determine the cost of the finished good.
• NOTE: When inventory leaves Fishbowl (sold, scrapped, etc.), the cost that is exported to the accounting system will rarely match the individual cost of that item when it entered inventory. Instead, a part's cost fluctuates according to the current cost of the selected costing method.

View quantity details

To view the Quantity Details window, click the Display More Information button located in the Inventory section, to the right of the total quantities.

The Quantity Details window displays inventory totals, inventory quantities per location group, as well as upcoming orders with the selected part.

Inventory status terms

Below is a description of the inventory status terms displayed in the Inventory module. In the Fishbowl Client, hover the mouse over an inventory term or quantity to see more details, such as inventory breakdowns, or the formula used to calculate the inventory status.

• On Hand - The total amount of inventory in stock.
• Allocated - The amount of inventory allocated or assigned to other orders. For example, inventory on issued sales orders, purchase orders, transfer orders, and work orders. Hover over the Allocated quantity to see more details.
• Not Available - The quantity in locations that are not available for sale.
• Drop Ship - The quantity being drop shipped directly to customers.
• Available For Sale - The quantity available for sale is calculated as On Hand - Allocated - Not Available + Drop Ship.
• On Order - The quantity on order for a purchase order, sales order, work order, or transfer order.
• Committed - Items picked and ready to be shipped, or items started on a work order. Inventory that is committed will always be allocated. However, inventory that is allocated is not always committed.
• Short - The quantity needed to fulfill demand.
• Available To Pick - Calculated as On Hand - Committed for inventory in locations that are marked as Pickable.

TABS

General tab

The General tab displays important inventory details.

The top section displays the Part Description, Part Number, UOM, Total Cost, and Average Cost.

• Total Cost - The total cost is the dollar value of the inventory in stock for the selected part. When using average cost or standard cost, the total cost is the current unit cost multiplied by the number of items on hand. When using FIFO or LIFO, the total cost is the sum of all of the costing layers.
• Average Cost - The average cost is set when the cost is first entered for a part. This cost will fluctuate each time the part is purchased for a different cost. The average cost is calculated by taking the total cost of all items divided by the quantity on hand. When using standard cost or FIFO/LIFO, the Average Cost field will change accordingly. For more information, see Costing method.
• The Edit button is used to edit the cost of inventory.

The Inventory section displays the quantity of inventory on hand as well as the inventory status totals.

• The inventory totals can be viewed for each location group by clicking on the Quantity Details button.
• In the Fishbowl Client, hover the mouse over an inventory status or quantity to see more details or the formula used to calculate the inventory status.

The Information section displays the inventory within each location. This section provides the following functions.

• Edit tracking information
• Move inventory
• Cycle count inventory
• Scrap inventory

Costing tab

The Costing tab displays costing details.

• The top section displays the part number, the quantity on hand, and the current costing method.
• The lower section displays info for various costing methods. Note that only the data for the Current Costing Method will be used, but it may be useful to view details for other costing methods as well.
• Part cost is set as inventory enters Fishbowl.
  1. When a part is purchased, the final part cost is determined in the Receiving module.
  2. When manually adding inventory, the part cost is entered in the Unit Cost field.
  3. When cycling inventory in, the new inventory will receive the current cost that is listed on the Costing tab of the Inventory module
  4. If a part is manufactured, the costs of the raw goods are used to determine the cost of the finished good.
• NOTE: When inventory leaves Fishbowl (sold, scrapped, etc.), the cost that is exported to the accounting system will rarely match the individual cost of that item when it entered inventory. Instead, a part's cost fluctuates according to the current cost of the selected costing method.

MODULE OPTIONS

Some aspects of the Inventory module can be customized by opening the module, clicking the Tools menu, and then selecting Module Options.

General tab

• Allow Scheduled Part Cost History Snapshot

This option stores a daily snapshot of part costs for use with the Historical Part Cost report.