I am new to CSIDE and C/Al. I am using Nav 2009 R2.
I would like to design a report based on the following SQL Query. Please guide.
select [Item Category Code], sum(B.[Invoiced Quantity]) as Qty, sum([Cost Posted to G_L]) as Value
from [CRONUS International Ltd_$Item] A
inner join [CRONUS International Ltd_$Value Entry] B
on A.No_ = B.[Item No_]
where B.[Posting Date] <= '04/30/2019'
group by A.[Item Category Code]
order by A.[Item Category Code]