× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



 I'm wondering if anyone has ever had to recover a failed GLUPDATE job?

We update our invoices in GL using AFI, which is driven by posting rules
in FIP45. On 9/7/04, the AFIGLUPDAT job produced a 13,000 page
EXCEPTIONS - DEFAULT ACCOUNT POSTINGS report (FI551PT3). The error
message was ' Rule not found'. We have since determined that the AFI
posting rule in our FIP45 records is no longer on the system because a
new newly numbered rule has been made effective. The FLP008 records were
created with the actual account as the GL account number, but when
background job GLUPDATE tried to process those FLP008 records, the
program GL161, looped and produced a spool file so large, it caused a
critical storage warning on our system. There are approximately 130,000
FLP008 records that have this problem that haven't been processed by
GLUPDATE.

The UPDNOG (Update Number General Ledger) is still 0 for the FLP008
records in the session, which leads me to believe general ledger
accounts have not been updated with this information. Is that correct?

I'm trying to determine how to recover from this. I am thinking of
deleting the FLP008 and associated FLP007 records for this session and
then updating the FIP45 records to use the correct AFI posting rule,
re-running the AFIGLUPDAT and seeing if the new FLP007 and FLP008
records would process through the GLUPDATE job. Will this recovery work?
If not, how do I recover this?

We are using version 3.5.0b of System 21, if that matters.

== Donna Thomas
The Butler Company.


**********************************************************************
CONFIDENTIALITY NOTICE:  The information transmitted in this message is 
intended only for the person or entity to which it is addressed and may contain 
confidential and/or privileged material.  Any review, retransmission, 
dissemination or other use of this information by persons or entities other 
than the intended recipient is prohibited.  If you received this in error, 
please contact the sender and destroy all copies of this document.  Thank you.  
The Butler Company
**********************************************************************



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.