SHOWPAID
Returns the amount paid to a specific course in reports where you do not have pay detail but desire to display selected payments (i.e. in COURSE or DEADBEAT reporting).
Reporting Area(s)
Courses, Accounting
Required Parameters
- Course # (i.e. cocrse, rgcrse, pycrse)
Optional Parameters
- Character return value: Pay types to return (i.e. "12" returns cash/check payments). Default is all but billings/voids/refunds.
- Condition to return payments (i.e. "pyaddate > ctod('09/01/2002' " returns all payments made after 09/01/2002
Example(s)
SHOWPAID(cocrse) returns all payments except billings/voids/refunds (i.e. 102550.00)
SHOWPAID(cocrse,"","pyaddate > CTOD([09-01-2002])") returns all payments for course added after 9/1/2002