Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article explain how to setup the Entry Code for manual usage.

Setup and configuration

Before reading this article we would recommend to get acquainted with the general information on Payroll Script and Payroll Entry Codes.

Adjusting existing auto-generated Entry Code to be used for manual adjustments.

  1. Go to the Entry Code Maintenance and select the entry that you want to be used for manual adjustments;


  2. Open the Input tab and , add the names for fields to be used and enabled 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.

  3. Under the Calculation tab we need to do 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 simple formula:

    • If we need to input the full Amount, we use the following formula before the condition used for calculation of amount on auto-generated entry:

      IF L21 <> 0 THEN
      L61=L21
      ELSE

      It means that L61 will be equal to the value inputted by the user in L21 Amount field.



    • If we need 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


      It means that L61 will be equal to the value in L22 Days field multiplied with the value in L23 Rate field.

  4. Then under Payroll > Entries screen when we add this Entry Code manually.

    • In the first case we need to add only the Amount.





    • In the second case we need to input the Days and Rate.


Creating new entry for manual usage.

  1. Go to the Entry Code Maintenance and add a new allowance Entry Code. Let’s call it Basic Wages.



    Set is either as Allowance or Deduction.


  2. Open the Input tab and add the names for fields to be used. In our example we will use the following:



    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.

  3. Under the Options tab we will turn on the following options:


    Remove from Pay Slip 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 is to be payed after his/her employment for the company came to an end, but he should still be paid some additional expenses.

  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 do add a formula for L61 calculation.

    • If you don't have any complex calculation rules and don't have a script linked to this entry, then under the Amount field for L61 we can just add simple formula - @L21.
      It means that L61 will be equal to the value inputted in L21 Amount field on this entry.



      Or we can use @L22*L23.
      It means that L61 will be equal to the value in L22 Days field multiplied with the value in L23 Rate field.



    • If our entry has complex calculation rules with various conditions then we need to link it to the payroll script.

      If we need to input the full Amount, we 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 L21 Amount field.



      If we need 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 L22 Days field multiplied with the value in L23 Rate field.

    • Add account numbers for debit/credit, if they are required.

  5. Finally, under the Payslip tab we will add fields that we want to be shown in the Payslip report.



    Our Entry Codes is ready!
  6. Now, when the setup is complete under Payroll > Entries screen when we add this Entry Code manually.

    • In the first case we need to add only the Amount.





    • In the second case we need to input the Days and Rate.