Newest KB Articles in General

No Pennies? No Problem!

Tue, 06 Jan 2026 21:49:01 GMT

With the United States no longer minting new pennies, many retailers are having trouble obtaining sufficient pennies to provide change and are rounding cash transactions to the nearest available denomination (typically $0.05). To support this change, Atrex includes a Cash Rounding feature that ensures cash-only transactions are handled accurately and consistently.

How to Enable Cash Rounding

From the main window, select "Options - Company Information / Customization - Company Information and Settings".
Select the Defaults tab.
Locate the Round Cash option.
Set the drop-down value to Rounded and then choose the rounding increment you want to apply (for example, $0.05).
Click the OK button to save your changes.

Once enabled, the setting takes effect immediately for new cash transactions.

When Cash Rounding Applies

Cash rounding is only applied when all of the following are true:

Cash rounding is enabled in Company Settings
The transaction is paid entirely in cash
The transaction total includes a value that requires rounding based on your selected increment

Applies to Atrex 14+

Move Single User Atrex to new System

Fri, 26 Apr 2024 21:00:53 GMT

The following instructions will allow you to move your single user Atrex installation to a new system.

1. From your old system, open Atrex and select "Options - Backup / Restore - Backup" from the main Atrex menu. Save the backup to a USB drive.

2. Download and install Atrex on the new system. You can download the current version of Atrex from the downloads page of the Millennium Software web site. If you are running an older version of Atrex, you can download that from the Client Center.

3. Start Atrex on the new system and then enter your registration information. You can retrieve your registration information from the Client Center.

6. From the new system, select "Options - Backup/Restore - Restore" from the main menu. Restore from the backup that is on the USB drive.

Application Specific Password for Outlook 365

Tue, 07 Jun 2022 20:18:52 GMT

Microsoft Outlook 365 has recently started requiring applications such as Atrex, to use application specific passwords.

Instructions for creating application specific passwords for Outlook 365 are available from Microsoft at https://support.microsoft.com/en-us/account-billing/manage-app-passwords-for-two-step-verification-d6dc8c6d-4bf7-4851-ad95-6d07799387e9

Once you have generated the Application specific password, you can use that password inside of Atrex.

Windows 11 Compatibility

Wed, 10 Nov 2021 16:37:16 GMT

Please note that as Microsoft makes updates and security changes to Windows, these compatibility statements may change depending on the effects of the Windows updates.

Atrex 20, 21, 22, 23

Atrex version 20 through 23 are fully compatible with Windows 11.

Atrex 16, 17, 18, 19

Atrex 16, 17, 18, and 19 have NOT been tested on Windows 11, and cursory testing of Atrex 19 indicates general functional compatibility with Windows 11. However, there is a known issue with these versions of Atrex randomly closing when run under Windows 11 and it is strongly suggested that you upgrade to the current Atrex version.

Please note that any incompatibilities between these versions of Atrex and Windows 11, will be corrected in the current version of Atrex.

Atrex 15 and Older

Older versions of Atrex, 15 and earlier, are incompatible with Windows 11 and are NOT supported on that platform even when run in compatibility mode.

Application Specific Password for Gmail

Mon, 15 Jul 2019 17:18:10 GMT

Google has recently started requiring applications such as Atrex, to use application specific passwords. In addition to providing improved security, application passwords don't change when the Gmail password is changed.

The following are basic instructions on how to create an application specific password in Gmail.

In the browser of your choice, log into the Gmail account that you want to send email through from Atrex.
Click on the photo, name or letter icon in the upper right corner of your Gmail inbox.
Select "Manage your Google Account".
Click on the "Security" link on the left side panel.
Scroll down to the section titled "How you sign in to Google".
If 2-Step Verification is not enabled, click on the right arrow to begin the 2-Step Verification setup.
Once 2-Step Verification is enabled, return to the account security page.
At the top of the security page, search for "App Passwords" in the field that says "Search Google Account". Click on the result that matches "App Passwords" in the security section.
When the "App Passwords" page is displayed, click on the "Select App" drop down, and select "Other"
Type in "Atrex" and then click the "Generate" button.
Copy the generated password in yellow to the clipboard.

Once this password is generated and copied into the clipboard, paste the new password into the email setup for the user you are trying to configure or the Atrex company information email settings.

Is it time for a SSD drive

Mon, 11 Jan 2016 18:36:57 GMT

Reading and writing database information can be slow, especially if you have a large database and/or multiple users hitting the data at the same time. It's rare that the information that you want to retrieve from a database is stored sequentially. As a result, the hard drive has to go find the information that you requested.

