Release Notes: Difference between revisions

From Fishbowl Advanced
No edit summary
(Added completed work for 2025.6 release 3/22/26)
 
(21 intermediate revisions by the same user not shown)
Line 7: Line 7:
...verify the dates
...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.
==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.
{{Released|26.4|04|14|26}}
==Highlights - 26.4==
* <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
==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
{{Released|26.3|03|23|26}}
==Highlights - 26.3==
* <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>
* <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
==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: <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.
==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.
{{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
==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 [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
==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.
{{Released|26.1|01|15|26}}
{{Released|26.1|01|15|26}}
==Highlights - 26.1==
==Highlights - 26.1==
Line 49: Line 243:


* 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: 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





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.