For the complete documentation index, see llms.txt. This page is also available as Markdown.

Payroll Summary Report

Logic ERP has improved the formulas of the Payroll Summary Report. A formula column such as ACTUAL SALARY can now be written in VB.NET and still go through all the allowance and deduction columns of the report, as PowerShell formulas did. VB.NET formulas also work on the web and in the 64-bit version.


Step 1: Open the formula

  • Navigate to Payroll Reports and open the Payroll Summary Report.

  • Open the report's column settings (Set Column Attributes) and press Add/Edit Expression Columns. The Script Editor opens with the formula of the report's formula columns, for example ACTUAL SALARY.


Step 2: Convert or write the formula

  • The allowance and deduction columns show in the Field List as one group. In a VB.NET formula the group is written Arr_ followed by the group name, with spaces and symbols written as _ - for example Arr_ALLOW_DED. Each column of the group has a Name (the column's caption) and a Value.

  • A PowerShell formula that goes through the group with ForEach can now be turned into VB.NET with Convert to VB.NET. Earlier this part was left out of the conversion.

  • Test it with Script Watch and press Save.

Example — Actual salary

For an employee with ORG NET SALARY ₹18,234.67, LOAN DEDUCT ₹1,500.50, BONUS ₹3,000 and INCENTIVE ₹0.25, ACTUAL SALARY = 18,234.67 + 1,500.50 - 3,000 - 0.25 = ₹16,734.92 - the same as the old PowerShell formula.


Check after converting

  • The old PowerShell formula also counted a negative allowance or deduction value. The converted formula leaves negative values out. If your report can have negative values, compare a few employees before and after converting.


For more detailed information, Click Here