Duplicate Journal Entries

Jason,
Are they the same JE #? Look closely at the GLTRANS (DBGLT) table at the STATUS and JE_SEQUENCE fields. It could be that the original entries are creating memo/error suspense entries.

John, they don't have the same JE #'s. They are completely unique records in the GLTRANS table and others.

It's almost like the program didn't realize it created a journal entry for a released transaction, even though it had.

The exact issue that happened today was that a user ran a CB175 to create a journal entry. After the user ran the CB175 she printed a second trial balance. From the time she printed the first trial balance to the second two accounts changed values. Nobody else was running any jobs and she didn't run a GL190. Besides that the accounts that changed weren't the accounts affected by the journal entry created from the CB175 report. I looked at the GL45 and saw the CB journal entry that she created and it looked normal, it had a status of unreleased as I would expect. But, right above that journal was another released by CB175 by the same user, however she didn't actually release it. It was a duplicate of a previous entry and had the status of quickpost. She didn't go into the GL45 and quickpost it. As a result we have had to create entries in the reverse and post them to correct the errors.

thanks for checking,

Jason

What platform are you on? Regardless, this is a pretty old version...I doubt Lawson will even let you open a support call...

ISeries.


They will open a single call for a minimum charge of $2,500 but they're about to drop that option too. We're going through the release notes of 7.2.2.6 too see if there's any reference, we've had that release since '02 I guess and never installed it.

Lawson is actually a slight overkill for our organization but the implementation of any other package or even an upgrade to 9 is just too costly. but, if we keep having issues like this we may be forced.

Thanks for responding.

Have you talked to CIBER or Analysts International about on-going/on-call support? I know they have done it for clients in the past.