Skip to Content
avatar image
Former Member

link key between outgoing and payment means

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'

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 25, 2015 at 01:25 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2015 at 10:14 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • May 23, 2015 at 09:56 AM

    Hi,

    Please check this thread

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded