1. Payroll Implementation Guide
  2. DBA Calculations

DBA Calculations

Periodically, the system does not calculate one or more DBAs that should be calculated during pre-payroll. This might happen even if the system properly calculated the DBAs during the previous payroll cycle. This condition might affect payments for all employees, some employees, or just one employee.

You can use the D/B/A Transaction Audit Report (R073053) or the D/B/A Register report (R073062), which you can print at any time during the payroll cycle, to determine the number of employees for whom the system did not calculate DBAs.

If the system does not calculate a DBA for one or more employees, you should review the setup information for the DBA and make any necessary corrections. For example, if the system did not calculate the DBA for any of the employee records, you might need to correct the effective dates for the DBA. If the system calculated a DBA (such as a retirement plan deduction) for all but one of the employees, determine whether the affected employee has reached the limit for the DBA.

If the system calculated a DBA for some employees, but did not calculate it for any of the employees in a specific group plan, you might need to correct the effective dates or withholding period that you set up for the group plan.

If you are not using group DBA plans, or if the employees for whom the system did not calculate the DBA are in different group plans, verify that the employees earned enough to cover their deductions and that the employees' DBA instructions are accurate.

Sometimes, a valid condition exists that prevents the system from calculating a DBA for an employee. For example, you might have entered a one-time override for the DBA when you entered the employee's timecard.

If a DBA is not being calculated correctly for one or more employees in the payroll:

  • Verify that the Pre-Payroll DBA Calculation Control Table (F07901) contains data.

    If this table is empty, contact JD Edwards Technical Support for assistance.

  • Verify that user-defined code (UDC) table 07/VN exists and that it contains data.

  • Confirm that the Period Number field on the Pre-Payroll Processing form contains a value.

  • Verify that the value in the Period Number field on the Pre-Payroll Processing form coincides with the value in the appropriate Pay Period of the Month field on the Basic DBA Information form.

    For example, if the Period Number field contains a 1, verify that the Pay Period of the Month (1) field contains a value of * or Y.

  • Verify that the from and through dates for pre-payroll are not within the DBA start and stop dates.

  • Review the Override Flag in the employee's DBA instructions or in the group plan setup.

    The DBA might not be set up to calculate for an employee or group of employees.

  • Verify that the system calculated the based-on DBA if the DBA that you are reviewing is based on another DBA.

  • Verify that one or more of the pay types that were used to pay the employee's earnings for the period are included in the DBA's basis of calculation.

  • Verify that the Home Company field on the Advanced DBA Information form is blank.

    If it contains a value, verify that the value is the same as the employee's home company.