Release Notes

From Fishbowl
Revision as of 16:50, 11 January 2018 by Dnewsom (talk | contribs)
Jump to navigation Jump to search

Contents

2018.2 Release Notes - SCHEDULED RELEASE DATE 2/8/2018

Considerations before updating - 2018.2 Template:Top

Highlights - 2018.2 Template:Top

New Features - 2018.2 Template:Top

Fixes - 2018.2 Template:Top

Plugins - 2018.2 Template:Top

Database Changes - 2018.2 Template:Top

2018.1 Release Notes - 1/11/2018

Considerations before updating - 2018.1 Template:Top

  • If you are updating to 2018.1 from a version that is older than 2017.1 please note that you will first need to update to a version between 2017.1 and 2017.9 before proceeding with this version.

Highlights - 2018.1 Template:Top

New Features - 2018.1 Template:Top

Fixes - 2018.1 Template:Top

Authorize.net

  • Issue: Using wallet cards would fail unless the wallet was processed with the card security code.
  • Resolution: The card security code will only be required if your account settings require it.

Calendar

  • Issue: The calendar module does not work for displaying orders on newly created databases.
  • Resolution: All calendar functionality is now working correctly.

Checkout

  • Issue: Checkout does not have a view access right.
  • Resolution: A view access right was created to be in line with all other modules.
  • Issue: Checkout does not work properly unless the user has the Sales Order-QuickShip access right.
  • Resolution: Users can now process orders as long as they have access to Checkout.
  • Issue: Checkout is unable to process payments for credit return orders.
  • Resolution: Processing credit payments now works correctly unless it is a credit card type. This will still need to be processed in the Payment Viewer module if you are connected to a Payment Gateway.

CSV Import/Export

  • Issue: The Part and Product CSV's cannot import part images.
  • Resolution: Both CSV's can now upload images correctly.
  • Issue: The Currency CSV instructions reference "QB Class".
  • Resolution: This incorrect reference has been removed.
  • Issue: The Payment Data CSV will import payments with a $0 amount causing errors when exporting to accounting.
  • Resolution: Payments with $0 will be skipped on the import.

Manufacture Order

  • Issue: Changing an items quantity to 0 on the WO Details tab will cause it's associated pick item to also be changed to 0.
  • Resolution: Items can no longer be set to a 0 quantity on the WO Details tab.

Part

  • Issue: The edit window for Vendor Parts is too small and cuts off the Default checkbox.
  • Resolution: The Vendor Parts edit window is now sized correctly.

Pick

  • Issue: Some picks are not able to be opened and receive a null error due to an issue with location sorting.
  • Resolution: These picks no longer receive an error and open correctly.

Product

  • Issue: If you delete a product that has custom field data then open another product the module would ask you to save changes.
  • Resolution: Custom field data is no longer left filled in after deleting a product so it will not ask to save changes to a blank product.

Receiving

  • Issue: Reconciling a part will fail if that part was received and then was on a pick and shipment that were both voided after being shipped.
  • Resolution: This scenario no longer causes an error as the voided shipment should not be considered during the reconcile process.

Sales Order

  • Issue: Sales Order items with Manufacturing configurations can take a long time to open if you have a lot of images.
  • Resolution: Added better indexing to the Image table to load these orders much faster.

Plugins - 2018.1 Template:Top

Database Changes - 2018.1 Template:Top

2017.13 Release Notes - 12/18/2017

Considerations before updating - 2017.13 Template:Top

  • If you are updating to 2017.13 from a version that is older than 2017.1 please note that you will first need to update to a version between 2017.1 and 2017.9 before proceeding with this version.
  • If you have already updated to 2017.12 and are having issues with images, please contact support as additional steps may be needed to update to 2017.13.

Fixes - 2017.13 Template:Top

Issue: After updating to 2017.12, some companies are seeing issues with images being incorrect and in some cases are not able to make changes to those images.

  • Resolution: Images are now migrating correctly and can be updated as needed. If you are having these issues on 2017.12, please contact support and they can help you through the process of correcting the problem.


2017.12 Release Notes - 12/14/2017

Considerations before updating - 2017.12 Template:Top

  • If you are updating to 2017.12 from a version that is older than 2017.1 please note that you will first need to update to a version between 2017.1 and 2017.9 before proceeding with this version.
  • If you install 2017.12 to a new folder, you will need to move your Images folder from the previous Fishbowl install to your new install folder in order for your images to migrate.
  • Any custom reports that include images may be impacted by the change to storing images in the database directly. Please contact the custom reports team (email: reportsEmail.pngfishbowlinventory.com) before updating to ensure that your custom report is compatible with 2017.12.

Highlights - 2017.12 Template:Top

New Features - 2017.12 Template:Top

Fixes - 2017.12 Template:Top

Accounting

  • Issue: Updating currency conversions gets an error when using Yahoo as the conversion source.
  • Resolution: Yahoo has discontinued their finance API. Please connect to QuickBooks Desktop in order to import currency conversions or use our new Currency CSV import option.

Checkout

  • Issue: The window that opens when a user needs admin approval to override a price is not sizing correctly.
  • Resolution: The override window now sizes correctly and contains more information on what is needed.

CSV Import/Export

  • Issue: Product CSV fails to create new products if the carton count field is left blank.
  • Resolution: New products can now be created with or without the carton count field data.
  • Issue: The Product CSV can create products for part types that don't allow products as long as the part already exists.
  • Resolution: The Part type is now validated on import and products can only be created for part type's that allow products.
  • Issue: New Info field is not included on the Payment Data CSV.
  • Resolution: The Info field has been added to the Payment Data CSV.

Manufacture Order

  • Issue: Using the Search icon then selecting an item from the list does not add it to the order when you close the dialog.
  • Resolution: The first highlighted item in the list will now be added to the Manufacture Order.

Payment Gateway

  • Issue: If you are not integrated with a Payment Gateway, selecting a Check or E-check method in the payment wizard does not work.
  • Resolution: You can now use Check and E-check regardless of Payment Gateway status. (patch available for 2017.11 version, please contact support if needed.)
  • Issue: When integrated with Authorize.net, Check functions the same as E-check requiring an account and routing number.
  • Resolution: Check now functions as intended asking for a check number and reference. (patch available for 2017.11 version, please contact support if needed.)
  • Issue: Using Wallet cards for payment with Authorize.net fails in some cases citing that the security code cannot be left blank.
  • Resolution: A Security Code field has been added to the payment dialog in case it needs to be used for Wallet Cards.
  • Issue: On a Sales Order with a negative total price, selecting a Wallet card for the payment method will process the payment with a positive amount instead of directing you to the Payment Viewer module to use the Refund feature.
  • Resolution: Regardless of payment method, the payment wizard will direct you to the Payment Viewer module if the amount on the payment is negative.

QuickBooks Desktop

  • Issue: Exporting a Check type payment to QuickBooks was adding "Check #" to the data entered in the field.
  • Resolution: We now only send the Check number itself instead of all the data in our payment info field.

Reports

  • Issue: AU Only: In some cases the tax amount calculated on the Sales Order report and the Shipping Invoice report does not match what shows in the Sales Order module.
  • Resolution: These reports have been updated to round correctly to match the Sales Order module UI.

Sales Order

  • Issue: Product alert notes are not displaying if items are added through the Add SO Item wizard.
  • Resolution: Product alerts now display once a product is selected and you hit Next in the wizard.
  • Issue: If a user doesn't have the Price Override user right, they can still add Discounts through the Add wizard.
  • Resolution: The manager approval window will now ask for a valid user name and password when adding Discounts this way without the Price Override user right.
  • Issue: Adding line items to an issued Sales Order and hitting the Check Inventory button without saving first will cause a duplicate pick to be created.
  • Resolution: Using the Check Inventory button now saves the Sales Order correctly and will add new items to the current pick instead of creating a new one.

Vendor

  • Issue: New Vendors can be created from the Purchase Order Vendor drop down even if a user does not have Edit access for Vendors.
  • Resolution: The Purchase Order Vendor drop down now checks user access correctly.

Xero

  • Issue: AU Only - Exporting a credit return sales order with the amount includes tax box checked will not send the invoice properly to Xero.
  • Resolution: Credit return Sales Orders now send to Xero correctly for amounts include tax.

Plugins - 2017.12 Template:Top

Avalara

  • Issue: If a sales order item is split into different cartons on the shipment you may get a $0.00 item sent to Avalara returning no tax.
  • Resolution: The correct price is sent to Avalara regardless of how quantities are split on shipments.
  • Issue: If a Sales Order is set to use Avalara and the shipment is only packed, it will not let you void the shipment.
  • Resoltuion: As long as the order has not been shipped, you can use the Void button to undo a packed status.

Fishbowl GO for Android

  • Issue: When you don't have the access right to overpick Work Order's it errors saying you can't pick a quantity greater than what is listed.
  • Resolution: We now display an error message specifically saying you need the access right to overpick.

Database Changes - 2017.12 Template:Top

  • Added image table

2017.11 Release Notes - 11/9/2017

Considerations before updating - 2017.11 Template:Top

  • If you are updating to 2017.11 from a version that is older than 2017.1 please note that you will first need to update to a version between 2017.1 and 2017.9 before proceeding with this version.
  • Storing payment card information has been converted to a payment gateway specific token based system. Any payment card information stored prior to updating to 20107.11 will be removed from Fishbowl and will need to be reentered using the new "Customer Wallet" functionality.

Highlights - 2017.11 Template:Top

New Features - 2017.11 Template:Top

Fixes - 2017.11 Template:Top

General

  • Issue: Customer, Vendor, Part, and Company modules all store a user name of only 15 characters when user name can be 100 characters.
  • Resolution: Tables have been updated to 100 characters for storing the user name.
  • Issue: When created a new blank database the Core option in Product module options is left blank.
  • Resolution: Added a default "-Core%' value to this module option so other options can be changed without having to enter something new into the field.

Authorize.Net

  • Issue: When zip code is selected as an option, it will only send to Authorize.Net if the all the address options are selected.
  • Resolution: Each billing address option now processes correctly regardless of other options selected.

CSV Import/Export

  • Issue: A number of CSV Imports were refreshing the entire cache of items instead of just the changes made by the CSV causing the import to take an extended period of time.
  • Resolution: The following CSV's now refresh cache appropriately: Part, Product, Part Product and Vendor Pricing, Customer, Customer Parts, Part Units of Measure, Part/Product Renaming, Purchase Order, Vendor, Kit Items, Tax Rates, and QuickBooks Class.
  • Issue: The Sales Order CSV import will create a blank customer record for the order if CustomerName is blank on the CSV.
  • Resolution: The Sales Order CSV will now check if CustomerName is filled in and will error if it's blank.
  • Issue: The Sales Order CSV is not creating customer contact details when creating a new customer.
  • Resolution: The customer contact details will now save to the customer record on import.

Fishbowl GO

  • Issue: If you don't have View access to the Data module, the message on login is unclear.
  • Resolution: New error message tells you that you need the Data-View access right.
  • Issue: In some parts of Fishbowl GO you could not load a part number if it contained an apostrophe.
  • Resolution: The apostrophe character can now be searched for correctly.
  • Issue: When using the "Print From Device" setting the reports would be saved with the "Format Report for Exporting" option selected.
  • Resolution: Reports now print all pages correctly from GO.
  • Issue: When using the "Scan each individual item" option in Packing you are not able to scan a product UPC code once the edit screen is available.
  • Resolution: Using Product UPC is now working correctly when in the packing item edit screen.
  • Issue: When using the "Scan each individual item" in Picking, if the part you're editing doesn't have any Vendor associations and you type in the quantity to edit, Fishbowl GO will force close.
  • Resolution: In the Picking item edit window, decimal quantities can now be set regardless of Vendor parts or options selected.

Purchase Order

  • Issue: Fulfilling and exporting a receipt to Accounting and then voiding that receipt and immediately voiding the PO will remove the post records and not remove the PO from Accounting.
  • Resolution: Attempting to Void a PO after the Receipt is voided will require you to export to Accounting first.

QuickBooks Online

  • Issue: Using an American Express for payment would fail to export the payment details due to the reference being too long.
  • Resolution: Change Info saved to payment to says "Amex" instead of "American Express" to be within the required length.

Reports

  • Issue: Attempting to save reports as a .xls file will cause an error.
  • Resolution: Reports can again be saved as any of the available file types.
  • Service Order
  • Kit Header line would show when price was $0 and "Show Products with zero dollar value" was unchecked. Updated the report to exclude zero dollar Kit Header line items.
  • All Barcode Labels
  • Centered the barcode on the label.

Sales Order

  • Issue: When using a Drop Ship item, the Carrier does not transfer from the Sales Order to the new Purchase Order.
  • Resolution: Carrier now transfers from Sales Order to Purchase Order for Drop Ship items.
  • Issue: When carton based shipping is turned on and you back date a shipment, the shipping line added to the Sales Order is using today's date for the fulfilled date instead of the date used on the shipment.
  • Resolution: The shipping line item will use the date used on the shipment.
  • Issue: When taking multiple payments, hitting enter does not advance the confirmation dialog to take the next payment.
  • Resolution: Hitting enter will now advance the dialog and continue to the payment screen.

Shipping

  • Issue: When using the Product carton count feature the cartonCount field on the ship record does not populate correctly.
  • Resolution: Ship.cartonCount now populates the correct number or cartons when using Product carton count.

Plugins - 2017.11 Template:Top

Database Changes - 2017.11 Template:Top

  • posTransaction table - removed reference column
  • Added wallet and walletPayment tables

2017.10 Release Notes - 10/12/2017

Considerations before updating - 2017.10 Template:Top

  • If you are updating to 2017.10 from a version that is older than 2017.1 please note that you will first need to update to a version between 2017.1 and 2017.9 before proceeding with this version.
  • If you are having trouble starting your server on Mac or Linux, you may need to add a timezone setting to your MySQL .cnf file. Find your current .cnf file then add this line: default_time_zone=-07:00
  • The -07:00 number represents the Mountain timezone. Please adjust your timezone number accordingly (i.e. -08:00 for Pacific time)

Highlights - 2017.10 Template:Top

New Features - 2017.10 Template:Top

Fixes - 2017.10 Template:Top

General

  • Issue: Selecting multiple emails in an email wizard will cause an SMTP error.
  • Resolution: Selecting multiple emails now sends correctly to all addresses selected.

Accounting

  • Issue: Changing the cost of an item in between fulfilling and exporting a Work Order will cause the transaction to fail when exporting to QuickBooks Online or Xero.
  • Resolution: The standard cost of items is now stored at completion of Work Orders to avoid errors or future cost problems.

Customer

  • Issue: If a customer name included "\" then it would fail when exporting to QuickBooks Desktop.
  • Resolution: Corrected the issue for both customer and vendor names.

Inventory

  • Issue: When using an Outsourced item on a PO and going from one part to a different part, the new part's On Order count is not increased.
  • Resolution: On Order now reflects the new part that will be received in place of the old part for Outsourced items.
  • Issue: If a new part has never had inventory, attempting to edit the average cost will cause errors.
  • Resolution: You can only edit the average cost if you have current inventory available.

Payment Viewer

  • Issue: Delete and Refund payments always showed available even if no payment was loaded.
  • Resolution: Delete and Refund options only show when available to use.
  • Issue: Refunding a cash payment would cause an error.
  • Resolution: Cash payments can now be refunded.
  • Issue: Attempting to refund payments from previous versions of Fishbowl would not display an error if the Store Credit card option was turned off when the payment was taken.
  • Resolution: This scenario will now display an error correctly.

Picking

  • Issue: If a pick is fully committed, changing the Location Group option will not flag the pick as changed and you can't save the pick.
  • Resolution: Changing the Location Group drop down will now mark the order as changed and will save accordingly.

Product

  • Issue: The Inventory info button on the Details tab shows no inventory info.
  • Resolution: This inventory info button now shows inventory correctly based on user access.

Purchase Order

  • Issue: Outsourced PO's use the company ship to address from the order on the shipment created instead of the vendor you're sending the part to.
  • Resolution: Outsourced PO shipments now pull the Vendor's address from the order.

QuickBooks Desktop

  • Issue: Fishbowl's character limit for FOB Points is 15 characters while QuickBooks only supports 13 characters.
  • Resolution: We now trim the FOB point name to 13 characters when exporting to QuickBooks to avoid errors.

Reports

  • Costing Layer Valuation
  • Added UOM to Qty column.
  • Purchase Order Report
  • Added option to show/hide order notes.
  • Margins by Sales Order
  • Fixed issue where the part line item was duplicating.
  • Manufacture Order Traveler
  • Fixed the "Show WO Travelers" option to show all Work Order Travelers.
  • On Hand Report
  • Fixed an issue where the tracking fields were showing in an inconsistent order.
  • Turnover Report
  • Updated the report to account for selling products in different UOM's.
  • Compare Sales by Month
  • Report now always pulls from current product number/description instead of what it was on a given Sales Order.
  • Shipping Invoice
  • Fixed an issue where the Ship To address would disappear when the order had a discount or shipping line item.
  • Fixed an issue where the Subtotal wasn't correctly using discount or shipping items.

