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

[MacWheel99@xxxxxxx]

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
+---