This page (revision-73) was last changed on 29-Sep-2022 11:27 by Lilia Urtan

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
73 29-Sep-2022 11:27 13 KB Lilia Urtan to previous
72 26-Nov-2021 10:22 13 KB Karen Parrott to previous | to last
71 26-Nov-2021 10:22 13 KB Karen Parrott to previous | to last
70 26-Nov-2021 10:22 13 KB Karen Parrott to previous | to last
69 26-Nov-2021 10:22 13 KB mmcfarland to previous | to last
68 26-Nov-2021 10:22 13 KB mmcfarland to previous | to last
67 26-Nov-2021 10:22 13 KB kparrott to previous | to last
66 26-Nov-2021 10:22 13 KB kparrott to previous | to last
65 26-Nov-2021 10:22 13 KB kparrott to previous | to last
64 26-Nov-2021 10:22 13 KB kparrott to previous | to last
63 26-Nov-2021 10:22 11 KB kparrott to previous | to last
62 26-Nov-2021 10:22 11 KB khiggs to previous | to last
61 26-Nov-2021 10:22 10 KB mmcfarland to previous | to last

Page References

Incoming links Outgoing links
UPDISBV
UPDISBV

Version management

Difference between version and

At line 4 changed 2 lines
Personality handles payments to Accounts Payable vendors for selected employee deductions. This process extracts from closed employee pays and populates the disbursement tables so that individual vendors can be paid. Vendors reside in a separate ‘Payroll Code’ and can be paid in a separate pay cycle from regular employees. Vendor payments may also be extracted for payment in some other supporting system. This capability is of course unique in each situation. This process describes how vendor payments are placed into the disbursement tables and not how they are actually paid.
\\Note: All converted pay headers/pay lines should be stamped as posted otherwise the first UPDISBV that is generated will take a considerable amount of time.
Intent
This document describes the setup and processes that allow Personality to handle payments to Accounts Payable vendors for selected employee deductions. This process extracts from closed employee pays and populates the disbursement tables so that individual vendors can be paid. Vendors reside in a separate ‘Payroll Code’ and can be paid in a separate pay cycle from regular employees. Vendor payments may also be extracted for payment in some other supporting system. This capability is of course unique in each situation. This process describes how vendor payments are placed into the disbursement tables and not how they are actually paid.
At line 7 changed one line
There is a separate section, [Child Support Direct Deposit|UPDISBV#ChildSupportACHDirectDeposit], that outlines the setup needed to use the ACH interface for direct payment to vendors for Child Support Payments.
There is a separate section at the end of this document (Child Support Direct Deposit) that outlines the setup needed to use the ACH interface for direct payment to vendors for Child Support Payments.
At line 10 changed 4 lines
The Define Pay Component ([IPPC]) screen determines which components are to be picked up by [UPVEND].
On the [Accts/Arrears|IPRLU#AcctArrearsTab] tab, record the default Vendor number in the AP Vendor field. This vendor could be simply a ‘Dummy’ vendor if the same pay component is used for multiple vendors. In this situation, the vendor is entered in [IPSN] or in [IPPH] when the transaction is keyed.
The Define Pay Component (IPPC) screen determines which components are to be picked up by UPVEND.
On the ‘Accts/Arrears’ tab, record the default Vendor number. This vendor could be simply a ‘Dummy’ vendor if the same pay component is used for multiple vendors. In this situation, the vendor is entered in IPSN or in IPPH when the transaction is keyed.
At line 16 changed 2 lines
!!Pay Component Rules Setup Requirements
On the [PC Rules|IPRLU#PCRulesTab] tab, ‘Enter Vendor Code’ must be entered in the Reference field.
Pay Component Rules Setup Requirements
On the PC Rules tab, the reference column must be marked as ‘Enter Vendor Code’
At line 19 removed one line
!!!PREFERENCE REQUIRED FOR UPDISBV
At line 21 removed one line
UPAUDT ensures that all Vendor Items have the PPL reference Indo column populated with the Vendor Code.
At line 23 changed one line
The VENDOR MODULE preference must be set up on IMFN for the UPDISBV function. The valid values are UPVEND and UPDISBV.
Accounts Payable Vendors Lexicon
The list of valid vendor numbers is stored in a user-defined lexicon with the lexicon name ‘X_AP_VENDORS’. These vendor numbers must be the exact vendor number to be passed to the external Accounts Payable system when any interface file is required.
Both the ‘Display Value’ and the ‘Meaning’ should contain the vendor name.
Vendor Payment Transactions
Recurring AP transactions can either be entered on the Maintain Sundry Pay/Deductions (IPSN) screen, or entered individually as transactions in IPPH. The vendor number is supplied on the Line Info tab
At line 25 removed 3 lines
* A value of UPDISBV will result in UPAUDT __NOT__ populating the Vendor Code lines.
* A value of UPVEND will result in UPAUDT populating the Vendor Code on the pay lines in IPPH.
* If the preference is not defined, UPAUDT will update the pay lines with a Vendor Code.
At line 29 changed one line
Clients who use UPDISBV __MUST__ define this preference with a value of UPDISBV so the Vendor Code is not populated on the pay lines. Failing to do so will cause UPDISBV not to function properly.
Vendor Payrolls
All vendors MUST be in a separate payroll from any other employees. The payroll can share a check series with the regular payroll or use a separate series.
If vendors are paid on difference frequencies, then separate Vendor payrolls can be set up. In this situation, the vendors must be processed in separate execution of UPDISBV.
At line 31 removed 3 lines
!!Set Up Instructions
# Set up the preference in IMFN for the UPVEND function. Enter VENDOR MODULE in the Preference field and UPDISBV in the Value field.
# Add a new batch and pay. Any existing pay headers that may have been processed through UPAUDT will not work properly.
At line 35 added 3 lines
Vendor Units
Vendors must be set up in separate units from regular employees.
At line 36 changed 3 lines
!!Accounts Payable Vendors Lexicon
The list of valid vendor numbers is stored in a user-defined lexicon with the lexicon name [X_AP_VENDORS]. These vendor numbers must be the exact vendor number to be passed to the external Accounts Payable system when any interface file is required.\\ \\
In [IMLN], both the ‘Display Value’ and the ‘Meaning’ fields should contain the vendor name.\\ \\
Vendor Groups
Vendors must be set up in separate groups from regular employees.
At line 40 changed 2 lines
!!Vendor Payment Transactions
Recurring AP transactions can either be entered on the Maintain Sundry Pay/Deductions ([IPSN]) screen, or entered individually as transactions in [IPPH]. The vendor number is supplied on the [Line Info|IPSN#LineInfoTab] tab.
Vendor Job Codes
Vendors must be set up in separate jobs from regular employees.
At line 43 changed 3 lines
!!Vendor Payrolls
All vendors MUST be in a separate payroll from any other employees. The payroll can share a check series with the regular payroll or use a separate series.\\ \\
If vendors are paid on difference frequencies, then separate Vendor payrolls can be set up. In this situation, the vendors must be processed in separate execution of UPDISBV.\\
Vendor Department Codes
Vendors must be set up in separate departments from regular employees.
At line 47 removed 15 lines
!!Vendor Units
Within the Define Units [IDUN] screen, vendors must be set up in separate units from regular employees.\\ \For example, create a unit called 'Vendor'.
!!Vendor Groups
Within the Define Groups [IDGR] screen, vendors must be set up in separate groups from regular employees.\\ \For example, create a group called 'Vendor'.
!!Vendor Job Codes
Within the Define Jobs [IDJB] screen, vendors must be set up in separate jobs from regular employees.\\ \For example, create a job called 'Vendor'.
!!Vendor Department Codes
Within the Define Departments [IDDP] screen, vendors must be set up in separate departments from regular employees.\\ \For example, create a department called 'Vendor'.
!!Vendor Location Codes
Vendors must be set up in separate locations from regular employees.\\ \For example, create a location called 'Vendor'.
At line 63 removed 2 lines
!!Vendor Number
When a Pay Component for a Vendor who is paid for employee deductions entered in IPSN, the Actual Vendor Number is entered in the IPSN form and NOT in IPPC. If the Vendor Number is entered in both places, the vendor will get paid twice. The ONLY time a Vendor should be supplied in IPPC is for Vendors that are paid for deductions calculated in UPCALC. These would typically be for Benefit carriers and tax remittances. UPDISBV will not list these Setup Errors and Terminated so that Vendors are not overpaid. IPPC Setup will need to be corrected before UPDISBV will continue. To clarify, The Vendor can be supplied in IPPC OR in IPSN and NOT both places.\\When UPDISBV launches it goes through some Setup integrity checks and will terminate prematurely if it finds erronious setup situations like this.
At line 66 changed 2 lines
!!Vendor Employee Records (IEHR)
When UPDISBV is executed, vendors with a person code equal to the letter ‘V’ plus the vendor number are eligible to be processed. For example, if the vendor number id 200, then UPDISBV looks for an employee with the person code ‘V200’. If located, then a disbursement is created.
Vendor Location Codes
Vendors must be set up in separate locations from regular employees.
At line 69 removed 3 lines
!!UPDISBV – Disburse Vendor Payments
All vendors must be in a separate payroll from regular employees. Multiple vendor payrolls can be used if vendors are paid on a different cycle. Vendors can be individually selected for processing or all can be processed in a single execution.
At line 73 removed 2 lines
Vendor Pay Period must be selected and all disbursement records and pays created will be in this pay period.
All output from this process enters the vendor pay cycle as fully disbursed and is then ready for checks to be printed through [UPSTUBVC] and/or deposits to be processed through [UPSTUBD].
At line 57 added 3 lines
Vendor Employee Records (IEHR)
When UPDISBV is executed, vendors with a person code equal to the letter ‘V’ plus the vendor number are eligible to be processed. For example, if the vendor number id 2311, then UPDISBV looks for an employee with the person code ‘V2311’. If located, then a disbursement is created.
At line 78 removed 2 lines
----
!!Report Parameters & Filters
At line 81 removed 14 lines
||Report Parameters||
|Entity|Mandatory\\This field allows you identify the entity for which you wish to disburse a pay. This is used to filter the PPH records.
|Pay Run Number| Optional, Multiple, LOV Available, \\The pay run number of the pays to be selected. Multiple pay run numbers are allowed.
|Pay Issued From Date|Optional, Date, LOV Available \\The earliest issue date that will be used to determine which transactions to report.
|Pay Issued To Date|Optional, Date, LOV Available \\The latest issue date that will be used to determine which transactions to report.
|Vendor Entity|Optional\\This field allows you identify the Vendor entity for which you wish to disburse a pay. A warning message will be issued by the program if this field is not entered.
|Vendor Payroll|Optional\\This field allows you identify the Vendor payroll for which you wish to disburse a pay. A warning message will be issued by the program if this field is not entered.
|Vendor Pay Period|Optional\\This field allows you identify the pay period for which you wish to disburse a pay.\\This is used as an 'Up To' pay period and will pick up any prior period pays that have not yet been posted. A warning message will be issued by the program if this field is not entered.
|Vendor Pay Category|Mandatory\\This field allows you identify the pay period for which you wish to disburse a pay. A warning message will be issued by the program if this field is not entered.
|Sort Vendors By|Optional\\This field will allow you to determine the order in which the disbursements will be processed. For instance by destination, last name then first name. This sorting becomes the order that check numbers are assigned.
|Trial|Optional\\If YES, the Posted UPVEND UDF (for pay header in IPPH) will remain as 'N'.
|*Generate AP Interface|\\This must be set to YES to generate a File.
|Exception Level|Mandatory, Match, Multiple selections, LOV available.\\This field defines the exception level (report messages) required.
|User Comment|Optional\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
At line 96 changed 12 lines
||Interface File Parameters (*must complete for Generate File)||
|Interface Code| Mandatory, LOV Available\\Only those reports of the format “AP Interface” will display. Choose from the report \\formats created. The format “HL$AP” has been provided as a sample, but should \\be copied, and the copy edited, by the client before running this report. The report \\definition selected will determine the format of the output file (if any), as well as the \\columnar content of the report.
|Interface Directory| Mandatory, Text \\Must be a directory on the [data base server|DATA BASE SERVER] for which the current user (as signed onto the \\client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the \\‘TEMP’ directory on the server, not the local directory for the computer terminal \\being used.
|File Name| Mandatory, Text\\Enter the name of the file that will be created in the interface directory specified.
|File Format|Optional, Lexicon\\This field defines how the output file is to be formatted.
|Output Header/Trailer| Optional, Toggle\\If the file is to contain a header and trailer record then indicate ‘ON’.
|Accounting Date|Optional, Date, LOV Available\\The ‘Accounting' date will be printed on the report.
|Sum FILE by Vendor/PC |Optional, Toggle\\If the file is to be summarized by Vendor/PC this toggle must be ‘ON.’
|Pay Period Begin Date|Optional, Date, LOV Available\\The pay period begin date.
|Pay Period End Date|Optional, Date, LOV Available\\The pay period end date.
|AP Year (MH) \\ AP Year (MH)|These are customized fields.
|AP Period (MH) \\ AP Period (MH)|These are customized fields.
UPDISBV – Disburse Vendor Payments
All vendors must be in a separate payroll from regular employees. Multiple vendor payrolls can be used if vendors are paid on a different cycle. Vendors can be individually selected for processing, or all can be processed in a single execution.
Vendor Pay Period must be selected and all disbursement records and pays created will be in this pay period.
All output from this process enters the vendor pay cycle as fully disbursed and is then ready for checks to be printed through UPSTUBV and/or deposits to be processed through UUPDTB.
At line 69 added 4 lines
At line 110 changed 2 lines
!!Undisburse Vendor Payments
In situations where UPDISBV has been executed and must be backed out, the Undisburse Vendor Payments ([UPUNDISB]) screen can be executed to __undo__ the work from a previous execution of UPDISBV. [UPUNDISB] can also be used to undo executions of regular employee [UPCALC] executions.
Undisburse Pay Runs(s)
Overview
In situations where UPDISBV has been executed and must be backed out, the Undisburse Vendor Payments (UPUNDISB) screen can be executed to ‘Undo’ the work from a previous execution of UPDISBV. UPUNDISB can also be used to undo executions of regular employee UPCALC executions.
One or more pay runs can be handled in one execution of UPUNDISB.
At line 113 removed one line
One or more pay runs can be handled in one execution of [UPUNDISB].
At line 115 changed 13 lines
!!Child Support ACH Direct Deposit
This feature provides for the ability to pay Child Support deductions directly to the vendor (a recipient, for example, the child's mother), through the ACH interface in payroll. These vendors are set up in the same manner as any other vendor that receives direct payment through payroll.\\ \\
In addition to the payment record, these particular direct deposits will have an ACH ‘Addenda Record’ sent along with the payment record. This event is triggered by the existence of any of the Child Support user fields listed below. The [UPDISBV] process therefore will not create this special addenda record unless the information needed is supplied in the [IPSN] form where the recurring deduction is maintained.\\ \\
The UPDISBV report will show the Vendor and each payment with the associated ACH CHILD CARE ADDENDA field populated along with the amount for each employee. \\ \\
[{Image src='UPDISBV_ACHChildCare.jpg'}]
\\
!Child Support User Fields
There are four user fields that can be added to the table [P2K_PR_SUNDRY_LINES]:
||USER FIELD||OPTIONAL/MANDATORY
|[CS CASE IDENTIFIER|CS CASE IDENTIFIER (UDF)|CS CASE IDENTIFIER (UDF)]|Optional
|[CS CASE NUMBER|CS CASE NUMBER (UDF)|CS CASE NUMBER (UDF)]|Mandatory
|[CS MED INDICATOR|CS MED INDICATOR (UDF)]|Optional
|[CS FIPS CODE|CS FIPS CODE (UDF)]|Optional
At line 129 changed 7 lines
*The above User Fields must be set up on IMUF without underscores, ex. ‘CS CASE IDENTIFIER’
*Remember to refer to lexicon ‘X_YES_NO’ on the medical indicator, so that the value entered in [IPSN] can only be ‘Y’ or ‘N’.
*If these are set up without any data provided in [IPSN], then the [UPVEND] process will use the correct defaults without any problem.
*The names of these user fields must be exactly as shown (in upper case).
*A Minimum of 'Case Identifier' and 'Case Number' is required to create an addenda record.
*An employee must be paid 100% by check to have an addenda record.
*Information in these User Fields will cause the UPDISBV to generate individual payments and show separately on the UPDISBV report
Child Support ACH Direct Deposit
Overview
This feature provides for the ability to pay Child Support deductions directly to the vendor (likely the mother), through the ACH interface in payroll. These vendors (recipients) are set up in the same manner as any other vendor that receives direct payment through payroll.
In addition to the payment record, these particular direct deposits will have an ACH ‘Addenda Record’ sent along with the payment record. This event is triggered by the existence of any of the Child Support user fields documented in the pages following. The UPDISBV process therefore will not create this special addenda record unless the information needed is supplied in the IPSN form where the recurring deduction is maintained.
Child Support User Fields
There are four user fields that can be added to the table ‘P2K_PR_SUNDRY_LINES’ as shown below. Remember to refer to lexicon ‘X_YES_NO’ on the medical indicator, so that the value entered in IPSN can only be ‘Y’ or ‘N’. Case Number is mandatory, and the other three are optional. If these are set up without any data provided in IPSN, then the UPVEND process will use the correct defaults without any problem. The names of these user fields must be exactly as shown.
At line 137 changed one line
!Sundry Entry for ACH Child Support Data
Sundry Entry for ACH Child Support Data
At line 140 removed 3 lines
!Disbursement Addenda User Fields
UPDISBV will insert the ACH ‘Addenda Information’ as a user field named ‘ACH ADDENDA DATA’ attached to the disbursement. It can be viewed with the ‘UDF’ button in [IPDS]. This user field does not have to be added manually since UPDISBV will create it automatically the first time it is needed.
When [UPDTB] is executed to create the ACH interface file, an extra addenda record will be written if the above user field contains data. If the user field is empty, then the addenda record will not be created.
At line 144 changed 16 lines
!Addenda Layout
||ORDER||COMMENTS||CONTENT||Mandatory?||Field Type||Length
|1|Segment Identifier|DED|Y|ID|3
|2|Application Identifier|CS|Y|ID|2
|3|CS Case Identifier|XXXXXXXXX|Y|VARCHAR|1-20
|4|Pay Date|YYMMDD|Y|DATE|6
|5|Payment Amount|$$$$$$$$CC|Y|NUMBER|1-10
|6|Noncustodial Parent Social Security Number|XXXXXXXXX|Y|VARCHAR|9
|7|CS Medical Support Indicator|X|Y|VARCHAR|1
|8|Noncustodial Parent Name|XXXXXXXXXX|N|VARCHAR|1-10
|9|CS FIP Code|XXXXXXX|N|VARCHAR|5-7
|10|Employment Termination Indicator|X|N|VARCHAR|1
----
![Notes|Edit:Internal.UPDISBV]
[{InsertPage page='Internal.UPDISBV' default='Click to create a new notes page'}]
Disbursement Addenda User Fields
UPDISBV will insert the ACH ‘Addenda Information’ as a user field named ‘ACH ADDENDA DATA’ attached to the disbursement. It can be viewed with the ‘UDF’ button in IPDS. This user field does not have to be added manually since UPDISBV will create it automatically the first time it is needed.
When UPDTB is executed to create the ACH interface file, an extra addenda record will be written if the above user field contains data. If the user field is empty, then the addenda record will not be created.
This page (revision-73) was last changed on 29-Sep-2022 11:27 by Lilia UrtanTop