This page (revision-6) was last changed on 26-Nov-2021 10:22 by mmcfarland

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

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
6 26-Nov-2021 10:22 3 KB mmcfarland to previous
5 26-Nov-2021 10:22 3 KB RForbes to previous | to last
4 26-Nov-2021 10:22 3 KB JEscott to previous | to last
3 26-Nov-2021 10:22 3 KB JEscott to previous | to last
2 26-Nov-2021 10:22 3 KB JEscott to previous | to last
1 26-Nov-2021 10:22 4 KB JEscott to last

Page References

Incoming links Outgoing links
UPVEND
UPVEND

Version management

Difference between version and

At line 3 changed one line
Periodically, an Accounts Payable (AP) Interface file is created. This can only be launched after all pay runs for the given payroll period are closed ([UPCLOZ]). This function provides a detailed list of all AP invoices to be exported to an interface file named in this function.
!!Processing Information
At line 5 added 2 lines
The UPVEND function is run to create an Accounts Payable (AP) interface file. This can only be launched after all pay runs for the given payroll period are closed ([UPCLOZ]). This function provides a detailed list of all AP invoices to be exported to an interface file named in this function.
At line 7 removed one line
When using eP to create checks versus sending the information into an Accounts Payable system, the UPVEND process does not create any additional General Ledger journal entries. The journal entries must be created by the Payroll General Ledger interface program ([UPGL]).
At line 9 changed one line
You must set up the proper accounting entries on the pay components directly through [IPPC]. Instead of crediting the amount to a liability account, the amount will be credited directly to the cash/bank account. There will not be an in/out entry in the liability.
For more information on the required set up for running UPVEND and creating an accounts payable interface file see the [ACCOUNTS PAYABLE - UPVEND] page.
At line 11 changed one line
Typically, the taxes would be credited to a liability account. Once paid through the financial system, the entry would be debited to the liability account and credit the cash/bank account.
!! Required Set Up - Preference
The VENDOR MODULE preference must be set up on IMFN for the UPVEND function. Valid values are: UPVEND and UPDISBV
* A value of UPVEND will result in UPAUDT populating the Vendor Code on the pay lines in IPPH.
* A value of UPDISBV will result in UPAUDT not populating the Vendor Code on the pay lines.
At line 13 changed one line
When using UPVEND, the liability is 'cleared' right away. Therefore, the client would not send the taxes to a liability account, the amount would be posted directly to the Cash/Bank account.
If the preference is not defined, UPAUDT will update the pay lines with a Vendor Code.
At line 15 removed one line
At line 20 added 2 lines
!!Report Parameters & Filters
At line 18 changed 14 lines
|__Entity__|__Mandatory, LOV Available__ \\Limits the process to the entity specified.
|__Issued From__|__Mandatory, Date, LOV Available__ \\The earliest issue date that will be used to determine which transactions to report.
|__Issued To__|__Mandatory, Date, LOV Available__ \\The latest issue date that will be used to determine which transactions to report.
|__Accounting Date__|__Mandatory, Date, LOV Available__\\The ‘Accounting' date will be printed on the report.
|__AP Liability Distribution__|__Mandatory, Text__ \\This is the Liability Distribution 'mask'. May be X's for wildcards.
|__Vendor Payroll \\ Vendor (Category) \\ Vendor Period \\ Vendor Issue Date__|These ‘Vendor’ parameters MUST be completed if a check or deposit is to be \\produced. If you leave these defaulted to ALL, the process will abort with errors.\\These fields do not have to be completed if you are producing an AP interface 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 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.
|__AP Year (MH) \\ AP Period (MH)__|These are customized fields.
|__Sum FILE by Vendor/PC __|__Optional, Toggle__\\If the file is to be summarized by Vendor/PC this toggle must be ‘ON.’
|__Output Header/Trailer__|__ Optional, Toggle__\\If the file is to contain a header and trailer record then indicate ‘ON’.
|__Exception Level__|__ Mandatory, LOV Available__\\A ‘trace’ report of exception messages may be produced to assist in the testing \\phase. If necessary, choose from 0 – 9 (highest) level of trace. Please note that this \\is a voluminous report and will cause very slow performance.
|Entity|Mandatory, LOV Available \\Limits the process to the entity specified.
|Issued From|Mandatory, Date, LOV Available \\The earliest issue date that will be used to determine which transactions to report.
|Issued To|Mandatory, Date, LOV Available \\The latest issue date that will be used to determine which transactions to report.
|Accounting Date|Mandatory, Date, LOV Available\\The ‘Accounting' date will be printed on the report.
|AP Liability Distribution|Mandatory, Text \\This is the Liability Distribution 'mask'. May be X's for wild cards.
|Vendor Payroll \\ Vendor (Category) \\ Vendor Period \\ Vendor Issue Date|These ‘Vendor’ parameters MUST be completed if a check or deposit is to be \\produced. If you leave these defaulted to ALL, the process will abort with errors.\\These fields do not have to be completed if you are producing an AP interface 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.
|AP Year (MH) \\ AP Period (MH)|These are customized fields.
|Sum FILE by Vendor/PC |Optional, Toggle\\If the file is to be summarized by Vendor/PC this toggle must be ‘ON.’
|Output Header/Trailer| Optional, Toggle\\If the file is to contain a header and trailer record then indicate ‘ON’.
|Exception Level| Mandatory, LOV Available\\A ‘trace’ report of exception messages may be produced to assist in the testing \\phase. If necessary, choose from 0 – 9 (highest) level of trace. Please note that this \\is a voluminous report and will cause very slow performance.
At line 34 changed 2 lines
|__Payroll__|__ Optional, LOV Available__ \\Only one payroll may be selected per execution of this function.
|__Pay Run Number__|__ Optional, Multiple, LOV Available,__ \\The pay run number of the pays to be selected. Multiple pay run numbers are \\allowed.
|Payroll| Optional, LOV Available \\Only one payroll may be selected per execution of this function.
|Pay Run Number| Optional, Multiple, LOV Available, \\The pay run number of the pays to be selected. Multiple pay run numbers are \\allowed.
----
![Notes|Edit:Internal.UPVEND]
[{InsertPage page='Internal.UPVEND' default='Click to create a new notes page'}]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop