Release Notes

From Fishbowl
Jump to navigation Jump to search

Release Notes.png

Release notes:

2021.7 - 7/15/2021

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 an automatically applying to Invoices incorrectly
  • Resolution: Added a module option for Automatically Applying Payments that can be disabled

QuickBooks Online

  • Resolved: Vendor credit return posting incorrect journal entries

REST API

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

UOM

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

User Group

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

Xero AU

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

2021.6 - 6/10/2021

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

2021.5 - 5/13/2021

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

2021.4 - 4/15/2021

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

2021.3 - 3/11/2021

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

2021.2 - 2/18/2021

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

2020.11.1 - 11/13/2020

Highlights - 2020.11.1
New Features - 2020.11.1
Fixes - 2020.11.1

Fishbowl Client

  • Connection security improvements

CSV

  • Issue: Customers CSV marks all contacts of a single type as default upon import
  • Resolution: The last record on the import for that contact type is selected as default
  • Issue: Vendors CSV marks all contacts of a single type as default upon import
  • Resolution: The last record on the import for that contact type is selected as default
  • Resolved: UOM CSV allows changes to read only UOMs

Picking

  • Resolved: Changing the Sales Order number does not update the Pick Number(s)

Purchase Order

  • Resolved: Unable to receive when an tracked outsource item is set to return as an non-tracked item

QuickBooks Online

  • Issue: Export issues when taking negative payments on a return Sales Order
  • Resolution: When taking a negative payment on a return Sales Order, an error message is now displayed with directions to take the payment in QuickBooks Online
  • Issue: Customers address information is updating based on Ship To address
  • Resolution: Updated customer update to update address information based on the Bill To or Main Office address
  • Resolved: Receiving Journal entry not being voided when using a specific process
  • Resolved: Null pointer on export

Reports

  • Resolved: TPS Report not accounting for split shipments
  • Resolved: Sales Backorder Report: POs in summary were not appearing on XLS/CSV exports
  • Resolved: Sales Order Summary: Date not displaying correctly when range is set to a single day

Sales Order

  • Speed improvements when quick fulfilling an order with a high number of items

Square

  • Resolved: Unable to integrate the payment gateway for the first time

Xero

  • Resolved: Tax Rate export issue with multi currency enabled

2020.10 - 10/8/2020

Highlights - 2020.10
New Features - 2020.10
Fixes - 2020.10

API

  • Resolved: AddSoItemRq getting a new Sales Order Number instead of using the order number supplied

Linux Installer

  • Resolved: Headless installer installing the Client Only

Manufacture Order

  • Resolved: The "Short Quantity" Auto Create option was creating orders for full order qty instead of what was short for Staged Bill of Materials

Purchase Order

  • Resolved: Automatically issue Drop Ship orders option not working with CSV imported Sales Orders
  • Issue: Auto PO location group class filter not showing expected data
  • Resolution: Clarified usage through user interface and logic changes

QuickBooks Online

  • Resolved: Export errors causing multi-currency orders to fail


Database Changes

  • Added CalCategoryId column to MoItem table

2020.9 - 9/17/2020

Highlights - 2020.9
New Features - 2020.9
Fixes - 2020.9

Avalara

  • Resolved: Quick Fulfill issues with service type items

CSV

  • Resolved: Historical Sales Order status triggers Build To Order settings on Bill of Materials
  • Resolved: Add Inventory CSV incorrect line # error
  • Resolved: Sales Order CSV errors when importing more than one order per file

Custom Fields

  • Resolved: Searching data in custom fields yielding inconsistent results

Email

  • Resolved: Email Address Book list included inactive users' emails

Installer

  • Resolved: Installer auto assigns too much server memory

Manufacture Order

  • Resolved: Finished Good rounding issues

Part

  • Resolved: Next Value column for Tracking only accepts single digit values

QuickBooks Online

  • Resolved: Full payment not being sent over for an order with multiple shipments
  • Resolved: Accounts Receivable and Accounts Payable account creation showing the other account in the description

Receiving

  • Resolved: Tracking Numbers placed in the Shipping tab are unable to be copied
  • Resolved: Inconsistent Rounding for items added during the Add Item step of the Reconcile wizard

Reports

  • Resolved: Sales Order Taxes - Credit items showing $0
  • Resolved: Customer Purchase History - Filtering for Product Trees broken.
  • Resolved: Sales Backorder Report - Show PO not working.

Xero

  • Resolved: Accounts Receivable and Accounts Payable account creation showing the other account in the description


Database Changes

  • Login column increased field size to 2048 on PaymentGateway table
  • Secret column increased field size to 2048 on PaymentGateway table
  • Added TotalTax column to PostSo table
  • Added TotalTax column to PostSoItem table

2020.8 - 8/13/2020

Highlights - 2020.8
  • Replaced the Dropbox module with the Icon.Fishbowl Drive.png Fishbowl Drive plugin
  • The Class field on a Sales Order is now sent to the LocationCode in Avalara
  • Added an option to remove the prefix of the order number sent to Avalara
  • Added an option to connect to a sandbox account for testing the Avalara integration
  • Added an option to send either the Customer Name or Customer Account Number to the CustomerCode in Avalara
  • Enhanced flow for drop ship, credit return and other non-sale type items when integrated with Avalara
  • Added an accounting module option to send shipping tracking numbers to the Sales Order and Accounting integration without needing to use Carton Based Shipping
  • Added option to import custom single level Bill of Materials on the Sales Order CSV import
New Features - 2020.8
  • Customer Jobs entered on the Customer CSV now inherit the parent customers address when leaving the address fields blank
  • Enhanced the VoidShipment API call to allow for unpacking a packed shipment
  • Separated User Rights in Sales Order for Void and Delete
  • Increased text type Part Tracking fields to allow for 256 characters
  • Optimized the Auto PO function
  • Updated Xero to send 4 decimal places for unit costs
  • Updated Xero to append original unit qty to the description field
  • Added green text to show payment processing for eCheck payment methods
  • Updated the GS1 Code field to display 0's and leading 0's
Fixes - 2020.8

Avalara

  • Resolved: Estimate button not sending the product code to Avalara
  • Resolved: Null error when quick fulfilling an order with an invalid zip code

CSV

  • Resolved: Part Product and Vendor Pricing import does not update length, width or height for Non-Inventory type items
  • Resolved: BOM import requires Part field for note type items

Checkout

  • Resolved: UOM Conversion errors
  • Resolved: CA version would not allow you to edit a line item

Custom Fields

  • Resolved: Required list type custom fields won't allow users to issue Purchase Orders with "Access right to issue order" enabled

Email Templates

  • Resolved: Email template carriage returns not working

Payments

  • Resolved: Issues taking eCheck payments with business type checking accounts

Picking

  • Resolved: 0 qty pick issues
  • Resolved: Selecting an alternate pick location with insufficient inventory and clicking Finish resets item back to Entered status

Reports

  • Resolved: Purchase Order Summary - PO# hyperlink broken
  • Resolved: Sales Backorder Report - Summary data not matching main items
  • Resolved: Customer Statement - Very old orders showing $0 price
  • Resolved: Packing Slip - Show Carton Info checkbox broken
  • Resolved: Packing Slip - Not showing all tracking
  • Resolved: POS Receipt - Rounding issues
  • Resolved: Batch Packing List by Date - Null error when trying to run report
  • Resolved: Margins Report - Displaying incorrect data when grouped by Product Tree

Reports Module

  • Resolved: Default search filters for MO Status set to All instead of All Open

Sales Order

  • Resolved: Duplicating a credit return resulted in a positive total price on each line item
  • Resolved: Duplicate Sales Order error when using an _ in the order number

Work Order

  • Issue: Disassembling a WO with a raw good that consumed 2 different lot #'s only adds 1 of the lot #'s to inventory
  • Resolution: When more than value of the same type tracking was consumed, the disassemble requires entry of the tracking to add to inventory

Xero

  • Resolved: "The line total does not match the expected line total" on Sales Order Export

Database Changes

  • Updated TrackingInfo.info and TrackingText.info fields to be varchar(256)

2020.7 - 7/9/2020

Highlights - 2020.7
New Features - 2020.7
  • Purchase Order Summary
  • Added options to hide/show headers, totals, and timestamp to make it more Excel friendly.
Fixes - 2020.7

API

  • Resolved: User access rights for viewing orders working opposite of expectation (GetSOSearchListRq)

Checkout

  • Resolved: Round Cash Transactions module option not working for home currency customers
  • Resolved: Default Customer module option doesn't save home currency customers

