Customer/Vendor Information Pro

On this Page:
 Cust/Ven Info
 Cust/Ven Turnover
 by Cost Centres
 Different Periods

The following functions compliments the functions we have seen above to provide additional useful reporting data.

All of the following requires the Pro version. see Prices

 

Get Customer/Vendor Information

Syntax: =CXL.ContactName( CompCode, CustVendCode, [Options] )
Performance Rated:C

This will get the Customer/Vendor Name

Syntax: =CXL.ContactAdd1( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactAdd2( CompCode, CustVendCode, [Options] )
Performance Rated:C

This will get the Customer/Vendor Name address from Consolidated XL encrypted Database.

Syntax: =CXL.ContactAddName1( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactAddName2( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactPriName( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactNumber( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactDDINumber( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactMobNumber( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactFaxNumber( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactWebSite( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactEmail1( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactRegNumber( CompCode, CustVendCode, [Options] )
Performance Rated:C
Syntax: =CXL.ContactCurrency( CompCode, CustVendCode, [Options] )
Performance Rated:C

Get various Customer/Vendor data from Consolidated XL encrypted Customer/Vendor Database.

Parameters:

Parameter Description
CompCode Short code assigned by Consolidated XL, or by you to identify your company.
CustVendCode Customer/Vendor code
Customer/Vendor Name if you don't use Account Codes
Options Future use?