Skip to Content

Query for budget report

Kindly mapping the below query's and Table.

1. [dbo].[EAVw_GetGLAmount] --> view query Alter VIEW [dbo].[EAVw_GetGLAmount] as SELECT MONTH(T1.[RefDate]) as 'GLMonth',YEAR(T1.[RefDate] ) as 'GLYear',T0.[Account], T0.[Project], SUM(T0.[Debit]) AS 'CurrentAmount' FROM JDT1 T0 INNER JOIN OJDT T1 ON T0.[TransId] = T1.[TransId] GROUP BY T0.[Account], T0.[Project],MONTH(T1.[RefDate]),YEAR(T1.[RefDate]) UNION ALL SELECT MONTH(T1.[RefDate]) as 'GLMonth',YEAR(T1.[RefDate] ) as 'GLYear',T0.[Account], T0.[Project], SUM(T0.[Credit]) AS 'CurrentAmount' FROM JDT1 T0 INNER JOIN OJDT T1 ON T0.[TransId] = T1.[TransId] GROUP BY T0.[Account], T0.[Project],MONTH(T1.[RefDate]),YEAR(T1.[RefDate])2. I need to map this view query with OACT ,OBGS,OBGT and BGT1 3..NOTE: Field Name'sI need this fields in report AcctCode AcctName--OACT PrjCode DebLTotal CredLTotal DebLTotal CredLTotal Current Amount Month Yearkindly help to solve..regards Mani
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers