cancel
Showing results for 
Search instead for 
Did you mean: 

AP INVOICE DIRECT ENTRY QUERY

thobenjo1
Explorer
0 Kudos
202

Dear Experts,

Can I get a query that shows all the A/P Invoices that are directly entered without a base document.

Thank you

nikunjmehta2290
Participant
0 Kudos

Hello thobenjo1 ,

Below query helps you.

SELECT T0."DocNum", T1."ItemCode", T1."Dscription", T1."LineStatus", T1."BaseLine", T1."BaseEntry", T1."BaseType", T1."BaseRef" FROM OPCH T0 INNER JOIN PCH1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE T0."DocDate" >= '[%0]' and T0."DocDate" <= '[%1]'

View Entire Topic
thobenjo1
Explorer
0 Kudos

Thank you guys