RE: ITH not posted to Gen Led (Was CST600 rollup)

Even if transactions are set up not to affect General Ledger, the system
should change the status flag to "Y".  We have occasionally had this
situation when the inventory post job was inadvertently canceled by someone
in operations.  This caused some of the transactions to post and some remain
unposted.  However, the next inventory post picks up the remaining
transactions.  If the transactions cannot post due to errors, the Journal
Entry Errors report (INV921B) should indicate them when inventory post is
run.  Also, I don't believe the ITE file controls whether or not a
transactions posts to GL (at least not in 6.02) - that is actually
controlled by subsystem event determination - file GED.  We have "T"
transactions set up to bypass journal entries, and their status in ITH is
changed to "Y" during the post but no journal entries are generated.

        -----Original Message-----
        From:   Jim [SMTP:jcannon@antigua.com]
        Sent:   Tuesday, April 18, 2000 7:27 PM
        To:     BPCS-L@midrange.com
        Subject:        Re: ITH not posted to Gen Led (Was CST600 rollup)

        Nice catch Mac! Excellent suggestion.

        From:                   MacWheel99@aol.com
        Date sent:              Tue, 18 Apr 2000 17:13:20 EDT
        Subject:                Re: ITH not posted to Gen Led (Was CST600
rollup)
        To:                     BPCS-L@midrange.com
        Send reply to:          BPCS-L@midrange.com

        Not all inventory transactions get posted to the General Ledger ...
your 
        settings in the ITE file - Inventory Transaction Effects ...
determine which 
        transactions go to Gen Led & which don't & you need to understand
the 
        function of various transactions ... perhaps they are not being
posted to Gen 
        Led for good reason.

        The "O" can have 2 meanings
        a) When INV900 recomputes opening balance & resets all the MTD to
zero
        b) When you take a physical inventory

        In the first case you might not want Gen Led to get latest value of
inventory 
        from detail by item warehouse location, but rather some other total
story by 
        facility or warehouse.
        In the second case you might not want physical inventory data to go
directly 
        to Gen Led, rather you might want to post some variance by facility
or 
        warehouse.

        "T" is a transfer between two locations ... if you do not track your

        inventory valuation in Gen Led to the detail level by location then
there is 
        no point having this go to General Ledger.

        I do not know off hand what all those letters you cited do, but your
ITE 
        settings needs to be the first place to look.  There's an inquiry,
INV355 I 
        think, to get a screen view of what the Gen Led rules are by
transaction, 
        that you can scroll through to see how the value is changing in a
particular 
        field, or you can do a query chart off ITE to look at a few values
of 
        particular interest.

        Another thing to check is whether any transaction effects have an 
        inconsistent history - some to Gen Led & some not, which might
indicate that 
        someone changed the ITH settings recently.

        Warning - if you want detail to Gen Led, make sure each transaction
type goes 
        to a different Journal Reference or else you are going to run out of
what can 
        be posted in one month.

        > Subj:  Re: CST600 question; what controls rollup of buckets?
        >  From:    bpcsmaynez@yahoo.com (Jesus Maynez)
        >  
        >  Hello Everybody,
        >  
        >  I have a problem I have found about a thousand
        >  transactions in my ITH file that has a TSTAT in blank.
        >  They were not posted and I dont know why. The oldest
        >  transactions are 5 months old, and most of them are
        >  transactions 'O','T' but thare are some
        >  'U','UB','II','H','IC', and 'C'.
        >  
        >  Does someone have an idea of why these transactions
        >  were not posted, and they are not taken by the INV920
        >  program?
        >  
        >  I would appreciate any help.
        >  
        >  Thanks
        >  Jesus Maynez

        Al Macintyre  ©¿©
        http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
        +---
        | This is the BPCS Users Mailing List!
        | To submit a new message, send your mail to BPCS-L@midrange.com.
        | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
        | To unsubscribe from this list send email to
BPCS-L-UNSUB@midrange.com.
        | Questions should be directed to the list owner: dasmussen@aol.com
        +---
        +---
        | This is the BPCS Users Mailing List!
        | To submit a new message, send your mail to BPCS-L@midrange.com.
        | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
        | To unsubscribe from this list send email to
BPCS-L-UNSUB@midrange.com.
        | Questions should be directed to the list owner: dasmussen@aol.com
        +---
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---