|
Mike & Richard, Worked like a dream! thanks guys. Mona -----Original Message----- From: system21-request@xxxxxxxxxxxx [mailto:system21-request@xxxxxxxxxxxx] Sent: Tuesday, December 16, 2003 2:06 AM To: system21@xxxxxxxxxxxx Subject: SYSTEM21 Digest, Vol 1, Issue 654 Send SYSTEM21 mailing list submissions to system21@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/system21 or, via email, send a message with subject or body 'help' to system21-request@xxxxxxxxxxxx You can reach the person managing the list at system21-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of SYSTEM21 digest..." Today's Topics: 1. AP session (Mona Ferriols) 2. Re-Use deleted Records (DAhKow@xxxxxxxxxxxxx) 3. RE: Re-Use deleted Records (Chris Tringham) 4. RE: AP session (MLemon@xxxxxxxxxxx) 5. RE: Re-Use deleted Records (Kincer, Alan) 6. Re: AP session (Richard_Caldicott@xxxxxxxxxxxxxxx) 7. RE: Re-Use deleted Records (DBarry@xxxxxxxxxxxxx) ---------------------------------------------------------------------- message: 1 date: Mon, 15 Dec 2003 13:20:12 +0800 from: Mona Ferriols <mon.ferriols@xxxxxxxxxxxxxx> subject: [SYSTEM21] AP session How do you recover an AP session with 'I' as status? User's computer conked out just as he was confirming log entries. Now when we try to confirm again, system says "reference already in Accounts Payable", but they do not appear in 11/APY (ad hoc payments). In PLP15 items affected do not have event number and record status code is not D. Mon Ferriols Data Management & Control Ionics EMS, Inc. - Plant7 * (49) 545-9751 * mon.ferriols@xxxxxxxxxxxxxx * www.ionicsgroup.com "ERP is not just computers and software, but PEOPLE, PROCESSES and FUNCTIONS." ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ------------------------------ message: 2 date: Mon, 15 Dec 2003 12:04:03 +0400 from: DAhKow@xxxxxxxxxxxxx subject: [SYSTEM21] Re-Use deleted Records Hi everybody, as part of a regular routine, we do reorganise the physical files in our OSL libraries to purge deleted records, since some of these files have grown to quite large figures and for some of them, the number of deleted records is quite a high percentage of the total number of records. RGZPFM takes quite some time to complete, especially when there are many logicals that have to be re-indexed. We would like to know if would be safe to change the 'RE-USE DELETED RECORDS' attributes of such files to *YES. Anybody has done that already without any problem? Rgds ------------------------------ message: 3 date: Mon, 15 Dec 2003 20:38:32 +0800 from: "Chris Tringham" <ctringham@xxxxxxxxxxxxxx> subject: RE: [SYSTEM21] Re-Use deleted Records It's safe, and I think it can even improve performance. I've done it, and it didn't cause any problems. -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of DAhKow@xxxxxxxxxxxxx Sent: 15 December 2003 4:04 PM To: System 21 Users Subject: [SYSTEM21] Re-Use deleted Records Hi everybody, as part of a regular routine, we do reorganise the physical files in our OSL libraries to purge deleted records, since some of these files have grown to quite large figures and for some of them, the number of deleted records is quite a high percentage of the total number of records. RGZPFM takes quite some time to complete, especially when there are many logicals that have to be re-indexed. We would like to know if would be safe to change the 'RE-USE DELETED RECORDS' attributes of such files to *YES. Anybody has done that already without any problem? Rgds _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ------------------------------ message: 4 date: Mon, 15 Dec 2003 08:23:55 -0500 from: MLemon@xxxxxxxxxxx subject: RE: [SYSTEM21] AP session This works for direct postings, log entry, and log transfer sessions. Maybe others, but that's pretty much all we do here: Option 32/apu. Enter the session number and the company number and press enter. This task requires exclusive use of the company in the AP module. (But, if you know that the session actually failed, you can remove the exclusivity from the task) Once that is done, go back into the menu option that the user was in Immediately press f12. You will be prompted for the session again. Enter it and press enter. The first screen that you see will show you the control total and the accumulated totals of the batch. I generally tell my users to go ahead and press enter without changing anything. At this point, the user is back in the session like they never left. I usually ask the user to delete the last item that they entered and re-enter it. If your payables module is linked to Job Management and that last transaction was job related, you may have an extra cost post to the job (but not to payables)-- this can be undone by doing a direct posting to relieve the cost from the job. They may have some issues with their control total being off when they go to finish their session (our users never use control totals) Mike -----Original Message----- From: Mona Ferriols [mailto:mon.ferriols@xxxxxxxxxxxxxx] Sent: Monday, December 15, 2003 12:20 AM To: Jbausers-L (E-mail) Subject: [SYSTEM21] AP session How do you recover an AP session with 'I' as status? User's computer conked out just as he was confirming log entries. Now when we try to confirm again, system says "reference already in Accounts Payable", but they do not appear in 11/APY (ad hoc payments). In PLP15 items affected do not have event number and record status code is not D. Mon Ferriols Data Management & Control Ionics EMS, Inc. - Plant7 * (49) 545-9751 * mon.ferriols@xxxxxxxxxxxxxx * www.ionicsgroup.com "ERP is not just computers and software, but PEOPLE, PROCESSES and FUNCTIONS." ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ------------------------------ message: 5 date: Mon, 15 Dec 2003 08:29:58 -0500 from: "Kincer, Alan" <akincer@xxxxxxxxx> subject: RE: [SYSTEM21] Re-Use deleted Records We use RGZDTALIB (Reorganize Data Base Files In Library) from JBA Tools. Does a good job of "weed-whacking" all the white space out of files within entire libraries (make sure you've taken down dependent subsystems/jobs!:) Alan -----Original Message----- From: DAhKow@xxxxxxxxxxxxx [mailto:DAhKow@xxxxxxxxxxxxx] Sent: Monday, December 15, 2003 3:04 AM To: System 21 Users Subject: [SYSTEM21] Re-Use deleted Records Hi everybody, as part of a regular routine, we do reorganise the physical files in our OSL libraries to purge deleted records, since some of these files have grown to quite large figures and for some of them, the number of deleted records is quite a high percentage of the total number of records. RGZPFM takes quite some time to complete, especially when there are many logicals that have to be re-indexed. We would like to know if would be safe to change the 'RE-USE DELETED RECORDS' attributes of such files to *YES. Anybody has done that already without any problem? Rgds _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. === [ KI (USA) Corporation - http://www.kiusa.com ] ====================================== Tel. 859.986.1420 -- Fax. 859.986.1485 This e-mail, including any attachments, contains information from KI (USA) Corporation that may be confidential or privileged. Mail is intended only for those to whom it is addressed. If you are not the intended recipient do not copy, distribute, or take any action in reliance on the contents of this message. If you have received this e-mail in error notify the sender immediately then delete or destroy all electronic and hard copies of this communication, including attachments. KI (USA) Corporation's anti-virus system checks for known viruses. However you are advised to run your own virus check before opening any attachments received. KI (USA) Corporation will not accept any liability once an e-mail and/or any attachment is received. Views expressed in the e-mail are those of the author and not necessarily those of KI (USA) Corporation. ============================================================================ ------------------------------ message: 6 date: Mon, 15 Dec 2003 09:05:01 -0600 from: Richard_Caldicott@xxxxxxxxxxxxxxx subject: Re: [SYSTEM21] AP session You may first have to 'release' the session using 33/APU. Next you have to know what option the user was in - you can determine this from the session type and log flag. Go into that option and on the first panel take F12. You can now enter the session number and resume entry, or cancel the session. If resuming, be sure to review what has been entered so far. If an entry was not full completed it may not be on in the session. Richard Mona Ferriols <mon.ferriols@xxxxxxxxxxxxxx> Sent by: system21-bounces@xxxxxxxxxxxx 12/14/2003 11:20 PM Please respond to System 21 Users To: "Jbausers-L (E-mail)" <jbausers-l@xxxxxxxxxxxx> cc: Subject: [SYSTEM21] AP session How do you recover an AP session with 'I' as status? User's computer conked out just as he was confirming log entries. Now when we try to confirm again, system says "reference already in Accounts Payable", but they do not appear in 11/APY (ad hoc payments). In PLP15 items affected do not have event number and record status code is not D. Mon Ferriols Data Management & Control Ionics EMS, Inc. - Plant7 * (49) 545-9751 * mon.ferriols@xxxxxxxxxxxxxx * www.ionicsgroup.com "ERP is not just computers and software, but PEOPLE, PROCESSES and FUNCTIONS." ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ------------------------------ message: 7 date: Mon, 15 Dec 2003 10:59:16 -0500 from: DBarry@xxxxxxxxxxxxx subject: RE: [SYSTEM21] Re-Use deleted Records We've also done this without incident. We still run a reorg two or three times a year. "Chris Tringham" <ctringham@netviga To: "'System 21 Users'" <system21@xxxxxxxxxxxx> tor.com> cc: Sent by: Subject: RE: [SYSTEM21] Re-Use deleted Records system21-bounces@m idrange.com 12/15/2003 07:38 AM Please respond to System 21 Users It's safe, and I think it can even improve performance. I've done it, and it didn't cause any problems. -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of DAhKow@xxxxxxxxxxxxx Sent: 15 December 2003 4:04 PM To: System 21 Users Subject: [SYSTEM21] Re-Use deleted Records Hi everybody, as part of a regular routine, we do reorganise the physical files in our OSL libraries to purge deleted records, since some of these files have grown to quite large figures and for some of them, the number of deleted records is quite a high percentage of the total number of records. RGZPFM takes quite some time to complete, especially when there are many logicals that have to be re-indexed. We would like to know if would be safe to change the 'RE-USE DELETED RECORDS' attributes of such files to *YES. Anybody has done that already without any problem? Rgds _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ------------------------------ _______________________________________________ This is the System 21 Users (SYSTEM21) digest list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. End of SYSTEM21 Digest, Vol 1, Issue 654 **************************************** ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
