Description
The DA Payroll statistics is implemented as an APM plug-in. How to install the plug-in see section Housekeeping below. The following requirements are implemented.
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|
Compatible
Compatible with APM 2019.50 or higher*
*Requires cross reference table; PW001C000_XREF, and PWORG_XREF
Location
After installing the plug-in the plug-in is available in the following location
Tools > Export > DA Payroll Statistics
Functionality
After setting up the plug-in as described in 'House keeping' section below, you start the plug-in.
In the plug-in you add the last information needed in the Reporter section of export file; Supplier Identification, System Number and the date of the export.
Main Selection
In the main form of the plugin you select the year to report, the Reporting Company, the National Code used to define ILType's*. In the field 'Vessel Org.' you select the organization that contains the DIS vessels and final select the vessel that need to be included in the reporting.
Once you have made the main selection, hit the refresh button to populate the person and payroll tab.
Export
You can then select the persons or use 'Tag All' and create the export file.
*see housekeeping below
Housekeeping
XREF Interfaces used:
The DA_Payroll Statistics plug-in uses the following interface definitions:
| Interface Code | Description |
|---|---|
| DA_STAT | General interface |
| DA_0200 | DA Statistics Terms of employment PTYPE 0200 |
| DA_0351 | DA Statistics job positions PTYPE 0351 |
DA_0400 | DA Statistics Job Status PTYPE 0400 |
| DA_0620 | DA_Statistics Holiday supplement PTYPE 0620 |
To define the interface go to:
Setup > General Codes > Interfaces
Vessels configuration
To add 'DIS Dansk International' open General Codes → Vessel → Register
DA Payroll Statistics is only reported when serving on DIS (Dansk International Ship register) in the vessel set-up organization structure select DIS.
Configuration settings for Reporter Setup (Row type 1)
| DA Property | Adonis | |
|---|---|---|
| Reporter CVR Number | Company number | Setup > Organization Structure > Select Company used in the reporting
|
| Reporters Name (INAVN) | Company Name | |
Reporters Address (IADR) Reporters Post Code (IPOST) | Company Address |
|
Configuration settings for Person Information Record (Row Type 3)
| DA Property | Adonis Field | |
|---|---|---|
| CVR Number | Persons client company number | |
| DA Union Code | Use the company XREF tab and interface DA_STAT to link the DA Union Code to the company |
|
| CPR-Number | Person ID | |
| IPTYPE | See description below | |
| MKODE | See description below |
IPTYPE and MKODE configuration
| IPTYPE | Description | MKODE(Value) | Adonis Reference |
|---|---|---|---|
| 0200 | Terms of Employment | 4 = Company employed Seafarers with a contract for an indefinite duration. This also applies to trainees. 5 = Temporary/Contract employed | Identified by the contract type on payscale table. Interface code DA_0200 in the contract type XREF identifies the correct MKcode to use.
|
| 0351 | Job Position | Indicate the three-digit code for the seafarer’s job position corresponding to the code you report to Udligningskontoret. Visit the Danish Shipping website to find the complete list of valid codes. |
|
| 0400 | Job Status | 1 = Trainee/apprentice 3 = Officer’s rank 9 = Private/ordinary seafarers Ordinary seafarers without managerial status. The date at which the seafarer has received the job status in question must be indicated in the date field. | See setup of 0351 |
| 0620 | Holiday supplement (%) (Employees who have paid holiday days) | For employees who have paid holiday days, indicate the percentage that is used for calculating the holiday supplement. This comprises at least 1% of the entitled holiday pay, but there may be local agreements regarding higher percentages. The percentage is to be indicated as whole 1/100 percentages. Thus 1% of special holiday supplement is reported as the number 100. |
|
Configuration Settings for Wage Row (Row Type 4)
| DA Property | Adonis | |
|---|---|---|
| CVR-Number (SENR) | Company* Number | Setup > Organization Structure > Select Company used in the reporting
|
| DA-UNION (DAK) | Use the company* XREF tab and interface DA_STAT to link the DA Union Code to the company | |
| Employee number (MNR) | persons nationality + PIN number | |
| CPR-Number | Persons Personal ID | |
| Data Type (ILTYPE) | What kind of information is reported. | |
| Units(ENHEDER) | Number of units for the relevant ILTYPE. Mandatory for ILTypes marked with Days | |
| Amount(BELØP) | Amount for the relevant ILTYPE. Mandatory for ILTypes marked with ØRØ under the column Beløp in the guide | |
| P-Number (PNR) | Persons payment currency + vessels IMO number |
ILTYPE and configuration
Annual Summary Code Definition Header
To identify which entry code and field is used by the DA Statistics you need to define National Code DA_STAT and the AS Codes.
New AS National Code
To be able to add the ILTYPES as AS Codes you need to define a new National Code named DA_STAT.
Goto General Codes > Payroll > Annual Summary Definition Header
and add the code DA_STAT
Annual Code Setup
Goto Setup > Tables > Payroll > AS Codes
Select the national code DA_STAT and define the AS Codes as defined by the DA Payroll statics information. See links in above.
In addition to the standard codes you add two more codes CENTS and DAYS these are used to identify if the entrycode/field contains an amount or an unit.
see screenshot below
.png?version=1&modificationDate=1580996349000&cacheVersion=1&api=v2&height=250)
Define entry code and field to be exported
In the entry code maintenance screen select the entry code that need to be included in the reporting and select the field containing the units, amounts and link them to correct AS Code, ILTYPE.
As code 1 is reserved for the ILTYPE and AS Code 2 is used to identify if it is an amount or unit, days.
Download & Install the plugin
Download
http://download.adonis.no/files/upgrade/PersonnelManager/Plugins/DaPayrollStat/
Installing the plugin
After downloading the plug-in on the server where APM is installed execute the file, the installation set will prompt you for the APM location. After adding or selecting the correct location hit install.
The plug-in will be installed below the given location in directory labeled PLUGIN
On start-up APM will detect the plug-in and make it available in menu Tools>Export > DA Payroll Statistics
Access Rights
The plug-in is also detected by the Adonis Control Center, once detected the administrator can give user groups access to the interface.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|