<< Click to Display Table of Contents >> Navigation: PaXcel - functions > GL Functions > CBBalance() |
CBBalance( Company, Account, Period, ValueType )
This function will retrieve the Cashbook value in currency (if a currency Cashbook)
The arguments are as follows:
Company: This is the path to your Pastel data directory. For example:
c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company.
Account: The GL Account number of the cashbook. You can only enter a single account number.
Period: The period to calculate the figures for. The keywords found in GLBALANCE can also be used here.
ValueType: Enter "H" for home, anything else for currency value.
Return the cashbook balance for account 8400/000 from Pastel for period 1 then the formula would be:
CBBalance( "c:\PastelData\_demo", "8400000", "Month 1", "H" )
The "H" indicates to retrieve the home currency value, which is the same as using the GLBalance function.
If we change this to "F" we will get the foreign currency value. If the amount returned is zero then it is a home currency cash book.
CBBalance("c:\PastelData\_demo", "8400000", "Month 1", "F" )
|