Part

From Fishbowl
Jump to: navigation, search
Part
Training Videos
Part Training Videos
Related Pages
Product
Inventory
Kitting

Icon.Part.png The Part module, located in the Materials group, allows parts to be created and modified. There are several part types, but in general, a part is an item that is stored, manufactured, or consumed. Parts can also have a corresponding product, which is an item that is sold to a customer.

Module buttons

New Button.png New creates a new part.

Save Button.png Save saves any changes made to the part.

Delete Button.png Delete deletes the part.

Auto ROP Button.png Auto ROP allows multiple reorder points to be set simultaneously.

Auto ABC Button.png Auto ABC allows multiple ABC codes to be set simultaneously.

New BOM Button.png New BOM creates a new bill of materials with the open part as the finished good.

To Inventory Button.png To Inventory loads the Small.Inventory.png Inventory module for the open part.

Duplicate Button.png Duplicate creates a duplicate copy of the part.

Email Button.png 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 Small.Setup.png Setup module.

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.

Create a part

New parts can be created in the Small.Part.png Part module, through imports, or by typing a new item number in a Part/Product field and selecting Add New. The Part/Product field is found in many modules including Purchase Order, Sales Order, Transfer Order, Consignment, and Checkout. Follow the steps below to create a new part from the Small.Part.png Part module. If desired, many of the wizard steps can be hidden.

  1. Open the Small.Part.png Part module and click the New Button.png New button located on the module toolbar.
  2. Enter the part number, description, UPC, part type, and unit of measure (UOM).
    Create a new part.part description.png
  3. Enter the product details and then click Next.
  4. If the part will have tracking, select the tracking methods and then click Next.
    Tracking Inventory.png
  5. If the part is already in stock, enter the initial inventory and then click Next.
    Initial Inventory.png
  6. If applicable, enter the part's default locations and then click Next.
    Default Locations Step.png
  7. If applicable, select a default vendor and then click Next.
    Default Vendors Step.png
  8. Enter any part custom fields and then click Next.
    Part Custom Fields Step.png
  9. Select the default accounts to use with the accounting system and then click Next.
    Default Accounts Step.png
  10. If applicable, highlight any categories in the product tree and then click the Add button. Press the Clear button to remove the product from the product tree.
    Product Tree Step.png
  11. Click Next and enter any product custom fields.
    Part Custom Fields.png
  12. Click Next to see the Summary step and then finish the wizard.

Inactivate a part

A part can only be deleted if it has not been used and it has no associated products. The part cannot be deleted if inventory has been added, the part is on an order, etc. However, a part can be inactivated so that it will not appear in part lists.

  • Inactivate a single part - To inactivate a single part, open the part, uncheck the Active box on the General tab, and then click Save.
    Inactivate part.png
  • Inactivate multiple parts - To inactivate multiple parts, click each part in the search pane while holding down the Ctrl key on the keyboard. After the desired parts are all highlighted, right-click any of the highlighted parts and select Inactivate.
  • Reactivate a part - A part can be reactivated by searching for inactive parts in the Advanced Search and then checking the Active box on the parts that should be reactivated.

Edit a part

Nearly all aspects of a part can be edited by opening the part, clicking the corresponding tab, and changing the desired field.

  • Edit UOM - To edit the part UOM, click the Edit Icon Button.png Edit UOM button on the General tab.
  • Edit type - The part type is not editable. The one exception is that the admin user can change a non-inventory item to an inventory item.
  • Save changes - After making any changes, remember to click the Save button to commit the changes.

Create part reorder levels

Reorder levels are used to determine when inventory is getting low and when specific parts should be reordered or manufactured. Below are a few of the ways that reorder levels can be utilized.

  • Reorder levels can be used to automatically create purchase orders for the required parts and quantities using the Auto PO wizard.
  • Reorder levels can be used to automatically create manufacture orders for the required parts and quantities using the Auto MO wizard.
  • Reorder levels are also used in the Small.Transfer Order.png Transfer Order module and the Small.Consignment.png Consignment module.
  • The Reorder Report generates a list of parts below reorder tolerance and specifies the quantity that is needed.

