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: email@example.com (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. > firstname.lastname@example.org > 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: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.