This occurs when the release includes changes to the files that your Query uses. For example, if we add a new field to the MASTER file, any Query you have that uses that file will display an error message. Fortunately, it is very easy to refresh your Query so that you can use it again. All you need to do is access the Query and save it. That's all. You don't have to make changes to it, it's just important that you save it so it can refresh itself to match the new file layout.   More...

These files should automatically be placed into the correct spots to ensure that Iaccess continues to work without any problems. If you want to verify that you have received this file you can follow these few steps: Open My computer Navigate to c:\users\public\documents\ibm\client access\ Verify the current file size of “cwbssldf.kdb” If this file size is 30kb then everything worked correctly and you don’t have to do anything else. If this file size is different follow steps   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 CBX The table has been used before (has at least 1 row of data in it). For the purpose of the exampl  More...

When you use the filter buttons on the File Maintenance Inquiry dashboard (Tool #159: Audit File Maintenance Inquiry (CUFMNT)), indicators note which programs, fields/columns, and files/tables AuditLink has flagged as “critical” for auditing teams to monitor on a daily basis. You can quickly sort by that indicator and select only those items for a quick scan of maintenance that directly affects member accounts. Below is a listing of these critical items. Columns/Fields Field Why   More...

If you or your member notice an account is not being updated (or the additional signer on a loan) you should first try to find out if the loan/additional signer was included in the file sent over to the bureau. You can do this for the most recent reporting cycle by running Tool #658 Print Loan Info Sent to Credit Bureau . If the member loan/additional signer information (defined by METRO 2 as the J1 segment or J2 Segment) is present in that file you need to look further into the following types  More...

The FRB produces six sets of files each business day on weekdays, Monday through Friday, except for Federal Holidays. CU*Answers posts the files as follows: CU*Answers receives the first and sixth set of files overnight and posts them by 8:30 AM ET. As this posting is a combined posting, two Receive reports and one Posting report are produced. CU*Answers receives the second set of files by noon and posts by 1:00 PM ET. Same-day credits must be posted with this file. CU*Answers receives the thir  More...

The Secondary Names (SECNAMES) file stores instructions that link a membership account to another member or non-member record. The file stores links to joint owner names and beneficiary names for all non-IRA account types. (IRA beneficiaries are stored in a completely different file because they are linked to an IRA Plan Type, not specific individual sub-accounts.) The file also stores a third type referred to as miscellaneous owner which can be used for any purpose you wish. The most co  More...

Use Tool #332 Database Search Assistant. This tool lets you enter part or all of a table (file) name, a column (field) name, or even a portion of a table or column description to help locate where data is stored in your member files.

Beginning with the 17.10 CUBASE Release (October 22, 2017 for online clients), CU*Answers implemented the CUFMAINT table, which includes data from the CUFMNT table, as well as additional data not included in CUFMNT. CU*Answers recommends using the CUFMAINT table for all report building and query activity. If you currently have any Queries using the CUFMNT table, they will still work, as CUFMNT is now a View over the C UFMAINT table but without all of the additional information, so it will s  More...

This is because the print session is not pointing to the correct folder location. It shoudl be pointing to the \..\PrePrint folder for eLoans and other forms, and to the \..\ToPrint folder for eReceipts. Contact a CSO team member for assistance at 800.327.3478 x266.

You can review this authority via Tool #1355 Download/Upload Authorized Users Inquiry . Data from this inquiry is updated at the end of each day. You can also find the monthly report CU*BASE produces on the first of each month, LSECAUDITM, which contains all staff with Upload/Download authority and what files they have access to. You can retrieve this report from CU*Spy.

Access the Bankruptcy topics to learn more https://help.cbxcore.com/steps/Content/Bankruptcy.htm See the Related Q A below.

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...

NMS will need access to Tool #3555 NMS Combine Surf Files . This is custom tool, which means we will need to adjust settings on our end so your credit union has access to the tool. This is normally done as part of a regular CU*BASE release, although special arrangements can be made. Contact a CSR for assistance. Once the tool is activated for you, then your credit union's security officer will be able to grant NMS authority to the tool as usual via CU*BASE Employee Security. Once the user h  More...

See links below, especially Handling Bankruptcy A to Z . Find more bankruptcy directions here: https://help.cbxcore.com/steps/Content/Bankruptcy.htm

Yes. CBX offers an great feature to calculate a membership ownership or patronage dividend that allows for an audit run to evaluate the total amount and accounts that may be excluded. At the time the patronage dividend audit or posting run is processed, there are two files created that reside in the QUERYXX library. The data file for the excluded accounts is PATRDIVEXC. For the accounts that will earn the patronage dividend, the file name is PATRDIVINC. The data in each file represents the last   More...

Yes. The data match file we already send to the State of Wisconsin each quarter will be used now by them for multiple purposes, including tax data, unemployment insurance, etc. Your credit union is still charged the same quarterly fee* for transmitting a single file to the state. (Note: This same technique may also be used by other states that are now requiring unemployment insurance claim data matches. CUs do not need to do anything; the file content is the same and the state is simply using  More...

There are two methods used to track delinquent loans for reporting purposes in CBX: 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 of da  More...

There are three choices. 1. Manually add the estimated finance charges to the balance of the account and have the member make the full payoff at that time. Then clear the cumulative balance on the individual buckets to ensure that there are no finance charges assessed on the account. To do this you will launch Tool #20 Update Account Information . Select the credit card account and then select Chg Type Maint . Select the individual bucket and select the Maintenance action code. In the cumulative  More...

Trust accounts can be set up as either individual or organizational depending on the legal nature of the trust. Following are recommendations for handling situations when a member wants to set up a membership where the primary member and the first joint owner are, in essence, the same person. This happens most often for trust accounts. Currently in CU*BASE there are two ways to handle trusts: For trusts that use a person’s SSN (where you do not have a separate TIN for the trust), set up th  More...

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 CBX. Others require that you contact your Check Item Processor. Read below for deta  More...

The NSF Statistics Dashboard (Tool #557) will track this information for you automatically. It is separated into the NSF category and the Courtesy Pay Category. Credit unions are using this dashboard to help predict averages of NSF/Courtesy Pay fee income and also to track how many members may be using the service. You can click on any of the origins (listed in blue text) and you can drill further to members who had more than X transactions in a specific month. There are a lot of graphical oppor  More...

For things like expanded balance and transaction $ amounts, Query will automatically adapt to larger amounts, and you generally won’t need to do anything. (The only exception is if you send the output to a vendor, they’ll need to be made aware of the larger amounts. Or perhaps if your report is completely full side to side and you need to remove a column in order for everything to still fit across a printed page.) As far as dates, if a date was formerly 3 separate fields for year  More...

No. The way that normal CU*BASE features work is to use the CU*BASE Workstation Configuration settings to determine a default printer for certain functions, or you can choose a printer directly when printing most CU*BASE reports. But since IBM Query is not a CU*BASE program but rather a generic program offered by IBM, it does not have any way of looking at CU*BASE configs for the info it would need to direct the print job. Therefore a Query definition will go to your list of spooled files and  More...

Download the Software Note: Our network requirements have been updated and can be found here . Please verify with your IT vendor that these changes have been put into place before attempting to download Station Control. You can download CBX from this link . Site-Four clients please use this link . Instructions for Manual Install of CBX Station Control Run the downloaded CBX Install Suite Prod CBX1.exe installer. This will require administrative privileges on the workstation. 1. On the CBX In  More...