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. |