Example - Automatic Payment Application Based on Account Mapping

After you have entered or imported payment lines in the General Journal window, you can use the Apply Automatically function to apply each payment to its related open invoice or credit memo before you post the general journal lines. For more information, see How to: Automatically Apply Payments with Open Documents.

To handle the payments that could not be applied automatically, you can set up maps between text and accounts in the Account Mapping window that map payments with debit or credit accounts and a balancing account according to text found in the Description field on the general journal line.

The way general journal lines for payments are created or modified based on text-account maps depends on how you fill the fields in the Account Mapping window.

Example 1 – Balance Source Fields Are Set Up

The following example shows how new invoice and credit memo records are created for non-applied payments in the General Journal window based on the following text-account maps.

Mapping Text Bal. Source Type Bal. Source No. Debit Acc. No Credit Acc. No.

Fuel

Customer

(Shell)

Customer Refunds

Customer Receivables

The following general journal lines are edited or created.

Change Event Document Type Account Type Account No. Description Amount Bal. Account Type

Edited

Payment

Filled: Customer

Filled: (Shell)

Fuel

-100

Bank

Inserted

Invoice

Customer

(Shell)

Fuel

100

G/L Account

(Customer Receivables)

Edited

Refund

Filled: Customer

Filled: (Shell)

Fuel refund

100

Bank

Inserted

Credit Memo

Customer

(Shell)

Fuel refund

-100

G/L Account

(Customer Refunds)

Example 2 – Balance Source Fields Are Not Set Up

The following example shows how existing non-applied payments in the General Journal window are edited based on the following text-account maps.

Mapping Text Bal. Source Type Bal. Source No. Debit Acc. No Credit Acc. No.

Fuel

Customer Refunds

Customer Receivables

The existing general journal line is edited as follows.

Change Event Document Type Account Type Account No. Description Amount Bal. Account Type

Edited

Payment

Filled: G/L Account

Filled: Customer Receivables

Fuel

-100

Bank

Because the Bal. Source Type field in the Account Mapping window was not filled, then no new general journal line is created. The Account Type field is filled with G/L Account, and the Account No. field is filled with a relevant account number.

See Also

Tasks

How to: Automatically Apply Payments with Open Documents
How to: Import Bank Statements
How to: Export Payments to a Bank File

Other Resources

Account Mapping