Skip to Content
0

SAP Business One : Outgoing Payment Query

Nov 15, 2016 at 06:52 AM

84

avatar image

Hello,

Require a query from Outgoing Payments having the following fields


Doc Internal Id
Doc No
Doc Date
A/c Head (Vendor Name or Customer Name or Account payment )
Amount
Payment Mode (Cheque / Bank Transfer/Cash)
JE G/L Credit A/c (i.e. Journal Entry A/c Debit and Credit)
JE G/L A/c Debit

10 |10000 characters needed characters left characters exceeded

SELECT docentry, docnum, docdate, cardname, T0.[DocCurr], T0.[DocTotal], case when T0.[CashSum]>0 then 'Cash' when T0.[CheckSum]>0 then 'Check' when T0.[TrsfrSum]>0 then 'Bank Transfer' end as 'Pyament Mode', T0.[TrsfrAcct] as 'JE GL Credit A/C', cardcode as 'JE G/L A/c Debit' FROM OVPM T0

1

Thank You Edmund for your help but can you please also add a date from and to selection criteria

Full points to you

0

SELECT docentry, docnum, docdate, cardname, T0.[DocCurr], T0.[DocTotal], case when T0.[CashSum]>0 then 'Cash' when T0.[CheckSum]>0 then 'Check' when T0.[TrsfrSum]>0 then 'Bank Transfer' end as 'Pyament Mode', T0.[TrsfrAcct] as 'JE GL Credit A/C', cardcode as 'JE G/L A/c Debit' FROM OVPM T0 where T0.docdate>='[%0]' and T0.docdate<='[%1]'

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers