Skip to main content
Skip table of contents

Billing Payments Tutorial

Difficulty

Intermediate

EMS Compatible

(tick)

iMIS 2017 Compatible

(error)

Usage Notes

Length of Video

n/a

iImport

(tick)

iUpdate

(tick)

Actions

Insert, Insert with Matching

Overview

The billing payments feature of iDMS is very flexible and can be used in a variety of ways. The mapping provided determine how billing payments are entered into iMIS and where payments are applied.

Mapping

Due to the flexible nature of billing payments, there is an additional help screen that can be accessed when mapping.

Location of Help in Mapping Screen

Required Fields

  • Bill to Party ID - iMIS ID of record being invoiced.

  • Amount - Total of payment made.

  • Payment Method ID - Which payment method should be used.

Location of Payment Method IDs
  • Payment Method IDs can be found in iMIS by going to Settings > Finance > Pay Central > Payment methods

Optional Fields

  • Date - The date associated with the payment. If no date is provided, the current date will be used.

  • Check Number - The check number associated with the payment.

  • Invoice Number(s) - If paying specific invoice numbers, map the invoices to pay off here. Additional details below.

  • Invoice Type(s) - If paying by invoice types, map the invoice types here. Payments will be applied in the order you select. Additional details below.

  • Source System(s) - If paying by source system, map the source systems here. Payments will be applied in the order you select. Additional details below.

  • Is Pre-Payment (Credit Only) - Check this box if you want to apply prepayment exclusively. When this option is set, other filtering criteria is ignored (i.e., invoice numbers, invoice types, source systems).

Mapping Notes

Empty Field Functionality

If there is no match on for invoice number, invoice type, and source system, payment will default to paying Dues for the Bill to ID.

Payment Greater than Invoice

When paying invoices, if the amount of payment is greater than the invoice, the payment will be applied as a credit to general AR. 

Different Payment Functionality

Based on the mapping provided, you will see different payment functionality.

Paying by Invoice Number

If paying by specific invoice number, see the sample mapping below on how to pay by invoice number.

Mapping for Paying by Invoice Number Screenshot

Paying by Source System

When you select the source system, you will get a multi-select dropdown containing a list of the source systems. In this field, you specify the source system in the order in which payment should be applied.

Source System Order

Payments are applied in the order you select.

Screenshot of Paying by Source System

Paying By Invoice Type

When you select the invoice type(s), you will get a multi-select dropdown containing a list of invoice types. In this field, you specify the invoice type in the order in which payment should be applied.

Invoice Type Order

Payments are applied in the order you select.  

Paying by Invoice Type

CSI does not recommend paying by invoice type unless you have a very specific purpose. 

Screenshot of Paying by Invoice Type
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.