Re: ILQTY vs ILQINS vs ILREV In SIL

From Al Macintyre

This is one answer - I have others if you do not buy this explanation & want 
to see what other BS I have to offer.  In BPCS405 CD ... SIL & SIH populated 
as part of the Billing Process ... we do most of our Billing via BIL500 with 
occasional BIL600 corrections ... the nature of data captured BY CUSTOMER 
ITEM is different ... if you do BIL600 without identifying ITEM then some 
later SSD SSH analysis will come out wrong on item detail because of the 
missing BIL600 corrections.  Price can come to EC* ES* by multiple means & 
might not be tracked consistently.

A lot of stuff starts in the EC* files & gets translated to other files with 
risk of getting corrupted in transit.  Incidentally ITH (type B) is the only 
history file I have seen that stores both the PRICE of what was billed and 
the actual and standard COST at the time it was shipped ... most files have 
COST or PRICE or only one of the two costs.

Be aware that BPCS has what I call a Systemic Problem with unit of measure & 
other conversions.  In RPG there is some kind of upper limit on fields used 
in math, like 30 numeric places & 9 decimal places.  If you multiply 2 
numbers 30.9 times 30.9 you get unpredictable results ... this is spelled out 
in the RPG Programmer manual which apparently very few people at SSA have 
read because BPCS does this all over the place.  Now the unpredictable 
results are worst with simple numbers.

For example multiply ZERO by ONE in fields defined as 30.9 & what you often 
get in BPCS is NEGATIVE 0.000000001 or 2 ... thus if you have a unit of 
measure conversion of ONE and multiply it by VERY SMALL numbers stored in 
VERY LARGE fields, there is this problem that leads to creeping inaccuracies 
in our data bases.

I tried to explain this quite some time ago to SSA Tech Support after we 
found several programs where this was happening entirerly too often, but my 
skills at explaining do not seem to connect where most important.

> From: cmassoglia@voyager.net (Charlie Massoglia)

>  What is the difference between ILQTY and ILQINS in SIL?  Also what is the 
> difference between ILNET and ILNETS in SIL?  My understanding is ILQTY and 
> ILNET are stocking unit of measure and price while ILNET and ILNETS are 
> selling unit of measure and price.  Why would these fields be different if 
> the stocking and selling unit of measure are the same?  And why would 
ILNETS 
> be zero?  Also, where does the field ILREV fit into the equation?
>  
>  Thanks in advance.
>  
>  Charles L.Massoglia, President
>  Massoglia Technical Consulting, Inc.
>  cmassoglia@voyager.net
>  In MI 517-676-9700 or in NC 919-363-9395

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

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