This chapter contains these topics:
In rare instances, you might encounter a history integrity problem that you cannot correct by running an integrity report in update mode or by revising payroll history manually. For example:
During final update, a machine failure or power outage might prevent the system from updating the summary history tables.
While revising pay and tax amounts by month, you might have entered an incorrect gross pay amount.
In these instances, you can usually repost to correct the problem. A repost program retrieves the information in a detail history table by payment date and recalculates the totals in the corresponding summary history table. The system retrieves the information from the history detail during a repost. If you revised or corrected the history summary and want to keep the changes, you should not run a repost. Except for maximum amount taxes such as FICA and Medicare, the repost will not include the revisions you made to summary history.
This section contains the following:
Reposting Pay Types to the Payroll Month
Reposting DBAs to the Payroll Month
Reposting DBAs to the Calendar Month
Reposting the Tax ID to the Tax Ledger
Reposting DBAs to the Tax Area Summary
Reposting DBAs to the Fiscal and Anniversary History Summary
Reposting the Workers Compensation Summary
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose Pay Types to Payroll Month
Repost pay types to payroll month if your Payroll Month PDBA Summary History table (F06146) contains corrupt data. This repost totals the pay type transactions stored in the Payroll Transaction History table (F0618) and posts monthly totals for gross pay and hours to the Payroll Month PDBAs Summary History table.
The repost summarizes by cheque date. It overwrites existing totals in the summary table.
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose DBAs to Payroll Month
Repost DBAs to the payroll month if the information in your Payroll Month PDBA Summary History table (F06146) does not correspond to the detail information in the DBA Detail History table (F0619). For each employee, this repost calculates monthly totals for each DBA type. It then posts these totals to the Payroll Month PDBAs Summary History table.
The repost summarizes by cheque date. It overwrites existing totals in the summary table.
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose DBAs to Calendar Month
Repost DBAs to the calendar month if the information in your Calendar Month DBA History table (F06145) does not correspond to the detail information in the DBA Detail History table (F0619). For each employee, this repost calculates monthly totals for each DBA type. It then posts these totals to the Calendar Month DBA History table.
The repost summarizes by cheque date. It overwrites existing totals in the summary table.
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose Tax ID to Tax Ledger
JD Edwards World recommends that you run the repost procedure only with the guidance of JD Edwards World Customer Support.
Repost the tax ID to the tax ledger if you originally made a mistake in setting up your tax ID, or if your company received a new corporate tax ID. When you receive a new tax ID, you must update all records that have the temporary tax ID.
This keeps your tax ledger entries accurate. You can assign the tax ID to up to five tax types at one time.
Updating a new tax ID to Canadian Tax History files involves running the Tax ID to Tax Ledger (P07990) utility program, which updates related data in the Repost Tax ID to Tax Ledger (F0716) file. In most cases, you must then run the Tax ID to Tax Ledger (P07790) program to update related data in the Taxation Summary by Province (F0713) file. See the steps below for details.
It is strongly suggested that you also enter data selection criteria for the dates that you want to update. If you do not enter date information, the DREAM Writer version will update ALL Tax Ledger Detail (F0716) records with the tax ID entered in the data selection.
After you run the repost, you should review each tax type to ensure that the new tax ID number was correctly assigned. This program does not produce a report.
When you receive a new company tax ID, you will use data selection to specify the records to update and a processing option to specify the new Tax ID.
This process includes:
Back up the entire Tax ID to Tax Ledger (F0716) file to protect the integrity of your data.
Call JD Edwards World Customer Support to assist with the following steps. It is recommended that you complete this procedure with their guidance.
Set up a DREAM Writer version of the Tax ID to Tax Ledger (P07990) program (G7731/17) with data selection that will enable you to select the "From" tax ID and specify the records to be updated. You must do this before you run the program to update the tax ID to the F0716 file.
Note:
If you do not specify the records to update through data selection, this program will update the tax ID for ALL records in the F0716 file. Additionally, if you fail to select the "From" tax ID through data selection, the results may be unpredictable and could cause the program to job log.Specify the "To" (new) tax ID through processing option #1 on the Tax ID to Tax Ledger (P07990) program (G7731/17).
For most situations, you must update the new tax ID to the Taxation Summary by Province (F0713) file using the Tax ID to Tax Ledger (P07790) program located at G7731/18.
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose DBAs to Tax Area Summary
Repost DBAs to the tax area summary if the information in your Tax Area Transaction Summary History table (F06148) does not correspond to the detail information in the DBA Detail History table (F0619). For each employee, this repost totals amounts for all transactions that have the same tax area, DBA type, year, tax ID, and company number. It then posts the total, as one summary transaction, to the Tax Area Transaction Summary History table.
The repost overwrites existing totals in the summary table.
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose DBAs to Fiscal and Anniversary
Repost DBAs to the fiscal or anniversary summary history if the information in your Fiscal and Anniversary History Summary table (F06147) does not correspond to the information in the DBA Detail History table (F0619) and the Payroll Transaction History table (F0618). For each employee, this repost calculates the year-to-date (YTD) amount for only those DBAs that you have set up for fiscal or anniversary rollover. It then posts these YTD amounts to the Fiscal and Anniversary History Summary table.
The system uses the DBA limit method you entered when you set up your DBAs to determine whether the summary history is stored by payment date or pay period ending date. If the system needs pay types to calculate the year-end balance, the repost automatically reposts the required pay types.
The repost overwrites existing YTD amounts for each employee and DBA. It does not overwrite prior year and beginning balances.
See Section 54.11, "Repost DBAs to Fiscal and Anniversary (P06147A)"
See Also:
Section 35.3, "Setting Up Typical DBAs" for information about entering DBA limit amounts
From Canadian Payroll Master (G77), enter 27
From Payroll Advanced/Technical Operations (G773), choose Data Integrity/Global Update
From Data Integrity/Global Update (G7731), choose Workers Comp Survey
Repost the workers compensation summary when the information in your Workers Compensation Summary table (F0627) does not correspond to the detail information in the Transaction History table (F0618). This repost summarizes, by payment month and year, the workers compensation and general liability amounts in the Transaction History table. It then posts this summary to the Workers Compensation Summary table.
This repost adds additional information to the summary table. It does not overwrite any existing information.
If you have not set up a corporate tax ID for the workers compensation and general liabilities tax types, the system enters the Federal Tax ID for Canadian Payroll.