Labor Ledger - Actuals Only

Query Fields

  1. Fiscal Year: Enter fiscal year(s).
  2. Pay Run ID: leave blank to search across all pay runs or enter valid payroll run ID.
  3. Pay Period End Date – Begin Range: Leave blank for ALL or enter specific date in the format shown.
  4. Pay Period End Date – End Range: Leave blank for ALL or enter specific date in the format shown.
  5. RC Code: Leave blank for ALL or click on the Valid Values button to select from a list.
  6. Chart Code: Leave blank or click on the Valid Values button to select from a list.
  7. Org Code: Enter your Org cd or click on the Valid Values button to select from a list.
  8. Account Number: Leave blank or enter account number(s).
  9. Sub Account: Leave blank or enter sub account number(s).
  10. Object Code: Leave blank for ALL or enter specific object codes.
  11. Paygroup: Leave blank or click on the Valid Values button to select from a list.
  12. Earn Code: Leave blank or click on the Valid Values button to select from a list.
  13. Employee ID: Leave blank for ALL or enter specific ID number(s).
  14. Select Output Format: This will default to MS Excel (XLS).
  15. Select Output Destination: You should select “Send Output to Completed Reports”. You usually want to do this for long-running reports.
  16. Click the RUN button.

Be sure to limit your results by either the Org Code or Account Number(s), otherwise the report will take a long time to run.

Screenshot of Labor Ledger Actuals Only Query