Page 1 of 1

AR Payment Terms, Invoice Due Date

Posted: Wed Jul 02, 2008 4:03 pm
by sethrosu
Wondering if anyone has any experience/advice with a problem I am having. I need to be able to search in AR for invoices that have a specific payment type and are due within a certain period of time. I have tried the collections>account details screen but there is no payment term criteria. Any suggestions would be greatly appreciated.

Posted: Thu Jul 03, 2008 4:56 am
by hiszaki
Hi sethrosu

I think you can use any SQL tools (ex. TOAD) to build your SQL statement with your specific conditions & get the results you need.

Best Regards,
Hisham