ConstructionPayroll.Com Data Integration Framework |
Top Previous Next |
Enhancements have been made for handling the data integration between AccuBuild Construction Software (ABS) and ConstructionPayroll.COM (CP.COM). These enhancements will allow for payroll batches and Year to Date Employee Totals from ABS to be extracted and uploaded into CP.COM for parallel process testing. [PMID Ref No 23128]
•Advanced Property Setting: This Framework is enabled under a new advanced property setting:
oEnablePRBatchBackupForCPDotCOM
Enable this option on the File > System Administrator > Configuration > Accounting > Advanced Property Settings screen. Once this setting has been enabled, the payroll posting process will begin capturing historical batch records that can be exported and uploaded into CP2.0 for automated parallel testing between the two systems. Both automatic and handwritten payroll check batch data will be captured.
Three company tables will be created automatically during the payroll posting process in order to capture the batch information:
▪PRTCBatch_History ▪PRUserTTBatch_History ▪PRCKBatch_History
•Data Extraction for CP2.0: A new screen has been created for CP2.0 data extraction. To access this screen, select the option entitled ConstructionPayroll.COM Export from the Payroll Menu:
•Payroll Batches: The batch extraction process allows for individual posted payroll batches to be exported to excel spreadsheets for uploading into CP2.0 in order to perform parallel testing. This allows for timecard entries to be processed in CP2.0 automatically using the identical user entries from the AccuBuild System. Extract a payroll batch as follows:
oPayroll Batches: Select the desired batch number from the list of captured payroll batches.
oExport the Batch: Click the Export Timecard Batch Data Entries to Excel button to create the export files for the selected batch number. These files will be saved in the user’s AccuBuild Folder for processing in CP2.0. Two files are created for each batch and identified by the batch type:
▪AUTO = Source 17 Automatic Payroll Checks ▪HANDWRITTEN = Source 18 Handwritten Payroll Check Entry
•Employee Year to Date Totals: This option will allow you to extract year to date totals for each employee from AccuBuild into excel spreadsheets for uploading into CP2.0. This process MUST be done before attempting to run parallel payroll batch tests so that the tax calculates will respect each employee’s year to date totals. Extract the year to date totals as follows:
oConstructionPayroll.com Tenant ID: Enter the Tenant ID for ConstructionPayroll.com. Please contact AccuBuild Support if you are unsure of your Tenant ID.
oCutoff Dates: Set the cutoff date range for the desired calendar year.
oExport Year to Date Totals: Click the Export Hand Written Check Entries to Excel button to create the year to date export files. These files will be saved in the user’s AccuBuild Folder for processing in CP2.0. Three files are created for the year to date totals:
oTechnical Notes: A new user based class series 810000 has been added to the Script Library to handle all of the CP2.0 Processing (810001 thru 810999)
|