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.