Bug Fixes - 27.0.21 - Released 10 March 2025

Using Sage 100, when partially invoicing an order with multiple items and running connectors, this process alters the quantity ordered on the order. Consult the Reason For Point Release for information with how to keep from overwriting data in existing environments. This is one of the reasons for the point release.

Prior to this fix, we were not downloading the Sales Order Transaction Date (TxnDate) to our Order date (ord_dt) in QuickBooks Desktop. However, we were uploading it. Since we default order date to today, this was not being noticed in production environments. Consult the Reason For Point Release for information with how to keep from overwriting data in existing environments. This is one of the reasons for the point release.

A ship-to in QuickBooks Desktop with a blank code would not download because of the name broken rule.

We were downloading invoiced/manually closed orders from QuickBooks Desktop as if they were open orders and should not have been. Now, we don't download sales orders from QBD that are marked Fully Invoiced or Manually Closed.

This updates customer's and sales orders to download from QuickBooks Desktop before uploading from BD. We also updated the How It Works page to include a proper order of operations which highlights the sequence in which things are downloaded.

First time connectors run was pushing data back to QuickBooks Desktop, overwriting blank data with BirdDog default options.

We were seeing this error on Spire environments.

The unique index for ExternalNumber was incorrectly created as "Ord_No", "ExternalNumber" on Spire environments. This should have been "ExternalNumber", "Ord_Type", "Ord_No", "Line_No". This is one of the reasons for the point release.

Even though QuickBooks Desktop Sales Orders appears to be using the ShipTo codes, QBD does not actually have the concept of this on Sales Orders. Because of this setting, the default ship to on a customer causes issues. This removes the mapping of Default Ship To -> Customer's Default Ship To and adds the mapping Default Ship To -> BirdDog Field Default Ship To. This also does a data conversion setting BirdDog Field Default Ship To based upon if Customer's Default Ship To is set. Consult the Reason For Point Release for information about how to clear it.