Sales Order

  • Issue: After unissuing a Sales Order, if you right click on that order in the search pane, the options available are still for an issued order.
  • Resolution: Search pane will show correction menu options for whatever status an order is in.
  • Issue: In some cases, mostly on Canada databases, the tax at the bottom right of orders doesn't match what shows up on the order once it makes it to QuickBooks.
  • Resolution: The database stored the correct value for the order so we now display that instead of recalculating in the UI.
  • Issue: The check inventory wizard was not refreshing properly when using the back and next buttons and changing date options.
  • Resolution: You can now move between pages of the wizard, change options, and see correct results.
  • Issue: AUSTRALIA ONLY - New payment wizard does not account for the round to nearest module option.
  • Resolution: New payment wizard now correctly rounds for cash payments.
  • Issue: When using a Drop Ship part, if there is no Vendor association and you select Yes to create one, the Vendor part number does not fill in with the part number.
  • Resolution: The Vendor part number field will now fill in with the part number and can be edited if needed.

SalesPoint

  • Issue: Module options were not fitting correctly in the window.
  • Resolution: Resized the window to fit all options.
  • Issue: AUSTRALIA ONLY - When price rounding option is turned on, the change given doesn't calculate on payments taken.
  • Resolution: Change given now calculates correctly for SalesPoint payments.

Schedule

  • Issue: The Schedule module can lock up on tasks in some cases.
  • Resolution: Fixed issues where the schedule module locks up which should no longer require a server restart.

Shipping

  • Issue: Order type drop down includes WO option which isn't necessary.
  • Resolution: Removed the WO option from the order type drop down in Ship search.

Plugins - 2017.10 Template:Top

Avalara

  • Issue: The tax line item added to the sales order does not get a price set on its postSoItem record causing issues with some reports.
  • Resolution: The postSoItem for the Avalara tax item added to orders now gets price set correctly.

Database Changes - 2017.10 Template:Top

  • woItem table - added standardCost column for tracking the standard cost at the time of WO fulfill

2017.9 Release Notes - 9/21/2017

Considerations before updating - 2017.9 Template:Top

  • If you are updating to 2017.9 from a version that is older than 2017.1 please see Considerations before updating to 2017 before proceeding.
  • Credit card processing APIs have been updated. If you process credit cards through Fishbowl, please review this page before updating. After updating to 2017.9 a re-integration to your payment processor is required.

Highlights - 2017.9 Template:Top

New Features - 2017.9 Template:Top

Fixes - 2017.9 Template:Top

CSV Import/Export

  • Issue: The Sales Order Details CSV was able to change an SO's status even if it was In Progress.
  • Resolution: The CSV will now only be able to change the order status if it's available to be changed.

Inventory

  • Issue: If you have a lot of custom fields the Advanced Search window will not always be able to display all of them.
  • Resolution: The Advanced Search window will now have a scroll bar instead of attempting to fit all the field in one window.

Fishbowl GO

  • Issue: Trying to Pack in Fishbowl GO causes an error.
  • Resolution: Packing in GO now works as expected.

Payment

  • Issue: Attempting to enter a CVC number with a 0 at the beginning will cut off the 0.
  • Resolution: The CVC field will now accept all numbers.
  • Issue: When saving a payment's data to the Info field the wrong Name type was being used.
  • Resolution: The Payment Method name will now be stored in the Info field for future reference.

Reports

  • Shipping Invoice
  • Fixed an issue where the ship to address would disappear on a fulfilled shipment when the order has a shipping or discount line item.
  • POS Receipt
  • Updated the report to pull payment method and last 4 of the card number based on the new database table setup.

Plugins - 2017.9 Template:Top

Database Changes - 2017.9 Template:Top

  • PosTransaction table - column transactionId adjusted to be 100 characters instead of 20.

2017.8 Release Notes - 9/14/2017

Considerations before updating - 2017.8
  • If you are updating to 2017.8 from a version that is older than 2017.1 please see Considerations before updating to 2017 before proceeding.
  • Credit card processing APIs have been updated. If you process credit cards through Fishbowl, please review this page before updating. After updating to 2017.8 a re-integration to your payment processor is required.
Highlights - 2017.8
New Features - 2017.8
Fixes - 2017.8

General

  • Issue: Customer and Vendor Address Info on the Account Info tab was difficult to read because it was grayed out.
  • Resolution: The Address Info section now displays as normal text but is still uneditable. Go to the Address tab to make changes.
  • Issue: Attempting to use more than one email address in the BCC field for email setup will cause an error when sending emails.
  • Resolution: You can now use multiple email addresses in the BCC field.
  • Issue: CANADA ONLY - Creating a new blank database was getting an error that would allow you to use the database, but no views were created causing errors throughout Fishbowl.
  • Resolution: New databases now create with the views correctly.

Bill of Materials

  • Issue: Removing a Finished Good item from an Always Create type BOM will leave the Always Create flag marked on the part sometimes causing issues with Sales Orders.
  • Resolution: If the removed item is on no other Always Create BOM's, the Always Create flag on the part will be set to false.

Consignment

  • Issue: The error message for items attempting to be sold but that don't have an assigned product was incorrect.
  • Resolution: The error is now grammatically correct.

CSV Import/Export

  • Issue: If the UOM Each is inactive and you try to import "Part Product and Vendor Pricing" without any vendor part info you will receive a null error.
  • Resolution: "Part Product and Vendor Pricing" can now be imported while each is inactive as long as each is not used as the part UOM.

Location

  • Issue: Users are able to create "In Transit" location types.
  • Resolution: You now receive an error when attempting to save an In Transit location type as this type is reserved for Transfer Orders only.
  • Issue: The location module Tag field was using comma's for number of 4 digits or more.
  • Resolution: This field will now display only the number and no comma.
  • Issue: The location Auto Create feature would not create locations in some cases due to the way it was checking for existing locations.
  • Resolution: The Auto Create feature will now check existing locations correctly and will create new locations if necessary.

Part

  • Issue: For a part with multiple products, if you delete the default Product on the details tab, the remaining product will not be set as default which can cause errors in Consignment.
  • Resolution: You are no longer able to delete the default Product from the Part module.

Picking

  • Issue: When using inventory tracking, picking (as well as shipping and other inventory functions) can be very slow.
  • Resolution: Fishbowl no longer uses the tracking views in the database to look up the tracking needed and instead queries the database directly.

Purchase Order

  • Issue: Advanced search label says "Date Received" when it really is searching for Date Completed.
  • Resolution: Label updated to reflect search results. Go to Receiving Advanced Search for actual Date Received advanced searches.

QuickBooks Desktop

  • Issue: When importing new classes from QuickBooks an error would return for every class that already exists in Fishbowl causing confusion.
  • Resolution: If a class already exists in Fishbowl during the import, no error will display.
  • Issue: Sales Orders get an error posting to QuickBooks when Class tracking is assigned to names but the customer in QuickBooks does not have an assigned class.
  • Resolution: Sales Orders now have no trouble posting to QuickBooks regardless of how Class is assigned in QuickBooks.
  • Issue: CANADA ONLY - Tax Angency Vendors were making the Vendor import from QuickBooks fail when using certain tax reporting periods.
  • Resolution: Vendors can now be imported regardless of which tax reporting period is selected.

Reports

  • Part Barcodes One Off
  • The Count field now has two functions: If a part number is selected, it will print that specific quantity of labels for the selected part number. If the part number field is left blank, the count is the number of parts from your part list to print in conjunction with the skip field.
  • Product Barcodes One Off
  • The Count field now has two functions: If a product number is selected, it will print that specific quantity of labels for the selected part number. If the product number field is left blank, the count is the number of products from your product list to print in conjunction with the skip field.
  • Vendor Backorder Report
  • Now includes miscellaneous PO items on the report.
  • Vendor Performance Report
  • Now includes miscellaneous PO items on the report.
  • Receiving History
  • Selecting a vendor now excludes customer receipts and vice versa.
  • Packing List
  • Updated to pull Ship To address information from the Shipping module.
  • Fixed a spelling error in part number footnote. (Parenthesis to Parentheses)
  • Shipping Invoice
  • Updated to pull Ship To address information from the Shipping module.
  • Inventory Shipping Summary
  • Updated to pull Ship To address information from the Shipping module.
  • Shipment History
  • Updated to pull Ship To address information from the Shipping module.
  • Bill Of Lading
  • Updated to pull Ship To address information from the Shipping module.

Sales Order

  • Issue: Adding configurable items to a Sales Order no longer allowed you to manually set price adjustments for applicable items.
  • Resolution: Price adjustments can now be set manually or use the default for the item during the configuration wizard.
  • Issue: Kit headers do not get fulfilled when one of the items is a Drop Ship type item.
  • Resolution: Kit headers now fulfill correctly when all items are fulfilled regardless of item type.
  • Issue: The Sales Order item Margin field is not calculating correctly for Non-Inventory items with a quantity more than 1.
  • Resolution: The Margin field now calculates correctly regardless of item type or quantity.
  • Issue: For BOM's that have sub-assemblies with price adjustments, the adjustments are not calculating correctly with more than 1 quantity.
  • Resolution: Price adjustments now calculate regardless of quantity or assembly level.
  • Issue: In some cases line items fulfilled at the same time will get a slightly different fulfillment date and will cause the order to not get a date completed.
  • Resolution: The order date completed is now set correctly as long as all the lines are closed.

