Down Payment invoice
I was wondering if anyone of you can tell me in which table are unapplied downpayments kept.
I am trying to write a report in crystal which will tell my client which downpayments are still open and havent been applied to a final sale yet, but I cannot use OPDI.DocStatus as the moment the incoming payment is received, the DPMT Invoice is closed, but still available to draw later on.
I would approach this from the Down Payment G/L Account.
Create a query taking all the un-reconcilled transactions in the Down Payment G/L Account.