cancel
Showing results for 
Search instead for 
Did you mean: 

link key between outgoing and payment means

Former Member
0 Kudos

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'

Accepted Solutions (1)

Accepted Solutions (1)

isaac_kalii
Active Participant
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

former_member212181
Active Contributor
0 Kudos

Hi Komal

OVPM - Outgoing payment Header

VPM1 - Outgoing Payments - Check Rows

VPM3 - Outgoing Payments - Credit Vouchers

Cash GL Account, Bank Transfer GL Account will be available in OVPM itself.

Thanks

Unnikrishnan

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check this thread

Thanks.