Payroll Handbook

Insight Microsoft Dynamics AX

Payroll Handbook

Reconcile the Benefit/Deduction Transaction report to the AP Vendor Report 1. Remove the filter for the 669-PAC Fund on the spreadsheet with the Benefit/deduction transactions inquiry information.

2. Click on Insert tab, then PivotTable to create a Pivot Tale.

3. In the Rows window add Benefit/deductions .

4. In the Values window add in Sum of Worker Amount , Sum of Employer Amount , Sum of Total Benefit/Deduction Amount.

5. In the Filters field add Payment Period Number to be able to view the whole month or per pay period.

6. Use the Row Labels column heading to filter to the Benefit/deduction (ben/deds) of interest.

7. Follow your company’s existing process to issue payment.

©APi Group Inc. All Rights Reserved

Page 277

Last Updated: 9/14/18

Made with FlippingBook flipbook maker