Shipping

  • Issue: If a shipment gets a Part Cost ID database error during shipment, the shipment does not roll back properly and commits only a partially completed shipment.
  • Resolution: If a Part Cost ID error is given, the shipment now rolls back correctly to the open status.
Plugins - 2017.8

Avalara

  • Issue: The tax line item added to the Sales Order was being added with cost causing a journal entry in QuickBooks for Misc. COGS.
  • Resolution: The tax line item is now price only.
Database Changes - 2017.8
  • BOM table - added defaultCalCategory field.
  • PosTransaction table - added info field to store card type and last 4 digits of a processed card. Also removed miscCreditCard column as it was unused.
  • Ship table - added columns for shipping address.
  • SO table - changed residentialFlag field to shipToResidential

2017.7 Release Notes - 8/10/2017

Considerations before updating - 2017.7
Highlights - 2017.7
New Features - 2017.7
Fixes - 2017.7

General

  • Issue: When a date field becomes uneditable, sometimes it has a gray background making it difficult to read the date.
  • Resolution: Date fields now have a white background once they are uneditable.
  • Issue: Attempting to delete an address that includes contact information will give an unhelpful error.
  • Resolution: Deleting an address will contact information will now give you the option to cancel or also delete the contacts associated.
  • Issue: If the Fishbowl Server properties file did not include the License Key line, the Fishbowl server would crash on startup.
  • Resolution: The Fishbowl Server will no longer crash in this scenario and will instead ask you for a license key to add to the properties.

Accounting

  • Issue: Running a repost export that includes Work Orders does not clear all the necessary for re-exporting causing errors.
  • Resolution: Using the repost function will now post Work Order's correctly.
  • Issue: During data validation to QuickBooks Online some products or customer names would return an error in come cases saying it already exists.
  • Resolution: Fixed one possible issue where this error would occur.

CSV Import/Export

  • Issue: The Custom Field Data and Part Product and Vendor Pricing CSV's do not validate list type Custom Field data.
  • Resolution: You can only use case-sensitive values from the custom list specified when importing data for a list type custom field.
  • Issue: If the Sales Order CSV cell types are formatted incorrectly, dates will import as the year 0017 instead of 2017 in some cases.
  • Resolution: All dates will import as 2017 regardless of Excel cell formatting.

Picking

  • Issue: The Finish search column was not displaying correctly for some orders that were started but had short items.
  • Resolution: The Finish icon now shows correctly for started picks with short items.

Purchase Order

  • Issue: If you have an item that is received but not reconciled, you will not be able to add or delete current PO items.
  • Resolution: You are now able to change PO items regardless of receipt status.
  • Issue: The UOM drop down in the PO Item Details window or the Add Miscellaneous Item window was displaying blank even though the data was available to use.
  • Resolution: The UOM drop down now displays correctly for all PO Items.
  • Issue: Starting a new PO and not selecting a vendor then opening an existing PO will not allow you to change the item quantity.
  • Resolution: Item quantity is available for existing PO's regardless of the previous PO's state.

Sales Order

  • Issue: Fulfilling kits with only one kit item does not always calculate the quantity fulfilled for the kit header correctly.
  • Resolution: Kit header quantity fulfilled is now calculated correctly regardless of the number of kit items.
  • Issue: Sales Orders created by RMA's had a null Note and mcTotalTax fields in the database causing errors in some cases.
  • Resolution: RMA's now create Sales Order records correctly.
  • Issue: Switching between Markup and Unit Price fields on Sales Order items could continually recalculate the price or markup very slightly.
  • Resolution: If numbers are not changed we no longer try to recalculate the price or markup fields.

Setup

  • Issue: When changing a Payment Method name to something with the same spelling but different casing, you would get a unique name error.
  • Resolution: You can now change the casing of a Payment Method name and save it without an error.

Shipping

  • Issue: Carton weight does not calculate correctly if you partially pick an item, then finish the rest of the pick and add it to the same shipment.
  • Resolution: Carton weight now calculates correctly regardless of quantity picked.
  • Issue: Using the Carton Count feature in the product module while having more than one line of the same product on an SO causes the SO items to fulfill incorrectly.
  • Resolution: The Carton Count number will now apply to individual line items instead of total product quantity on an order.
Plugins - 2017.7

Fishbowl GO

  • Issue: Fishbowl GO will crash when trying to open a receipt for a credit return Sales Order created by an RMA.
  • Resolution: Fishbowl GO can now open these types of receipts with no issue.

2017.6 Release Notes - 7/13/2017

Considerations before updating - 2017.6
  • If you are updating to 2017.6 from a version that is older than 2017.1 please see Considerations before updating to 2017 before proceeding.
  • If your automatic Client update is failing after the Fishbowl Server is updated, please adjust your Client memory allocation by following the steps here.
Highlights - 2017.6
New Features - 2017.6
Fixes - 2017.6

General

  • Issue: Updating or backing up a MySQL database will leave a backup copy in a general Windows temp folder.
  • Resolution: These temp files are now deleted after we are done using them during the update or backup process.
  • Issue: New and Delete Address buttons were not displaying correctly throughout the software.
  • Resolution: These buttons now display the full text and are no longer cut off.

CSV Import/Export

  • Issue: On the Vendors CSV Import the Address Name was only allowing 60 characters when the database limit is 90.
  • Resolution: The Address Name field now allows the full 90 characters on the Vendors import.

Customer

  • Issue: The new customer wizard would always do a default class of None.
  • Resolution: The new customer wizard now leaves the Class field blank so that it can always be set or does nothing.

Inventory

  • Issue: In the Inventory module "Display more Information" screen, the checkbox to "Show all location groups" was working incorrectly.
  • Resolution: Removed the checkbox so you only see inventory for your location groups.

Picking

  • Issue: If remaining items on a Sales Order are deleted, the pick will have all finished items but still have an Entered pick status.
  • Resolution: If all remaining items are removed from a pick, that pick will be set to Finished.

Product

  • Issue: Duplicating products can be very slow in some cases.
  • Resolution: Refactor of code to improve speed.

Receiving

  • Issue: If you enter a Reference Number on a line item and hit Fulfill, the Reference Number field will be cleared.
  • Resolution: The Reference Number on the line item now saves when hitting Fulfill.
  • Issue: In the Edit Tracking window in the Receiving module, the auto-generate tracking buttons show available for Outsource type items.
  • Resolution: The auto-generate tracking icons now only show if the tracking field is editable.

SalesPoint

  • Issue: The Customer's default class is not assigning to the order or items.
  • Resolution: Class is now selected from the Customer's default.

Sales Order

  • Issue: Adding a Build to Order item with price adjustments to an SO can get the wrong price adjustment if an adjustment option line's box is not checked.
  • Resolution: The price adjustments on Build to Order items will only update if the box is checked for a specific item.

Schedule

  • Issue: Attempting to run a Currency update schedule will fail if you are not connected to an accounting package.
  • Resolution: Running a Currency update schedule can now be done regardless of accounting integration.

Shipping

  • Issue: Voiding a shipment does not clear the SO Item's date fulfilled.
  • Resolution: Voiding a shipment will now clear the SO Item's date fulfilled as long as the quantity fulfilled goes down to 0.
  • Issue: When using serial numbers sometimes the list would be truncated between picking and shipping causing shipping errors stating there's not enough serial numbers.
  • Resolution: All serial numbers now correctly make it to shipping.
  • Issue: Some shipments show a successful ship but are actually failing in the background and not rolling back the shipment, usually on larger orders.
  • Resolution: These errors now cause the shipment to fail and roll back what was successfully shipped to avoid corruption.
  • Issue: UPS Ready COD settings were not working correctly in some cases.
  • Resolution: Updated the UPS COD options to be correct in the database.

Unit of Measure

  • Issue: When creating a UOM conversion it does not check if current items on BOM's are compatible with the new conversion causing errors when finishing Work Order's later on.
  • Resolution: An error now shows when current BOM items are not compatible with a new conversion.

API

  • Issue: Using the SO Delete call can cause corruption.
  • Resolution: SO delete call removed to avoid this corruption. Use the Void API call instead.

iReport

  • Issue: Using the accountID parameter from our iReport documentation would cause reports not to run.
  • Resolution: This parameter has been fixed and can now be used without issue.
Plugins - 2017.6

General

  • Issue: The Fishbowl Server was not deleting old plugin files after updating the plugin.
  • Resolution: The old plugin files now delete correctly when updating or uninstalling plugins.
  • Issue: Updating the Fishbowl Client would sometimes hold old plugin files and install them again when updating the client to a new Fishbowl version.
  • Resolution: The Fishbowl Client now deletes the update files when the update is complete.
  • Issue: User Group access right options for plugins weren't duplicating and showing twice.
  • Resolution: Access rights only show once for plugins.

Avalara

  • Issue: Shipping an order would fail to process if the Sales Order has no taxable line items on it.
  • Resolution: If an SO has no taxable line items we will not process the order through Avalara.
  • Issue: If a customer is set to Tax Exempt, the Sales Order would be changed to a Tax Rate of None.
  • Resolution: If integrated with Avalara, the Tax Rate for Sales Orders is completely determined by the Customer's tax rate. If the Customer's rate is set to "AvaTax Order" then it will process through Avalara.
Fishbowl GO (ANDROID VERSION ONLY) New Features - 2.0

** This update requires Fishbowl 2017.5

** iOS release coming soon.

New Features

Bug Fixes

  • Issue: When scanning with the camera, app would force close if adding more than one serial number.
  • Resolution: All serial numbers can now be added regardless of scanning method.
  • Issue: WO Finish only asks for primary tracking instead of all tracking.
  • Resolution: WO Finish now asks for all tracking.
  • Issue: The Scrap feature was requiring all tracking instead of just the primary tracking.
  • Resolution: Scrap now only asks for the primary tracking (i.e. Serial Number).

2017.5 Release Notes - 6/15/2017

Considerations before updating - 2017.5
Highlights - 2017.5
New Features - 2017.5
Fixes - 2017.5

General

  • Issue: Fishbowl Server window still show "Database URL" text for Firebird database files.
  • Resolution: Fishbowl Server window now shows "Database Host" to indicate which MySQL server is being used.
  • Issue: Certain characters are not encoding correctly to the backup file when made through Fishbowl causing errors on restore in some cases.
  • Resolution: All characters are now encoded correctly on backup.
  • Issue: On low resolution monitors or small Fishbowl windows the email settings would cut off.
  • Resolution: Email settings now has a scroll bar.

CSV Imports/Exports

  • Issue: The Payment Data CSV was importing lines without error even when the CSV fails due to errors on other lines.
  • Resolution: This CSV will only import data on a successful import.
  • Issue: Importing kits using the Sales Order CSV would fail if the Kit Header item type was not set to 80.
  • Resolution: Kit headers will now import with a type of 80 or 10.
  • Issue: Importing a Sales Order CSV requires the Tax Code but the code is not required to be unique so it may not select the tax you're hoping for.
  • Resolution: The Tax Code field will now check the Tax Name first then the Code if it can't find the name.

Linux Installation

  • Issue: A change made to the system causes the .sh files not to work properly.
  • Resolution: The .sh files can now be used correctly. Please speak with Fishbowl Support about a resolution for the 2017.4 version or use the app files instead of the .sh files.

Location

  • Issue: The Customer/Job field would be available to select from but would hide if you switched location types.
  • Resolution: The Customer/Job field is now available to use for any location type.

Picking

  • Issue: If an item on a pick becomes short or partial while the pick is open, attempting to pick or refreshing the pick would clear the location from other finished items on the pick.
  • Resolution: A line item splitting or becoming short no longer removes the location from other pick items.
  • Issue: The status icon in the Pick search pane is not correct when dealing with non-inventory items.
  • Resolution: The status icon is now correct regardless of item type.

Purchase Order

  • Issue: Duplicating PO's can take a significant amount of time in some cases.
  • Resolution: Refactor of code to improve speed.
  • Issue: Part tax codes are not being applied to PO items in the Australia and Canada versions of Fishbowl.
  • Resolution: Tax codes now apply properly.
  • Issue: Unable to search for Miscellaneous Item number and description in the Advanced Search window.
  • Resolution: You can now use the Advanced Search Part Number and Description fields to find Miscellaneous Parts.

QuickBooks Desktop Integration

  • Issue: Pulling in open PO's from QuickBooks would leave the Vendor Number field blank on the PO Item when it's not allowed to be blank.
  • Resolution: The Vendor Number field now fills in with the Part Number.

Reports

  • Issue: Reports Module Options for Default Date Range, Location Group, and Salesperson do not work.
  • Resolution: These options have been removed since they can be saved per report.

Sales Order

  • Issue: Double clicking on a flat rate Discount item will reset the item price to the original amount from the Discount module.
  • Resolution: Double clicking to edit a flat rate Discount item now has no effect on the item price.
  • Issue: Margin and Markup calculations were not correct in some cases when large quantities were used.
  • Resolution: Margin and Markup calculations are now correct regardless of quantity.
  • Issue: Closing short a not-inventory item will cause a "Dividing by 0 is not allowed" error when using the Margin/Markup option.
  • Resolution: You can now close short a non-inventory without any errors.
  • Issue: Voiding a shipment would not clear the Sales Order Date Completed or the shipment's Date Shipped.
  • Resolution: Voiding a shipment now clears the above dates.
  • Issue: If an item was closed short to 0 quantity and you opened the Item Details window it would tell you the quantity could not be set to 0.
  • Resolution: Item Details can now be viewed on items closed short at 0 quantity.
  • Issue: Line Item custom fields are visible even when inactive.
  • Resolution: Inactive custom fields no longer show on SO line items.

User

  • Issue: Saving user details is unavailable on users other than admin when they should be able to update contact info and their password.
  • Resolution: Saving user details is now available for users without edit access so they can save their own details and password.

API

  • Issue: There is no option to set an SO item tax rate or code on the US version when using the SO Item call.
  • Resolution: You are now able to set the tax on an SO item regardless of country version.
Plugins - 2017.5

Dropbox

  • Updated to the latest Dropbox API

2017.4 Release Notes - 5/11/2017

Considerations before updating - 2017.4
  • If you are updating to 2017.4 from a version that is older than 2017.1 please see Considerations before updating to 2017 before proceeding.
  • Each client computer will need to be manually updated to the 2017.4 version as a result of changes made to the way the client update is received from the server.
Highlights - 2017.4
New Features - 2017.4
Fixes - 2017.4
  • Issue: Associated products, RMA's and custom field data via the API causes the Fishbowl client to run slowly.
  • Resolution: Optimization to each of these areas allows the client to run queries faster.
  • Issue: Items that have been used on a Work Order after being received cause an error when trying to reconcile.
  • Resolution: Items that have been received then consumed on a Work Order can now be reconciled properly.
  • Issue: Using the X to kill a scheduled task removes it from the list but doesn't always stop it from running.
  • Resolution: Killing a scheduled task now completely stops it from running in all cases.
  • Issue: In the Products section of the Part module, using the New or Edit Product window could cause some fields to be filled in with incompatible data.
  • Resolution: The New and Edit Product buttons now take you to the Product module to perform those functions.
  • Issue: The Bill of Materials CSV is not setting the Auto Create type to the module option default if the type was not set on the CSV.
  • Resolution: The Bill of Materials CSV will now use the default Auto Create type if not set on the CSV.
  • Issue: Importing a Bill of Materials through CSV would cause the Bill of Materials report to not show the BOM Number or Description until the BOM is manually saved.
  • Resolution: The Bill of Materials report now shows the BOM details immediately after the CSV is imported.
  • Issue: When adding a part to a Purchase Order, the UOM was not being set correctly and would cause it to be set to Each.
  • Resolution: UOM is now being set correctly when adding items to a Purchase Order.
Plugins - 2017.4
  • Issue: Fishbowl GO - Android version: Cycle counting an item with multiple tracking types doesn't record the secondary tracking correctly.
  • Resolution: Cycle counting with multiple part tracking fields works like a charm.

2017.3 Release Notes - 4/13/2017

Considerations before updating - 2017.3

If you are updating to 2017.3 from a version that is older than 2017.1 please see Considerations before updating to 2017 before proceeding.

Highlights - 2017.3
New Features - 2017.3
Fixes - 2017.3

General

  • Issue: Dashboard module button shows in the module pane even if you don't have access to it.
  • Resolution: Dashboard module button now only shows if you have the access right.
  • Issue: URL paths that don't exist don't display an error when attempting to navigate to the path.
  • Resolution: Error now displays correctly in the client.
  • Issue: Using the email button doesn't load company email addresses unless a customer or vendor is loaded.
  • Resolution: Company email addresses will now load any time the email button is used.
  • Issue: URL links are not working correctly if they are pointing to a shared or network drive.
  • Resolution: URL links now work correctly.
  • Issue: Server logging for reports is showing extra XML information.
  • Resolution: Logging no longer shows the extra unneeded information.

API

  • Issue: Processing credit card payments through the API doesn't charge the card or store details correctly.
  • Resolution: Card processing through the API now works correctly.
  • Issue: Using the Issue SO call after an order has already been issued or even fulfilled will create a duplicate pick.
  • Resolution: Attempting to use the Issue SO call will error out if the order has already been issued.
  • Issue: Using the Save Ship call will clear carton weight, length, height, and declared value if they have been filled in on the carton.
  • Resolution: the Save Ship call now includes the weight, length, height, and declared value fields to be set.

