Re: GLI transaction limit

Vanessa,
I ran into that problem at least 5 years ago in the IM GLI and I believe it was never solved. The problem is not that the INVTXN file has a limit. The problem is that if you do not summarize the transactions and you create a GL entry for each transaction (since the history behind the summary is lost), that is when the resulting IM Journal may run over the 99,999 sequence number. I do not know if this problem exists in the IFM world (what is the Journal ID field size) but DEFINITELY it is still a problem in the AM/GL application.

The only solution is the one that you described - processing transactions more frequently (weekly, bi-weekly or daily) thereby creating a new Journal Reference Id for each week/biweek/day.

We both know that there is probably some other solution available but I do not believe MAPICS was able to resolve it. For them to be able to replicate it, they would have to create over 100,000 transactions themselves (in test).
Happy Holidays from the West Coast...
Eric

From: VanessaKing@xxxxxxxxx> To: mapics-l@xxxxxxxxxxxx> Date: Tue, 18 Dec 2007 11:59:48 -0500> Subject: [MAPICS-L] GLI transaction limit> > The general ledger interfaces used to have a 99,999 or 100,000 transaction> limit for the TXN files (like INVTXN). When you reached whatever the limit> was, it would simply overwrite transaction #1 and keep going forward.> Customers got around this by posting ledger entries as often as they needed> to in order to clear that file before it reached the limit. Support says> that they aren't aware there was ever a limit and if so it should have been> fixed. The file has a *NOMAX, but I wonder if it was actually the program> that limited it somehow. Does anyone know for sure?> > > > Best regards,> > Vanessa> > > > Vanessa King> > > > > > > > _______________________________________________> 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.>

_________________________________________________________________
i’m is proud to present Cause Effect, a series about real people making a difference.
http://im.live.com/Messenger/IM/MTV/?source=text_Cause_Effect