Custom Fields

  • Updated the URL custom field advanced search text box to allow for more characters
  • Updated the text custom field advanced search to search containing instead of an exact match
  • Custom Field changes now show on the Audit Tables

CSV

  • Resolved: Null error when importing the Location CSV
  • Resolved: Errors caused after Part and Product Renaming CSV fails on import

Locations

  • Resolved: Auto Create Locations creation failing when the number of location to create ends in 0 or is a factor of 10
  • Resolved: Location Num search does not filter results

Reports

  • Resolved: Sales Order Taxes - order tax not showing is AU databases
  • Resolved: Margins Report - Discounts duplicating when there are split shipments
  • Resolved: Lot History Report - Customer info not showing
  • Resolved: Packing Slip - Some backorders not showing
  • Resolved: Bill of Lading - Items weights were not being multiplied by the quantity
  • Resolved: Customer Purchase History - Price duplicating in some instances
  • Resolved: Customer Purchase History - Credit Return items showing a positive quantity

RMA

  • Resolved: RMA Tracking Search step in the New RMA Item wizard was missing

Sales Order

  • Resolved: Saving changes to an SO causing original pick to be deleted and recreated

Shipping

  • Resolved: Inactive Carriers show up in the Batch Shipment Wizard

Xero

  • Resolved: Export errors related to records containing an "&"
  • Additional changes to Xero integration to help with reconnecting error
  • Resolved: Export error causes the entire export to stop and fail

Database Changes

  • Added column on part tracking for GS1 code

2020.6 - 6/11/2020

Highlights - 2020.6
New Features - 2020.6
  • Shipment History Report
  • All columns now stretch with overflow.
  • Order Number and Ship To columns are wider.
  • Report Title can be modified.
  • Pagination will auto-hide when "Format Report for Exporting" is checked.
  • ABC Report
  • Updated to be more Excel-friendly.
  • Part and Description fields are in their own columns.
  • Qty and UOM fields are their own columns.
  • Added options to remove headers, totals, and timestamp.
  • Pagination will auto-hide when "Format Report for Exporting" is checked.
  • Report Title can be modified.
  • Bill of Lading
  • Modified design
  • More fields are editable including Seal #, Trailer#, NMFC, and Class.
  • Added options to display Third Party Bill To address and PRO Number.
Fixes - 2020.6

Avalara

  • Updated order total and tax line item names to match Avalara requirements

CSV

  • Resolved: Sales Order Details CSV doesn't have residential flag
  • Updated Custom Field Data CSV to include Pick
  • Resolved: Sales Order and Sales Order Details CSV's import sets carrier service to customer default when left blank
  • Resolved: Shipping Data CSV does not clear out the carrier service when the carrier is set
  • Updated Part CSV Instructions (Import/Export) to add POItemType
  • Updated Sales Order CSV export instructions
  • Updated Sales Order Details CSV export instructions
  • Resolved: Sales Order Details CSV error with updating historical status orders
  • Resolved: Sales Order CSV does not import residential flag correctly

Custom Fields

  • Resolved: Checkbox custom fields clear data when the name is changed
  • Resolved: Error when adding a new item to the RMA Issue custom list

Customer

  • Resolved: Customer combobox search searching containing instead of starts with

Picking

  • Resolved: Custom Fields on finished picks were still editable

Reports

  • Resolved: Tracking Report won't run when there's too much data. Added Count and Skip parameters.

RMA

  • Resolved: Cannot complete RMA wizard for substitutions

Sales Order

  • Resolved: Sales Order details tab, contact field, pulls from Bill To address while other fields pull from the Ship To address


Database Changes

  • Updates to Custom Field helper functions
  • Add SHIPNUMVIEW for UPS Worldship and FedEx Ship Manager integrations
  • Added customFields column to BomInstructionItem table
  • Added customFields column to WoInstruction table
  • Added customFields column to Location table
  • Updated CustomFieldsView to include BomInstructionItem, WoInstruction, and Location custom fields

2020.5 - 5/21/2020

New Features - 2020.5

IMPORTANT INFORMATION REGARDING FISHBOWL 2020.5 UPDATE:

