Previously, credit unions used Code 38 for “Return to Maker”, but this code is no longer available in the system. This change was initiated by a Reg CC change in 2018. Now, if you are presented with a situation where you need to return a check to another institution, it is recommended that you use one of these codes to clarify the reason for the check return. Some codes allow you to make the change in CU*BASE. Others require that you contact your Check Item Processor. Read below for   More...

Using CU*BASE to Comply with New Rules for Tracking Beneficial Ownership FinCEN has issued new rules under the Bank Secrecy Act that require financial institutions to identify and verify the identity of the beneficial owners of all legal entity members (corporations, etc.). Under the final rule, credit unions are required to have written procedures to identify and verify beneficial owners of legal entity members who open new accounts on or after May 11, 2018. In addition to identifying and coll  More...

After accessing your query in Report Builder (Tool #100), select the option to Choose Files and select to add the DATELOOKUP table. To join this file, select 1 or 2 (matched records or matched with primary) and join by the compatible date fields. As an example, if your original file's date field is OPENDT and the format is MMDDYY layout, you would then match the OPENDT field with the matching field format in the DATELOOKUP table, DTMMDDYY. Once the DATELOOKUP table is linked in, you need  More...

Yes. The CU*BASE Budget tool is designed to set the base budget by using the historical record-keeping features of its General Ledger. Through the comparison of historical budgets and actual financial activity, CU*BASE can project a detailed budget in a single pass. Once your Budget is created, you can then use the Finanical Report Configuration to bring in your budget totals to perform your analysis.

You can easily convert columns in Excel so that they can be formatted as dates by using the Text to Columns wizard. While in your Excel table, follow these steps: First, use the column header to select the entire column with data to convert In the menu ribbon, select the Data tab Within the Data Tools section, click the Text to Columns button Follow these steps within the resulting wizard pop up Step 1 – no changes Step 2 – no changes Step 3 – Select Date and then if needed   More...

There is not currently a way to export a canned Query directly into an Excel file. If you want to export data from a canned Query, you'll need to create a similar custom Query via Tool #100 CU*BASE Report Builder (Query) . Once you have the Query built, then you can export the resulting database file. (See the related link below for instructions on downloading files.) Keep in mind that download authority is still required in order to export any data from the QUERYxx library.

The previous tools used for uploading and downloading to and from CU*BASE will be retired when your credit union recieves the 20.07 CU*BASE software release. For online and Site-Four credit unions, that date is Sunday, July 12. Self-processing credit unions will receive the release the following Sunday, July 19. To replace the two tools, a new tool was introduced in November 2018, Tool #1375 Data Transfers (Upload or Download) . Following the release, this tool will be the default data transfer  More...

If the Data Transfer Tool (Tool #1375) is not allowing entry of prod.cuanswers.com, contact your System Administrator to perform one of the following options to update the system config. Option #1 Run this command in CMD as Admin: C:\Users\Public\IBM\ClientSolutions\Start_Programs\Windows_i386-32\acslaunch_win-32.exe /PLUGIN=cfg /SYSTEM=prod.cuanswers.com /userid=*SHARE /ssl=1 Option #2 Manually create the system config by launching the acslaunch_win-32.exe file, navigating to “System Co  More...

This is happening because your financial report configuration was set up with a line of asterisks (************) as visual separators. These characters actually having meaning to the programming and that causes it to mess up when exporting the data. Simply remove those and things should line up fine next time you export.

This can happen when using the Browse button if the File name field is blank, like this: This error message appears: To prevent this error, before clicking the Browse button, enter QUERYxx/ (where xx is your CUID) into the File name field. This tells the system where to look for your files (and more importantly, gives it a location from which you are authorized to download):

A third-party utility is needed to generate robust PDF output. If you are having issues with PDF generation, it is possible that this is missing or corrupt on your PC. Or it may mean that you have not yet installed the software on your PC. See below for directions on what to do if you need to purchase a license of this software (iText Sharp) or how to install it once you have purchased a license. IMPORTANT NOTE REGARDING LICENSING (Updated January 28th, 2014): CU*Answers has purchased a blo  More...

Here are a couple of ways: Via the Tool Usage Analysis Dashboard: Launch Tool #1195 Tool Usage Analysis Dashboard Scroll down or search for the desired tool # Select it in the list and choose Show Assigned Employees The popup window will show which of those employees used it in the past month OR Via the Security Audit File canned Query: Launch Tool #162 Audit Insider/Employee Activity (SECAUD) Enter the following selection criteria (substitute the tool # you want for the 297 in the sample),   More...

There isn't a tool for this, but what you can do to generate a list of all tools available for your credit union is create a template or temporary employee ID in T ool #327 CU*BASE Employee Security and assign it every tool. Then you can use Tool #357 Employee Security Audit Report to un the Employee Security Audit Report. Run it for the assigned tools only and it will print a report listing all the tools assigned to that employee, which in that case would be all the tools. To get this int  More...

There are two methods used to track delinquent loans for reporting purposes in CU*BASE: Method One (for Collections tracking) We have always tracked delinquency in two separate fields for “Months” and ‘Days” in the member files. When a loan is 30 days delinquent, it shows as “0 Months, 30 Days” delinquent. When a loan is 31 days delinquent, it is “1 Month, 0 Days” delinquent. A month is always considered 30 days regardless of the actual number o  More...

The only way to retrieve the information is to use Query. The table name is HBMASTER in your FILExx library. The deleted record remains in this table, but will have a status of X .

Access this screen by selecting Organize Favorites from the Preferences window, or from any Tool Information window. To create a new group of favorite tools: Under the Favorite tools group to modify drop down, select (Create New Group) The Create new favorites group screen will appear; name the favorites group and enter a description. Use Save Changes (F12) to continue. When the Organize My Favorites screen reappears, select tools from the left side of the screen and use the Add > button  More...

This tool is a custom tool that would need to be requested by the Client Services and Education Team. Yes, although for obvious reasons it is a special tool that should be carefully controlled and used only by authorized users in special situations. The most common use is immediately after a data conversion, where new clients just moving to the CU*BASE platform need to perform some routine cleanup of truncated names or stray special characters on street addresses on the data that was converted   More...

Do not use these instructions if you are performing one of the standard uploads such as to DMPIMPORT, FCBUSINESS, FCPERSON, IMPEMAIL, etc. Instead, look for your appropriate .FDFX companion file in C:\cubase\cubase\resources Instructions below are relevant for projects where you are working to upload data to a custom table destination that meets the following criteria: The table already exists in CU*BASE The table has been used before (has at least 1 row of data in it). For the purpose of the ex  More...

This information can be accessed by querying the SMNOTEDT file in Tool #100: CU*BASE Report Builder (Query) . More information about query can be found at our Online Help and OnDemand resources. Additionally, we offer both custom query creation and training at our Online Store .

If you observe drastically reduced download speeds (such as anything over 5 minutes), it is most commonly due to issues translating the date fields between the CU*BASE file and the PC file. The Data Transfer tool will still complete the download, however, there are steps you can take to speed things along. To troubleshoot this issue, access Tool #1375 File Transfers (Upload or Download) , navigate to the From IBM i -2 tab and select the Format Options button in the File section. On the pop-u  More...

This comes from the Workstation Device Configuration in CU*BASE. To view or change this: Launch Tool #326 CU Hardware Configuration Select Terminal/Workstation In the list of workstations, locate the ID of the workstation you are looking up and double click on it (or just type the ID and press Enter) This will open up the terminal's configuration in CU*BASE. In the middle is the list of default printers where your documents will print: General Printer - this will be the printer to which a  More...

No, our CSRs will not reset the 2-character CU*BASE Employee IDs for your staff. This must be done by an internal CU security officer. Use Tool #762 Reset Employee ID Password . (This can also be done via Tool #327 CU*BASE Employee Security using the Reset PW option.) It is important that credit unions insure proper training to their employees regarding the expiration of their CU*BASE Employee ID password. We deliver a warning message of expiration 7 business days prior to the staff member.   More...

When a credit union statuses a member's card as 'HOT' or warm (Lost/Stolen/Fraud/Restricted), this information is transmitted immediately to your vendor to stop any further withdrawals/purchases being performed with that particular card. But at your vendor a 'Hot Card' is not considered to be a closed card. When your member's card remains at a HOT or Warm card status on CU*BASE, CU*BASE is still required to send any maintenance updates such as address change, phone numbe  More...

IMPORTANT NOTE: When It’s Me 247 was updated in 2021, the “See” option shown on here was made unavailable. There are two major points to consider when thinking about allowing members to see information beyond the account to which they are actually logged in. Both extend beyond online banking to consider a financial institution’s role and responsibility in protecting member private data via all access channels, from the teller line to a back office employee answering   More...

If you need to allow an employee to perform upload and/or download tasks (FinCEN, AIRES, ALM, uploading G/L entries to post, etc.), you must first complete the iShield Security Access Request form and have it signed by your credit union’s designated Security Officer to sign. Once our Client Services team receives your signed form and verifies it, a request will be submitted to our System i administrators, and you will be notified when the new permissions have been granted. This process wi  More...