How To: Retrieve account, main account or segment description

Product:  BizInsight
Applies to:  MAS 90/200
Article Type:  How To 

To retrieve a description for an account or a segment in your report, you can use one of the following functions:

Function to retrieve an account’s description:

=BizItems("Account Desc Function", "MAS90_Accounts","CompanyCode","", "AccountDesc","MAX", "CompanyCode=" & "ABC", "Account=" & "100-00-00")

Function to retrieve a main account’s description:
=BizItems("Account Desc Function", "MAS90_MainAccountCode","CompanyCode","", "MainAccountShortDesc","MAX", "CompanyCode=" & "ABC", "MainAccountCode=" & "101")

Function to retrieve the description for a segment:

=BizItems("Segment Desc Function", "MAS90_SubAccounts","CompanyCode","", "SubAccountDesc","MAX", "CompanyCode=" & "ABC", "SegmentNo=" & "02","SubAccountCode=" & "10")

The above functions have values hard coded for the key parameters.  Be sure to adjust to appropriate values or cell references. 

These functions are designed to work with a configured BizFunctions.xml file rather than the demo BizFunctions.xml.  If you get the error “Unable to locate definition for Cache: MAS90_XXXXX”, you are using the demo BizFunctions.xml and need to configure a BizFunctions.xml using the BizFunctions_Template.xml.  For information on how to create a configured BizFunctions.xml, please refer to the Installation Guide on www.biznetsoftware.com/products/sage/mas90_200.

If this article does not address your question, please contact BizNet Software Support for further assistance.