From dbd5ae96e06cb6dfdbeed7e019b519c6c71cf7c5 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 20 Jan 2009 20:11:05 +0000 Subject: [PATCH] whew, hopefully that will actually fix agent-specific invoices migrated from 1.7->1.9, RT#4645 --- FS/FS/cust_main.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index 77e08fe1c..e6c808408 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -7075,7 +7075,7 @@ sub _agent_plandata { " AND peo_agentnum.optionname = 'agentnum' ". " AND ( agentnum IS NULL OR agentnum = $agentnum ) ". " ORDER BY - CASE WHEN peo_cust_bill_age.optionname != 'cust_bill_age' + CASE WHEN part_event_condition_option.optionname IS NULL THEN -1 ELSE ". FS::part_event::Condition->age2seconds_sql('part_event_condition_option.optionvalue'). " END -- 2.11.0