Al,
Attached is a RPG that fixes the year --- it was (and maybe still is)
possible to have a invalid posting year.  It could be used a termplate RPG
to use journal reference vs. year only for selection. Just replace the
UPDATE with a DELETE if you choose, and change the test criteria for the
journal reference number being fixed.

*************** Beginning of data ******************************
FTEMGEN    UPE  E             DISK                              
C                   MOVEL     JRFNO         TEST              7 
C     TEST          IFEQ      'CR01908'                         
C     TEST          OREQ      'CR01905'                         
C     TEST          OREQ      'CR01906'                         
C     TEST          OREQ      'CR01907'                         
C     TEST          OREQ      'CR01909'                         
C                   Z-ADD     98            EYEAR               
C                   UPDATE    TEMGENLT                          
C                   END                                         
****************** End of data *********************************

We're now on IFM so you can see we haven't used this in a while!

Best Regards, 
Ed Kandel
 

-----Original Message-----
From: aldg3@xxxxxxxxxxx [mailto:aldg3@xxxxxxxxxxx] 
Sent: Tuesday, April 20, 2004 1:52 PM
To: MAPICS ERP System Discussion
Subject: Re: Re: TEMGEN contains prior year PR JEs

Hi Pete Olshavsky:

Thanks for your reply posting.

Yes we have G/L and the interface is on between it and P/R.

For some reason, prior years Period 5 P/R J/E's did not get cleared from the
TEMGEN file at the fiscal year end closing.  They certainly got copied into
the CURHIS file OK during the prior year's Period 5.

I notied that the Year field for all PR J/E's are populated only with a zero
(0); not 103 or 104 as your sample RPG program suggests.

The five (5) prior year Period 5 P/R J/E's have Journal Reference Numbers
ranging from: PR00822-% to PR00826-%.

Perhaps it's possible to rewrite the RPG program using the Journal Reference
Numbers at the conditional test.

I look forward to your follow up posting and perhaps suggestions from other
Mapica ML members.

Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
Grants Pass, OR, USA
aldg3@xxxxxxxxxxx




> 
> From: Pete Olshavsky <polshavsky@xxxxxxxxx>
> Date: 2004/04/20 Tue AM 10:24:49 PDT
> To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> Subject: Re: TEMGEN contains prior year PR JEs
> 
> Al,  Not sure why those records would still be in temgen.. Do you have
G/L? is the interface between P/R & G/L on? Once a month gets closed in G/L
then the Temgen records get moved to Curhis. So either, you are not using
G/L or these records got posted after 2003 period 5 was closed. 
>  
> Can you write an RPG pgms? Pretty simple pgm to write. I have done many
times
> Just compare fld
> EYEAR eq to 103 and EMNTH eq to 05. 
> Delete TEMGENLT
> Let me know if you have any questions
> Pete
>  


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

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-2021 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.