/
Multiple Worksite Report - Combine Munis Locations into one Location on report
Multiple Worksite Report - Combine Munis Locations into one Location on report
Description of Issue
Is there some way to get one total per group of Locations on the report? For example, Police has multiple sub-locations and there is a total for each sub-location, but wanting one total for Police overall, which would be the total of all the Police sub-locations.
Context
- Payroll
- State Reporting
- Multiple Worksite Report (BLS3020)
Cause
Resolution
Munis Locations can be grouped using the MWL Crosswalk Type.
The Crosswalk can correlates to the Location field in the Employee Master (Primary Location), or to the Check Location field in the Employee Master (Work Location).
- Select Crosswalk from the Multiple Worksite Report (BLS3020) screen.
- Select Add
- Select MWL - Multiple Worksite Report Location from the Crosswalk Type drop-down
- In the Munis Value field, enter the Munis Location code you want to Crosswalk
- In the Crosswalk Value field, enter the Location code you want to see on the Multiple Worksite Report
- Select Accept
- Repeat steps 2 through 6 for each Munis Location that needs to be Crosswalked
- Select Back to return to the Multiple Worksite Report (BLS3020) screen
- Select Define
- Select either Crosswalk Primary or Crosswalk Work in the Location field, depending on which field in the Employee Master should be evaluated for the Crosswalk
- Populate remaining fields and click Accept
- Select an output option
Additional Information
Tip: Before building the MWL Crosswalk, pull up all the Location or Check Location values. Browse and export to Excel. Use the Excel file to plan the Crosswalk.
, multiple selections available,
Related content
Multiple Worksite Report is not showing location and not sure how to identify who the employees are
Multiple Worksite Report is not showing location and not sure how to identify who the employees are
More like this
Multiple Worksite Report Location description reporting as blank
Multiple Worksite Report Location description reporting as blank
More like this
Location for Multiple Worksite Report is not effective dated
Location for Multiple Worksite Report is not effective dated
More like this
Employees are pulling into the Multiple Worksite Report with no Location
Employees are pulling into the Multiple Worksite Report with no Location
More like this
How to create a crosswalk in the 834 Report
How to create a crosswalk in the 834 Report
More like this
Where to find the Pay by Work Location and Org Obj report
Where to find the Pay by Work Location and Org Obj report
More like this