DA Payroll Statistics
- Erick Meijer
- yuriy.biryukov
- Oleksandr Dykopavlenko
Description | DA Payroll Statistics |
Latest Version | 2022.1.0.5 |
Release Date | Oct 24, 2022 |
Download Path | |
Type | APM Plugin |
Description
The DA Payroll statistics is implemented as an APM plug-in. For how to install the plug-in see the section Housekeeping below. The following requirements are implemented.
- 1 Description
- 1.1 Compatible
- 1.2 Location
- 2 Functionality
- 2.1 Main Selection
- 2.2 Export
- 3 Housekeeping
- 3.1 XREF Interfaces used:
- 3.2 Vessels configuration
- 3.3 Configuration settings for Reporter Setup (Row type 1)
- 3.4 Configuration settings for Person Information Record (Row Type 3)
- 3.5 Configuration Settings for Wage Row (Row Type 4)
- 3.5.1 ILTYPE and configuration
- 3.5.1.1 Annual Summary Code Definition Header
- 3.5.1.2 Annual Code Setup
- 3.5.1.3 Define entry code and field to be exported
- 3.5.1 ILTYPE and configuration
- 3.6 Yearly maintenance
- 4 Download & Install the plugin
- 4.1 Download
- 4.2 Installing the plugin
- 5 Access Rights
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 'Housekeeping' 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 or month to report,
the Reporting Company
DA_STAT National Code
In the field ‘Vessel Org.' you can select the organization that contains the DIS vessels and select the vessel that need to be included in the reporting. Note that selection of vessels is not mandatory, if none selected, the system will report everyone employed by the selected Company.
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 | Identified by the Contract Type on Payscale Table. If Payscale Table Contract type is empty - then use Contract Type from Personal details. 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 | |
0400 | Job Status | 1 = Trainee/apprentice | 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. |
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
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.
More details on the setup of Entry Codes can be found here Payroll setup for DA reporting (Danish Payroll Statistics)
Yearly maintenance
The AS Codes and Entry Codes settings for DA Statistics reporting need to be transferred manually after each year closure:
Go to Plugin > Setup
Transfer Definition
Select the correct years and Transfer
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.