Share via


How to: Find Unpaid Documents During Manual Payment Reconciliation

The Payment Registration window supports you in tasks needed to balance internal accounts with actual cash figures to ensure effective collection from customers and due payment to vendors. It shows outstanding incoming payments as lines that represent sales documents where an amount is due for payment. For more information, see How to: Reconcile Payments Manually.

Typically, when a payment has been made, recorded in the bank or otherwise, the related sales or purchase document is represented as a line in the Payment Registration window because the document in question is waiting for the payment to be posted against the outstanding amount. However, sometimes a payment that has been made is not represented by a line in the Payment Registration window, typically because the document in question has not been fully invoice posted.

In the Document Search window, you can search among documents that are not fully invoiced. You can search based on one or more of the following criteria:

  • Document number

  • Amount or amount range

The following procedure explains how to find a specific document by using both search criteria.

To find a specific document that is not fully invoiced

  1. In the Search box, enter Payment Registration, and then choose the related link.

  2. With the pointer on any line, on the Home tab, in the Search group, choose Search Documents.

  3. In the Document Search window, enter a search value in the Document No. field.

    Note

    The value that you enter in this field is enclosed in hidden wildcard characters (* *). This means that the function searches for all document numbers that contain the entered value.

  4. In the Amount field, enter the specific amount that exists on the document that you want to find.

  5. In the Amount Tolerance % field, enter a percentage value to define the range of amounts that you want to search to find the open document.

    If you enter 10, then the function will search for amounts in a range between ten percent lower and ten percent higher than the value in the Amount field.

  6. On the Home tab, in the Process group, choose Search.

The search function searches among documents that are not fully invoiced based on the specified criteria.

If one or more documents match the criteria, then the Document Search Result window opens to display lines that represent those documents. Each line contains a document number, description, and amount so that you can easily find a specific document, for example based on information on your bank statement.

If a payment in the bank is not represented by any document in Microsoft Dynamics NAV 2013 R2, then you can open a prefilled general journal from the Payment Registration window to post the payment directly to the balancing account without applying the payment to a document. Alternatively, you may want to record the payment in the journal until the origin of the payment has been resolved. For more information, see How to: Record or Post Payments Manually Without a Related Document.

See Also

Tasks

How to: Reconcile Payments Manually
How to: Set Up Manual Payment Reconciliation
How to: Reconcile Overdue Payments Manually
How to: Reconcile Payments With Discounts Manually

Other Resources

Document Search
Document Search Result
Payment Registration