Flowfield query - count of late purchase order receipts

Datapac

I'd like to create a flowfield on the Vendor table that gives me a count of late PO receipts. i.e.
Count(Purch Rcpt Header)
Purch Rcpt Header.Buy from Vendor = Vendor.No AND
Purch Rcpt Header.Expected Receipt Date < Purch Rcpt Header.Posting Date

Is this possible using flowfields?
Or do I have to add a boolean flag to the Purch Rcpt Header to say whether a delivery was on time, stamp it on the PO Post Receipt and count this new boolean flag for my Flowfield?

Thanks in advance,
Richie

ara3n

Can't use flowfields for this. You can have a boolean and that would do it.

Savatage

we did something similar -
we added a command button to the vendor card that pulls up the purch recipts list. The list is filtered on "Late reciept" boolean = YES

we added a boolean to the vendor card - field class Flowfield and use the "If Exists" method to show us if indeed that particular vendor has any late orders.

& if you want to see the late orders then we can click the command button to bring up the list. *edit* you can also add a count at the bottm of that list if you wish

It's kind of like the Comment button.

Hope that made sence... :-k

DenSter

I would probably add this to the F9 statistics form, there is already similar functionality. Just for fun, open the Vendor Card and press F9, see what happens

Savatage

using the same theory

LateReceiptCount = Decimal

On the Header....
If Date Received > Expected date
then
LateReceiptCount := 1
Else
LateReceiptCount := 0

Then every header would have a 1 or a 0

adding a flowfield to the vendor table summing this By vendor should give you a count of how many late by a vendor. :-k