Saturday, June 13, 2020

Dynamics NAV/BC - How to post cash to the bank in a lump so it displays in the bank rec as a single value


  • What does not work
    • If you use balancing accounts on the cash receipt screen, it will come in as multiple lines in the bank rec
    • The deposit screen details will come in as multiple lines in the bank rec UNLESS 
      1. you untick the General Ledger Setup>Bank Recon. With Auto Match 
      2. OR You untick the General journal Templates>Deposits>Force Doc Balance 
        • (This puts a balancing entry on each journal line, disabling it puts a summary journal line which results in a single bank entry
  • What works - There are 5 ways to do this
    1. Payment Registration
      1. Select invoices to receive payment for
      2. Post as Lump
    2. Cash Receipt Entry
      1. Do not use balancing accounts
      2. Enter all cash receipts on single lines
      3. Enter single line for the bank entry that is the total of all cash entries to register the entire transaction as a single journal
      4. Post
      5. This will allow you to apply each line separately, but show up in the bank rec as a single entry
    3. Use a suspense account to collect payments, then manually journal deposit values into the bank from that account
    4. Deposit with Force Doc Balance Disabled
      1. General Journal Templates>Deposits>Untick Force Doc Balance 
      2. Use Deposit Screen as normal
      3. When deposit is posted, it will come into the bank as a single entry
    5. Disable Bank Recon. with Auto Match (NA Only)
      1. This gives you a completely different bank rec screen and bank rec report which is more conventional than the default bank rec screen and report
      2. The only drawback of this option is you do not enter the bank statement for auto-matching, but otherwise, this is the most conventional method of bank reconciliation
      3. Process>Suggest lines>Both
        1. Manually mark each entry as cleared
        2. Enter total for bank statement on top
        3. Post

No comments:

Post a Comment