Hi All,
Automatic Bank Reconciliation in NAV 2013 R2 works on
Step 1: Posting Exchange Definition needs to be defined and configured to Import Bank statements.
Below is the screenshot of the same.
1) We need to define the Type whether Import or Export
2) File format whether variable or fixed format, separator, etc
3) Posting Line Definition Tab : We define the no. of colums and do the mapping with Bank Account Ledger Entry fields
4) Posting Column Definition Tab : We define all the fields in bank statement with the format of each field as shown below
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiP4b3tnYJlfCo0ylA-VI2f0nZ9iwJAwMhWQgl2fhBxiJ28JfITaixNrVF3uUMdOiHt58Ln65_bvyQgnwQoe-jKukv5PTAdvnAvev-OMGbXGVla7rNLxvEG2zoRdc8AOmd_O7UHDXv-Tww/s640/Posting+Exchange+Definition.png)
Step 2: Mapping of fields of Posting Line Definition with Posting Column Definition as shown below
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNNhh3yyDxKlELug3LhqqrcAk1cma0j9GpS5zf5TPoE5_Ar3puOkSvmR9Cr0gn4db7pHg8jz5LFRmV7C00qFqY83a0v9mLOsGEhSKX7IbshsdJgfS7TIGZEc0B1mdk89GeeYeGdZYc2Yw/s640/Field+Mapping.png)
Step 3: Add Posting Exchange Definition in Bank Export/Import Setup and then tag the same in Bank Account Master.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVjjAW2IiYwYr-w5dl_LQw71iX4CuDJi0Ll1roCX2hDJybddZoo45UkSUCqXfO5SRNs-p51HaktbG8pfpjUE9UlhhmH8D1Q_CKUK1TyjcN6HYvGIrtOLbnLdfucki9DFnxWMW6-cSRLag/s640/Bank+Mapping.png)
Step 4: Now import the bank statement file in Bank Account Reconciliation window.
You can select the file by clicking Import bank statement marked in Red. The Imported records will reflect on the left hand side and bank account ledger will be on right hand side
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5-ALtD37L2zVyVL-IWGNRrjenI08uHZocKmht7y99zPW-ooPkL8YmtdR5xdO_-yLPO0tcbebZD6d-Ovt7kA2W3ahfWEI8FSx96pSIBbBxuZY942qjT8V5eX9RNOYY0c-ZXApNL2LFIXc/s640/Reconciliation.png)
Step 5 : Auto Reconcile by clicking on Match Automatically marked in Yellow.
Matching is done on some criteria and priority. Please check below link for the same
https://msdn.microsoft.com/en-us/library/dn414563(v=nav.71).aspx
Thanks & Regards,
Nandesh Gowda
Automatic Bank Reconciliation in NAV 2013 R2 works on
- Posting Exchange Definition to Import Bank Statements.
- Auto Reconciliation of Bank Statement with NAV Bank Account Ledger Entry based on some priority and criteria.
Below is the screenshot of the same.
1) We need to define the Type whether Import or Export
2) File format whether variable or fixed format, separator, etc
3) Posting Line Definition Tab : We define the no. of colums and do the mapping with Bank Account Ledger Entry fields
4) Posting Column Definition Tab : We define all the fields in bank statement with the format of each field as shown below
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiP4b3tnYJlfCo0ylA-VI2f0nZ9iwJAwMhWQgl2fhBxiJ28JfITaixNrVF3uUMdOiHt58Ln65_bvyQgnwQoe-jKukv5PTAdvnAvev-OMGbXGVla7rNLxvEG2zoRdc8AOmd_O7UHDXv-Tww/s640/Posting+Exchange+Definition.png)
Step 2: Mapping of fields of Posting Line Definition with Posting Column Definition as shown below
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNNhh3yyDxKlELug3LhqqrcAk1cma0j9GpS5zf5TPoE5_Ar3puOkSvmR9Cr0gn4db7pHg8jz5LFRmV7C00qFqY83a0v9mLOsGEhSKX7IbshsdJgfS7TIGZEc0B1mdk89GeeYeGdZYc2Yw/s640/Field+Mapping.png)
Step 3: Add Posting Exchange Definition in Bank Export/Import Setup and then tag the same in Bank Account Master.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVjjAW2IiYwYr-w5dl_LQw71iX4CuDJi0Ll1roCX2hDJybddZoo45UkSUCqXfO5SRNs-p51HaktbG8pfpjUE9UlhhmH8D1Q_CKUK1TyjcN6HYvGIrtOLbnLdfucki9DFnxWMW6-cSRLag/s640/Bank+Mapping.png)
Step 4: Now import the bank statement file in Bank Account Reconciliation window.
You can select the file by clicking Import bank statement marked in Red. The Imported records will reflect on the left hand side and bank account ledger will be on right hand side
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5-ALtD37L2zVyVL-IWGNRrjenI08uHZocKmht7y99zPW-ooPkL8YmtdR5xdO_-yLPO0tcbebZD6d-Ovt7kA2W3ahfWEI8FSx96pSIBbBxuZY942qjT8V5eX9RNOYY0c-ZXApNL2LFIXc/s640/Reconciliation.png)
Step 5 : Auto Reconcile by clicking on Match Automatically marked in Yellow.
Matching is done on some criteria and priority. Please check below link for the same
https://msdn.microsoft.com/en-us/library/dn414563(v=nav.71).aspx
Thanks & Regards,
Nandesh Gowda
No comments:
Post a Comment