This guide provides a temporary workaround to display SKBBK amounts correctly in your payroll reports. Follow the steps below to customise your report format so that the SKBBK column and totals appear accurately for use by your accounts department.
Important: This is a temporary workaround. Please test the report format thoroughly after making changes before using it for financial reporting.
Step 1: Open the Print Report dialog and customize the layout
In the Print Report dialog, select Customize.
Move objects in the report to create a space between SOCSO employee and EIS employee.
Step 2: Add the SKBBK field object
Click View, Report Controls Toolbar, click on Field (2nd option) – the object with [ab].
Left-click and hold the mouse button on the empty space, drag to draw a small square, then release the click to create the field object.
In the Expression field, enter the following: lg('SKBBK').
Step 3: Add the SKBBK total expressions
getvalue(skbbkcc)
getvalue(ltSkbbkcc)
getvalue(atSkbbkcc)
Note: Expressions 2 and 3 require variables to be created before they will work. Follow Step 4 below to set these up.
Step 4: Create variables for expressions 2 and 3
Go to Report, then click Variables.
Insert the variables corresponding to the expressions getvalue(ltSkbbkcc) and getvalue(atSkbbkcc).
Save the format and test the report to verify the values are displaying correctly.
Tip: You can add more totals and columns depending on your report format using the same expressions and variables” including group, branch, department totals, and nett totals.