How to Export a Batch

1.

Go to Portal > Finance Integration > Export.
The Export screen opens.

Click on the Export Type field and select the types of financial data that is to be exported in this batch by clicking on each relevant export type. For example, if you want to export wages and sales transactions only, select Wages and Sales. Alternatively, select An y if you want to export all transactions types.

Note:
The export types that are available can be limited based on an option in General Maintenance Settings. Therefore, the export types that you can select will depend on how the Finance Integration module has been configured.

4.

Click on the Posting Date field and use the calendar control to select the date that will determine the financial reporting period to which the transactions in the batch will be allocated in your finance system.
The date you select is displayed in the Posting Date field.

5.

On the Pay Batch tab, select any filtering criteria if you want to narrow down the pay-related transactions that you want to export in this batch. Note that fields on the Pay Batch tab may be unavailable depending on the type of transactions you have chosen to export.
For more information about the fields available on the Pay Batch tab, see Using the Export Screen.

6.

On the Invoice tab, select any filtering criteria if you want to narrow down the sales-related transactions that you want to export in this batch. Note that fields on the Invoice Batch tab may be unavailable depending on the type of transactions you have chosen to export.
For more information about the fields available on the Invoice tab, see Using the Export Screen.

7.

Click .
The Export List section of the screen is populated with items that meet the export criteria you have selected.

8.

Using the columns of information shown in the Export List section of the screen, review the items that are to be included in the batch. For more information about the columns that are displayed within the Export List, see Using the Export Screen.
Note that the Export Totals at the top of the Export List section of the screen show the total monetary value of each export type that will be exported, based on the items that are currently selected in the list.

9.

If necessary, un-tick any items that are listed in the Export List section of the screen that you do not want to include in the export batch.
The Export Totals at the top of the Export List section of the screen update to reflect the items that are selected for inclusion in the batch.

10.

When you are ready to export the batch, click .
Validation is performed to ensure that the batch can be created successfully and if the validation succeeds a confirmation message is displayed, showing the unique export batch ID, and the batch is queued for processing.

Error Message

Description/Resolution

Batch creation failed. The following items have already been exported:
<Item ID> in batch
<Batch ID>
…

Another user has exported one or more items, which are selected for inclusion in your batch, in another batch before you attempted to export the batch. Since the same item cannot be exported multiple times, the export has failed as it included items already exported in another batch.

To overcome this error, close the error message and click on the Export screen to refresh the list of items that are shown in the Export List section of the screen. Only items that have already been exported will be automatically removed from the list. You can then attempt to export the batch again.

Warning:
If you deselected one or more items that you did not want to export prior to attempting to initially export the batch, those items will be selected again when you refresh the list. Therefore, make sure you deselect any items that you do not want to export before attempting to export the batch again.

Export failed. No GL account mapping has been defined in maintenance.

GL account segment mapping has not been configured or is not defined for the export date of the batch.
Make sure that the required GL account segment mapping is configured in Portal > Settings > Maintenance > Finance Integration > GL Account Segments and that the validity period of the configuration covers the export date of the batch.