Company

  • Issue: Certain areas of the company module are able to be edited in some cases even when the user only has view access.
  • Resolution: All areas of the company module are locked down for view only access.

Consignment

  • Issue: Cycle counting an item causes a null error.
  • Resolution: Cycle counting now works correctly.

CSV Imports / Exports

  • Issue: Custom field data instructions refer to the "export" but there isn't an export for custom field data
  • Resolution: Instructions updated
  • Issue: Sales Order Details would get a null error if it didn't recognize the status ID.
  • Resolution: Incorrect status on the CSV will now give an appropriate error.

Part

  • Issue: Loading parts can be slow, especially if you have a lot of custom fields
  • Resolution: Refactor of code to improve speed
  • Issue: During the new part wizard, the Product Income account does not save if you go to the next page and then back to the Default Accounts page.
  • Resolution: Product Income account now saves regardless of moving through wizard pages.

Picking

  • Issue: The picking module is slow in some cases (load module, open pick, or finish).
  • Resolution: Refactor of code to improve speed
  • Issue: Using the "Group Single Item Orders" option in the Group Pick window groups multi item orders as well.
  • Resolution: The "Group Single Item Orders" option now works correctly.
  • Issue: Ungrouping picks doesn't work correctly when two different order types have the same ID.
  • Resolution: Ungrouping picks works correctly regardless of order type.

Purchase Order

  • Issue: Opening the item details window would load slowly in some cases due to loading inventory details
  • Resolution: Don't load the inventory details until that tab is selected.
  • Issue: Adding an item to be a PO can be slow because it queries more data than it needs.
  • Resolution: Only the necessary data for the PO is loaded when adding a part.
  • Issue: If item description is too long, the inventory tab of the item details window loads incorrectly.
  • Resolution: Inventory tab now loads correctly regardless of description length.
  • Issue: Some Advanced Search fields are not being cleared when using the Reset Filters button.
  • Resolution: All Advanced Search fields now clear correctly when resetting filters.

QuickBooks Desktop Integration

  • Issue: On a brand new integration, the "Days" fields for importing orders are not initially available to edit.
  • Resolution: Days checkbox edit availability is now based off of its assigned order type check box.

QuickBooks Merchant Services

  • Issue: Errors returning from QuickBooks Merchant Services were not being captured and displayed.
  • Resolution: Errors returning from QuickBooks Merchant Services are now handled correctly.

QuickBooks Online Integration

  • Issue: Sending over a credit return Purchase Order would fail with an error that the amount must be greater than zero.
  • Resolution: Credit return PO's now send over correctly to QBO.

Receiving

  • Issue: Non-inventory drop ship items can be voided after being received, reconciled, or fulfilled.
  • Resolution: Non-inventory drop ship items can no longer be voided after moving on from Entered status.

Sales Order

  • Issue: Orders are slow to load and add products.
  • Resolution: Refactor of code to improve speed.
  • Issue: Opening the item details window would load slowly in some cases due to loading inventory details
  • Resolution: Don't load the inventory details until that tab is selected.
  • Issue: If item description is too long, the inventory tab of the item details window loads incorrectly.
  • Resolution: Inventory tab now loads correctly regardless of description length.
  • Issue: The phone and email fields on the Details tab can still be edited after fulfill even if you don't have access.
  • Resolution: Phone and email fields now tie to the "Can Always Change Details" user right.
  • Issue: Margin and Markup fields will show incorrectly data when item has more than one quantity fulfilled.
  • Resolution: Margin and Markup fields now display correct data.
  • Issue: Customer PO field is not checked for duplicates if the Sales Order is saved while the cursor is in the Customer PO field.
  • Resolution: Customer PO field is correctly checked for duplicates.
  • Issue: Duplicating Sales Orders can take a significant amount of time in some cases.
  • Resolution: Refactor of code to improve speed.
  • Issue: Checking for duplicate Customer PO's can take a significant amount of time if lots of Sales Orders have the same Customer PO data.
  • Resolution: Refactor of code to improve speed.
  • Issue: Some Advanced Search fields are not being cleared when using the Reset Filters button.
  • Resolution: All Advanced Search fields now clear correctly when resetting filters.

User Group

  • Issue: Sorting by the "Access Right" column will sort Accounting to the top instead of All Modules.
  • Resolution: When sorted, All Modules is on the top then everything else sorts alphabetically.

Xero Integration

  • Issue: AU version of Xero Integration doesn't export order totals correctly when the "amount includes tax" option is enabled
  • Resolution: Xero export always changes the amount to NOT include tax when exporting.
Plugins - 2017.3

Avalara

  • Issue: Sales Orders with subtotal items would send the subtotal to Avalara to be taxed.
  • Resolution: Subtotal type items no longer send through to Avalara.

2017.2 Release Notes - 3/9/2017

Considerations Before Updating - 2017.2
Highlights - 2017.2
New Features - 2017.2
Fixes - 2017.2

Calendar

  • Issue: Editing a work order calendar event and category shows as grayed out, but it can still be edited.
  • Resolution: Fields are no longer grayed out.

CSV Imports / Exports

  • Issue: Sales order import fails when an order contains a kit within a kit.
  • Resolution: Importing an order with kits that contain kits returns an error message saying it is not handled.

Database Backup

  • Typo on the message that the database was backed up successfully has been resolved. (We can spell, but apparently we couldn't type correctly)

Dropbox

  • Issue: Attempting to download a file multiple times causes an error.
  • Resolution: File downloads work multiple times, no limit no :).

Inventory

  • Issue: loading inventory parts with tracking is slow.
  • Resolution: Loading tracking has been optimized with the MySQL database.

Locations

  • Issue: Attempting to delete a location causes an error.
  • Resolution: Deleting a location is possible when it's not in use.

Picking

  • Issue: Picking a non inventory item displays the wrong color pick icon, shows yellow, even though its pickable.
  • Resolution: Pick icon status color now shows in green for non inventory items.

Part

  • Part tracking type "check box" has been updated to "checkbox"
  • Issue: Advanced search window appears on primary monitor, not necessarily the monitor the Fishbowl client resides on.
  • Resolution: Advanced search window always launches on the same monitor as the Fishbowl client.

Payment Viewer

  • Issue: A payment that has a transaction ID, but no merchant service connected it still attempts to void through a merchant service and causes an error.
  • Resolution: When a transaction ID is present, but no current merchant integration is in place, the void skips the merchant step.

Purchase Order

  • Issue: Order cannot be saved if the last item added is a misc purchase item.
  • Resolution: orders can now be saved with misc items...oops.

QuickBooks Desktop Integration

  • Issue: Using an underscore (_) in the name of a payment method causes an export error if there are multiple methods with this character.
  • Resolution: Exporting payment methods with an underscore in the name works just fine.
  • Issue: Importing an inventory assembly from QuickBooks brings the raw goods in as an "each" even when the UOM is different.
  • Resolution: Importing assemblies from QuickBooks now includes the UOM on raw goods.
  • Issue: Sending a customer to QuickBooks doesn't populate the "Company Name" only the customer name.
  • Resolution: Customer name and company name are both populated on customer creation.
  • Issue: Partially shipping orders that contain a flat tax will duplicate the tax on each subsequent shipment, not just the initial shipment.
  • Resolution: Flat rate taxes are only included on one shipment, not all.

Receiving

  • Issue: Reconcile bill date auto resets to today's date when left empty in the reconcile wizard.
  • Resolution: Bill date is no longer reset and defaulting to the current date.

Reports

  • Issue: Auto PO report doesn't populate correctly.
  • Resolution: Report now populates with correct reorder data.
  • Issue: Bill of Materials report with the same stage multiple times only rolls up once, and doesn't account for UOM's.
  • Resolution: Report now includes UOM's and stages roll up correctly. Available and short quantity also added to the report.

Sales Order

  • Issue: Date issued stays populated in the database even after an order has been unissued.
  • Resolution: Unissuing a sales order removes the issue date.
  • Issue: Part cost on the sales order isn't updating when the order is fulfilled.
  • Resolution: Part cost now updates when the order is fulfilled.
  • Issue: Items can't be deleted from expired sales orders.
  • Resolution: Items can now be deleted form expired orders.
  • Issue: Sales order search causes an error when a voided status order is selected.
  • Resolution: Selecting voided errors works just fine.
  • Issue: Non inventory, service and ship type items cost doesn't update the margin / markup fields.
  • Resolution: Margin / Markup now reference the cost field on these types of parts to update the fields.

Transfer Order

  • Issue: Splitting items or attempting to partially ship a transfer order causes an error.
  • Resolution: Partial transfer orders can now be completed error free...sorry.

User

  • Issue: searching for a username and default email causes an error.
  • Resolution: Search now returns with no error.

Fishbowl Canada

  • Issue: Importing sales orders from QuickBooks doesn't correctly import the currency for multi-currency orders.
  • Resolution: Currency is now imported with the order.

Fishbowl GO

  • Issue: Packing an order clears the ship service associated with the order.
  • Resolution: Packing preservers the ship service.
Plugins - 2017.2
  • Issue: When closing FB the JX browser didn't also close
  • Resolution: JX Browser now closes when FB exits

Volusion

  • Issue: Product sync only allowed 100 items to sync at a time.
  • Resolution: All products now sync correctly
  • Issue: Cancelled orders import into FB.
  • Resolution: Cancelled orders are no longer imported into FB.
  • Issue: Sync failed if only one product is synced
  • Resolution: Single products now sync
  • Issue: Syncing product from FB to Volusion didn't return the product id to FB
  • Resolution: Product ID is now stored in the product id custom field in FB
  • Issue: Discount items not importing correctly
  • Resolution: Discount items now import correctly on FB SO

Forecast

  • Issue: Error returned when trying to run forecast data
  • Resolution: Forecast plugin now works in 2017 version of FB

QuickBooks Online

  • Issue: Error when trying to load plugin
  • Resolution: Plugin now works in 2017 version of FB

Magento Cart

  • Enhancement to store Magento Cart Store ID in SO Custom Field
  • Issue: Last Sync Date was set to task completion not task start
  • Resolution: Last Sync Date now sets to when scheduled task starts
  • Issue: New products when pulling from Magento to FB not created
  • Resolution: New products created in FB when pulling from Magento.
Note - product will try to map Magento SKU to FB Product Number. If no match then a new product will be created.
Database Changes - 2017.2
  • SO table added column "totalPrice"
  • SO table added column "subTotal"
  • Address table column "addressName" length is now 90 characters
  • IssuableStatus table was created
  • Customer table added column "issuableStatusId"

2017.1 Release Notes - 2/9/2017

Considerations Before Updating - 2017.1
  • Please carefully read Updating to 2017 before proceeding with the update.
  • Before updating to Fishbowl 2017.1, you must first be running Fishbowl 2016.14.
  • After updating, the database will be migrated from Firebird to MySQL. A new database will be created and populated with all existing data. This process will take a significant amount of time, especially when updating large databases.
  • If you have integrations such as shopping carts, custom reports, or custom shipping integrations, please contact the partner you purchased them from before upgrading to make sure they will work with 2017.1. We recommend that you test all custom integrations before updating.
  • When using ODBC shipping integrations, the ODBC driver will need to be reconfigured.
  • If you have your Fishbowl Server running on a Mac, please contact our support team. The database migration tool will not run on a Mac. We will be more than happy to assist you in migrating your database.
Highlights - 2017.1
New Features - 2017.1


  • QuickBooks desktop order import now includes line item notes during sync
  • Importing purchase orders from QuickBooks desktop now imports kit items as parts
  • Importing sales orders and invoices from QuickBooks desktop now imports kit items as products
  • Importing orders from QuickBooks desktop now imports sub items for order as parts/products
  • Tooltips added to show max characters to numerous Fishbowl fields
  • Running Fishbowl server on Debug level now shows plugin CSV data
  • Tooltips added to monitor module Alert and Critical inventory level data
  • Exporting CSV files remembers the last file location for future exports
  • Customer / Job information now posts to QuickBooks Desktop for each line item on an item receipt or bill
  • Shipment tracking in the shipping module now works with USPS shipments
  • Message received when maximum number of users is reached now correctly refers to the account sales executive
  • Functionality to multi select and issue multiple manufacture orders
  • Saving a file now recalls the last save location when saving files from Fishbowl
  • Hot keys added to database selection panel
  • Shipping Details tab allows the phone and email fields to be copied
Fixes - 2017.1

General

  • Issue: Opening multiple clients concurrently doesn't always load correctly unless any clients after the first run the client.bat file.
  • Resolution: Opening multiple client instances now works correctly.
  • Issue: Quantity and money type field data can become corrupted.
  • Resolution: Data storage and saving of quantity and money fields saves correctly.
  • Issue: Newfoundland state code lists as "NF" but it should be "NL".
  • Resolution: State code now correctly lists "NL".
  • Issue: Client computers aren't always checking for plugin updates from the server.
  • Resolution: update check is working correctly.

Class

  • Issue: Inactivating a sub class causes strange behavior in the class module.
  • Resolution: Inactivating now displays everything correctly.

CSV Import / Export

  • Issue: Instruction file includes a line that says, " the file does not contain column names, just data" and this is incorrect.
  • Resolution: Incorrect instructions have been removed.
  • Issue: Sales order import doesn't import correctly when discounts directly follow a kit header on the order import.
  • Resolution: Discounts now import correctly regardless of other item types being imported.
  • Issue: Instructions for the sales order import don't designate that importing a kit item requires that the soitemtypeid is required.
  • Resolution: Instructions now identify all required fields.

Currency

  • Issue: Updating currency conversions using the schedule module doesn't work.
  • Resolution: Scheduler correctly updates conversions again.

Customer

  • Issue: The error message when changing a customer account number to an account number that is already is use isn't clear as to what the error is.
  • Resolution: Error message now reads more clearly.
  • Issue: New customer wizard is requiring a default tax to be set, even though it's not required during a customer edit.
  • Customer tax rate is no longer required during the new customer wizard.
  • Issue: Creating a customer address with the state as Alabama (AL) actually enters as Alaska (AK) if you just tab through the field.
  • Resolution: State entry is now recorded correctly when using tab key to advance through fields.
  • Issue: Maps Button doesn't display the address correctly when there is a carriage return in the address.
  • Resolution: Address displays correctly now.

Dropbox Integration

  • Issue: Downloading files from dropbox fails on a Mac client because the file mapping structure is formatted incorrectly.
  • Resolution: File download now works correctly on a Mac client.

Mac Installer

  • Issue: Installing Fishbowl on a Mac that doesn't have Java installed doesn't run without manually installing Java or a previous version of Fishbowl.
  • Resolution: Installer now installs Java if needed, so that the installer can run correctly.

Monitor

  • Issue: Monitor module Refresh Rate option always runs for 30 seconds when enabled, regardless of user defined time setting.
  • Resolution: Refresh rate frequency now looks at the defined time interval.

Part

  • Issue: Part allows serial number tracking to be enabled when a part is on a picked but not finished work order.
  • Resolution: All part tracking can now only be enabled when a part isn't on any open orders or picks.
  • Issue: Saving a part with default locations that the user doesn't have access to, deletes the default locations for those groups.
  • Resolution: Saving now preserves default locations.
  • Issue: Part tracking type "check box" changed to "checkbox".
  • Issue: Lead time field on the bottom of the vendor tab doesn't save the data.
  • Resolution: Field now saves.

Pick

  • Issue: Pick search Finish icons showed incorrectly when items were on hold.
  • Resolution: Icons now show inventory as unavailable to pick with yellow or red status icons when items are on hold.
  • Issue: Pick search gives bad results when searching by number when there are multiple order types with the same number.
  • Resolution: Searching by number now accounts for multiple order types.

Product

  • Issue: Product Module advanced search window sometimes opens on a different screen.
  • Resolution: Advanced search will now open over the main search pane.
  • Issue: Product hyperlink tooltip says "part number" instead of "product".
  • Resolution: Tooltip now accurately says "product".
  • Issue: Editing a kit resets the UOM and SO item type fields to default settings.
  • Resolution: Editing a kit now saves the UOM and SO item type settings.
  • Issue: Product tree description changes don't take until a server restart occurs.
  • Resolution: Changes now take correctly on save.

Purchase Order

  • Issue: Purchase Order search fields would fail to search if too many characters were in the field.
  • Resolution: Purchase Order search fields are limited to the amount of characters of the original field.

QuickBooks Desktop

  • Issue: Importing orders from QuickBooks that have an item with 0 quantity would break the import.
  • Resolution: 0 quantity items in QuickBooks now import as a quantity of 1 and a price of 0.
  • Issue: Running a "Mark as Posted" export resets the date posted on all posted sales orders.
  • Resolution: Exporting as "Mark as Posted" only updates the dates on sales orders flagged as posted within the given posting batch.
  • Issue: Posting an item receipt that is behind a closing date doesn't actually post, only the bill is sent.
  • Resolution: Posting an item receipt behind a closing date now displays a message to the user indicating that QuickBooks doesn't allow this.

Receiving

  • Issue: Receiving a non-inventory drop ship item updates to an incorrect cost on the Sales Order item data.
  • Resolution: Receiving non-inventory drop ship items now uses the correct cost.

RMA

  • Issue: RMA's in International versions would assign line item tax code to non if the customer had a tax with a duplicate code.
  • Resolution: Product tax code is now assigned correctly for RMA's.

