Fishbowl Advanced
Release Notes: Difference between revisions

Release Notes: Difference between revisions

From Fishbowl Advanced
No edit summary
(Added completed work for 2025.6 release 3/22/26)
 
(479 intermediate revisions by 7 users not shown)
Line 1: Line 1:
{{ReleaseNotesIntro}}
{{ReleaseNotesIntro}}
__TOC__
<!-- To insert the template for a new release, paste the following line


<!-- To insert the template for a new release, paste the following line, update the numbers...
{{subst:Insert|25.3|2|18|25}}
{{subst:Insert|2022.11|11|10|22}}
 
...verify the dates
...and then save the page -->
...and then save the page -->
{{Release|26.5|05|19|26}}
==Highlights - 26.5==
* <u style="color: red;">'''Important Notice'''</u>: '''MySQL 8.0 End of Life - Update Optional for Now''' - MySQL 8.0 reached End of Life (EOL) in April 2026. Oracle will no longer issue security patches, bug fixes, or official support for MySQL 8.0. While we recommend upgrading to MySQL 8.4 LTS, '''this update is NOT required at this time'''. Fishbowl will continue to support MySQL 8.0 until the September 2026 release. '''You can safely use the standard auto-update process for version 2026.5''' - it will maintain your current MySQL 8.0 installation. For detailed upgrade instructions, visit: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update</nowiki>
* <u style="color: red;">'''Important Notice'''</u>: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
* <u style="color: red;">'''Important Notice'''</u>: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.5. Follow the instructions here to migrate to MySQL 8.0: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration</nowiki>
* <u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.5 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
* <u style="color: red;">'''Important Notice'''</u>: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.5.
* Improved client connection performance with reduced server communication overhead
* Product search now correctly defaults to active items only in the Products module
* Accounting export errors related to manually corrected landed costs resolved
* QuickBooks Online and Xero integration export errors resolved


==New Features - 26.5==
* '''Client connection performance improvements.''' The Fishbowl client connection has been optimized to reduce the number of server round-trips made during normal operation. Clients now check whether server-side updates are available before requesting them, rather than fetching on every interaction. Users on high-latency or slower network connections should notice improved responsiveness.


{{Released|2022.10|10|13|22}}
==Fixes - 26.5==
==Highlights - 2022.10==
'''General'''
* [[Payment Gateway|New payment gateway integration to Stax Pay in Payment Gateway module (enrollment link included). Stax Pay allows users to process, refund, and void credit card (not present) transactions.]]
* [[Reports#Packing_Slip|The Packing Slip 4x6 label previously available on our reports store has been added as a standard report.]]


==New Features - 2022.10==
* Resolved: After upgrading to version 2026.3, the Products module search began returning both active and inactive products by default. The Active Only filter shown in Advanced Options was not being applied on initial load or when clicking the search button. The default search behavior now correctly limits results to active products.
* [[Reports|Gross Sales By Product Report: Added some options and a slight redesign to make the report more Excel friendly.]]
* [[Reports|Added custom fields to the following reports: Packing List, Shipping Invoice, and Sales Order Summary.]]
* [[Reports|Sales Order Summary: The report can now be filtered by a custom field. Added the option to show orders with a Cancelled status. Reorganized the Modify Report dialog.]]
* [[Plugin|Updated to the latest version of JxBrowser.]]


==Fixes - 2022.10==
'''Accounting'''
'''Picking'''
* Resolved: Insufficient quantity error when picking decimal quantities from a UOM conversion with date or text tracking.
* Resolved: UOM conversion issue during picking causing database problems.
'''Manufacture Order'''
* Resolved: Custom bill of materials + button not functional. It has been removed.
'''Reports'''


* Resolved: Product Catalog V2 replacing original Product Catalog in new databases.
* Resolved: When manually applying landed costs, entering an incorrect amount that triggered a validation error and then correcting the value would cause Fishbowl to accumulate both the invalid and corrected amounts rather than replacing the prior entry. This resulted in an overstated landed cost total and a "Please balance your debits and credits" error on accounting export. The correction now replaces the prior entry rather than adding to it.
* Resolved: Exporting a Sales Order to QuickBooks Online failed with an "Amount is not equal to UnitPrice * Qty" error when associated pricing on the order had been changed after the order was issued. The unit price was not being correctly carried through to the export calculation. The export now uses the price stored on the sales order line item.
* Resolved: Exporting a Credit Return Sales Order to Xero failed with a line total mismatch error when stock for the return was received in multiple batches (e.g., two receipts of 5 units for a line originally returned as 10). Fishbowl was not correctly apportioning the unit price across split receipts, producing mismatched totals. The export now correctly calculates line totals for split credit return receipts.


'''Mac Client'''


* Resolved: Command-Q keyboard shortcut not logging the user out.
{{Released|26.4|04|14|26}}
==Highlights - 26.4==


'''CSV Import'''
* <u style="color: red;">'''Important Notice'''</u>: '''MySQL 8.0 End of Life - Update Optional for Now''' - MySQL 8.0 will reach End of Life (EOL) in April 2026. Oracle will no longer issue security patches, bug fixes, or official support for MySQL 8.0. While we recommend upgrading to MySQL 8.4 LTS, '''this update is NOT required at this time'''. Fishbowl will continue to support MySQL 8.0 until the September 2026 release. '''You can safely use the standard auto-update process for version 2026.4''' - it will maintain your current MySQL 8.0 installation. For detailed upgrade instructions, visit: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update</nowiki>
* <u style="color: red;">'''Important Notice'''</u>: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
* <u style="color: red;">'''Important Notice'''</u>: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.4. Follow the instructions here to migrate to MySQL 8.0: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration</nowiki>
* <u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.4 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
* <u style="color: red;">'''Important Notice'''</u>: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.4.
* New user rights added for individual Import/Export operations
* Improved user security with automatic password expiration and CSV-based temporary password assignment
* Updated USPS address validation integration
* Quality and reliability improvements across accounting, purchasing, inventory, and receiving modules


* Resolved: Currency ID not importing with Purchase Order CSV Import.
==New Features - 26.4==


'''Receiving'''
* '''Granular Import/Export access rights.''' A new set of 114 individual access rights has been added — one for each import and export operation — giving administrators the ability to allow or deny specific import and export operations per user group. The existing Import/Export-View access right continues to control visibility of the Import/Export menu item. All existing user groups are automatically granted the new rights via migration to maintain backward compatibility.
* '''Inventory: Require Notes on Quantity Adjustments and Inventory Moves.''' Two new module options have been added to the Inventory module that allow administrators to require users to enter a note when adjusting inventory quantities or moving inventory between locations. Both options are off by default. When enabled, users must provide a note before completing the action, creating a documented record for each inventory change.
* '''Automatic user password expiration.''' A new option in the Users module allows administrators to enable automatic password expiration. When enabled, a configurable expiration period (in days, defaulting to 30) is set, and users are prompted to reset their password at their next login after it expires. This improves password security for organizations that require periodic credential rotation.
* '''Temporary password assignment via users.csv import.''' A new optional "Password" column has been added to the users.csv import format, allowing administrators to assign a temporary password when creating new users via CSV import. This field applies to new user creation only and cannot be used to reset passwords for existing users. This action is limited to the admin user.
* '''USPS Address Validation update.''' The USPS address validation integration has been updated to work with the current USPS API. This feature, which allows users to validate shipping addresses on orders directly within Fishbowl, was previously non-functional due to changes made by USPS.
* '''REST API: Part tracking data on GET Shipment.''' The GET Shipment endpoint now returns part tracking information on ship items when tracking data is present, matching the tracking details visible when viewing a shipment in the Fishbowl client.
** '''GET /api/shipments/:id''' - Now includes a tracking object on each shipItem when applicable.


* Resolved: Receiving details load slowly in some circumstances.
==Fixes - 26.4==
'''Part'''
'''General'''


* Resolved: Part creation erroring due to not having a "returning as" part associated even for types other than "Outsource".
* Resolved: Cost and price fields, line item totals, and order totals on Purchase Orders and Sales Orders now display correctly when the home currency is set to an Arabic currency (e.g., Kuwaiti Dinar, Iraqi Dinar, Omani Rial, Bahraini Dinar). Previously, values displayed using Eastern Arabic numerals instead of standard numerals, and order totals did not appear at all.
{{HideReleased|2022.9|09|08|22}}
* Resolved: Cycle counts that result in no quantity change (where the counted quantity exactly matches the system quantity) are now saved as records. Previously, zero-change cycle counts were discarded with no record retained, making it impossible to report on when an item was last counted or confirm its accuracy at that point in time.
{{HideH2|Highlights - 2022.9}}
* Resolved: Transfer Order CSV imports now enforce UOM compliance for each line item. Previously, importing a Transfer Order via CSV allowed any unit of measure to be assigned, regardless of whether it was valid for the part, which could corrupt order, pick, and inventory records.
* [[Settings#Email_tab|Sign in with Microsoft. Updated authentication process for Microsoft email settings.]]
* Resolved: Filtering when exporting via the CSV export wizard now works correctly. Previously, applying a filter in the export wizard would result in a blank error and no file was produced. Exporting without applying a filter was unaffected.
* [[Advanced_Reports#Custom Fields|Custom fields can now be displayed on standard reports. The SO Report can now display up to 6 SO custom fields and 3 SO line item custom fields. Custom fields will be added to additional reports in the coming months.]]


{{HideH2|New Features - 2022.9}}
'''Purchasing and Receiving'''
* [[Sales_Order#Take_a_payment|Estimated tax will now be displayed in the Payments wizard when integrated with Avalara.]]
* [[Access_Rights#Receiving|Added a user access right to hide/show tax columns in the Receiving module (non-US versions only).]]
* [[Manufacture_Order#Module_Options_General_tab|Added a new Manufacture Order module option: "Do not recalculate labor quantities in fulfillment wizard". When checked, labor quantities will not be adjusted in the consumption step of the WO fulfill wizard.]]
* [[Advanced_Reports#Purchase_Order_Report|Option to modify field titles added to PO Report, Shipping Invoice, and Packing List. Modify report window has also been reorganized with tabs and groups in these reports.]]


{{HideH2|Fixes - 2022.9}}
* Resolved: Outsourced Purchase Orders can now be reconciled even when one or more receivable line items do not yet have cost history. Previously, the absence of a cost history for any receivable line would prevent the entire receipt from being reconciled.
'''Sales Order'''
* Resolved: Purchase Order CSV imports now preserve unit cost values with more than two decimal places. Previously, line item unit costs were incorrectly rounded to two decimal places during import, introduced in version 2026.1.
* Resolved: Variable kit items with associated build-to-order BOMs are not creating Work Orders when added to a Sales Order in some instances.
* Resolved: The Receiving Data CSV import now assigns the correct billed unit cost when a single order line is received across multiple CSV rows. Previously, splitting one line into multiple receive lines resulted in each row receiving a different, incorrect calculated cost (e.g., $10.00, $2.00, $2.50, $3.33) instead of the correct value.


'''Database Changes'''
'''Accounting'''
* Increased column sysValue to VARCHAR(3072) on the SysProperties table


{{HideReleased|2022.8|08|11|22}}
* Resolved: QuickBooks Desktop exports now correctly handle tax rounding when Canadian dollars are used as the home currency. Previously, the exported tax amount was rounded up by $0.01, causing a discrepancy between the payment recorded in Fishbowl and the invoice balance in QBD that required manual correction on each affected invoice.
{{HideH2|Highlights - 2022.8}}
* Resolved: Credit returns on Sales Order lines for non-inventory parts now correctly reverse the COGS entry with a negative cost value. Previously, when duplicating a Sales Order and selecting "Credit Return," non-inventory line items retained a positive cost rather than posting a negative COGS, overstating cost of goods sold.
* Resolved: When duplicating a Sales Order as a Credit Return, tax line items calculated by TaxJar and QuickBooks Online Automated Sales Tax are now correctly converted to negative amounts. Previously, these tax line items remained positive on the credit return, resulting in incorrect tax totals instead of properly reversing the original tax charges
{{Released|26.3|03|23|26}}
==Highlights - 26.3==


* Functionality has been added to better allow for the organization of the [[Reports#Modify_report_filters|'''Modify Report''' window]]. Additional tabs can now be added, along with grouping and sorting inside of each tab. We’ve also made it possible for the displaying of tooltips for each setting within the tabs. Select reports have been updated to make use of this new functionality (SO Report, Customer Purchase History, & Part Activity Report). Additional reports will be updated in the coming months.
* <u style="color: red;">'''Important Notice'''</u>: '''MySQL 8.0 End of Life - Update Optional for Now''' - MySQL 8.0 will reach End of Life (EOL) in April 2026. After this date, Oracle will no longer issue security patches, bug fixes, or official support for MySQL 8.0. While we recommend upgrading to MySQL 8.4 LTS before the EOL date, '''this update is NOT required at this time'''. Fishbowl will continue to support MySQL 8.0 until the September 2026 release. '''You can safely use the standard auto-update process for version 2026.3''' - it will maintain your current MySQL 8.0 installation. If you wish to upgrade to MySQL 8.4 now, see the "MySQL 8.4 upgrade" feature description below. For detailed upgrade instructions, visit: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update</nowiki>
* The [[Advanced_Reports#Sales_Order_Report|Sales Order Report]] now has the ability to modify all field titles.
* <u style="color: red;">'''Important Notice'''</u>: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
* <u style="color: red;">'''Important Notice'''</u>: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.3. Follow the instructions here to migrate to MySQL 8.0: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration</nowiki>
* <u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.3 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
* <u style="color: red;">'''Important Notice'''</u>: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.3.
* <u style="color: red;">'''Important Notice'''</u>: Previously the Ebay plugin was not compatible with Java 21. This issue has been resolve and it is now fully functional.
* Improved MySQL 8.4 update process
* New Bi Report
* Enhanced REST API with shipment and payment search functionality
* Improved Sales Order flexibility with kit item type changes
* Quality and reliability improvements across multiple modules


{{HideH2|New Features - 2022.8}}
==New Features - 26.3==


* [[Data#Query_parameters|Added a button that allows parameters to be easily added to queries in the Data module]]
* '''MySQL 8.4 upgrade option (Optional).''' For customers who wish to upgrade to MySQL 8.4 LTS ahead of the September 2026 requirement, the Fishbowl installer now includes automatic MySQL 8.4 upgrade capability. '''This upgrade is completely optional for the 2026.3 release.''' Here's how it works:
** '''Windows users with Fishbowl-installed MySQL 8.0:''' Simply run the full Fishbowl installer (not the auto-update) over your existing installation. The installer will automatically detect and upgrade MySQL 8.0 to MySQL 8.4.
** '''Windows users with manually-installed MySQL:''' You will need to manually upgrade MySQL 8.4 first, then install Fishbowl Advanced 2026.3. The installer will provide instructions if it detects manually-installed MySQL 8.0.
** '''MacOS and Linux users:''' You will need to manually upgrade MySQL to 8.4 first, then install Fishbowl Advanced 2026.3. The installer will provide upgrade prompts and instructions.
** '''If you choose to stay on MySQL 8.0:''' Simply use the standard auto-update process for Fishbowl 2026.3. Your MySQL 8.0 installation will remain unchanged and fully supported. For detailed MySQL upgrade instructions, visit: <nowiki>https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update</nowiki>
* '''Fishbowl Payments (Powered by Run Payments).''' The integration has been updated to continue to help merchants save on credit card processing fees. When you process a payment, Fishbowl automatically sends detailed transaction information to the payment processor, including:
** Order details like customer PO number, order date, and shipping information
** Individual line items with product descriptions, quantities, prices, and product codes
** Accurate tax and shipping amounts By sending this extra information, Fishbowl Payments helps you qualify for the lowest processing fees available for business-to-business transactions. The system automatically handles sending the additional data - you don't need to do anything different when taking payments.
* '''Inventory Reorder Watchlist BI Report.''' A new standalone Inventory Reorder Watchlist BI Report has been added to the BI Reports module, providing detailed visibility into parts approaching or below reorder points with drill-down functionality to investigate specific part details, supplier information, and inventory levels across locations to help prevent stockouts and optimize inventory management. Click [https://help.fishbowlinventory.com/advanced/s/article/BI-Report#Inventory_Reorder_Monitor here] to learn more.
* '''Sales Order kit item type flexibility.''' A new Sales Order module option "Allow changing kit item types" enables users to change the item type (Sale, Credit Return, Drop Ship) for kit items that have been added to a Sales Order. This option is unchecked by default to maintain backward compatibility. When enabled, users can modify kit item types both inline and in the item edit screen, providing greater flexibility for managing inventory status changes.
* '''Enhanced auto-update options.''' A new "Never notify or update automatically" option has been added to the Server Administration page auto-update settings. When selected, Fishbowl will neither notify users about new updates nor automatically update the software, providing complete control over the update process for organizations with strict change management policies.
* '''REST API shipment management.''' The REST API now includes new shipment functionality:
** '''GET /api/shipments/:id''' - Retrieves details of a specific shipment by ID with location group access validation
** '''POST /api/shipments/:id/pack''' - Changes shipment status from Entered to Packed, with validation to prevent packing already packed or shipped orders
** '''Search functionality''' - Returns paginated lists of shipments based on filter criteria with proper access rights checking
* '''REST API payment search.''' The REST API now supports searching for payments with the ability to return paginated lists of payments based on filter criteria. Documentation has been added to the Payments section of the REST API docs with proper access rights checking.
* '''REST API product search.''' The REST API now supports searching for products with the ability to return paginated lists of products based on filter criteria. Documentation has been added to the Products section of the REST API docs with proper access rights checking.
* '''Updated Remote Assist link for AU databases.''' Australian database users accessing Help > Remote Assist are now redirected to the correct remote support page (<nowiki>https://apac.fishbowlinventory.com/s/remote-assist/</nowiki>) instead of the booking support page.


{{HideH2|Fixes - 2022.8}}
==Fixes - 26.3==
'''Sales'''


'''Class'''
* Resolved: Kits containing both standard type kit items and variable quantity type kit items can now be added to Sales Orders with the variable quantity item set to 0, as long as at least one standard kit item has a quantity greater than 0. Previously, the system incorrectly displayed an error stating "Invalid Qty: Kit must have at least one item in the kit" even when standard items were present.
* Resolved: Creating a new class freezing the client or giving an error but still creating the class depending on client connection type
* Resolved: Sales Order totals now display correctly when the home currency is UAE Dirham or other non-US currencies. Previously, total values at the bottom of orders would not display, though line item unit prices displayed correctly.


'''CSV'''
'''Payments'''
* Resolved: Mismatched error message when trying to update part UOMs with the Part UOM CSV import


'''Product'''
* Resolved: Fishbowl Payments (Powered by Run Payments), The payment window has been resized to ensure all three payment options (Card Present, Manually Entered (Send to Payment Terminal), and Manually Entered) are visible when connected to a payment terminal, eliminating the need to manually stretch the window.
* Resolved: Adding products to a product tree caused the client to freeze when using the non-web connection
* Resolved: CloverConnect card processing via terminal continues to function properly after removal of outdated port numbers from integration URLs.


'''Receiving'''
'''Manufacturing'''
* Resolved: Blank error when receiving an order with two parts and only entering a ref # on the first item


'''REST API'''
* Resolved: BOMs with notes can now be properly deleted from partially fulfilled Manufacturing Orders without requiring Knowledge Engineer or Support assistance. Previously, attempting to delete BOMs with notes would generate a null error.
* Resolved: Missing information on Import data via JSON curl example
* Resolved: Null error when using the MO Create call when the user does not have a default location group and does not specify a location group in the request


'''Sales Order'''
'''Purchase'''
* Resolved: Kit pricing becoming incorrect when changing the customer on the order


'''Server'''
* Resolved: When the "Update vendor cost on issue" Purchase Order module option is unchecked, vendor costs are no longer incorrectly updated when issuing orders. Additionally, when multi-currency is enabled and vendor costs are updated, the calculations are now accurate. Previously, changing the currency conversion rate on a Purchase Order could incorrectly update vendor last costs with wrong values for both home and foreign currencies.
* Resolved: Logging out API users not logging out the API users
* Resolved: Purchase Order totals now display correctly when the home currency is UAE Dirham or other non-US currencies. Previously, total values at the bottom of orders would not display, though line item unit prices displayed correctly.


'''Database Changes'''
'''Accounting'''
* Removed Substitute product links from kits on the KITITEM table


{{HideReleased|2022.7|07|14|22}}
* Resolved: QuickBooks Online can again create new currencies when exporting from Fishbowl if they don't already exist in QuickBooks Online. Previously, exports would fail with an "Operation could not find resource for entity companycurrency is not supported" error when a currency existed in Fishbowl but not in QuickBooks Online.
{{HideH2|Highlights - 2022.7}}
* Resolved: Xero exports now properly handle part cost journal entries when class tracking (categories) is enabled. Previously, exporting part cost changes would fail with a null error because journal entries did not have a class/category assigned and the system was incorrectly validating these entries.


* [[{{REST API}}|The web connection Client functionality is now available to all users]]
* [[{{REST API}}|New Fishbowl installs now use the web connection by default]]


{{HideH2|New Features - 2022.7}}
{{Released|26.2|02|19|26}}
==Highlights - 26.2==
* <u style="color: red;">'''Important Notice'''</u>: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
* '''<u style="color: red;">Important Notice</u>''': Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.2. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
* <u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.2 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
* '''<u style="color: red;">Important Notice</u>''':  Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.2.New and updated Business Intelligence Dashboards with enhanced data visualization
* Expanded Server Administration capabilities for remote management
* Enhanced REST API for improved performance
* Outsourced Purchase Orders now support parts with tracking
* Quality and reliability improvements across multiple modules


* [[QuickBooks_Online#Module_Options_QuickBooks_Online_tab|Added a module option to allow Bank Transfer as an available payment method in QuickBooks Online]]
==New Features - 26.2==
* [[{{REST API}}|Combo boxes in the Client now update appropriately when using the web connection]]


{{HideH2|Fixes - 2022.7}}
* '''New Business Intelligence Dashboards.''' Two new and three updated professionally-designed BI Dashboard reports are now included by default both as Dashboards and in the BI Reports module, providing powerful data visualization and decision-making tools:
** '''New Production Scheduling Module''' - Manufacturing order planning and scheduling optimization featuring an interactive calendar view where manufacturing orders can be moved and rescheduled by dragging and dropping, plus drill-down functionality for detailed work order analysis. Click [https://help.fishbowlinventory.com/advanced/s/article/Production-Scheduling here] to learn more.
** '''New Company Dashboard''' - High-level company performance overview with drill-down capabilities across multiple business areas for deeper insights. Click [https://help.fishbowlinventory.com/advanced/s/article/Company-Dashboard here] to learn more.
** '''Updated Sales Dashboard''' - Comprehensive sales performance metrics and trends with drill-down functionality to explore detailed order and customer information. Click [https://help.fishbowlinventory.com/advanced/s/article/Sales-Dashboard here] to learn more.
** '''Updated Purchasing Dashboard''' - Purchase order tracking and vendor performance analysis with drill-down capabilities to view detailed purchase order and vendor data. Click [https://help.fishbowlinventory.com/advanced/s/article/Purchasing-Dashboard here] to learn more.
** '''Updated Inventory Dashboard''' - Real-time inventory reorder watchlist and stock management with drill-down options to investigate part-level inventory details. Click [https://help.fishbowlinventory.com/advanced/s/article/Inventory-Dashboard here] to learn more.
** '''Note:''' These new BI Dashboard reports must be granted as user rights in the User Group module for users to view them. Each Dashboard has its own unique user right under the access tab and the Bi Reports tab. Administrators should review and assign appropriate access rights to users who need access to these dashboards.
** '''Note:''' If you prefer the previous dashboard experience, you can easily switch back to the Classic Dashboards through the Dashboard customization settings in the Settings module. See the Dashboard customization settings feature description below for more information.
* '''Dashboard customization settings.''' A new "Dashboards" tab has been added to the Settings module, allowing administrators to customize the default dashboard experience for each dashboard module. Users can select between Classic Dashboards (maintaining the appearance of the Dashboards from version 26.1) or any available BI Report. This means that Bi Reports can be edited or created in the Bi Editor and then selected as a default for the following modules (Click [https://help.fishbowlinventory.com/advanced/s/article/Settings#Dashboard_tab here] to learn more):
** Inventory Dashboard
** Sales Dashboard
** Purchasing Dashboard
** Manufacturing Dashboard
** Production Scheduling Dashboard
** Company Dashboard
* '''Dashboard module rename.''' The existing Dashboard module has been renamed to "User Dashboard" to distinguish it from the new Company Dashboard in the General module group. The User Dashboard can be customized by each individual user and the Company Dashboard is a company wide dashboard.
* '''New Server Administration Module.''' The Server Administration module now includes powerful remote management capabilities previously only available when directly logged on to the Fishbowl Server(Click [https://help.fishbowlinventory.com/advanced/s/article/Server-Administration-Module here] to learn more):
** '''Active Connections management''' - View all connected users with their name, last activity, and client type. Administrators can refresh the user list, log off selected users, and send messages to connected users directly from this module in the client.
** '''Connection settings''' - Configure Client Inactivity Timeout and enforce single-login restrictions (users can only be logged in once).
** '''Server restart capability''' - Restart the Fishbowl Server directly from the Administration module with configurable delay periods to give connected users adequate warning. This feature requires a new "Restart Fishbowl Server" user right (granted to the admin user only by default).
* '''Outsourced Purchase Orders with part tracking.''' Parts with tracking (including Lot Numbers, Expiration Dates, Serial Numbers, and custom tracking types) can now be used on outsourced Purchase Orders. This enables manufacturers who outsource production operations to maintain full traceability throughout their outsourced manufacturing process without being forced to remove tracking from parts.
* '''Automatic backup retention management.''' Scheduled database backup tasks now support automatic deletion of old backup files. Administrators can configure a retention period (in days) to automatically clean up backups older than the specified threshold, preventing disk space issues without manual maintenance. Setting the value to 0 disables automatic deletion. Create a new or edit your existing Database Backup scheduled task to enable this feature. Default setting is set to 0. Click [https://help.fishbowlinventory.com/advanced/s/article/Schedule#Create_a_scheduled_task here] to learn more.
* '''Enhanced Fishbowl Payments (Powered by Run Payments) card entry.''' When connected to a Run Payments card processing terminal, users now have more flexibility for card not present transactions. A new "Manually Entered" option allows credit card information to be entered directly into the client through the Run Payments iFrame for faster processing, while the existing functionality has been renamed to "Manually Entered (Send to Payment Terminal)" for sending payment processing to the card terminal. Card Present remains the default option.
* '''REST API memo endpoints.''' The REST API now supports full memo management for Sales Orders, Parts, and Products with the following new endpoints:
** '''getMemoList''' - Retrieves a list of all memos associated with a specific Sales Order, Part, or Product
** '''getMemo''' - Retrieves details of a single specific memo by its ID
** '''deleteMemo''' - Removes a memo from a Sales Order, Part, or Product
** '''updateMemo''' - Modifies the content of an existing memo
** '''createMemo''' - Adds a new memo to a Sales Order, Part, or Product


'''CSV'''
==Fixes - 26.2==
* Updated Bill of Materials and Bill of Materials Details CSV instruction to remove Work Order as a BOM Item Type
'''Fishbowl Payments (Powered by Run Payments)'''


'''Checkout'''
* Resolved: QuickBooks Online automated sales tax is now properly included in Run Payment Links. Previously, QBO estimated tax amounts appeared correctly on the Sales Order and in the manual payment screen but were not included in the payment link total.
* Resolved: Advanced search default filters not saving


'''Database Rebuild'''
'''REST API'''
* The PARTCOST table is now cleared out on rebuild


'''Inventory'''
* Resolved: REST API performance and efficiency have been significantly improved for customers with large amounts of orders, customers, and parts. These improvements resolve Java heap space errors previously experienced by customers with larger datasets. The following enhancements have been implemented:
* Resolved: Blank WO column storing last WO hyperlink value
** Replaced HttpURLConnection with the new HttpClient
 
** Enabled HTTP/2 support
'''Part'''
** Removed JSON size limit for API requests
* Resolved: UOM conversion error when changing a parts UOM when it has an associated with a bill of materials
** Improved file download memory efficiency
 
** Eliminated unnecessary base64 encoding to decrease request sizes
'''Purchase Order'''
** Avoided double serialization
* Resolved: Alert Notes not being displayed when adding parts via the + button
* Resolved: REST API documentation for search endpoints now correctly indicates that all search filters are optional for Inventory, Location Group, Manufacture Order, Part, Purchase Order, UOM, User, and Vendor.
 
* Resolved: REST API documentation links have been updated from the old wiki URLs to the new help article URLs. All "Related Guide" links now correctly redirect to the appropriate pages on the help site.
'''QuickBooks Online'''
* Resolved: The /api/products/:id/best-price endpoint documentation now correctly indicates that customerid is a required field, and optional parameters (uomId, date, and includePricingRules) are properly marked as optional.
* Resolved: Initial connection null error
'''Database Updates'''
 
*Added "deleteBackupOlderThan" column to the fbschedule table. This new column enables the new automatic deletion of backups feature in the schedule module.
'''REST API'''
{{Released|26.1|01|15|26}}
* Resolved: Create PO call causing an error when a location group is not specified
==Highlights - 26.1==
* <u style="color: red;">'''Important Notice'''</u>: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
* '''<u style="color: red;">Important Notice</u>''': Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.1. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
* <u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.1 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
* '''<u style="color: red;">Important Notice</u>''':  Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.1.
* Enhanced Fishbowl Commerce integration with channel-specific status mapping
* Run Payments ACH-only integration option added
* Quality and reliability improvements across multiple modules


'''Shipping'''
==New Features - 26.1==
* Resolved: Weight showing 0 when the product UOM doesn’t have a conversion set for the default weight UOM
* '''Fishbowl Commerce channel-specific status mapping.''' A custom scheduled script is now available that allows operations managers to override the status import behavior for specific e-commerce channels. This enables different status mappings depending on the channel, preventing the need for additional processing of orders. For example, if more than one channels orders are in shipped status in Fishbowl Commerce and is mapped to come in as issued to Fishbowl Advanced, the script can take one of those channels orders an fulfill them. The script takes two parameters: desired status ID and the channel name and runs via the schedule module to automatically perform the steps necessary for additional order processing. If you want to enable this feature reach out to our Support Department at 800-774-7085 ext 3.
* '''Fishbowl Payments ACH-only support.''' The Fishbowl Payments integration now supports customers who only have an ACH Merchant ID (MID). When the service provider is integrated using only the ACH MID, only ACH payments are processed through Fishbowl Payments and only an ACH option appears on generated payment links.


'''Web Connection'''
==Fixes - 26.1==
* Resolved: Report errors when using the web connection
'''General'''
* Resolved: Xero accounts not being auto selected when they already exist
* Resolved: Users can now properly revoke access to the MyFishbowl Module through user access rights. Previously, all users could view the MyFishbowl Module regardless of access rights settings.
* Resolved: QBO accounts not being auto selected when they already exist
* Resolved: The Part Activity Report tooltip for the Group By option now correctly describes the grouping functionality rather than showing the same tooltip as the Order By option.
* Resolved: Company module displaying blank information
'''Sales'''
* Resolved: Find Fishbowl Servers magnifying glass returning a blank result


'''Work Order'''
* Resolved: We have removed the Module Option for "Fulfill Flat Rate discounts with preceding line items on ship" from the Sales Order Module Options. This option will be included in a future release pending some additional development changes.
* Resolved: Assigned users not saving when being set by right clicking on a Work Order


{{HideReleased|2022.6|06|09|22}}
'''Purchasing and Receiving'''
{{HideH2|Highlights - 2022.6}}
* [[Amazon#Release_Notes|Amazon Plugin customer mapping functionality updated to comply with Amazon's Data Protection Policy]]


{{HideH2|Fixes - 2022.6}}
* Resolved: International customers using currencies with commas as decimal separators and vendor part number associations can now be added to Purchase Orders when multi-currency is enabled. Previously, these parts could not be added to a Purchase Order and the cost could not be changed in the vendor's home currency.
* Resolved: Purchase Order CSV imports now enforce the same cost restrictions as the Fishbowl Client. Credit return type line items with positive costs are imported as negative costs, and purchase type line items with negative costs are imported as positive costs, preventing incorrect accounting exports.


'''Checkout'''
'''Materials'''
* Resolved: Selecting an order tax rate being required for international customers


'''Consignment'''
* Resolved: The "All Locations" option in the Part Module's MRP feature no longer assigns reorder points to inactive location groups. Inactive location groups are now excluded from MRP calculations.
* Resolved: Auto Replenish being unable to finish


'''Database Rebuild Tool'''
'''Calendar'''
* Resolved: Memo's not being cleared out on rebuild
* Resolved: Costing layers not being cleared out on rebuild


'''Picking'''
* Resolved: The Calendar module in international databases now works correctly in all view modes (1 Day, 5 Day, and 7 Day views). Previously, orders would not display in 1 Day and 5 Day views, and selecting 7 Day view would cause an error that prevented other modules from loading requiring a restart of the Fishbowl Client to fix.
* Resolved: UOM conversion issue when voiding the pick for a Work Order
* Resolved: Slot numbering issues when adding additional picks to an existing group pick


'''Purchase Order'''
'''Advanced Search'''
* Resolved: Null error running the Auto PO with an empty summary page
* Resolved: Outsourced Returning As UOM conversion error in receiving


'''Receiving'''
* Resolved: The Advanced Search popup window now properly displays cancel and search buttons at the bottom without requiring window resizing, specifically when many custom fields are present. The dialog now allows scrolling to accommodate a large numbers of custom fields in Part, Product, Customer, and Vendor modules.
* Resolved: Item receiving user rights erroring when receiving tracked items


'''REST API'''
'''Scheduled Tasks'''
* Resolved: Address creation issues when creating Purchase Orders


'''Sales Order'''
* Resolved: Scheduled tasks no longer remain stuck in queue requiring a server restart to run. Thread management issues related to the schedule module have been addressed, and timeouts have been added to Run Payments API requests to prevent tasks from hanging indefinitely.
* Resolved: Incorrect salesman displayed after creating a new user
'''Plugins'''


'''Shipping'''
* The Ebay plugin has been update to be compatible with Java 21 and is not fully functional
* Resolved: Fixed column width not saving after logging out


'''Vendor'''
* Updated the example databases vendor costing rules names to match functionality


'''Work Order'''
{{Released|25.12.1|12|30|25}}
* Resolved: Error when saving a Work Order after removing the class selection
==Highlights - 25.12.1==
* <u style="color: red;">'''Important Notice'''</u>: There is currently a bug with the new "Fulfill flat rate discounts with preceding line items" shipping module option where fulfilled discounts are not being transferred to Accounting. If you have previously updated we recommend disabling this module option in the shipping module to continue to fulfill discounts normally and transfer to accounting. This will be addressed with the January Release.
* <u style="color: red;">'''Important Notice'''</u>: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 to 2025.12 this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
* '''<u style="color: red;">Important Notice</u>''': Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2025.11 and newer. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
* '''<u style="color: red;">Important Notice</u>''': The SPS Commerce integration is now fully compatible with the 2025.12 release. The timestamp formatting issues that affected the 2025.11 release have been resolved.
* <u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2025.12 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade to the 2025.12 (Java 21) release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
* '''<u style="color: red;">Important Notice</u>''':  The Ebay plugin is not currently working with 2025.12 (Java 21) release. If you utilize the Ebay plugin its recommended to wait to update to 2025.12 or migrate to Fishbowl Commerce which does support the Ebay integration.
* '''<u style="color: red;">Important Notice</u>''':  Custom Plugins are not supported in 2025.12 or newer versions. If you utilize any custom Plugins do not upgrade to 2025.12 or newer. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST API or Legacy API will continue to function on 2025.12.
* Java 21 compatibility improvements with critical fixes for payment processing integrations and timestamp handling across multiple modules.
* Enhanced payment processing with improved synchronization for Payment Links and card-present transactions, plus critical Authorize.net integration fixes.
* Quality and reliability improvements across Sales Orders, Purchase Orders, CSV imports, Accounting, and user access rights.


{{HideReleased|2022.5|05|19|22}}
==New Features - 25.12.1==
{{HideH2|Highlights - 2022.5}}
* Fishbowl Payments enhancements. Three new improvements have been added to enhance payment processing:
** Payment Links now automatically update when Sales Order pricing changes, ensuring customers always pay the correct amount without manual intervention by sales representatives.
** Payment Links can now be generated for Sales Orders in Estimate status allowing for receipt of payment before issuing the order to the warehouse
** Card-present transactions now include the Invoice ID (Sales Order number) in the Run payment portal, providing better transaction tracking and reconciliation.
* <u style="color: red;">'''Important Notice'''</u>: The following feature currently has a bug where fulfilled discounts are not being transferred to Accounting. If you update simply disable this module option in the shipping module to continue to fulfill discounts normally and transfer to accounting.
** New Sales Order discount fulfillment option. A new module option has been added to the Shipping module to give users control over flat-rate discount fulfillment behavior. The "Fulfill Flat Rate discounts with preceding line items on ship" checkbox allows flat-rate discounts to fulfill automatically when the line item above them is fulfilled, matching the behavior of percentage discounts and providing more flexibility in order fulfillment workflows.


* [[Getting_Started#1._Install_Fishbowl|Improvements to the client connection]]
==Fixes - 25.12.1==
'''General'''
* Resolved: User access rights now properly restrict editing capabilities for users with View-only permissions. Users with Part-View access rights can no longer modify the Part URL field, and users with Purchase Order-View access rights can no longer add items to Purchase Orders.
'''Sales'''


{{HideH2|Fixes - 2022.5}}
* Resolved: Sales Orders linked to Manufacturing Orders with BOMs set to Short Quantity can now be edited and saved without encountering blank error messages.
* Resolved: Flat-rate discounts can now be configured to fulfill automatically when the preceding line item is fulfilled. A new module option "Fulfill Flat Rate discounts with preceding line items on ship" in the Shipping module allows flat-rate discounts to match the fulfillment behavior of percentage discounts.


'''Database Update'''
'''Accounting and Integrations'''
* Resolved: Update issues related to removing UPS Ready


{{HideReleased|2022.4.1|04|22|22}}
* Resolved: Authorize.net payment integration now functions properly following the Java 21 upgrade.
{{HideH2|Highlights - 2022.4.1}}
* Resolved: QuickBooks Online integration now provides clear error messaging when payment terms contain unsupported characters. When attempting to export orders with payment terms that include ampersands (&) or other special characters, the system now displays: "The Payment Terms used on orders attempting to export to Accounting have unsupported characters. Please update the Payment Terms names in the Payment Term module to remove any invalid character such as "&" or "#""
* Resolved: Xero tax code imports no longer fail due to typeCode length limitations. The typeCode field has been expanded from 25 to 50 characters to accommodate longer values generated by Xero's Auto Tax feature powered by Avalara.


* Updated Fishbowl to account for a Java remote code execution vulnerability
'''CSV Imports and Exports'''


{{HideH2|Fixes - 2022.4.1}}
* Resolved: CSV imports with date columns containing timestamps now process successfully. Date formats that include time values (e.g., "05/21/2024 12:00:00AM") are once again accepted, restoring compatibility with SPS Commerce and other systems that export dates with timestamps.
* Resolved: Customer CSV imports now properly handle the TaxExempt field when set to FALSE. Importing a customer with TaxExempt set to FALSE now clears the TaxExemptNumber from the database, matching the behavior of the Fishbowl Client user interface and preventing confusion when re-exporting customer data.


'''Fishbowl GO'''
'''Fishbowl Payments'''
* Resolved: Unable to Pack a shipment


'''Picking'''
* Resolved: Payments made using Payment Links now sync properly back to Sales Orders in Fishbowl, ensuring accurate payment tracking and reconciliation.
* Resolved: Unable to void picks that were finished prior to the update to 2022.4
* Resolved: Payment Links no longer create duplicate payment records when syncing back to Fishbowl. The payment import process now properly validates TransactionIDs to prevent duplicate entries and ensures that declined transactions are not imported.
* Resolved: Card-present transactions processed through Run now include the Invoice ID (Sales Order number) in the transaction details, improving traceability in the Run payment portal.


'''Database Changes'''
'''Reports'''
* Removed DCOPTIONS table
* Removed PACKAGETYPES table
* Removed PACKAGETYPEID column from SHIPCARTON table
* Removed DELIVERYCONFIRMATIONID column from SHIPCARTON table


{{HideReleased|2022.4|04|14|22}}
* Resolved: The Customer Purchase History report now correctly displays discount items. The "discount items" option in the report properly shows both dollar and percentage discounts applied to sales orders.
{{HideH2|Highlights - 2022.4}}
{{Released|25.11|11|14|25}}
==Highlights - 25.11==
*'''<u style="color: red;">Important Notice</u>''': The Fishbowl 2025.11 update will require plugins to be updated on the Fishbowl Server. Please see the [https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-Java-21-Update update guide] for more information.
*'''<u style="color: red;">Important Notice</u>''': Fishbowl 2025.11 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2025.11 and newer. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
*<u style="color: red;">'''Important Notice'''</u>: We are unable to support the Fishbowl Anywhere plugin as part of the 2025.11 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade to the 2025.11 (Java 21) release. We hope to have this included as part of the 2025.12 release but will provide additional information once available.
*'''<u style="color: red;">Important Notice</u>''': Custom Plugins are no longer supported with the release of 2025.11. If you utilize any custom Plugins do not upgrade to 2025.11 or newer. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST API or Legacy API will still continue to function on 2025.11.
*<u style="color: red;">'''Important Notice'''</u>: This upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button.
*<u style="color: red;">'''Important Notice'''</u>: The SPS Commerce integration is not compatible with the 2025.11 (Java 21) release due to timestamp formatting changes. If you are actively using the SPS Commerce integration, you should not upgrade to 2025.11. A fix for the SPS Commerce integration will be included in the 2025.12 release.
*<u style="color: red;">'''Important Notice'''</u>: The Ebay plugin is not currently working with 2025.11 (Java 21) release. If you utilize the Ebay plugin its recommended to wait to update to 2025.11 or migrate to Fishbowl Commerce which does support the Ebay integration.
*Java 21 upgrade with improved performance, security, and compatibility. See our Java 21 update guide: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-Java-21-Update
*Improved client update experience for Java 21 upgrade
*Quality and reliability improvements across multiple modules
*Improved demo database functionality for international regions


* [[User#MODULE_OPTIONS|Added Password Policy options that allow for more secure user passwords]]
==New Features - 25.11==
* [[Shipping_Integration|The UPS Ready integration has been completely removed]]
*'''Java 21 upgrade.''' Fishbowl Advanced 2025.11 includes a major upgrade to Java 21, bringing significant improvements to the platform:
**Enhanced performance for faster application responsiveness
**Improved security to protect your data
**Better compatibility with modern operating systems and hardware
*'''Fishbowl Payments enhancements.''' Two new features have been added to the Fishbowl Payments module to give users more control over payment processing:
**A "Run Import Task" button has been added to the settings tab, allowing administrators to manually sync payments on demand. When clicked, the payment import task is queued to run immediately, enabling faster shipment processing.
**Payment download scheduling now offers finer grain control with hourly sync options. Users can specify the number of hours between syncs (e.g., 1 for every hour or 6 for every six hours) to match their business needs.
*'''Customer module options for Customer Module.''' New module options have been added to the Customer Module to control the "To be printed" and "To be emailed" checkboxes for customers created through clicking on the New button, Plugins, or CSV imports. When enabled, these options set the default behavior for new customer creation, providing better control over customer communication preferences across different import methods.
*'''QuickBooks Desktop Nexus auto-close.''' The Nexus connector now automatically closes 10 minutes after connection timeout to prevent issues that occur when Nexus loses connection with QuickBooks Desktop after being left open for extended periods. This configuration can be overridden in the nexus.config settings file if needed.
*'''Receiving Data .CSV Import.''' The receivingdata.csv import now fulfills items that were previously received in the client. Previously you either had to receive or fulfill items but could not receive first and then later use the import to fulfill already received parts.


{{HideH2|New Features - 2022.4}}
==Fixes - 25.11==
'''General'''


* [[Start_Fishbowl#Creating_a_new_database|Database password is now blank when creating a new database on a Mac or Linux server install]]
*Resolved: The Available to Build report has been updated with an improved version that significantly increases performance. Customers previously experiencing slow load times or reports that failed to run will now see excellent performance with this updated report.
* [[Fishbowl_GO#Approve_app|Fishbowl GO iOS is now auto-approved in the demo database]]
*Resolved: Converting character sets before database updates now properly handles compound keys during MySQL 5.7 to 8.0 database upgrades. Previously, collation errors could occur when updating views if bad values were part of compound keys.
* [[{{REST API}}|Added the ability to do an inventory move through the REST API]]
*Resolved: Converting character sets before database updates no longer causes collation errors when updating custom views during the migration from MySQL 5.7 to MySQL 8.0.
* [[{{REST API}}|Added the ability to cycle count inventory through the REST API]]
*Resolved: Demo databases now have properly configured dates for existing orders. The Canadian demo database dates have been updated to align with current dates rather than being set far in the past.
* [[Carrier#Add_a_new_carrier|Updated UPS Carrier Codes to be editable after UPS Ready removal]]
*Resolved: The Australian demo database's Auto SO Number system property is now properly initialized to prevent "This order number is already in use" errors when creating new sales orders.
*Resolved: The default location group for the Australian demo database has been changed to Adelaide for the admin user. This prevents getting a message stating that inventory is not available when adding Products to Sales Orders.
*Resolved: Multi-currency columns on the receiptItem table are now properly populated in demo databases, allowing pre-populated receipts to be successfully reconciled without errors.
* Resolved: The Advanced Mobile plugin's "How To" button now correctly redirects to the proper help article URL.
*Resolved: Demo databases no longer contain inventory log entries with future event dates, which previously prevented certain received parts from being voided.
*Resolved: The duplicate serial number error message now displays correctly when attempting to add inventory with a duplicate serial number into the same location and location group.


{{HideH2|Fixes - 2022.4}}
'''Sales'''


'''API'''
*Resolved: Variable kit items can no longer be added to Sales Orders with all items at zero quantity. If all kit items are set to zero quantity at the end of the kit wizard, an error message now displays: "Invalid Qty: Kit must have at least one item in the kit."
* Updated password hash change on Java and C# code samples
*Resolved: Editing or adding a memo to an expired Sales Order no longer automatically resets the Date Expires field and Status. Users are now prompted with the option to reopen the Sales Order when saving changes. If they choose not to reopen, the order remains in Expired status.
*Resolved: Multi-Currency Total tax was not rounding properly in some cases causing discrepancies between the Sales Order Module and Sales Order and Invoice Report.


'''Bill of Materials'''
'''Purchasing and Receiving'''  
* Resolved: Module options are available to all regardless of user right settings


'''Clover Connect'''
*Resolved: The Unit Cost displayed in the Receiving screen now correctly shows the PO line cost when Vendor Cost Rules exist with UOM conversion, rather than incorrectly displaying the Vendor Cost Rule value.
* Resolved: Wallets disappearing on update
*Resolved: The Receiving module's Reconcile Order wizard now properly handles Transfer Orders when the "Require bill date for reconcile" module option is enabled. Since Transfer Orders do not require bill dates, the wizard no longer errors when this option is turned on.
* Additional name updates for Clover Connect rebrand
*Resolved: The Date Entry Tolerance warning no longer incorrectly appears when navigating between tabs on fulfilled Purchase Orders with dates outside the tolerance range. Additionally, clicking the calendar button after dismissing the warning now properly opens the calendar picker.


'''CSV'''
'''Accounting and Integrations'''
* Resolved: Import errors on Part Product and Vendor Pricing import when tracking columns are missing
* Resolved: "Column 'consumptionRate' cannot be null" error when importing the Part CSV


'''License'''
*Resolved: QuickBooks Online integration now properly handles home currency validation in multi-currency databases. The integration has been updated to accommodate QuickBooks Online's change in how they provide currency information through their API.
* Removed "ExpressTech" from license agreements
*Resolved: Reconciling Purchase Orders using the "Quantity" setting to distribute landed costs now properly rounds values, preventing "Please balance your debits and credits" export errors caused by penny-rounding discrepancies.
*Resolved: The "Amounts Include Tax" checkbox in the Purchase Order module has been adjusted to match the Sales Order module and is now limited to the checkbox size, preventing accidental toggling when clicking nearby areas.
*Resolved: Avalara tax estimates now remain available when taking payment throughout the entire order process, including after items have been picked on the Sales Order.


'''Mac Version'''
'''CSV Imports and Exports'''
* Resolved: MySQL port defaulting to 3306 when creating a new database


'''Database Changes'''
*Resolved: Data module CSV exports now include quotes around data values, making them consistent with scheduled task exports and compatible with systems like Salesforce that require quoted values for imports.
* Removed SHIPUPSCARTONDETAILS table
*Resolved: Product CSV imports no longer require a default carton type when only a carton count is specified, matching the behavior of the Fishbowl Client User Interface where carton counts can be added without carton types.
* Removed SHIPUPSCARTONDETAILS_AUD table
*Resolved: Sales Order Details CSV imports in international (non-US) databases now properly ignore the order tax rate when left blank and only import line item tax codes, matching the behavior of the standard Sales Order .csv import.
* Removed SHIPUPSDETAILS table
*Resolved: The Part-Product-Vendor-Purchase export (PPVP) when filtered by vendor now completes in a reasonable time even in databases with 600,000+ parts, improving from over an hour to approximately 2 minutes.
* Removed SHIPUPSDETAILS_AUD table
'''Fishbowl Payments'''
* Removed UPSACCOUNT table
*Resolved: Payments made using Payment Links were not properly syncing back to the Sales Order in Fishbowl
* Removed UPSACCOUNT_AUD table
* Removed UPSCOD table
* Removed UPSPAYMENTTYPE table
* Removed UPSRETURNSHIPMENT table
* Removed UPSRETURNSHIPMENT_AUD table
* Removed column UPS from the COUNTRYCONST table


{{HideReleased|2022.3|03|10|22}}
'''Reports'''
{{HideH2|Highlights - 2022.3}}


* [[Fishbowl_Server_Administration#Rebuild_Database|Added the ability to rebuild a database]]
*Resolved: The Available to Build report has been updated with improved performance and can now handle databases with large amounts of staged BOMs. Customers who previously experienced timeouts or were unable to run the report will now see significantly faster results.
*Resolved: The Sales Order Report now correctly displays the appropriate currency symbol (e.g., pounds in UK databases) for line item Total Price fields rather than always showing the dollar symbol.


{{HideH2|New Features - 2022.3}}
{{Released|25.9|09|16|25}}
* [[{{REST API}}|Added the ability to run a data query through the REST API]]
==Highlights - 25.9==
* [[Payment_Gateway#Clover_Connect|Updated CardConnect branding to Clover Connect]]
*Run Payment integration now supports payment links
* [[{{REST API}}|Updated documentation for the REST Import call]]
*Improved client update experience for upcoming Java 21 update in November
*Quality and reliability improvements


{{HideH2|Fixes - 2022.3}}
==New Features - 25.9==
*The Run Payments integration now supports payment links. When integrated with run payments, users can now easily create and send payment links to customers allowing them to easily pay any invoices.
*Card present (EMV) transactions with supported Run Payments hardware now supports saving Card on File for future payments.
*Starting with 25.9, the Java update process has been simplified in preparation for the November release of Java 21.
**The Fishbowl Client will check if its Java version matches the Fishbowl Server. If a mismatch is detected, users can simply click on the button "Automatically update your Fishbowl Client" which will automatically install the update with the correct Java version.
**The Fishbowl Server will check during update if a Java update is required and notify the user. Users will be presented with a button to "Download Fishbowl" which will download the appropriate Fishbowl version to the downloads folder. Simply run this install over the top of the existing installation to get the latest version of both Fishbowl Server and Java.
*An option to "Convert Character Sets" has been added to the Database Administration Pages, right click, options menu. This new option can help in cases where data migration issues can occur when migrating from MySQL 5.7 to MySQL 8.0. Simply right click the database that you want to apply the fix to and click "Convert Character Sets." If any data changes occur they will be output to a file for review.


'''API'''
==Fixes - 25.9==
* Updated the REST documentation for logging out
'''General'''
*Resolved: The Database Migration tool, used to updated from MySQL 5.7 to MySQL 8.0, was erroring out due to additional constraints in MySQL 8.0. The Database Migration Tool now automatically checks for this condition, applies a fix, and outputs a file with any data changes that may have been necessary for successful migration.
* Resolved: The Vendor Parts CSV import was not requiring a vendor part number. This caused issues with Purchase Orders where the Module Option "Only show vendor parts in drop-down filter" was selected causing no parts to show up in drop-down.
*Resolved: Several How To links were not directed to the right How To pages and have now been updated.
'''Sales'''
*Resolved: In some circumstances customer numbers were creating constraint errors because the auto increment number was set above the auto increment number limit.
*Resolved: Multi-Selecting and then starting picks was not correctly setting the "To be printed" checkbox on picks.
'''Integrations'''
*Resolved: Clicking the button to integrate with Run Payments, while currently integrated with a different service provider, was not automatically removing the existing payment integration as expected.
* Resolved: The feature for Amount Includes Tax was not properly calculating tax when the item edit menu was opened and modified on the Sales Order.
{{Released|25.8|08|27|25}}
==Highlights - 25.8==
*Run Payments is now integrated into Fishbowl Advanced enabling card not present, card present, ACH transactions.
*Stability improvements for the Mac version of Fishbowl Advanced


'''Client'''
==New Features - 25.8==
* Resolved: Client auto update not including all required files
* Run Payments is now part of the Fishbowl Payments module. This new integration enables:  
**Card not present transactions
**Card present (EMV) transactions with supported Run Payments hardware. This feature supports swipe, chip, and tap to pay type payment methods. Note that Card on File is not supported for this method at this time.
**Automated Clearing House (ACH) transactions enabling bank or credit union transfers
**Refunds
**Card on File or stored payments for repeat transactions
**More to come (including the Payment Links feature) with our upcoming September release
*The Fishbowl installer now supports command line installation which removes the need for user input when installing Fishbowl


'''Server'''
==Fixes - 25.8==
* Optimized server startup when connection to Fishbowl's online services are interrupted
'''General'''


*Resolved: Display issues with where drop down boxes and error messages were appearing behind the main screen now appear in their proper order. This mainly affected Mac users of the software.
*Resolved: The Mac installer now properly distributes the Java Runtime Environment (JRE) for Fishbowl instead of requiring its own separate standalone installation.
*Resolved: Fishbowl's embedded web browser (JxBrowser) has been updated to 7.43.7. This update provides multiple security improvements and ensures the continued stable operation of this feature.
*Resolved: Importing multiple CSV files concurrently would occasionally cause price discrepancies on Sales Orders. This issue primarily affected the integration with Fishbowl Commerce and its parallel import feature.
*Resolved: The Bill of Materials CSV import allowed negative quantities on raw goods which prevented the fulfillment of associated Sales Orders and displaying a error message that the quantity cannot be negative.


'''Database Changes'''
'''Sales'''  
* Removed the READONLY column from the BISCRIPT table
* Updated OUTSOURCEDPARTNUMBER and OUTSOURCEDPARTDESCRIPTION on the POITEM table to be empty strings instead of null


{{HideReleased|2022.2.1|02|15|22}}
*Resolved: Sales Orders with Similar number such as FB-123 and FB_123 would cause a Duplicate Ship error when finishing the pick of the second order.
{{HideH2|Fixes - 2022.2}}


* Resolved: Client Auto Update running for plugins causing the client to become inoperable
'''Reports'''
*Resolved: The Turnover Report was displaying odd characters in some circumstances based on the result of a calculation on the report.
* Resolved: The Work Order Flag Report was not displaying all work orders when utilizing a combination of available, receivable, or pickable settings for locations.
'''Accounting'''


{{HideReleased|2022.2|02|10|22}}
*Resolved: The How To buttons link in the Accounting module was not linking to the correct help page on the Fishbowl website.
{{HideH2|Highlights - 2022.2}}


* [[{{REST API}}|Added a REST API call for Imports]]
'''Integrations'''


{{HideH2|New Features - 2022.2}}
* Resolved: The Payment Gateway module has been renamed to the Fishbowl Payments module.
* Resolved: The Gateway tab of the Fishbowl Payments module has been renamed to be the Service Providers tab.
* Resolved: The parallel import feature of the Fishbowl Commerce plugin would duplicate customers in some instances.
*Resolved: Removing Clover Connect from the Fishbowl Payments module was not properly handing removal of payment device settings complicating integration with a different Service Providers hardware.


* [[User_Group#Report_Rights_tab|The report rights assigned to the default user groups on new databases have been updated]]
{{Released|25.7|07|16|25}}
* [[{{REST API}}|The REST API documentation page now shows the Fishbowl server version in the header]]
==Highlights - 25.7==
* [[Install_Fishbowl#Install_Fishbowl|The User License Agreement has been updated in the Fishbowl Installer]]
*New workflow optimization for printing Picks
*Compatibility improvements for Hot Keys on all operating systems.


{{HideH2|Fixes - 2022.2}}
==New Features - 25.7 ==


'''Accounting Exports'''
*A new To Be Printed checkbox and advanced‑search filter help to identify pick tickets that still require printing, preventing duplicate printouts.
* Resolved: "The total debits must equal total credits" export error due to rounding differences (AU)
**Starting a pick and printing it will automatically remove the to be printed checkbox.
**Utilize the the Advanced Search feature in picking to see a list of picks that still need to be printed.
*Fishbowl Hot Key changes. Previous hot key combinations (Command + Q) caused the Fishbowl application to quick. Hot keys have now been made more universal for all operating systems.
**Sales Orders Quick Fulfill command has been changed from Ctrl + Q and Cmd + Q to Ctrl + F and Cmd+F
**Transfer Orders UnRequest command has been changed from Ctrl + Q and Cmd + Q to Ctr + R and Cmd + R
**Checkouts Checkout command has been changed from Ctrl + Q and Cmd + Q to Ctr+F and Cmd+F  


'''CSV'''
== Fixes - 25.7==
* Resolved: Sales Order Details CSV failing due to no data being provided to a required custom field with the "Create an access right to restrict the modification of this field" custom field option enabled
'''Accounting and Integrations'''
* Resolved: Sales Order CSV failing due to no data being provided to a required custom field with the "Create an access right to restrict the modification of this field" custom field option enabled


'''Part'''
* Resolved: Associated price type line items were not exporting to QuickBooks Online and Xero.
* Resolved: Cost discrepancy caused by voiding a shipment and reconciling a purchase order
*Resolved: Re‑connecting Xero no longer clears custom account mappings; the Account Mapping report opens without errors.
*Resolved: Debits and Credits for Work Orders were not posting properly when using Standard Costing as a costing method.


'''Picking'''
'''Sales and Customers'''
* Resolved: Order Link Section sizing to small and cutting off text
* Resolved: Unit of Measure conversions causing quantity discrepancies when picking from multiple locations


'''QBO'''
* Resolved: In one scenario users could change a customer’s currency even when historical orders existed.
* Resolved: Export errors due to duplicate tax rates (Canada)


'''Sales Order'''
'''Purchasing and Receiving'''
* Resolved: Amounts not be classified as negative when currency uses a trailing negative sign


'''Xero'''
*Resolved: The Receiving screen was not refreshing unit cost, subtotal and billed‑total immediately after a saving a Purchase Order edit.
* Resolved: Vendor street address pulling the company address instead of the vendors address
*Resolved: In one case Purchase Order was selecting the first line instead of the desired line when clicking on a line item.
*Resolved: Transfer Orders containing a backslash (“\”) were erroring out on the Receiving screen.
*Resolved: Reconciliation was giving an error when affecting Work Order adjustments for work orders that utilized non-inventory type finished goods.


{{HideReleased|2022.1|01|13|22}}
'''Manufacturing'''
{{HideH2|Highlights - 2022.1}}


* [[Support|Updated Log4j to the latest version]]
*Resolved: Deleting a line item on a Sales Order would sometime leave an associated Manufacture Order open in the wrong status.
* [[Receiving#Module_Options_Reconcile_tab|Added module options in the Receiving module to require the Ref # and Bill Date fields during the reconcile wizard]]
*Resolved''':''' Required custom fields on Work Orders are now enforced on any Manufacturing Orders created from them.
* [[Inventory#Search|Added the ability to save the Advanced Search in the Inventory module]]
*Resolved: Manufacturing Orders auto‑created from Sales Orders were not populating checkbox type custom fields appropriately. This negatively affected utilizing the Advanced Search Function in the Manufacture Order Module.
* [[Payment_Gateway#Clover Connect|The CardConnect payment gateway has been updated to save cards to the Wallet when processed through a terminal device]]
* [[Payment_Gateway#Clover Connect|The CardConnect payment gateway has been updated to use new mandated classification fields on transactions sent to CardConnect]]


{{HideH2|New Features - 2022.1}}
'''Reports'''
*Resolved: The Available to Build report was not properly calculating when the selected Bill Of Material included stages.
'''Database Updates'''
*Added a "toBePrinted" column to the pick table to better enable Pick Ticket printing
{{Released|25.6|06|17|25}}
==Highlights - 25.6==
*New Packing Slip Report options
*Enhanced Tab navigation feature


* [[Part#MRP_wizard|A column displaying the part UOM was added to the Summary step of the MRP wizard]]
==New Features - 25.6==
* [[Payment_Gateway#Square|The Square Payment Gateway has been updated to exclude inactive locations in the Location selection list]]
*Open module tabs can now be rearranged by simply clicking and dragging the module tab to the location desired helping to organize your workflow.
* [https://www.fishbowlinventory.com/support/updates/download Removed the 32-bit version of the Fishbowl Installer]
*A signature collected at the time of delivery can now be saved for external documentation purposes even after the order has been shipped.
* [[{{REST API}}|Added the ability to scrap inventory through the REST API]]
*Editing Transfer Order line items can now be done in-line on transfer orders reducing clicks needed to make simple edits.
* [[Fishbowl_Legacy_API#Save_Image_Request|Updated the SaveImageRq API call to accept images for Sales Orders]]
*New Packing Slip report options have been added giving a wider selection of Packing Slips to choose from with enhanced layouts and colorized options.
* [[Fishbowl_Legacy_API#Save_Image_Request|Updated the SaveImageRq API call to accept images for Work Orders]]
** Packing Slip Colorized V1 Report: Light Blue color scheme
** Packing Slip Colorized V2 Report: Green color scheme
** Packing Slip Colorized V3 Report: Dark Blue color scheme
**Packing Slip Landscape Report
** Packing Slip Landscape Colorized Report: Light Blue color scheme


{{HideH2|Fixes - 2022.1}}
==Fixes - 25.6 ==
'''General'''


'''CSV'''
*Updated JxBrowser to version 7.43.0
* Resolved: Incorrect column header in the Customer Parts CSV. (Previously listed as "CustomerLastPartPrice")
*Resolved: In some cases special characters were corrupted when restoring a database backup.
*Resolved: Updating a Fishbowl Client while still logged in would not properly logout the user.
* Resolved: The Product CSV import was not properly capturing date created not captured when creating new products.


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


'''Email Settings'''
*Resolved: Transfer Order Memos could not be created or updated after a Transfer Order was fulfilled.
* Resolved: Using "Sign in with Google" while also having data in the Username and Password fields causes emails to fail to send


'''Sales Order'''
'''Sales Order'''
* Resolved: Right-click and Issue ignored the "Issue Sales Orders" module option when manager approval would be needed
{{HideReleased|2021.12|12|09|21}}
{{HideH2|Highlights - 2021.12}}
* [[Sales_Order#Search|Custom fields can now be viewed in the Sales Order line item table as additional columns]]
* [[Purchase_Order#Search|Custom fields can now be viewed in the Purchase Order line item table as additional columns]]
* [[User#Change_a_user_password|Updated encryption of passwords]]
{{HideH2|New Features - 2021.12}}
* [[{{REST API}}|Added the ability to Add Inventory with Tracking through the REST API]]
* [[{{REST API}}|Added the ability to Add Inventory with Serial Numbers through the REST API]]
* [[{{REST API}}|Updated third party dependencies]]
* [[{{REST API}}|Improved REST API documentation]]
{{HideH2|Fixes - 2021.12}}
'''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
{{HideReleased|2021.11|11|11|21}}
{{HideH2|Highlights - 2021.11}}
* [[Part#Search|The Part Search has been updated to include inventory numbers and images]]
* [[Amazon#Release_Notes|Added the ability for the Amazon plugin to purge Personal Identifiable Information (PII) data from Fishbowl]]
{{HideH2|New Features - 2021.11}}
* [[Inventory#Search|Added the UOM column to the Inventory Search table]]
* [[{{REST API}}|Added the ability to update a Manufacture Order through the REST API]]
* [[{{REST API}}|Added the ability to search Inventory through the REST API]]
* [[{{REST API}}|Added Category to the Manufacture Order REST API object]]
* [[{{REST API}}|Added the ability to add inventory via the REST API]]
* [[{{REST API}}|Added the ability to get pricing rule pricing through the REST API]]
* [[Plugin|JXBrowser has been updated to the latest version]]
* [[QuickBooks#Required_QuickBooks_Accounts|The QuickBooks Desktop integration has been updated to create the Cost Variance Account as a COGS type account]]
{{HideH2|Fixes - 2021.11}}
'''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'''
*Resolved: When utilizing the "Amount includes tax feature" total prices were not rounding appropriately.
* Improved error messaging for errors dealing with Closing Dates
* Resolved: An issue where the checkbox for the feature "Amounts Include Tax'" extended beyond the checkbox resulting in some accidental selections.
 
*Resolved: The duplicate function on Sales Orders was keeping the original "Created by user" instead of the user duplicating the order.
'''Sales Order'''
*Resolved: Shipping - Qty on the line in shipping changes after order has shipped, edit to address causes it to update.
* Resolved: Sales Order item details dialog loading slowly


'''Shipping'''
'''Shipping'''
* Resolved: Slowness shipping large quantities of kits


'''Time'''
* Resolved: Serial number duplication on a tracking table was preventing some Sales Orders from being shipped out resulting in an error stating"Invalid number of serial numbers: Found: X Expected: X"
* The plugin has been updated to update time/wo/part records to the new plugin format


'''Xero'''
'''Purchasing'''
* Resolved: Receiving holding account not reversing when order is fulfilled


'''Database Changes'''
*Resolved: The reconcile wizard was rounding costs with more than two decimal places to $.01 causing the vendor last for that part to update with the rounded cost. This would cause the next Purchase Order places for that item to be inflated.
* Removed SOITEMTOMOITEM table
*Resolved: The Auto PO function was not properly capturing demand for all location groups when using the No ROP/OUL checkbox and setting Reorder Points to be by location.
* Resolved: Fishbowl Payments was requiring a bill to address for all payments regardless of settings.


{{HideReleased|2021.10|10|14|21}}
'''Reports'''
{{HideH2|Highlights - 2021.10}}


* [[Part#Inventory_tab|Added a Consumption Rate to the Part module to be used in Reorder Point calculations]]
*Resolved: The Packing Slip Report was not properly applying all parameters selected in the Customize Report options.
* [[Part#MRP_wizard|Updated the Auto ROP wizard to be named MRP]]
* [[Part#MRP_wizard|Added Days of Stock to Part Inventory details to show an estimates days of stock based on the Parts Consumption Rate]]
* [[Part#MRP_wizard|The Select Parts step of the MRP wizard has been updated to only show Inventory type parts]]
* [[Part#MRP_wizard|The Date Range step of the MRP wizard now has an option to use the Parts Consumption Rate stored in the Part module]]
* [[Part#MRP_wizard|The Date Range step of the MRP wizard now has options to select which Consumption to include when calculating a Parts Consumption Rate]]
* [[Part#MRP_wizard|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]]
* [[Part#MRP_wizard|The Reorder Point step of the MRP wizard has been updated to pull the Default Vendors Lead Time for the ROP calculation]]
* [[Part#MRP_wizard|The Order Up to Level step of the MRP wizard has been updated to the new MRP terminology]]
* [[Part#MRP_wizard|The Summary step of the MRP wizard has been updated with additional columns, sorting, and inline editing]]
* [[Part#MRP_wizard|The Summary step of the MRP wizard has the option to update the Part's Consumption Rate upon finishing the wizard]]


{{HideH2|New Features - 2021.10}}
'''Database Updates'''
*New Table Added "Accounting Export Log" which records any export activity and outputs the result. Is useful in understanding if the accounting integration returned an error, if repost, or a mark as posted was attempted.
* New Table Added "Accounting Export Type" utilized in conjunction with the Accounting Export Log table to specify Standard Export, Repost, or Mark as posted.


* [[Access_Rights#Sales_Order|Added an access right for duplicating Sales Orders]]
{{Released|25.5|05|20|25}}
* [[Access_Rights#Purchase_Order|Added an access right for duplicating Purchase Orders]]
==Highlights - 25.5==
* [[Currency|Added Barbados to the Currency list]]
*Continued focus and prioritization addressing key issues that highly impact users
* [[{{REST API}}|Added the ability to update a Manufacture Order through the REST API]]
*Server and Client Time Zone Synchronization


{{HideH2|Fixes - 2021.10}}
==New Features - 25.5 ==
* Server Time Zone can now be synced with the Fishbowl client to aid in date accuracy and advanced search utilization
* New REST API Endpoints for Sales Orders
**Search, Issue, Unissue, Cancel, Close Short, Close Short Line Items
*Purchase Order line items can now be split to facilitate efficiency while creating bulk orders.
*Multi-Factor Authentication (MFA)
**General login workflow has been enhanced with a "Trusted Devices" option on the login screen. Checking this reduces the amount of times needed to obtain a code when using trusted devices.
** Administration level control has been added to allow the admin user to reset MFA when necessary
*The QuickBooks Online API has been updated to the latest version ensuring continued operation and allowing further updates to the QuickBooks Online integration.
* The Packing Slip has be enhanced
**Now optimized to run more efficiently
**Added ability to "Show Kit Headers Only" simplifying the display of kits down to just the essential information
*New Reports have been added to Fishbowl to improve usability
**Sales Order Report with Special Characters. A new version of the Sales Order Report now shows special characters, such as non-english languages
**Shipping Invoice Report with Special Characters. A new version of the Shipping Invoice Report now shows special characters, such as non-english languages
**Pick Report with Special Characters. A new version of the Pick Report now shows special characters, such as non-english languages
**Part Barcodes by Location Avery. The report prints part a single barcode for every part within a selected location. This simplifies the initial generation of barcodes for warehouses that have never used barcodes before.


'''Checkout'''
==Fixes - 25.5 ==
* Resolved: Company image not displaying on Checkout secondary monitor screen
'''General'''
*Resolved: Computers set to utilize a language other than english could not issue orders
'''Materials'''
*Resolved: Average cost used for scrap adjustment amount after reconciling cost on FIFO databases in some scenarios
'''Sales Order'''


'''CSV'''
*Resolved: Sales Order over picking was not utilizing UOM conversions when the Part's option to "Pick in part UOM only" was checked
* Updated the Product Import instructions to match terminology used in the client
* Resolved: Sales Order.csv import when utilizing multi currency assigning wrong currency for tax type items


'''Customer'''
'''Reports'''
* Resolved: Being able to update the currency rate for customers set to Home Currency through the module and CSV import


'''Part'''
*COGS By Account Summary was only showing "Use Default" instead of the actual default account name.
* Resolved: The Default Returning As part is incorrectly set after duplicating a part
*Dormant Customers was not properly displaying custom fields when the option was selected
 
*2x4 Part Barcodes was displaying an option to show price
'''QuickBooks Desktop'''
*4x6 Part Barcodes was displaying an option to show price
* Resolved: No Certificate being displayed when integrating
*Bill of Lading was not properly applying unit of measure conversions when calculating weight
 
*Work Order Forecast Report was utilizing the wrong date field causing wrong calculations in certain circumstances
'''REST API'''
*Part Committed Report was not showing the correct unit of measure for credit return type Purchase Order items.
* Resolved: REST API does not use  the server option to only allow a user to be logged in once
*Production Demand Report was showing inconsistent data causing certain work orders to be missing from the report
* Resolved: SSL Context error with Jetty Server on startup
*Outstanding Work Order Report date range was not properly formatted when selecting "All" for the date range
 
*Part Allocated Report was not showing in transit location inventory properly
'''Settings'''
*Batch Packing Slip by Date was showing null where length, width, and height header should be
* Updated the Max Thumbnail Size to not allow a number below 16
*Shipping Invoice Report was showing null where length, width, and height header should be
 
*Work Order Traveler Report was not removing columns from raw goods area when they were unchecked from the columns tab.
'''Server'''
*Work Order Summary Report showed issued as a selectable status even though that status does not exist for work orders
* Improved calculation rounding precision in situations dealing with money
*Item History Report is not showing totals on the first page when the report spans multiple pages
 
*Sales Dashboard's Ordered Products field was including voided, canceled, and closed short items from a Sales Order
'''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'''
'''Xero'''
* Issue: Balance Debits and Credits error displaying only the PO Ref #
*Resolved: Items with tracking that were picked and packed separately were causing the export error "Line total does not match" in some cases
:* Resolution: The PO # is now displayed in the error as well as the PO Ref #
*Resolved: Discount items were being sent to the wrong accounts in Xero.


'''Database Updates'''
{{Released|25.4|04|16|25}}
* Added CONSUMPTIONRATE column to the PART table
==Highlights - 25.4==
*Continued focus and prioritization addressing key issues that highly impact users
*Enhanced Standard Reports
*New Sales Order Feature allows over picking on Sales Orders
*New REST API endpoint


{{HideReleased|2021.9|09|09|21}}
==New Features - 25.4==
{{HideH2|Highlights - 2021.9}}
'''Enhanced Reports'''
*Packing Slip
**Dimensions have been added for each carton including Length, Width, High
* Receiving List
**Added shipment tracking number to help when receiving blanket Purchase Orders
**Added Vendor Name to report details
*Manufacture Order and Work Order Traveler reports
**Page numbers are now sequential when printing multiple Work Orders for the same Manufacture Order
*Adjustment Report
**A new checkbox has been added to the modify report options to "Show Posted" transactions
** Updated the date parameter to increase report data accuracy
*Work Order Flag
**Added part description to shortage summary section of the report
**Added page numbers to the shortage summary section of the report
'''Sales'''


* [[Payment_Gateway#Square|The Square Payment Gateway was been updated to the latest API/SDK]]
*Over Picking on Sales Orders is now possible. This feature will allow you to pick more than was on the original Sales Order and once picked will update the Sales Order with the new quantity.
* The Customer alert notes field has been expanded from 256 character limit to 1,024 allowing more space to store critical notes, comments, or warnings for Sales and Warehouse teams.


{{HideH2|New Features - 2021.9}}
'''REST API'''


* [[Fishbowl_Legacy_API#Legacy_Requests|Updated the PartGetRq to select active parts first when searching based on UPC]]
*A new endpoint has been added, Get SO by ID, which allows you to retrieve Sales Order information utilizing the Sales Order ID
* [[Currency|Added Suriname to the Currency country list]]
 
{{HideH2|Fixes - 2021.9}}
 
'''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
 
{{HideReleased|2021.8|08|12|21}}
 
{{HideH2|Highlights - 2021.8}}
* [[Transfer_Order#1._Create_a_transfer_order|The line item Scheduled Date on Transfer Orders has been opened up to allow editing until item is received]]
* [[Inventory#View_quantity_details|The Order Location Group has been added to the Next Orders section of the Inventory Details screen]]
 
{{HideH2|Fixes - 2021.8}}
 
'''Accounting Intergrations'''
* Resolved: "Please Balance your debits and credits" export error


==Fixes - 25.4==
'''General'''
*Resolved: Quantity Discrepancies between tables would cause a PartCostID Error when consuming or reconciling inventory
'''Sales'''
*Resolved: Multi-currency rounding discrepancies were occurring when using discounts on Sales Orders
'''Purchasing'''
*Resolved: Receiving Data CSV import was unable to partially receive items. It was automatically fulfilling remaining items.
'''Accounting'''
*Resolved: Xero multi-currency taxes were calculated incorrectly when exported to Xero
*Resolved: QuickBooks Online Blank notes going over by themselves caused a "Required parameter" export error
*Resolved: QuickBooks Online Partially fulfilled Sales Orders with percentage discounts produced an "Amount not equal to unit price" export error
'''Manufacturing'''
*Resolved: Update error messaging when attempting to unissue a Manufacture Order with pick(s) in progress. The error message now lists which picks are in progress.
*Resolved: Bills of Material with note type items could prevent deletion of a Sales Order even though its in entered status
'''API'''
'''API'''
* Resolved: Errors caused by UOM conversion issues when picking serial numbers
*Resolved: Legacy API call GetCustomerList returning wrong user for Salesperson when left blank on the Sales Order
*Resolved: Legacy API call InvQtyRq removing trailing zeros on Lot Number tracking
'''Reports'''
*Resolved: Customer Purchase History was not showing historical part numbers
*Resolved: Shipping Invoice report was showing "null" for carton details on some Sales Orders
*Resolved: Historical Part Cost report gives out wrong total cost when using FIFO/LIFO databases
*Resolved: Part Cost Over Time was not filtering dates properly
*Resolved: Sales Order Dashboard total including voided and cancelled orders
*Resolved: Sales Order Dashboard top selling products quantities and prices were being improperly inflated
*Resolved: Sales Order Dashboard did not reflect the proper home currency symbol


'''Client'''
* Resolved: Server Shutdown Timer message showing an error


'''CSV'''
{{HideReleased|25.3|03|18|25}}
* Resolved: Customer Parts not using the customer full name for import/export
{{HideH2|Highlights - 25.3}}
* 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'''
*Continued focus and prioritization addressing key issues that highly impact users
* Resolved: Incorrect line encoding in eve.sh file
*New QuickBooks Online Sales Tax Feature
*Updated My Fishbowl Portal
*API Enhancements


'''QBO'''
{{HideH2|New Features - 25.3}}
* Resolved: Null export error on note/subtotal type line items
*New integration with QuickBooks Online automated Sales Tax
**Sales tax laws are complex, differ per state and are constantly in flux. We have partnered with QuickBooks to utilize their new Automated Sales Tax functionality. This new integration allows users to setup a single integration solve for multiple tax needs
*New REST API Features. The following endpoints have been added to the REST API allowing for export of CSV's and their headers.
**New API endpoint GET Export
** New API endpoint Export Header
*The My Fishbowl module has been updated to include new information
**The new My Fishbowl page gives users access to information relevant to their company as well as access to support cases making it so you can see everything in one place.
*The Ai Insights plugin is now installed automatically with every new Fishbowl install
**Including the Ai Insights plugin with every install helps to streamline the setup process meaning less steps and less time waiting for it to install.
{{HideH2|Fixes - 25.3}}
'''General'''
*Resolved: Running the Fishbowl Server in console mode was not automatically activating license keys
'''Sales'''  
*Resolved: When two users were attempting to issue the same Sales Order in some cases it would cause duplicate picks
*Resolved: When two users were attempting to pick the same Sales Order in some cases extra items were added to a shipment
'''Purchasing'''
*Resolved: When two users were attempting to receive the same Purchase Order in some cases duplicate items would be received
'''Accounting'''
*Resolved: Manufacturing Adjustment type Journal Entries were throwing an XML error or posting to incorrect accounts in QuickBooks Desktop
*Resolved: Exporting Sales Orders to QuickBooks Online was rounding the unit price field incorrectly when using repeating decimals
*Resolved: Items with multiple tracking values were posting to QuickBooks Desktop with the first tracking repeating
*Resolved: Payment refunds when utilizing a foreign currency were not posting to QuickBooks Online but instead giving a "Business Validation Error" during export
'''Setup'''
*Resolved: User Group Rights associated with individual plugins were not saving changes properly after a server update
'''Reports'''
*Resolved: Sales Order Taxes Report was doubling line item type taxes in the report's Grand Total


'''REST API'''
=MAR 6, 2025 - Plugins =
* Resolved: UserId missing from login request
{{HideH2|Commerce}}
*Amazon Plugin connection can't be disconnected with delete icon in settings.
**The trash icon button in the settings dialogue was only clearing the connection name field and the connect button. It should break the connection without having to delete the whole instance.
*Use customer properties setting not applying when customer is a job.
** The setting was not being considered and is now used when selected.
*Kits with service items were not fulfilling correctly
**Kit item quantities were not captured properly if one of the items was a service item. The service item is now recognized as fulfilled and sends the data over correctly.


'''Work Order'''
{{HideH2|WooCommerce}}
* Resolved: Updated finished good and raw good text during the Custom WO wizard
*Tax exempt customers still being taxed
**Default settings on plugin for taxes were causing some errors that have been corrected.


'''Xero'''
{{HideReleased|25.2|02|14|25}}
* Resolved: Purchase Order inventory holding account transactions not being reversed upon fulfillment
{{HideH2|Highlights - 25.2}}
*Increased focus and prioritization addressing key issues that highly impact users
*New REST API Enhancements
*Updated Plugin Integrations
* Improved Sales Order Alert Note Flow


{{HideReleased|2021.7|07|15|21}}
{{HideH2|New Features - 25.2}}
{{HideH2|Highlights - 2021.7}}
*The following endpoints have been added to the REST API and are now available for use. This allows for more accurate order syncing between programs by allowing the deletion of payments associated with canceled orders and management of Parts and Products. Users will spend less time manually deleting these items via the Fishbowl Client. 
* [[QuickBooks_Online#Export|Multiple email addresses are now sent from Fishbowl to QuickBooks Online on Customers and Invoices]]
**Delete Payment
**Delete Part
**Delete Product
*ShipExpress integration has been updated. This helps to ensure continued performance and use in the future
*Shopify Plugin integration has been updated. This helps to ensure continued performance and use in the future


{{HideH2|New Features - 2021.7}}
{{HideH2|Fixes - 25.2}}
'''General''' 
*Resolved: Fishbowl Client was slow to load on startup. This was a highly impactful issue with difficult workarounds that affected all customers. We have resolved this issue by updating JxBrowser which will fix the issue and prevent it from occurring in the future. Note that the latest version of JxBrowser no longer supports macOS 10 Catalina.
*Resolved: Download and installation of MySQL was not initiating properly. This was a highly impactful issue for anyone that was downloading and installing Fishbowl for the first time. Fishbowl Installer will now continue to download and install MySQL without interruption requiring user interaction.
'''Sales Order'''
* Resolved: Some users were getting an "Unable to decrement quantity" error after voiding and then re-shipping a Sales Order.
'''Part'''
*Resolved: Unable to enable Serial Number tracking when a part's inventory was in a single location.


* [[Access_Rights#Inventory|Added a user right to limit the Add functionality of the Inventory module]]
{{HideReleased|25.1|01|14|25}}
* [[Customer#Check_balance|Updated the Check Balance button of the Customer module to exclude estimate status orders]]
{{HideH2|Highlights - 25.1}}
* [[{{REST API}}|Added Location Group search options through the REST API]]
*Multi-Factor Authentication improvements
* [[{{REST API}}|Added the ability to create UOM's through the REST API]]
*Fishbowl Commerce speed improvements
* [[{{REST API}}|Added the ability to update UOM's through the REST API]]
* [[{{REST API}}|Enhanced the MO create REST API call to allow for creation of custom orders]]


{{HideH2|Fixes - 2021.7}}
{{HideH2|New Features - 25.1}}
*Multi-Factor Authentication is now required if integrating with Xero. Once integrated with Xero, MFA will not be able to be disabled.
*Multi-Factor Error message has been updated for greater clarity. We have included a link to a knowledge article with common troubleshooting steps.
*Fishbowl Commerce has been optimized in the following areas: Customer Import, Quick Fulfill, GetSystemProperty. This improves the overall performance when syncing between Fishbowl Commerce and Fishbowl Advanced so that less time is spent waiting for updates between the two systems.
*The QuickShipRq API call has been enhanced for speed. This allows more orders to be Quick Shipped in a shorter period of time.
* Added a new REST API endpoint that allows for deletion of Sales Orders. The new endpoint is DELETE SO.


'''Custom Fields'''
{{HideH2|Fixes - 25.1}}
* Resolved: Checkbox type custom fields are not transferred to the Sales Order module from the Customer module
'''General'''  
*Resolved: Fishbowl Server Application installer would fail to load MySQL 8.0 if Microsoft Visual C++ Redistributable was not pre-installed before installation. The installation now installs Microsoft Visual C++ Redistributable by default.


'''Fishbowl Client'''
'''Sales'''
* Resolved: Enter button not working in Advanced Search after closing and reopening a module
*Resolved: Editing an address on a Sales Order would remove the contact information from the details tab. Now this information is only changed when an existing address is selected that has default contact information.
* Client Connection changes for connection issues
*Resolved: Sales Order Quantity Picked field was not being updated properly after voiding the pick. This caused the Close Short button on Sales Orders to be greyed out.


'''Pick'''
'''Materials'''  
* Resolved: Pick custom fields being cleared out when using API calls
*Resolved: Creating a Purchase Order from within the Consignment Module would cause an invalid error preventing the creation of the Purchase Order.
*Resolved: Users could enable tracking on a part and skip adding tracking for some items. When attempting to pick these items later, the user would be unable to pick because the tracking numbers were unable to be selected.
'''Accounting'''
*Resolved: When attempting to reconcile parts on a Transfer Order that had already been consumed, users were receiving an error upon export to any accounting system stating "Balance your debits and credits." The error would not allow the Accounting Export to go through.


'''QuickBooks Desktop'''
'''Reports'''
* Resolved: Miscellaneous Credit general journal entries posting incorrectly
*Resolved: Sales Order Summary Report and Sales Order Summary Export Report were unable to be scheduled because of the added ability to filter by Product Tree. The report has been modified so that the Product Tree filter can be manually entered and still be scheduled in the Schedule module.
* Issue: Payments exporting and automatically applying to Invoices incorrectly
*Resolved: Export Summary Report was including posted transactions even when unchecking the box to include them in the report.
:* Resolution: Added a module option for Automatically Applying Payments that can be disabled
*Resolved: ABC Report has been updated to use a new report parameter improving date accuracy and simplifying report customizations.
*Resolved: Production Report has been updated to use a new report parameter improving date accuracy and simplifying report customizations.
'''Fishbowl Commerce'''
*Resolved: Settings allowing the Location Group for a Sales Order to be set according to the state on the ship-to address were non functional


'''QuickBooks Online'''
{{HideReleased|24.12|12|10|24}}
* Resolved: Vendor credit return posting incorrect journal entries
{{HideH2|Highlights - 24.12}}
*New Report enhancements
*Improved Plugin load times


'''REST API'''
{{HideH2|Features - 24.12}}
* Resolved: Issues with Purchase Order custom fields
*Enhanced the Sales Order Summary Report and the Sales Order Summary Export report with the following:  
* Resolved: Custom fields issues on Manufacture Order creation
**Added Customer PO as a column that can be enabled in Modify Report settings
**Added Modify Report Filters:
***Customer Group
***Carrier
***Product Tree
***Default Vendor


'''UOM'''
{{HideH2|Fixes - 24.12}}
* Resolved: Make default UOM's, like Each, inactive did not remove them from the UOM list when creating new parts
'''General'''  
* Updated text for Abbreviation fields
*Resolved: Some Hosted users were receiving a dialog box asking if they wanted to apply the downloaded update. This dialog box is now bypassed and update of the application happens automatically.


'''User Group'''
'''Purchasing'''
* Resolved: "See All Customers" user access right not limiting customers in the Product module, Customers tab
*Resolved: When changing the vendor on a purchase order with outsourced items, the costs were updating to the new vendor's costs.
*Resolved: Drop-shipped quantities updated on the sales order not being updated on the associated purchase order.


'''Xero AU'''
'''Receiving'''
* Resolved: "Unexpected error: Please reintegrate with Xero."
*Resolved: Accounting discrepancy was caused when immediately voiding after reconciling a single line item.


{{HideReleased|2021.6|06|10|21}}
'''Accounting'''
{{HideH2|Highlights - 2021.6}}
*Resolved: Partially fulfilled kits were causing the error "Line total does not match the expected line total" when exporting to Xero.
*Resolved: Exporting invoices to QuickBooks Online caused errors when sales tax was turned off in both Fishbowl and QuickBooks Online.


* [[Fishbowl_for_Mac|Mac installer improvements]]
'''Reports'''
* [[Sales_Order|Added the ability to right-click multiple sales orders in the search pane and close short the orders]]
*Resolved: Sales Order Summary report was not pulling the correct information when selecting a single day from the Date Range dropdown.
*Resolved: Sales Order Summary Export report was not pulling the correct information when selecting a single day from the Date Range dropdown.
*Resolved: Work in Progress Report was not totaling properly when including multiple work orders.


{{HideH2|New Features - 2021.6}}
'''Plugins'''
*Resolved: Improved load time for all plugins which was also affecting the client load and log in time.
*Resolved: A macOS file in the Plugins folder was causing the plugin updates to fail.
*Resolved: "The quantity must be a whole number" error was occurring for some UOM conversions when performing Move, Scrap, Cycle, and Add through the API. This affected these functions in Fishbowl Advanced Mobile.
*Resolved: The next available location was not being automatically populated in picking after partially picking a part through the API. This mainly affected Picking in Fishbowl Advanced Mobile.
* Resolved: Picking in a different Unit of Measure than the part is stored in would incorrectly show short inventory for that item. This mainly affected Picking in Fishbowl Advanced Mobile.


* [[Currency|Added the Zimbabwean Dollar to the available currencies list]]
{{HideReleased|24.11|11|20|24}}
* [[Getting_Started#Login|Updated the login message when exceeding the number of licensed users]]
{{HideH2|Highlights - 24.11}}
* [https://fishbowlhelp.com/files/csv/importSO.html The Sales Order CSV import now looks at the customer's priority setting if the priority field is left blank]
*[[User#Multi-Factor_Authentication_(MFA)|New Multi-Factor Authentication feature]].
* [[Manufacture_Order#Module_Options_General_tab|Unchecked "Always use the multiple finished goods step" MO module option by default for new databases]]
*Updated Error Messaging for Login and QuickBooks Desktop connections.
* [[Start_Fishbowl#Creating_a_new_database|Updated the default MySQL settings for new installs]]
* New fields available for Kit Items import.
* [[{{REST API}}|Updated Jetty to the latest version]]
* [[Company#Module_Options_LDAP_tab|LDAP logins are now supported in the REST API]]
* [[{{REST API}}|Added the UOM object to the REST API]]
* [[{{REST API}}|Added the ability to delete a UOM through the REST API]]
* [[{{REST API}}|Added Part Search to the available REST API calls]]
* [[{{REST API}}|Added UOM Search to the available REST API calls]]
* [[{{REST API}}|Added Vendor Search to the available REST API calls]]
* [[{{REST API}}|Added the Manufacture Order object to the REST API]]
* [[{{REST API}}|Added the ability to create a Manfacture Order through the REST API]]
* [[{{REST API}}|Added the ability to issue a Manufacture Order through the REST API]]
* [[{{REST API}}|Added the ability to unissue a Manufacture Order through the REST API]]
* [[{{REST API}}|Added the ability to close short a Manufacture Order through the REST API]]


{{HideH2|Fixes - 2021.6}}
{{HideH2|New Features - 24.11}}  
*Multi-Factor Authentication feature has been added and can be enabled for the Fishbowl Client log in process.
**'''What is Multi-Factor Authentication (MFA)?'''
***Multi-Factor Authentication (MFA) adds an extra layer of security by requiring not only a password and username but also a verification code when a user logs into their Fishbowl account. If MFA is triggered, a verification code will be provided through an authenticator app (e.g., Google Authenticator). This helps to ensure that the user is the only person who can access their Fishbowl Client login. To enable MFA, follow [[User#Multi-Factor_Authentication_(MFA)|these steps in Fishbowl's '''User''' module]].
**Outcome: Enhances overall security of the application through utilization of popular authentication applications.
*Updated error messaging for login and QuickBooks Desktop connection error messages.
**Outcome: Less bottlenecks in day to day Fishbowl usage meaning less time spent troubleshooting and more time doing more important tasks. The new error messages include a link users can click with detailed guides to troubleshooting and resolving the issue.
*New Fields available for Kit Items import. The following fields are available to update Kit Items: Weight, WeightUOM, Width, Height, Length, sizeUOM, and TaxCode (For international databases).
**Outcome: Spend less time having to manually update these fields with every new Kit imported into Fishbowl.


'''Client'''
{{HideH2|Fixes - 24.11}}
* Resolved: Unable to open multiple client instances on the same computer
'''General'''
* Resolved: Login and logout issues that caused the client the freeze
*Resolved: When attempting to run the optimize database feature, it was simply erroring out and essentially non-functional.
* Resolved: Chat box goes off screen for long messages


'''Company'''
'''Sales'''
* Updated text for LDAP module options
*Resolved: The Contact Details for a Sales Order were not updating after changing to a different ship to address.


'''CSV'''
'''Accounting'''  
* Resolved: Null import error when importing blank UPC with the module option "Only allow numeric characters in UPC code" enabled
*Resolved: When attempting to reconcile an outsourced Purchase Order (and at least some of the inventory outsourced had already been consumed) users were receiving an error upon export to any accounting system stating "Balance your debits and credits." The error would not allow the Accounting Export to go through.
* Resolved: Import issues when importing incomplete data in the UOM CSV import


'''Intuit Payments'''
'''Checkout'''
* Resolved: Error when taking a payment for a card already stored as a wallet
*Resolved: Users were not able to edit flat rate discounts on a Sales Order.


'''Manufacture Order'''
'''Reports'''
* Resolved: Unissuing a Manufacture Order did not clear out the issue date
*Resolved: 3 Reports (Sales Backorder Summary, Work order Summary, Export Summary) had an issue where if a single day was selected for a date range the report would populate with a blank page.
* Resolved: Partially fulfilling a WO, the secondary WO doesn't auto commit inventory when that option is enabled
*Resolved: The Product Catalog V2 report would not run if a customer was selected that had more than one address type marked as default.
* 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'''
'''Database Updates'''
* Resolved: Data not being saved after changing the date scheduled to the same date and choosing to update the line item dates
*Added two new columns to the '''sysuser''' table
**'''mfaSecret'''
** '''mfaBypassCounter'''
*Added a new column to the '''userlog''' table
**'''isMfa'''


'''QuickBooks Online'''
=NOV 14, 2024 - Commerce Plugin=
* Resolved: "Please balance your debits and credits" error when exporting bills
*The Commerce plugin in Fishbowl Advanced now uses SSO (Single Sign-On) to [[Commerce#Authentication_-_Connection_and_Setup|authenticate with Fishbowl Commerce]].
**Outcome: You no longer need to enter an App ID and App Secret which means that setup is faster and more secure.


'''Receiving'''
=NOV 8, 2024 - AI Insights=
* Resolved: Currency showing USD for a multi currency order with the multi currency values
* We're excited to announce the first release of our new [[AI Insights|AI Insights plugin]] for Fishbowl Advanced.
**If you'd like to unlock the power of your Fishbowl database, [https://www.fishbowlinventory.com/fishbowl-ai-insights book a demo today].
{{HideReleased|24.10|10|15|24}}
{{HideH2|Highlights - 24.10}}
*New Module Dashboard Date Filter options.
*New Module Dashboard speed improvements.
*New Updated [https://help.fishbowlinventory.com/s/Database-Dictionary Database Dictionary]


'''Sales Order'''
{{HideH2|New Features - 24.10}}
* Resolved: Unable to save after fulfilling a service item that is part of a kit
*The Sales, Purchasing, and Inventory Dashboards have all received updated date range filter options.
**Outcome: With these new options, period comparisons will be more accurate and informative to facilitate better mid-period business decisions.
*All four module dashboards have receiving significant speed improvements by implementing asynchronous functionality so that all cards and queries are running simultaneously.
**Outcome: The Dashboards run faster and display data as it is returned instead of waiting for all data to be returned before populating the entire dashboard.
*New Updated [https://help.fishbowlinventory.com/s/Database-Dictionary Database Dictionary]
**Outcome: You can now more efficiently and accurately build integrations, custom queries, and custom reports with the help of up to date documentation of database structure and dependencies.


{{HideH2|Fixes - 24.10}}
'''General'''
*Resolved: Scaling issues causing text to appear very small on some windows installations due to previous jxbrowser update.
*Resolved: When installing MySQL through the Fishbowl Server Installation we were utilizing the default MySQL settings. MySQL settings have now been optimized for the Fishbowl Server Application on all new installs.


'''Materials'''
*Resolved: Performing a move within the Consignment Module was not respecting the unit of measure selected. Instead it was always using the default Part unit of measure.


'''Database Changes'''
'''Purchasing'''
* Removed unused leadTimetoFulfill from the Part table
*Resolved: If a user had a Purchase Order and sorted the items by description then when a user would select the Cost field Fishbowl would automatically scroll the list of line items. The correct cost field was still selected but often caused confusion as to which item was being edited.


{{HideReleased|2021.5|05|13|21}}
'''Sales'''
{{HideH2|Highlights - 2021.5}}
*Resolved: Some users were receiving an error message that was preventing shipping an order that stated "Line item in entered status."


* [[Purchase_Order#Auto_PO|Added the ability to enter a Forecast % on the Auto PO wizard Summary page]]
'''Manufacturing'''
* [[Purchase_Order#Auto_PO|You can now set the schedule date for the Purchase Orders being created during the Auto PO wizard]]
* Resolved: The feature in Manufacturing that allowed a user to carry a tracking number from a Raw Good through to the Finished good was not functioning.
* [[Purchase_Order#Auto_PO|Added hover over details to quantity and cost columns in the Auto PO wizard Summary page]]
*Resolved: If "Auto-advance to Work Order finish step" was unchecked in the Manufacture Order Module, then picking would not occur automatically during the picking step. This caused users to have to go back to the picking step and manually pick every item.
* [[Purchase_Order#Auto_PO|Quantity, Unit Cost and UOM columns have been added to the Auto PO wizard Summary page]]
*Resolved: Bill of Material Instructions custom fields were not transferring properly to Work Orders created from that Bill of Material. If a user had more than one custom field then the first custom field in the list would be duplicated for every subsequent custom field on the Work Order.
* [[Purchase_Order#Auto_PO|Added an option to round up quantities to the nearest whole number during the Auto PO wizard]]
* [[Purchase_Order#Auto_PO|Added the ability to edit in line on the Auto PO wizard summary page]]
* [[Purchase_Order#Auto_PO|The vendor lead-time is displayed per part in the Auto PO wizard]]
* [[Purchase_Order#Auto_PO|The Date Scheduled during the Auto PO wizard automatically uses vendor lead-times to set the date]]
* [[Receiving#Module_Options_Options_tab|Added a module option in the Receiving module to update vendor lead times when receiving a part]]
 
{{HideH2|New Features - 2021.5}}
 
* [[{{CSV}}|The Sales Order CSV pulls custom field values for customers when module option is enabled]]
* [[{{CSV}}|The Sales Order CSV pulls custom field values for products when module option is enabled]]
* [[Purchase_Order#Auto_PO|Add a delete confirmation when removing a part from a PO during the Auto PO wizard]]
* [[Company#Module_Options_Address_Validation_tab|Available Address Validation has been updated to communicate over HTTPS]]
* [[Shipping#Module_Options_Email_tab|Updated "Send email when shipment is shipped" to have options for the Shipping Report, Shipping Invoice report, or None]]
* [[Kitting#Specify_Kit_Price|The "Specify Kit Price" option now functions the same way whether the order is created via the client or CSV]]
* [[{{REST API}}|Added a Manufacture Order search call to the REST API]]
* [[{{REST API}}|Added ability to delete a Manufacture Order through the REST API]]
* [[{{REST API}}|Manufacture Order Memos can now be created/updated/deleted through the REST API]]
* [[{{REST API}}|Upgraded the REST documentation navigation pane]]
* [[{{REST API}}|Updated the Part Best Cost call to include vendor minimum quantities]]
* [[Reports#Included_reports|Packing Slip - Added carrier service. Added a "Blind Shipment" checkbox. When checked, the company logo and address info will not print]]
* [[Reports#Included_reports|Pick Ticket - Added carrier service]]
 
{{HideH2|Fixes - 2021.5}}


'''Accounting'''
'''Accounting'''
* Resolved: Errors in export due to voiding items in receiving
*Resolved: When reintegrating with Xero the module option for "Use Class Tracking" in the Class Module would automatically be unchecked. This option would have to be re-checked manually before classes could be sent to Xero again.
*Resolved: When reintegration with Xero was required we returned the same error message we received from Xero which was not very helpful to the user. A better error message notifying the user of the need to reintegrate/re-authorize is now shown.
*Resolved: Sales Order payment refunds were not allowed if a customer was integrated with QuickBooks Online. This was because the payment refund would go to the wrong accounts in QuickBooks. Payment Refunds have now been enabled and post to the correct accounts in QuickBooks Online.


'''Database'''
'''Reports'''
* Resolved: QtyOnOrder view not matching On Order quantity in Inventory Module
*Resolved: 5 Reports have been updated to use a new date range parameter that reduces date range errors and more easily facilitates future changes and customizations. Reports updated include: Auto PO Report, Export Summary Report, Sales Backorder Report, Work Order Summary Report, and Sales Order Summary Report.


'''CSV'''
'''REST API'''  
* Update instructions text for the Bill of Materials Details CSV
*Resolved: The REST API did not allow passing of a parameter via the Data Query call. This change enables better integration with applications like SalesForce.
* Resolved: SO Details and SO CSV's do not check for duplicate vendor names
*Resolved: The REST API was recalculating unit cost for the PurchaseOrder call based on the total cost. This was causing the unit cost when entered to be recalculated and rounded and no longer matched what was originally passed to the REST API.


'''Customer'''
'''Database Updates'''  
* Resolved: Tax exempt checkbox and number field showing available in the new customer wizard in Canadian databases
*Added a new column to the fbschedule table called pluginManaged. This field is utilized to make certain scheduled tasks read only avoiding the possibility of user changes that can cause certain features to stop working.


'''Gmail Integration'''
{{HideReleased|24.9|09|17|24}}
* Resolved: Old Fishbowl Logo showing on the final integration step
{{HideH2|Highlights - 24.9}}
*New [[Inventory Dashboard]] Module.
* New [[Manufacturing Dashboard]] Module.
*New feature that automatically restarts the Server application after downloading an update.


'''QuickBooks Desktop'''
{{HideH2|New Features - 24.9}}
* Resolved: Export error's on misc items
*[[Inventory Dashboard]] includes the following information: Inventory Value by Month (YTD), Average Days in Inventory, Parts to be Reconciled, Stock Adjustments, Expired Parts, and Short Parts.
**Outcome: Empowers businesses leaders to make informed decisions by providing a quicker and clearer picture of overall inventory status and helps identify potential problem areas.
*[[Manufacturing Dashboard]] includes the following information: Open Work Orders, Overdue Work Orders, Current WIP Value, Work Orders by Status, Production Needed, Yield and Consumption Variance.
**Outcome: Offers a more powerful and user-friendly Fishbowl experience, empowering your team with key data they need to facilitate decision making and drive operational success regarding the Manufacturing process.
*Automatically restart the Fishbowl Server application after an update: The feature setting in the Server Administration page for "Automatically Download and Apply Updates" has been improved. Now you can set a day and a time to have Fishbowl completed the update process by restarting the Fishbowl Server application after downloading an update. For those customers that have already enabled the "Automatically Download and Apply Updates" setting before updating, the default restart day is Sunday and the default restart time is 1:00 AM. This can be changed to whichever day and time works best for your business.
**Outcome: Less time spent having to wait for an update to complete the next time you restart your server manually. Helps keep you consistently up to date with the latest bug fixes and features.
*The Xero integration has been improved to better handle automatically associating payments made in Fishbowl. Now overpayments are able to be automatically applied to their corresponding invoice in Xero.
**Outcome: Less time spent having to manually apply payments in Xero for orders that are paid in full but only partially shipped.
*The JXbrowser service has been updated to 7.41.2
**Outcome: Improves compatibility with MacOS Sequoia keeping you up to date with the latest bug fixes and feature enhancements.


'''Part'''
{{HideH2|Fixes - 24.9}}
* Resolved: Able to add tracking to default return as Part
'''Purchasing'''  
*Resolved: The Auto PO function was creating multiple separate purchase orders for the same vendor. This was caused by how we handled parts that were similar in number. For example: B201 and 0B201.
*Resolved: When importing the Receiving Data.csv, if your Purchase Order number included a "P" as a prefix the import would error out and say that it could not find the Purchase Order.


'''Purchase Order'''
'''Sales'''  
* Resolved: Ability to edit qty/cost during Auto PO on the "No Vendor" step
*Resolved: Products with unit of measure conversions that produced repeating or long decimals were causing some picks to get a null error when trying to finish the pick.
*Resolved: The Sales Order.csv import was not respecting the setting for the "PriceIsHomeCurrency" column.
'''Manufacturing'''
*Resolved: The Bill of Materials.csv export was extremely slow when filtering to export a single bill of materials.
'''Server Administration'''
*Resolved: Fishbowl Server was not automatically restarting after installing an update for Mac computers.


'''REST API'''
'''Accounting'''  
* Updated the Purchase Order search CompletedTo/From to FulfilledTo/From
*Resolved: When invoices were exported over to Xero the line item numbering did not match was on the Sales Order.
* Resolved: Server Connections screen not updating for REST users on login and logout
*Resolved: Fishbowl would randomly loose its connection with Xero prompting the user to disconnect the integration and re-integrate.
*Resolved: The disconnect button in accounting now removes Fishbowl from the Connected Apps section of Xero.
*Resolved: Exporting subtotals to a Xero invoice was causing a "Line total does not match the expected line total" error.


'''Vendor'''
'''Reports'''  
* Resolved: Vendor Last Cost not updating the Last Date when cost is updated
*Resolved: The Sales Dashboard was including subtotals in the list of top selling products.
*Resolved: Sales Order Report date type custom fields were including a timestamp by default. The timestamp has been removed.
*Resolved: Accounting's Export Summary report was not totaling correctly for "not posted" orders.
*Resolved: Receiving History Report when exported as an .xls type file was not saving the total fields.
*Resolved: The Packing List Report was not properly displaying kit headers when choosing the "By Carton" layout.
* Resolved: The Reorder Report was including inactive locations when utilizing "By Location" reorder points.
*Resolved: The Pick Report was still including a prefix on the barcode even when the option to "Prefix Barcodes" is unchecked.
* Resolved: Reverse Lot History report was running very slow. Have made improvements to further optimize the report.
*Resolved: The Packing List report was renamed to Packing Slip but was still referenced as packing list throughout the rest of the client.


{{HideReleased|2021.4|04|15|21}}
{{HideReleased|24.8|08|13|24}}
{{HideH2|Highlights - 2021.4}}
{{HideH2|Highlights - 24.8}}
*New [[Sales Dashboard]] and [[Purchasing Dashboard]] have been added to provide quick access to crucial business insights empowering you to make better informed decisions.


* [[User#Notifications|Added Purchase Order SMS based notification subscriptions for Purchase Order approvals]]
{{HideH2|New Features - 24.8}}
*A [[Sales Dashboard]] has been added to provide the following information: Sales Orders vs. Previous Period, Sales Order Summary, Margins, Top Selling Products, Sales by Product Tree, Orders Fulfilled in Full on Time.
**Outcome: Empowers businesses leaders to make better informed decisions by providing a clear picture of sales performance.
*A [[Purchasing Dashboard]] has been added to provide the following information: Top Selling Parts by Vendor, Top Margins by Vendor, Inventory Value, Days in Inventory, Orders Closed Short, Purchases by Type.
**Outcome: Provides businesses with crucial insights into their procurement processes by streamlining purchasing data into actionable insights, companies can improve supplier negotiations, optimize inventory levels, and manage purchasing costs effectively.
*New Installations of the Fishbowl Server are now set to "Automatically Download and Install Updates." If an update becomes available Fishbowl will automatically download the update and apply it the next time the server is restarted.
**Outcome: Helps you get the most out of Fishbowl with new features and fixes with less manual intervention.


{{HideH2|New Features - 2021.4}}
{{HideH2|Fixes - 24.8}}
'''Sales Order'''
*Resolved: The "How to" button was linking to the wrong help article for Fishbowl Payments.
'''Purchasing'''
*Resolved: The Auto PO function was pulling order demand outside of selected filter dates.
'''Accounting'''
*Resolved: Catching illegal characters causing XML Parse errors when exporting to QuickBooks has been improved.
*Resolved: Issue where rounding of taxes was causing discrepancies when exported to Xero.
*Resolved: Rate limit issues when sending a high number of transactions to Xero. A wait period of 30 seconds has been implemented to allow the export to continue.
*Resolved: Automatic syncing of tax items is now optional when integrating with Xero.
*Resolved: When choosing a different tax rate upon reconciling a receipt the original tax on the Purchase Order was exported to Xero.
*Resolved: A 32bit version of Fishbowl Nexus ("Fishbowl Nexus x86") is now included in the Server Bin folder upon installation and can be used when integrating with QuickBooks Desktop versions 2021 or older and Reckon.
'''Manufacturing'''
* Resolved: Some users were encountering a "Not enough quantity in target tag" error when attempting to finish a Work Order with a raw good that was only partially short inventory and the user right "consume when short" is enabled.
*Resolved: Work Orders that contained a Product with a long description were not displaying properly in the Finish Work Order Wizard.
'''Reports'''
*Resolved: Auto PO report was pulling order demand outside of selected filter dates.
*Resolved: Historical Part Cost Report was pulling historical entries outside of the date selected.
*Resolved: Historical Part Cost Report was not calculating total cost correctly for FIFO costing databases.
*Resolved: Sales backorder report was inflating the short calculations columns by including drop ship and credit return type items in the calculation.
*Resolved: Gross sales by Sales Person Report was not including miscellaneous type items.
*Resolved: Gross sales by Sales Person Report has been updated to match the corresponding BI Report.
* Resolved: A new parameter has been added to better facilitate report date ranges.


* [[QuickBooks_Online#Journal_entries|Added customer reference to Purchase Order journal entries in QuickBooks Online]]
{{HideReleased|24.7|07|16|24}}
* [[Customer#Details_tab|Increased Customer and Vendor alert notes character limit to 256]]
{{HideH2|Highlights - 24.7}}
* [[Fishbowl_Checkout#Module_Options_General_tab|Added a module option in Fishbowl Checkout to default the Salesperson field to blank]]
*The Nexus application used to connect to QuickBooks Desktop has been updated to be 64bit compatible.
* [[Access_Rights#Sales_Order|Added a user right to control access to Payment Terms dropdown on a Sales Order]]
* [[QuickBooks#Module_Options_QuickBooks_tab|Added a module option to set the Sales Order # or Shipment # to go to the QuickBooks Desktop "Other" field]]
* [[{{REST API}}|Updated custom field REST API search to search by ID instead of name]]
* [[{{REST API}}|Added the ability to close short a Purchase Order through the REST API]]
* [[{{REST API}}|Added the ability to close short Purchase Order items through the REST API]]
* [[{{REST API}}|Updated the Currency REST call to include the currency code]]
* [[{{REST API}}|Added a user search call for the REST API]]
* [[{{REST API}}|Added a get part best cost call in the REST API for Purchase Orders]]
* [[Fishbowl_API|Updated legacy VendorGet API call to link in addresses]]
* [[Advanced_Reports#Z_Report|Z Report: Now displays the salesperson and has an option to sort by various columns]]
* [[Advanced_Reports#Sales_Order_Report|SO Report: Fulfillment Date label changed to Date Scheduled (still displays the item Date Scheduled)]]


{{HideH2|Fixes - 2021.4}}
{{HideH2|New Features - 24.7}}
*The Nexus application used to connect to QuickBooks Desktop has been updated to be 64bit compatible.
**Outcome: This update helps to facilitate future updates and integration performance and stability improvements.
*The Xero integration has been enhanced to automatically apply partial payments.
**Outcome: Now payments in full and partial payments are automatically allocated to the invoice when they get to Xero saving time spent manually applying payments.
* Adding different carton types to shipments has been made easier by removing case sensitivity from the carton search field.
**Outcome: Searching for cartons types to add to a shipment takes less time having to enter in uppercase vs lowercase letters.


'''API'''
{{HideH2|Fixes - 24.7}}
* Resolved: Calls not setting the userid on the REVINFO table
'''Sales Order'''
*Resolved: License key issues with Checkout was only allowing the admin user to log in.
*Resolved: Multi-Currency Sales Orders were not rounding properly causing a discrepancy in some cases of $0.01
'''Manufacturing'''
*Resolved: The Bill of Material CSV import was throwing an error stating that item descriptions were required when they should not be required.
*Resolved: When finishing a repair item with two or more assigned serial numbers on a Work Order, editing one of those serial numbers gave an error stating that the serial number already exists.
*Resolved: An automation that apply's changes made to a Bill of Materials to any open Work Orders was not utilizing Unit of Measure conversions for the part that was modified.
'''Mac'''
*Resolved: A notification animation in the client application was prompting a notification in iOS to enable screen recording even though it was not required.
'''Accounting'''
*Resolved: Xero payments were being duplicated in circumstances where the payment amount was more than the total amount of the invoice
'''Database Updates'''
*Serial Numbers were limited to 41 characters in the database. The following fields have been updated to support up to 256 characters: 
**serialnum.serialnum
** tiinventorylog'''.'''info
**tiinventorylogsn.serialNum
**trackinginfosn.serialNum
**serialnum_aud.serialNum
**trackinginfosn_aud.serialNum


'''Client'''
{{HideH2|Commerce Plugin - 24.7.4}}
* Resolved: Inactivity causing the client application to become unresponsive
'''Features'''
*Added functionality to set PRODUCT "Active" status in Fishbowl Commerce based on selection in Fishbowl. Inactive products in Fishbowl will not be created in Fishbowl Commerce, only updated if previously linked.
** Users need to be able to adapt listing quickly and easily as products change and get new versions. This update allows sellers to keep product listings current when they change active status in the origin app, Fishbowl.
*Added an option to filter out imported orders that don't have a mapped status
**Users with many store channels will have increasing processes that deviate from the traditional flows. This option will give more B2C customers the ability to define when fulfilled orders should come into Fishbowl for inventory and accounting recording.


'''CSV'''
'''Fixes'''
* Resolved: EDI Shipping blank export due to Null error  
*Fixed a Settings export issue that was changing location settings to make inventory unavailable
* Resolved: Sales Order CSV instructions text update
*Removed Warehouse/LG ID from the the Order Import resolving an import error for Not Found Warehouse ID
* Resolved: Locations import running slow when importing 1000's of location for a single location group
*Fixed an issue with Inventory update when "Include Available to Build quantities" option was enabled
* Resolved: Slowness when importing the Receiving Data import
*Fixed query syntax issue with the Inventory Update task when the "Include Available To Build quantities" is selected
*Fixed issue on fulfillments where incorrect shipments were being sent to Fishbowl Commerce by supporting re-sending shipments via backdated sync
*Location Group mapping was refactored for the Settings export to match and update on the LocationGroup/Warehouse name rather than ID
*Fixed a Fulfillment issue resulting from batching large amounts of Shipments at once
*Changed how fulfillments get sent to Fishbowl Commerce to catch missing fulfillments
*Kits fulfilled in varying UOMs will be converted back to original order UOM to prevent errors to Fishbowl Commerce


'''Custom Fields'''
{{HideH2|Advanced Plugins - 24.7}}
* Resolved: Slowness with custom lists
'''Fixes'''  
*08/06/2024 - Fixed Null pointer exceptions for all e-commerce on dropship fulfillments preventing an all fail to the channel
*Saturday Delivery and Retail Rates options now return rates and labels for ShipExpress
*Updated Magento plugin Fulfillment and Order API calls for Bundle types, Together and Separate
* Updated Magento (AdobeCommerce) plugin to handle bundle fulfillments via the new API
* Updated ShipExpress dependencies for the latest version of Fishbowl Advanced


'''Part'''
{{HideReleased|24.6|06|18|24}}
* Resolved: Issues changing the default return as part when duplicating an outsourced part
{{HideH2|Highlights - 24.6}}
*The Xero integration has been enhanced to automatically apply payments made in full to an invoice saving time having to manually apply all payments in Xero.
*The installation process has been streamlined to save time and effort during installation.
*Last manufactured cost has been added as an option in pricing rules ensuring more balanced and accurate pricing resulting in less time spent comparing cost versus price.


'''Picking'''
{{HideH2|New Features - 24.6}}
* Resolved: Pick Location selection issue across multiple locations
* The Xero integration has been enhanced to automatically apply payments made in full to an invoice.
**Outcome: Save time by not having to manually apply every payment sent from Fishbowl to Xero.
*The server installation process has been streamlined for ease of use. Fishbowl will automatically install MySQL for you.
**Outcome: IT administrators no longer have to manually install a separate application when installing the Fishbowl Server.
*Sales Order 
**Last manufactured cost has been added as an option in pricing rules
*Product
** Next order information has been added to the Product Tree search pane's information button. This gives information regarding future incoming inventory for the selected product helping make better decisions on whether or not to add that product to the selected Product Tree.
*Reports
**The Receiving Summary report is used to see an overview of orders that are in receiving and their status. It can show which orders have items that have been received but not reconciled which can help accountants.
**The Production Demand report is used to quickly see what the current demand (allocated to an order) is for finished goods in a given date range. It shows demand for each order and also includes a summary by Part Number helping you know exactly what needs to be produced in manufacturing.
*The Asian Pacific regions license agreement has been updated.


'''Product'''
{{HideH2|Fixes - 24.6}}
* Resolved: Product Module Sort by Product Type sorting issue


'''Purchase Order'''
'''Accounting'''  
* 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: If taxes were not synced between Xero and Fishbowl those taxes would show up as tax exempt on orders. Fishbowl now automatically syncs taxes upon integration with Xero.
* Resolved: Receiving holding account entry not being reversed upon fulfill
*Resolved: The Xero integration was showing an option to import currency when that functionality is not available through the integration with Xero.
* Resolved: Purchase Order journal entries should set the class for the line item and not the order class
*Resolved: The wrong logo was being displayed on the Reckon integration button.
 
'''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


'''Sales Orders'''
*Resolved: The setting in the Shipping module options "Print Shipping Invoice on Ship" was only printing the first Shipping Invoice when shipping multiple orders at the same time.
*Resolved: When trying to copy text on a Sales Order using "Control + C" on a Mac it would launch the Inventory Check Tool instead of copying the text. Now to launch the Inventory Check Tool, use "Control + E".
*Resolved: With multi-currency enabled, if an order was created using the home currency which does not utilize multi-currency then the multi-currency fields for that order were not filled out. This was causing issues with plugin integrations.
*Resolved: Sales Order and Sales Order details were not including part cost for service type items on kits.
*Resolved: Closing short one item on a sales order kit broke shipping moving forward for that order.
* Resolved: Status was allowed to be changed using the Sales Order Details CSV import. This has been removed. This created an instance where Sales Orders were issued but no pick was automatically generated.
*Resolved: In the Shipping module's advanced search, both Order Number and Ship Number were pointing to the same field.
'''Purchase Orders'''
*Resolved: Auto-generating a purchase order was not including item custom fields on the purchase order.
'''Reports'''
'''Reports'''
* Resolved: Sales By Rep BI Report - Not including discounts
*Resolved: Bill of Materials Report was not showing correct Units of Measure and was running slowly.
* 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'''
{{HideH2|Commerce Plugin - 24.6}}
* Resolved: Null error when creating a Return and not verifying by order
'''New Features'''
*Initial sync with Fishbowl Commerce now sends Accounting class and salesperson lists to facilitate mapping those fields per linked channel
**Users may use these order fields to run accounting and sales reports on a channel by channel basis in Fishbowl or the accounting app


'''Work Order'''
'''Fixes'''  
* Resolved: Seemingly random quantities when splitting repair Work Order lines
*Resolved: Inventory Export correctly references Min/Max settings
*Fixed Inventory null error on inventory update for Kit products
*Fixed an issue with Customer name mapping when Fishbowl Commerce default customer was not being used
*Fixed mapping the Order item description field in Fishbowl from Fishbowl Commerce fields
*The plugin no longer logs stacks for successful runs of scheduled tasks, preventing cluttered log files


{{HideH2|Advanced Plugins - 24.6}}
'''Fixes'''
*Fixed the Invoice (810) ship date in the SPS Plugin
* Fixed an issue on Amazon orders where shipping tax was getting removed twice when setting was enabled.
*Fixed Amazon order import to honor tax exempt status in the plugin
*Updated Amazon plugin UI to show corrected field name for default customer mapping
*Fixed File Storage plugin settings from getting overwritten when license validation fails


'''Database Changes'''
{{HideReleased|24.5|05|14|24}}
* Updated Customer.note field to be varchar(256)
{{HideH2|Highlights - 24.5}}
* Updated Vendor.note field to be varchar(256)
*The Xero integration has been updated to the latest SDK
* Created Notification table
**Outcome: Not only does this offer access to the latest integration features, but it offers increased stability and fixes for past bugs.
* Created NotificationType table


{{HideReleased|2021.3|03|11|21}}
{{HideH2|New Features - 24.5}}  
{{HideH2|Highlights - 2021.3}}
*The Cycle Count Data CSV import has been updated to honor UOM conversions
**Outcome: Being able to utilize different UOM's when performing cycle counts adds efficiency and accuracy to the cycle count in a warehouse full of different bundles of products.
*Database Layer Updates
** Outcome: Updates to the frameworks for communication between the Server and Database have been updated, offering a more efficient connection as well as security updates.
*QuickBooks Online Integration steps have been simplified
**Outcome: The integration wizard will now auto progress after account login to improve efficiency during integration.


* [[Purchase_Order#Module_Options_General_tab|Added the ability to require approval for Purchase Orders over a specified dollar amount]]
{{HideH2|Fixes - 24.5}}
* [[Access_Rights#Purchase_Order|Added user right to allow users to approve Purchase Orders in the Pending Approval status]]
* [[Shipping#Module_Options_Ship_Items_tab|Added the ability to assign different print defaults for packing and shipping]]
 
{{HideH2|New Features - 2021.3}}
 
* [[Fishbowl_Anywhere|Added logos for plugins into the module header bar]]
* [[Sales_Order|Sales Orders created by RMAs without a verified order will use customers default salesperson]]
* [[Access_Rights#Sales_Order|Added a user right to limit access to the Payment Deposit Account in the payment wizard]]
* [[Access_Rights#Sales_Order|Added a user right to limit access to the Payment Date in the payment wizard]]
* [[{{REST API}}|Added Home Currency flag on currency object for Purchase Order REST API]]
* [[{{REST API}}|Added total cost for Purchase Order in REST API]]
* [[{{REST API}}|Updates to error messages when using the Purchase Order REST API]]
* [[{{REST API}}|Added the ability to access memos in the Purchase Order REST API]]
 
{{HideH2|Fixes - 2021.3}}


'''Accounting Export'''
*Resolved: When not using the legacy client connection, the Accounting Export window did not update until the export was finished
'''Checkout'''
'''Checkout'''
* Resolved: Null error when fulfilling a credit return


'''CSV'''
* Resolved: The default port for fresh installs has been updated to align with the Fishbowl Client.
* 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'''
'''Database Rebuild'''
* Resolved: Customers with stored wallets not loading due to missing icons
*Resolved: The database rebuild tool has been updated to clear the PartCostHistory table
'''Login'''
*Resolved: When not using the legacy client connection, a generic error message was displayed when the user login limit had been reached
'''Reports'''
*Resolved: The Batch Pick Ticket by Order report was showing null as the title for the pick tickets
*Resolved: Incorrect tax inclusion on the SO to PO Margin report
*Resolved: The Work In Progress report showing duplicate orders and incorrect totals
* Resolved: The Purchase Order Summary report showing the incorrect currency symbols
* Resolved: Repair items showing up twice on the Work Order Consumption report
* Resolved: Incorrect columns show on the Sales Order Summary report when modifying columns
*Resolved: Date type custom fields showing incorrectly on the Sales Order report
* Resolved: Scheduling the Dormant Customers report giving errors and a corrupt file
*Resolved: Export issue when saving the Customer Purchase History to XLS and CSV
*Resolved: Batch Sales Order Invoice date range parameter issues
*Resolved: Purchase Order Summary export not showing the correct currency symbol
*Resolved: Currency symbol issues on the Item History report
*Resolved: Average cost calculation issues on the Part Cost of Time Report


'''Database Update'''
'''Sales Orders'''  
* Resolved: Database update failure due to multiple shipping invoice reports
* Resolved: The cost for kits not honoring UOM conversions
*Resolved: Parts that are not inventory type not honoring UOM conversions and showing incorrect costs


'''Installer'''
{{HideH2|Commerce Plugin - 24.5}}
* Resolved: Inability to install a Client Only version due to license key requirement
'''New Features'''
* Updated the installer to exclude the webapp folder on Client Only installs
*Order Discounts can be displayed as their own line item or rolled up in to the item price
*Inventory Export sends short quantities to Fishbowl Commerce as negative total quantities
*Added Vendor PO to the order mapping tables
*Allow USPS shipments to get passed back to Amazon without carrier tracking data in compliance with Amazon's VTR policies


'''Kits'''
'''Fixes'''
* Resolved: UOM UI conversion error when editing quantities on a Sales Order
*Removed Drop Ship quantity allocations from quantities passed to Fishbowl Commerce
*Removed redundant setting to map Order numbers in the plugin when the setting exists in Fishbowl Commerce already


'''Linux'''
{{HideH2|Advanced Plugins - 24.5}}
* Resolved: Notification animation causing the client to lock up
'''Fixes'''
* Resolved: Environments without a system tray unable to see server window
*Fixed Salesforce Order defaults to use "Customer Default" mapping options only when selected
*Fixed Amazon orders to send fulfillment data from drop ship receipts
* Added carrier, CanPar, as a service validated carrier for Amazon fulfillments
*Fixed an issue with Amazon shipping tax being removed twice from payments on payment tax removal option
*Mapped order taxes to ShipStation tax fields on the Shipment Export


'''Purchase Order'''
{{HideReleased|24.4|04|16|24}}
* Resolved: Line item notes not saving on partial or fulfilled status line items
{{HideH2|Highlights - 24.4}}
* Resolved: Unissuing a PO does not clear out the date issued
*To keep business running smoothly and take advantage of performance, security and feature enhancements made or temporarily bypass the manual database engine update process, the Fishbowl installer now streamlines the install process based on your business needs at the time of the update.
* Resolved: Unissuing a PO does not change the Last Modified info
**During the installer, Fishbowl will detect which version of MySQL is currently found and give you options for remaining on MySQL 5.7 or updating to MySQL 8.0.
*To offer the best connection experience while working in Fishbowl, the login screen has been updated to show you if you are using the legacy connection with options of disabling it.
**The login screen has been update to display if the legacy socket connection is being used between the Fishbowl Client and Server.
*To start off on the right foot, new installs of Fishbowl will utilize port 2456 for the client connection, thus requiring less from your IT department.
** Instead of defaulting to port 80, new installs of Fishbowl will utilize port 2456 for the updated connection between Fishbowl Client and Server.
*To eliminate potential downtime due to updates and to keep your connection running smoothly, the default memory allocation for Fishbowl Client has been increased and updated.
**The previous RAM allocation was 1GB. It has been updated to 2GB to prevent issues with the connection and when updates occur.


'''QuickBooks Desktop - Canadian'''
{{HideH2|New Features - 24.4}}
* Resolved: Issues with Sales Receipts vs Invoice/Payment creation on export
*Ensuring accuracy and completeness for every transaction, no matter the stage the order is in, Purchase Order fields like Customer Sales Order Number, Vendor Sales Order Number and line item custom fields are editable even after order fulfillment.
* Resolved: Rounded cash transactions not exporting the amount on sales receipts
*Tired of the endless scrolling through products when creating orders for your customers when they have a specific product list? There is now an option to limit that list to those products that are linked to your customer, thus simplifying the order creation process.
*Data accuracy and consistency is key in any business. Limiting access to editable fields can ensure that remains true. User rights have been added to limit access to the Sales Order Number, Ship Date, Purchase Order Number and Receive date fields during the order taking and fulfillment process.
*Need to contact a customer about a payment that was taken? The customers email address from the order is now shown in the Payment Viewer for quick access.
* Fishbowl's connection to QuickBooks Online is key to your business running smoothly. The connection itself has been updated, along with improvements around connecting and disconnecting have been made.


'''QuickBooks Online'''
{{HideH2|Fixes - 24.4}}
* Resolved: Business Validation error on export
'''Database Access'''
* Resolved: Jobs imported from QuickBooks Online creating new job entries on export
*After updating to MySQL 8 the “gone” user was not created automatically affecting integrations with third party programs that utilized an ODBC connection to the database. The new update creates the “gone” user automatically making it immediately available for use.
'''Fishbowl Payments'''


'''Receiving'''
*In some cases, the scheduled task to import payments that were made via Pay Link would fail without error and would not update the timestamp on the last run date. These issues have been resolved.
* Resolved: Errors when receiving an outsourced item with a rejection


'''REST API'''
'''Inventory'''  
* Resolved: Bad error message when updating an existing Purchase Order
*In rare cases some serial numbers were removed from inventory. If a user was performing a cycle count and also attempted to change a serial number mid process that serial number would be lost upon completion of the cycle count process. This happened specifically when the serial number letters remained the same but were changed between uppercase and lowercase. This issue is now resolved and the serial numbers are updated and remain intact.
 
'''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
 
{{HideReleased|2021.2|02|18|21}}
{{HideH2|Highlights - 2021.2}}
* [[Start_Fishbowl#Parts_of_the_Screen|Fishbowl's look and feel has been updated with a new color scheme, icons, and splash screen for 2021]]
* [[{{REST API}}|Beta release of web based Rest API with endpoints for Purchase Orders]]
 
{{HideH2|New Features - 2021.2}}
 
* [[Sales_Order#Search|The Advanced Search for sales orders has a new tab to be able to search line item custom fields]]
* [[Customize_Fishbowl#Program_Options|Added a Program Option for setting the table line height throughout Fishbowl]]
* [[Sales_Order#Module_Options_Custom_tab|Updated the description for the custom report text in the Sales Order module options]]
* [[Getting_Started#1._Install_Fishbowl|Added additional license key and support contract validation during installation]]
* [[Getting_Started#1._Install_Fishbowl|The installer has been updated to include a few "Things to consider before updating"]]
* [https://fishbowlhelp.com/files/csv/importPart.html The Part CSV import now has the ability to assign a default outsourced return part]
* [https://fishbowlhelp.com/files/csv/importBCReceiving.html The Receiving Data CSV import now has the ability to update shipping information for the order]
 
{{HideH2|Fixes - 2021.2}}
 
'''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'''
'''QuickBooks Online'''
* Resolved: Part/Product/Item validation errors
*When posting Purchase Orders to QuickBooks Online, if a customer received an error stating that “A bill has already been created”, duplicate journal entries would be created in the holding account
* 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'''
'''Reports'''
* Resolved: Updating vendor info in Fishbowl erases banking info on export
* The Reverse Lot History report  was missing some Work Orders in certain circumstances. The report has been fixed and now includes all Work Orders.
*The Shipping Invoice was not including shipping type items in its total. The report has been fixed and now includes associated shipping items in the total.
*The Bi Report “MTD Chart” was unable to run because of an issue regarding leap year. The report has been updated and runs as expected.
* The Manufacture Order Projected Cost doubling the total cost to finish the order. The report has been updated to show the total accurately.
'''Sales Order''' 


'''Sales Order'''
*When modifying and updating a Sales Order with link Manufacture Orders, a user may receive a blank error, thus causing changes to not save. This error has been updated to inform the user of the issue and steps to resolve it.
* 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'''
'''Server Administration'''
* Resolved: Sorting issues when sorting the Last Run Time column


'''Shipping'''
*Resolved issues causing Database Maintenance to fail when using MySQL 8
* Resolved: Shipping custom fields clearing out when saving with shipping through ShipExpress


'''Tax Rate'''
'''Database Updates'''
* Resolved: View only rights still allowing users to edit tax rates


'''UOM'''
*Add access right for editing Sales Order number
* Updated text descriptions during the Add New UOM Conversion Wizard
*Add access right for editing Purchase Order number
*Add access right for editing batch Ship Date
*Add access right for editing Receive Date


'''Work Order'''
=MAR 29, 2024 - Commerce Plugin=
* Resolved: Save dialog popping up when nothing was changed


{{HideH2|New Features}}
*Adding a product to a product tree triggers an inventory update to Fishbowl Commerce for that product.
* Added options for importing line-item, order, and shipping discounts as part of the item price or as an added line item.
*Updated standardized discount logic aligned with Fishbowl Commerce and E-commerce channels.
*Product Import/Export now includes Fishbowl Commerce product-dimension data when present.
* Added Fishbowl Commerce product fields to the product-mapping table for Import and Export.


'''Database Changes'''
{{HideH2|Fixes}}
* Remove SOITEMTOMOITEM table
*Fixed issue to import non-erroring orders on a null-pointer scenario.
* Added a new column to the MOITEM table for SOITEMID
*Fixed an inventory-export issue related to sending short quantities to Fishbowl Commerce.
*Fixed order-customer-name logic on orders using missing address settings.

Latest revision as of 15:49, 22 April 2026

This page lists recent changes made in Fishbowl Advanced as well as download links for the currently supported versions.

Scheduled for MAY 19, 2026 - Advanced 26.5

Highlights - 26.5

  • Important Notice: MySQL 8.0 End of Life - Update Optional for Now - MySQL 8.0 reached End of Life (EOL) in April 2026. Oracle will no longer issue security patches, bug fixes, or official support for MySQL 8.0. While we recommend upgrading to MySQL 8.4 LTS, this update is NOT required at this time. Fishbowl will continue to support MySQL 8.0 until the September 2026 release. You can safely use the standard auto-update process for version 2026.5 - it will maintain your current MySQL 8.0 installation. For detailed upgrade instructions, visit: https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update
  • Important Notice: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
  • Important Notice: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.5. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.5 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
  • Important Notice: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.5.
  • Improved client connection performance with reduced server communication overhead
  • Product search now correctly defaults to active items only in the Products module
  • Accounting export errors related to manually corrected landed costs resolved
  • QuickBooks Online and Xero integration export errors resolved

New Features - 26.5

  • Client connection performance improvements. The Fishbowl client connection has been optimized to reduce the number of server round-trips made during normal operation. Clients now check whether server-side updates are available before requesting them, rather than fetching on every interaction. Users on high-latency or slower network connections should notice improved responsiveness.

Fixes - 26.5

General

  • Resolved: After upgrading to version 2026.3, the Products module search began returning both active and inactive products by default. The Active Only filter shown in Advanced Options was not being applied on initial load or when clicking the search button. The default search behavior now correctly limits results to active products.

Accounting

  • Resolved: When manually applying landed costs, entering an incorrect amount that triggered a validation error and then correcting the value would cause Fishbowl to accumulate both the invalid and corrected amounts rather than replacing the prior entry. This resulted in an overstated landed cost total and a "Please balance your debits and credits" error on accounting export. The correction now replaces the prior entry rather than adding to it.
  • Resolved: Exporting a Sales Order to QuickBooks Online failed with an "Amount is not equal to UnitPrice * Qty" error when associated pricing on the order had been changed after the order was issued. The unit price was not being correctly carried through to the export calculation. The export now uses the price stored on the sales order line item.
  • Resolved: Exporting a Credit Return Sales Order to Xero failed with a line total mismatch error when stock for the return was received in multiple batches (e.g., two receipts of 5 units for a line originally returned as 10). Fishbowl was not correctly apportioning the unit price across split receipts, producing mismatched totals. The export now correctly calculates line totals for split credit return receipts.


​

APR 14, 2026 - Advanced 26.4

Download - 26.4

Highlights - 26.4

  • Important Notice: MySQL 8.0 End of Life - Update Optional for Now - MySQL 8.0 will reach End of Life (EOL) in April 2026. Oracle will no longer issue security patches, bug fixes, or official support for MySQL 8.0. While we recommend upgrading to MySQL 8.4 LTS, this update is NOT required at this time. Fishbowl will continue to support MySQL 8.0 until the September 2026 release. You can safely use the standard auto-update process for version 2026.4 - it will maintain your current MySQL 8.0 installation. For detailed upgrade instructions, visit: https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update
  • Important Notice: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
  • Important Notice: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.4. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.4 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
  • Important Notice: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.4.
  • New user rights added for individual Import/Export operations
  • Improved user security with automatic password expiration and CSV-based temporary password assignment
  • Updated USPS address validation integration
  • Quality and reliability improvements across accounting, purchasing, inventory, and receiving modules

New Features - 26.4

  • Granular Import/Export access rights. A new set of 114 individual access rights has been added — one for each import and export operation — giving administrators the ability to allow or deny specific import and export operations per user group. The existing Import/Export-View access right continues to control visibility of the Import/Export menu item. All existing user groups are automatically granted the new rights via migration to maintain backward compatibility.
  • Inventory: Require Notes on Quantity Adjustments and Inventory Moves. Two new module options have been added to the Inventory module that allow administrators to require users to enter a note when adjusting inventory quantities or moving inventory between locations. Both options are off by default. When enabled, users must provide a note before completing the action, creating a documented record for each inventory change.
  • Automatic user password expiration. A new option in the Users module allows administrators to enable automatic password expiration. When enabled, a configurable expiration period (in days, defaulting to 30) is set, and users are prompted to reset their password at their next login after it expires. This improves password security for organizations that require periodic credential rotation.
  • Temporary password assignment via users.csv import. A new optional "Password" column has been added to the users.csv import format, allowing administrators to assign a temporary password when creating new users via CSV import. This field applies to new user creation only and cannot be used to reset passwords for existing users. This action is limited to the admin user.
  • USPS Address Validation update. The USPS address validation integration has been updated to work with the current USPS API. This feature, which allows users to validate shipping addresses on orders directly within Fishbowl, was previously non-functional due to changes made by USPS.
  • REST API: Part tracking data on GET Shipment. The GET Shipment endpoint now returns part tracking information on ship items when tracking data is present, matching the tracking details visible when viewing a shipment in the Fishbowl client.
    • GET /api/shipments/:id - Now includes a tracking object on each shipItem when applicable.

Fixes - 26.4

General

  • Resolved: Cost and price fields, line item totals, and order totals on Purchase Orders and Sales Orders now display correctly when the home currency is set to an Arabic currency (e.g., Kuwaiti Dinar, Iraqi Dinar, Omani Rial, Bahraini Dinar). Previously, values displayed using Eastern Arabic numerals instead of standard numerals, and order totals did not appear at all.
  • Resolved: Cycle counts that result in no quantity change (where the counted quantity exactly matches the system quantity) are now saved as records. Previously, zero-change cycle counts were discarded with no record retained, making it impossible to report on when an item was last counted or confirm its accuracy at that point in time.
  • Resolved: Transfer Order CSV imports now enforce UOM compliance for each line item. Previously, importing a Transfer Order via CSV allowed any unit of measure to be assigned, regardless of whether it was valid for the part, which could corrupt order, pick, and inventory records.
  • Resolved: Filtering when exporting via the CSV export wizard now works correctly. Previously, applying a filter in the export wizard would result in a blank error and no file was produced. Exporting without applying a filter was unaffected.

Purchasing and Receiving

  • Resolved: Outsourced Purchase Orders can now be reconciled even when one or more receivable line items do not yet have cost history. Previously, the absence of a cost history for any receivable line would prevent the entire receipt from being reconciled.
  • Resolved: Purchase Order CSV imports now preserve unit cost values with more than two decimal places. Previously, line item unit costs were incorrectly rounded to two decimal places during import, introduced in version 2026.1.
  • Resolved: The Receiving Data CSV import now assigns the correct billed unit cost when a single order line is received across multiple CSV rows. Previously, splitting one line into multiple receive lines resulted in each row receiving a different, incorrect calculated cost (e.g., $10.00, $2.00, $2.50, $3.33) instead of the correct value.

Accounting

  • Resolved: QuickBooks Desktop exports now correctly handle tax rounding when Canadian dollars are used as the home currency. Previously, the exported tax amount was rounded up by $0.01, causing a discrepancy between the payment recorded in Fishbowl and the invoice balance in QBD that required manual correction on each affected invoice.
  • Resolved: Credit returns on Sales Order lines for non-inventory parts now correctly reverse the COGS entry with a negative cost value. Previously, when duplicating a Sales Order and selecting "Credit Return," non-inventory line items retained a positive cost rather than posting a negative COGS, overstating cost of goods sold.
  • Resolved: When duplicating a Sales Order as a Credit Return, tax line items calculated by TaxJar and QuickBooks Online Automated Sales Tax are now correctly converted to negative amounts. Previously, these tax line items remained positive on the credit return, resulting in incorrect tax totals instead of properly reversing the original tax charges

​

MAR 23, 2026 - Advanced 26.3

Download - 26.3

Highlights - 26.3

  • Important Notice: MySQL 8.0 End of Life - Update Optional for Now - MySQL 8.0 will reach End of Life (EOL) in April 2026. After this date, Oracle will no longer issue security patches, bug fixes, or official support for MySQL 8.0. While we recommend upgrading to MySQL 8.4 LTS before the EOL date, this update is NOT required at this time. Fishbowl will continue to support MySQL 8.0 until the September 2026 release. You can safely use the standard auto-update process for version 2026.3 - it will maintain your current MySQL 8.0 installation. If you wish to upgrade to MySQL 8.4 now, see the "MySQL 8.4 upgrade" feature description below. For detailed upgrade instructions, visit: https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update
  • Important Notice: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
  • Important Notice: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.3. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.3 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
  • Important Notice: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.3.
  • Important Notice: Previously the Ebay plugin was not compatible with Java 21. This issue has been resolve and it is now fully functional.
  • Improved MySQL 8.4 update process
  • New Bi Report
  • Enhanced REST API with shipment and payment search functionality
  • Improved Sales Order flexibility with kit item type changes
  • Quality and reliability improvements across multiple modules

New Features - 26.3

  • MySQL 8.4 upgrade option (Optional). For customers who wish to upgrade to MySQL 8.4 LTS ahead of the September 2026 requirement, the Fishbowl installer now includes automatic MySQL 8.4 upgrade capability. This upgrade is completely optional for the 2026.3 release. Here's how it works:
    • Windows users with Fishbowl-installed MySQL 8.0: Simply run the full Fishbowl installer (not the auto-update) over your existing installation. The installer will automatically detect and upgrade MySQL 8.0 to MySQL 8.4.
    • Windows users with manually-installed MySQL: You will need to manually upgrade MySQL 8.4 first, then install Fishbowl Advanced 2026.3. The installer will provide instructions if it detects manually-installed MySQL 8.0.
    • MacOS and Linux users: You will need to manually upgrade MySQL to 8.4 first, then install Fishbowl Advanced 2026.3. The installer will provide upgrade prompts and instructions.
    • If you choose to stay on MySQL 8.0: Simply use the standard auto-update process for Fishbowl 2026.3. Your MySQL 8.0 installation will remain unchanged and fully supported. For detailed MySQL upgrade instructions, visit: https://help.fishbowlinventory.com/advanced/s/article/MySQL-Update
  • Fishbowl Payments (Powered by Run Payments). The integration has been updated to continue to help merchants save on credit card processing fees. When you process a payment, Fishbowl automatically sends detailed transaction information to the payment processor, including:
    • Order details like customer PO number, order date, and shipping information
    • Individual line items with product descriptions, quantities, prices, and product codes
    • Accurate tax and shipping amounts By sending this extra information, Fishbowl Payments helps you qualify for the lowest processing fees available for business-to-business transactions. The system automatically handles sending the additional data - you don't need to do anything different when taking payments.
  • Inventory Reorder Watchlist BI Report. A new standalone Inventory Reorder Watchlist BI Report has been added to the BI Reports module, providing detailed visibility into parts approaching or below reorder points with drill-down functionality to investigate specific part details, supplier information, and inventory levels across locations to help prevent stockouts and optimize inventory management. Click here to learn more.
  • Sales Order kit item type flexibility. A new Sales Order module option "Allow changing kit item types" enables users to change the item type (Sale, Credit Return, Drop Ship) for kit items that have been added to a Sales Order. This option is unchecked by default to maintain backward compatibility. When enabled, users can modify kit item types both inline and in the item edit screen, providing greater flexibility for managing inventory status changes.
  • Enhanced auto-update options. A new "Never notify or update automatically" option has been added to the Server Administration page auto-update settings. When selected, Fishbowl will neither notify users about new updates nor automatically update the software, providing complete control over the update process for organizations with strict change management policies.
  • REST API shipment management. The REST API now includes new shipment functionality:
    • GET /api/shipments/:id - Retrieves details of a specific shipment by ID with location group access validation
    • POST /api/shipments/:id/pack - Changes shipment status from Entered to Packed, with validation to prevent packing already packed or shipped orders
    • Search functionality - Returns paginated lists of shipments based on filter criteria with proper access rights checking
  • REST API payment search. The REST API now supports searching for payments with the ability to return paginated lists of payments based on filter criteria. Documentation has been added to the Payments section of the REST API docs with proper access rights checking.
  • REST API product search. The REST API now supports searching for products with the ability to return paginated lists of products based on filter criteria. Documentation has been added to the Products section of the REST API docs with proper access rights checking.
  • Updated Remote Assist link for AU databases. Australian database users accessing Help > Remote Assist are now redirected to the correct remote support page (https://apac.fishbowlinventory.com/s/remote-assist/) instead of the booking support page.

Fixes - 26.3

Sales

  • Resolved: Kits containing both standard type kit items and variable quantity type kit items can now be added to Sales Orders with the variable quantity item set to 0, as long as at least one standard kit item has a quantity greater than 0. Previously, the system incorrectly displayed an error stating "Invalid Qty: Kit must have at least one item in the kit" even when standard items were present.
  • Resolved: Sales Order totals now display correctly when the home currency is UAE Dirham or other non-US currencies. Previously, total values at the bottom of orders would not display, though line item unit prices displayed correctly.

Payments

  • Resolved: Fishbowl Payments (Powered by Run Payments), The payment window has been resized to ensure all three payment options (Card Present, Manually Entered (Send to Payment Terminal), and Manually Entered) are visible when connected to a payment terminal, eliminating the need to manually stretch the window.
  • Resolved: CloverConnect card processing via terminal continues to function properly after removal of outdated port numbers from integration URLs.

Manufacturing

  • Resolved: BOMs with notes can now be properly deleted from partially fulfilled Manufacturing Orders without requiring Knowledge Engineer or Support assistance. Previously, attempting to delete BOMs with notes would generate a null error.

Purchase

  • Resolved: When the "Update vendor cost on issue" Purchase Order module option is unchecked, vendor costs are no longer incorrectly updated when issuing orders. Additionally, when multi-currency is enabled and vendor costs are updated, the calculations are now accurate. Previously, changing the currency conversion rate on a Purchase Order could incorrectly update vendor last costs with wrong values for both home and foreign currencies.
  • Resolved: Purchase Order totals now display correctly when the home currency is UAE Dirham or other non-US currencies. Previously, total values at the bottom of orders would not display, though line item unit prices displayed correctly.

Accounting

  • Resolved: QuickBooks Online can again create new currencies when exporting from Fishbowl if they don't already exist in QuickBooks Online. Previously, exports would fail with an "Operation could not find resource for entity companycurrency is not supported" error when a currency existed in Fishbowl but not in QuickBooks Online.
  • Resolved: Xero exports now properly handle part cost journal entries when class tracking (categories) is enabled. Previously, exporting part cost changes would fail with a null error because journal entries did not have a class/category assigned and the system was incorrectly validating these entries.


​

FEB 19, 2026 - Advanced 26.2

Download - 26.2

Highlights - 26.2

  • Important Notice: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
  • Important Notice: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.2. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.2 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
  • Important Notice: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.2.New and updated Business Intelligence Dashboards with enhanced data visualization
  • Expanded Server Administration capabilities for remote management
  • Enhanced REST API for improved performance
  • Outsourced Purchase Orders now support parts with tracking
  • Quality and reliability improvements across multiple modules

New Features - 26.2

  • New Business Intelligence Dashboards. Two new and three updated professionally-designed BI Dashboard reports are now included by default both as Dashboards and in the BI Reports module, providing powerful data visualization and decision-making tools:
    • New Production Scheduling Module - Manufacturing order planning and scheduling optimization featuring an interactive calendar view where manufacturing orders can be moved and rescheduled by dragging and dropping, plus drill-down functionality for detailed work order analysis. Click here to learn more.
    • New Company Dashboard - High-level company performance overview with drill-down capabilities across multiple business areas for deeper insights. Click here to learn more.
    • Updated Sales Dashboard - Comprehensive sales performance metrics and trends with drill-down functionality to explore detailed order and customer information. Click here to learn more.
    • Updated Purchasing Dashboard - Purchase order tracking and vendor performance analysis with drill-down capabilities to view detailed purchase order and vendor data. Click here to learn more.
    • Updated Inventory Dashboard - Real-time inventory reorder watchlist and stock management with drill-down options to investigate part-level inventory details. Click here to learn more.
    • Note: These new BI Dashboard reports must be granted as user rights in the User Group module for users to view them. Each Dashboard has its own unique user right under the access tab and the Bi Reports tab. Administrators should review and assign appropriate access rights to users who need access to these dashboards.
    • Note: If you prefer the previous dashboard experience, you can easily switch back to the Classic Dashboards through the Dashboard customization settings in the Settings module. See the Dashboard customization settings feature description below for more information.
  • Dashboard customization settings. A new "Dashboards" tab has been added to the Settings module, allowing administrators to customize the default dashboard experience for each dashboard module. Users can select between Classic Dashboards (maintaining the appearance of the Dashboards from version 26.1) or any available BI Report. This means that Bi Reports can be edited or created in the Bi Editor and then selected as a default for the following modules (Click here to learn more):
    • Inventory Dashboard
    • Sales Dashboard
    • Purchasing Dashboard
    • Manufacturing Dashboard
    • Production Scheduling Dashboard
    • Company Dashboard
  • Dashboard module rename. The existing Dashboard module has been renamed to "User Dashboard" to distinguish it from the new Company Dashboard in the General module group. The User Dashboard can be customized by each individual user and the Company Dashboard is a company wide dashboard.
  • New Server Administration Module. The Server Administration module now includes powerful remote management capabilities previously only available when directly logged on to the Fishbowl Server(Click here to learn more):
    • Active Connections management - View all connected users with their name, last activity, and client type. Administrators can refresh the user list, log off selected users, and send messages to connected users directly from this module in the client.
    • Connection settings - Configure Client Inactivity Timeout and enforce single-login restrictions (users can only be logged in once).
    • Server restart capability - Restart the Fishbowl Server directly from the Administration module with configurable delay periods to give connected users adequate warning. This feature requires a new "Restart Fishbowl Server" user right (granted to the admin user only by default).
  • Outsourced Purchase Orders with part tracking. Parts with tracking (including Lot Numbers, Expiration Dates, Serial Numbers, and custom tracking types) can now be used on outsourced Purchase Orders. This enables manufacturers who outsource production operations to maintain full traceability throughout their outsourced manufacturing process without being forced to remove tracking from parts.
  • Automatic backup retention management. Scheduled database backup tasks now support automatic deletion of old backup files. Administrators can configure a retention period (in days) to automatically clean up backups older than the specified threshold, preventing disk space issues without manual maintenance. Setting the value to 0 disables automatic deletion. Create a new or edit your existing Database Backup scheduled task to enable this feature. Default setting is set to 0. Click here to learn more.
  • Enhanced Fishbowl Payments (Powered by Run Payments) card entry. When connected to a Run Payments card processing terminal, users now have more flexibility for card not present transactions. A new "Manually Entered" option allows credit card information to be entered directly into the client through the Run Payments iFrame for faster processing, while the existing functionality has been renamed to "Manually Entered (Send to Payment Terminal)" for sending payment processing to the card terminal. Card Present remains the default option.
  • REST API memo endpoints. The REST API now supports full memo management for Sales Orders, Parts, and Products with the following new endpoints:
    • getMemoList - Retrieves a list of all memos associated with a specific Sales Order, Part, or Product
    • getMemo - Retrieves details of a single specific memo by its ID
    • deleteMemo - Removes a memo from a Sales Order, Part, or Product
    • updateMemo - Modifies the content of an existing memo
    • createMemo - Adds a new memo to a Sales Order, Part, or Product

Fixes - 26.2

Fishbowl Payments (Powered by Run Payments)

  • Resolved: QuickBooks Online automated sales tax is now properly included in Run Payment Links. Previously, QBO estimated tax amounts appeared correctly on the Sales Order and in the manual payment screen but were not included in the payment link total.

REST API

  • Resolved: REST API performance and efficiency have been significantly improved for customers with large amounts of orders, customers, and parts. These improvements resolve Java heap space errors previously experienced by customers with larger datasets. The following enhancements have been implemented:
    • Replaced HttpURLConnection with the new HttpClient
    • Enabled HTTP/2 support
    • Removed JSON size limit for API requests
    • Improved file download memory efficiency
    • Eliminated unnecessary base64 encoding to decrease request sizes
    • Avoided double serialization
  • Resolved: REST API documentation for search endpoints now correctly indicates that all search filters are optional for Inventory, Location Group, Manufacture Order, Part, Purchase Order, UOM, User, and Vendor.
  • Resolved: REST API documentation links have been updated from the old wiki URLs to the new help article URLs. All "Related Guide" links now correctly redirect to the appropriate pages on the help site.
  • Resolved: The /api/products/:id/best-price endpoint documentation now correctly indicates that customerid is a required field, and optional parameters (uomId, date, and includePricingRules) are properly marked as optional.

Database Updates

  • Added "deleteBackupOlderThan" column to the fbschedule table. This new column enables the new automatic deletion of backups feature in the schedule module.

​

JAN 15, 2026 - Advanced 26.1

Download - 26.1

Highlights - 26.1

  • Important Notice: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 or later versions this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
  • Important Notice: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2026.1. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2026.1 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade beyond the 2025.9 release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
  • Important Notice: Custom Plugins are not supported in 2025.11 or newer versions. If you utilize any custom Plugins do not upgrade beyond 2025.9. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST or Legacy API's will continue to function on 2026.1.
  • Enhanced Fishbowl Commerce integration with channel-specific status mapping
  • Run Payments ACH-only integration option added
  • Quality and reliability improvements across multiple modules

New Features - 26.1

  • Fishbowl Commerce channel-specific status mapping. A custom scheduled script is now available that allows operations managers to override the status import behavior for specific e-commerce channels. This enables different status mappings depending on the channel, preventing the need for additional processing of orders. For example, if more than one channels orders are in shipped status in Fishbowl Commerce and is mapped to come in as issued to Fishbowl Advanced, the script can take one of those channels orders an fulfill them. The script takes two parameters: desired status ID and the channel name and runs via the schedule module to automatically perform the steps necessary for additional order processing. If you want to enable this feature reach out to our Support Department at 800-774-7085 ext 3.
  • Fishbowl Payments ACH-only support. The Fishbowl Payments integration now supports customers who only have an ACH Merchant ID (MID). When the service provider is integrated using only the ACH MID, only ACH payments are processed through Fishbowl Payments and only an ACH option appears on generated payment links.

Fixes - 26.1

General

  • Resolved: Users can now properly revoke access to the MyFishbowl Module through user access rights. Previously, all users could view the MyFishbowl Module regardless of access rights settings.
  • Resolved: The Part Activity Report tooltip for the Group By option now correctly describes the grouping functionality rather than showing the same tooltip as the Order By option.

Sales

  • Resolved: We have removed the Module Option for "Fulfill Flat Rate discounts with preceding line items on ship" from the Sales Order Module Options. This option will be included in a future release pending some additional development changes.

Purchasing and Receiving

  • Resolved: International customers using currencies with commas as decimal separators and vendor part number associations can now be added to Purchase Orders when multi-currency is enabled. Previously, these parts could not be added to a Purchase Order and the cost could not be changed in the vendor's home currency.
  • Resolved: Purchase Order CSV imports now enforce the same cost restrictions as the Fishbowl Client. Credit return type line items with positive costs are imported as negative costs, and purchase type line items with negative costs are imported as positive costs, preventing incorrect accounting exports.

Materials

  • Resolved: The "All Locations" option in the Part Module's MRP feature no longer assigns reorder points to inactive location groups. Inactive location groups are now excluded from MRP calculations.

Calendar

  • Resolved: The Calendar module in international databases now works correctly in all view modes (1 Day, 5 Day, and 7 Day views). Previously, orders would not display in 1 Day and 5 Day views, and selecting 7 Day view would cause an error that prevented other modules from loading requiring a restart of the Fishbowl Client to fix.

Advanced Search

  • Resolved: The Advanced Search popup window now properly displays cancel and search buttons at the bottom without requiring window resizing, specifically when many custom fields are present. The dialog now allows scrolling to accommodate a large numbers of custom fields in Part, Product, Customer, and Vendor modules.

Scheduled Tasks

  • Resolved: Scheduled tasks no longer remain stuck in queue requiring a server restart to run. Thread management issues related to the schedule module have been addressed, and timeouts have been added to Run Payments API requests to prevent tasks from hanging indefinitely.

Plugins

  • The Ebay plugin has been update to be compatible with Java 21 and is not fully functional


​

DEC 30, 2025 - Advanced 25.12.1

Download - 25.12.1

Highlights - 25.12.1

  • Important Notice: There is currently a bug with the new "Fulfill flat rate discounts with preceding line items" shipping module option where fulfilled discounts are not being transferred to Accounting. If you have previously updated we recommend disabling this module option in the shipping module to continue to fulfill discounts normally and transfer to accounting. This will be addressed with the January Release.
  • Important Notice: If you are upgrading from version 2025.9 or older then this upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button. If you are upgrading from 2025.11 to 2025.12 this update follows the normal upgrade process supporting auto updating of the server by simply checking for updates.
  • Important Notice: Fishbowl 2025.12 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2025.11 and newer. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: The SPS Commerce integration is now fully compatible with the 2025.12 release. The timestamp formatting issues that affected the 2025.11 release have been resolved.
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2025.12 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade to the 2025.12 (Java 21) release. We will have Fishbowl Anywhere included in an upcoming release but will provide additional information once available.
  • Important Notice: The Ebay plugin is not currently working with 2025.12 (Java 21) release. If you utilize the Ebay plugin its recommended to wait to update to 2025.12 or migrate to Fishbowl Commerce which does support the Ebay integration.
  • Important Notice: Custom Plugins are not supported in 2025.12 or newer versions. If you utilize any custom Plugins do not upgrade to 2025.12 or newer. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST API or Legacy API will continue to function on 2025.12.
  • Java 21 compatibility improvements with critical fixes for payment processing integrations and timestamp handling across multiple modules.
  • Enhanced payment processing with improved synchronization for Payment Links and card-present transactions, plus critical Authorize.net integration fixes.
  • Quality and reliability improvements across Sales Orders, Purchase Orders, CSV imports, Accounting, and user access rights.

New Features - 25.12.1

  • Fishbowl Payments enhancements. Three new improvements have been added to enhance payment processing:
    • Payment Links now automatically update when Sales Order pricing changes, ensuring customers always pay the correct amount without manual intervention by sales representatives.
    • Payment Links can now be generated for Sales Orders in Estimate status allowing for receipt of payment before issuing the order to the warehouse
    • Card-present transactions now include the Invoice ID (Sales Order number) in the Run payment portal, providing better transaction tracking and reconciliation.
  • Important Notice: The following feature currently has a bug where fulfilled discounts are not being transferred to Accounting. If you update simply disable this module option in the shipping module to continue to fulfill discounts normally and transfer to accounting.
    • New Sales Order discount fulfillment option. A new module option has been added to the Shipping module to give users control over flat-rate discount fulfillment behavior. The "Fulfill Flat Rate discounts with preceding line items on ship" checkbox allows flat-rate discounts to fulfill automatically when the line item above them is fulfilled, matching the behavior of percentage discounts and providing more flexibility in order fulfillment workflows.

Fixes - 25.12.1

General

  • Resolved: User access rights now properly restrict editing capabilities for users with View-only permissions. Users with Part-View access rights can no longer modify the Part URL field, and users with Purchase Order-View access rights can no longer add items to Purchase Orders.

Sales

  • Resolved: Sales Orders linked to Manufacturing Orders with BOMs set to Short Quantity can now be edited and saved without encountering blank error messages.
  • Resolved: Flat-rate discounts can now be configured to fulfill automatically when the preceding line item is fulfilled. A new module option "Fulfill Flat Rate discounts with preceding line items on ship" in the Shipping module allows flat-rate discounts to match the fulfillment behavior of percentage discounts.

Accounting and Integrations

  • Resolved: Authorize.net payment integration now functions properly following the Java 21 upgrade.
  • Resolved: QuickBooks Online integration now provides clear error messaging when payment terms contain unsupported characters. When attempting to export orders with payment terms that include ampersands (&) or other special characters, the system now displays: "The Payment Terms used on orders attempting to export to Accounting have unsupported characters. Please update the Payment Terms names in the Payment Term module to remove any invalid character such as "&" or "#""
  • Resolved: Xero tax code imports no longer fail due to typeCode length limitations. The typeCode field has been expanded from 25 to 50 characters to accommodate longer values generated by Xero's Auto Tax feature powered by Avalara.

CSV Imports and Exports

  • Resolved: CSV imports with date columns containing timestamps now process successfully. Date formats that include time values (e.g., "05/21/2024 12:00:00AM") are once again accepted, restoring compatibility with SPS Commerce and other systems that export dates with timestamps.
  • Resolved: Customer CSV imports now properly handle the TaxExempt field when set to FALSE. Importing a customer with TaxExempt set to FALSE now clears the TaxExemptNumber from the database, matching the behavior of the Fishbowl Client user interface and preventing confusion when re-exporting customer data.

Fishbowl Payments

  • Resolved: Payments made using Payment Links now sync properly back to Sales Orders in Fishbowl, ensuring accurate payment tracking and reconciliation.
  • Resolved: Payment Links no longer create duplicate payment records when syncing back to Fishbowl. The payment import process now properly validates TransactionIDs to prevent duplicate entries and ensures that declined transactions are not imported.
  • Resolved: Card-present transactions processed through Run now include the Invoice ID (Sales Order number) in the transaction details, improving traceability in the Run payment portal.

Reports

  • Resolved: The Customer Purchase History report now correctly displays discount items. The "discount items" option in the report properly shows both dollar and percentage discounts applied to sales orders.

​

NOV 14, 2025 - Advanced 25.11

Download - 25.11

Highlights - 25.11

  • Important Notice: The Fishbowl 2025.11 update will require plugins to be updated on the Fishbowl Server. Please see the update guide for more information.
  • Important Notice: Fishbowl 2025.11 and newer versions no longer support MySQL 5.7: If you are still running MySQL 5.7 we recommend migrating to MySQL 8.0 before upgrading to 2025.11 and newer. Follow the instructions here to migrate to MySQL 8.0: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-MySQL-Migration
  • Important Notice: We are unable to support the Fishbowl Anywhere plugin as part of the 2025.11 (Java 21) release. If you are actively using Fishbowl Anywhere, you should not upgrade to the 2025.11 (Java 21) release. We hope to have this included as part of the 2025.12 release but will provide additional information once available.
  • Important Notice: Custom Plugins are no longer supported with the release of 2025.11. If you utilize any custom Plugins do not upgrade to 2025.11 or newer. Note that custom integrations are different than custom Plugins. Custom integrations that utilize the REST API or Legacy API will still continue to function on 2025.11.
  • Important Notice: This upgrade requires a coordinated installation process. The Fishbowl Server must be updated manually first, followed by client updates. The Fishbowl Client will automatically detect version mismatches and guide users through the update process with a simple "Automatically update your Fishbowl Client" button.
  • Important Notice: The SPS Commerce integration is not compatible with the 2025.11 (Java 21) release due to timestamp formatting changes. If you are actively using the SPS Commerce integration, you should not upgrade to 2025.11. A fix for the SPS Commerce integration will be included in the 2025.12 release.
  • Important Notice: The Ebay plugin is not currently working with 2025.11 (Java 21) release. If you utilize the Ebay plugin its recommended to wait to update to 2025.11 or migrate to Fishbowl Commerce which does support the Ebay integration.
  • Java 21 upgrade with improved performance, security, and compatibility. See our Java 21 update guide: https://help.fishbowlinventory.com/advanced/s/article/Fishbowl-Advanced-Java-21-Update
  • Improved client update experience for Java 21 upgrade
  • Quality and reliability improvements across multiple modules
  • Improved demo database functionality for international regions

New Features - 25.11

  • Java 21 upgrade. Fishbowl Advanced 2025.11 includes a major upgrade to Java 21, bringing significant improvements to the platform:
    • Enhanced performance for faster application responsiveness
    • Improved security to protect your data
    • Better compatibility with modern operating systems and hardware
  • Fishbowl Payments enhancements. Two new features have been added to the Fishbowl Payments module to give users more control over payment processing:
    • A "Run Import Task" button has been added to the settings tab, allowing administrators to manually sync payments on demand. When clicked, the payment import task is queued to run immediately, enabling faster shipment processing.
    • Payment download scheduling now offers finer grain control with hourly sync options. Users can specify the number of hours between syncs (e.g., 1 for every hour or 6 for every six hours) to match their business needs.
  • Customer module options for Customer Module. New module options have been added to the Customer Module to control the "To be printed" and "To be emailed" checkboxes for customers created through clicking on the New button, Plugins, or CSV imports. When enabled, these options set the default behavior for new customer creation, providing better control over customer communication preferences across different import methods.
  • QuickBooks Desktop Nexus auto-close. The Nexus connector now automatically closes 10 minutes after connection timeout to prevent issues that occur when Nexus loses connection with QuickBooks Desktop after being left open for extended periods. This configuration can be overridden in the nexus.config settings file if needed.
  • Receiving Data .CSV Import. The receivingdata.csv import now fulfills items that were previously received in the client. Previously you either had to receive or fulfill items but could not receive first and then later use the import to fulfill already received parts.

Fixes - 25.11

General

  • Resolved: The Available to Build report has been updated with an improved version that significantly increases performance. Customers previously experiencing slow load times or reports that failed to run will now see excellent performance with this updated report.
  • Resolved: Converting character sets before database updates now properly handles compound keys during MySQL 5.7 to 8.0 database upgrades. Previously, collation errors could occur when updating views if bad values were part of compound keys.
  • Resolved: Converting character sets before database updates no longer causes collation errors when updating custom views during the migration from MySQL 5.7 to MySQL 8.0.
  • Resolved: Demo databases now have properly configured dates for existing orders. The Canadian demo database dates have been updated to align with current dates rather than being set far in the past.
  • Resolved: The Australian demo database's Auto SO Number system property is now properly initialized to prevent "This order number is already in use" errors when creating new sales orders.
  • Resolved: The default location group for the Australian demo database has been changed to Adelaide for the admin user. This prevents getting a message stating that inventory is not available when adding Products to Sales Orders.
  • Resolved: Multi-currency columns on the receiptItem table are now properly populated in demo databases, allowing pre-populated receipts to be successfully reconciled without errors.
  • Resolved: The Advanced Mobile plugin's "How To" button now correctly redirects to the proper help article URL.
  • Resolved: Demo databases no longer contain inventory log entries with future event dates, which previously prevented certain received parts from being voided.
  • Resolved: The duplicate serial number error message now displays correctly when attempting to add inventory with a duplicate serial number into the same location and location group.

Sales

  • Resolved: Variable kit items can no longer be added to Sales Orders with all items at zero quantity. If all kit items are set to zero quantity at the end of the kit wizard, an error message now displays: "Invalid Qty: Kit must have at least one item in the kit."
  • Resolved: Editing or adding a memo to an expired Sales Order no longer automatically resets the Date Expires field and Status. Users are now prompted with the option to reopen the Sales Order when saving changes. If they choose not to reopen, the order remains in Expired status.
  • Resolved: Multi-Currency Total tax was not rounding properly in some cases causing discrepancies between the Sales Order Module and Sales Order and Invoice Report.

Purchasing and Receiving

  • Resolved: The Unit Cost displayed in the Receiving screen now correctly shows the PO line cost when Vendor Cost Rules exist with UOM conversion, rather than incorrectly displaying the Vendor Cost Rule value.
  • Resolved: The Receiving module's Reconcile Order wizard now properly handles Transfer Orders when the "Require bill date for reconcile" module option is enabled. Since Transfer Orders do not require bill dates, the wizard no longer errors when this option is turned on.
  • Resolved: The Date Entry Tolerance warning no longer incorrectly appears when navigating between tabs on fulfilled Purchase Orders with dates outside the tolerance range. Additionally, clicking the calendar button after dismissing the warning now properly opens the calendar picker.

Accounting and Integrations

  • Resolved: QuickBooks Online integration now properly handles home currency validation in multi-currency databases. The integration has been updated to accommodate QuickBooks Online's change in how they provide currency information through their API.
  • Resolved: Reconciling Purchase Orders using the "Quantity" setting to distribute landed costs now properly rounds values, preventing "Please balance your debits and credits" export errors caused by penny-rounding discrepancies.
  • Resolved: The "Amounts Include Tax" checkbox in the Purchase Order module has been adjusted to match the Sales Order module and is now limited to the checkbox size, preventing accidental toggling when clicking nearby areas.
  • Resolved: Avalara tax estimates now remain available when taking payment throughout the entire order process, including after items have been picked on the Sales Order.

CSV Imports and Exports

  • Resolved: Data module CSV exports now include quotes around data values, making them consistent with scheduled task exports and compatible with systems like Salesforce that require quoted values for imports.
  • Resolved: Product CSV imports no longer require a default carton type when only a carton count is specified, matching the behavior of the Fishbowl Client User Interface where carton counts can be added without carton types.
  • Resolved: Sales Order Details CSV imports in international (non-US) databases now properly ignore the order tax rate when left blank and only import line item tax codes, matching the behavior of the standard Sales Order .csv import.
  • Resolved: The Part-Product-Vendor-Purchase export (PPVP) when filtered by vendor now completes in a reasonable time even in databases with 600,000+ parts, improving from over an hour to approximately 2 minutes.

Fishbowl Payments

  • Resolved: Payments made using Payment Links were not properly syncing back to the Sales Order in Fishbowl

Reports

  • Resolved: The Available to Build report has been updated with improved performance and can now handle databases with large amounts of staged BOMs. Customers who previously experienced timeouts or were unable to run the report will now see significantly faster results.
  • Resolved: The Sales Order Report now correctly displays the appropriate currency symbol (e.g., pounds in UK databases) for line item Total Price fields rather than always showing the dollar symbol.

​

SEP 16, 2025 - Advanced 25.9

Download - 25.9

Highlights - 25.9

  • Run Payment integration now supports payment links
  • Improved client update experience for upcoming Java 21 update in November
  • Quality and reliability improvements

New Features - 25.9

  • The Run Payments integration now supports payment links. When integrated with run payments, users can now easily create and send payment links to customers allowing them to easily pay any invoices.
  • Card present (EMV) transactions with supported Run Payments hardware now supports saving Card on File for future payments.
  • Starting with 25.9, the Java update process has been simplified in preparation for the November release of Java 21.
    • The Fishbowl Client will check if its Java version matches the Fishbowl Server. If a mismatch is detected, users can simply click on the button "Automatically update your Fishbowl Client" which will automatically install the update with the correct Java version.
    • The Fishbowl Server will check during update if a Java update is required and notify the user. Users will be presented with a button to "Download Fishbowl" which will download the appropriate Fishbowl version to the downloads folder. Simply run this install over the top of the existing installation to get the latest version of both Fishbowl Server and Java.
  • An option to "Convert Character Sets" has been added to the Database Administration Pages, right click, options menu. This new option can help in cases where data migration issues can occur when migrating from MySQL 5.7 to MySQL 8.0. Simply right click the database that you want to apply the fix to and click "Convert Character Sets." If any data changes occur they will be output to a file for review.

Fixes - 25.9

General

  • Resolved: The Database Migration tool, used to updated from MySQL 5.7 to MySQL 8.0, was erroring out due to additional constraints in MySQL 8.0. The Database Migration Tool now automatically checks for this condition, applies a fix, and outputs a file with any data changes that may have been necessary for successful migration.
  • Resolved: The Vendor Parts CSV import was not requiring a vendor part number. This caused issues with Purchase Orders where the Module Option "Only show vendor parts in drop-down filter" was selected causing no parts to show up in drop-down.
  • Resolved: Several How To links were not directed to the right How To pages and have now been updated.

Sales

  • Resolved: In some circumstances customer numbers were creating constraint errors because the auto increment number was set above the auto increment number limit.
  • Resolved: Multi-Selecting and then starting picks was not correctly setting the "To be printed" checkbox on picks.

Integrations

  • Resolved: Clicking the button to integrate with Run Payments, while currently integrated with a different service provider, was not automatically removing the existing payment integration as expected.
  • Resolved: The feature for Amount Includes Tax was not properly calculating tax when the item edit menu was opened and modified on the Sales Order.

​

AUG 27, 2025 - Advanced 25.8

Download - 25.8

Highlights - 25.8

  • Run Payments is now integrated into Fishbowl Advanced enabling card not present, card present, ACH transactions.
  • Stability improvements for the Mac version of Fishbowl Advanced

New Features - 25.8

  • Run Payments is now part of the Fishbowl Payments module. This new integration enables:
    • Card not present transactions
    • Card present (EMV) transactions with supported Run Payments hardware. This feature supports swipe, chip, and tap to pay type payment methods. Note that Card on File is not supported for this method at this time.
    • Automated Clearing House (ACH) transactions enabling bank or credit union transfers
    • Refunds
    • Card on File or stored payments for repeat transactions
    • More to come (including the Payment Links feature) with our upcoming September release
  • The Fishbowl installer now supports command line installation which removes the need for user input when installing Fishbowl

Fixes - 25.8

General

  • Resolved: Display issues with where drop down boxes and error messages were appearing behind the main screen now appear in their proper order. This mainly affected Mac users of the software.
  • Resolved: The Mac installer now properly distributes the Java Runtime Environment (JRE) for Fishbowl instead of requiring its own separate standalone installation.
  • Resolved: Fishbowl's embedded web browser (JxBrowser) has been updated to 7.43.7. This update provides multiple security improvements and ensures the continued stable operation of this feature.
  • Resolved: Importing multiple CSV files concurrently would occasionally cause price discrepancies on Sales Orders. This issue primarily affected the integration with Fishbowl Commerce and its parallel import feature.
  • Resolved: The Bill of Materials CSV import allowed negative quantities on raw goods which prevented the fulfillment of associated Sales Orders and displaying a error message that the quantity cannot be negative.

Sales

  • Resolved: Sales Orders with Similar number such as FB-123 and FB_123 would cause a Duplicate Ship error when finishing the pick of the second order.

Reports

  • Resolved: The Turnover Report was displaying odd characters in some circumstances based on the result of a calculation on the report.
  • Resolved: The Work Order Flag Report was not displaying all work orders when utilizing a combination of available, receivable, or pickable settings for locations.

Accounting

  • Resolved: The How To buttons link in the Accounting module was not linking to the correct help page on the Fishbowl website.

Integrations

  • Resolved: The Payment Gateway module has been renamed to the Fishbowl Payments module.
  • Resolved: The Gateway tab of the Fishbowl Payments module has been renamed to be the Service Providers tab.
  • Resolved: The parallel import feature of the Fishbowl Commerce plugin would duplicate customers in some instances.
  • Resolved: Removing Clover Connect from the Fishbowl Payments module was not properly handing removal of payment device settings complicating integration with a different Service Providers hardware.

​

JUL 16, 2025 - Advanced 25.7

Download - 25.7

Highlights - 25.7

  • New workflow optimization for printing Picks
  • Compatibility improvements for Hot Keys on all operating systems.

New Features - 25.7

  • A new To Be Printed checkbox and advanced‑search filter help to identify pick tickets that still require printing, preventing duplicate printouts.
    • Starting a pick and printing it will automatically remove the to be printed checkbox.
    • Utilize the the Advanced Search feature in picking to see a list of picks that still need to be printed.
  • Fishbowl Hot Key changes. Previous hot key combinations (Command + Q) caused the Fishbowl application to quick. Hot keys have now been made more universal for all operating systems.
    • Sales Orders Quick Fulfill command has been changed from Ctrl + Q and Cmd + Q to Ctrl + F and Cmd+F
    • Transfer Orders UnRequest command has been changed from Ctrl + Q and Cmd + Q to Ctr + R and Cmd + R
    • Checkouts Checkout command has been changed from Ctrl + Q and Cmd + Q to Ctr+F and Cmd+F  

Fixes - 25.7

Accounting and Integrations

  • Resolved: Associated price type line items were not exporting to QuickBooks Online and Xero.
  • Resolved: Re‑connecting Xero no longer clears custom account mappings; the Account Mapping report opens without errors.
  • Resolved: Debits and Credits for Work Orders were not posting properly when using Standard Costing as a costing method.

Sales and Customers

  • Resolved: In one scenario users could change a customer’s currency even when historical orders existed.

Purchasing and Receiving

  • Resolved: The Receiving screen was not refreshing unit cost, subtotal and billed‑total immediately after a saving a Purchase Order edit.
  • Resolved: In one case Purchase Order was selecting the first line instead of the desired line when clicking on a line item.
  • Resolved: Transfer Orders containing a backslash (“\”) were erroring out on the Receiving screen.
  • Resolved: Reconciliation was giving an error when affecting Work Order adjustments for work orders that utilized non-inventory type finished goods.

Manufacturing

  • Resolved: Deleting a line item on a Sales Order would sometime leave an associated Manufacture Order open in the wrong status.
  • Resolved: Required custom fields on Work Orders are now enforced on any Manufacturing Orders created from them.
  • Resolved: Manufacturing Orders auto‑created from Sales Orders were not populating checkbox type custom fields appropriately. This negatively affected utilizing the Advanced Search Function in the Manufacture Order Module.

Reports

  • Resolved: The Available to Build report was not properly calculating when the selected Bill Of Material included stages.

Database Updates

  • Added a "toBePrinted" column to the pick table to better enable Pick Ticket printing

​

JUN 17, 2025 - Advanced 25.6

Download - 25.6

Highlights - 25.6

  • New Packing Slip Report options
  • Enhanced Tab navigation feature

New Features - 25.6

  • Open module tabs can now be rearranged by simply clicking and dragging the module tab to the location desired helping to organize your workflow.
  • A signature collected at the time of delivery can now be saved for external documentation purposes even after the order has been shipped.
  • Editing Transfer Order line items can now be done in-line on transfer orders reducing clicks needed to make simple edits.
  • New Packing Slip report options have been added giving a wider selection of Packing Slips to choose from with enhanced layouts and colorized options.
    • Packing Slip Colorized V1 Report: Light Blue color scheme
    • Packing Slip Colorized V2 Report: Green color scheme
    • Packing Slip Colorized V3 Report: Dark Blue color scheme
    • Packing Slip Landscape Report
    • Packing Slip Landscape Colorized Report: Light Blue color scheme

Fixes - 25.6

General

  • Updated JxBrowser to version 7.43.0
  • Resolved: In some cases special characters were corrupted when restoring a database backup.
  • Resolved: Updating a Fishbowl Client while still logged in would not properly logout the user.
  • Resolved: The Product CSV import was not properly capturing date created not captured when creating new products.

Materials

  • Resolved: Transfer Order Memos could not be created or updated after a Transfer Order was fulfilled.

Sales Order

  • Resolved: When utilizing the "Amount includes tax feature" total prices were not rounding appropriately.
  • Resolved: An issue where the checkbox for the feature "Amounts Include Tax'" extended beyond the checkbox resulting in some accidental selections.
  • Resolved: The duplicate function on Sales Orders was keeping the original "Created by user" instead of the user duplicating the order.
  • Resolved: Shipping - Qty on the line in shipping changes after order has shipped, edit to address causes it to update.

Shipping

  • Resolved: Serial number duplication on a tracking table was preventing some Sales Orders from being shipped out resulting in an error stating"Invalid number of serial numbers: Found: X Expected: X"

Purchasing

  • Resolved: The reconcile wizard was rounding costs with more than two decimal places to $.01 causing the vendor last for that part to update with the rounded cost. This would cause the next Purchase Order places for that item to be inflated.
  • Resolved: The Auto PO function was not properly capturing demand for all location groups when using the No ROP/OUL checkbox and setting Reorder Points to be by location.
  • Resolved: Fishbowl Payments was requiring a bill to address for all payments regardless of settings.

Reports

  • Resolved: The Packing Slip Report was not properly applying all parameters selected in the Customize Report options.

Database Updates

  • New Table Added "Accounting Export Log" which records any export activity and outputs the result. Is useful in understanding if the accounting integration returned an error, if repost, or a mark as posted was attempted.
  • New Table Added "Accounting Export Type" utilized in conjunction with the Accounting Export Log table to specify Standard Export, Repost, or Mark as posted.

​

MAY 20, 2025 - Advanced 25.5

Download - 25.5

Highlights - 25.5

  • Continued focus and prioritization addressing key issues that highly impact users
  • Server and Client Time Zone Synchronization

New Features - 25.5

  • Server Time Zone can now be synced with the Fishbowl client to aid in date accuracy and advanced search utilization
  • New REST API Endpoints for Sales Orders
    • Search, Issue, Unissue, Cancel, Close Short, Close Short Line Items
  • Purchase Order line items can now be split to facilitate efficiency while creating bulk orders.
  • Multi-Factor Authentication (MFA)
    • General login workflow has been enhanced with a "Trusted Devices" option on the login screen. Checking this reduces the amount of times needed to obtain a code when using trusted devices.
    • Administration level control has been added to allow the admin user to reset MFA when necessary
  • The QuickBooks Online API has been updated to the latest version ensuring continued operation and allowing further updates to the QuickBooks Online integration.
  • The Packing Slip has be enhanced
    • Now optimized to run more efficiently
    • Added ability to "Show Kit Headers Only" simplifying the display of kits down to just the essential information
  • New Reports have been added to Fishbowl to improve usability
    • Sales Order Report with Special Characters. A new version of the Sales Order Report now shows special characters, such as non-english languages
    • Shipping Invoice Report with Special Characters. A new version of the Shipping Invoice Report now shows special characters, such as non-english languages
    • Pick Report with Special Characters. A new version of the Pick Report now shows special characters, such as non-english languages
    • Part Barcodes by Location Avery. The report prints part a single barcode for every part within a selected location. This simplifies the initial generation of barcodes for warehouses that have never used barcodes before.

Fixes - 25.5

General

  • Resolved: Computers set to utilize a language other than english could not issue orders

Materials

  • Resolved: Average cost used for scrap adjustment amount after reconciling cost on FIFO databases in some scenarios

Sales Order

  • Resolved: Sales Order over picking was not utilizing UOM conversions when the Part's option to "Pick in part UOM only" was checked
  • Resolved: Sales Order.csv import when utilizing multi currency assigning wrong currency for tax type items

Reports

  • COGS By Account Summary was only showing "Use Default" instead of the actual default account name.
  • Dormant Customers was not properly displaying custom fields when the option was selected
  • 2x4 Part Barcodes was displaying an option to show price
  • 4x6 Part Barcodes was displaying an option to show price
  • Bill of Lading was not properly applying unit of measure conversions when calculating weight
  • Work Order Forecast Report was utilizing the wrong date field causing wrong calculations in certain circumstances
  • Part Committed Report was not showing the correct unit of measure for credit return type Purchase Order items.
  • Production Demand Report was showing inconsistent data causing certain work orders to be missing from the report
  • Outstanding Work Order Report date range was not properly formatted when selecting "All" for the date range
  • Part Allocated Report was not showing in transit location inventory properly
  • Batch Packing Slip by Date was showing null where length, width, and height header should be
  • Shipping Invoice Report was showing null where length, width, and height header should be
  • Work Order Traveler Report was not removing columns from raw goods area when they were unchecked from the columns tab.
  • Work Order Summary Report showed issued as a selectable status even though that status does not exist for work orders
  • Item History Report is not showing totals on the first page when the report spans multiple pages
  • Sales Dashboard's Ordered Products field was including voided, canceled, and closed short items from a Sales Order

Xero

  • Resolved: Items with tracking that were picked and packed separately were causing the export error "Line total does not match" in some cases
  • Resolved: Discount items were being sent to the wrong accounts in Xero.

​

APR 16, 2025 - Advanced 25.4

Download - 25.4

Highlights - 25.4

  • Continued focus and prioritization addressing key issues that highly impact users
  • Enhanced Standard Reports
  • New Sales Order Feature allows over picking on Sales Orders
  • New REST API endpoint

New Features - 25.4

Enhanced Reports

  • Packing Slip
    • Dimensions have been added for each carton including Length, Width, High
  • Receiving List
    • Added shipment tracking number to help when receiving blanket Purchase Orders
    • Added Vendor Name to report details
  • Manufacture Order and Work Order Traveler reports
    • Page numbers are now sequential when printing multiple Work Orders for the same Manufacture Order
  • Adjustment Report
    • A new checkbox has been added to the modify report options to "Show Posted" transactions
    • Updated the date parameter to increase report data accuracy
  • Work Order Flag
    • Added part description to shortage summary section of the report
    • Added page numbers to the shortage summary section of the report

Sales

  • Over Picking on Sales Orders is now possible. This feature will allow you to pick more than was on the original Sales Order and once picked will update the Sales Order with the new quantity.
  • The Customer alert notes field has been expanded from 256 character limit to 1,024 allowing more space to store critical notes, comments, or warnings for Sales and Warehouse teams.

REST API

  • A new endpoint has been added, Get SO by ID, which allows you to retrieve Sales Order information utilizing the Sales Order ID

Fixes - 25.4

General

  • Resolved: Quantity Discrepancies between tables would cause a PartCostID Error when consuming or reconciling inventory

Sales

  • Resolved: Multi-currency rounding discrepancies were occurring when using discounts on Sales Orders

Purchasing

  • Resolved: Receiving Data CSV import was unable to partially receive items. It was automatically fulfilling remaining items.

Accounting

  • Resolved: Xero multi-currency taxes were calculated incorrectly when exported to Xero
  • Resolved: QuickBooks Online Blank notes going over by themselves caused a "Required parameter" export error
  • Resolved: QuickBooks Online Partially fulfilled Sales Orders with percentage discounts produced an "Amount not equal to unit price" export error

Manufacturing

  • Resolved: Update error messaging when attempting to unissue a Manufacture Order with pick(s) in progress. The error message now lists which picks are in progress.
  • Resolved: Bills of Material with note type items could prevent deletion of a Sales Order even though its in entered status

API

  • Resolved: Legacy API call GetCustomerList returning wrong user for Salesperson when left blank on the Sales Order
  • Resolved: Legacy API call InvQtyRq removing trailing zeros on Lot Number tracking

Reports

  • Resolved: Customer Purchase History was not showing historical part numbers
  • Resolved: Shipping Invoice report was showing "null" for carton details on some Sales Orders
  • Resolved: Historical Part Cost report gives out wrong total cost when using FIFO/LIFO databases
  • Resolved: Part Cost Over Time was not filtering dates properly
  • Resolved: Sales Order Dashboard total including voided and cancelled orders
  • Resolved: Sales Order Dashboard top selling products quantities and prices were being improperly inflated
  • Resolved: Sales Order Dashboard did not reflect the proper home currency symbol


MAR 18, 2025 - Advanced 25.3

Download - 25.3
Highlights - 25.3
  • Continued focus and prioritization addressing key issues that highly impact users
  • New QuickBooks Online Sales Tax Feature
  • Updated My Fishbowl Portal
  • API Enhancements
New Features - 25.3
  • New integration with QuickBooks Online automated Sales Tax
    • Sales tax laws are complex, differ per state and are constantly in flux. We have partnered with QuickBooks to utilize their new Automated Sales Tax functionality. This new integration allows users to setup a single integration solve for multiple tax needs
  • New REST API Features. The following endpoints have been added to the REST API allowing for export of CSV's and their headers.
    • New API endpoint GET Export
    • New API endpoint Export Header
  • The My Fishbowl module has been updated to include new information
    • The new My Fishbowl page gives users access to information relevant to their company as well as access to support cases making it so you can see everything in one place.
  • The Ai Insights plugin is now installed automatically with every new Fishbowl install
    • Including the Ai Insights plugin with every install helps to streamline the setup process meaning less steps and less time waiting for it to install.
Fixes - 25.3

General

  • Resolved: Running the Fishbowl Server in console mode was not automatically activating license keys

Sales

  • Resolved: When two users were attempting to issue the same Sales Order in some cases it would cause duplicate picks
  • Resolved: When two users were attempting to pick the same Sales Order in some cases extra items were added to a shipment

Purchasing

  • Resolved: When two users were attempting to receive the same Purchase Order in some cases duplicate items would be received

Accounting

  • Resolved: Manufacturing Adjustment type Journal Entries were throwing an XML error or posting to incorrect accounts in QuickBooks Desktop
  • Resolved: Exporting Sales Orders to QuickBooks Online was rounding the unit price field incorrectly when using repeating decimals
  • Resolved: Items with multiple tracking values were posting to QuickBooks Desktop with the first tracking repeating
  • Resolved: Payment refunds when utilizing a foreign currency were not posting to QuickBooks Online but instead giving a "Business Validation Error" during export

Setup

  • Resolved: User Group Rights associated with individual plugins were not saving changes properly after a server update

Reports

  • Resolved: Sales Order Taxes Report was doubling line item type taxes in the report's Grand Total

MAR 6, 2025 - Plugins

Commerce
  • Amazon Plugin connection can't be disconnected with delete icon in settings.
    • The trash icon button in the settings dialogue was only clearing the connection name field and the connect button. It should break the connection without having to delete the whole instance.
  • Use customer properties setting not applying when customer is a job.
    • The setting was not being considered and is now used when selected.
  • Kits with service items were not fulfilling correctly
    • Kit item quantities were not captured properly if one of the items was a service item. The service item is now recognized as fulfilled and sends the data over correctly.
WooCommerce
  • Tax exempt customers still being taxed
    • Default settings on plugin for taxes were causing some errors that have been corrected.


FEB 14, 2025 - Advanced 25.2

Download - 25.2
Highlights - 25.2
  • Increased focus and prioritization addressing key issues that highly impact users
  • New REST API Enhancements
  • Updated Plugin Integrations
  • Improved Sales Order Alert Note Flow
New Features - 25.2
  • The following endpoints have been added to the REST API and are now available for use. This allows for more accurate order syncing between programs by allowing the deletion of payments associated with canceled orders and management of Parts and Products. Users will spend less time manually deleting these items via the Fishbowl Client.
    • Delete Payment
    • Delete Part
    • Delete Product
  • ShipExpress integration has been updated. This helps to ensure continued performance and use in the future
  • Shopify Plugin integration has been updated. This helps to ensure continued performance and use in the future
Fixes - 25.2

General

  • Resolved: Fishbowl Client was slow to load on startup. This was a highly impactful issue with difficult workarounds that affected all customers. We have resolved this issue by updating JxBrowser which will fix the issue and prevent it from occurring in the future. Note that the latest version of JxBrowser no longer supports macOS 10 Catalina.
  • Resolved: Download and installation of MySQL was not initiating properly. This was a highly impactful issue for anyone that was downloading and installing Fishbowl for the first time. Fishbowl Installer will now continue to download and install MySQL without interruption requiring user interaction.

Sales Order

  • Resolved: Some users were getting an "Unable to decrement quantity" error after voiding and then re-shipping a Sales Order.

Part

  • Resolved: Unable to enable Serial Number tracking when a part's inventory was in a single location.


JAN 14, 2025 - Advanced 25.1

Download - 25.1
Highlights - 25.1
  • Multi-Factor Authentication improvements
  • Fishbowl Commerce speed improvements
New Features - 25.1
  • Multi-Factor Authentication is now required if integrating with Xero. Once integrated with Xero, MFA will not be able to be disabled.
  • Multi-Factor Error message has been updated for greater clarity. We have included a link to a knowledge article with common troubleshooting steps.
  • Fishbowl Commerce has been optimized in the following areas: Customer Import, Quick Fulfill, GetSystemProperty. This improves the overall performance when syncing between Fishbowl Commerce and Fishbowl Advanced so that less time is spent waiting for updates between the two systems.
  • The QuickShipRq API call has been enhanced for speed. This allows more orders to be Quick Shipped in a shorter period of time.
  • Added a new REST API endpoint that allows for deletion of Sales Orders. The new endpoint is DELETE SO.
Fixes - 25.1

General

  • Resolved: Fishbowl Server Application installer would fail to load MySQL 8.0 if Microsoft Visual C++ Redistributable was not pre-installed before installation. The installation now installs Microsoft Visual C++ Redistributable by default.

Sales

  • Resolved: Editing an address on a Sales Order would remove the contact information from the details tab. Now this information is only changed when an existing address is selected that has default contact information.
  • Resolved: Sales Order Quantity Picked field was not being updated properly after voiding the pick. This caused the Close Short button on Sales Orders to be greyed out.

Materials

  • Resolved: Creating a Purchase Order from within the Consignment Module would cause an invalid error preventing the creation of the Purchase Order.
  • Resolved: Users could enable tracking on a part and skip adding tracking for some items. When attempting to pick these items later, the user would be unable to pick because the tracking numbers were unable to be selected.

Accounting

  • Resolved: When attempting to reconcile parts on a Transfer Order that had already been consumed, users were receiving an error upon export to any accounting system stating "Balance your debits and credits." The error would not allow the Accounting Export to go through.

Reports

  • Resolved: Sales Order Summary Report and Sales Order Summary Export Report were unable to be scheduled because of the added ability to filter by Product Tree. The report has been modified so that the Product Tree filter can be manually entered and still be scheduled in the Schedule module.
  • Resolved: Export Summary Report was including posted transactions even when unchecking the box to include them in the report.
  • Resolved: ABC Report has been updated to use a new report parameter improving date accuracy and simplifying report customizations.
  • Resolved: Production Report has been updated to use a new report parameter improving date accuracy and simplifying report customizations.

Fishbowl Commerce

  • Resolved: Settings allowing the Location Group for a Sales Order to be set according to the state on the ship-to address were non functional


DEC 10, 2024 - Advanced 24.12

Download - 24.12
Highlights - 24.12
  • New Report enhancements
  • Improved Plugin load times
Features - 24.12
  • Enhanced the Sales Order Summary Report and the Sales Order Summary Export report with the following:
    • Added Customer PO as a column that can be enabled in Modify Report settings
    • Added Modify Report Filters:
      • Customer Group
      • Carrier
      • Product Tree
      • Default Vendor
Fixes - 24.12

General

  • Resolved: Some Hosted users were receiving a dialog box asking if they wanted to apply the downloaded update. This dialog box is now bypassed and update of the application happens automatically.

Purchasing

  • Resolved: When changing the vendor on a purchase order with outsourced items, the costs were updating to the new vendor's costs.
  • Resolved: Drop-shipped quantities updated on the sales order not being updated on the associated purchase order.

Receiving

  • Resolved: Accounting discrepancy was caused when immediately voiding after reconciling a single line item.

Accounting

  • Resolved: Partially fulfilled kits were causing the error "Line total does not match the expected line total" when exporting to Xero.
  • Resolved: Exporting invoices to QuickBooks Online caused errors when sales tax was turned off in both Fishbowl and QuickBooks Online.

Reports

  • Resolved: Sales Order Summary report was not pulling the correct information when selecting a single day from the Date Range dropdown.
  • Resolved: Sales Order Summary Export report was not pulling the correct information when selecting a single day from the Date Range dropdown.
  • Resolved: Work in Progress Report was not totaling properly when including multiple work orders.

Plugins

  • Resolved: Improved load time for all plugins which was also affecting the client load and log in time.
  • Resolved: A macOS file in the Plugins folder was causing the plugin updates to fail.
  • Resolved: "The quantity must be a whole number" error was occurring for some UOM conversions when performing Move, Scrap, Cycle, and Add through the API. This affected these functions in Fishbowl Advanced Mobile.
  • Resolved: The next available location was not being automatically populated in picking after partially picking a part through the API. This mainly affected Picking in Fishbowl Advanced Mobile.
  • Resolved: Picking in a different Unit of Measure than the part is stored in would incorrectly show short inventory for that item. This mainly affected Picking in Fishbowl Advanced Mobile.


NOV 20, 2024 - Advanced 24.11

Download - 24.11
Highlights - 24.11
New Features - 24.11
  • Multi-Factor Authentication feature has been added and can be enabled for the Fishbowl Client log in process.
    • What is Multi-Factor Authentication (MFA)?
      • Multi-Factor Authentication (MFA) adds an extra layer of security by requiring not only a password and username but also a verification code when a user logs into their Fishbowl account. If MFA is triggered, a verification code will be provided through an authenticator app (e.g., Google Authenticator). This helps to ensure that the user is the only person who can access their Fishbowl Client login. To enable MFA, follow these steps in Fishbowl's User module.
    • Outcome: Enhances overall security of the application through utilization of popular authentication applications.
  • Updated error messaging for login and QuickBooks Desktop connection error messages.
    • Outcome: Less bottlenecks in day to day Fishbowl usage meaning less time spent troubleshooting and more time doing more important tasks. The new error messages include a link users can click with detailed guides to troubleshooting and resolving the issue.
  • New Fields available for Kit Items import. The following fields are available to update Kit Items: Weight, WeightUOM, Width, Height, Length, sizeUOM, and TaxCode (For international databases).
    • Outcome: Spend less time having to manually update these fields with every new Kit imported into Fishbowl.
Fixes - 24.11

General

  • Resolved: When attempting to run the optimize database feature, it was simply erroring out and essentially non-functional.

Sales

  • Resolved: The Contact Details for a Sales Order were not updating after changing to a different ship to address.

Accounting

  • Resolved: When attempting to reconcile an outsourced Purchase Order (and at least some of the inventory outsourced had already been consumed) users were receiving an error upon export to any accounting system stating "Balance your debits and credits." The error would not allow the Accounting Export to go through.

Checkout

  • Resolved: Users were not able to edit flat rate discounts on a Sales Order.

Reports

  • Resolved: 3 Reports (Sales Backorder Summary, Work order Summary, Export Summary) had an issue where if a single day was selected for a date range the report would populate with a blank page.
  • Resolved: The Product Catalog V2 report would not run if a customer was selected that had more than one address type marked as default.

Database Updates

  • Added two new columns to the sysuser table
    • mfaSecret
    • mfaBypassCounter
  • Added a new column to the userlog table
    • isMfa

NOV 14, 2024 - Commerce Plugin

  • The Commerce plugin in Fishbowl Advanced now uses SSO (Single Sign-On) to authenticate with Fishbowl Commerce.
    • Outcome: You no longer need to enter an App ID and App Secret which means that setup is faster and more secure.

NOV 8, 2024 - AI Insights

  • We're excited to announce the first release of our new AI Insights plugin for Fishbowl Advanced.

OCT 15, 2024 - Advanced 24.10

Download - 24.10
Highlights - 24.10
  • New Module Dashboard Date Filter options.
  • New Module Dashboard speed improvements.
  • New Updated Database Dictionary
New Features - 24.10
  • The Sales, Purchasing, and Inventory Dashboards have all received updated date range filter options.
    • Outcome: With these new options, period comparisons will be more accurate and informative to facilitate better mid-period business decisions.
  • All four module dashboards have receiving significant speed improvements by implementing asynchronous functionality so that all cards and queries are running simultaneously.
    • Outcome: The Dashboards run faster and display data as it is returned instead of waiting for all data to be returned before populating the entire dashboard.
  • New Updated Database Dictionary
    • Outcome: You can now more efficiently and accurately build integrations, custom queries, and custom reports with the help of up to date documentation of database structure and dependencies.
Fixes - 24.10

General

  • Resolved: Scaling issues causing text to appear very small on some windows installations due to previous jxbrowser update.
  • Resolved: When installing MySQL through the Fishbowl Server Installation we were utilizing the default MySQL settings. MySQL settings have now been optimized for the Fishbowl Server Application on all new installs.

Materials

  • Resolved: Performing a move within the Consignment Module was not respecting the unit of measure selected. Instead it was always using the default Part unit of measure.

Purchasing

  • Resolved: If a user had a Purchase Order and sorted the items by description then when a user would select the Cost field Fishbowl would automatically scroll the list of line items. The correct cost field was still selected but often caused confusion as to which item was being edited.

Sales

  • Resolved: Some users were receiving an error message that was preventing shipping an order that stated "Line item in entered status."

Manufacturing

  • Resolved: The feature in Manufacturing that allowed a user to carry a tracking number from a Raw Good through to the Finished good was not functioning.
  • Resolved: If "Auto-advance to Work Order finish step" was unchecked in the Manufacture Order Module, then picking would not occur automatically during the picking step. This caused users to have to go back to the picking step and manually pick every item.
  • Resolved: Bill of Material Instructions custom fields were not transferring properly to Work Orders created from that Bill of Material. If a user had more than one custom field then the first custom field in the list would be duplicated for every subsequent custom field on the Work Order.

Accounting

  • Resolved: When reintegrating with Xero the module option for "Use Class Tracking" in the Class Module would automatically be unchecked. This option would have to be re-checked manually before classes could be sent to Xero again.
  • Resolved: When reintegration with Xero was required we returned the same error message we received from Xero which was not very helpful to the user. A better error message notifying the user of the need to reintegrate/re-authorize is now shown.
  • Resolved: Sales Order payment refunds were not allowed if a customer was integrated with QuickBooks Online. This was because the payment refund would go to the wrong accounts in QuickBooks. Payment Refunds have now been enabled and post to the correct accounts in QuickBooks Online.

Reports

  • Resolved: 5 Reports have been updated to use a new date range parameter that reduces date range errors and more easily facilitates future changes and customizations. Reports updated include: Auto PO Report, Export Summary Report, Sales Backorder Report, Work Order Summary Report, and Sales Order Summary Report.

REST API

  • Resolved: The REST API did not allow passing of a parameter via the Data Query call. This change enables better integration with applications like SalesForce.
  • Resolved: The REST API was recalculating unit cost for the PurchaseOrder call based on the total cost. This was causing the unit cost when entered to be recalculated and rounded and no longer matched what was originally passed to the REST API.

Database Updates

  • Added a new column to the fbschedule table called pluginManaged. This field is utilized to make certain scheduled tasks read only avoiding the possibility of user changes that can cause certain features to stop working.


SEP 17, 2024 - Advanced 24.9

Download - 24.9
Highlights - 24.9
New Features - 24.9
  • Inventory Dashboard includes the following information: Inventory Value by Month (YTD), Average Days in Inventory, Parts to be Reconciled, Stock Adjustments, Expired Parts, and Short Parts.
    • Outcome: Empowers businesses leaders to make informed decisions by providing a quicker and clearer picture of overall inventory status and helps identify potential problem areas.
  • Manufacturing Dashboard includes the following information: Open Work Orders, Overdue Work Orders, Current WIP Value, Work Orders by Status, Production Needed, Yield and Consumption Variance.
    • Outcome: Offers a more powerful and user-friendly Fishbowl experience, empowering your team with key data they need to facilitate decision making and drive operational success regarding the Manufacturing process.
  • Automatically restart the Fishbowl Server application after an update: The feature setting in the Server Administration page for "Automatically Download and Apply Updates" has been improved. Now you can set a day and a time to have Fishbowl completed the update process by restarting the Fishbowl Server application after downloading an update. For those customers that have already enabled the "Automatically Download and Apply Updates" setting before updating, the default restart day is Sunday and the default restart time is 1:00 AM. This can be changed to whichever day and time works best for your business.
    • Outcome: Less time spent having to wait for an update to complete the next time you restart your server manually. Helps keep you consistently up to date with the latest bug fixes and features.
  • The Xero integration has been improved to better handle automatically associating payments made in Fishbowl. Now overpayments are able to be automatically applied to their corresponding invoice in Xero.
    • Outcome: Less time spent having to manually apply payments in Xero for orders that are paid in full but only partially shipped.
  • The JXbrowser service has been updated to 7.41.2
    • Outcome: Improves compatibility with MacOS Sequoia keeping you up to date with the latest bug fixes and feature enhancements.
Fixes - 24.9

Purchasing

  • Resolved: The Auto PO function was creating multiple separate purchase orders for the same vendor. This was caused by how we handled parts that were similar in number. For example: B201 and 0B201.
  • Resolved: When importing the Receiving Data.csv, if your Purchase Order number included a "P" as a prefix the import would error out and say that it could not find the Purchase Order.

Sales

  • Resolved: Products with unit of measure conversions that produced repeating or long decimals were causing some picks to get a null error when trying to finish the pick.
  • Resolved: The Sales Order.csv import was not respecting the setting for the "PriceIsHomeCurrency" column.

Manufacturing

  • Resolved: The Bill of Materials.csv export was extremely slow when filtering to export a single bill of materials.

Server Administration

  • Resolved: Fishbowl Server was not automatically restarting after installing an update for Mac computers.

Accounting

  • Resolved: When invoices were exported over to Xero the line item numbering did not match was on the Sales Order.
  • Resolved: Fishbowl would randomly loose its connection with Xero prompting the user to disconnect the integration and re-integrate.
  • Resolved: The disconnect button in accounting now removes Fishbowl from the Connected Apps section of Xero.
  • Resolved: Exporting subtotals to a Xero invoice was causing a "Line total does not match the expected line total" error.

Reports

  • Resolved: The Sales Dashboard was including subtotals in the list of top selling products.
  • Resolved: Sales Order Report date type custom fields were including a timestamp by default. The timestamp has been removed.
  • Resolved: Accounting's Export Summary report was not totaling correctly for "not posted" orders.
  • Resolved: Receiving History Report when exported as an .xls type file was not saving the total fields.
  • Resolved: The Packing List Report was not properly displaying kit headers when choosing the "By Carton" layout.
  • Resolved: The Reorder Report was including inactive locations when utilizing "By Location" reorder points.
  • Resolved: The Pick Report was still including a prefix on the barcode even when the option to "Prefix Barcodes" is unchecked.
  • Resolved: Reverse Lot History report was running very slow. Have made improvements to further optimize the report.
  • Resolved: The Packing List report was renamed to Packing Slip but was still referenced as packing list throughout the rest of the client.


AUG 13, 2024 - Advanced 24.8

Download - 24.8
Highlights - 24.8
New Features - 24.8
  • A Sales Dashboard has been added to provide the following information: Sales Orders vs. Previous Period, Sales Order Summary, Margins, Top Selling Products, Sales by Product Tree, Orders Fulfilled in Full on Time.
    • Outcome: Empowers businesses leaders to make better informed decisions by providing a clear picture of sales performance.
  • A Purchasing Dashboard has been added to provide the following information: Top Selling Parts by Vendor, Top Margins by Vendor, Inventory Value, Days in Inventory, Orders Closed Short, Purchases by Type.
    • Outcome: Provides businesses with crucial insights into their procurement processes by streamlining purchasing data into actionable insights, companies can improve supplier negotiations, optimize inventory levels, and manage purchasing costs effectively.
  • New Installations of the Fishbowl Server are now set to "Automatically Download and Install Updates." If an update becomes available Fishbowl will automatically download the update and apply it the next time the server is restarted.
    • Outcome: Helps you get the most out of Fishbowl with new features and fixes with less manual intervention.
Fixes - 24.8

Sales Order

  • Resolved: The "How to" button was linking to the wrong help article for Fishbowl Payments.

Purchasing

  • Resolved: The Auto PO function was pulling order demand outside of selected filter dates.

Accounting

  • Resolved: Catching illegal characters causing XML Parse errors when exporting to QuickBooks has been improved.
  • Resolved: Issue where rounding of taxes was causing discrepancies when exported to Xero.
  • Resolved: Rate limit issues when sending a high number of transactions to Xero. A wait period of 30 seconds has been implemented to allow the export to continue.
  • Resolved: Automatic syncing of tax items is now optional when integrating with Xero.
  • Resolved: When choosing a different tax rate upon reconciling a receipt the original tax on the Purchase Order was exported to Xero.
  • Resolved: A 32bit version of Fishbowl Nexus ("Fishbowl Nexus x86") is now included in the Server Bin folder upon installation and can be used when integrating with QuickBooks Desktop versions 2021 or older and Reckon.

Manufacturing

  • Resolved: Some users were encountering a "Not enough quantity in target tag" error when attempting to finish a Work Order with a raw good that was only partially short inventory and the user right "consume when short" is enabled.
  • Resolved: Work Orders that contained a Product with a long description were not displaying properly in the Finish Work Order Wizard.

Reports

  • Resolved: Auto PO report was pulling order demand outside of selected filter dates.
  • Resolved: Historical Part Cost Report was pulling historical entries outside of the date selected.
  • Resolved: Historical Part Cost Report was not calculating total cost correctly for FIFO costing databases.
  • Resolved: Sales backorder report was inflating the short calculations columns by including drop ship and credit return type items in the calculation.
  • Resolved: Gross sales by Sales Person Report was not including miscellaneous type items.
  • Resolved: Gross sales by Sales Person Report has been updated to match the corresponding BI Report.
  • Resolved: A new parameter has been added to better facilitate report date ranges.


JUL 16, 2024 - Advanced 24.7

Download - 24.7
Highlights - 24.7
  • The Nexus application used to connect to QuickBooks Desktop has been updated to be 64bit compatible.
New Features - 24.7
  • The Nexus application used to connect to QuickBooks Desktop has been updated to be 64bit compatible.
    • Outcome: This update helps to facilitate future updates and integration performance and stability improvements.
  • The Xero integration has been enhanced to automatically apply partial payments.
    • Outcome: Now payments in full and partial payments are automatically allocated to the invoice when they get to Xero saving time spent manually applying payments.
  • Adding different carton types to shipments has been made easier by removing case sensitivity from the carton search field.
    • Outcome: Searching for cartons types to add to a shipment takes less time having to enter in uppercase vs lowercase letters.
Fixes - 24.7

Sales Order

  • Resolved: License key issues with Checkout was only allowing the admin user to log in.
  • Resolved: Multi-Currency Sales Orders were not rounding properly causing a discrepancy in some cases of $0.01

Manufacturing

  • Resolved: The Bill of Material CSV import was throwing an error stating that item descriptions were required when they should not be required.
  • Resolved: When finishing a repair item with two or more assigned serial numbers on a Work Order, editing one of those serial numbers gave an error stating that the serial number already exists.
  • Resolved: An automation that apply's changes made to a Bill of Materials to any open Work Orders was not utilizing Unit of Measure conversions for the part that was modified.

Mac

  • Resolved: A notification animation in the client application was prompting a notification in iOS to enable screen recording even though it was not required.

Accounting

  • Resolved: Xero payments were being duplicated in circumstances where the payment amount was more than the total amount of the invoice

Database Updates

  • Serial Numbers were limited to 41 characters in the database. The following fields have been updated to support up to 256 characters:
    • serialnum.serialnum
    • tiinventorylog.info
    • tiinventorylogsn.serialNum
    • trackinginfosn.serialNum
    • serialnum_aud.serialNum
    • trackinginfosn_aud.serialNum
Commerce Plugin - 24.7.4

Features

  • Added functionality to set PRODUCT "Active" status in Fishbowl Commerce based on selection in Fishbowl. Inactive products in Fishbowl will not be created in Fishbowl Commerce, only updated if previously linked.
    • Users need to be able to adapt listing quickly and easily as products change and get new versions. This update allows sellers to keep product listings current when they change active status in the origin app, Fishbowl.
  • Added an option to filter out imported orders that don't have a mapped status
    • Users with many store channels will have increasing processes that deviate from the traditional flows. This option will give more B2C customers the ability to define when fulfilled orders should come into Fishbowl for inventory and accounting recording.

Fixes

  • Fixed a Settings export issue that was changing location settings to make inventory unavailable
  • Removed Warehouse/LG ID from the the Order Import resolving an import error for Not Found Warehouse ID
  • Fixed an issue with Inventory update when "Include Available to Build quantities" option was enabled
  • Fixed query syntax issue with the Inventory Update task when the "Include Available To Build quantities" is selected
  • Fixed issue on fulfillments where incorrect shipments were being sent to Fishbowl Commerce by supporting re-sending shipments via backdated sync
  • Location Group mapping was refactored for the Settings export to match and update on the LocationGroup/Warehouse name rather than ID
  • Fixed a Fulfillment issue resulting from batching large amounts of Shipments at once
  • Changed how fulfillments get sent to Fishbowl Commerce to catch missing fulfillments
  • Kits fulfilled in varying UOMs will be converted back to original order UOM to prevent errors to Fishbowl Commerce
Advanced Plugins - 24.7

Fixes

  • 08/06/2024 - Fixed Null pointer exceptions for all e-commerce on dropship fulfillments preventing an all fail to the channel
  • Saturday Delivery and Retail Rates options now return rates and labels for ShipExpress
  • Updated Magento plugin Fulfillment and Order API calls for Bundle types, Together and Separate
  • Updated Magento (AdobeCommerce) plugin to handle bundle fulfillments via the new API
  • Updated ShipExpress dependencies for the latest version of Fishbowl Advanced


JUN 18, 2024 - Advanced 24.6

Download - 24.6
Highlights - 24.6
  • The Xero integration has been enhanced to automatically apply payments made in full to an invoice saving time having to manually apply all payments in Xero.
  • The installation process has been streamlined to save time and effort during installation.
  • Last manufactured cost has been added as an option in pricing rules ensuring more balanced and accurate pricing resulting in less time spent comparing cost versus price.
New Features - 24.6
  • The Xero integration has been enhanced to automatically apply payments made in full to an invoice.
    • Outcome: Save time by not having to manually apply every payment sent from Fishbowl to Xero.
  • The server installation process has been streamlined for ease of use. Fishbowl will automatically install MySQL for you.
    • Outcome: IT administrators no longer have to manually install a separate application when installing the Fishbowl Server.
  • Sales Order
    • Last manufactured cost has been added as an option in pricing rules
  • Product
    • Next order information has been added to the Product Tree search pane's information button. This gives information regarding future incoming inventory for the selected product helping make better decisions on whether or not to add that product to the selected Product Tree.
  • Reports
    • The Receiving Summary report is used to see an overview of orders that are in receiving and their status. It can show which orders have items that have been received but not reconciled which can help accountants.
    • The Production Demand report is used to quickly see what the current demand (allocated to an order) is for finished goods in a given date range. It shows demand for each order and also includes a summary by Part Number helping you know exactly what needs to be produced in manufacturing.
  • The Asian Pacific regions license agreement has been updated.
Fixes - 24.6

Accounting

  • Resolved: If taxes were not synced between Xero and Fishbowl those taxes would show up as tax exempt on orders. Fishbowl now automatically syncs taxes upon integration with Xero.
  • Resolved: The Xero integration was showing an option to import currency when that functionality is not available through the integration with Xero.
  • Resolved: The wrong logo was being displayed on the Reckon integration button.

Sales Orders

  • Resolved: The setting in the Shipping module options "Print Shipping Invoice on Ship" was only printing the first Shipping Invoice when shipping multiple orders at the same time.
  • Resolved: When trying to copy text on a Sales Order using "Control + C" on a Mac it would launch the Inventory Check Tool instead of copying the text. Now to launch the Inventory Check Tool, use "Control + E".
  • Resolved: With multi-currency enabled, if an order was created using the home currency which does not utilize multi-currency then the multi-currency fields for that order were not filled out. This was causing issues with plugin integrations.
  • Resolved: Sales Order and Sales Order details were not including part cost for service type items on kits.
  • Resolved: Closing short one item on a sales order kit broke shipping moving forward for that order.
  • Resolved: Status was allowed to be changed using the Sales Order Details CSV import. This has been removed. This created an instance where Sales Orders were issued but no pick was automatically generated.
  • Resolved: In the Shipping module's advanced search, both Order Number and Ship Number were pointing to the same field.

Purchase Orders

  • Resolved: Auto-generating a purchase order was not including item custom fields on the purchase order.

Reports

  • Resolved: Bill of Materials Report was not showing correct Units of Measure and was running slowly.
Commerce Plugin - 24.6

New Features

  • Initial sync with Fishbowl Commerce now sends Accounting class and salesperson lists to facilitate mapping those fields per linked channel
    • Users may use these order fields to run accounting and sales reports on a channel by channel basis in Fishbowl or the accounting app

Fixes

  • Resolved: Inventory Export correctly references Min/Max settings
  • Fixed Inventory null error on inventory update for Kit products
  • Fixed an issue with Customer name mapping when Fishbowl Commerce default customer was not being used
  • Fixed mapping the Order item description field in Fishbowl from Fishbowl Commerce fields
  • The plugin no longer logs stacks for successful runs of scheduled tasks, preventing cluttered log files
Advanced Plugins - 24.6

Fixes

  • Fixed the Invoice (810) ship date in the SPS Plugin
  • Fixed an issue on Amazon orders where shipping tax was getting removed twice when setting was enabled.
  • Fixed Amazon order import to honor tax exempt status in the plugin
  • Updated Amazon plugin UI to show corrected field name for default customer mapping
  • Fixed File Storage plugin settings from getting overwritten when license validation fails


MAY 14, 2024 - Advanced 24.5

Download - 24.5
Highlights - 24.5
  • The Xero integration has been updated to the latest SDK
    • Outcome: Not only does this offer access to the latest integration features, but it offers increased stability and fixes for past bugs.
New Features - 24.5
  • The Cycle Count Data CSV import has been updated to honor UOM conversions
    • Outcome: Being able to utilize different UOM's when performing cycle counts adds efficiency and accuracy to the cycle count in a warehouse full of different bundles of products.
  • Database Layer Updates
    • Outcome: Updates to the frameworks for communication between the Server and Database have been updated, offering a more efficient connection as well as security updates.
  • QuickBooks Online Integration steps have been simplified
    • Outcome: The integration wizard will now auto progress after account login to improve efficiency during integration.
Fixes - 24.5

Accounting Export

  • Resolved: When not using the legacy client connection, the Accounting Export window did not update until the export was finished

Checkout

  • Resolved: The default port for fresh installs has been updated to align with the Fishbowl Client.

Database Rebuild

  • Resolved: The database rebuild tool has been updated to clear the PartCostHistory table

Login

  • Resolved: When not using the legacy client connection, a generic error message was displayed when the user login limit had been reached

Reports

  • Resolved: The Batch Pick Ticket by Order report was showing null as the title for the pick tickets
  • Resolved: Incorrect tax inclusion on the SO to PO Margin report
  • Resolved: The Work In Progress report showing duplicate orders and incorrect totals
  • Resolved: The Purchase Order Summary report showing the incorrect currency symbols
  • Resolved: Repair items showing up twice on the Work Order Consumption report
  • Resolved: Incorrect columns show on the Sales Order Summary report when modifying columns
  • Resolved: Date type custom fields showing incorrectly on the Sales Order report
  • Resolved: Scheduling the Dormant Customers report giving errors and a corrupt file
  • Resolved: Export issue when saving the Customer Purchase History to XLS and CSV
  • Resolved: Batch Sales Order Invoice date range parameter issues
  • Resolved: Purchase Order Summary export not showing the correct currency symbol
  • Resolved: Currency symbol issues on the Item History report
  • Resolved: Average cost calculation issues on the Part Cost of Time Report

Sales Orders

  • Resolved: The cost for kits not honoring UOM conversions
  • Resolved: Parts that are not inventory type not honoring UOM conversions and showing incorrect costs
Commerce Plugin - 24.5

New Features

  • Order Discounts can be displayed as their own line item or rolled up in to the item price
  • Inventory Export sends short quantities to Fishbowl Commerce as negative total quantities
  • Added Vendor PO to the order mapping tables
  • Allow USPS shipments to get passed back to Amazon without carrier tracking data in compliance with Amazon's VTR policies

Fixes

  • Removed Drop Ship quantity allocations from quantities passed to Fishbowl Commerce
  • Removed redundant setting to map Order numbers in the plugin when the setting exists in Fishbowl Commerce already
Advanced Plugins - 24.5

Fixes

  • Fixed Salesforce Order defaults to use "Customer Default" mapping options only when selected
  • Fixed Amazon orders to send fulfillment data from drop ship receipts
  • Added carrier, CanPar, as a service validated carrier for Amazon fulfillments
  • Fixed an issue with Amazon shipping tax being removed twice from payments on payment tax removal option
  • Mapped order taxes to ShipStation tax fields on the Shipment Export


APR 16, 2024 - Advanced 24.4

Download - 24.4
Highlights - 24.4
  • To keep business running smoothly and take advantage of performance, security and feature enhancements made or temporarily bypass the manual database engine update process, the Fishbowl installer now streamlines the install process based on your business needs at the time of the update.
    • During the installer, Fishbowl will detect which version of MySQL is currently found and give you options for remaining on MySQL 5.7 or updating to MySQL 8.0.
  • To offer the best connection experience while working in Fishbowl, the login screen has been updated to show you if you are using the legacy connection with options of disabling it.
    • The login screen has been update to display if the legacy socket connection is being used between the Fishbowl Client and Server.
  • To start off on the right foot, new installs of Fishbowl will utilize port 2456 for the client connection, thus requiring less from your IT department.
    • Instead of defaulting to port 80, new installs of Fishbowl will utilize port 2456 for the updated connection between Fishbowl Client and Server.
  • To eliminate potential downtime due to updates and to keep your connection running smoothly, the default memory allocation for Fishbowl Client has been increased and updated.
    • The previous RAM allocation was 1GB. It has been updated to 2GB to prevent issues with the connection and when updates occur.
New Features - 24.4
  • Ensuring accuracy and completeness for every transaction, no matter the stage the order is in, Purchase Order fields like Customer Sales Order Number, Vendor Sales Order Number and line item custom fields are editable even after order fulfillment.
  • Tired of the endless scrolling through products when creating orders for your customers when they have a specific product list? There is now an option to limit that list to those products that are linked to your customer, thus simplifying the order creation process.
  • Data accuracy and consistency is key in any business. Limiting access to editable fields can ensure that remains true. User rights have been added to limit access to the Sales Order Number, Ship Date, Purchase Order Number and Receive date fields during the order taking and fulfillment process.
  • Need to contact a customer about a payment that was taken? The customers email address from the order is now shown in the Payment Viewer for quick access.
  • Fishbowl's connection to QuickBooks Online is key to your business running smoothly. The connection itself has been updated, along with improvements around connecting and disconnecting have been made.
Fixes - 24.4

Database Access

  • After updating to MySQL 8 the “gone” user was not created automatically affecting integrations with third party programs that utilized an ODBC connection to the database. The new update creates the “gone” user automatically making it immediately available for use.

Fishbowl Payments

  • In some cases, the scheduled task to import payments that were made via Pay Link would fail without error and would not update the timestamp on the last run date. These issues have been resolved.

Inventory

  • In rare cases some serial numbers were removed from inventory. If a user was performing a cycle count and also attempted to change a serial number mid process that serial number would be lost upon completion of the cycle count process. This happened specifically when the serial number letters remained the same but were changed between uppercase and lowercase. This issue is now resolved and the serial numbers are updated and remain intact.

QuickBooks Online

  • When posting Purchase Orders to QuickBooks Online, if a customer received an error stating that “A bill has already been created”, duplicate journal entries would be created in the holding account

Reports

  • The Reverse Lot History report was missing some Work Orders in certain circumstances. The report has been fixed and now includes all Work Orders.
  • The Shipping Invoice was not including shipping type items in its total. The report has been fixed and now includes associated shipping items in the total.
  • The Bi Report “MTD Chart” was unable to run because of an issue regarding leap year. The report has been updated and runs as expected.
  • The Manufacture Order Projected Cost doubling the total cost to finish the order. The report has been updated to show the total accurately.

Sales Order

  • When modifying and updating a Sales Order with link Manufacture Orders, a user may receive a blank error, thus causing changes to not save. This error has been updated to inform the user of the issue and steps to resolve it.

Server Administration

  • Resolved issues causing Database Maintenance to fail when using MySQL 8

Database Updates

  • Add access right for editing Sales Order number
  • Add access right for editing Purchase Order number
  • Add access right for editing batch Ship Date
  • Add access right for editing Receive Date

MAR 29, 2024 - Commerce Plugin

New Features
  • Adding a product to a product tree triggers an inventory update to Fishbowl Commerce for that product.
  • Added options for importing line-item, order, and shipping discounts as part of the item price or as an added line item.
  • Updated standardized discount logic aligned with Fishbowl Commerce and E-commerce channels.
  • Product Import/Export now includes Fishbowl Commerce product-dimension data when present.
  • Added Fishbowl Commerce product fields to the product-mapping table for Import and Export.
Fixes
  • Fixed issue to import non-erroring orders on a null-pointer scenario.
  • Fixed an inventory-export issue related to sending short quantities to Fishbowl Commerce.
  • Fixed order-customer-name logic on orders using missing address settings.
Retrieved from "https://fishbowlhelp.com/a/index.php?title=Release_Notes&oldid=7505"