Fishbowl 2020.5 introduces a new way of storing Custom Fields. This change also affects custom reports and plugins. If you have custom reports and/or plugins, please contact Fishbowl's Reports Team (reports@fishbowlinventory.com), Plugins Team (pluginsdev@fishbowlinventory.com), or the partner who built the plugin prior to updating to 2020.5 to make sure they continue working after the update.

  • Item History Report
  • The Qty field has been widened. It can now fit 6 digit numbers without wrapping.
  • Purchase Order Summary
  • Added Date Confirmed and Order Date Scheduled as date range options
  • Title can now be modified.
  • Minor cosmetic changes.
  • Work Order Summary
  • Added the option to filter by assigned user to enable users to see only the orders they are assigned to.
  • Shipping Invoice
  • Added the option to hide/show Tax Code, Tax Amount, and Item Currency Tax columns for Australia and International versions.
  • Added an option to show carton details including shipment tracking numbers.
  • SO Report
  • Added an option to display the tax code name in place of "Sales Tax" in the totals section.
  • Title can now be modified.
  • WO Flag Report
  • Added the option to filter by assigned user to enable users to see only the orders they are assigned to.
  • The selected date range now displays at the top of the report.
  • CC Receipt 3in
  • The receipt has been completely redesigned. A copy of the old receipt file can be obtained for free at https://store.fishbowlinventory.com/products/cc-receipt-3in-legacy.
  • Added an option to show/hide the signature name.
  • Added a customizable line of text at the bottom. It defaults to "Thank You!". Character limit is approximately 16-50 (depending on which characters are used).
  • MO Projected Cost Report
  • Added an option include/exlude WOs that are stages from the MO Total Cost.
  • Calendar Report
  • Added an MO filter. Only the WOs for the selected MO will show unless the filter is left blank.
  • Inventory Availability Report
  • Added an option to Show Parts with 0 Qty.
  • Pick Efficiency Report
  • Changed the User text input field to a combo box (drop-down list).
  • Part Allocated Report
  • Added an option to include drop ship items in Qty Allocated to SOs.
Fixes - 2020.5

Accounting

  • Added pop up message when selecting "Create a bill in {Accounting} after reconciling a receipt."

Bill of Materials

  • Resolved: Sorting part number column
  • Resolved: BOM Min/Max Variable Qty doesn't save without additional change

Checkout

  • Resolved: Error when cancelling payment when Auto Pack module option is enabled

CSV

  • Custom Field - Updated module name from SysUser to User
  • Custom Field - Updated the export sorting
  • Cycle Count CSV - Updated instructions pertaining to part tracking
  • Resolved: BOM/BOM Details import alters unchanged sort order
  • Resolved: Export and reporting a Purchase Order created by dropship Sales Order breaks the link between the orders
  • Resolved: Part Product and Vendor Pricing allowed updating the COGS account for Capital Equipment type parts

Custom Fields

  • Resolved: Required list-type custom fields can be saved without a value
  • Resolved: Values not saving for list-type when partially typing a value and selecting from the filtered list

Customer

  • Resolved: Customer save prompt after viewing a secondary address

Manufacture Order

  • Resolved: Search not showing "Multiple BOM's" for multiple Finished Goods

Picking

  • Resolved: Issues with module option for "Assign user to pick on finish"

Product

  • Resolved: Product details banner display issues

Purchase Order

  • Resolved: Customer/job not updating on receipt until PO is unissued and reissued.
  • Resolved: Being able to close short items created by dropship kit items
  • Resolved: Incorrect buyer name from Drop Ship Sales Orders
  • Resolved: Carrier Service doesn't carry through to Shipment for Credit Return PO's
  • Resolved: Order Fulfill or Line Fulfill removes carrier service from Shipping Tab

QuickBooks/Reckon

  • Integration compatibility improvements

Receiving

  • Resolved: Outsource parts costing layer issues when reconciling multiple times
  • Resolved: Blank error when reconciling consumed part
  • Resolved: Reconcile wizard showing the landed cost step when there is nothing to land into

Reports

  • Resolved: Part Barcodes Avery - label alignment drifts when part description is greater than 3 lines.
  • Resolved: Sales Order Taxes - The tax rate field does not stretch with overflow.
  • Resolved: Sales Order Taxes - Discounts showing a negative tax.
  • Resolved: Customer Purchase History - Duplicating discounts.
  • Resolved: Customer Purchase History - Qtys incorrect if split into more than one ship item.
  • Resolved: Margins Report - Product Tree filter not working correctly.
  • Resolved: Being able to edit tracking when receiving an outsourced item

