Re: accounts receivable remaing amount due

["Ahmed Hussain" <ayusuf@xxxxxxxxxxxxxxxxxx>]

What I understood, that you are saying that Invoice balance amount supposed to 
be A/R
amount, if yes, then I would go back to my previous e-mail to SSA.

Detail:
This Issue is regarding the billing and G/L transaction. The SIL has two 
quantity fields
ILQTY and ILQINS. Presumably, the ILQTY is the total of units by stock unit of 
measure,
and the ILQINS the total of units by selling unit and both are supposed to be 
equal. Our
company has the same unit of measure for stocking than for billing.

But in some cases ILQTY and ILQINS are not equal, and ILQINS became negative the
difference between the two fields are not logical


ILINVN  ILQTY                  ILNET                  ILREV           ILQINS
25,832          40.040             125.0000            5005.00            
15.100-
25,836          40.500             155.0000            6277.50              
.200-
25,883          30.050             155.0000            4657.75             
1.000-
25,802          35.960             170.0000            6113.20            
36.120-
25,893          30.000             160.0000            4800.00            
82.000-
26,250          40.600              82.5000            3349.50           
133.100-
28,340          29.900             120.0000            3588.00             .150-

Subsystem is affecting by ILQTY times ILNET, and G/L and Account Receivable by 
ILQINS
times ILNET and calculated amount is kept in ILREV and the same field is being
transferred to G/L., and I check the units of measure in the Item Master and 
they look
ok.


Thanks and Regards

Ahmed Hussain

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