Reorder Information section.png

A reorder level consists of two numbers:

  • Reorder Point (ROP) - Sometimes referred to as the minimum quantity, the ROP is the quantity level that indicates the part should be reordered to avoid a stockout.
  • Order Up to Level (OUL) - Sometimes referred to as the maximum quantity, the OUL represents the ideal quantity of inventory to stock. Typically a part is replenished until the total inventory on hand equals the OUL.

Reorder levels could also be explained by using an analogy of fuel in a car. The ROP is the warning light indicating that the fuel is low and it's time to fill-up. The OUL is the capacity of the fuel tank.

Reorder levels are either specified per location group, or company wide, depending on the Small.Location Group.png Location Group module options. Reorder levels can be set through any of the following methods:

  • To automatically create multiple reorder levels, use the Auto ROP wizard.
  • Reorder levels can be set for multiple parts through the Reorder Levels import.
  • Individual reorder levels can be set and modified on the Inventory tab of the Small.Part.png Part module.

Follow the steps below to manually create individual reorder levels:

  1. Open the desired part in the Small.Part.png Part module and click the Inventory tab.
  2. Click the Add Icon Button.png Add Reorder Level button located on the component toolbar to the right.
    New reorder level.png
  3. Enter the Order Up to Level (OUL) and the Reorder Point (ROP) and then click OK.

Auto ROP wizard

Follow the steps below to automatically create Reorder Levels in the Auto ROP wizard based on historical data.

  1. Click the Auto ROP Button.png Auto ROP button located on the module toolbar of the Small.Part.png Part module.
  2. Select which parts should be included in the calculation and click Next.
    Auto ROP wizard step 1.png
  3. Select the date range that should be used for the calculation and click Next.
    Auto ROP wizard step 2.png
    • Unit sales per day is calculated as total sales (or manufacturing use) / total number of days in the selected date range. For example, if 100 units were sold over 50 days, unit sales per day would be 100 / 50 = 2
    • If the starting date is left blank, the first date in the inventory log for each part will be used (the first day the part was added to inventory).
  4. If applicable, enter a forecasting percentage to account for increasing or decreasing sales and then click Next.
    Auto ROP wizard step 3.png
    • The forecast percentage is multiplied by the total quantity and then used in the unit sales per day calculation. For example, if 100 units were sold over 50 days, and a forecast percentage of 25% is entered, unit sales per day would be 100 * (1 + .25) / 50 = 2.5
    • The comparison date range calculates a percentage by dividing the total quantity in the forecasting range (step 3) by the total quantity in the date range (step 2). Typically this would mean the forecasting range should be a comparable period in the past, such as last year. For example, if 50 units were sold last year, and 100 units were sold this year, the forecast percentage would be 50 / 100 = 200%
  5. The Reorder Point step gives an explanation of the formula used to calculate the ROP. Enter the Lead Time, Safety Stock, and Basic Stock and then click Next.
    Auto ROP wizard step 4.png
  6. The Order Up to Level step gives an explanation of the formula used to calculate the OUL. Enter the Order Interval and then click Next.
    Auto ROP wizard step 5.png
  7. The final step of the wizard shows the reorder levels that were calculated.
    Auto ROP wizard step 6.png
    • To modify the reorder levels, select the desired parts by ctrl-clicking each one, enter the new ROP and OUL levels, and then click the Save Icon Button.png Save button.
    • The Pause Icon Button.png Pause button will leave the reorder levels at their current values.
  8. Once all of the reorder levels are correct, click Finish to complete the wizard.

Establish ABC codes

Auto ABC wizard.JPG
ABC codes provide a way to classify inventory. For example, important inventory parts that have a large impact on sales could be classified as A while parts that are less valuable and less important could be classified as C. A part's ABC code can be set manually on the Inventory tab of the Small.Part.png Part module, or calculated based on historical sales data by using the Auto ABC wizard.

Follow the steps below to use the Auto ABC wizard.

  1. Click the Auto ABC Button.png Auto ABC button located on the module toolbar of the Small.Part.png Part module.
  2. On the first step of the wizard, specify whether the codes should be calculated using Sales Activities, Manufacture Activities, or both. Also select a time period to use while calculating the codes.
  3. Click Next to confirm the ABC codes. The codes will be calculated using the percentage for Sales and/or Manufacturing usage (80% - A, 15% - B, 5% - C). Any code can be changed as necessary by using the A, B, and C buttons on the component toolbar to the right. Select Finish to complete the wizard.
    Auto abc step 2.png

The Advanced Search in the Small.Part.png Part module provides the ability to filter parts based on their ABC code, as does the Cycle Count List report.

Create a tracking method

Custom tracking methods can be created in Fishbowl to keep track of important part details. A tracking method could be created to track details such as size, color, dates, etc. Multiple serial number can also be added. Follow the steps below to add a new tracking method.

  1. Click the Tools menu in the Small.Part.png Part module, select Module Options and then click the Tracking tab.
    Create unique tracking methods.png
  2. Click the Add Icon Button.png Add Part Tracking button located on the component toolbar.
  3. A blank line will be added at the bottom of the Part Tracking List. Click each empty field to enter the details for the tracking method.
  4. Select from the following options in the Type field: Text, Date, Expiration Date, Serial Number, Money, Quantity, Count, or Checkbox.
  5. Click OK to save the changes and close the Module Options window.
  6. To track a part by the newly created tracking method, open the part, click the Details tab, and place a check mark next to the new tracking method.
    Track expiration date and serial number.png

Additional columns can be displayed on the Tracking tab of the Small.Part.png Part module options by right-clicking a column header. To inactivate a tracking method, uncheck the Active box. The Usage column displays how many parts use each tracking method. Tracking methods may can also be deleted or moved using the buttons on the component toolbar.

Primary tracking

Primary Tracking has been created within Fishbowl to replace the use of Tag tracking in both the Fishbowl Client and Fishbowl Mobile. Primary Tracking has been designed to provide functionality similar to tags and offers many of the same features tags provide; however, Primary Tracking utilizes part custom tracking rather than auto assigned numbers. For additional detailed instructions on how this feature works, please see Primary tracking.

Auto tracking

Fishbowl has the ability to automatically generate serial numbers and part tracking in the Small.Inventory.png Inventory module, the Small.Receiving.png Receiving module, the New part wizard, and anywhere that new tracking data is entered.

  1. To enable auto tracking, open the desired part in the Small.Part.png Part module and then click on the Details tab.
  2. In the Next Value field, enter the next tracking value that should be used.
    Next Tracking Field.png
    • Any Serial Number or Text type tracking can be automatically increased. Every time a new tracking value is needed, the final group of numbers will be increased by one. For example, BB2001-99PRO will be incremented to BB2001-100PRO.
    • Any Date type tracking can be automatically set for a specified number of days in the future. For example, if the next value for an expiration date is set to 30, the expiration date will be set 30 days from today.
  3. Click the Save button on the module toolbar.
  4. Now when entering tracking for this part, click the Auto Icon Button.png Auto button to automatically populate the tracking fields with the next tracking value.
    Auto Tracking Panel.png

Part types

Below is a list of the part types available in Fishbowl.

  • Inventory - Can be purchased and sold and stocked in inventory.
  • Service - Can be purchased and sold but is not stocked in inventory.
  • Labor - Cannot be purchased or sold, but can be added during manufacturing or reconciling.
  • Overhead - Can be included as a component of a part's cost during manufacturing.
  • Non-Inventory - Can be purchased and sold but is not tracked in inventory.
  • Internal Use - Can be purchased but is not sold or stocked in inventory.
  • Capital Equipment - Equipment that depreciates in value and can be purchased but is not sold or stocked in inventory.
  • Shipping - Can be purchased or sold, but is not stocked in inventory.

Batch upload part pictures

