Rep_ClientView

Reference No: 21794

(V 02.00.01-00)

Details

In CR2, you can generate custom report using Rep_ClientView, which will display the Customer Balance Information. Details of the columns are as given in Table 1.0.

Table 1.0 Column Reference Table

Field	Description
CUSTOMERID	Unique ID of the customer.
CUSTOMERSTATUS
COMPANYNAME	Name of Company.
UCCOMPANYNAME	Name of Company in upper case.
CONTACTID	Customer Main Contact ID.
PAYMENTTERMSID	ID of Payment Term set for the customer.
CREDITLIMIT	Customer Credit Limit.
BALANCE	Total amount due for the customer.
CUSTOMERIID	Customer IID.
OPENORDERBALANCE	Total amount due on Open Orders.
INVOICESBALANCE	Total amount due on Invoices.
Open Order Balance	To view the values as displayed in the Accounts tab of Customer Edit window for the respective fields.
Invoices Balance	To view the values as displayed in the Accounts tab of Customer Edit window for the respective fields.