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

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

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

Page References

Incoming links Outgoing links
UPTODATE
UPTODATE

Version management

Difference between version and

At line 6 changed 3 lines
As it reads each employee's IPPH (pay header) information it will delete any existing [IPVT] ([P2K_PR_TODATE_HEADERS]) records. It will then go through all the [P2K_PR_PAY_HEADERS] records and rebuild them from the [P2K_PR_PAY_PC_AMOUNTS] data (the Pay Amounts tab on [IPPH]) based upon the [PAY_ISSUE_DATE].
* __YTD__: Year To Date values are always created
* __QTD__: Quarter To Date values are created if you have indicated you wish a [QTD summary|QUARTERLY_SUMMARIES] on [IPPR]. QTDs are based on calendar quarters.
As it reads each employee's IPPH (pay header) information it will delete any existing [IPVT] ([P2K_PR_TODATE_HEADERS]) records for the to-date records selected in the parameters. It will then go through all the [P2K_PR_PAY_HEADERS] records and rebuild them from the [P2K_PR_PAY_PC_AMOUNTS] data (the Pay Amounts tab on [IPPH]) based upon the [PAY_ISSUE_DATE].
New parameters have been implemented for the following:
At line 10 changed 2 lines
* __FTD__: Fiscal Month To Date are created if you have indicated you wish a [FTD summary|FISCAL_SUMMARIES] on [IPPR]. FTDs are based on the Fiscal months as defined on Fiscal Calendar for the GL Company ([IDGC])
* __ATD__: Assignment To Date records are created with totals by Assignment Code. This information is taken from [P2K_PR_PAY_LINES] and [P2K_PR_PAY_LINE_DETAILS], which are shown on the Pay Lines tab of [IPPH], rather than the PC Amounts. Only the pay components that have Note that this information is not normally converted, so this record would not be created. Only those pay components that are on the Pay Line Details will be included by assignment.
* __QTD__: Quarter To Date values are created if you have indicated you wish a [QTD summary|QUARTERLY_SUMMARIES] on [IPPR]. QTDs are based on calendar quarters.
* __YTD__: Year To Date values are always created
* __FTD__: Fiscal Month To Date are created if you have indicated you wish a [FTD summary|FISCAL_SUMMARIES] on [IPPR]. FTDs are based on the Fiscal months as defined on Fiscal Calendar for the GL Company ([IDGC]). The FTD will not be processed when a year is provided in the YEAR Parameter.
* __ATD__: Assignment To Date records are created if you have indicated you wish [Assignment Summary|Assignment_Summary] on [IPPR]. The totals are by Assignment Code. This information is taken from [P2K_PR_PAY_LINES] and [P2K_PR_PAY_LINE_DETAILS], which are shown on the Pay Lines tab of [IPPH], rather than the PC Amounts. Only those pay components that are on the Pay Line Details will be included by assignment. The ATD will not be processed when a year is provided in the YEAR Parameter.
* __YEAR(YYYY)__: The for which the To-date records are to be updated for.
At line 13 removed 5 lines
%%warning
Known Issues:\\
;Problem:If you select a specific year, __all FTD and ATD records are removed__. ATD are rebuilt, but FTD records are only rebuilt for the specified year:\\
;Workaround:If you have FTD values then do not run for only a specific year
%%
At line 17 added one line
For M/Q/Y records, process either all IPPH or the Year matching the report parameter
At line 19 added 2 lines
This page (revision-10) was last changed on 26-Nov-2021 10:22 by kparrottTop