Inventory

From Fishbowl

Jump to: navigation, search
Inventory
Related Pages
Part
Product
Transfer Order
Accounting
Cycle Count Increasing Inventory
Cycle Count Decreasing Inventory
Scrapping Inventory
Adding Initial Inventory

Icon.Inventory.png 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.

Contents

Module buttons
Jump to top of page

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

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

Email Button.png Email attaches the module's default report to an email, if email is configured.

Print Button.png Print sends the default module report to the printer.

How To Button.png How To opens this article in a web browser.

Refresh Button.png Refresh reloads whatever is currently open in the module.

Search
Jump to top of page

The search panel in the Small.Inventory.png 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.

Move inventory
Jump to top of page

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

  1. Open the part to be moved in the Small.Inventory.png Inventory module.
  2. Highlight the desired location and click the Move Icon Button.png Move button located on the component toolbar to the right.
    Inventory Details.png
  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 a CSV Import.

Adjust tracking information
Jump to top of page

Tracking can be edited in the Small.Inventory.png 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 Small.Inventory.png Inventory module.
  2. Highlight the desired location and click the Tracking Button.png Tracking button located on the component toolbar to the right, or double-click the line item.
    Inventory Details.png
  3. Tracking that has already been committed will have a Lock.png icon. Click any field to make the desired changes and then click OK.
    Inventory Tracking Details.png

Cycle count
Jump to top of page

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.

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.png 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.
    Cycle count.png
  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.png 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.
    Cycle count specify quantity.png
  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
Jump to top of page

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.png Add button in the Small.Inventory.png 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.
    Cycle count add inventory.png
  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 Icon Button.png Auto buttons.
    Auto Tracking Panel.png.
  6. Once all the desired information has been entered, click the Finish button.

Inventory can also be added through a CSV Import.

See Also

Adding Initial Inventory: The Accounting Process

Scrap inventory
Jump to top of page

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 Icon Button.png 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.
    Scrap.png
  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
Jump to top of page

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

  1. Double-click the desired part in the Small.Inventory.png Inventory module
  2. Click the Edit Icon Button.png Edit button located to the right of the current cost.
    Editing average cost.png
  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 a CSV Import.

View costing details
Jump to top of page

To view a part's costing details, load the part in the Small.Inventory.png Inventory module and then click the Info Icon Button.png Costing Details button located to the right of the current cost. This will display the Costing Details window.

Costing details.png

The Costing Details window displays the part number, the quantity on hand, as well as the average cost, the standard cost, and the FIFO/LIFO costing layers.

View quantity details
Jump to top of page

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

Inventory Quantity details.png

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

Inventory status terms
Jump to top of page

Below is a description of the inventory status terms displayed in the Small.Inventory.png 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.

Allocated info.png

TABS

General tab
Jump to top of page

The General tab displays important inventory details.

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


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


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

MODULE OPTIONS

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

General tab
Jump to top of page
Inventory module options.png
This option stores a daily snapshot of part costs for use with the Historical Part Cost report.
Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate