You could also use SQL to delete them. Enter STRSQL to start the interactive SQL. You can select the records first by entering: select * from amflib.TEMGEN Pressing enter will display the records in the file. Entering this again and pressing F4 will allow you to enter a where clause such as below to see a range of Journal Reference numbers: select * from amflib.TEMGEN where JRFNO >= 'PR00822' and JRFNO <= 'PR00826' You could also enter the following to get a count of the records prior to deleting: select count(*) from amflib.TEMGEN where JRFNO >= 'PR00822' and JRFNO <= 'PR00826' Once you are sure (absolutely sure)these are the correct records to delete, you can change the statement to the following to delete them: delete from amflib.TEMGEN where JRFNO >= 'PR00822' and JRFNO <= 'PR00826' No programming required but SQL is very powerful. I would suggest running in test first. -----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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.