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 (BLS3030) 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.
Add Comment