Using iMIS AR Importer
To implement the AR Importer:
- Make sure you are licensed for AR Importer.
- Format AR data for import.
- Perform the import.
- Verify the import.
To enable the iMIS AR Importer module
As with all iMIS modules, you must have this system enabled on the iMIS System Setup level. If necessary, open the System Setup window (select File > System Setup) and edit your iMIS licensing to enable the iMIS AR Importer.
To format AR data for import
The transaction format is tab- or comma-delimited input, with various types of records allowed in a single stream. The import file must contain a single batch header record, followed by any number of cash payment records. There should not be any empty lines between record entries.
Note: You can use the AR Importer for accrual dues billing.
The major transaction formats include the following:
All records
|
# |
Field Name |
Data |
Comments |
|---|---|---|---|
|
1 |
Record Type |
|
Identifies the type of record |
|
2 |
Batch Number |
10 chars, all upper case |
|
Batch header
|
# |
Field Name |
Data |
Comments |
|---|---|---|---|
|
1 |
Record Type |
BH |
Always "BH" |
|
2 |
Batch Number |
10 chars, all upper case |
|
|
3 |
Batch Date |
Date |
Date of batch (mm/dd/yy) |
|
4 |
Batch Description |
60 chars |
|
|
5 |
Control Count |
Numeric |
Optional |
|
6 |
Control Amount |
Monetary |
Total of the batch of payments |
|
7 |
Cash Account Code |
10 chars, all upper case |
Code assigned through the Set up cash accounts window. Indicates the cash account into which the funds were deposited. |
Cash payment record
|
# |
Field Name |
Data |
Comments |
|---|---|---|---|
|
1 |
Record Type |
PAY |
Always "PAY" |
|
2 |
Batch Number |
10 chars, all upper case |
Optional. If blank, defaults to batch header's batch number. |
|
3 |
System |
AR |
|
|
4 |
Customer ID |
10 chars, customer ID |
Can substitute with Major Key, if prefixed with * (asterisk) |
|
5 |
Date |
Date |
Optional. If blank, defaults to batch header date. |
|
6 |
Invoice |
Alphanumeric |
The invoice number. If you need to enter a payment towards an invoice and the Auto Apply option is not enabled in the AR/Cash Set up module window, this option is required. If you need to import a prepayment, this option is not required, even if the Auto Apply option is not enabled. |
|
7 |
Amount |
Individual payment amount |
Total amount of the check or credit card payment. Do not enter a $ (dollar sign). |
|
8 |
Check/CCType |
Check number or credit card type |
Optional |
|
9 |
CCNumber |
Credit card number |
Optional |
|
10 |
CCExp |
Credit card expiration date |
Optional |
|
11 |
Name on CC |
Name on credit card |
Optional |
|
12 |
CCAuthorize |
Credit card authorization code |
Optional |
|
13 |
Name |
60 chars for audit trail |
Optional but important. This value is printed on the transaction report to identify the customer. |
|
14 |
Comment |
255 chars |
Optional but important. This value is printed on the transaction report and related inquiries to explain the transaction, such as "Dues Payment" or "Subscription Payment". |
More:
Example AR Import File