on 05-23-2015 7:44 AM
Hello Experts,
Can you tell me what is the key link between outgoing and payment means.?
Or can anyone help me in getting the details of all the checks, amount and bank from payment means without the record of 'INTER BANK TRANSFERS'
Hi Komal
Try this:
SELECT | TOP (100) PERCENT dbo.OVPM.DocNum, dbo.VPM4.LineId, CONVERT(varchar, dbo.OVPM.DocDate, 103) AS DocDate, CONVERT(varchar, dbo.OVPM.CreateDate, 103) |
AS CreateDate, UPPER(dbo.VPM4.Descrip) AS Details, dbo.VPM4.SumApplied AS Amount, dbo.OACT.AcctName | |
FROM | dbo.OACT AS OACT_1 RIGHT OUTER JOIN |
dbo.OACT INNER JOIN | |
dbo.VPM4 ON dbo.OACT.AcctCode = dbo.VPM4.AcctCode INNER JOIN | |
dbo.OVPM ON dbo.VPM4.DocNum = dbo.OVPM.DocEntry ON OACT_1.AcctCode = dbo.OVPM.CashAcct | |
WHERE | (NOT (dbo.OACT.AcctCode IN (N'_SYS00000000179', N'_SYS00000000180'))) AND (dbo.OVPM.CashAcct IN (N'_SYS00000000179', N'_SYS00000000180')) |
NOTE: In the WHERE you can input the desired parameters.
Regards,
Isaac.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It didn't help.
what I want is the details of outgoing checks from OCHO (payment means) table.
its showing all records but, i want to make some condition.
that is, a record of particular G/L account should not come in result.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
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.