EDI Reference

Big Business 11.20 updates Middleware to include return fields for EDI including:
• EDI_Reference
• EDI_Date
• EDI_Time
These allow your system(s) for EDI to post back transaction updates, like showing an invoice was sent via EDI, in exactly the same way Shipping posts back Tracking so any Big Business user can see what they need to confirm and details they might need to follow up.

This soluti


  Sent Checkbox

Big Business 11.20 allows systems for EDI to post back transaction updates, which automatically update the Sent Checkbox. You can view the Sent Checkbox in Invoices Search, to see which have been sent, and on the Shipping tab of the Invoice where shipment information will show details.

This solution provides details. (6889)


  MySQL 5.7

MySQL 5.7.11 fixes compatibility with Mac OS X allowing it to autostart. When Yosemite was released MySQL would not autostart, requiring you to click the start button in System Prefs if the computer was rebooted.

Big Business 10.3 includes a fix for compatibility with MySQL 5.7.8 and higher. Changes to Date formatting in MySQL can block earlier versions of Big Business from making some updates.


  MySQL 5.7 for Windows

MySQL 5.7 updates installers for Windows and some of the syntax for typical changes needed to share data from your Big Buisness Server to shipping workstations running UPS WorldShip, FedEx Ship Manager, and so on.

This Solution provides details. (6655)


  MySQL 8

MySQL 8 simplifies Password setup.

(7105)


  Fix XML

Big Business includes an XML Parser which validates and will throw an error like:
-9935 The XML is not valid or is not well-formed

Fix XML is an option to correct incoming XML with syntax errors like failing to encode Ampersand.

(7159)


  Setting up MySQL on OS X

MySQL is a popular database platform with connectivity options for many programming languages such as PHP, Perl, Python, TCL, C, Java etc. This means you can easily access this data from a variety of applications written in a variety of programming languages.

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more r


  Setting up MySQL on Windows

MySQL is a popular database platform with connectivity options for many programming languages such as PHP, Perl, Python, TCL, C, Java etc. This means you can easily access this data from a variety of applications written in a variety of programming languages.

The Middleware Add-On is an option that allow Big Business Server to synchronize data with an external data source (MySQL) where it can be


  MySQL: Creating a System DSN

This feature is part of the MySQL Add-On, which is an additional module that enables Big Business to synchronize data with MySQL.

This Solution describes Creating a System DSN for to connect, for example, UPS Worldship, to MySQL using ODBC. (6169)


  Middleware Connection Settings

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more readily accessed and copied to another system. This Solution describes its connection settings (6172).


  Items in Middleware

Big Business 8.6 adds the option to include Items in Middleware. This feature makes it easy to provide up to the minute inventory information to your online store, web site, or other systems.

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more readily accessed or copied to another system.

This Solution provid


  Customers in Middleware

Big Business 9.1 adds the option to include Customers in Middleware. This feature makes it easy to provide up to the minute customer information to your online store, web site, or other systems.

Big Business 9.1+ fixes updating and adds Tags for Customers and Contacts.

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it c


  Vendors in Middleware

Big Business 11.12 adds the option to include Vendors, PO's, and Bills in Middleware. This feature makes it easy to provide up to the minute vendor information to your shipping or other systems.

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more readily accessed or copied to another system.

This Solution prov


  Audit in Middleware

Big Business 11.12 adds the option to include Audit entries in Middleware. Audit shows Created and Modified dates for other records.

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more readily accessed or copied to another system.

This Solution provides details for use. (6798)


  Server Only

Big Business Server supports a number of features, such as Warehouses, that are not availalble in the standalone, 1-User version of Big Business.

Big Business 11.12 extends Middleware by making it Server Only.

This Solution provides details. (6799)


  Middleware Delete

Middleware Delete is an essential change. Middleware is not just used to look up Shipping. More and more it is being used to get data to Web Stores, to automate purchasing or billing, and for EDI.

Big Business 11.17 updates Middleware to process Deletes. This change applied to all tables.

This Solution provides details. (6850)


  Middleware Update

Middleware Update checks and updates needed fields in Middleware.

This Solution provides details. (6860)


  Middleware Resize

Big Business 8.7 fixes a problem with Middleware that Sales Orders, Invoice, or Items may not appear in MySQL if they contain newer, longer entries.

This Solution provides details. (6316)


  Removing MySQL on Windows

MySQL is a popular database platform with connectivity options for many programming languages such as PHP, Perl, Python, TCL, C, Java etc. This means you can easily access this data from a variety of applications written in a variety of programming languages.

The Middleware Add-On is an option that allow Big Business Server to synchronize data with an external data source (MySQL) where it can be


  Removing MySQL on Mac OS X

MySQL is a popular database platform with connectivity options for many programming languages such as PHP, Perl, Python, TCL, C, Java etc. This means you can easily access this data from a variety of applications written in a variety of programming languages.

The Middleware Add-On is an option that allow Big Business Server to synchronize data with an external data source (MySQL) where it can be