Rotational drives (HDD) have to physically move the heads to different positions over the drive surface in order to access the data, and they also have to wait for the desired information to rotate around underneath the heads. The time required to retrieve any specific piece of information from a modern rotational drive is about 10ms. While a hundredth of a second doesn't sound like much, it adds up very quickly when you have to do thousands of reads and writes from different places on the drive.

SSDs don't have any physically moving parts, so it doesn't have to wait for the heads to move or the data to rotate under the heads. While the access time varies between SSD manufacturers, a 0.1ms average access time or better is quite common with newer SSD drives.

Now for a little math. If your operation requires 100,000 read/write operations throughout the average day, that comes out to about 16 minutes of time waiting for the data to be accessed on a HDD with a 10ms average access time. Those same operations on a SSD with a 0.1ms average access time is less than a minute. 15 minutes of wasted time every day is not insignificant.

Is it time for a SSD? The answer to this is a bit subjective, but it's not a difficult question to answer. If you have a rotational HDD and the data access is sluggish enough that it is affecting the efficiency of your operation, then moving to a SSD can save you significant time and money. Back to the math. If you lose 15 minutes of productivity a day from the wait time of your HDD and your average hourly wage for your employees is $15, your HDD is costing you $3.75 a day in employee time. With the cost of 500GB SSD drives being under $100, it doesn't take much in time savings to more than pay for the upgrade.

Keep in mind that access time is only one portion of the time it takes to read and write data from the database, so your mileage may vary depending on your environment. But it's pretty clear that a SSD drive can make a significant difference in performance with a minimal investment in some new hardware.

Windows 10 Compatibility

Thu, 30 Jul 2015 20:45:55 GMT

Please note that as Microsoft makes updates and security changes to Windows, these compatibility statements may change depending on the effects of the Windows updates.

Atrex 16, 17, 18, 19, 20, 21, 22, 23

Atrex versions 16 through 23 were fully compatible with Windows 10 at the time they were developed.

As Windows 10 updates are released, it is possible that the older versions of Atrex in this series may experience compatibility issues with the newer operating system changes. If you are running Atrex 21 or older and experience issues running Atrex after a Windows update, it is strongly suggested that you upgrade to the current version.

It is expected that users processing credit cards with Atrex 16 or newer using the Atrex 14 FDMS or Paymentech plug-ins will experience the same issues with cards being approved but not captured. As the FDMS and Paymentech plug-ins are not EMV or PCI compliant, it is strongly recommend that customers processing on these platforms move to Worldpay Integrated Payments to take advantage of the EMV capabilities of Atrex 20 as well as the VIP solution being out of scope with regards to PCI compliance.

Atrex 15

Atrex 15 is incompatible with Windows 10, particularly 1806 and newer, and is NOT supported on that platform even when run in compatibility mode.

Errors include an access violation in GDI32.DLL when using any of the code based areas of the report designer, access violations on startup which prevented Atrex from being used at all, the inability to create PDFs from within Atrex (which also prevents printing and sending emails with PDF attachments), windows randomly reporting that the Atrex program has been damaged, and the error message "Internal Version Mismatch" being displayed in multiple areas of the program. While the program continues to run, some internal processing is not being completed which may result in unexpected results, data corruption, or data loss.

It is expected that users processing credit cards with Atrex 15 using the Atrex 14 FDMS or Paymentech plug-ins will experience the same issues with cards being approved but not captured. As the FDMS and Paymentech plug-ins are not EMV or PCI compliant, it is strongly recommend that customers processing on these platforms upgrade to the current version of Atrex and move to Worldpay Integrated Payments to take advantage of the EMV capabilities in Atrex 20 as well as the VIP solution being out of scope with regards to PCI compliance.

Atrex 14

Atrex 14 is incompatible with Windows 10 and is NOT supported on that platform even when run in compatibility mode. While Atrex 14 may install and run on Windows 10, we have received a variety of reports of issues, especially after installing the Windows 10 anniversary edition. These issues include failure to start, random access violations, an access violation in GDI32.DLL when using any of the code based areas of the report designer, and issues saving PDF files and emailing from within Atrex 14.

In addition, some users are reporting problems processing credit cards using the Atrex 14 FDMS and Paymentech. After upgrading to Windows 10, process requests are being returned as being approved, but they are not actually captured resulting in the funds not being deposited into the merchant bank account.

Given the severity of the issues, Millennium Software will not support Atrex 14 running on Windows 10.

Atrex 13 and Older

Older versions of Atrex, 13 and earlier, are incompatible with Windows 10 and are NOT supported on that platform even when run in compatibility mode.

FedEx Integration

Tue, 10 Feb 2015 19:22:55 GMT

