Bug Fixes: Version 9.8.7.636 - Released 6 November 2018

This build has the following bug fixes implemented:

Fixed

7331893 - Macola Orders Posted in Birddog Have Wrong Kit Component Quantities

When you posted an order created in Macola using Accounting | Process Orders that has a kit item on the order, the components for the kit were issued at 1/100 of their actual quantity. Example: if the kit component issued a quantity of 5, Process Orders issued instead 0.05. This worked fine if the order was placed in Birddog or if the order was posted using Macola.

Fixed

7694536 - Field Import on Web Not Working

Field Values were erroneously set to case sensitive, so a value of "red" (for example) did not match a field value of "Red" during the import. In such a scenario now, the import will ignore case providing the data itself matches.

Fixed

7766860 - Percentage Off Order Rule Doesn't Update if Item Added to Cart After Special Code Entered

The Order Rule Result "Percentage Off' wasn't getting updated if you added an item to the cart after the Special Code is entered. Now, it updates every time the cart is updated.

Fixed

7826382 - Contact Note Body Doesn't Save

On BRAIN/ContactForm.aspx, the Body of Contact | Notes did not get saved when you clicked Save.

Fixed

8723801 - ES - Birddog Does Not Write to Macola Order Audit Tables

Orders created and edited in Birddog software were not writing entries properly to the database.

Fixed

9376959 - Quote header not deleted when converting credit card quote to order

When an quote was converted to an order using BirdDog Enterprise, the process was not properly removing the quote so both it and the order remained in the system.

Better

9419275 - Saving Edited Order Can Delete Credit Card Expiration Date in cicmpy

Saving an edited order could delete the credit card expiration date in cicmpy if the customer CC info was edited in Macola while the order was open. This was a case of 2 things open at the same time and they were stepping on each other.

Better

9467769 - Add better error logging to Order Form

Added error handling on a number of the available buttons to catch strange exceptions.

Better

9605359 - Tax Code Page Missing Label

Added a label to the page.

Better

9627196 - Popup on Item Edit Needs Work

Tweaked the visuals for this popup so it doesn't look as bad.

Better

9682111 - Tooltip: Google Analytics in Site Settings Needs Tweak

Edited to improve clarity.

Fixed

9686570 - No longer able to override credit card comments on checkout page

A customization point that existed in prior versions had been removed, added back in this release.

Fixed

9697409 - BDShipViaFreightAccounts Table Not Syncing

This table was not properly syncing which affected how orders were being handled.

Better

9723288 - Web Page Redirect URL's Limited to 50 Characters

Previously, you were unable to add a redirect page if the "Code" was over 50 characters. We have significantly increased that limit.

Fixed

9747062 - Checkout Page Saved Address DDL Problem

The default address (the one created when creating a new customer) was showing in the Checkout page Saved Address DDL as a blank. When you clicked on another saved address, the ship-to info changed to the one selected, however, if you then clicked the 'blank' saved address, nothing happened.

Fixed

9770581 - Data Scrubbing license not included in SaaS License

Customers with just the SaaS / Subcription license did not have access to Enterprise for Windows | Processes | Data Scrubbing items, but should have.

Fixed

9786874 - Web Category Import should allow name or ID for Document Layout

When importing a web category, you can use either the intended layout name or its ID (which will be a GUID.) Prior to this, the ID was the only one that would work.

Fixed

9797970 - Item Page Only Looking at Item's Default Location to Determine In-Stock Status

The ItemForm.aspx page is determining In Stock status by looking at the item's Default Location and not the location determined by the parameters set for the item / customer. The CartForm.aspx page shows correctly based on the quantity for the location that is determined to be used for the order.

Better

9833076 - Tooltip: Freight Dimensions

Added tooltip.

Better

9843250 - Move Phone Text Box on Check Out page

On the Checkout page, the "Phone" label & text box were located in the "Shipping Address" section. The phone number here was the "Ordered By" number, not the ship-to number so it needed to be moved to the "Your Information" section (right under "Email Address").

Fixed

9834764 - Software Throwing an Incorrect Syntax error but isn't Reporting the Bad Query

Software was throwing an Incorrect Syntax error but wasn't actually reporting the bad query that was the actual problem. This happened only in very specific situations with equally specific data, but we tweaked the coding to handle this kind of scenario better.

Better

9848563 - Request Timed Out Error When Clicking Open Orders

Open Orders was rating freight, which was problematic if your active customer had a very large number of Orders.

Fixed

9877708 - Error When Placing Credit Card Orders

The Authorize.net merchant service was not handing the error message back correctly, so we forced the code to handle this scenario better.

Fixed

9877809 - Unable to Pick Orders Using Enterprise for Windows

Error due to customer specific data fixed.

Fixed

9894928 - Print Pick Tickets Adding to Allocations in Macola ES

When you run "Print Pick Tickets" in Enterprise for Windows, it was adding to the item's allocations in iminvloc_sql for every item picked (should remain the same). This was throwing off allocations every time Print Pick Tickets was run.

Fixed

9896439 - Saved Credit Cards with No Address Blank Bill To Address on Order

Saved Credit Cards that were missing address info caused the order Bill To info to blank out which resulted in the order Bill To changing to match the saved card's address info.

Fixed

9913507 - Freight Tax Causing Posting Error

Tax on freight was causing order posting to throw an "Out of Balance" error when tax was from a Tax Schedule.

Fixed

9914015 - Birddog Not Posting Same As Macola

Orders posted using Birddog were setting the selection code to "X" (should be "Z") and not entering info in four specific fields in one table.

Fixed

9932129 - Conversion Error When Converting Cart to Order

Orders were not sending all order confirmation emails. We discovered that some orders were throwing errors under the hood and the system was not handling them gracefully.

Fixed

9942541 - Password Recovery Email Using Wrong From Address

The "From" address for Password Recovery emails WAs using the "Default Email Address" and not the "Password Recovery Mail From" address in Site Settings>Email tab.

Fixed

9947409 - Capture Credit Cards doesn't support NoActualPrinting

If the Process End of Day job was set to 'noactualprinting' (which was added in previous versions), it was throwing an error instead of completing the job.

Better

9984988 - Allow Partial Shipments is on the wrong tab

"Allow Partial Shipments" was on Site Settings | Ecommerce | Other but this is a Customer default and needed to be moved to that tab below "Allow Back Orders".

Fixed

9974234 - Site blows up when you press Standardize Address and USPS isn't setup

If you do not have a USPS freight account setup, when you click on Standardize Address on a BRAIN contact, the site crashed. Now it gives you a message telling you it can't do this.

Better

9976201 - Field Maintenance does not confirm delete

While editing a field in System Management, clicking Delete simply did it without asking for confirmation.

Better

10008007 - BDCreditCardTrxs.AmountUser Needs Larger Character Limit

This table field was limited to 30 characters, which was resulting in an error during checkout if the transaction had more characters than that.

Fixed

10022717 - Find User From Customer Search Crashes EntWin

Enterprise for Windows was crashing when attempting to use this search function.

Fixed

10038377 - Coupon Code Order Rule Not Working in Customer Service

In Customer Service>Order Entry, when you entered a "Coupon Code" (from an Order Rule), you received an "Invalid Coupon Code" message on the page. The order rule worked fine in ecommerce.

Fixed

10046622 - Conversion from type DBNull to String Error when placing order

Error due to customer specific data fixed.

Fixed

10048724 - Site Error when Trying to View Invoices

Error due to customer specific data fixed.

Fixed

10059447 - Orders Not Getting "Ship Complete" Set as TRUE

Orders were getting created with "Ship Complete" as FALSE even though they marked TRUE in Site Settings.

Better

10082176 - Ship Complete Unchecked when Converting Quote to Order

When you converted a Quote to an Order, the "Ship Complete" box gets unchecked.

Fixed

10090704 - MVC Warehouse Management Label Misspelled

Label typo.

Better

10095229 - Vendor Import Not Working Correctly

There were two problems with this: First, the import was trying to read the header line, and not skipping it and starting on line 2. Second, if the first column (Vendor#) was blank, the import was not creating a new Vendor with a system assigned vendor number. Instead, it shifted every column over to the left by one and then threw an error because the values for the columns didn't match the schema.

Fixed

10121210 - Getting "Invalid or expired password reset request" When Trying to Reset P/W from Cart

When clicking on Forgot Password from the Cart login, the link received via email was bad. If you went directly to Login and tried it that way, however, it worked fine.

Fixed

10125779 - Not handling apostrophes in customer number

Attempting to reviewing a customer that has a number with an apostrophe was causing a site crash.

Better

10130152 - Bad Error Message on EntWin from Avalara

The error message Enterprise for Windows was returning for a bad address failed to identify exactly what address was wrong.

Fixed

10142365 - End of Day Processing Does Not Manifest Select

Using Enterprise for Windows, the "Interface Shipping" section of the "Process End of Day" was not "Selecting" the order or adding the freight amount in the proper table to the order.

Better

10146652 - AuthNet Returning N/A for Card Code Status

We updated how the CVV code gets sent to Auth.Net to fix this error message.

Better

10172426 - Poor Error Msg if User Logging In Has No Roles

A user logging into Enteprrise for Windows without any roles assigned got a confusing and far too technical error message. Now it tells you what is actually wrong in non-developer English.

Fixed

10208875 - Print Pick Ticket Job Not Working in Macola Progression

Making a change to an existing code located at Maintain | Freight | Pay Codes was causing the program to error out.

Fixed

10211219 - Item Edit Search Fails

When you troed search for an item in Item Edit, you got a spinner that never goes away and no results ever appeared.

Fixed

10228157 - Keyword Search Not Filtering for Audiences

On the search form, keyword search was not filtering results to only items that were in an audience.

Fixed

10229104 - Percentage Off Order Rule Result Doesn't Work Without Coupon Trigger

This Order Rule Result only worked when a specific trigger was also included in the rule.

Fixed

10229951 - Can't Process Credit Card if "&" in Customer Number

If an ampersand ("&") is in the customer number, credit cards simply would not process. This was only the case in Customer Service Order Entry.

Fixed

10242863 - Bin Table Not Updated When Selecting and Posting

Added support for Bins when selecting and posting.

Fixed

10245550 - Product Management License not being reflected in EntWin

Enterprise for Windows was not properly recognizing this license so those who had it could not use it.

Fixed

10269211 - Can't handle different edi_fg

An unexpected value in the Edi_fg column on the order and invoice header would cause errors. Now it no longer causes a system crash.

Fixed

10273173 - New Shipping Address Created with Every Order

When an order was placed in ecommerce, a new saved ship-to was being created with the shipping address that was used even if it is the customer's default shipping address.

Fixed

10273865 - Software Stripping Out Required Zeroes in GL Accounts

This happened only with the O/E Setup Profit Center Usage was set to O=Ord Pft Ctr and was causing some issues with accounting.

Better

10294945 - System Allowing Same Code in Freight Pay Codes

The system was allowing you enter a duplicate "Code" in Freight Pay Codes. This must be a unique code.

Fixed

10295235 - Get Page Error Loading Work Order

When you go to Manufacturing>Work Orders and click on an order number, you get "Page Not Found".

Better

10295240 - Order Not Taxable Flag Being Ignored When Sent to Avalara

We weren't sending Exempt on the transaction when that flag is checked in an order.

Better

10302823 - iminvtrx_sql Getting Different Input from Macola Order

Fixed scenarios where data in IMInvTrx_sql was not being formatted correctly.

Fixed

10306336 - Order Rule Discount Goes Away After Logging In

If you have an order rule using a coupon code and apply the code before logging in, it worked fine. This is also true if you login first. However, if you apply the coupon and then login, the discount goes away.

Better

10307751 - BDInvoiceSupport allows multiple records for invoice

Fixed error where multiple records per invoice could get into BDInvoiceSupport.

Better

10308684 - Process Day End Throws Error for Q Type Orders

Updated end of day process to not error when seeing quotes unexpectedly.

Better

10313598 - Canadian Address with Tax Code throwing Invalid Tax Schedule Error

Canadian tax laws are complicated and thus require a tax schedule setup in a specific way. If this schedule does not exist, the software now alerts you to this fact instead of displaying a confusing error message.

Fixed

10324930 - Missing Important Field for BOM Import

We were missing the all important Quantity field on our Bill of Materials import.

Better

10328345 - Order History Display Messed Up if No Item Image

When viewing an order in order history, if the item (in line items) does not have a small image, then the first column (which displays the image) displayed garbage instead of being blank.

Fixed

10336771 - Inventory Transaction Table Not Writing Correctly

Fixed scenarios where data in IMInvTrx_sql was not being formatted correctly.

Fixed

10343806 - Admin Can't Checkout if Customer Service is Enabled but Not Licensed

When a company is not licensed for customer service but the module is licensed, attempts to use it resulted in a site error.

Fixed

10356018 - Remove Permissions from Obsolete Items Job Not Working

This job was not working properly.

Fixed

10365014 - Invoice Totals Amounts are Different

On the invoice report, the "Total" & "Balance Due" were not always the same (with Amount Received = 0). For example: Total = 206319.38 & Balance Due = 206319.40. This bug fix requires an update to Invoice.rpt and an customized invoice report that you have.

Fixed

10361682 - Getting Duplicate Key Exception During Process Invoice

Fixed error where multiple records per invoice could get into BDInvoiceSupport.

Fixed

10377639 - Ca$h Throws Error Finalizing a Sale

The BirdDog point-of-sale software was not properly reading a printer-related setting when finalizing a sales order.

Fixed

10378619 - Credit Card Orders Not Writing Correctly to oecshfil_sql.trx_type

Credit Card orders were writing to oecshfil_sql.trx_type as 'X' instead of 'C' like they should which was causing problems in Macola as the order needs to come in as Type = Bank Statement otherwise you only get a total with no details to be able to reconcile.

Fixed

10402199 - Invalid user_name broken rule when importing GL Trx

When using a non-admin User in Enterprise for Windows, this error was being thrown when attempting to import G/L Transactions. Admin users worked fine and this did not always happen on every database.

Fixed

10402858 - Work Orders Filter "Only Lines w/ Qty Remaining" Doesn't Work

The search filter "Only Lines with Qty Remaining" for Manufacturing>Work Orders did not work. You could set it to "TRUE" and still get work orders with Qty Remaining = 0.

Fixed

10419555 - Adding New Customer Type Not Using Default GL Accounts

When you add a new customer type, the "G/L Accounts" tab is not loading the default account info from the proper table.

Better

10420292 - Commit Sales Tax Not Reporting How Many Invoices Errored Out

When running Commit Sales Tax, the software did not tell you how many invoices failed to report to Avalara correctly.

Fixed

10420608 - Checkout Not Defaulting to Correct Ship Via on First Pass

When you went to the Checkout page, the system should default to the first Ship Via that rates correctly but did not in previous versions. However, if you went to the checkout page and then back to the cart and then back to the checkout page, it defaulted correctly.

Fixed

10451447 - Website Causing Application Pool to Crash

9.8.6 builds of the website were, in certain specific scenarios, causing the application pool in IIS to crash.

Fixed

10462789 - Invoice Report Not Calculating Balance Due Correctly

When using Enterprise for Windows>Transactions>Invoicing>Process Invoices, the Balance Due on the Invoice Report was being calculated incorrectly.

Fixed

10465618 - Enterprise for Windows - Maintain > Items > Main Setup Disabled

In Maintain>Items..., the Main Setup tab showed as "disabled" and would not allow editing of info on that page.

Fixed

10466801 - Error When Going to Connector Accounts in EntWin With ES Database

One of our wires was crossed and as a result, Enterprise for Windows stated that the engine was not supported when attempting to access the Connector Accounts using a Macola ES database.

Fixed

10483576 - Get Error Running Invoice Batch

Error due to customer specific data fixed.

Fixed

10548510 - Credit Card Page in Account Section Not Displaying Header

Fixed the page.

Fixed

10583115 - Errors When Accessing 'Maintain | Items' in Enterprise for Windows

Navigating to this menu item was erroring out the program.

Fixed

10641935 - Enterprise for Windows: Error When Selecting Orders or Processing Invoices

These processes were erroring out in previous builds.

Fixed

10642509 - Old Credit Card Reports Need to be Removed

Obsolete reports have been removed.

Fixed

10709213 - Enterprise for Windows: Freight Pay Code Dialog Broken

Making a change to an existing code located at Maintain | Freight | Pay Codes was causing the program to error out.

Fixed

10816044 - Item Field Order Rule Trigger Not Working

This rule trigger was not working correctly.

Bug Fixes: Version 9.8.7.636 - Released 6 November 2018

This build has the following bug fixes implemented:

Industries