Applying Open Entries

In this topic

• Evaluation Scheme
• See also

1. If the journal is not yet open, select NAVAX Payment > Imports on the Business Central home page or ☰ > NAVAX Payment > Imports if you are not in the Accountant role. Select the desired import line and click on Open Journals.
2. Click on
   • NCP Imports > Import Suggest Application - All Lines, to create an automatic suggested application for all lines.
   • NCP Imports > Import Suggest Application - Line, to create an automatic suggested application for the marked line.
   The system attempts to determine the Account No. and the corresponding open entries based on various criteria.

   Note

   This only applies to those lines for which the Applied indicator is not set
   For lines that contain a value in the field Account No. , this value is used as a filter for the entry search. In the following sequence, the system attempts to determine a Account No. or Clearing Documents for each line:
   1. The system checks whether a Fixed Account Allocation exists for the line. Example In the Fixed Account Allocation, it is defined that G/L account 241203 is used if the Remittance Info contains the word "tax office". The first line contains this account. For more information, see Setup, Fixed Account Allocations.

      Note

      With G/L accounts, the description may not be written in the journal line. This is due to the setting Omit Default desc. in Jnl on the G/L account. The option specifies if the default description is automatically inserted in the Description field on journal lines created for this general ledger account.
   2. If the Remittance Info contains a Document No. of a receivable or External Document No. of a vendor invoice, this Document No. is searched for in the database. The appropriate customer or vendor is determined and the payment is applied. Example:: The Remittance Info of the third line contains a Document No.. Customer and document no. are assigned. The line is applied and automatically receives the indicator Applied.
   3. If the remittance Info contains a customer/vendor number, the system searches the database for a suitable customer/vendor number. Applying with an open entry is not possible because the document number is not known.

      Tip

      In order to still get a suggested application, the option Keep Account Allocation can be activated in the NCP Imports Setup, so that the customer/vendor is suggested for the line, even if no document is found. Example: The Remittance Info of the second line contains a number that is not found in the database. However, a customer with this number could be found. The customer is assigned to the line.
3. Click on the NCP Imports > Import Deviation - Set Filter button to only show lines that have not yet been fully applied or that have no G/L account entered in the Account No. field.
.

Evaluation Scheme

1. A Fixed Account Allocation is found ➟ +2000 points
2. Searches the value of the payment reference from the import in the Payment Reference of the entries ➟ +1000 points
3. Searches the value of the payment reference from the import in Document Numbers or External Document Numbers ➟ +600 points
4. Searches the value of the purpose in the Payment Reference, Document Numbers and External Document Numbers of the entries ➟ +600 points according to the degree of match (Only if it has no payment reference)
5. Searches account number in Customers/Vendors ➟ +100 points
6. Searches external account holder in Customers/Vendors ➟ +100 points
7. Searches payment reference in Customers/Vendors ➟ +300 points according to the degree of match
8. Searches purpose in Customers/Vendors ➟ +300 points according to the degree of match (Only if it has no payment reference)
9. Found Customers/Vendors are blocked ➟ Not considered.
10. Found entry has a future date of the posting ➟ Not considered.
11. Found entry has correct amount ➟ +100 points
12. Found entry has payment tolerance/discount from the amount ➟ +50 points

See also

• Setup, Imports, Fixed Account Allocations