Sales Order

  • Quicklist dropdown improvements
  • Resolved: Cost issues when changing from credit return to sale type

Server Administration

  • Added a confirm dialog to the database disconnect button

Shipping

  • Resolved: SO/PO Item descriptions no carrying over to shipping

Work Order

  • Resolved: Work Order item sort order not matching Bill of Materials sort order

Xero

  • Resolved: Class not exporting for SO reconcile journal entries

Database Changes

  • Added customField JSON field to BOM, Company, Customer, MO, PO, PoItem, Part, Product, RMA, SO, SoItem, Ship, SysUser, Vendor, WO, XO, Pick and BomItem tables
  • Removed the following tables: CustomDecimal, CustomInteger, CustomSet, CustomTimeStamp, CustomVarChar, CustomVarCharLong
  • Removed the CustomFieldAuditView
  • Added function to help with custom field queries: CustomFieldByName(customFields, “custom_field_name”)
  • Added function to help with custom field queries: CustomFieldByID(customFields, "id")
  • Updated CUSTOMFIELDVIEW
  • Updated ONTRACVIEW

2020.3 - 3/12/2020

New Features - 2020.3
Fixes - 2020.3

Auto PO

  • Resolved: Parts with sufficient quantity showing to be ordered

Bill Of Materials

  • Resolved: BOM Instructions missing browse for URL

Fishbowl GO

  • Resolved: Error caused by a part stored in pounds being consumed in ounces on WO

Imports

  • Resolved: Spaces not being trimmed from beginning or end of column Headers
  • Resolved: Unable to import kits with option groups or discounts
  • Resolved: Importing a kit on the Sales Order CSV with only the kit header will show part cost as $0
  • Resolved: Importing the PPVP for an existing part with only the required columns will overwrite Tax Codes to blank (AU)
  • Resolved: EDI Shipping Export exporting the SO number instead of the shipment number
  • Resolved: Incorrect line number errors on WO Steps CSV import
  • Resolved: Incorrect line number errors on BOM Instructions CSV import
  • Resolved: Incorrect line number errors on BOM Details CSV import
  • Resolved: Incorrect line number errors on Kit Items CSV import
  • Resolved: Incorrect line number errors on SO Details CSV import

Monitor

  • Resolved: Displayed negative available quantity

Pricing Rules

  • Resolved: Using Adjust Prices wizard only updating the first 100 records

QuickBooks Desktop

  • Re-integration improvements

QuickBooks Online

  • Issue: Discount Account mappings not overriding the Integration Default Mappings
  • Resolution: Disabled the dropdown in Discounts to select specific accounts

Reports Module

  • Resolved: Report module wouldn't load after getting logged out for inactivity until you exit and restart the client

Sales Order

  • Resolved: Return SO's from RMAs do not take BOM adjustments into account
  • Resolved: Sales Order not refreshing after voiding a shipment

Shipping

  • Resolved: Layout changes not saving

User

  • Resolved: Errors when logging in with a User whose default location group was inactivated

XERO

  • Resolved: Connection error when trying to reintegrate

2020.2 - 2/20/2020

Highlights - 2020.2
New Features - 2020.2
  • Shipping Invoice
  • Title is now modifiable. Proforma and Invoice titles can be changed separately.
  • Downsized the font on the item list. The report can now display more items per page.
  • Work Order Flag
  • Now displays calendar categories.
  • Added options to filter by, sort by, and hide/show categories.
  • Title can now be modified.
  • Work Order Summary
  • Now displays calendar categories.
  • Added options to filter by, group by, and hide/show categories.
  • Added an optional Location Group column.
  • Title can now be modified.
  • Work Order Traveler
  • This report has been completely redesigned.
  • Changed to portrait and downsized the font to make room for many more items on a page.
  • Now displays calendar categories.
  • Added option to hide/show categories.
  • Title can now be modified.
  • BOM Instructions no longer display on their own page.
  • Manufacture Order Traveler
  • This report has been completely redesigned.
  • Changed to portrait and downsized the font to make room for more WOs per page.
  • Now displays calendar categories.
  • Added option to hide/show categories.
  • Title can now be modified.
  • Export Summary
  • Added "Apply Date Filter" option. The date range can now be set to look at either Date Posted or Item Date Fulfilled.
  • Purchase History
  • "Apply Date Filter" titles have been changed to reflect the names in the client.
  • Report title has been changed to "Customer Purchase History".
