Inactive Contact Partners?

[Former Member]

Hi,

I've been looking for inactive Contact Partners but I cannt find it... where can I check for customers that have his account in status blocked? (so they cannt buy more products)

[edy_simon · Accepted solution]

Hi Jose,

The fields involved are

SELECT validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo  FROM OCRD

Need to check the combination of the 6 fields to determine.

Regards
Edy