Skip to main content

Auto-create AP Invoices for Union Calculations

A
Written by Andy Temple
Updated over 3 weeks ago

***NOTE: THIS IS A US SPECIFIC TOPIC.***

Overview

In Coins ERP+, users could auto-create AP invoices for Payroll calculations such as child support, etc., but the union files did not support this setup. The ability to auto-create Accounts Payable Invoices based on union Calculations is available in Payroll for both Fringes Not in Pay and Deductions. This alleviates the burden of users having to manually key these invoices into Accounts Payable individually.

Union Calculation Summary

The Supplier, Invoice Txn Type, and Separate Invoice for Each Deduction fields are available in the General Info layout in Payroll > Global Setup > Unions > Union Calculations tab > Union Calculation Summary > Main tab, as shown in

Union Calculation Summary Screen

Supplier

The supplier account number.

Invoice Txn Type

The invoice transaction type that is set up in Accounts Payable. The transaction type found in parameter PLCSTYPE cannot be used for union transactions.

Separate Invoice for Each Deduction

If multiple deductions are taken of the same deduction type on a paycheck, this read-only field specifies whether an invoice is created with multiple distribution lines (N) or a new invoice is generated for each deduction (Y). If set to N, the deductions use the same Pay Item; Y is for deductions to use specific Pay Items.

This field can only be checked if the Invoice Txn Type field is being used in the Accounts Payable PLCSTYPE parameter value. This Invoice Txn Type is most commonly used for child support and other garnishments.

For union deductions, this field should not be checked, and the Invoice Txn Type used for union deductions cannot be set in the PL Parameter PLCSTYPE.

Costing Workbench

PL Analysis Report

The PL Analysis Report generated in Payroll > [Frequency] Payroll > Costing Workbench includes Invoices created from union Calculations.

Validate Batches

The Validate Batches action run in Payroll > [Frequency] Payroll > Costing Workbench validates Invoices that are created from union Calculations. Only Deductions and Fringes Not Included in Pay are processed.

Post Batches

The Post Batches action run in Payroll > [Frequency] Payroll > Costing Workbench creates Invoices from union Calculations. Previously, Create Invoices only retrieved this information from the Employee Cost record for Pay Calculations.

Did this answer your question?