Skip to Content
Former Member
Apr 30, 2013 at 03:32 PM

Incoming Payments Query


Hi All,

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?