ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> SO invoiced correctly - invtxn 4 times
http://www.istechforum.com/YaBB.pl?num=1212598206

Message started by khays on 06/04/08 at 09:50:06

Title: SO invoiced correctly - invtxn 4 times
Post by khays on 06/04/08 at 09:50:06

I'm puzzled and looking for some ideas on how this might occur.
In doing EOM reports I noticed these details:
05/23/08 G-60 048 60861 B44 2.00 0.0000 82.7200 -82.7200
05/23/08 G-60 048 60861 B44 2.00 0.0000 82.7200 -82.7200
05/23/08 G-60 048 60861 B44 2.00 0.0000 82.7200 -82.7200
05/23/08 G-60 048 60861 B44 2.00 0.0000 82.7200 -82.7200
Item Class: SHT Total 0.0000 330.8800 -330.8800

IN-E reflects the same entries.
after investigating invoice 60861 - it was in fact for just 2 G-60 048 for a total of about $100.
This part is Lot controlled.

I have tried several release scenarios using an offline system with backup data prior to the real release that caused these entries. Neither I nor the office staff that did the real release can reproduce these results.

I am trying to avoid our CPA questioning the confidence of the data.

Title: Re: SO invoiced correctly - invtxn 4 times
Post by GasGiant on 06/04/08 at 09:58:31

What are the transaction types for these transactions? Releasing does not transact in INVTXN. There are no reversed transactions? Looks like the invoiced stuttered, or as if someone kept killing the transaction when they got to the Lot number entry. Do all of the transactions show the Lot number?

Title: Re: SO invoiced correctly - invtxn 4 times
Post by khays on 06/04/08 at 12:07:11

IN-E says that all 4 transactions are S type.
LC-D has the correct lot number on all 4 entries.
No reversing entries.

Re: INVTXN I guess I should have said I tried various release/invoice/post senarios. Interestingly the timestamps look something like this:

G-60 048 USER1 2:06:26
G-60 048 USER1 2:06:26
G-60 048 USER1 2:06:26
G-60 048 USER1 2:06:27

these seem petty quick for a human triggered event

I figured there was something odd that went on when the system asked for the lot number but can't come up with what.

Title: Re: SO invoiced correctly - invtxn 4 times
Post by Lynn_Pantic on 06/05/08 at 12:45:44

Does the GL also show the duplication? If not, then I would concur that it was some sort of stumble when it prompted for the Lot number because the GL Posting is already complete by that point. That doesn't explain exactly WHAT happened but does help identify when.

Title: Re: SO invoiced correctly - invtxn 4 times
Post by khays on 06/05/08 at 14:41:26

G/L is fine. Any suggestions for the cleanest fix? We'll just watch future L/C transactions and assume this one was a fluke.