I am trying to get a SQL query to track incoming payments. Basically I would need to display the same information contained in the incoming payments windows.
Headers: Code, DocNum,
Lines: Document No. Instalment, Date, Due Date, Overdue Date, Total Payment
I know that most of the information can be extracted from OINV, ORCT and RCT2 but I am having problems trying to figure out the fields, Date, Due Date, Overdue Date.
Can anybody help me to create a query that displays this information?