This blog was created to assist clients new to Microsoft Dynamics NAV. The instructions below are used simply to load the bank sub ledger and does not address the G/L Balances.
1. Go to the Financial Management > Payables > Payment Journal
2. Enter the following as shown below:
Posting Date = Check Date
Document Type = Payment
Bank Payment Type = Manual Check
Document No. = Check Number
Account Type = Bank Account
Account No. = Bank Account number
Description = Defaults with Bank Name or you can enter in the Payee name.
Amount = Enter Check Amount as negative
Bal. Account Type = G/L Account
Bal. Account No. = G/L Account that the selected Bank Account uses to post
3. In this example, you may have noticed that they are running an add-on called Easy Security Light. If you are not running this add-on, simply navigate to the Search Box, and type in ‘User Setup’.
4. You will need to open up your posting dates before you can post these outstanding checks. Find your User ID and update the ‘Allow Posting From’ and ‘Allow Posting To’ fields to include the date of the earliest outstanding check.
Please remember to change these dates back after posting to prevent postings in the wrong period.
NOTE! If for any reason one of these checks needs to be voided, you will have to void the check and then manually make an entry to the Bank G/L account and the offsetting expense account where the check was originally applied.