• Instructions for updating Fishbowl to the latest version can be found in Update Fishbowl.
• Release Notes for older versions are found in the Release Notes archive.
• Upcoming features are found in the Road Map.

2022.1 - 1/13/22

Highlights - 2022.1

• Updated Log4j to the latest version
• Added module options in the Receiving module to require the Ref # and Bill Date fields during the reconcile wizard
• Added the ability to save the Advanced Search in the Inventory module
• The CardConnect payment gateway has been updated to save cards to the Wallet when processed through a terminal device
• The CardConnect payment gateway has been updated to use new mandated classification fields on transactions sent to CardConnect

New Features - 2022.1

• A column displaying the part UOM was added to the Summary step of the MRP wizard
• The Square Payment Gateway has been updated to exclude inactive locations in the Location selection list
• Removed the 32-bit version of the Fishbowl Installer
• Added the ability to scrap inventory through the REST API
• Updated the SaveImageRq API call to accept images for Sales Orders
• Updated the SaveImageRq API call to accept images for Work Orders

Fixes - 2022.1

CSV

• Resolved: Incorrect column header in the Customer Parts CSV. (Previously listed as "CustomerLastPartPrice")

Dashboard

• Resolved: Client login being slowed down due to the Dashboard loading as a saved tab

Email Settings

• Resolved: Using "Sign in with Google" while also having data in the Username and Password fields causes emails to fail to send

Sales Order

• Resolved: Right-click and Issue ignored the "Issue Sales Orders" module option when manager approval would be needed

2021.12 - 12/9/2021

• Custom fields can now be viewed in the Sales Order line item table as additional columns
• Custom fields can now be viewed in the Purchase Order line item table as additional columns
• Updated encryption of passwords

• Added the ability to Add Inventory with Tracking through the REST API
• Added the ability to Add Inventory with Serial Numbers through the REST API
• Updated third party dependencies
• Improved REST API documentation

API

• Resolved: Being able to add inventory for parts that are not inventory type

Part

• Resolved: The Part search "Display more information" button not showing correct data

Pricing Rules

• Resolved: Pricing Rules using vendor currency instead of home currency

Purchase Order

• Resolved: Error when trying to close short a Purchase Order created from a drop ship Kit product

REST API

• Resolved: Product Best Price curl command text update

Database Changes

• Added column passwordLastModified DATETIME(6) to the SYSUSER table
• Increased column userPwd to VARCHAR(255) on the SYSUSER table

2021.11 - 11/11/2021

• The Part Search has been updated to include inventory numbers and images
• Added the ability for the Amazon plugin to purge Personal Identifiable Information (PII) data from Fishbowl

• Added the UOM column to the Inventory Search table
• Added the ability to update a Manufacture Order through the REST API
• Added the ability to search Inventory through the REST API
• Added Category to the Manufacture Order REST API object
• Added the ability to add inventory via the REST API
• Added the ability to get pricing rule pricing through the REST API
• JXBrowser has been updated to the latest version
• The QuickBooks Desktop integration has been updated to create the Cost Variance Account as a COGS type account

CSV

• Resolved: Consumption Rate missing from the Part CSV instructions
• Resolved: Consumption Rate missing from the PPVP CSV instructions
• Resolved: Tax Rate errors when importing the Product CSV in a Canadian database

Customer

• Resolved: Date Last Modified being updated when a new Sales Order is created/saved

Dashboard

• Resolved: Report Widget arrows being backwards

QuickBooks Desktop

• Improved error messaging for errors dealing with Closing Dates

Sales Order

• Resolved: Sales Order item details dialog loading slowly

Shipping

• Resolved: Slowness shipping large quantities of kits

Time

• The plugin has been updated to update time/wo/part records to the new plugin format

Xero

• Resolved: Receiving holding account not reversing when order is fulfilled

Database Changes

• Removed SOITEMTOMOITEM table

2021.10 - 10/14/2021

• Added a Consumption Rate to the Part module to be used in Reorder Point calculations
• Updated the Auto ROP wizard to be named MRP
• Added Days of Stock to Part Inventory details to show an estimates days of stock based on the Parts Consumption Rate
• The Select Parts step of the MRP wizard has been updated to only show Inventory type parts
• The Date Range step of the MRP wizard now has an option to use the Parts Consumption Rate stored in the Part module
• The Date Range step of the MRP wizard now has options to select which Consumption to include when calculating a Parts Consumption Rate
• The Forecasting step of the MRP wizard now has the option to select which Consumption to include when Part Consumption Rate was chosen on the previous step
• The Reorder Point step of the MRP wizard has been updated to pull the Default Vendors Lead Time for the ROP calculation
• The Order Up to Level step of the MRP wizard has been updated to the new MRP terminology
• The Summary step of the MRP wizard has been updated with additional columns, sorting, and inline editing
• The Summary step of the MRP wizard has the option to update the Part's Consumption Rate upon finishing the wizard

• Added an access right for duplicating Sales Orders
• Added an access right for duplicating Purchase Orders
• Added Barbados to the Currency list
• Added the ability to update a Manufacture Order through the REST API

Checkout

• Resolved: Company image not displaying on Checkout secondary monitor screen

CSV

• Updated the Product Import instructions to match terminology used in the client

Customer

• Resolved: Being able to update the currency rate for customers set to Home Currency through the module and CSV import

Part

• Resolved: The Default Returning As part is incorrectly set after duplicating a part

QuickBooks Desktop

• Resolved: No Certificate being displayed when integrating

REST API

• Resolved: REST API does not use the server option to only allow a user to be logged in once
• Resolved: SSL Context error with Jetty Server on startup

Settings

• Updated the Max Thumbnail Size to not allow a number below 16

Server

• Improved calculation rounding precision in situations dealing with money

Square Payment Gateway

• Resolved: The location chosen when integrating was missing in the transaction requests sent to Square

Transfer Order

• Resolved: Module Option dictating which location the Transit location is created in not working as designed

Vendor

• Resolved: Being able to update the currency rate for vendors set to Home Currency through the module and CSV import

Work Order

• Issue: Error when creating a custom Work Order where the Finished Good is a Kit

• Resolution: Removed Kits from the available list when selecting a Finished Good

Xero

• Issue: Balance Debits and Credits error displaying only the PO Ref #

• Resolution: The PO # is now displayed in the error as well as the PO Ref #

Database Updates

• Added CONSUMPTIONRATE column to the PART table

2021.9 - 9/9/2021

• The Square Payment Gateway was been updated to the latest API/SDK

• Updated the PartGetRq to select active parts first when searching based on UPC
• Added Suriname to the Currency country list

Accounting Integrations

• Issue: "Balance Debits and Credits" export error

• Resolution: Locked down scenarios allowing for landing costs across multiple reference #'s and bill dates

CSV

• Resolved: Pricing Rule CSV duplicate entry error

Picking

• Updated error message on pick module refresh when the pick has been removed

Square

• Resolved: Failed to Process error message due to multiple emails in the email field

Work Order

• Resolved: Custom Work Order wizard allowing partial eaches

Database Changes

• Resolved: Added dateExpiration column to the PaymentGateway table

2021.8 - 8/12/2021

• The line item Scheduled Date on Transfer Orders has been opened up to allow editing until item is received
• The Order Location Group has been added to the Next Orders section of the Inventory Details screen

Accounting Intergrations

• Resolved: "Please Balance your debits and credits" export error

API

• Resolved: Errors caused by UOM conversion issues when picking serial numbers

Client

• Resolved: Server Shutdown Timer message showing an error

CSV

• Resolved: Customer Parts not using the customer full name for import/export
• Resolved: Location CSV not using the customer full name for import/export
• Resolved: Incorrect character limit for salesman in SO and SO Details CSV instructions

Linux

• Resolved: Incorrect line encoding in eve.sh file

QBO

• Resolved: Null export error on note/subtotal type line items

REST API

• Resolved: UserId missing from login request

Work Order

• Resolved: Updated finished good and raw good text during the Custom WO wizard

Xero

• Resolved: Purchase Order inventory holding account transactions not being reversed upon fulfillment

2021.7 - 7/15/2021

• Multiple email addresses are now sent from Fishbowl to QuickBooks Online on Customers and Invoices

• Added a user right to limit the Add functionality of the Inventory module
• Updated the Check Balance button of the Customer module to exclude estimate status orders
• Added Location Group search options through the REST API
• Added the ability to create UOM's through the REST API
• Added the ability to update UOM's through the REST API
• Enhanced the MO create REST API call to allow for creation of custom orders

Custom Fields

• Resolved: Checkbox type custom fields are not transferred to the Sales Order module from the Customer module

Fishbowl Client

• Resolved: Enter button not working in Advanced Search after closing and reopening a module
• Client Connection changes for connection issues

Pick

• Resolved: Pick custom fields being cleared out when using API calls

QuickBooks Desktop

• Resolved: Miscellaneous Credit general journal entries posting incorrectly
• Issue: Payments exporting and automatically applying to Invoices incorrectly

• Resolution: Added a module option for Automatically Applying Payments that can be disabled

QuickBooks Online

• Resolved: Vendor credit return posting incorrect journal entries

REST API

• Resolved: Issues with Purchase Order custom fields
• Resolved: Custom fields issues on Manufacture Order creation

UOM

• Resolved: Make default UOM's, like Each, inactive did not remove them from the UOM list when creating new parts
• Updated text for Abbreviation fields

User Group

• Resolved: "See All Customers" user access right not limiting customers in the Product module, Customers tab

Xero AU

• Resolved: "Unexpected error: Please reintegrate with Xero."

2021.6 - 6/10/2021

• Mac installer improvements
• Added the ability to right-click multiple sales orders in the search pane and close short the orders

• Added the Zimbabwean Dollar to the available currencies list
• Updated the login message when exceeding the number of licensed users
• The Sales Order CSV import now looks at the customer's priority setting if the priority field is left blank
• Unchecked "Always use the multiple finished goods step" MO module option by default for new databases
• Updated the default MySQL settings for new installs
• Updated Jetty to the latest version
• LDAP logins are now supported in the REST API
• Added the UOM object to the REST API
• Added the ability to delete a UOM through the REST API
• Added Part Search to the available REST API calls
• Added UOM Search to the available REST API calls
• Added Vendor Search to the available REST API calls
• Added the Manufacture Order object to the REST API
• Added the ability to create a Manfacture Order through the REST API
• Added the ability to issue a Manufacture Order through the REST API
• Added the ability to unissue a Manufacture Order through the REST API
• Added the ability to close short a Manufacture Order through the REST API

Client

• Resolved: Unable to open multiple client instances on the same computer
• Resolved: Login and logout issues that caused the client the freeze
• Resolved: Chat box goes off screen for long messages

Company

• Updated text for LDAP module options

CSV

• Resolved: Null import error when importing blank UPC with the module option "Only allow numeric characters in UPC code" enabled
• Resolved: Import issues when importing incomplete data in the UOM CSV import

Intuit Payments

• Resolved: Error when taking a payment for a card already stored as a wallet

Manufacture Order

• Resolved: Unissuing a Manufacture Order did not clear out the issue date
• Resolved: Partially fulfilling a WO, the secondary WO doesn't auto commit inventory when that option is enabled
• Resolved: Partially fulfilling a WO, the secondary WO doesn't pick from the correct location
• Resolved: Finishing a WO/MO does not allow duplicate serial numbers for separate serial type tracking

Purchase Order

• Resolved: Data not being saved after changing the date scheduled to the same date and choosing to update the line item dates

QuickBooks Online

• Resolved: "Please balance your debits and credits" error when exporting bills

Receiving

• Resolved: Currency showing USD for a multi currency order with the multi currency values

Sales Order

• Resolved: Unable to save after fulfilling a service item that is part of a kit

Database Changes

• Removed unused leadTimetoFulfill from the Part table

2021.5 - 5/13/2021

• Added the ability to enter a Forecast % on the Auto PO wizard Summary page
• You can now set the schedule date for the Purchase Orders being created during the Auto PO wizard
• Added hover over details to quantity and cost columns in the Auto PO wizard Summary page
• Quantity, Unit Cost and UOM columns have been added to the Auto PO wizard Summary page
• Added an option to round up quantities to the nearest whole number during the Auto PO wizard
• Added the ability to edit in line on the Auto PO wizard summary page
• The vendor lead-time is displayed per part in the Auto PO wizard
• The Date Scheduled during the Auto PO wizard automatically uses vendor lead-times to set the date
• Added a module option in the Receiving module to update vendor lead times when receiving a part

• The Sales Order CSV pulls custom field values for customers when module option is enabled
• The Sales Order CSV pulls custom field values for products when module option is enabled
• Add a delete confirmation when removing a part from a PO during the Auto PO wizard
• Available Address Validation has been updated to communicate over HTTPS
• Updated "Send email when shipment is shipped" to have options for the Shipping Report, Shipping Invoice report, or None
• The "Specify Kit Price" option now functions the same way whether the order is created via the client or CSV
• Added a Manufacture Order search call to the REST API
• Added ability to delete a Manufacture Order through the REST API
• Manufacture Order Memos can now be created/updated/deleted through the REST API
• Upgraded the REST documentation navigation pane
• Updated the Part Best Cost call to include vendor minimum quantities
• Packing Slip - Added carrier service. Added a "Blind Shipment" checkbox. When checked, the company logo and address info will not print
• Pick Ticket - Added carrier service

Accounting

• Resolved: Errors in export due to voiding items in receiving

Database

• Resolved: QtyOnOrder view not matching On Order quantity in Inventory Module

CSV

• Update instructions text for the Bill of Materials Details CSV
• Resolved: SO Details and SO CSV's do not check for duplicate vendor names

Customer

• Resolved: Tax exempt checkbox and number field showing available in the new customer wizard in Canadian databases

Gmail Integration

• Resolved: Old Fishbowl Logo showing on the final integration step

QuickBooks Desktop

• Resolved: Export error's on misc items

Part

• Resolved: Able to add tracking to default return as Part

Purchase Order

• Resolved: Ability to edit qty/cost during Auto PO on the "No Vendor" step

REST API

• Updated the Purchase Order search CompletedTo/From to FulfilledTo/From
• Resolved: Server Connections screen not updating for REST users on login and logout

Vendor

• Resolved: Vendor Last Cost not updating the Last Date when cost is updated

2021.4 - 4/15/2021

• Added Purchase Order SMS based notification subscriptions for Purchase Order approvals

• Added customer reference to Purchase Order journal entries in QuickBooks Online
• Increased Customer and Vendor alert notes character limit to 256
• Added a module option in Fishbowl Checkout to default the Salesperson field to blank
• Added a user right to control access to Payment Terms dropdown on a Sales Order
• Added a module option to set the Sales Order # or Shipment # to go to the QuickBooks Desktop "Other" field
• Updated custom field REST API search to search by ID instead of name
• Added the ability to close short a Purchase Order through the REST API
• Added the ability to close short Purchase Order items through the REST API
• Updated the Currency REST call to include the currency code
• Added a user search call for the REST API
• Added a get part best cost call in the REST API for Purchase Orders
• Updated legacy VendorGet API call to link in addresses
• Z Report: Now displays the salesperson and has an option to sort by various columns
• SO Report: Fulfillment Date label changed to Date Scheduled (still displays the item Date Scheduled)

API

• Resolved: Calls not setting the userid on the REVINFO table

Client

• Resolved: Inactivity causing the client application to become unresponsive

CSV

• Resolved: EDI Shipping blank export due to Null error
• Resolved: Sales Order CSV instructions text update
• Resolved: Locations import running slow when importing 1000's of location for a single location group
• Resolved: Slowness when importing the Receiving Data import

Custom Fields

• Resolved: Slowness with custom lists

Part

• Resolved: Issues changing the default return as part when duplicating an outsourced part

Picking

• Resolved: Pick Location selection issue across multiple locations

Product

• Resolved: Product Module Sort by Product Type sorting issue

Purchase Order

• Resolved: Unable to unissue Purchase Order after voiding receipt
• Resolved: Outsourced PO item Null error
• Resolved: Auto PO location group reordering issue

QuickBooks Online

• Resolved: Receiving holding account entry not being reversed upon fulfill
• Resolved: Purchase Order journal entries should set the class for the line item and not the order class

QuickBooks Online - Australia

• Resolved: Imbalance and rounding issues

QuickBooks Online - Canada

• Resolved: Query Parse Export error on Invoice

Receiving

• Resolved: Discrepancy between multi-currency subtotal and billed total

Reports

• Resolved: Sales By Rep BI Report - Not including discounts
• Resolved: Inventory Availability Report - Available to Pick calculating incorrectly

REST API

• Resolved: Blank error for Purchase Orders with tax rate of none on Non-US databases
• Resolved: Documentation for QB Class listing as option but it is being required
• Resolved: Inconsistencies between Purchase Order and Purchase Order item Tax Rate references on the documentation

RMA

• Resolved: Null error when creating a Return and not verifying by order

Work Order

• Resolved: Seemingly random quantities when splitting repair Work Order lines

Database Changes

• Updated Customer.note field to be varchar(256)
• Updated Vendor.note field to be varchar(256)
• Created Notification table
• Created NotificationType table

2021.3 - 3/11/2021

• Added the ability to require approval for Purchase Orders over a specified dollar amount
• Added user right to allow users to approve Purchase Orders in the Pending Approval status
• Added the ability to assign different print defaults for packing and shipping

• Added logos for plugins into the module header bar
• Sales Orders created by RMAs without a verified order will use customers default salesperson
• Added a user right to limit access to the Payment Deposit Account in the payment wizard
• Added a user right to limit access to the Payment Date in the payment wizard
• Added Home Currency flag on currency object for Purchase Order REST API
• Added total cost for Purchase Order in REST API
• Updates to error messages when using the Purchase Order REST API
• Added the ability to access memos in the Purchase Order REST API

Checkout

• Resolved: Null error when fulfilling a credit return

CSV

• Resolved: Bad error message for duplicate abbreviation when importing the UOM csv
• Resolved: Imported discount amounts not coming in properly for multi currency customers

