Insight Microsoft Dynamics AX
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
Last Updated: 9/14/18
Made with FlippingBook flipbook maker