How to setup Entry Code for manual usage
This article explains how to set up the Entry Code for manual usage.
Before reading this article we would recommend getting acquainted with the general information on https://adonishr.atlassian.net/wiki/spaces/KB/pages/3203928309 and https://adonishr.atlassian.net/wiki/spaces/KB/pages/3207266779.
Contents
Setup and configuration
Adjusting existing Entry Code for manual usage
Step 1
Go to the Entry Code Maintenance and select the entry that you want to be used for manual adjustments;
Step 2
Open the Input tab, add the names of the fields to be used, and enable them for manual input.
In our example we will use the following:
L21 - Amount, if we need to input the whole amount manually without any additional calculations.
L22 - Days and L23 - Rate, if we need to input only the number of days and rate so that the system calculates the Amount based on those values.
Step 3
Under the Calculation tab, we need to add a formula for L61 calculation since only the amounts from L61 are added to the EC 994 Net Wages.
Thus, in the script of this entry we need to add a simple formula:
Option 1
If we want to have the possibility to input the full Amount manually, then before the condition used for calculation of the amount on auto-generated entry we need to add the following formula.
IF L21 <> 0 THEN
L61=L21
ELSE
…
ENDIF
At the end of the whole condition we then need to add extra ENDIF to end the condition.
It means that L61 will be equal to the value inputted by the user in the L21 Amount field.
Option 2
If we want the system to perform the calculation of the Amount based on the rate (L23) and the number of days (L22), then we need to use this formula:
IF L22 <> 0 AND L23<>0 THEN
L61=L22*L23
ELSE
…
ENDIF
At the end of the whole condition we then need to add extra ENDIF to end the condition.
It means that L61 will be equal to the value in the L22 Days field multiplied by the value in the L23 Rate field.
Once the setup is completed we can add our Entry Code manually under the Payroll > Entries.
Step 4
Here’s how the above setup would be reflected in the entries:
Option 1
In case we made a setup to add only the Amount we need to input it in L21 and calculate.
Option 2
In case we made a setup to calculate the Amount based on the rate (L23) and the number of days (L22), we need to add appropriate values to those fields and calculate.
Creating new entries for manual usage
Step 1
Go to the Entry Code Maintenance and add a new Entry Code. Let’s call it Basic Wages.
Set it either as Allowance or Deduction.
Step 2
Open the Input tab and add the names for fields to be used.
In our example we will use the following:
L21 - Amount, if we need to input the whole amount manually without any additional calculations.
L22 - Days and L23 - Rate, if we need to input only the number of days and rate so that the system calculates the Amount based on those values.
L32 - Vessel.
Step 3
Under the Options tab we will turn on the following options:
Remove from PaySlip when CaculatedAmount1 = 0
For the entry code not to be displayed in the Payslip report if there are no overtime payments.
Calculate fixed entries also for de-active persons.
If this is a fixed entry and the option is checked, the entry will be still included in payroll recalculation for the de-active persons.
It is needed in case the person should be paid after his/her employment for the company came to an end, but he should still be paid some additional expenses.
Step 4
As we learned previously, only the amounts from L61 field on any Entry Code is added to the EC 994 Net Wages.
Thus, under the Calculation tab we need to add a formula for L61 calculation.
If you don't have any complex calculation rules, then we don't need to add payroll script on this entry.
Option 1
If we want to input the full Amount, we can just add a simple formula - @L21 under the Amount field for L61.
It means that L61 will be equal to the value inputted in L21 Amount field on this entry.
Option 2
If we want the system to perform the calculation of the Amount based on the rate (L23) and the number of days (L22), then we need to use the @L22*L23 formula instead.
It means that L61 will be equal to the value in the L22 Days field multiplied by the value in the L23 Rate field.
If our entry has complex calculation rules with various conditions, then we need to link it to the payroll script.
Option 1
If we want to input the full Amount, we need to use the following formula in the script:
IF L21 <> 0 THEN
L61=L21
ENDIF
It means that L61 will be equal to the value inputted by the user in the L21 Amount field.
Option 2
If we want the system to perform the calculation of the Amount based on the rate (L23) and the number of days (L22), then we need to use this formula:
IF L22 <> 0 AND L23<>0 THEN
L61=L22*L23
ENDIF
It means that L61 will be equal to the value in the L22 Days field multiplied by the value in the L23 Rate field.
Step 5
Finally, under the Payslip tab, we will add fields that we want to be shown in the Payslip report.
Our Entry Code is ready!
Step 6
Once the setup is completed we can add our Entry Code manually under the Payroll > Entries.
Option 1
In case we made a setup to add only the Amount we need to input it in L21 and calculate.
Option 2
In case we made a setup to calculate the Amount based on the rate (L23) and the number of days (L22), we need to add appropriate values to those fields and calculate.