To display the correct amount of vacation pay owing at the time of the paycheck, menu select Print > Paychecks. This item will allow you to display the perpetual amounts in selected cells from which you can have the Excel template perform the calculation you need to display. Examples templates are located in print_templates/payroll_ca/payroll_reports within your NewViews program folder.
Payroll_ca_paycheck_ytd_vacation.xls is one template you can review. The Vac Owed row will be of interest to you. Print > Paychecks uses the defined mapped table you set under Advanced > Payroll Report Codes.
The above is for Canadian users. USA Payroll users can find the Payroll Report templates under print_templates/payroll_us within your NewViews program folder.
Regards to All,