Hello,
I have created a report that is set to calculate the difference between parts ordered and parts received for various Work Orders and then list a sub total for each part number that has an outstanding balance due. All "Qty_Ord" fields have numbers, but "Qty_Rec" fields are many times blank as no parts have been received yet and/or the total "Qty_Rec" is less than the "Qty_Ord" so there is a balance due of the remainder.
On the report I put this in the part number footer section:
=Sum([Qty Ord])-Nz([Qty Rec],0)
In all instances except two it works fine, but in two instances it does not return the correct amount. Sometimes it is off by one and in another instance by more than one. These two particular records have both empty fields for Qty_Rec as well as balance due as some Work Orders did receive some of the parts ordered.
I would be most grateful for any advice.
Best regards,
I have created a report that is set to calculate the difference between parts ordered and parts received for various Work Orders and then list a sub total for each part number that has an outstanding balance due. All "Qty_Ord" fields have numbers, but "Qty_Rec" fields are many times blank as no parts have been received yet and/or the total "Qty_Rec" is less than the "Qty_Ord" so there is a balance due of the remainder.
On the report I put this in the part number footer section:
=Sum([Qty Ord])-Nz([Qty Rec],0)
In all instances except two it works fine, but in two instances it does not return the correct amount. Sometimes it is off by one and in another instance by more than one. These two particular records have both empty fields for Qty_Rec as well as balance due as some Work Orders did receive some of the parts ordered.
I would be most grateful for any advice.
Best regards,
Report sub totals not correct
