My client having a requirement of below needs to identify the charges of the particular ledger.
Please help with that query
sample query
select oact.acctname as Account_Name,OACT.CurrTotal from OACT
where AcctCode IN('700904','700903')
Thanks
Vinoth
Hi Jimmy,
I want to execute the report in sql.
can u please guide me.
Thanks
Vinoth
Hi Vinoth,
This report will need data from the JEs so you will need a join with JDT1.
The grouping by Month/Qtr/Year will be achievable depends on where the report will be run, in B1 using query report, in a Crystal report or in Excel.
For Crystal report or Excel, it's relatively easy to use a pivot table format and have the numbers grouped by the dates. If it's required to run as a query report, then you may use some PIVOT statement in your SQL script.
Cheers,
Jimmy