KI (All) - Total Creditors and Total Debtors widget sorts period in alpha order

Issue

Support has confirmed that the Total Creditors Widget sort's a period in alpha order rather than date.

The periods in the Total Creditors widget in Business Analytics are not sorted in period order e.g. they display April, June, May.

Workaround

SQL Code to replace Total Creditors

select cast(sum(SalesValueUnallocated) as money) as Amount,
'0. Overdue' as Period
from Analytics_PurchaseTransaction
where duedate < getdate()
union
select cast(sum(SalesValueUnallocated) as money) as Amount,
CONCAT( AgePeriod,'. ',DATENAME(month, DueDate)) as Period
from Analytics_PurchaseTransaction
where duedate >= getdate()
group by PeriodName,DATENAME(month, DueDate),AgePeriod
order by Period

SQL Code to replace Total Debtors

select cast(sum(SalesValueUnallocated) as money) as Amount,
'0. Overdue' as Period
from Analytics_SaleTransaction
where duedate < getdate()
union
select cast(sum(SalesValueUnallocated) as money) as Amount,
CONCAT( AgePeriod,'. ',DATENAME(month, DueDate)) as Period
from Analytics_SaleTransaction
where duedate >= getdate()
group by PeriodName,DATENAME(month, DueDate),AgePeriod
order by Period

Resolution

Attached to Problem ticket 11964596015 to be resolved in a future release.