Fishbowl Advanced
Release Notes: Difference between revisions

Release Notes: Difference between revisions

From Fishbowl Advanced
Tag: New redirect
 
(Removed redirect to Fishbowl Desktop:Release Notes)
Tag: Removed redirect
Line 1: Line 1:
#REDIRECT [[Fishbowl Desktop:Release Notes]]
{{ReleaseNotesIntro}}
 
<!-- To insert the template for a new release, paste the following line, update the numbers...
{{subst:Insert|2022.9|09|08|22}}
...and then save the page -->
 
{{Released|2022.8|08|11|22}}
==Highlights - 2022.8==
 
* Functionality has been added to better allow for the organization of the [[Reports#Modify_report_filters|'''Modify Report''' window]]. Additional tabs can now be added, along with grouping and sorting inside of each tab. We’ve also made it possible for the displaying of tooltips for each setting within the tabs. Select reports have been updated to make use of this new functionality (SO Report, Customer Purchase History, & Part Activity Report). Additional reports will be updated in the coming months.
* The [[Advanced_Reports#Sales_Order_Report|Sales Order Report]] now has the ability to modify all field titles.
 
{{HideH2|New Features - 2022.8}}
 
* [[Data#Query_parameters|Added a button that allows parameters to be easily added to queries in the Data module]]
 
==Fixes - 2022.8==
 
'''Class'''
* Resolved: Creating a new class freezing the client or giving an error but still creating the class depending on client connection type
 
'''CSV'''
* Resolved: Mismatched error message when trying to update part UOMs with the Part UOM CSV import
 
'''Product'''
* Resolved: Adding products to a product tree caused the client to freeze when using the non-web connection
 
'''Receiving'''
* Resolved: Blank error when receiving an order with two parts and only entering a ref # on the first item
 
'''REST API'''
* Resolved: Missing information on Import data via JSON curl example
* Resolved: Null error when using the MO Create call when the user does not have a default location group and does not specify a location group in the request
 
'''Sales Order'''
* Resolved: Kit pricing becoming incorrect when changing the customer on the order
 
'''Server'''
* Resolved: Logging out API users not logging out the API users
 
'''Database Changes'''
* Removed Substitute product links from kits on the KITITEM table
 
{{HideReleased|2022.7|07|14|22}}
{{HideH2|Highlights - 2022.7}}
 
* [[{{REST API}}|The web connection Client functionality is now available to all users]]
* [[{{REST API}}|New Fishbowl installs now use the web connection by default]]
 
{{HideH2|New Features - 2022.7}}
 
* [[QuickBooks_Online#Module_Options_QuickBooks_Online_tab|Added a module option to allow Bank Transfer as an available payment method in QuickBooks Online]]
* [[{{REST API}}|Combo boxes in the Client now update appropriately when using the web connection]]
 
{{HideH2|Fixes - 2022.7}}
 
'''CSV'''
* Updated Bill of Materials and Bill of Materials Details CSV instruction to remove Work Order as a BOM Item Type
 
'''Checkout'''
* Resolved: Advanced search default filters not saving
 
'''Database Rebuild'''
* The PARTCOST table is now cleared out on rebuild
 
'''Inventory'''
* Resolved: Blank WO column storing last WO hyperlink value
 
'''Part'''
* Resolved: UOM conversion error when changing a parts UOM when it has an associated with a bill of materials
 
'''Purchase Order'''
* Resolved: Alert Notes not being displayed when adding parts via the + button
 
'''QuickBooks Online'''
* Resolved: Initial connection null error
 
'''REST API'''
* Resolved: Create PO call causing an error when a location group is not specified
 
'''Shipping'''
* Resolved: Weight showing 0 when the product UOM doesn’t have a conversion set for the default weight UOM
 
'''Web Connection'''
* Resolved: Report errors when using the web connection
* Resolved: Xero accounts not being auto selected when they already exist
* Resolved: QBO accounts not being auto selected when they already exist
* Resolved: Company module displaying blank information
* Resolved: Find Fishbowl Servers magnifying glass returning a blank result
 
'''Work Order'''
* Resolved: Assigned users not saving when being set by right clicking on a Work Order
 
{{HideReleased|2022.6|06|09|22}}
{{HideH2|Highlights - 2022.6}}
* [[Amazon#Release_Notes|Amazon Plugin customer mapping functionality updated to comply with Amazon's Data Protection Policy]]
 
{{HideH2|Fixes - 2022.6}}
 
'''Checkout'''
* Resolved: Selecting an order tax rate being required for international customers
 
'''Consignment'''
* Resolved: Auto Replenish being unable to finish
 
'''Database Rebuild Tool'''
* Resolved: Memo's not being cleared out on rebuild
* Resolved: Costing layers not being cleared out on rebuild
 
'''Picking'''
* Resolved: UOM conversion issue when voiding the pick for a Work Order
* Resolved: Slot numbering issues when adding additional picks to an existing group pick
 
'''Purchase Order'''
* Resolved: Null error running the Auto PO with an empty summary page
* Resolved: Outsourced Returning As UOM conversion error in receiving
 
'''Receiving'''
* Resolved: Item receiving user rights erroring when receiving tracked items
 
'''REST API'''
* Resolved: Address creation issues when creating Purchase Orders
 
'''Sales Order'''
* Resolved: Incorrect salesman displayed after creating a new user
 
'''Shipping'''
* Resolved: Fixed column width not saving after logging out
 
'''Vendor'''
* Updated the example databases vendor costing rules names to match functionality
 
'''Work Order'''
* Resolved: Error when saving a Work Order after removing the class selection
 
{{HideReleased|2022.5|05|19|22}}
{{HideH2|Highlights - 2022.5}}
 
* [[Getting_Started#1._Install_Fishbowl|Improvements to the client connection]]
 
{{HideH2|Fixes - 2022.5}}
 
'''Database Update'''
* Resolved: Update issues related to removing UPS Ready
 
{{HideReleased|2022.4.1|04|22|22}}
{{HideH2|Highlights - 2022.4.1}}
 
* Updated Fishbowl to account for a Java remote code execution vulnerability
 
{{HideH2|Fixes - 2022.4.1}}
 
'''Fishbowl GO'''
* Resolved: Unable to Pack a shipment
 
'''Picking'''
* Resolved: Unable to void picks that were finished prior to the update to 2022.4
 
'''Database Changes'''
* Removed DCOPTIONS table
* Removed PACKAGETYPES table
* Removed PACKAGETYPEID column from SHIPCARTON table
* Removed DELIVERYCONFIRMATIONID column from SHIPCARTON table
 
{{HideReleased|2022.4|04|14|22}}
{{HideH2|Highlights - 2022.4}}
 
* [[User#MODULE_OPTIONS|Added Password Policy options that allow for more secure user passwords]]
* [[Shipping_Integration|The UPS Ready integration has been completely removed]]
 
{{HideH2|New Features - 2022.4}}
 
* [[Start_Fishbowl#Creating_a_new_database|Database password is now blank when creating a new database on a Mac or Linux server install]]
* [[Fishbowl_GO#Approve_app|Fishbowl GO iOS is now auto-approved in the demo database]]
* [[{{REST API}}|Added the ability to do an inventory move through the REST API]]
* [[{{REST API}}|Added the ability to cycle count inventory through the REST API]]
* [[Carrier#Add_a_new_carrier|Updated UPS Carrier Codes to be editable after UPS Ready removal]]
 
{{HideH2|Fixes - 2022.4}}
 
'''API'''
* Updated password hash change on Java and C# code samples
 
'''Bill of Materials'''
* Resolved: Module options are available to all regardless of user right settings
 
'''Clover Connect'''
* Resolved: Wallets disappearing on update
* Additional name updates for Clover Connect rebrand
 
'''CSV'''
* Resolved: Import errors on Part Product and Vendor Pricing import when tracking columns are missing
* Resolved: "Column 'consumptionRate' cannot be null" error when importing the Part CSV
 
'''License'''
* Removed "ExpressTech" from license agreements
 
'''Mac Version'''
* Resolved: MySQL port defaulting to 3306 when creating a new database
 
'''Database Changes'''
* Removed SHIPUPSCARTONDETAILS table
* Removed SHIPUPSCARTONDETAILS_AUD table
* Removed SHIPUPSDETAILS table
* Removed SHIPUPSDETAILS_AUD table
* Removed UPSACCOUNT table
* Removed UPSACCOUNT_AUD table
* Removed UPSCOD table
* Removed UPSPAYMENTTYPE table
* Removed UPSRETURNSHIPMENT table
* Removed UPSRETURNSHIPMENT_AUD table
* Removed column UPS from the COUNTRYCONST table
 
{{HideReleased|2022.3|03|10|22}}
{{HideH2|Highlights - 2022.3}}
 
* [[Fishbowl_Server_Administration#Rebuild_Database|Added the ability to rebuild a database]]
 
{{HideH2|New Features - 2022.3}}
* [[{{REST API}}|Added the ability to run a data query through the REST API]]
* [[Payment_Gateway#Clover_Connect|Updated CardConnect branding to Clover Connect]]
* [[{{REST API}}|Updated documentation for the REST Import call]]
 
{{HideH2|Fixes - 2022.3}}
 
'''API'''
* Updated the REST documentation for logging out
 
'''Client'''
* Resolved: Client auto update not including all required files
 
'''Server'''
* Optimized server startup when connection to Fishbowl's online services are interrupted
 
 
'''Database Changes'''
* Removed the READONLY column from the BISCRIPT table
* Updated OUTSOURCEDPARTNUMBER and OUTSOURCEDPARTDESCRIPTION on the POITEM table to be empty strings instead of null
 
{{HideReleased|2022.2.1|02|15|22}}
{{HideH2|Fixes - 2022.2}}
 
* Resolved: Client Auto Update running for plugins causing the client to become inoperable
 
{{HideReleased|2022.2|02|10|22}}
{{HideH2|Highlights - 2022.2}}
 
* [[{{REST API}}|Added a REST API call for Imports]]
 
{{HideH2|New Features - 2022.2}}
 
* [[User_Group#Report_Rights_tab|The report rights assigned to the default user groups on new databases have been updated]]
* [[{{REST API}}|The REST API documentation page now shows the Fishbowl server version in the header]]
* [[Install_Fishbowl#Install_Fishbowl|The User License Agreement has been updated in the Fishbowl Installer]]
 
{{HideH2|Fixes - 2022.2}}
 
'''Accounting Exports'''
* Resolved: "The total debits must equal total credits" export error due to rounding differences (AU)
 
'''CSV'''
* Resolved: Sales Order Details CSV failing due to no data being provided to a required custom field with the "Create an access right to restrict the modification of this field" custom field option enabled
* Resolved: Sales Order CSV failing due to no data being provided to a required custom field with the "Create an access right to restrict the modification of this field" custom field option enabled
 
'''Part'''
* Resolved: Cost discrepancy caused by voiding a shipment and reconciling a purchase order
 
'''Picking'''
* Resolved: Order Link Section sizing to small and cutting off text
* Resolved: Unit of Measure conversions causing quantity discrepancies when picking from multiple locations
 
'''QBO'''
* Resolved: Export errors due to duplicate tax rates (Canada)
 
'''Sales Order'''
* Resolved: Amounts not be classified as negative when currency uses a trailing negative sign
 
'''Xero'''
* Resolved: Vendor street address pulling the company address instead of the vendors address
 
{{HideReleased|2022.1|01|13|22}}
{{HideH2|Highlights - 2022.1}}
 
* [https://help.fishbowlinventory.com/hc/en-us/articles/4416794839703 Updated Log4j to the latest version]
* [[Receiving#Module_Options_Reconcile_tab|Added module options in the Receiving module to require the Ref # and Bill Date fields during the reconcile wizard]]
* [[Inventory#Search|Added the ability to save the Advanced Search in the Inventory module]]
* [[Payment_Gateway#Clover Connect|The CardConnect payment gateway has been updated to save cards to the Wallet when processed through a terminal device]]
* [[Payment_Gateway#Clover Connect|The CardConnect payment gateway has been updated to use new mandated classification fields on transactions sent to CardConnect]]
 
{{HideH2|New Features - 2022.1}}
 
* [[Part#MRP_wizard|A column displaying the part UOM was added to the Summary step of the MRP wizard]]
* [[Payment_Gateway#Square|The Square Payment Gateway has been updated to exclude inactive locations in the Location selection list]]
* [https://www.fishbowlinventory.com/support/updates/download Removed the 32-bit version of the Fishbowl Installer]
* [[{{REST API}}|Added the ability to scrap inventory through the REST API]]
* [[Fishbowl_Legacy_API#Save_Image_Request|Updated the SaveImageRq API call to accept images for Sales Orders]]
* [[Fishbowl_Legacy_API#Save_Image_Request|Updated the SaveImageRq API call to accept images for Work Orders]]
 
{{HideH2|Fixes - 2022.1}}
 
'''CSV'''
* Resolved: Incorrect column header in the Customer Parts CSV. (Previously listed as "CustomerLastPartPrice")
 
'''Dashboard'''
* Resolved: Client login being slowed down due to the Dashboard loading as a saved tab
 
'''Email Settings'''
* Resolved: Using "Sign in with Google" while also having data in the Username and Password fields causes emails to fail to send
 
'''Sales Order'''
* Resolved: Right-click and Issue ignored the "Issue Sales Orders" module option when manager approval would be needed
 
{{HideReleased|2021.12|12|09|21}}
{{HideH2|Highlights - 2021.12}}
 
* [[Sales_Order#Search|Custom fields can now be viewed in the Sales Order line item table as additional columns]]
* [[Purchase_Order#Search|Custom fields can now be viewed in the Purchase Order line item table as additional columns]]
* [[User#Change_a_user_password|Updated encryption of passwords]]
 
{{HideH2|New Features - 2021.12}}
 
* [[{{REST API}}|Added the ability to Add Inventory with Tracking through the REST API]]
* [[{{REST API}}|Added the ability to Add Inventory with Serial Numbers through the REST API]]
* [[{{REST API}}|Updated third party dependencies]]
* [[{{REST API}}|Improved REST API documentation]]
 
{{HideH2|Fixes - 2021.12}}
 
'''API'''
* Resolved: Being able to add inventory for parts that are not inventory type
 
'''Part'''
 
* Resolved: The Part search "Display more information" button not showing correct data
 
'''Pricing Rules'''
* Resolved: Pricing Rules using vendor currency instead of home currency
 
'''Purchase Order'''
 
* Resolved: Error when trying to close short a Purchase Order created from a drop ship Kit product
 
'''REST API'''
* Resolved: Product Best Price curl command text update
 
'''Database Changes'''
* Added column passwordLastModified DATETIME(6) to the SYSUSER table
* Increased column userPwd to VARCHAR(255) on the SYSUSER table
 
{{HideReleased|2021.11|11|11|21}}
{{HideH2|Highlights - 2021.11}}
 
* [[Part#Search|The Part Search has been updated to include inventory numbers and images]]
* [[Amazon#Release_Notes|Added the ability for the Amazon plugin to purge Personal Identifiable Information (PII) data from Fishbowl]]
 
{{HideH2|New Features - 2021.11}}
 
* [[Inventory#Search|Added the UOM column to the Inventory Search table]]
* [[{{REST API}}|Added the ability to update a Manufacture Order through the REST API]]
* [[{{REST API}}|Added the ability to search Inventory through the REST API]]
* [[{{REST API}}|Added Category to the Manufacture Order REST API object]]
* [[{{REST API}}|Added the ability to add inventory via the REST API]]
* [[{{REST API}}|Added the ability to get pricing rule pricing through the REST API]]
* [[Plugin|JXBrowser has been updated to the latest version]]
* [[QuickBooks#Required_QuickBooks_Accounts|The QuickBooks Desktop integration has been updated to create the Cost Variance Account as a COGS type account]]
 
{{HideH2|Fixes - 2021.11}}
 
'''CSV'''
* Resolved: Consumption Rate missing from the Part CSV instructions
* Resolved: Consumption Rate missing from the PPVP CSV instructions
* Resolved: Tax Rate errors when importing the Product CSV in a Canadian database
 
'''Customer'''
* Resolved: Date Last Modified being updated when a new Sales Order is created/saved
 
'''Dashboard'''
* Resolved: Report Widget arrows being backwards
 
'''QuickBooks Desktop'''
* Improved error messaging for errors dealing with Closing Dates
 
'''Sales Order'''
* Resolved: Sales Order item details dialog loading slowly
 
'''Shipping'''
* Resolved: Slowness shipping large quantities of kits
 
'''Time'''
* The plugin has been updated to update time/wo/part records to the new plugin format
 
'''Xero'''
* Resolved: Receiving holding account not reversing when order is fulfilled
 
'''Database Changes'''
* Removed SOITEMTOMOITEM table
 
{{HideReleased|2021.10|10|14|21}}
{{HideH2|Highlights - 2021.10}}
 
* [[Part#Inventory_tab|Added a Consumption Rate to the Part module to be used in Reorder Point calculations]]
* [[Part#MRP_wizard|Updated the Auto ROP wizard to be named MRP]]
* [[Part#MRP_wizard|Added Days of Stock to Part Inventory details to show an estimates days of stock based on the Parts Consumption Rate]]
* [[Part#MRP_wizard|The Select Parts step of the MRP wizard has been updated to only show Inventory type parts]]
* [[Part#MRP_wizard|The Date Range step of the MRP wizard now has an option to use the Parts Consumption Rate stored in the Part module]]
* [[Part#MRP_wizard|The Date Range step of the MRP wizard now has options to select which Consumption to include when calculating a Parts Consumption Rate]]
* [[Part#MRP_wizard|The Forecasting step of the MRP wizard now has the option to select which Consumption to include when Part Consumption Rate was chosen on the previous step]]
* [[Part#MRP_wizard|The Reorder Point step of the MRP wizard has been updated to pull the Default Vendors Lead Time for the ROP calculation]]
* [[Part#MRP_wizard|The Order Up to Level step of the MRP wizard has been updated to the new MRP terminology]]
* [[Part#MRP_wizard|The Summary step of the MRP wizard has been updated with additional columns, sorting, and inline editing]]
* [[Part#MRP_wizard|The Summary step of the MRP wizard has the option to update the Part's Consumption Rate upon finishing the wizard]]
 
{{HideH2|New Features - 2021.10}}
 
* [[Access_Rights#Sales_Order|Added an access right for duplicating Sales Orders]]
* [[Access_Rights#Purchase_Order|Added an access right for duplicating Purchase Orders]]
* [[Currency|Added Barbados to the Currency list]]
* [[{{REST API}}|Added the ability to update a Manufacture Order through the REST API]]
 
{{HideH2|Fixes - 2021.10}}
 
'''Checkout'''
* Resolved: Company image not displaying on Checkout secondary monitor screen
 
'''CSV'''
* Updated the Product Import instructions to match terminology used in the client
 
'''Customer'''
* Resolved: Being able to update the currency rate for customers set to Home Currency through the module and CSV import
 
'''Part'''
* Resolved: The Default Returning As part is incorrectly set after duplicating a part
 
'''QuickBooks Desktop'''
* Resolved: No Certificate being displayed when integrating
 
'''REST API'''
* Resolved: REST API does not use  the server option to only allow a user to be logged in once
* Resolved: SSL Context error with Jetty Server on startup
 
'''Settings'''
* Updated the Max Thumbnail Size to not allow a number below 16
 
'''Server'''
* Improved calculation rounding precision in situations dealing with money
 
'''Square Payment Gateway'''
* Resolved: The location chosen when integrating was missing in the transaction requests sent to Square
 
'''Transfer Order'''
* Resolved: Module Option dictating which location the Transit location is created in not working as designed
 
'''Vendor'''
* Resolved: Being able to update the currency rate for vendors set to Home Currency through the module and CSV import
 
'''Work Order'''
* Issue: Error when creating a custom Work Order where the Finished Good is a Kit
:* Resolution: Removed Kits from the available list when selecting a Finished Good
 
'''Xero'''
* Issue: Balance Debits and Credits error displaying only the PO Ref #
:* Resolution: The PO # is now displayed in the error as well as the PO Ref #
 
'''Database Updates'''
* Added CONSUMPTIONRATE column to the PART table
 
{{HideReleased|2021.9|09|09|21}}
{{HideH2|Highlights - 2021.9}}
 
* [[Payment_Gateway#Square|The Square Payment Gateway was been updated to the latest API/SDK]]
 
{{HideH2|New Features - 2021.9}}
 
* [[Fishbowl_Legacy_API#Legacy_Requests|Updated the PartGetRq to select active parts first when searching based on UPC]]
* [[Currency|Added Suriname to the Currency country list]]
 
{{HideH2|Fixes - 2021.9}}
 
'''Accounting Integrations'''
* Issue: "Balance Debits and Credits" export error
:* Resolution: Locked down scenarios allowing for landing costs across multiple reference #'s and bill dates
 
'''CSV'''
* Resolved: Pricing Rule CSV duplicate entry error
 
'''Picking'''
* Updated error message on pick module refresh when the pick has been removed
 
'''Square'''
* Resolved: Failed to Process error message due to multiple emails in the email field
 
'''Work Order'''
* Resolved: Custom Work Order wizard allowing partial eaches
 
 
'''Database Changes'''
* Resolved: Added dateExpiration column to the PaymentGateway table
 
{{HideReleased|2021.8|08|12|21}}
 
{{HideH2|Highlights - 2021.8}}
* [[Transfer_Order#1._Create_a_transfer_order|The line item Scheduled Date on Transfer Orders has been opened up to allow editing until item is received]]
* [[Inventory#View_quantity_details|The Order Location Group has been added to the Next Orders section of the Inventory Details screen]]
 
{{HideH2|Fixes - 2021.8}}
 
'''Accounting Intergrations'''
* Resolved: "Please Balance your debits and credits" export error
 
'''API'''
* Resolved: Errors caused by UOM conversion issues when picking serial numbers
 
'''Client'''
* Resolved: Server Shutdown Timer message showing an error
 
'''CSV'''
* Resolved: Customer Parts not using the customer full name for import/export
* Resolved: Location CSV not using the customer full name for import/export
* Resolved: Incorrect character limit for salesman in SO and SO Details CSV instructions
 
'''Linux'''
* Resolved: Incorrect line encoding in eve.sh file
 
'''QBO'''
* Resolved: Null export error on note/subtotal type line items
 
'''REST API'''
* Resolved: UserId missing from login request
 
'''Work Order'''
* Resolved: Updated finished good and raw good text during the Custom WO wizard
 
'''Xero'''
* Resolved: Purchase Order inventory holding account transactions not being reversed upon fulfillment
 
{{HideReleased|2021.7|07|15|21}}
{{HideH2|Highlights - 2021.7}}
* [[QuickBooks_Online#Export|Multiple email addresses are now sent from Fishbowl to QuickBooks Online on Customers and Invoices]]
 
{{HideH2|New Features - 2021.7}}
 
* [[Access_Rights#Inventory|Added a user right to limit the Add functionality of the Inventory module]]
* [[Customer#Check_balance|Updated the Check Balance button of the Customer module to exclude estimate status orders]]
* [[{{REST API}}|Added Location Group search options through the REST API]]
* [[{{REST API}}|Added the ability to create UOM's through the REST API]]
* [[{{REST API}}|Added the ability to update UOM's through the REST API]]
* [[{{REST API}}|Enhanced the MO create REST API call to allow for creation of custom orders]]
 
{{HideH2|Fixes - 2021.7}}
 
'''Custom Fields'''
* Resolved: Checkbox type custom fields are not transferred to the Sales Order module from the Customer module
 
'''Fishbowl Client'''
* Resolved: Enter button not working in Advanced Search after closing and reopening a module
* Client Connection changes for connection issues
 
'''Pick'''
* Resolved: Pick custom fields being cleared out when using API calls
 
'''QuickBooks Desktop'''
* Resolved: Miscellaneous Credit general journal entries posting incorrectly
* Issue: Payments exporting and automatically applying to Invoices incorrectly
:* Resolution: Added a module option for Automatically Applying Payments that can be disabled
 
'''QuickBooks Online'''
* Resolved: Vendor credit return posting incorrect journal entries
 
'''REST API'''
* Resolved: Issues with Purchase Order custom fields
* Resolved: Custom fields issues on Manufacture Order creation
 
'''UOM'''
* Resolved: Make default UOM's, like Each, inactive did not remove them from the UOM list when creating new parts
* Updated text for Abbreviation fields
 
'''User Group'''
* Resolved: "See All Customers" user access right not limiting customers in the Product module, Customers tab
 
'''Xero AU'''
* Resolved: "Unexpected error: Please reintegrate with Xero."
 
{{HideReleased|2021.6|06|10|21}}
{{HideH2|Highlights - 2021.6}}
 
* [[Fishbowl_for_Mac|Mac installer improvements]]
* [[Sales_Order|Added the ability to right-click multiple sales orders in the search pane and close short the orders]]
 
{{HideH2|New Features - 2021.6}}
 
* [[Currency|Added the Zimbabwean Dollar to the available currencies list]]
* [[Getting_Started#Login|Updated the login message when exceeding the number of licensed users]]
* [https://fishbowlhelp.com/files/csv/importSO.html The Sales Order CSV import now looks at the customer's priority setting if the priority field is left blank]
* [[Manufacture_Order#Module_Options_General_tab|Unchecked "Always use the multiple finished goods step" MO module option by default for new databases]]
* [[Start_Fishbowl#Creating_a_new_database|Updated the default MySQL settings for new installs]]
* [[{{REST API}}|Updated Jetty to the latest version]]
* [[Company#Module_Options_LDAP_tab|LDAP logins are now supported in the REST API]]
* [[{{REST API}}|Added the UOM object to the REST API]]
* [[{{REST API}}|Added the ability to delete a UOM through the REST API]]
* [[{{REST API}}|Added Part Search to the available REST API calls]]
* [[{{REST API}}|Added UOM Search to the available REST API calls]]
* [[{{REST API}}|Added Vendor Search to the available REST API calls]]
* [[{{REST API}}|Added the Manufacture Order object to the REST API]]
* [[{{REST API}}|Added the ability to create a Manfacture Order through the REST API]]
* [[{{REST API}}|Added the ability to issue a Manufacture Order through the REST API]]
* [[{{REST API}}|Added the ability to unissue a Manufacture Order through the REST API]]
* [[{{REST API}}|Added the ability to close short a Manufacture Order through the REST API]]
 
{{HideH2|Fixes - 2021.6}}
 
'''Client'''
* Resolved: Unable to open multiple client instances on the same computer
* Resolved: Login and logout issues that caused the client the freeze
* Resolved: Chat box goes off screen for long messages
 
'''Company'''
* Updated text for LDAP module options
 
'''CSV'''
* Resolved: Null import error when importing blank UPC with the module option "Only allow numeric characters in UPC code" enabled
* Resolved: Import issues when importing incomplete data in the UOM CSV import
 
'''Intuit Payments'''
* Resolved: Error when taking a payment for a card already stored as a wallet
 
'''Manufacture Order'''
* Resolved: Unissuing a Manufacture Order did not clear out the issue date
* Resolved: Partially fulfilling a WO, the secondary WO doesn't auto commit inventory when that option is enabled
* Resolved: Partially fulfilling a WO, the secondary WO doesn't pick from the correct location
* Resolved: Finishing a WO/MO does not allow duplicate serial numbers for separate serial type tracking
 
'''Purchase Order'''
* Resolved: Data not being saved after changing the date scheduled to the same date and choosing to update the line item dates
 
'''QuickBooks Online'''
* Resolved: "Please balance your debits and credits" error when exporting bills
 
'''Receiving'''
* Resolved: Currency showing USD for a multi currency order with the multi currency values
 
'''Sales Order'''
* Resolved: Unable to save after fulfilling a service item that is part of a kit
 
 
 
'''Database Changes'''
* Removed unused leadTimetoFulfill from the Part table
 
{{HideReleased|2021.5|05|13|21}}
{{HideH2|Highlights - 2021.5}}
 
* [[Purchase_Order#Auto_PO|Added the ability to enter a Forecast % on the Auto PO wizard Summary page]]
* [[Purchase_Order#Auto_PO|You can now set the schedule date for the Purchase Orders being created during the Auto PO wizard]]
* [[Purchase_Order#Auto_PO|Added hover over details to quantity and cost columns in the Auto PO wizard Summary page]]
* [[Purchase_Order#Auto_PO|Quantity, Unit Cost and UOM columns have been added to the Auto PO wizard Summary page]]
* [[Purchase_Order#Auto_PO|Added an option to round up quantities to the nearest whole number during the Auto PO wizard]]
* [[Purchase_Order#Auto_PO|Added the ability to edit in line on the Auto PO wizard summary page]]
* [[Purchase_Order#Auto_PO|The vendor lead-time is displayed per part in the Auto PO wizard]]
* [[Purchase_Order#Auto_PO|The Date Scheduled during the Auto PO wizard automatically uses vendor lead-times to set the date]]
* [[Receiving#Module_Options_Options_tab|Added a module option in the Receiving module to update vendor lead times when receiving a part]]
 
{{HideH2|New Features - 2021.5}}
 
* [[{{CSV}}|The Sales Order CSV pulls custom field values for customers when module option is enabled]]
* [[{{CSV}}|The Sales Order CSV pulls custom field values for products when module option is enabled]]
* [[Purchase_Order#Auto_PO|Add a delete confirmation when removing a part from a PO during the Auto PO wizard]]
* [[Company#Module_Options_Address_Validation_tab|Available Address Validation has been updated to communicate over HTTPS]]
* [[Shipping#Module_Options_Email_tab|Updated "Send email when shipment is shipped" to have options for the Shipping Report, Shipping Invoice report, or None]]
* [[Kitting#Specify_Kit_Price|The "Specify Kit Price" option now functions the same way whether the order is created via the client or CSV]]
* [[{{REST API}}|Added a Manufacture Order search call to the REST API]]
* [[{{REST API}}|Added ability to delete a Manufacture Order through the REST API]]
* [[{{REST API}}|Manufacture Order Memos can now be created/updated/deleted through the REST API]]
* [[{{REST API}}|Upgraded the REST documentation navigation pane]]
* [[{{REST API}}|Updated the Part Best Cost call to include vendor minimum quantities]]
* [[Reports#Included_reports|Packing Slip - Added carrier service. Added a "Blind Shipment" checkbox. When checked, the company logo and address info will not print]]
* [[Reports#Included_reports|Pick Ticket - Added carrier service]]
 
{{HideH2|Fixes - 2021.5}}
 
'''Accounting'''
* Resolved: Errors in export due to voiding items in receiving
 
'''Database'''
* Resolved: QtyOnOrder view not matching On Order quantity in Inventory Module
 
'''CSV'''
* Update instructions text for the Bill of Materials Details CSV
* Resolved: SO Details and SO CSV's do not check for duplicate vendor names
 
'''Customer'''
* Resolved: Tax exempt checkbox and number field showing available in the new customer wizard in Canadian databases
 
'''Gmail Integration'''
* Resolved: Old Fishbowl Logo showing on the final integration step
 
'''QuickBooks Desktop'''
* Resolved: Export error's on misc items
 
'''Part'''
* Resolved: Able to add tracking to default return as Part
 
'''Purchase Order'''
* Resolved: Ability to edit qty/cost during Auto PO on the "No Vendor" step
 
'''REST API'''
* Updated the Purchase Order search CompletedTo/From to FulfilledTo/From
* Resolved: Server Connections screen not updating for REST users on login and logout
 
'''Vendor'''
* Resolved: Vendor Last Cost not updating the Last Date when cost is updated
 
{{HideReleased|2021.4|04|15|21}}
{{HideH2|Highlights - 2021.4}}
 
* [[User#Notifications|Added Purchase Order SMS based notification subscriptions for Purchase Order approvals]]
 
{{HideH2|New Features - 2021.4}}
 
* [[QuickBooks_Online#Journal_entries|Added customer reference to Purchase Order journal entries in QuickBooks Online]]
* [[Customer#Details_tab|Increased Customer and Vendor alert notes character limit to 256]]
* [[Fishbowl_Checkout#Module_Options_General_tab|Added a module option in Fishbowl Checkout to default the Salesperson field to blank]]
* [[Access_Rights#Sales_Order|Added a user right to control access to Payment Terms dropdown on a Sales Order]]
* [[QuickBooks#Module_Options_QuickBooks_tab|Added a module option to set the Sales Order # or Shipment # to go to the QuickBooks Desktop "Other" field]]
* [[{{REST API}}|Updated custom field REST API search to search by ID instead of name]]
* [[{{REST API}}|Added the ability to close short a Purchase Order through the REST API]]
* [[{{REST API}}|Added the ability to close short Purchase Order items through the REST API]]
* [[{{REST API}}|Updated the Currency REST call to include the currency code]]
* [[{{REST API}}|Added a user search call for the REST API]]
* [[{{REST API}}|Added a get part best cost call in the REST API for Purchase Orders]]
* [[Fishbowl_API|Updated legacy VendorGet API call to link in addresses]]
* [[Advanced_Reports#Z_Report|Z Report: Now displays the salesperson and has an option to sort by various columns]]
* [[Advanced_Reports#Sales_Order_Report|SO Report: Fulfillment Date label changed to Date Scheduled (still displays the item Date Scheduled)]]
 
{{HideH2|Fixes - 2021.4}}
 
'''API'''
* Resolved: Calls not setting the userid on the REVINFO table
 
'''Client'''
* Resolved: Inactivity causing the client application to become unresponsive
 
'''CSV'''
* Resolved: EDI Shipping blank export due to Null error
* Resolved: Sales Order CSV instructions text update
* Resolved: Locations import running slow when importing 1000's of location for a single location group
* Resolved: Slowness when importing the Receiving Data import
 
'''Custom Fields'''
* Resolved: Slowness with custom lists
 
'''Part'''
* Resolved: Issues changing the default return as part when duplicating an outsourced part
 
'''Picking'''
* Resolved: Pick Location selection issue across multiple locations
 
'''Product'''
* Resolved: Product Module Sort by Product Type sorting issue
 
'''Purchase Order'''
* Resolved: Unable to unissue Purchase Order after voiding receipt
* Resolved: Outsourced PO item Null error
* Resolved: Auto PO location group reordering issue
 
'''QuickBooks Online'''
* Resolved: Receiving holding account entry not being reversed upon fulfill
* Resolved: Purchase Order journal entries should set the class for the line item and not the order class
 
'''QuickBooks Online - Australia'''
* Resolved: Imbalance and rounding issues
 
'''QuickBooks Online - Canada'''
* Resolved: Query Parse Export error on Invoice
 
'''Receiving'''
* Resolved: Discrepancy between multi-currency subtotal and billed total
 
'''Reports'''
* Resolved: Sales By Rep BI Report - Not including discounts
* Resolved: Inventory Availability Report - Available to Pick calculating incorrectly
 
'''REST API'''
* Resolved: Blank error for Purchase Orders with tax rate of none on Non-US databases
* Resolved: Documentation for QB Class listing as option but it is being required
* Resolved: Inconsistencies between Purchase Order and Purchase Order item Tax Rate references on the documentation
 
'''RMA'''
* Resolved: Null error when creating a Return and not verifying by order
 
'''Work Order'''
* Resolved: Seemingly random quantities when splitting repair Work Order lines
 
 
'''Database Changes'''
* Updated Customer.note field to be varchar(256)
* Updated Vendor.note field to be varchar(256)
* Created Notification table
* Created NotificationType table
 
{{HideReleased|2021.3|03|11|21}}
{{HideH2|Highlights - 2021.3}}
 
* [[Purchase_Order#Module_Options_General_tab|Added the ability to require approval for Purchase Orders over a specified dollar amount]]
* [[Access_Rights#Purchase_Order|Added user right to allow users to approve Purchase Orders in the Pending Approval status]]
* [[Shipping#Module_Options_Ship_Items_tab|Added the ability to assign different print defaults for packing and shipping]]
 
{{HideH2|New Features - 2021.3}}
 
* [[Fishbowl_Anywhere|Added logos for plugins into the module header bar]]
* [[Sales_Order|Sales Orders created by RMAs without a verified order will use customers default salesperson]]
* [[Access_Rights#Sales_Order|Added a user right to limit access to the Payment Deposit Account in the payment wizard]]
* [[Access_Rights#Sales_Order|Added a user right to limit access to the Payment Date in the payment wizard]]
* [[{{REST API}}|Added Home Currency flag on currency object for Purchase Order REST API]]
* [[{{REST API}}|Added total cost for Purchase Order in REST API]]
* [[{{REST API}}|Updates to error messages when using the Purchase Order REST API]]
* [[{{REST API}}|Added the ability to access memos in the Purchase Order REST API]]
 
{{HideH2|Fixes - 2021.3}}
 
'''Checkout'''
* Resolved: Null error when fulfilling a credit return
 
'''CSV'''
* Resolved: Bad error message for duplicate abbreviation when importing the UOM csv
* Resolved: Imported discount amounts not coming in properly for multi currency customers
 
'''Customer'''
* Resolved: Customers with stored wallets not loading due to missing icons
 
'''Database Update'''
* Resolved: Database update failure due to multiple shipping invoice reports
 
'''Installer'''
* Resolved: Inability to install a Client Only version due to license key requirement
* Updated the installer to exclude the webapp folder on Client Only installs
 
'''Kits'''
* Resolved: UOM UI conversion error when editing quantities on a Sales Order
 
'''Linux'''
* Resolved: Notification animation causing the client to lock up
* Resolved: Environments without a system tray unable to see server window
 
'''Purchase Order'''
* Resolved: Line item notes not saving on partial or fulfilled status line items
* Resolved: Unissuing a PO does not clear out the date issued
* Resolved: Unissuing a PO does not change the Last Modified info
 
'''QuickBooks Desktop - Canadian'''
* Resolved: Issues with Sales Receipts vs Invoice/Payment creation on export
* Resolved: Rounded cash transactions not exporting the amount on sales receipts
 
'''QuickBooks Online'''
* Resolved: Business Validation error on export
* Resolved: Jobs imported from QuickBooks Online creating new job entries on export
 
'''Receiving'''
* Resolved: Errors when receiving an outsourced item with a rejection
 
'''REST API'''
* Resolved: Bad error message when updating an existing Purchase Order
 
'''Database Updates'''
* Dropped dependencies on SOITEMTOMOITEM table
* Module Table
* Renamed “Shipping Label” to “Shipping Invoice”
* PO Table
* Added column IssuedByUserId int(11) default null
* POStatus Table
* Increased Name column to 20 characters
* Added “Pending Approval” with id 15
 
{{HideReleased|2021.2|02|18|21}}
{{HideH2|Highlights - 2021.2}}
* [[Start_Fishbowl#Parts_of_the_Screen|Fishbowl's look and feel has been updated with a new color scheme, icons, and splash screen for 2021]]
* [[{{REST API}}|Beta release of web based Rest API with endpoints for Purchase Orders]]
 
{{HideH2|New Features - 2021.2}}
 
* [[Sales_Order#Search|The Advanced Search for sales orders has a new tab to be able to search line item custom fields]]
* [[Customize_Fishbowl#Program_Options|Added a Program Option for setting the table line height throughout Fishbowl]]
* [[Sales_Order#Module_Options_Custom_tab|Updated the description for the custom report text in the Sales Order module options]]
* [[Getting_Started#1._Install_Fishbowl|Added additional license key and support contract validation during installation]]
* [[Getting_Started#1._Install_Fishbowl|The installer has been updated to include a few "Things to consider before updating"]]
* [https://fishbowlhelp.com/files/csv/importPart.html The Part CSV import now has the ability to assign a default outsourced return part]
* [https://fishbowlhelp.com/files/csv/importBCReceiving.html The Receiving Data CSV import now has the ability to update shipping information for the order]
 
{{HideH2|Fixes - 2021.2}}
 
'''API'''
* Resolved: API not updating UserID on audit tables
 
'''Accounting Exports'''
* Resolved: Issues causing the Mark as Posted function to fail
 
'''Client'''
* Resolved: Auto logout caused the Sales Order module to lock up
* Resolved: Auto logout not closing additional open windows (Advanced Searches, etc.)
 
'''Company'''
* Updated text in Module Options
 
'''CSV'''
* Updated instructions text on Part Cost import/export
* Updated instructions text on Part UOM import/export
* Resolved: Locations import no updating location types
* Resolved: Sales Order CSV import does not transfer line item notes to the Work Order for Build to Order products
* Resolved: "Duplicate Bill of Materials Option Group found" import error when modifying parts on the Bill of Materials
 
'''Custom Fields'''
* Resolved: Long Text type custom fields not providing a scroll bar when needed
 
'''Intuit Payments'''
* Resolved: A declined payment did not show the appropriate exception when taking a payment
 
'''Location'''
* Resolved: Location type of a default location could be changed
 
'''Location Groups'''
* Resolved: Inactive users showing in location group user section
 
'''Manufacture Order'''
 
* Significant speed improvements to Advanced Search
 
'''Purchase Order'''
* Resolved: Being able to search order custom fields without user access rights assigned
 
'''QuickBooks Online'''
* Resolved: Part/Product/Item validation errors
* Resolved: Updating customer details in Fishbowl erasing customer info in QuickBooks Online
* Resolved: A miscellaneous sale not hitting the COGS Account when cost was added
* Resolved: "Cannot Change who Customer Bills With" error when exporting customer job updates
* Resolved: Missing classes on reconciled journal entries
* Resolved: Partially shipped kits sending tax twice
 
'''QuickBooks Online AU'''
* Resolved: Updating vendor info in Fishbowl erases banking info on export
 
'''Sales Order'''
* Resolved: Price discrepancies when closing short a drop ship order
* Resolved: Add button in Custom Work Order wizard not functional
* Resolved: FedEx Shipping Tracking # link did not pull up the tracking on www.fedex.com
* Resolved: Divide by zero error when partially shipping and closing short an order with a kit
 
'''Schedule'''
* Resolved: Sorting issues when sorting the Last Run Time column
 
'''Shipping'''
* Resolved: Shipping custom fields clearing out when saving with shipping through ShipExpress
 
'''Tax Rate'''
* Resolved: View only rights still allowing users to edit tax rates
 
'''UOM'''
* Updated text descriptions during the Add New UOM Conversion Wizard
 
'''Work Order'''
* Resolved: Save dialog popping up when nothing was changed
 
 
'''Database Changes'''
* Remove SOITEMTOMOITEM table
* Added a new column to the MOITEM table for SOITEMID

Revision as of 11:26, 1 September 2022

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


​

AUG 11, 2022 - Advanced 2022.8

Download - 2022.8

Highlights - 2022.8

  • Functionality has been added to better allow for the organization of the Modify Report window. Additional tabs can now be added, along with grouping and sorting inside of each tab. We’ve also made it possible for the displaying of tooltips for each setting within the tabs. Select reports have been updated to make use of this new functionality (SO Report, Customer Purchase History, & Part Activity Report). Additional reports will be updated in the coming months.
  • The Sales Order Report now has the ability to modify all field titles.
New Features - 2022.8

Fixes - 2022.8

Class

  • Resolved: Creating a new class freezing the client or giving an error but still creating the class depending on client connection type

CSV

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

Product

  • Resolved: Adding products to a product tree caused the client to freeze when using the non-web connection

Receiving

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

REST API

  • Resolved: Missing information on Import data via JSON curl example
  • Resolved: Null error when using the MO Create call when the user does not have a default location group and does not specify a location group in the request

Sales Order

  • Resolved: Kit pricing becoming incorrect when changing the customer on the order

Server

  • Resolved: Logging out API users not logging out the API users

Database Changes

  • Removed Substitute product links from kits on the KITITEM table


JUL 14, 2022 - Advanced 2022.7

Download - 2022.7
Highlights - 2022.7
  • [[Template:REST API|The web connection Client functionality is now available to all users]]
  • [[Template:REST API|New Fishbowl installs now use the web connection by default]]
New Features - 2022.7
Fixes - 2022.7

CSV

  • Updated Bill of Materials and Bill of Materials Details CSV instruction to remove Work Order as a BOM Item Type

Checkout

  • Resolved: Advanced search default filters not saving

Database Rebuild

  • The PARTCOST table is now cleared out on rebuild

Inventory

  • Resolved: Blank WO column storing last WO hyperlink value

Part

  • Resolved: UOM conversion error when changing a parts UOM when it has an associated with a bill of materials

Purchase Order

  • Resolved: Alert Notes not being displayed when adding parts via the + button

QuickBooks Online

  • Resolved: Initial connection null error

REST API

  • Resolved: Create PO call causing an error when a location group is not specified

Shipping

  • Resolved: Weight showing 0 when the product UOM doesn’t have a conversion set for the default weight UOM

Web Connection

  • Resolved: Report errors when using the web connection
  • Resolved: Xero accounts not being auto selected when they already exist
  • Resolved: QBO accounts not being auto selected when they already exist
  • Resolved: Company module displaying blank information
  • Resolved: Find Fishbowl Servers magnifying glass returning a blank result

Work Order

  • Resolved: Assigned users not saving when being set by right clicking on a Work Order


JUN 9, 2022 - Advanced 2022.6

Download - 2022.6
Highlights - 2022.6
Fixes - 2022.6

Checkout

  • Resolved: Selecting an order tax rate being required for international customers

Consignment

  • Resolved: Auto Replenish being unable to finish

Database Rebuild Tool

  • Resolved: Memo's not being cleared out on rebuild
  • Resolved: Costing layers not being cleared out on rebuild

Picking

  • Resolved: UOM conversion issue when voiding the pick for a Work Order
  • Resolved: Slot numbering issues when adding additional picks to an existing group pick

Purchase Order

  • Resolved: Null error running the Auto PO with an empty summary page
  • Resolved: Outsourced Returning As UOM conversion error in receiving

Receiving

  • Resolved: Item receiving user rights erroring when receiving tracked items

REST API

  • Resolved: Address creation issues when creating Purchase Orders

Sales Order

  • Resolved: Incorrect salesman displayed after creating a new user

Shipping

  • Resolved: Fixed column width not saving after logging out

Vendor

  • Updated the example databases vendor costing rules names to match functionality

Work Order

  • Resolved: Error when saving a Work Order after removing the class selection


MAY 19, 2022 - Advanced 2022.5

Download - 2022.5
Highlights - 2022.5
Fixes - 2022.5

Database Update

  • Resolved: Update issues related to removing UPS Ready


APR 22, 2022 - Advanced 2022.4.1

Download - 2022.4.1
Highlights - 2022.4.1
  • Updated Fishbowl to account for a Java remote code execution vulnerability
Fixes - 2022.4.1

Fishbowl GO

  • Resolved: Unable to Pack a shipment

Picking

  • Resolved: Unable to void picks that were finished prior to the update to 2022.4

Database Changes

  • Removed DCOPTIONS table
  • Removed PACKAGETYPES table
  • Removed PACKAGETYPEID column from SHIPCARTON table
  • Removed DELIVERYCONFIRMATIONID column from SHIPCARTON table


APR 14, 2022 - Advanced 2022.4

Download - 2022.4
Highlights - 2022.4
New Features - 2022.4
Fixes - 2022.4

API

  • Updated password hash change on Java and C# code samples

Bill of Materials

  • Resolved: Module options are available to all regardless of user right settings

Clover Connect

  • Resolved: Wallets disappearing on update
  • Additional name updates for Clover Connect rebrand

CSV

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

License

  • Removed "ExpressTech" from license agreements

Mac Version

  • Resolved: MySQL port defaulting to 3306 when creating a new database

Database Changes

  • Removed SHIPUPSCARTONDETAILS table
  • Removed SHIPUPSCARTONDETAILS_AUD table
  • Removed SHIPUPSDETAILS table
  • Removed SHIPUPSDETAILS_AUD table
  • Removed UPSACCOUNT table
  • Removed UPSACCOUNT_AUD table
  • Removed UPSCOD table
  • Removed UPSPAYMENTTYPE table
  • Removed UPSRETURNSHIPMENT table
  • Removed UPSRETURNSHIPMENT_AUD table
  • Removed column UPS from the COUNTRYCONST table


MAR 10, 2022 - Advanced 2022.3

Download - 2022.3
Highlights - 2022.3
New Features - 2022.3
Fixes - 2022.3

API

  • Updated the REST documentation for logging out

Client

  • Resolved: Client auto update not including all required files

Server

  • Optimized server startup when connection to Fishbowl's online services are interrupted


Database Changes

  • Removed the READONLY column from the BISCRIPT table
  • Updated OUTSOURCEDPARTNUMBER and OUTSOURCEDPARTDESCRIPTION on the POITEM table to be empty strings instead of null


FEB 15, 2022 - Advanced 2022.2.1

Download - 2022.2.1
Fixes - 2022.2
  • Resolved: Client Auto Update running for plugins causing the client to become inoperable


FEB 10, 2022 - Advanced 2022.2

Download - 2022.2
Highlights - 2022.2
New Features - 2022.2
Fixes - 2022.2

Accounting Exports

  • Resolved: "The total debits must equal total credits" export error due to rounding differences (AU)

CSV

  • Resolved: Sales Order Details CSV failing due to no data being provided to a required custom field with the "Create an access right to restrict the modification of this field" custom field option enabled
  • Resolved: Sales Order CSV failing due to no data being provided to a required custom field with the "Create an access right to restrict the modification of this field" custom field option enabled

Part

  • Resolved: Cost discrepancy caused by voiding a shipment and reconciling a purchase order

Picking

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

QBO

  • Resolved: Export errors due to duplicate tax rates (Canada)

Sales Order

  • Resolved: Amounts not be classified as negative when currency uses a trailing negative sign

Xero

  • Resolved: Vendor street address pulling the company address instead of the vendors address


JAN 13, 2022 - Advanced 2022.1

Download - 2022.1
Highlights - 2022.1
New Features - 2022.1
Fixes - 2022.1

CSV

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

Dashboard

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

Email Settings

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

Sales Order

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


DEC 9, 2021 - Advanced 2021.12

Download - 2021.12
Highlights - 2021.12
New Features - 2021.12
Fixes - 2021.12

API

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

Part

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

Pricing Rules

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

Purchase Order

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

REST API

  • Resolved: Product Best Price curl command text update

Database Changes

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


NOV 11, 2021 - Advanced 2021.11

Download - 2021.11
Highlights - 2021.11
New Features - 2021.11
Fixes - 2021.11

CSV

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

Customer

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

Dashboard

  • Resolved: Report Widget arrows being backwards

QuickBooks Desktop

  • Improved error messaging for errors dealing with Closing Dates

Sales Order

  • Resolved: Sales Order item details dialog loading slowly

Shipping

  • Resolved: Slowness shipping large quantities of kits

Time

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

Xero

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

Database Changes

  • Removed SOITEMTOMOITEM table


OCT 14, 2021 - Advanced 2021.10

Download - 2021.10
Highlights - 2021.10
New Features - 2021.10
Fixes - 2021.10

Checkout

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

CSV

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

Customer

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

Part

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

QuickBooks Desktop

  • Resolved: No Certificate being displayed when integrating

REST API

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

Settings

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

Server

  • Improved calculation rounding precision in situations dealing with money

Square Payment Gateway

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

Transfer Order

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

Vendor

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

Work Order

  • Issue: Error when creating a custom Work Order where the Finished Good is a Kit
  • Resolution: Removed Kits from the available list when selecting a Finished Good

Xero

  • Issue: Balance Debits and Credits error displaying only the PO Ref #
  • Resolution: The PO # is now displayed in the error as well as the PO Ref #

Database Updates

  • Added CONSUMPTIONRATE column to the PART table


SEP 9, 2021 - Advanced 2021.9

Download - 2021.9
Highlights - 2021.9
New Features - 2021.9
Fixes - 2021.9

Accounting Integrations

  • Issue: "Balance Debits and Credits" export error
  • Resolution: Locked down scenarios allowing for landing costs across multiple reference #'s and bill dates

CSV

  • Resolved: Pricing Rule CSV duplicate entry error

Picking

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

Square

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

Work Order

  • Resolved: Custom Work Order wizard allowing partial eaches


Database Changes

  • Resolved: Added dateExpiration column to the PaymentGateway table


AUG 12, 2021 - Advanced 2021.8

Download - 2021.8


Highlights - 2021.8
Fixes - 2021.8

Accounting Intergrations

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

API

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

Client

  • Resolved: Server Shutdown Timer message showing an error

CSV

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

Linux

  • Resolved: Incorrect line encoding in eve.sh file

QBO

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

REST API

  • Resolved: UserId missing from login request

Work Order

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

Xero

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


JUL 15, 2021 - Advanced 2021.7

Download - 2021.7
Highlights - 2021.7
New Features - 2021.7
Fixes - 2021.7

Custom Fields

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

Fishbowl Client

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

Pick

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

QuickBooks Desktop

  • Resolved: Miscellaneous Credit general journal entries posting incorrectly
  • Issue: Payments exporting and automatically applying to Invoices incorrectly
  • Resolution: Added a module option for Automatically Applying Payments that can be disabled

QuickBooks Online

  • Resolved: Vendor credit return posting incorrect journal entries

REST API

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

UOM

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

User Group

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

Xero AU

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


JUN 10, 2021 - Advanced 2021.6

Download - 2021.6
Highlights - 2021.6
New Features - 2021.6
Fixes - 2021.6

Client

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

Company

  • Updated text for LDAP module options

CSV

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

Intuit Payments

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

Manufacture Order

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

Purchase Order

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

QuickBooks Online

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

Receiving

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

Sales Order

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


Database Changes

  • Removed unused leadTimetoFulfill from the Part table


MAY 13, 2021 - Advanced 2021.5

Download - 2021.5
Highlights - 2021.5
New Features - 2021.5
Fixes - 2021.5

Accounting

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

Database

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

CSV

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

Customer

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

Gmail Integration

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

QuickBooks Desktop

  • Resolved: Export error's on misc items

Part

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

Purchase Order

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

REST API

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

Vendor

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


APR 15, 2021 - Advanced 2021.4

Download - 2021.4
Highlights - 2021.4
New Features - 2021.4
Fixes - 2021.4

API

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

Client

  • Resolved: Inactivity causing the client application to become unresponsive

CSV

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

Custom Fields

  • Resolved: Slowness with custom lists

Part

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

Picking

  • Resolved: Pick Location selection issue across multiple locations

Product

  • Resolved: Product Module Sort by Product Type sorting issue

Purchase Order

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

QuickBooks Online

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

QuickBooks Online - Australia

  • Resolved: Imbalance and rounding issues

QuickBooks Online - Canada

  • Resolved: Query Parse Export error on Invoice

Receiving

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

Reports

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

REST API

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

RMA

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

Work Order

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


Database Changes

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


MAR 11, 2021 - Advanced 2021.3

Download - 2021.3
Highlights - 2021.3
New Features - 2021.3
Fixes - 2021.3

Checkout

  • Resolved: Null error when fulfilling a credit return

CSV

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

Customer

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

Database Update

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

Installer

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

Kits

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

Linux

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

Purchase Order

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

QuickBooks Desktop - Canadian

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

QuickBooks Online

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

Receiving

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

REST API

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

Database Updates

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


FEB 18, 2021 - Advanced 2021.2

Download - 2021.2
Highlights - 2021.2
New Features - 2021.2
Fixes - 2021.2

API

  • Resolved: API not updating UserID on audit tables

Accounting Exports

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

Client

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

Company

  • Updated text in Module Options

CSV

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

Custom Fields

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

Intuit Payments

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

Location

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

Location Groups

  • Resolved: Inactive users showing in location group user section

Manufacture Order

  • Significant speed improvements to Advanced Search

Purchase Order

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

QuickBooks Online

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

QuickBooks Online AU

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

Sales Order

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

Schedule

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

Shipping

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

Tax Rate

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

UOM

  • Updated text descriptions during the Add New UOM Conversion Wizard

Work Order

  • Resolved: Save dialog popping up when nothing was changed


Database Changes

  • Remove SOITEMTOMOITEM table
  • Added a new column to the MOITEM table for SOITEMID
Retrieved from "https://fishbowlhelp.com/a/index.php?title=Release_Notes&oldid=2555"