Customer On Account Payments

Is there a report that shows all customers accounts with an open on account payment?

  • 0

    I'm not aware of one - you might have to write one. I knocked one out based on customers like this

    Based on Audit Header and selecting only SA transactions

  • 0

    I used the Customer Reports>Customer Invoices>SL_UNALL (Un-Allocated Sales Credit Notes & Payments on Account) as the basis for my unallocated transactions reports.

    If you edit the filter to remove the SC bit, ie from 

    (AUDIT_SPLIT.TYPE LIKE "SC" OR AUDIT_SPLIT.TYPE LIKE "SA") AND AUDIT_SPLIT.OUTSTANDING <> 0

    to

    AUDIT_SPLIT.TYPE LIKE "SA" AND AUDIT_SPLIT.OUTSTANDING <> 0

    It will list only those Payments on Account which are outstanding (unallocated).  You may like to add AND AUDIT_SPLIT.DELETED_FLAG=0 to the end, ie:

    AUDIT_SPLIT.TYPE LIKE "SA" AND AUDIT_SPLIT.OUTSTANDING <> 0 AND AUDIT_SPLIT.DELETED_FLAG=0

    to ensure deleted records are definitely ignored.

    Finally change the GROSS_AMOUNT variable to OUTSTANDING (same table) in the Details and Report Footer sections: it will list only the amount of those payments on account which is currently outstanding and not the original amount.

    If you've deallocated some SR (Sales Receipts) and want to include those, change the filter to:

    (AUDIT_SPLIT.TYPE LIKE "SR" OR AUDIT_SPLIT.TYPE LIKE "SA") AND AUDIT_SPLIT.OUTSTANDING <> 0 AND AUDIT_SPLIT.DELETED_FLAG=0

  • 0 in reply to Robert N

    Nice one Robert - I've just done the same but added Outstanding as another column.

  • 0 in reply to Robert N

    That is great! Thanks for your help!