06-08-2017 8:47 AM - edited 02-03-2024 10:49 PM
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 reportAcctCode AcctName--OACT PrjCode DebLTotal CredLTotalDebLTotal CredLTotal Current Amount Month Yearkindly help to solve..regards ManiUser | Count |
---|---|
99 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.