RE: Re: TEMGEN contains prior year PR JEs

[lisa.thomas@xxxxxxxxxxx]

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.