What This Process Does

  • When the Update Bank Reconciliation process has been run, this Undo step is necessary when the Bank ID, Check Number, Check Date, voucher amount, Vendor ID or Deduction Description ID on a voucher needs to be changed, when a voucher needs to be deleted, or when a voucher was voided in error.
  • Creates offsetting electronic transmittals in the Bank Reconciliation module.
  • Marks the selected checks for deletion in the Bank Reconciliation module.
  • Automatically removes the check records when flags are set.

Best Practices

  • In order for vouchers to be selected, Update Bank Reconciliation must be true.
  • Undo processes must begin with the last process completed, and move up through the Undo Vendor Withholding menu until the last process needed for the correction is completed.
  • Because check records in Bank Rec are automatically marked for deletion and automatically removed, range carefully to ensure only vouchers associated with checks that need to be undone are included in the process; a report will be provided to verify checks being undone.
  • If using this process because the wrong check was voided, use the Clear Voided Fields flag on the range tab; this will allow you to undo the Distribution for the V/W voucher(s) created for the void so that the voucher(s) can be deleted; the original checks (vouchers) that were voided in error can then be updated to Bank Rec.

Undo Vendor Withholding Update Bank Reconciliation

1. Payroll Vendor Withholding → Maintenance → Undo Vendor Withholding Vouchers → Update Bank Reconciliation

2. Range as appropriate, based on the voucher(s) for which you want to undo Update Bank Reconciliation.

3. Click Run/Print Report (the cog button); review the report for accuracy.

4. Click Cancel.

NOTE: If a No Records Error is received, it may be due to inaccurate Range or Select criteria, or an indication that the Update Bank Reconciliation flag is already false on the vouchers.

5. If the report accurately reflects the vouchers you want to undo, click Set Flags; if the report is incorrect/incomplete, click Quit.

NOTE: If you used this process because the wrong check was voided, you can now run Update Bank Reconciliation (from the task window) to update the original voucher that was voided in error.

FIELDSOpt.Rec.Req.Description
Clear Void Fields in V/W Voucher♦——Flag if you are running this process because the wrong check was voided; this will allow you to undo the Distribution for the V/W voucher(s) created for the void, so that the voucher(s) can be deleted
Bank Identification♦——Use this range criteria if you want to undo undo Update Bank Rec for vouchers that were added with a specified Bank ID
Check/Electronic Transfer Number♦——Use this range criteria if only one number, or range of sequential numbers, needs to be undone
Check/Electtronic Transfer Date♦——Use this range criteria if you want to undo undo Update Bank Rec for vouchers with a specified Check/Electronic Check Date
Source User—♦—Recommended if multiple users are creating vouchers
Deduction Description ID♦——Use this range criteria if you want to undo Update Bank Rec for a specific deduction, and not all vouchers
Fiscal Year♦——Use this range criteria if you want to undo undo Update Bank Rec for vouchers that were added for a specified Fiscal Year
Entry Date♦——Use this range criteria if you want to undo Update Bank Rec that was run on a specific date
Bank Rec Update By♦——Use this range criteria if you want to undo Update Bank Rec that was run by a specific user
Bank Rec Updated Date—♦—Recommended; use this range criteria to undo Update Bank Rec that was done on a specified date
Employer Identification♦——Use this range criteria if you want to undo Update Bank Rec on vouchers with a specified Employer ID
Vendor Identification♦—–Use this range criteria if you want to undo the audit trail on vouchers for a specific vendor, and not all vouchers
Select When Electronic Transfer False♦——Flag to include vouchers that were not electronic vouchers
Select When Electronic Transfer True♦——Flag to include electronic vouchers (i.e., those vouchers that were not checks)
Select When Direct Draft False♦——Flag to include vouchers that are not set up as direct drafts
Select When Direct Draft True♦——Flag to include direct draft vouchers
Opt. = Optional  Rec. = Recommended  Req. = Required