Welcome, Guest. Please Login.
05/25/25 at 08:09:42
News:
Home Help Search Login


Pages: 1
Send Topic Print
CONSOLIDATE INVTXN ERROR (Read 516 times)
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
CONSOLIDATE INVTXN ERROR
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?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print