| Excerpt |
|---|
This article describes how to create an .csv file that can be imported to Xledger |
Description
If you use Xledger as your Accounting System, you can at the end of the month generate a .CSV file via our Custom Export tool.
Export - Step-by-Step
If you run payroll for more than one company, you will need one export for each one set up in General Codes.
To export the file:
Go to Tools | Export | Custom Export | Xledger - XXX
Select the company you want to export a file for
Input information in the dialogue window as follows:
Payroll Period - The payroll period you want to do an export for. You can export both the open payroll period and any closed payroll periods.
Voucher No. - This number will become part of the file and be the Voucher number in Xledger
Export Number - This should always default to 1. Currently there is not a possibility to do a second export with only selected records.
Select the Path where you want to export the file to by clicking on the 3 dots button
Setup of the Export
General Codes
The export is created in General Codes by importing the attached Template file.
...
...
To import this template you need to take the following steps.
Save the Xledger.xml file above to your computer.
Then go to Adonis Personnel Manager and Setup | General Codes
Select Custom Export | Export
Give the export a Code (max 10 char) and a Name in the Text field
Select Template | Import in the bottom of the window
Find the file in the location where you saved it, select it and click Open
Click OK and save. You are now ready to start using the export
Access Rights
You have three options for setting access restrictions to the Custom exports.
All Users on a specific level should have no access to any export tools
All Users on Levels that has access to Custom Exports should be able to use all Exports.
Users on one level should only have access to specific Exports
The below describes how to make the correct settings in the Adonis Control Centre, by using the Security code available in General Codes.
All Users on a specific level should have no access to any export tools
Set Export to N under Routines tab in the Adonis Control Centre
All Users on Levels that has access to Custom Exports should be able to use all Exports.
Set the Security Code on each of the Custom Exports to the same number, e.g. 200 (The number is random)
Go to the Adonis Control Centre. Select the User Level that should have access and go to General Codes - Custom Export | Export
Select Write access on one of the Custom Exports and all exports with same code in the Field column will be granted access.
Users on one level should only have access to specific Exports
Set the Security Code on each of the Custom Exports to a different number, e.g. 200, 201, 202 (The numbers are random)
Go to the Adonis Control Centre. Select the User Level that should have access and go to General Codes - Custom Export | Export
Select Write access on one of the Custom Exports and only exports with same code in the Field column will be granted access.
Defining Cost Dimensions
The Cost dimensions you have set up in Payroll can be part of the export for any Account numbers that has this selected. In this template file, only the dimension in the field Accountdim2, which is normally a vessel, is part of the export and the CODE of the vessel will be included for the selected accounts.
To enable the cost dimension on the individual GL accounts;
Go to Set up | Tables | Payroll | Accounts
Set a tick in Dim2 for the accounts that should have the amounts split by the vessel accounting code in the file.
Adonis Template file and SQL statement
| View file | ||
|---|---|---|
|
...
...
| View file | ||
|---|---|---|
|
...
| View file | ||
|---|---|---|
|
...
...
Xledger file Specification
| View file | ||
|---|---|---|
|
...
...
| View file | ||
|---|---|---|
|
...
| View file | ||
|---|---|---|
|
...
| View file | ||
|---|---|---|
|
...
Sample Generated File in APM
| View file | ||
|---|---|---|
|
...