ADDAPAY

Returns field from Pay table for a specific payment.

Reporting Area(s):

Registrations, Accounting

Required Parameters:

  1. Search key field from Pay table (i.e. pysubid (default), pyrecnum, pyinvnum, pydate, pyacctfor)
  2. Field from Pay table to return (i.e. "pytypye", "pyuser")

Optional Parameters:

  1. Logical .t. returns "* PYSUBID not found" if no payment exists, .f. returns a blank
  2. Character sort value - ONLY required if using search key field other than pysubid:

"receipt"=if searching by pyrecnum

"pydate"= if searching by pydate

"pyinvnum"= if searching by pyinvnum

"pyacctfor"= if searching by pyacctfor (deposit number)

"invoice"= if searching by pyinvnum and only want to return billing records

Example(s):

ADDAPAY(pysubid, "pydate") returns payment date for pay record

ADDAPAY(pysubid,"pydate",.t.) returns payment date if payment has been made, but returns "* PYSUBID not found" if no payment exists

ADDAPAY(pyrecnum, "pytype",.t.,"receipt") returns payment type for pay record using pyrecnum as search and sort key

Notes:

PYSUBID field is unique for each pay record, so this function will give you a data element for one payment record. Deleted payment records are automatically excluded.

 

Related Topics Link IconRelated Topics