Down Payment invoice

[Former Member]

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.

[former_member583013 · Accepted solution]

Izak,

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.

Suda