Missing acknowledgement buttons on a payment cycle in Mosaic are usually due to invoices which have not been acknowledged on previous cycles.
β
Please raise a new case online and reference the title of this article, and we can help you locate which previous cycles contain unacknowledged invoices.
β
Otherwise, feel welcome to also self-serve and create a local report using the script below which looks for all certified invoices from previous cycles where the date of acknowledgement received is null. These will be the list that you will need to work through by going back to those cycles and addressing these.
β
βScript to identify
select mosaic_names.organisation_name(ra.payee_organisation_id), mosaic_names.person_name(ra.payee_person_id), ra.* from ra_acknowledgements ra
join invoices i
on i.payment_cycle_id = ra.payment_cycle_id
and coalesce(i.payee_org_id,0) = coalesce(ra.payee_organisation_id,0)
and coalesce(i.payee_person_id,0) = coalesce(ra.payee_person_id,0)
and i.status = 'C'
where ra.date_ackno_received is null
order by ra.created_on desc
Once you have then addressed these, these invoices should then move from 'Awaiting Acknowledgement' to 'Pending'
