ACA Visual Integrator Sample Jobs and Import Setup for Sage 100 ERP
Description
Cause
ACA Reporting Worksheet for Sage 100 ERP
Many customers with more than 1,000 employees requested a way to begin entering ACA reporting information.

 

Resolution

ACA resources

For additional ACA setup and reporting information check the Related Resources section below.

 

Locate the sample ACA Visual Integrator jobs

The ACA Payroll Visual Integrator sample jobs are in the following folder:
  • ..\MAS90\PR\PayrollACAMaintenanceImports.exp

Import the sample jobs

  1. Open Visual Integrator, Main, Job Import.
  2. Browse to the..\MAS90\PR folder.
  3. Select PayrollACAMaintenanceImports.exp.
  4. Click Select All.
  5. Click Accept.

Available sample import jobs

These imported jobs work with the ACA Reporting Worksheet. Follow the worksheet instructions exactly.

PR_ACAEMP1

  • Imports data into PR_ACAEmployee.
  • Populates ACA Employee Maintenance.

PR_ACAEMP2

  • Imports data into PR_ACAEmployeeMonthlyDtl.
  • Populates ACA Employee Monthly Detail.

PR_ACAEMP3

  • Imports data into PR_ACAEmployeeCoveredInd.
  • Populates ACA Employee Covered Individuals.

PR_ACAEMP4

  • Imports data into PR_EmployeeTaxFilingStatus.
  • Populates fields on the Employee Maintenance Taxes tab.
  • Populates the 1095 Consent field for the FEDERAL Tax Group.

Information these jobs can import

The sample jobs import the following ACA information:
  • Self-insured coverage acknowledgment.
  • Employee and covered individual details, including name, Social Security number, and date of birth.
  • Monthly employee details for Offer of Coverage, Low-Cost Share, and Safe Harbor codes.
  • Employee electronic consent acknowledgment.

 

[BCB:155:Chat 100 US:ECB]

 

Steps to duplicate
Related Solutions

How does Sage 100 support the Affordable Care Act (ACA)
How do I setup Sage 100 to support Affordable Care Act (ACA) requirements
How to copy Employee ACA data from one tax year to the next tax year