Customer

• Resolved: Customers with stored wallets not loading due to missing icons

Database Update

• Resolved: Database update failure due to multiple shipping invoice reports

Installer

• Resolved: Inability to install a Client Only version due to license key requirement
• Updated the installer to exclude the webapp folder on Client Only installs

Kits

• Resolved: UOM UI conversion error when editing quantities on a Sales Order

Linux

• Resolved: Notification animation causing the client to lock up
• Resolved: Environments without a system tray unable to see server window

Purchase Order

• Resolved: Line item notes not saving on partial or fulfilled status line items
• Resolved: Unissuing a PO does not clear out the date issued
• Resolved: Unissuing a PO does not change the Last Modified info

QuickBooks Desktop - Canadian

• Resolved: Issues with Sales Receipts vs Invoice/Payment creation on export
• Resolved: Rounded cash transactions not exporting the amount on sales receipts

QuickBooks Online

• Resolved: Business Validation error on export
• Resolved: Jobs imported from QuickBooks Online creating new job entries on export

Receiving

• Resolved: Errors when receiving an outsourced item with a rejection

REST API

• Resolved: Bad error message when updating an existing Purchase Order

Database Updates

• Dropped dependencies on SOITEMTOMOITEM table
• Module Table
• Renamed “Shipping Label” to “Shipping Invoice”
• PO Table
• Added column IssuedByUserId int(11) default null
• POStatus Table
• Increased Name column to 20 characters
• Added “Pending Approval” with id 15

2021.2 - 2/18/2021

• Fishbowl's look and feel has been updated with a new color scheme, icons, and splash screen for 2021
• Beta release of web based Rest API with endpoints for Purchase Orders

• The Advanced Search for sales orders has a new tab to be able to search line item custom fields
• Added a Program Option for setting the table line height throughout Fishbowl
• Updated the description for the custom report text in the Sales Order module options
• Added additional license key and support contract validation during installation
• The installer has been updated to include a few "Things to consider before updating"
• The Part CSV import now has the ability to assign a default outsourced return part
• The Receiving Data CSV import now has the ability to update shipping information for the order

API

• Resolved: API not updating UserID on audit tables

Accounting Exports

• Resolved: Issues causing the Mark as Posted function to fail

Client

• Resolved: Auto logout caused the Sales Order module to lock up
• Resolved: Auto logout not closing additional open windows (Advanced Searches, etc.)

Company

• Updated text in Module Options

CSV

• Updated instructions text on Part Cost import/export
• Updated instructions text on Part UOM import/export
• Resolved: Locations import no updating location types
• Resolved: Sales Order CSV import does not transfer line item notes to the Work Order for Build to Order products
• Resolved: "Duplicate Bill of Materials Option Group found" import error when modifying parts on the Bill of Materials

Custom Fields

• Resolved: Long Text type custom fields not providing a scroll bar when needed

Intuit Payments

• Resolved: A declined payment did not show the appropriate exception when taking a payment

Location

• Resolved: Location type of a default location could be changed

Location Groups

• Resolved: Inactive users showing in location group user section

Manufacture Order

• Significant speed improvements to Advanced Search

Purchase Order

• Resolved: Being able to search order custom fields without user access rights assigned

QuickBooks Online

• Resolved: Part/Product/Item validation errors
• Resolved: Updating customer details in Fishbowl erasing customer info in QuickBooks Online
• Resolved: A miscellaneous sale not hitting the COGS Account when cost was added
• Resolved: "Cannot Change who Customer Bills With" error when exporting customer job updates
• Resolved: Missing classes on reconciled journal entries
• Resolved: Partially shipped kits sending tax twice

QuickBooks Online AU

• Resolved: Updating vendor info in Fishbowl erases banking info on export

Sales Order

• Resolved: Price discrepancies when closing short a drop ship order
• Resolved: Add button in Custom Work Order wizard not functional
• Resolved: FedEx Shipping Tracking # link did not pull up the tracking on www.fedex.com
• Resolved: Divide by zero error when partially shipping and closing short an order with a kit

Schedule

• Resolved: Sorting issues when sorting the Last Run Time column

Shipping

• Resolved: Shipping custom fields clearing out when saving with shipping through ShipExpress

Tax Rate

• Resolved: View only rights still allowing users to edit tax rates

UOM

• Updated text descriptions during the Add New UOM Conversion Wizard

Work Order

• Resolved: Save dialog popping up when nothing was changed

Database Changes

• Remove SOITEMTOMOITEM table
• Added a new column to the MOITEM table for SOITEMID