how to include the quantity ordered in OE entry if order type is ACTIV

[CRdesigner]

Hi guys,

I'm using CRXI(crystal report version XI) and i'm getting tables from accpac module OE(OE ENTRY).

my problem is i want to include the quantity ordered in the report if order type is "ACTIVE" but the only thing that crystal report shows is the order type "QUOTE"

scenario:
reference = parameter

balance ref:index1
item quantity(active) quantity(quote)
abcd = oeordd.qtyordered oeordd.qtyordered
(if {oeordh.type} = 1 then (if ref = {@index1}
oeordd.qtyordered) and{oeordh.type}=4 then
oeordd.qtyordered)

the result is :

item balance ref: january
abcd 0.00 100


i don't know why crystal report can't show the quantity ordered if the oeordh.type(order type) is equal to 1 or ACTIVE. it only shows the quantity ordered if the order type is QUOTE OR EQUAL TO 4

guys please help me on this.

any advice, suggestions or comments would be very much appreciated.

thank you

 

[ettienne]

I think you are looking for the original qty ordered field, it's something like OQTYORDER.