Sales Order

  • Issue: Sales Order item markup field can be edited to change the price of the item when the price should not be edited.
  • Resolution: Markup field can only be edited when price can be edited.
  • Issue: Clicking in the markup field on a Sales Order item with 0 cost would reset the price of the item.
  • Resolution: Sales Order item price does not update by clicking in markup field.
  • Issue: When a customer default tax rate is set to "None" the sales order is defaulting to the default tax rate rather than the customer default.
  • Resolution: Sales orders now use the customer default tax rate when it is present.
  • Issue: Kit item prices can be adjusted from 0 even when the kit price is set by the kit header.
  • Resolution: Kit item prices can no longer be adjusted when the kit price is defined in the kit header.
  • Issue: Entering a quantity with a decimal quantity on a part with an "each" UOM and dismissing the error dialog, then entering the item again, saves the item with the decimal quantity.
  • Resolution: Quantity now clears correctly when adding items to the sales order.
  • Issue: Credit return items update the customer part number last price when using the Quick Fulfill feature.
  • Resolution: Customer part number price is now properly reserved.
  • Issue: Custom line item fields don't transfer to the new order when using the duplicate feature.
  • Resolution: Custom line items are now included in the sales order duplicate.
  • Issue: Selecting back in the sales order item add wizard in the associated price step doesn't work if you don't have associated prices on the products.
  • Resolution: Back button now works.

Shipping

  • Issue: Some shipments receive an "Unable to void shipment" message when an item didn't make it into shipping due to an error.
  • Resolution: Error message now includes the part number causing the issue.
  • Issue: Product CSV import does not notate SKU and UPC character limit on the import instructions like the Part Product and Vendor Pricing import does.
  • Resolution: Product CSV import instructions now show character limit for SKU and UPC.
  • Issue: Voiding a shipment does not properly decrement the soItem.TotalCost when shipping an order it adds to the cost again, causing reporting discrepancies.
  • Resolution: Voiding a shipment now calculates correctly.

UPS Ready

  • Issue: Carrier service drop down menu on a return shipment doesn't display carriers.
  • Resolution: Drop down menu populates correctly.

User Right

  • Issue: Right to "Always edit item notes" on sales order only apples to item edit window, you can still edit in line.
  • Resolution: Access right now applies to inline edit also.

Vendor

  • Issue: Saving a vendor cost rule with duplicate names on the same part doesn't display a clear error message.
  • Resolution: Error message now reads more clearly.

Fishbowl Australia

  • Issue: Help \ About dialog doesn't display information.
  • Resolution: Dialog now shows correctly.
Plugins - 2017.1

Amazon

  • Issue: Amazon item total price is populating the imported order as the unit price.
  • Resolution: Price is now setting correctly.
  • Issue: Having a comma (,) in the company name of the Amazon account causes an error when attempting to configure the plugin.
  • Resolution: Commas and other special characters can now be used in the company name with no issues.

Avalara

  • Issue: Products with a number that is greater than 50 characters in length causes an error and doesn't display a clear error message.
  • Resolution: Error message from Avalara is now passed through to Fishbowl.
  • Issue: An error occurs when syncing with Avalara via the estimated tax button if the location group on the order does not have a default address in the company module.
  • Resolution: Estimated tax now displays a message informing the user that an address needs to be entered before estimated tax can be calculated.
  • Issue: Multiple shipments against a single sales order update Avalara with the latest transaction only when the "commit transactions" option is not enabled.
  • Resolution: Multi shipment orders now process each shipment correctly.

BigCommerce

  • Issue: BigCommerce plugin does not correctly verify if an order already exists in Fishbowl causing errors.
  • Resolution: Plugin now checks for current orders correctly.
  • Issue: Spaces on the end of a SKU are causing problems when looking up products by SKU.
  • Resolution: Carts that use SKU for identification now trim any spaces from the beginning or end of the SKU field.
  • Issue: Payment isn't pulled in on any orders paid for with store credit.
  • Resolution: Store credit now works as payment for orders when importing to Fishbowl.
  • Issue: Order number field is limited to a 30 character limit, orders with longer numbers do not import correctly.
  • Resolution: Field has been updated to varCharLong to accommodate for more characters.
  • Issue: If a product already exists in Fishbowl, any subsequent product syncs do not link variants.
  • Resolution: Variant products are now correctly linked during the product sync.
  • Issue: Verifying whether an order already exists in Fishbowl doesn't always work correctly.
  • Resolution: Order verification now correctly looks at existing orders.
  • Issue: Orders with more than 50 items don't include any items past the 50 item mark.
  • Resolution: Orders with more than 50 items now import correctly.
  • Issue: Coupons aren't coming in as a discount line item.
  • Resolution: Coupons now import correctly as a discount.
  • Issue: Inventory sync is occurring by product SKU instead of the item ID in the BigCommerce custom field.
  • Resolution: Inventory sync is now occurring by ID.
  • Issue: Sales order export isn't using the custom field for ID.
  • Resolution: ID field is now being used correctly.
  • Issue: Discounts are applying to the line item level, not the order level.
  • Resolution: Discounts now correctly apply to the order.

Magento

  • Enhancements
  • Ability to push product price and description changes from FB to Magento after initial product sync
  • Added more product field mapping options for SKU, Name, and Description fields
  • Customer email from Magento order now imports to the FB SO
  • Magento Store identity is now stored on the FB SO
  • Line item identity is now stored in SO Line Item custom field
  • If the FB carrier is set to UPS, USPS, FEDEX or DHL that will be sent to Magento, otherwise the value "custom" is sent along with the tracking number.
  • Fixes
  • Configurable Products now import correctly to FB
  • Zero Dollar Orders now import to FB
  • Line item level discounts now apply correctly

Magento 2x

  • Issue: Magento 2 plugin was not properly hiding the Tax field in the order import settings for international versions making it unusable.
  • Resolution: Tax fields now hides correctly for international versions of Fishbowl.
  • Issue: Discounts on orders cause an error when attempting to import.
  • Resolution: Discount field added to plugin to allow for mapping.
  • Issue: Unpaid orders come into Fishbowl as paid, while paid orders are coming in as unpaid.
  • Resolution: Paid orders and unpaid orders now come in with the correct payment status.
  • Issue: Attempting to connect to a shopping cart store when credentials are incorrect doesn't display a failure message.
  • Resolution: Failure to connect to a store now displays a user friendly message.

ShipStation

  • Enhancements:
  • Push Carrier and Carrier Method (when selected) from FB SO to Shipstation Order
  • Added reset last sync button
  • Push Carton Dimensions (when defined) from FB to Shipstation
  • Push product price from FB to Shipstation
  • Orders synced to SS will push over the customer email address
  • Fixes
  • Issue: Transfer orders don't import to ShipStation.
  • Resolution: Transfer orders are now included in the shipment sync to ShipStation.
  • Issue: syncing orders can create duplicate data when the order of operations isn't carried out correctly.
  • Resolution: Sync to and from Fishbowl have been combined into a single button.

Shopify

  • Issue: Manually linking a kit doesn't pull the kit product number, it pulls the title or SKU based on settings.
  • Resolution: The kit product number is now used for linking.

Volusion

  • Issue: Order export does not add store group number to query causing orders to fail when pushed to Fishbowl.
  • Resolution: Store group number is now included and order sync is working properly.

WooCommerce

  • Issue: Orders are using the customer address information instead of the order address which causes a null error when importing orders.
  • Resolution: Order address is now being used so the order import can successfully run.
  • Issue: When a user has the "company" field populated but nor first or last name a blank customer record is created.
  • Resolution: Customer record no longer includes blank data.
  • Issue: Using the Avalara Avatax plugin with WooCommerce cannot pull in orders because of an error that occurs when attempting to sync.
  • Resolution: Orders with Avatax now correctly sync.

Zen Cart

  • Issue: Order sync isn't correctly pulling the bill to address on an order, only the ship to address.
  • Resolution: The bill to address is now pulling with the order sync.

Fishbowl API

  • Issue: Save CarrierService on shipment doesn't work.
  • Resolution: Save works now
  • Issue: GetNextNumber causes incorrect commiting.
  • Resolution: Removed the bad request
  • Removed: OpenModuleRq
  • Removed: ProductQuery
  • Use Instead: ProductGet
Database Changes - 2017.1
  • POSTransaction table column "change" has been updated to "changeGiven"
  • ShippingImport table column "ignore" has been updated to "ignoreThis"
  • PluginProperties table column "key" has been renamed to "dataKey"
  • PluginData table column "key" has been renamed to "dataKey"
  • DataExport table column "sql" has been renamed to "dataQuery"
  • Part table column "rev" has been renamed to "revision"
  • Data auditing is now enabled. When audits occur, new tables are created as tableName_aud