When setup is successfully completed, three custom fields should have been created within QuickBooks (see below).
However, if the software did not create the three fields needed...
Note: If you have just created your QuickBooks qbw files, exit and restart QuickBooks.
This will ensure that you have set up QuickBooks with an admin password.
To fix/check this, we need to go to QuickBooks
In QuickBooks, navigate to either the Customer, Employee or Vendor Center.
In this example, we'll navigate to the Vendor Center.
The first profile (vendor) will be displayed by default. Simply click on the edit button on the upper right.
On the profile window, click on the Additional Info tab, then 'Define Fields'
To fix manually-created fields:
- Rename the three fields that were created (to Bank Account #-BAD, ABA Routing Number-BAD', and CHK/SAV-BAD).
- In QuickBooks, login as the Admin and be in single-user mode. Then, from the QuickBooks integration >multiple origination tab, re-run the integration wizard. The three fields will be created by ACH Universal.
- Then cut/paste the software-created field name over the manually-named field. Do this for each of the three fields. This way, the properties are retained for integration and you will not lose the data already entered.
- Then, uncheck the fields not needed.
The three field names that should appear exactly as shown are:
- Bank Account Number
- ABA Routing Number
- CHK/SAV
Tip: Don't forget to check the boxes for the profiles you want to display (Customers, Employees, Vendors).
If you do not see ACH Universal's fields, you may not have enough available custom fields.
The maximum number of custom fields in use (checked boxes) for each profile type (Customers, Employees, Vendors) is 7 for Pro and 12 for Enterprise.
To fix: Uncheck fields that you do not need.
Pro and Premiere users:
As there is a 7 field limit, the most check-marks that you can have in a column is 4 (as ACH Universal will need to create 3 in each profile).
Enterprise users:
As there is a 12 field limit, the most check-marks that you can have in a column is 9 (as ACH Universal will need to create 3 in each profile).
Tip: You only need to unmark check-boxes for the profile types (Customers, Employees, Vendors) that you will be using with ACH Universal.
Once you have updated the fields, click OK and close the profile edit window.
In ACH Universal, you can reselect the QuickBooks Integration Window and click 'View Transactions'. You will get the same message as before, but on the following screen you can opt to re-run the Wizard (please do so to complete).
Note:
If you have upgraded, and did not have a CHK/SAV field, you can over-ride this verification:
Select the Settings tab > click 'Import, System' > 'Import' tab > QuickBooks suppress field warning > select 'suppress'.
Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission.