Main Page → Bank Reconciliation → Documentation → Query → Query Deposits


Contents

 
  • 1 What This Process Does
  • 2 Best Practices
  • 3 Requirements
  • 4 Query Deposits



What This Process Does


  • This process makes it possible to locate a deposit in order to view it or make changes.


Best Practices


  • Unless otherwise instructed, there is no need to delete a deposit. When running an undo process to remove a deposit, a negative record is created to wash out the original deposit.
  • Do not change any field within the deposit. If you are unsure about the accuracy of a field, please call technical support.


Requirements


  • In order for a deposit record to exist, the receipt record in Financial Management must have been updated through an Update Bank Reconciliation process.


Query Deposits


  1. Finance → Bank Reconciliation → Query → Deposits
  2. Range accordingly to view desired deposits. Click Select.
  3. A browse list of deposits appears. Highlight the deposit and click Select.


FIELDSOpt.Rec.Req.Description
Bank ID———Populates based on bank chosen when deposit created
Deposit Number———A number assigned to the deposit when updated to the Bank Reconciliation module
Deposit Amount———Populates based on the amount entered when deposit created
Reference ID———
  • FINMGT: Populates based on the Control/Deposit ID entered when deposit created
  • VENPMT: Populates based on the Vendor ID entered when deposit created
  • BNKREC: Populates based on the Reference ID entered when deposit created
Reference Name———
  • FINMGT: Populates based on the Control/Deposit ID entered when deposit created
  • VENPMT: Populates based on the Vendor Name entered when deposit created
  • BNKREC: Populates based on the Reference Name entered when deposit created
Source Module———The module where the deposit is created
Statement Date———The bank statement in which the deposit record will appear
Process———The process that was run from the source module to update the Bank Reconciliation module with the deposit
Process User———The user who ran the update bank reconciliation process in the source module
Process Date———
  • FINMGT: Populates based on the deposit date entered when deposit created
  • VENPMT: Populates based on EFT date entered when deposit created
  • BNKREC: Populates based on deposit date entered when deposit created
Cleared———Checked if deposit has been reconciled in Bank Reconciliation
Updated———Checked if deposit has been updated to cleared balance in Bank Reconciliation
Opt. = Optional  Rec. = Recommended  Req. = Required