on 06-26-2015 7:22 PM
Hi
Any Body share TDS Query in SAP Business one.
Gopi
Close the Thread with the correct and helpful answers
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check this one for the detailed one
SELECT T2.[DocNum], T0.[DocDate], T2.[CardCode], T2.[CardName], T2.[BaseAmnt], T4.[Rate], T4.[WTAmnt], T0.[BSRCode], T0.[ChallanNo], T1.[DueDate], T1.[CheckNum], T1.[CheckSum] FROM OVPM T0 INNER JOIN VPM1 T1 ON T0.DocEntry = T1.DocNum INNER JOIN OPCH T2 ON T0.DocEntry = T2.DepositNum INNER JOIN PCH1 T3 ON T2.DocEntry = T3.DocEntry INNER JOIN PCH5 T4 ON T2.DocEntry = T4.AbsEntry GROUP BY T2.[DocNum], T0.[DocDate], T2.[CardCode], T2.[CardName], T4.[WTAmnt], T1.[DueDate], T1.[CheckNum], T1.[CheckSum], T0.[BSRCode], T0.[ChallanNo], T2.[BaseAmnt], T4.[Rate]
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gopinath...
Try this one
select T0.DocNum, T0.DocDate, T0.CardName, T0.DocTotal, T0.WTSum,T2.WTName, T1.Rate from opch T0
inner join pch5 T1 on T0.Docentry=T1.Absentry
inner join owht T2 on T1.WTcode=T2.WTCode
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
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.