Skip to Content
0
Former Member
Jul 30, 2012 at 07:30 AM

creating a query from incoming payment

366 Views

Hi SQL expert,

i need a query that has an open balance of payment (outstanding payment) per customer. How can i achieve this? i know i should use ORCT as the header but not sure on the item. should it be rct1, rct2 or rct3?

Thanks.
Harith