Though the customer’s renewal date as per FreshOps is next year, they might still see a payment banner in their Freshdesk account. 


This would happen when there are pending invoices for this account in Chargebee. To check if there are any pending payments, we can use the below query in Haystack,


“Account_id” and “payment_due”


"id"=>"ev_Azz3uSSKC5uss5PvV", "occurred_at"=>1608907979, "source"=>"scheduled_job", "object"=>"event", "api_version"=>"v1", "content"=>{"invoice"=>{"id"=>"FD1168287", "sub_total"=>76500, "start_date"=>1605629108, "customer_id"=>"641294", "subscription_id"=>"641294", "recurring"=>true, "status"=>"payment_due" 


Above is what the log result would look like and we can see the invoice ID that is pending to be paid.