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¢
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.