AnalyticAccountAccountingAccountBalance
This method returns the balance of the amount attributed for an account to an analytical account, up to a given date.
Syntax:
oBiz.AnalyticAccountAccountingAccountBalance(<cAnaAccount>, <cAccountingAccount>, [<dDateEnd>][, <dDateStart>])
Parameters |
Description |
lcAnaAccount |
Analytical account number. |
cAccountingAccount |
Account number. |
dDateEnd |
The recordings up to this date are considered. This parameter is optional. If the parameter is omitted, the recordings up to the end of the fiscal year are considered. |
dDateStart |
The recordings starting from this date are considered. The parameter is optional. If the parameter is omitted, the recordings starting from the beginning of the fiscal year are considered. |
Example:
*/ Instantiate end set the database location.
oBiz = createobject("bizinfo.application")
oBiz.cDatabasePath = "C:\WinBIZ Data"
oBiz.nCompany = 1000
oBiz.nYear = 2017
*/ Display the total balance for the fiscal year for the amounts of the account 1000 attributed to the analytical account 100.7022.3.
messagebox(oBiz.AnalyticAccountBalance("100.7022.3", "1000"))
*/ Display the same balance of the previous example, up to the 01.03.2017.
messagebox(oBiz.AnalyticAccountBalance("100.7022.3", "1000", {01.03.2017}))
*/ Display the same balance of the previous example for the month of march 2017 only.
messagebox(oBiz.AnalyticAccountBalance("100.7022.3", "1000", {01.03.2017}, {31.03.2017}))