AP controls
Note
This topic only applies if the PR to AP interface is enabled in ActivityHD.
If the Payroll to AP interface is enabled, your system includes the AP control entity. AP controls carry all the information needed to post from Payroll to AP to generate AP invoices. AP controls are assigned to garnishment records, to PRCode segment items for taxes and deduction codes, and can be assigned on payroll check lines.
Create an AP control
- In the Navigation pane, highlight the Payroll/Human Resources > Setup > AP Controls folder.
- Click . The New AP Control window opens.
- Enter a unique Code for the AP control.
- Enter a Description of the AP control.
- In the Vendor field, select the vendor the AP control applies to.
- From the Frequency drop-down list, select how often items with this AP control should be posted to AP. Your options are:
- Weekly
- Biweekly
- Semimonthly
- Monthly
- Quarterly
- Yearly
-
In the Calendar field, select the calendar with the periods you want to use to group check lines for invoice creation.
Note
If you select a "Quarterly" calendar, Post PR to AP creates separate invoices based on the quarter of the check lines' liability dates.
In general, check lines are combined on the same invoice if all the following are true:
- same AP control
- same liability account
- same calendar period, or no calendar period
- Combine flag is set on the AP control
- same invoice date and GL date
- same invoice type (debit/credit)
- If the AP control needs to produce tax deposits, select the Tax Deposit Type.
- In the Terms field, select the payment terms to apply to invoices with this AP control.
- In the AP Account field, enter the AP account or account mask for the AP liability account to use with this AP control. This field defaults from the selected vendor's default AP account mask. In the Post to AP process, this account mask combines with the payroll tax/deduction liability account to produce the AP invoice liability account.
- In the Invoice Number field, enter the literal text and/or keywords to use to derive the invoice numbers for invoices with this AP control.
- In the Invoice Description field, enter the literal text and/or keywords to use to derive the invoice descriptions for invoices with this AP control.
- In the Invoice PO # field, enter the purchase order number to use on invoices with this AP control, if applicable.
- In the Invoice Batch field, enter the batch name to use for the AP invoices produced with this AP control.
- In the GL Batch field, enter the batch name to use for the GL entry that results when the invoices with this AP control are merged.
- If you want to combine multiple check lines on one AP invoice, mark the Combine checkbox. Check lines are combined by AP batch/vendor/AP liability account/invoice date. If you prefer one invoice per check line, leave this checkbox cleared. Check lines for taxes should be combined; garnishment check lines should not be combined.
If you want to enable Quick Pay when posting Payroll check lines to AP for check lines with this AP control, continue at step 17. Otherwise, skip to step 23.
- From the Type drop-down list, select the payment type. Valid options are:
- Check
- EFT
- Manual
- Enter a name for the AP payment Batch.
- If you selected "Manual" in the Type field, the Reference field is enabled. Enter a reference note for the manual payment.
- Enter a name for the payment GL Batch.
- In the Bank field, select the payment bank account.
- In the Discount field, select the payment discount account.
- Save the new AP control.
If the AP control associated with a Payroll check line has Quick Pay set up, Quick Pay payments are created on AP invoices when check lines are posted to AP and the payments are automatically merged when the invoice is merged. If a tax deposit type is provided on the AP control, the tax deposit is also automatically created.
Purpose
The AP Controls Listing provides a list of the AP controls defined in Payroll. This feature is only available if you have the PR to AP interface installed.
Content
For each AP control included on the report, the listing shows:
- AP control code
- AP control description
- vendor
- frequency
- AP account
- invoice number
- invoice description
- invoice batch
- GL batch
- terms
- PO number
- whether the control combines multiple check lines on an invoice.
In addition, you can include one or more of the following:
- timestamps
- memos
- custom fields.
The following total appears on the report:
- record count.
Print the report
- In the Navigation pane, highlight the Payroll/Human Resources > Setup > AP Controls folder.
- Start the report set-up wizard.
- To report on all or a filtered subset of AP controls:
- Right-click the AP Controls folder and select Select and Report > AP Controls Listing from the shortcut menu.
- On the Selection tab, define any filters to apply to the data.
- To report on specifically selected payroll groups:
- In the HD view, select the AP controls to include on the report. You can use Ctrl and/or Shift selection to select multiple records.
- Click .
- To report on a particular AP control from the AP Control window:
- In the HD view, locate and double-click the AP control to report on. The AP Control window opens with the AP control loaded.
- Click .
- To report on all or a filtered subset of AP controls:
- Select the Options tab.
- Mark the checkbox(es) for the additional information to include:
- Timestamps
- Memos
- Custom Fields (only visible if custom fields are set up)
- Select the Output tab.
- In the Design field, look up and select the report design to use.
- In the toolbar, click the icon for the type of output you want:
- - Provides access to two preview options.
- Preview - Click the icon or click the drop-down arrow and select Preview from the drop-down menu to view the report in the Crystal Reports viewer.
- Preview to PDF - Click the drop-down arrow next to the icon and select Preview to PDF to view the report in the PDF reader.
- - Opens the Print dialog so that you can select and configure a printer and then print a paper copy of the report.
- - Opens the Report Email dialog so that you can address and compose an email that the report will be attached to. For best results, ensure your email client is running before you attempt to send a report via email.
- - Opens the Export Report dialog so that you can save the report to a file. File types include Crystal Reports (.rpt), PDF (.pdf), Microsoft Excel (.xls), Microsoft Word (.doc), rich text (.rtf), and XML (.xml).
- - Provides access to two preview options.
Data extensions
The following data extension is available for the report:
- AP controls
AP Control Record ID
AP Control tab
The vendor to which the AP control applies.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
- Weekly
- Biweekly
- Semimonthly
- Monthly
- Quarterly
- Yearly
The calendar with the periods to use to group check lines for invoice creation.
Note
If you select a "Quarterly" calendar, Post PR to AP creates separate invoices based on the quarter of the check lines' liability dates.
In general, check lines are combined on the same invoice if all the following are true:
- same AP control
- same liability account
- same calendar period, or no calendar period
- Combine flag is set on the AP control
- same invoice date and GL date
- same invoice type (debit/credit)
If tax deposits will be created using this AP control, enter the tax deposit type to create.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
The payment terms to apply to invoices with this AP control.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
The AP account or account mask for the AP liability account you want to use with this AP control. This field defaults from the selected vendor's default AP account mask. When you post invoices to AP, this account mask combines with the payroll tax/deduction liability account to produce the AP invoice liability account.
Press F2 to open the Account Expand dialog box where you can look up an account number, find an account number by its alias, build the account number by segment, or view setup and setup sources.
Press F3 to look up the account.
If an account is already selected, you can press F4 to open the record in the Account window.
- Check
- EFT
- Manual
Custom tab
This tab is visible if custom fields exist for the entity. At a minimum, if there are custom fields, a Fields subtab will be present. One or more additional categories of subtabs may also be visible.
Fields subtab
This tab prompts for values for any custom fields set up for entity records of this entity type. Respond to the prompts as appropriate.
References subtab
This tab is visible if other records reference the current record.
Example
Suppose a custom field exists on PRCodes that references an ARCode. On the ARCode record, on the Custom > References subtab, you can view all the PRCodes which reference that ARCode.
Exchange Folder subtab
This tab is visible only if you set up a custom field with a data type of "Exchange Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified Exchange folder.
File subtab
This tab is visible only if you set up a custom field with a data type of "File". The label on the tab is the name assigned to the custom field.
This tab renders the contents of the specified file according to its file type.
Internet Address subtab
This tab is visible only if you set up a custom field with a data type of "Internet Address". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified web page.
Network Folder subtab
This tab is visible only if you set up a custom field with a data type of "Network Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified network folder.
Garnishments tab
The Garnishments pane shows the Garnishments HD view filtered to show all garnishments with the selected AP control.
Double-click a row in the pane to drill down to its record in the Garnishment window.
Segment Items tab
The Segment Items pane shows the Segment Items HD view filtered to show all segment items the selected AP control is assigned to.
Double-click a row in the pane to drill down to its record in the Segment Item window.
PRCodes tab
The PRCodes pane shows the PRCodes HD view filtered to show all PRCodes with the selected AP control.
Double-click a row in the pane to drill down to its record in the PRCode window.
Check Lines tab
The Check Lines pane shows the Check Lines HD view filtered to show all check lines with the selected AP control.
Double-click a row in the pane to drill down to its record in the Check Line window.
AP Invoices tab
The AP Invoices pane shows the AP Invoices HD view in Accounts Payable filtered to show all invoices created with the selected AP control.
Double-click a row in the pane to drill down to its record in the AP Invoice window.
AP Payments tab
The AP Payments pane shows the Payments HD view in Accounts Payable filtered to show all payments associated with the selected AP control.
Double-click a row in the pane to drill down to its record in the Payment window.
Attachments tab
The Attachments tab is visible if any record for a given entity has an attachment. If the Attachments tab is not visible, this implies that no record of the entity type has an attachment on it; however, once an attachment is added to any record of the entity type, the Attachments tab will become available.
Other tab
AP controls security
Common accesses available on AP controls
Report Email dialog
- Windows user default account. Sends email using the user's Windows default email account. For most users, this is the account configured in Outlook or another email client application.
- Server personal. Sends email using the email configuration for the system or company server and the email address on the current user's authorized user record. The authorized user record must have a confirmed email address.
- Server generic. Sends email using the email configuration and "from" address for the system or company server. This option requires "Send generic" access to the Server Email resource.
AP invoice expression keywords
The following keywords are available in expressions for AP invoice numbers and AP invoice descriptions:
- <Garnishment Case>
- <Garnishment Description>
- <Garnishment State>
- <Employee Code>
- <Employee First Name>
- <Employee Middle Name>
- <Employee Last Name>
- <Employee First Name First>
- <Employee Last Name First>
- <Check Merge #>
- <Check Date>
- <Check Date Year>
- <Check Date Month>
- <Check Date Day>
- <Pay Period Begin Date>
- <Pay Period Begin Date Year>
- <Pay Period Begin Date Month>
- <Pay Period Begin Date Day>
- <Pay Period End Date>
- <Pay Period End Date Year>
- <Pay Period End Date Month>
- <Pay Period End Date Day>
5225 S Loop 289, #207 Lubbock, TX 79424 806.687.8500 | 800.354.7152 |
© 2024 AccountingWare, LLC All rights reserved. |