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

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

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
12 26-Nov-2021 10:22 4 KB tchau to previous
11 26-Nov-2021 10:22 4 KB jmyers to previous | to last
10 26-Nov-2021 10:22 5 KB jmyers to previous | to last
9 26-Nov-2021 10:22 4 KB jmyers to previous | to last
8 26-Nov-2021 10:22 4 KB jmyers to previous | to last
7 26-Nov-2021 10:22 6 KB jmyers to previous | to last
6 26-Nov-2021 10:22 6 KB jmyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 238 bytes RForbes to previous | to last
1 26-Nov-2021 10:22 46 bytes UnknownAuthor to last

Page References

Incoming links Outgoing links
UPGLUNDO
UPGLUNDO

Version management

Difference between version and

At line 15 changed 25 lines
|Retain Original G/L|Optional, [Yes or No|X_YES_NO] lexicon available\\You may need to retain the original GL to reverse out from the General Ledger system when re-sending the re-journalized journal entries\\ \\If <No>, original GL journal entries will not be retained, just removed\\If <Yes>, original GL journal entries will be retained\\ \\If the field is set to <Yes> when a journal entry is removed, the original journal entry will be copied and negated. The journal source is changed as follows\\01 – Labor G/L changed to:
02 – Payroll G/L changed to: 71 - Orig Labor G/L
03 – Accrual G/L changed to: 72 - Orig Payroll G/L
06 – Accrual Rev G/L changed to:
changed to: 73 - Orig Accrual G/L
changed to: 76 - Orig Accrual Rev G/L/%
\\ \\
The above original journal entries are for auditing purpose only and will not be re-sent in UPGLF.
- then the amount will be negated and will be re-send in UPGLF:
01 – Labor G/L changed to: 81 - Negate Labor G/L
02 – Payroll G/L changed to: 82 - Negate Payroll G/L
03 – Accrual G/L changed to: 83 - Negate Accrual G/L
06 – Accrual Rev G/L changed to: 86 - Negate Accrual Rev G/L
|Remove Prev Retain|Optional, [Yes or No|X_YES_NO] lexicon available\\If <Yes>, previous G/L will be removed.
|Retain Original G/L|Optional, [Yes or No|X_YES_NO] lexicon available\\You may need to retain the original GL to reverse out from the General Ledger system when re-sending the re-journalized journal entries\\ \\If <No>, original GL journal entries will not be retained, just removed\\If <Yes>, original GL journal entries will be retained\\ \\If the field is set to <Yes> when a journal entry is removed, the original journal entry will be copied and negated. The journal source is changed as follows\\01 – Labor G/L changed to: 71 - Orig Labor G/L\\02 – Payroll G/L changed to: 72 - Orig Payroll G/L\\03 – Accrual G/L changed to: 73 - Orig Accrual G/L\\06 – Accrual Rev G/L changed to: 76 - Orig Accrual Rev G/L\\ \\The above original journal entries are for auditing purpose only and will not be re-sent in UPGLF.\\ \\The amount will then be negated and will be re-send in UPGLF\\01 – Labor G/L changed to: 81 - Negate Labor G/L\\02 – Payroll G/L changed to: 82 - Negate Payroll G/L\\03 – Accrual G/L changed to: 83 - Negate Accrual G/L\\06 – Accrual Rev G/L changed to: 86 - Negate Accrual Rev G/L
|Remove Prev Retain|Optional, [Yes or No|X_YES_NO] lexicon available\\If <No>, Prev Retain GL journal entries are not removed.\\If <Yes>, Prev Retain GL journal entries are removed\\ \\After one UPGLUNDO is run, the original GL entries may be retained in P2K system. At that point UPGL is run again and errors are discovered. Next, the UPGLUNDO will be run gain and at that point you may select to remove the previously retain original GL in subsequent UPGLUNDO run.\\ \\Usually you will not remove original retain GL entries because these retain entries may already be recorded in the General Ledger system that need to be reverse out from the negated entries.
At line 54 removed one line
|Undo Execution ID|- optional, multiple Execution ID of UPGL or UPGLUNDO are allowed\\- the user may undo by UPGL run or undo the run from previous UPGLUNDO
At line 56 removed 10 lines
|Retain Original GL|- optional,
Remove Prev Retain GL:- optional, after one UPGLUNDO is run, the original GL entries may be retained in P2K system, then user runs UPGL again and errors are discovered, then user will run UPGLUNDO again, the user may select to remove the previously retain original GL in subsequent UPGLUNDO run
- usually the user will not remove original retain GL entries because these retain entries may already be recorded in the General Ledger system that need to be reverse out from the negated entries
- if toggle is OFF, Prev Retain GL journal entries are not removed
- if toggle is ON, Prev Retain GL journal entries are removed
|Trial: | - in Trial run, database activities will not be updated, this is used for testing
At line 38 added 3 lines
- user should run with ‘Exception only’ except for debugging
- if Level ‘1 - User Trace’, UPGLUNDO displays each Employee header
- if Level ‘9 - Utility Trace’, UPGLUNDO displays all trace messages
At line 53 added one line
This page (revision-12) was last changed on 26-Nov-2021 10:22 by tchauTop