How to remove Direct Deposit employee from Direct Deposit Interface file.
Description

The files for 2x and above are PR_DirectDepositTransDetail and PR_DirectDepositTransHeader in 2.X

Cause
Resolution

Resolution 1: For Payroll versions 2.x and later

  1. Open Library Master, Utilities, Data File Display & Maintenance
  2. Enter file name PR_DirectDepositTransDetail
  3. Click Key Scan button, find the applicable Batch ID
  4. Select applicable Employee(s) that need to be removed i.e. xxxxYYYYYYYYY (xxxx=batch ID, YYYYYYYYY=employee number)
  5. Verify amount and click Delete button
  6. Open the PR_DirectDepositTransHeader
  7. Click Key Scan button, find the applicable Batch ID
  8. Click Edit button
  9. Select the FileTransmitted field
  10. Change from Y to N
  11. Close out of Data File Display & Maintenance

Resolution 2: For legacy (Versions 2017 and prior)

  1. Open Library Master, Utilities, Data File Display & Maintenance
  2. Enter file name PR_03xxx.soa (xxx=company code)
  3. Click Key Scan button, find the applicable Batch ID
  4. Select applicable Employee(s) that need to be removed i.e. xxxxYYYYYYYYY (xxxx=batch ID, YYYYYYYYY=employee number)
  5. Verify amount and click Delete button
  6. Go back to Header record (just the xxxx batch number)
  7. Click Edit button
  8. Field=1, Position=17, Length=1
  9. Change from Y to N
  10. Close out of Data File Display & Maintenance

Regenerate the ACH File:

  1. Expand Payroll, Direct Deposit, Generate Direct Deposit Interface
  2. Select Option: Batches to include in transmission: Only Batches Never Transmitted
  3. Click Proceed


Steps to duplicate
Related Solutions

How to Reverse Payroll Checks or Direct Deposits in Sage 100 versions 2017 or prior