Simple integration into the FedEx shipping software can be accomplished using the Atrex ODBC driver and a custom view.

Creating the View:

Select "Options - Customization/Company Setup - User Defined Fields and Sizes" from the main Atrex menu, then read and accept the warning about changing field sizes.
Click on the "User Defined Views" tab and click the "+" button on the navigation control to create a new view.
Enter U_FedEx in the View Name field.

Enter the following in the Definition field:
For Atrex 20:

select t.number, t.transdate, t.custnum, t.shipvia, t.custpo, t.shipping,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipcompany else c.company) as fe_company,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipname else LTrim(coalesce(c.firstname, '') + ' ' + c.lastname)) as fe_shipname,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipadd else c.add1) as fe_shipadd,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipadd2 else c.add2) as fe_shipadd2,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipcity else c.city) as fe_shipcity,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipstate else c.state) fe_shipstate,
if ((length(t.shipname) + length(t.shipcompany) > 0) then t.shipzip else c.zip) fe_shipzip
from invoice t
join cust c on t.custnum = c.custnum

For Atrex 13 through 19:

select t.number, t.transdate, t.custnum, t.shipvia, t.custpo, t.shipping, 
if (t.shipname is not null then t.shipname else LTrim(coalesce(c.firstname, '') + ' ' + c.lastname)) as fe_shipname,
if (t.shipname is not null then t.shipadd else c.add1) as fe_shipadd,
if (t.shipname is not null then t.shipadd2 else c.add2) as fe_shipadd2,
if (t.shipname is not null then t.shipcity else c.city) as fe_shipcity,
if (t.shipname is not null then t.shipstate else c.state) fe_shipstate,
if (t.shipname is not null then t.shipzip else c.zip) fe_shipzip
from invoice t join cust c on t.custnum = c.custnum

You can leave the description field blank, or enter something like "Atrex/FedEx Shipping Information View".
Click the Check (post) button on the navigation control to save the View.
Click OK to save the changes.
Run the "Options - Batch Processing" function with exclusive access to the database to create the view.

Configuring the ODBC Driver:

Instructions on how to configure the Atrex ODBC driver are available at http://support.1000years.com/KB/a4/configure-the-atrexelevatedb-odbc-driver.aspx .

Once the View and the ODBC driver are configured, your FedEx technician can access the data using the ODBC DSN entry. To retrieve information about a specific invoice and retrieve it into the FedEx shipping software, use the following query, replacing <number> with the number of the invoice that you want to retrieve:

select * from U_FedEx where number = <number>

To update the invoice record with the tracking number, use the following query, replacing <number> with the number of the invoice that you want to update and <TrackingNumber> with the FedEx tracking number:

update invoice set tracknum = '<TrackingNumber>' where number = <number>

Atrex is no longer prompting for item quantities

Mon, 09 Feb 2015 22:14:32 GMT

This can occur when someone has turned on the increment scan function in Atrex, which causes Atrex to no longer prompt for item quantity. To turn this off, do the following:

Start a sales transaction such as an invoice, order, or quote.
Click cancel at the "Stock Code Entry" window.
Right click on the white item grid.
On the popup menu, click on "Increment Scan" to uncheck the option.
Click Cancel and cancel out of the invoice.

Unexpected reorder quantities or items not appearing on reorder report

Fri, 21 Nov 2014 15:32:41 GMT

Inventory items appear on the reorder report based upon a simple set of rules.

The available quantity for the item, adjusted to take into consideration quantities already on order, must be less than the specified minimum quantity for the item. The calculation for this is (OnHand - Allocated + OnOrder - OnRma) < Minimum').
The item must not be a container.
The item must not be Non-Depleting.
The item must not be Discontinued.

If any of the above conditions are not met, the item will not be included on the inventory reorder report.

If you suspect that an item should be on the inventory reorder report, but is not, here are steps to determine why the item is not on the reorder report

Run the batch processing with the validation options selected and then re-run the inventory reorder report. Information about the calculated values being out of sync is available at http://support.1000years.com/kb/a26/incorrect-unexpected-allocated-on-order-rma-quantities_.aspx
Edit the inventory item and verify that the item is not a container, and that the Non-Depleting and Discontinued flags are not checked.
Open the stock code selection window and highlight the item in question. The bottom section of the window will contain the Available quantity (OnHand - Allocated - OnRma) and the On-Order quantity. Add the Available and On-Order quantities together to get your adjusted available quantity. That should be less than the minimum quantity specified on the stock code information window.

If you have verified all of the items above and are still not seeing items that you expect on the inventory reorder report, please contact our support department.