Report Design Nav 2009 R2

Hi,

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]

tdpj3nhpdbxd.png


Thanks,
Prasoothan

Best Answer

Answers

Sign In or Register to comment.