Hi Community,
How do I get the Bank Statement Lines to be filled up in Navision ?
Please give me a step by step way of doing it. Thank you!
Hi Community,
How do I get the Bank Statement Lines to be filled up in Navision ?
Please give me a step by step way of doing it. Thank you!
Josh,
I copied my handout steps:
SETUP:
Data Exchange Definition.
Bank Export/Import Setup.
Fields to be updated on Bank Account Card.
Setup in Detail
Code= TEST BANK IMPORT (Any relevant Code of your choice)
Name= TEST BANK IMPORT (Any relevant Name of your choice)
File Type= Variable Text
Type= Bank Statement Import
Reading/Writing Xml Port= 1220
Ext Data Handling Code unit= 1240
File Encoding = WINDOWS
Column Separator = Comma
Line Type: Detail.
Code = Test (Any relevant Code of your choice)
Name = TEST BANK IMPORT (Any relevant Name of your choice)
Column Count= 7 (The Number of columns in the Bank Statment to be imported. For my e.g., it's 7.)
Enter Name of Column, Data Type of Column, Data Format, Data Formatting Culture.
Field Mapping FastTab:
In Column No. click on the drop-down, then select the first line. It will point to the Column Definition from the Data Exchange Definition page.
Then, go to the Field ID column, click the dropdown. Field lookup will open. Select the field, then click on 'OK'.
Follow the same Procedure for all Lines.
Now the Field Mapping FastTabwill look something like this:
Step 6: Now go to Bank Export-Import Setup.
Code = TEST BANK IMPORT
Name = Test for Bank Recon
Direction = Import
Processing Code Unit Id= 1270
Processing Code Unit Name= Exp. Launcher Gen. Jnl.
In the Exchange Definition Code, Click the drop-down & Select = TEST BANK IMPORT
Step 7: Go to the Bank Account Card.
Transaction
Step 1: On the Navigation pane, click Departments and then click Financial Management.
Header
If you have a file that has the current bank statement, proceed to fill the lines automatically.
The lines include the following fields:
Transaction Date: Specifies the posting date of the bank account or check ledger entry on the reconciliation line when the Suggest Lines function is used.
Type: This shows the type of ledger entry or a difference to be reconciled on this line.
The options are as follows:
Description: This shows a description of the transaction on the reconciliation line.
Statement Amount: This shows the transaction amount that appears on the bank's statement that shows on the reconciliation line.
Applied Amount: This shows the transaction amount on the reconciliation line that is applied to the bank account or the check ledger entry.
Difference: This shows the difference between the amount in the Statement Amount field and the Applied Amount field for the reconciliation line.
Value Date: You can use this field to enter the official date when funds are available and when interest is calculated on the amount on the reconciliation line.
Document No.: Shows the document number that is specified on the original bank account ledger entry.
Check No.: Shows the Check number (specified as the document number) used on the original check ledger entry.
Applied Entries: Specifies whether the transaction on the bank's statement on this reconciliation line is applied to one or more bank account or check ledger entries.
Step 8: On the Actions tab, in the Functions group, choose Import Bank Statement.
The below format is used for Importing the Bank Statement in our example. I am attaching a sample used to import in my example.
To automatically match bank statement lines with bank account ledger entries:
Step 11: In the Transaction Date Tolerance (Days) field, specify the span of days before and after the bank account ledger entry posting date within which the function will search for matching transaction dates in the bank statement.
All bank statement lines and bank account ledger entries that can be matched change to green font, and the applied check box in the right pane is selected.
To manually match bank statement entries with bank account ledger entries:
In the left pane, select a bank statement line.
In the right pane, select one or more banks account ledger entries that can be matched with the selected bank statement line. To choose multiple lines, press and hold the Ctrl key.
On the Home tab, in the Matching group, choose Match Manually. The selected bank statement line and the selected bank account ledger entries change to green font, and the applied check box in the right pane is selected.
Repeat steps 3 through 5 for all bank statement lines that are not matched.
To remove a match, select the bank statement line, and then, on the Home tab, in the Matching group, choose Remove Match.
Step 1: Let’s add an additional entry on the left pane: Bank Statement Lines.
After the bank reconciliation, has been posted, a bank account statement is created. To view the bank account statement, open the relevant bank account card, and from the Navigate tab, in the Bank Acc. group, choose Statements.
Step 4: Click on Edit to view the Bank Statement Entries.
thanks
Hi Kim,
May I see a screenshot of where this setting in General Ledger Setup is?
Thank you!
Thanks Josh, for your reply.. Hmm... The strange thing is that when my accounts selected Suggest Lines and input the month Jan, there was not results in the bank Statements.
I had confirmed with her that we have yet to do any Jan Bank Recon.
Is there anyway I can check whether it has been Bank Reconcile?
Thank you so much.
To be clear, your setting in General Ledger Setup must the Auto Match to download the csv that Josh mentions and the Suggest Lines is used if you are not auto matching.
Simply way is to use the “suggest lines” page action. Choose your dates and other filter conditions. The most common is to get a csv download from the business bank account. Using data exchange definitions you map the csv file. The bank account card can then use a chosen import method. On the bank reconciliation you then use the import statement page action. Choose your csv file and the data is added according to the data exchange definition.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal...
288,584
Super User
Martin Dráb
225,864
Super User
nmaenpaa
101,148