The Part import can be used to upload pictures for multiple parts at once.

  1. Export the Part CSV by clicking the File menu, selecting Export, and then choosing Part.
  2. Choose a location to save the file.
  3. Browse to the location where the file was saved (Documents folder by default) and open the file in a spreadsheet program like Excel.
  4. Type the path to the image file into the PictureUrl column.
    • If the images are located in an images folder on the C: drive, the cell value would look similar to this:
      file://localhost/C:/images/B201.jpg
    • Make sure the file extension matches exactly (.jpg, .jpeg, .JPG).
    • In the URL field, localhost means that the files are located on the local computer. The word localhost could be replaced with the name of the server where the images are stored. If the name of the server is excluded, make sure there are three forward slashes instead of just two: (file:///C:).
    • If the images are predictably named, a formula can be used to reference other cells. For example, if the image is named the same as the part number, then the part number field (A2) can be used in the formula. The same formula can be copied into all applicable cells. The formula would look similar to this:
      ="file://localhost/C:/images/"&A2&".jpg"
  5. Import the Part CSV by clicking the File menu, selecting Import, choosing Part, and then selecting the edited file.

TABS

General tab
Part Module general subtab.png

The General tab displays important details about the part.

  • The URL field can be used to link to local files, websites, etc.
  • Uncheck the Active checkbox to hide a part from the Part fields throughout Fishbowl.
  • Check the Pick in part UOM only checkbox to pick the part in the UOM displayed next to the part number, even when it is sold in a different UOM.
  • To add an image to a part, drag and drop the picture file into the picture area. Alternatively, click the Add Icon Button.png Add button located on the component toolbar to the right, locate the image file, and then click Open.
  • Clicking the Delete Image Icon Button.png Delete Image button will remove the current part image.
  • The Save Icon Button.png Save button allows the current image to be saved to a specified location.
  • Click the image to display it in a separate window.
  • The maximum image and thumbnail size can be set in the Small.Setup.png Setup module options.
  • To upload pictures for multiple parts at once, see Batch upload part pictures.
Details tab
Part Details subtab.png

The Details tab displays part details such as Revision, UPC, Size, and Weight.

  • The Standard Cost field is only used internally and will NOT be the cost shown on inventory reports unless Standard Costing was selected as the costing method when creating the database. The current cost, regardless of the costing method, can be viewed in the Small.Inventory.png Inventory module.
  • Alert Notes are displayed in a pop-up window each time the part is added to a purchase order.
  • The Tracking section displays all of the current tracking methods. The methods being used by this part will be marked with a check. All orders using this part must be in Entered, Issued, or Fulfilled status before tracking methods can be added or removed for a part. Additional tracking methods can be created in the Small.Part.png Part module options. The Next Value column is used to automatically generate tracking data.
  • The Products section displays all of the products associated with this part. It is possible to have multiple products per part, but only one part per product is allowed. If multiple products are shown, the default product will be marked with a check. Additional products may be created beneath this section by clicking the New Product icon located on the component toolbar.
Accounts tab
Part accounts subtab.png

The Accounts tab allows parts to be assigned to specific accounts in the accounting system.

  • Each part can be assigned a specific Asset Account, COGS Account, Adjustment Account, and a Scrap Account.
  • When exporting to the accounting system, the part will export to the accounts specified here.
  • If no accounts are specified, the part will export to the default accounts chosen in the accounting integration.
Inventory tab
Part Inventory Subtab.png

The Inventory Tab provides inventory details for the selected part, allows the ABC Code to be set, and also allows Reorder levels to be set. To view a detailed display of inventory in each location group, click the Info Icon Button.png Info button located to the right of the inventory values. Below are descriptions for the inventory values displayed on the Inventory tab. In the Fishbowl Client, hover the mouse over each inventory value to see more information.

  • 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.
  • Not Available: The uncommitted quantity in locations that are marked as Not Available.
  • Drop Ship: The quantity being drop shipped directly to customers.
  • Available For Sale: The quantity that is available for sale (On Hand - Allocated - Not Available + Drop Ship).
  • On Order: The quantity on order for purchase Order, sales orders, work orders, or transfer orders.
  • Committed: Items picked for shipping or work orders.
  • Back Ordered: The quantity needed to fulfill demand.
  • Available To Pick: The quantity that is available to pick (On Hand - Committed - Not Available To Pick).
Default Locations tab
Default Locations subtab.png

The Default Locations tab allows part default locations to be set for each location group.

  • When a part is received, the Location field will default to the default location specified here. If a default location is not specified, the part will be received into the default receiving location of the location group.
  • When a part is manufactured, the Location field will default to the default location specified here. The Location field will be left blank if there is no default and the user will be required to enter a location.
  • When a part is picked, the Pick Location field will default to the default location specified here when inventory is available.
  • Default locations can also be specified using the import.
Bill of Materials tab
Part bill of materials subtab.png

The Bill of Materials tab displays which BOMs include the open part.

Vendors tab
Part Vendors subtab.png

The Vendors tab provides a list of the vendors this part was purchased from. Information included for each vendor is shown below.

  • Vendor Part Number: Fishbowl can store the number each vendor uses to reference parts in Fishbowl. The default number is the Fishbowl part number. The vendor number may be edited by double-clicking in the Number column. Vendor part numbers can also be set in-line on a Purchase Order and on the Parts tab of the Small.Vendor.png Vendor module. Items can be added to a purchase order by typing the vendor part number into the Part field.
  • Last Cost: The last cost the part was purchased for. The last cost can also be set using the import.
  • UOM: The part's Unit of Measure
  • The last date of purchase: The last date this part was purchased. This will be the Purchase Order's Fulfillment date.
  • Lead Time: The time from when the Purchase Order is issued until Received.
  • Default: The default vendor will be used for drop shipping, Auto PO, and pricing rules.

Use the Add Icon Button.png Add button, Edit Icon Button.png Edit button, or Delete Icon Button.png Delete button by highlighting the vendor and clicking the corresponding button located on the component toolbar.

Memo tab
Part Memo subtab.png

The Memo tab can be used to add information to each part. The upper pane displays the memos, the date they were created, and the user that created them. Highlighting a memo will display the details of the memo in the lower pane.

  • Click the New Icon Button.png New button to create a new memo.
  • To edit a memo, highlight the memo in the upper pane and then click the Edit Icon Button.png Edit button.
  • To delete a memo, highlight the memo in the upper pane and then click the Delete Icon Button.png Delete button.
  • Click the Print Memos button to print a report with all of the memos.
Custom tab
Part Custom subtab.png

The Custom tab stores additional fields for the part that can be customized to fit the needs of each company.

  • Custom fields can be created and modified by opening the Small.Custom Field.png Custom Field module and selecting Part from the drop-down at the top of the module.
  • To search for orders using the custom fields, click the Advanced Search button in the search pane to the left and then click the Custom tab.


MODULE OPTIONS

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

General tab
Part module options.png
  • Search by Part and Product descriptions in drop-down filters
With this option checked, the part and product descriptions, not just the numbers, will be searched when typing into part and product drop downs.
  • Add custom fields to PO item
If this option is enabled, custom fields with the same name and type will transfer from the part to the purchase order item. For example, if a part has a custom field that stores color and there is a matching custom field for purchase order line items, the data in the part custom field will transfer to the custom field for the PO item.
Tracking tab
Part module options tracking subtab.png
  • The tracking tab allows new part tracking items to be created. To add part tracking, click the New button located on the component toolbar to the right. A blank line item will be added to the bottom of the tracking list. Enter the name, abbreviation, and description. The type can be set to any of the following: Text, Date, Expiration Date, Serial Number, Money, Quantity, Count, or Checkbox. Unchecking the active box will inactivate a tracking item.
Part Wizard tab
Part Module Options Part Wizard.png
  • Don't show these steps in the New Part Wizard
When creating a new part, many of the wizard steps can be hidden by checking the Checked.png Don't show this step again checkbox. The visibility of the steps can be set at the bottom of the wizard steps, or in the module options.