Skip to Content
0
Former Member
Nov 21, 2011 at 09:53 AM

Query to pull out Vendor details with AP invoice

254 Views

Hi all

I have made the following query to pull out the following data

House Bank Account, Customer/Vendor Name,Payment Method code,Default Account,Default Branch,Default bank Internal id,

Document NUmber,Customer/Vendor Ref No,Row Total,Item/Service description,Branch,Street

SELECT T0.[HousBnkAct], T1.[CardName], T0.[PymCode], T0.[DflAccount],T0.[DflBranch], T0.[BankCtlKey], T1.[DocNum],T1.[NumAtCard], T2.[LineTotal], T2.[Dscription], T3.[Branch], T3.[Street] FROM OCRD T0 INNER JOIN OPCH T1 ON T0.CardCode = T1.CardCode INNER JOIN PCH1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DSC1 T3 ON T0.HousActKey = T3.AbsEntry WHERE T1.[DocDate] >=[%0] AND T1.[DocDate] <=[%1] AND T1.[DocStatus] = 'o' AND T0.[PymCode] = 'EFT'

But i have observed that i am not getting all the customers in this query where the invoice is open, it displays only few records.

Regards

Farheen