Resource Center Home
Resource Center Home

HR and Payroll for Business Central

HR and Payroll for Business Central

Create Custom Payroll Reports

Create Payroll Report Layout Groups

  • Full Payroll Menu
  • Setup Groups
  • Payroll Layout Groups
  • Here is where you create your groups that will link to the Payroll Code. The below is an example for an Earnings report.
    • Select New
      • Code “Regular” and this will populate the name under Caption.
      • Description “Regular”
      • Type:
        • If you want all of one type of payroll codes. Ex) if you select Earnings that would bring All earnings into the report.
        • Leaving it blank
          • This will allow you to select payroll codes that you would like in the report.
          • To select a payroll code or group of payroll Codes
  • This will bring up Payroll Report Layout Group Codes so you can add the payroll code or payroll codes.
  • You can Add payroll codes individually or you can do Suggest Payroll Codes. This will bring in all payroll codes for that type and you can then remove any payroll codes that you don’t need.
  • Once you have created all the groups you would like in your report you are now ready to build the report.

Create Report Layout

  • Full Payroll Menu
  • Setup Groups
  • Payroll Layout Groups
  • Select New
    • Code “REGULAR”
    • Description “Regular”
    • Source Ledger Entries or Open Documents (if you want to use it when you have a Payroll Batch)
      • When you run the report, you can always override this option in the selection.
    • Level- Depending on how you would like to see the data but you can override this when you run the report.
      • Employee
      • Employee Posting Group
      • Payroll Division
      • State
      • Company Code
    • Sub Total Depending on how you would like to see the data you can subtotal by the following. When you run the report you can override this option.
      • Employee Posting Group
      • Payroll Division
      • State
      • Month