Skip to Content
0

Query for budget report

Jun 08, 2017 at 07:47 AM

75

avatar image
Former Member

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers