We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

DECLARE @D1 DATE

DECLARE @D2 DATE

SET @D1= '2019-1-1'

SET @D2= '2019-3-31'


select T0.BaseRef as 'Doc Num' ,T0.RefDate as 'Posting Date' ,T0.TaxDate as 'Document Date',T0.Ref2 as 'Ref No2.',

Account=(CASE WHEN T2.AcctName IS NULL THEN t3.Cardname else T2.AcctName end ),

T0.TransId,T3.CardName,

T1.Account as AccountCode,T1.BPLName as Branch,
SUM(T1.Debit) as 'Debit',SUM(T1.Credit) as 'Credit',
(SELECT SUM(t1.Debit) - SUM(t1.Credit) FROM JDT1 Where RefDate <= DATEADD (dd, -1, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) +1, 0)) and Account = T1.Account Group by Account) AS 'Opening Balance',


t1.ShortName,
case
when T0.Memo like '%Outgoing Paymentst%' then
(select top 1 Comments from OVPM where docnum = T0.BaseRef)
when T0.Memo like '%A/P Invoices%' then
(select top 1 Comments from opch where docnum = T0.BaseRef)

else
T0.Memo

end as Particular,

case
when T0.Memo like '%Outgoing%' then
(select CardName from OVPM where docnum = T0.BaseRef)
when T0.Memo like '%A/P Invoices%' then
(select CardName from opch where docnum = T0.BaseRef)

else
T0.Memo

end as Vendor


from OJDT T0


inner join JDT1 T1 on T0.TransId =T1.TransId

inner join oact tr3 on tr3.AcctCode = T1.account

left outer Join OACT T2 ON T2.AcctCode=T1.ContraAct

left outer join OCRD t3 on t3.CardCode=T1.ShortName


where T0.RefDate>=@d1 and T0.RefDate<=@d2

Group By T0.BaseRef,T0.TransId ,T0.RefDate,T0.TaxDate,t1.Line_ID,T0.Ref2, T1.[ContraAct],Tr3.AcctName, T2.AcctName,t3.cardname,
T1.Account,T1.Debit, T1.Credit,T1.BPLName,t1.ShortName,T1.SYSCred,T0.Memo,t3.cardname


Order by T0.TransId

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 137

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Reply to This

Replies to This Discussion

Ya Asim Bajwa ka subject hy wo university min pechly 10 sal say yhi phara rha hy. jab online aye tu kanoo sy nap lena usy.

ho gya resolved issue thanks bro

Us k begir hi

Sir aap bhi kisi say kam nahi, sirf khud ko chuptay har jagah kabhi apni karmaat ki jhalak deikhyain tu sahi

khoubsorat code, masla kiya hay?

MAsla bht bra hai :P mat pouchooo   

Wesa ap k ati qury ??

bro meri qabliyat par shaq kar rahay?

Har kisam kay kaam kar laita mein

come ib ... 

mjhy tou smj hi ni aii

RSS

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.