<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Supplier Functions > PLBalance() |
PLBalance( Company, Account, Period, ReturnForexValue )
This function will return the outstanding balance or movement for the selected account and period specified.
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: This should be the supplier account number. Multiple accounts can be specified in the format ABC001, ABC002, ABC003.
Period: This is a predefined keyword that represents the period to return the balance for. x - can be a period from 1 to 13.
Month x - will return the current outstanding balance as at month specified
Last Year x - will return the outstanding balance as at the Last Year period specified
Net Month x - will return the net change in the balance outstanding for the period specified
Net Last Year x - will return the net change in the balance outstanding for the period last year
Year to Date x - will return the outstanding balance for the year to date up to the period specified
Last Year to Date x - will return the outstanding for last year to date up to the period specified
Year to Date x and Month x are interchangeable as both will return the outstanding balance
ReturnForeignBalance: If you set this to 1 the value returned will be the outstanding balance in foreign currency, anything else and the home currency balance will be returned.
The following will return the outstanding balance as at Month 1 in home currency
PLBalance( "c:\PastelData\_demo", "COM001", "Month 1", 0 )
The following will return the outstanding balance as at Month 1 last year in home currency
PLBalance( "c:\PastelData\_demo", "COM001", "Month 1", 0 )
The following will return the outstanding as a Month 1 for accounts COM001 and HARC001
PLBalance( "c:\PastelData\_demo", "COM001, HAR001", "Month 1", 0 ) |