如何基于GetDate()、CASE和固定列别名进行GroupBy

Question

我正在尝试创建一个openAR文件，我被卡住了，试图按客户和发票分组此数据。文件将每天创建。

[开票金额]1000-100-750820

使用CTE引用别名。或者，在我的评论中，只对"CONVERT (nvarchar(30), GETDATE(), 101)"或"(GACC.AMOUNT_0 * GACC.SNS_0)"进行分组

With MyInvoices as 
(
SELECT 
CONVERT (nvarchar(30), GETDATE(), 101) as [FILE DATE],
GACC.BPR_0 as [CUSTOMER ID],
GACC.NUM_0 as [INVOICE NUMBER],
GACC.TYP_0 as [INVOICE TYPE], 
Case
When GACC.TYP_0 in ('INV', 'CM') Then CONVERT (nvarchar(30), SI.BPRDAT_0 , 101)
Else CONVERT (nvarchar(30), PAY.ACCDAT_0 , 101)
End as [INVOICE DATE],
(GACC.AMOUNT_0 * GACC.SNS_0) as [OPEN INVOICE AMOUNT]   
FROM dbo.GACCDUDATE as GACC
left join dbo.SINVOICE as SI 
on GACC.NUM_0 = SIV.NUM_0
left join dbo.PAYMENT as PAY  
on PAY.NUM_0 = GACC.NUM_0
)
select [FILE DATE], [CUSTOMER ID], [INVOICE NUMBER], [INVOICE TYPE],[INVOICE DATE],[OPEN INVOICE AMOUNT] from MyInvoices
group by  [FILE DATE], [CUSTOMER ID], [INVOICE NUMBER], [INVOICE TYPE],[INVOICE DATE]