Account Mapping Window

Specifies maps between text in payment descriptions and the debit or credit account that you want the payment to be applied to when you use the Apply Automatically function in the General Journal window.

On general journal lines where the payment has been applied automatically with an open document, the Account Type and Account No. fields are filled, and the Applied check box is selected. For more information, see the “To automatically apply payments with open invoices or credit memos” section in How to: Match Payments with Open Invoices or Credit Memos.

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. For more information, see the “To map payment text to accounts and then apply payments to new records” section in How to: Match Payments with Open Invoices or Credit Memos.

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. For more information, see Account Mapping Examples.

The following table describes the fields in the Account Mapping window that affect general journal lines.

Field	Description	Effect on journal line
Bal. Source Type	Specifies if the mapped payment is to be applied to a vendor or to a customer.	A general journal line is created for a new invoice or credit memo record that is applied to the payment. If you select Vendor, depending on the sign of the payment amount, either a vendor invoice record or a vendor credit memo record is created. If you select Customer, depending on the sign of the payment amount, either a customer invoice record or a customer credit memo record is created. For more information, see “Example 1” in Account Mapping Examples. Note If you leave this field blank, then no new invoice or credit memo record is created that you can apply the payment to. Instead, the general ledger account specified in the Debit Acc. No and the Credit Acc. No. fields is inserted in the Account No. field on the general journal line, and the value in the Account Type field is filled with G/L Account. For more information, see “Example 2” in Account Mapping Examples.
Bal. Source No.	Specifies which vendor or customer the mapped payment is to be applied to.	The new invoice or credit memo record on the general journal line is created for the vendor or customer number that you specify in this field. Note If you leave this field blank, then no new invoice or credit memo record is created that you can apply the payment to. Instead, the general ledger account specified in the Debit Acc. No and the Credit Acc. No. fields is inserted in the Account No. field on the general journal line, and the value in the Account Type field is filled with G/L Account. For more information, see “Example 2” in Account Mapping Examples.
Debit Acc. No	Specifies the debit account in the general ledger that the mapped payment is to be posted to.	The Account Type and Account No. fields are filled with the information that is used to create the matching debit record that the payment can be applied to. Note If you leave this field blank, then no debit payments are processed when you use the Apply Automatically function in the General Journal window.
Credit Acc. No.	Specifies the credit account in the general ledger that the mapped payment is to be posted to.	The Account Type and Account No. fields are filled with the information that is used to create the matching credit record that the payment can be applied to. Note If you leave this field blank, then no credit payments are processed when you use the Apply Automatically function in the General Journal window.

Tip

For more information on how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For assistance in finding specific pages, see Search.

See Also

Reference

Account Mapping
General Journal
Bal. Source No.
Bal. Source No.
Debit Acc. No
Credit Acc. No.

Other Resources

How to: Match Payments with Open Invoices or Credit Memos
PwC - E-Bank, Payment Matching, KPI, Payroll, Incoming Documents