ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> CONSOLIDATE INVTXN ERROR
http://www.istechforum.com/YaBB.pl?num=1168718012

Message started by cathyh on 01/13/07 at 11:53:32

Title: CONSOLIDATE INVTXN ERROR
Post by cathyh on 01/13/07 at 11:53:32

I tried the consolidate inv transactions today and as it did the last time I did this, when I ran the SM-J-C transaction reconciliation it wanted to create lots of transactions to balance the records-
St Lv File     Item Number     Location   Action Taken
-- -- -------- --------------- ---------- ----------------------------------------------------------------------------------------
   T  INVTXN   1300007                    BKICLOC UOH: -0.38; INVTXN UOH: 48.62; created INVTXN adj for -49.00.
   T  INVTXN   1400013                    BKICLOC UOH: 55.00; INVTXN UOH: 196.00; created INVTXN adj for -141.00.
   T  INVTXN   1600006                    BKICLOC UOH: 221.00; INVTXN UOH: 265.00; created INVTXN adj for -44.00.
   T  INVTXN   1600021                    BKICLOC UOH: 0.00; INVTXN UOH: 30.00; created INVTXN adj for -30.00.
   T  INVTXN   1600025                    BKICLOC UOH: 28.00; INVTXN UOH: 44.00; created INVTXN adj for -16.00.
   T  INVTXN   1610017                    BKICLOC UOH: 220.00; INVTXN UOH: 233.98; created INVTXN adj for -13.98.
   T  INVTXN   1620008                    BKICLOC UOH: 62.00; INVTXN UOH: 63.00; created INVTXN adj for -1.00.
   T  INVTXN   1800013                    BKICLOC UOH: 2202.00; INVTXN UOH: 885.00; created INVTXN adj for 1317.00.
   T  INVTXN   1800035                    BKICLOC UOH: 65.00; INVTXN UOH: 64.00; created INVTXN adj for 1.00.
   T  INVTXN   3000012                    BKICLOC UOH: 0.00; INVTXN UOH: 1.00; created INVTXN adj for -1.00.
   T  INVTXN   3000069                    BKICLOC UOH: 0.00; INVTXN UOH: 8.00; created INVTXN adj for -8.00.
   T  INVTXN   3620014                    BKICLOC UOH: 0.00; INVTXN UOH: 5.00; created INVTXN adj for -5.00.

Last time I did this we had to do a lot of journal entries to clear the transactions that were created here when we ran our usual month end reconciliation.
Good thing I did this in test.
I would so like this to work.  The invtxn file is so full of transactions we do not need to look at- from 2004.
Can this be fixed?

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.