- 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
- you untick the General Ledger Setup>Bank Recon. With Auto Match
- 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
- Payment Registration
- Select invoices to receive payment for
- Post as Lump
- Cash Receipt Entry
- Do not use balancing accounts
- Enter all cash receipts on single lines
- Enter single line for the bank entry that is the total of all cash entries to register the entire transaction as a single journal
- Post
- This will allow you to apply each line separately, but show up in the bank rec as a single entry
- Use a suspense account to collect payments, then manually journal deposit values into the bank from that account
- Deposit with Force Doc Balance Disabled
- General Journal Templates>Deposits>Untick Force Doc Balance
- Use Deposit Screen as normal
- When deposit is posted, it will come into the bank as a single entry
- Disable Bank Recon. with Auto Match (NA Only)
- 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
- 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
- Process>Suggest lines>Both
- Manually mark each entry as cleared
- Enter total for bank statement on top
- Post
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment