|
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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.