BeyondERP.Newsletter
Menu

Inquiry page · Payroll

Earnings statement lines

An inquiry page that lists payroll earnings statement lines across workers, with earning code, quantity, rate, amount and payment status.

Used by
Payroll administrator, Payroll manager
Business process
Pay employees
Menu item
PayrollEarningStatementLineInquiry
Main table
PayrollEarningStatementLine
Data entity
PayrollEarningStatementImportEntity
Show what matters for
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 isAn inquiry page that lists payroll earnings statement lines across workers, with earning code, quantity, rate, amount and payment status.
What you do hereUse this page to view earnings statement line amounts and export them to Excel to analyze the data or build custom reports.
ExampleFor 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.
Earnings statement lines page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage compensation and benefits › Pay employees
Menu pathPayroll › Inquiries and reports › Earnings statement lines
Used next byGenerate pay statements Microsoft Learn
Related pagesPay statement earnings Microsoft Learn
End user · Functional consultant

3How to do it

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

  1. Go to Payroll > Inquiries and reports > Earnings statement lines.
  2. Use the Filter box to find lines by worker, earning statement or earning code.
  3. Review the Pay cycle, Pay period, Payment status, Accounting date and Earnings date columns.
  4. Use Options to change the view or export the lines.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansTable column
Payment statusWhere the line is in payment processing.Microsoft Learn PaymentStatus
Accounting dateThe accounting date of the earning line.Microsoft Learn AccountingDate
Earnings dateThe date the earning applies to.Microsoft Learn EarningDate
Quantity / Rate / AmountThe amount is quantity multiplied by rate.Microsoft Learn
Tax regionThe tax region of the earning.Microsoft Learn WorkerTaxRegion
ProductiveThe hours that count as regular work hours (vacation and sick hours are excluded).Microsoft Learn IsProductive
Premium codeThe premium code that generated a premium earning line.Microsoft Learn PremiumEarningCode
SourceThe document or process the earning line came from, usually an earnings statement.Microsoft Learn GenerationSource
Technical architect

4Technical

Menu itemPayrollEarningStatementLineInquiry Checked in Dynamics 365
FormPayrollEarningStatementLineInquiry Checked in Dynamics 365
TablePayrollEarningStatementLineShown as “EARNINGS STATEMENT LINES” in Record infoChecked in Dynamics 365
Data entitiesPayrollEarningStatementImportEntityPayroll Earning Statement Import Microsoft data model PayrollEarningStatementLineEntityEarnings statement lines Microsoft data model PayrollEarningStatementLineInquiryEntityEarning statement lines inquiry Microsoft data model
Who can open itPrivilegesMaintain payroll earnings PayrollEarningsMaintainView payroll earnings PayrollEarningsViewDutiesInquire into earning entry PayrollEarningStatementGenerationInquireMaintain earning entry PayrollEarningStatementGenerationMaintInquire into payroll payments PayrollPayStatementGenerationInquire
2 security rolesPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManager
Checked in Dynamics 365
Roles to set it up and use itTo use itPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Developer

5Developer

Open it by URLhttps://<your-environment>/?mi=PayrollEarningStatementLineInquiry
Integrate withPayrollEarningStatementImportEntity data entity Microsoft data model
Table definitionPayrollEarningStatementLine columns and relations Microsoft data model
Everyone

6Sources

KEEP EXPLORING

More in Payroll.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.