Payroll Export

Hc Pay And JV Export

Overview

This Entity includes the specification of Pay Export and JV export. The Pay and JV Export window should include 2 filters (Interface and Export type) and a selection tab.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ► Hc Pay And JV Export

Hc Pay And JV Export screen Fields

Fields	Description
Interface	Allows selecting the interface for which the export is performed.
Export Type	Two options are available in the Export Type: "Pay Data" and "Manually Created JV's". The default should be "Pay Data"
Filename to Export	Pay Entitlement Code. The size is as per the size of the External Field corresponding to External Field Entitlement.
Selection Tab	The User will select from the List of elements within The Concept selected.
Fiscal Period	It includes the Employee Classes use during Pay Process.
Transaction Type	Two options are available in the transaction type: Summarized and Detailed
Total Selected	The amount will be displayed

Pay and JV Export Log

Overview

This Entity includes the list of Pay Export, for the current fiscal year, if the interface as selected under the Pay and JV Export screen are Export Pay. This Entity includes the list of Pay Export, for the current fiscal year, if the interface as selected under the Pay and JV Export screen are Export Pay.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ► Hc Pay And JV Export Log

Hc Pay And JV Export Log screen Fields

Fields	Description
Id	Unique identifier of the Log, generated by the system.
File Name	Corresponds to the name of the file to be exported.
Created Journal Voucher	Every time a transaction is created in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts.
From Batch No	Batch Numbers are attributed sequentially to all export lines. This field indicates the first batch number used for this export file.
To Batch No	Only applicable if export files are used. This field indicates the last batch number used for the export file.
Export Date	Date at which the file was exported, generated by the system.
No. of Transactions	Number of transactions in the exported files.
Value	For the pay export functionality, this field corresponds to the monetary value of all transaction lines that are exported.
Status	Current status of the file. Possible values are:"In Process", "Exported", "Rollback", and "Cancelled". "In Process" implies that the file is currently being executed. "Exported" implies that the file was exported, and "Rollback" indicates that the export was reversed using the Rollback icon.
Transactions from JV Tab	Information fetch from JV transactions.
Forecasting Pay Transaction Tab	This tab includes additional information on the distribution of the transactions contained in the payroll file after all Process Filters (File Name, Import/Generate, Action, Error and Other Selection) are applied.

Payroll Export Log

Overview

Payroll Export Log includes the list of Pay Export, for the current fiscal year, if the interface as selected under the Pay and JV Export screen is Export Pay.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ► Payroll Export Log

Payroll Export Log screen Fields

Fields	Description
Id	Unique Identifier for each record
Active	If unchecked the Log is not available.
Export Date	Date at which the file was exported, generated by the system.
Journal Voucher	Every time a transaction is created in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts.
File Name	Corresponds to the name of the file to be exported.
From Batch No	Batch Numbers are attributed sequentially to all export lines. This field indicates the first batch number used for this export file.
To Batch No	Only applicable if export files are used. This field indicates the last batch number used for the export file.
No Of Transactions	Number of transactions in the exported files.
Value	For the pay export functionality, this field corresponds to the monetary value of all transaction lines that are exported.
Status	Current status of the file. Possible values are:"In Process", "Exported", "Rollback", and "Cancelled". "In Process" implies that the file is currently being executed. "Exported" implies that the file was exported, and "Rollback" indicates that the export was reversed using the Rollback icon.

Support Entities

External System Definition

Overview

The External System Definition allows linking the import, generation and export components of the interface.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► External System Definition

External System Definition Screen Fields

Fields	Description
External System Definition ID	This is a unique value, generated by the system.
Language	As per the country language.
Description	Short Description of the External System Definition Group.
Export Interface	Pay Export Interface Definition selected from a list of Interface Definition with the set to "PayExportS" or "PayExportE".
Data Source	Data Source for the Export Interface selected from a list of Interface Definition with the set to "PayImportS" or "PayImportE".
Active	Default is True. If set to false, the External System Definition is not available.

Link Organizations to Financial Codes

Overview

This entity includes the list of Elements used as trigger points for the Multiple Offset functionality and associated Department Code from the Pay Import File.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► Link Organizations to Financial Codes

Link Organizations to Financial Codes Screen Fields

Fields	Description
Application Id	This is a unique value, generated by the system.
Active	Default is True. If set to False, the record cannot be used in transactions.
Concept	The Concept of COA from which the element will be selected
Element	The element that will be used as the trigger point for the Multiple Offset functionality, selected from the list of elements from the Concept.
Department	Department ID associated to the Element under the Pay Import File. The Department ID will be entered by the user.

Offset Codes for Created JVs

Overview

This entity includes the Offset Codes for the Journal Voucher created under Financials if Generation of JVs or Generation of Export File for Pay Export is set to "Generation of JVs. Different Offset Codes can be specified for different COA Elements if System Parameter Use Multiple Offset is set to True.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► Offset Codes for Created JVs

Fields	Description
Application Id	This is a unique value, generated by the system.
Active	Default is True. If set to False, the record cannot be used in transactions.
Concept	The Concept of COA from which the element will be selected
Element	The element that will be used as the trigger point for the Multiple Offset functionality, selected from the list of elements from the Concept.
Pay Transactions Offset Code	Offset code for the JV created by the Pay Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code.
Journal Voucher Offset Code	The default is Offset Code specified under Offset code for the JV created by the Manual JV process, that the user will select from the list of Offset Codes under Transaction Group Offset Code.
Month-End Accruals Offset Code	The default is Offset Code specified under Offset code for the JV created by the Month-End Accruals Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code.
Accruals Reversal Offset Code	The default is Offset Code specified under Offset code for the JV created by the Accruals Reversal Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code.
Liabilities Offset Code	Offset code for the JV created by the Banks and Liabilities Process, that the user will select from the list of Offset Codes under Transaction Group Offset Code.
Paye Offset Code	Offset code for the PAYE created by the PAYE Export (in Previous Fiscal Year), that the user will select from the list of Offset Codes under Transaction Group Offset Code.

Pay Export Validations

Overview

The Pay Export Validations Entity is tied to the Action drop-down menu of the Interface Definition of the Pay Export. It allows inserting a list of accepted values for a specific field, which may be used to determine whether the Action specified for the record, under the Interface Definition will be applied or not.

If the value returned by the record of the Interface Definition matches the Calculated Value contained in this Validation Entity, then the Action specified for the record will be ignored. However, if the value returned by the record of the Interface Definition is not included in the Validation Entity, then the Action specified for the record will be applied.

Navigation

Human Capital ► Payroll and Financial ► Payroll Export ►Support Entities ► Pay Export Validations

Pay Export Validations Screen Fields

Fields	Description
Pay Export Validation ID	Unique Pay Export Validation ID generated by the system.
Interface ID	Should be a drop-down list showing the Interface Name from Interface Definition attribute with the set to "PayExportS" or "PayExportE". or "AccrualsExportS", or "AccrualsExportE".
External Field ID	External Field from the Interface Definition of the Pay Export, selected from the list of External Fields for the selected Interface ID.
Calculated Value	Identifies a possible value against which the External Field will be validated.
isActive	Default is True. if set to false, the Validation is not available.