Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 06, 2008 at 05:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded