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
 


aldg3@xxxxxxxxxxx wrote:
Environment: Mapics DB, Mod 4

Hi group:

Our P/R person ran the "Payroll Temporary General Ledger listing" (AMV611) for 
Period 5, April 2004 and upon examination of the report, we find that it 
includes Period 5 P/R JE's from both this fiscal year and the last fiscal year.

I looked at TEMGEN using Query/400 and found that of the 5,023 Period 5 P/R JE 
records, only 984 were from this current fiscal year. The rest appear from 
Period 5 for the prior fiscal year.

Is there a fix for this using Mapics?

If all the prior fiscal year records were made "inactive," I suppose that would 
solve the problem.

But is there a way to delete these 4,039 records quickly and efficently?

I look forward to your comments.




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

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




                
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2020 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].