AX7 T&A: Payroll transfer and export


After pay types are created and approved there will be payment lines ready for transfer to payroll. The records for payment lines are created and there is a flag on each post showing whether or not the transaction has been exported. When transferring payments from AX we use a periodic grouping by the means of Period types. This is a shared feature between many different modules and situated in the Project module. You can create your own periods and can choose from a set of different types of period intervals. I normally use the ledger type, but have created some weekly or monthly offset types of payment periods. Workers can be grouped to different payment periods. It is then possible to do different exports for different workers, so in some cases you might even have similar period types with different names (for instance if exported to different systems, but in similar periods).

Go to Time and attendance > Setup > Payroll > Period types.

AX7_TA_PeriodTypes.png

After you have created a period type, make sure to generate the periods.

AX7_TA_PeriodTypesGeneratePeriod.png

A period has a from and to date and a nice name to go with it.

AX7_TA_PeriodTypesPeriod.png

Generate payroll file

The path for the exported file is set up at in the general Time and attendance parameters. To execute the export go to: Time and Attendance > Maintain payroll > Transfer to pay

AX7_TA_TransferToPay.png

Select a payment period and put in a pay date. The export will do an export for the period which the day resides, so if you select 04.01.2015 and the period is a Monthly type. It will export all transactions within 01.01 to 31.01. You can even retransfer transactions. This will ignore the “Transferred” flag on the payment line. The result of this is a comma separated file. The framework is made so that you can create your own type of exports.

Note: Only the pay types that are checked to be included in the export will be transferred.

AX7_TA_PayTypeExportMarked.png

 

Go to the AX 7 – Time and Attendance guide page

2 thoughts on “AX7 T&A: Payroll transfer and export

  1. “Generate payroll file, The path for the exported file is set up at in the general Time and attendance parameters. ”
    Fredrik, where do you find this path setup ? I get an internal error in our environment when we do “Transfer to Pay” and Microsoft is struggeling to figure out why. thanks Nic

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s