Hi All,
I'm a new user of SAP B1 Please help me generate query for unpaid vendor by due date. Below is the query that I did. But I want to modify and will only display unpaid vendor. Thanks..
SELECT T2.[CardCode], T2.[CardName], T0.[TransId], T0.[DueDate], T1.[Credit], T1.[U_DisBank], T4.[Name] FROM OJDT T0 INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId INNER JOIN OCRD T2 ON T1.ShortName = T2.CardCode INNER JOIN "@HOFFICE" T4 ON T1.U_Disbank = T4.Code WHERE T1.[Credit] !=0 AND T0.[DueDate] >=[%0] AND T0.[DueDate] <=[%1] ORDER BY T4.[Name]
Edited by: Arlmi2000 on May 27, 2011 10:35 AM