Customer Invoicing a headache!

[Jesus Maynez <bpcsmaynez@xxxxxxxxx>]

Once again, the customer billing is doing weird things.
The issue today is that the quantity billed does not match with the shipped 
quantity.
The SIL has two quantity fields ILQTY and ILQINS. Supposedly, the ILQTY is 
the total of units by stock unit of measure, and the ILQINS the total of 
units by selling unit. Therefore, the field used for the invoice is ILQINS. 
Our company has the same unit of measure for stocking than for billing. 
There is a relationship 1 to 1 for all the items. On this scenery, both 
fields should have the same values.
However, there are some invoices that have different values, thus the total 
for these invoices are incorrect. In addition, the difference between the 
two fields are not logical because the ILQINS and ILQTY do not have a 
common denominator.

Here is an example of these fields in the SIL record.

ILINVN       ILQTY                   ILNET            ILREV 
           ILQINS
51,792       1080.000               3.8075            7538.85-       1,9  
80.000- 
52,178        320.000               1.5947             893.03- 
        560.000-


ILREV is the amount which will affect the GL, and is calculated for ILQINS 
times ILNET.

I don't know for what reason the ILQINS became negative. The ILQTY matches 
with the quantity shipped, and I check the units of measure in the Item 
Master and they look ok.

Does anyone have an idea of what is going?


Thanks on advance.

Jesus Maynez
MIS Viasystems
(915) 860-5000x5124


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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
+---