Overview
Active Commodities
Two fields on the Commodity object determine if the commodity is active:
Effective Date
Expired Date
If neither field is populated, the record is active.
If both fields are populated, assuming Expired Date > Effective Date, the First Stop Pickup Date must land between the two dates for the commodity to be active.
If only the Expired Date is populated, then if First Stop Pickup Date < Expired Date, the commodity is active.
If only the Effective Date is populated, then if First Stop Pickup Date > Effective Date, the commodity is active.
Is Active field is a formula checkbox field.
The formula is based on System Date rather than First Stop Pickup Date.
In the Enhanced Commodity Search results, the component determines whether the commodity is active based on First Stop Pickup Date, not the system date. Inactive commodities may be shown in the search results (depending on filter values), but cannot be selected.