PAGE GUIDEWhat the page does and how to use it6 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
An inquiry page that lists payroll earnings statement lines across workers, with earning code, quantity, rate, amount and payment status.
What you do here
Use this page to view earnings statement line amounts and export them to Excel to analyze the data or build custom reports.
Example
For example, filter the lines for one pay period and export them to Excel to check hours and amounts by earning code before pay statements are generated.
The page in Dynamics 365. page title tab to open what to set or check
About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.
How to use it
Go to Payroll > Inquiries and reports > Earnings statement lines.
Use the Filter box to find lines by worker, earning statement or earning code.
Review the Pay cycle, Pay period, Payment status, Accounting date and Earnings date columns.
Use Options to change the view or export the lines.
The hours that count as regular work hours (vacation and sick hours are excluded).Microsoft Learn
IsProductive
Premium code
The premium code that generated a premium earning line.Microsoft Learn
PremiumEarningCode
Source
The document or process the earning line came from, usually an earnings statement.Microsoft Learn
GenerationSource
Technical architect
4Technical
Menu item
PayrollEarningStatementLineInquiryChecked in Dynamics 365
Form
PayrollEarningStatementLineInquiryChecked in Dynamics 365
Table
PayrollEarningStatementLineShown as “EARNINGS STATEMENT LINES” in Record infoChecked in Dynamics 365
Data entities
PayrollEarningStatementImportEntityPayroll Earning Statement Import Microsoft data model PayrollEarningStatementLineEntityEarnings statement lines Microsoft data model PayrollEarningStatementLineInquiryEntityEarning statement lines inquiry Microsoft data model
Who can open it
PrivilegesMaintain payroll earnings PayrollEarningsMaintainView payroll earnings PayrollEarningsViewDutiesInquire into earning entry PayrollEarningStatementGenerationInquireMaintain earning entry PayrollEarningStatementGenerationMaintInquire into payroll payments PayrollPayStatementGenerationInquire2 security rolesPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerChecked in Dynamics 365
Roles to set it up and use it
To use itPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365