Skip to content

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.

ADDGRPAY
ADDPAY
COPAYDTL
GTPAID
ORGPAY
OTHPAYER
PAYTYPE
RCPTINFO
GRPGTPAID
GTCOPAID
GTINVPAID
NETPAY
PAYCOMB
PAYTOT
RCTTPAY
RGHASPAY
RGINVPD
WHOPAY