Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) What are the fields (D...

What are the fields (Date, document no., Amount ..etc..)nav 2016 use auto match bank reconciliat

(0) Share

Report

Posted on by Community Member Microsoft Employee

Dear Experts,

I've one question regarding NAV 2016 bank reconciliation auto matching process.

What are the fields (like posting Date, document no., Amount ..etc..) that NAV 2016 considers to auto match bank reconciliation?. And is there any way to set rule in the system to make it use fields per our choice for auto matching imported bank statements with bank ledger entries?

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Hannes Holst 5,767 on at

Like (0)

Report

RE: What are the fields (Date, document no., Amount ..etc..)nav 2016 use auto match bank reconciliat

Hello,

No, an individual rule is for the Bank Reconciliation not possible. As soon as you export your Payments from NAV, you should have a succesful match rate always.

For details check Codeunit 1252, function "MatchSingle".

The decision for a match is based on a Score.

Following criteria do contribute to a Score:

- Remaining Amount does match statement amount

- Description does match

- Related Party name does match

- Transaction info does match

- Transaction Date matches posting date

in Case the bank statement is out of the posting date range, the match doesn't happen.