[BPCS-L] IPH -> ITH Quantities

[Alister Wm Macintyre <macwheel99@xxxxxxxxxxx>]

This weekend that just ended was our
end year, month, with physical inventory done a different way than in prior 
years
& some of our documentation from last year had managed to get lost

Now I am trying to figure out the significance of some stuff so that 
perhaps I can add to our overall collection of useful info for people, 
without major hassles getting there.

One thing I would like to figure out is the significance of various fields 
of ITH for transaction "O".
I recognize that the population of these ITH fields like dances to 
different band music for different types of transactions and even 
variations within same types.

ITH.TQTY is apparently the quantity variance ... how much the on-hand was 
changed as a result of the tags going into the opening balance.
ITH.THFAMT is apparently is quantity multiplied by the standard cost at 
time of INV650 ... in other words the $ variance due to the change from the 
physical inventory.
We are then able to sort on this ... I get the absolute value by squaring 
what I want to sort on, so that the pluses and minuses are grouped together 
in context.

Now notice these two lines from one of my queries. (it lines up nice if you 
change it to Courier or some such proportional font)

 Item            C  Wh 
Comment             Quantity          Variance
                 l                         Variance             $ 

                 s 

 910730          WP 42 TAG 
0026780SSUE   269119.262        1808.48144
 915013          MC 42 TAG 
0027592       128639.207-      16208.54008-

Notice the characters in the ITH.TCOM comment field AFTER the tag #.
The INV700 series reports that show tag #, such as INV740, do not have this 
extra stuff at the end of the tag #, so I figure this is an artifact of how 
INV650 works.
Does this happen at other companies & can anyone illuminate me as to the 
significance of this stuff?

When I was viewing the "O" tags input inventory history lines, and our 
subsequent adjustments and corrections, to see what other fields are 
populated with data that might be a useful addition to our reports, I 
became intensely curious about what the heck is the meaning of the stuff in 
fields

ITH.TOQTY       "Original Entry Quantity" and
ITH.THQUM ... "MTD Adj" ... naming sounds like Unit of Measure conversion, 
but the population pattern yes/no does not seem consistent with our unit of 
measure coding, which could have errors in it.

For most tags, ITH.THQUM is zero, with the next most common reality being 
the same value as ITH.TQTY, but the content of ITH.TOQTY seems to be all 
over the map without any consistent content relative to the other 
fields.  At one point, I thought this might be the on-hand that existed 
before the tags went in, but INV300 F21 disabused me of that notion.  The 
data is not consistent.

However, perhaps ITH.THQUM has either the quantity in the tags or what the 
on-hand was before the tags got dumped in ... I have not yet done 
exhaustive check to see if that is true, for any sub-set of the data..

Tag 202 the on-hand was 89, the tag said 89 physical, so
TQTY = zero variance
THQUM = 89
TOQTY = zero
202 had "ST on the end in TCOM

tag 203 the on-hand was zero, the physical found 40
TQTY = 40 added
THQUM = 40
TOQTY = 75
203 did not have anything appended in TCOM

what the heck does the 75 mean?
Well according to INV300 F21 75 was the last quantity we had on-hand 12/13 
before shipment of 75 on 12/16
That may be a coincidence, because when I go looking up INV300 on other 
items with TOQTY population, I am not finding a consistent story

Tag 204 the on-hand was 80, the physical found 80, so
TQTY = zero variance
THQUM = 80
TOQTY = 40
204 did not have anything appended in TCOM

What the heck does the 40 mean?
Oh, I see from INV300 F21 that this was one of the items where people did 
inventory transactions AFTER the tags got printed, so TOQTY may be related 
to the cycle count concept that we might want to know what the inventory 
was before people messed with the physical by overlapping other 
transactions when in theory we had shut down for physical.

We have a ton of "O" in ITH in which the TCOM comment is "* No Tag"
a handful of them have some value in ITH.TOQTY or ITH.THQUM ... each time I 
look in the INV300 F21 on these items it seems to me like that quantity 
relates to how many we made last month, or shipped last month, or how far 
negative it got last month ... but whatever rule of thumb I come up with 
what significance is this, it does not pan out when I look at the items 
with no tag whose ITH.TOQTY or ITH.THQUM is zero ... so far I have not 
found some explanation that makes any sense whatsoever with the "No Tag" 
entries..

-
Al Macintyre  http://www.ryze.com/go/Al9Mac