Fixes - 2020.2

Authorize.net

  • Resolved: Payment Gateway integration being removed after deleting a payment that was taken before integrating with Authorize.net

Checkout

  • Resolved: No prompt to print the invoice after selecting Invoice payment method

CSV Import/Export

  • Resolved: Users create from CSV import would not show in dropdown lists until after a server restart
  • Resolved: Generic Shopping Cart CSV missing QB Class column
  • Resolved: Yahoo Shopping Cart CSV missing QB Class column
  • Resolved: PO as SO export blank error because of missing QB Class column
  • Resolved: Receipt Item unit cost showing $0 when PO was created via CSV
  • Resolved: Add Inventory XLSX import error with 3 or more decimal digits
  • Updated Part Product & Vendor Pricing import instructions to specify that the Asset Account column maps to the expense account field for non-inventory parts
  • Resolved: Tooltips & CSV instructions showing incorrect character limits
  • Resolved: Importing locations requires a server restart to show in lists
  • Resolved: Part Product & Vendor Pricing import allowed non-inventory type parts to have tracking assigned
  • Resolved: Using Part Cost CSV to update costs on databases not using average cost caused accounting export errors

Customer

  • Resolved: Null error when trying to save a customer when the address and contact information was added and then the address was deleted

Dropbox

  • Resolved: Error when opening a file uploaded for a Work Order

Fishbowl GO

  • Resolved: Receiving clears out customer/job field on receipt item

Installer

  • Resolved: Linux installer errors
  • Auto-updater optimizations

Inventory

  • Resolved: Moving an item with a serial number containing "%" causes an error

Locations

  • Resolved: Null error when deleting non-required location

Location Groups

  • Resolved: Creating a new Location Group requires a server restart to show locations in lists

Manufacture Order

  • MO to PO speed improvements
  • An MO with multiple WO's for the same BOM will display the BOM number in the search instead of saying "Multiple BOMs"
  • Resolved: Inability to pick higher level WO when deleting a lower level stage on a multi-stage order

Picking

  • Resolved: Finished pick item status orb shows green circle instead of a checkmark
  • Resolved: Splitting Work Order picks causing decimal eaches

Purchase Order

  • Resolved: Deliver To on CSV import not being accessible in the client
  • Changed PO Item Details "Outsourced" field label to "Returning As"

Receiving

  • Resolved: Modifying a consumed RG's serial number when selecting Finished Good tracking from consumed tracking caused a blank error

Sales Order

  • Resolved: Sales Order CSV attachment being blank or missing when sending Purchase Order emails
  • Resolved: Payment Receipt module option set to none still tries to print receipt

Shipping

  • Resolved: Paid stamp not showing because of rounding errors
  • Resolved: Shipping an item with a serial number containing a "\" caused an error
  • Resolved: Voiding a shipment with Carton Based Shipping turned on removes all manually added shipping type line items

Quickbooks Desktop

  • Resolved: Customers without a set country not importing state into Fishbowl
  • Resolved: Partial fulfillment with multiple subtotals export issues
  • Resolved: Suspense account type would break the export/integration (UK version)

Quickbooks Online

  • Resolved: Part/Product assigned accounts not overriding integration default account mappings

XERO

  • Resolved: Classes not being included on journal entries in certain situations
  • Resolved: Vendor credit journal debiting inventory asset rather than crediting it
  • Resolved: Export rounding errors
  • Issue: "Invoice # must be unique" error when fulfilling 2 different drop-ship items on the same order
  • Resolution: Added module option to add a unique ID to the order number
  • Resolved: "The line amount cannot be zero or empty" export error

Database Changes

  • Added column PART.DEFAULTOUTSOURCEDRETURNITEMID
  • Added column PART.DEFAULTPOITEMTYPEID
  • Dropped table PLUGINDATA_AUD
  • Also added 'Cancelled' status id's for SO and SO Item (85 and 75 respectively)
  • Updated the following fields to size 60
  • SO.billToName
  • SO.shipToName
  • SHIP.shipToName
  • PO.shipToName
  • PO.remitToName
  • XO.shipToAttn
  • XO.fromAttn