...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Excerpt |
|---|
This article describes Import Payroll Entries functionality, which allows to import csv files into payroll module for accurate distribution of variable payments. |
Description
Import Payroll Entries tool is efficiently used when there is need to make a batch import of variable payments for multiple crew in the month.
NOTE: you can only import Payroll entries in the current period. Not possible to import entries to History using Import Payroll Entries tool.
File format
The file for import has be to a .csv type - comma, semicolon or tab used as column separator.
Columns for import:
COMMAND | mandatory |
PERIOD | mandatory |
VESSELNO | mandatory if NUMORGID is not used |
NUMORGID | mandatory if VESSELNO is not used |
ENTRYCODE | mandatory |
PIN | mandatory |
RANK | optional |
QUANTITY | optional |
RATE | optional |
AMOUNT | mandatory |
ENTRYFIELD4 |
|
ENTRYFIELD5 |
|
ENTRYFIELD6 |
|
ACCOUNTDIM3 |
|
ACCOUNTDIM4 |
|
ACCOUNTDIM5 |
|
ACCOUNTDIM6 |
|
ACCOUNTDIM7 |
|
ACCOUNTDIM8 |
|
ACCOUNTDIM9 |
|
TEXT |
|
Fields explanation
COMMAND is mandatory and required in order for the system to import the record in question.
The following commands may be found:COMMENT - This record will not be imported. It most likely consists not of an import info, but various other data.
<blank> In the event the field is blank, then this is a record that will be imported.
NUMORGID is vessel org. ID that you can check in Organization Structure.
VESSELNO is vessel org. code that you can check in Organization Structure.
PERIOD must be entered in format YYYYMM.
ENTRYCODE is the Entry Code number
QUANTITY is number of days/hours for entry record
RATE is daily/hourly pay rate
TEXT normally contains comments.
ENTRYFIELD4-6 are fields on payroll entries used to store various info.
ACCOUNTDIM3-9 are entry accounting (cost) dimensions. NB: the system normally is setup to set correct info in accounting dimensions during calculation for the variable entries as well, therefore it is optional for import.
Samples of import files
File that includes only mandatory columns, all COMMAND rows are blank, which means data will be imported starting the 2nd row.
File that includes optional columns, all COMMAND rows are blank, which means data will be imported starting the 2nd row.
File that includes optional columns, some COMMAND rows are set with COMMENT - such rows contain additional data and will not be imported, in case of below sample, the import will start with 9th row.
Import process
You can find the Import Payroll Entries utility in Tools > Import list
...
In the next window:
Select file
Select correct column separator used in your file.
Warning If you select a column separator different from what you used in the file, this will lead to import error.
Use "Skip entries with existing correspondent entry" option if your import file contains entries from previous import - the system will skip them to avoid duplicates.
Archive the import log file.
When import is finished, the system will show you a message for successful or failed import and log file listing how many entries were created (in case of success) or reason for import failure.
| Tip |
|---|
If payroll module was open at the moment of import, please remember to refresh the screen before checking the imported entries on a person. Recalculate the persons to have the imported entries be included in persons' wages. |