Creating Net Payment and Exceptions Reports

Once the GP_PAYMENT and GPFR_PAYMENT tables are populated, you can generate the following Structured Query Reports (SQRs):

• Payments report: lists details of each payment.

• Exceptions report: lists negative net payments excluded by the system when performing retroactive calculations.

  Global Payroll provides rules to prevent the calculation of negative net payments in the current segment; however, when processing periods retroactively, the system may generate negative payments under some conditions. If this occurs, the French banking process ignores the negative amounts (as French banking norms do not authorize negative net payments), and you can run the exceptions report to determine whether negative payments have been excluded from the banking file.

  Note: Note that the exceptions report is available only after payroll has been finalized and the banking process has been run, at which point it is too late in the process to modify payroll elements to prevent a negative net calculation. For this reason, Global Payroll for France provides an additional check for negative payments earlier in the calculation process: if a payee receives as negative net payment, the system issues a warning message that can be viewed on the Payee Messages page immediately after payroll has been calculated and before the payroll run has been finalized. You can then modify payroll data as needed to eliminate the negative payment before finalizing payroll and running the banking process.

Use the Net Payment Report FRA page (GPFR_BANK_REPORT) to select the Calendar Group ID and Pay Entity to use for the reports.

Navigation:

Global Payroll & Absence Mgmt > Payment Processing > Net Payment Report FRA > Net Payment Report FRA

This example illustrates the fields and controls on the Net Payment Report FRA page. You can find definitions for the fields and controls later on this page.