on 01-24-2022 8:26 AM
Dear Experts,
Can I get a query that shows all the A/P Invoices that are directly entered without a base document.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]'
Thank you guys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.