You can clear and close open entries in the journals based on the imported data:
If the journal is not yet open, select NCP Payments > Import or on the Business Central home page: Tasks > Payments Import. Select the desired import line and click on Open Journals.
Navigate > Electronic Payments > Payments Import > Import Suggest Application – All Lines, to create an automatic suggested application for all lines.
Navigate > Electronic Payments > Payments Import > 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.
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:
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.
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.
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.
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.
Click on the button Navigate > Electronic Payments > Payments Import > Import Deviation - Set Filter to display only those rows that have not yet been fully applied or that are in the field Account No. No G/L Account
You can delete a line at any time if it has not yet been posted.