Learn Tally ERP 9 programming without Tally Developer

This program defines a Collection called MyStatistics.

;;****** Collection definition ******
;;MyStatistics is a collection that contains a single Object (record) called MyObjects.
;;IsODBCTable is set as YES so that this collection is accessible to external programs

[Collection: MyStatistics]
Object: MyObjects
IsODBCTable: Yes

;;******* Object Definition *********
;;Herein we are defining an Object called

“MyObjects” which comprises of THREE

fields
;;1st: DebtorsLedgers – Number of Ledgers falling under group Sundry Debtors
;;2nd: CreditorsLedgers – Number of

Ledgers falling under group Sundry

Creditors
;;3rd: AllLedgers – Total Number of Ledgers
;;The FilterCount function requires a Formula (i.e. condition) as the 3rd parameter.
;;which is defined below
[Object: MyObjects]
DebtorsLedgers :

$$FilterCount:Ledger:HasSundryDebtors
CreditorsLedgers:

$$FilterCount:Ledger:HasSundryCreditors
AllLedgers :

$$FilterCount:Ledger:AlwaysTrue

;;******* Global Formula definition ********
;;$Name refers to the Field NAME of

Ledger Collection

[System: Formula]
HasSundryDebtors :

$$IsLedOfGrp:$Name:$$GroupSundryDebtors HasSundryCreditors:

$$IsLedOfGrp:$Name:$$GroupSundryCreditors
AlwaysTrue : $$IsWindows
;;Notes
;;=====
;; $$IsLedOfGroup is a Tally Interenal Function that is used to check whether a Ledger falls under a
;; specific Group or not.
;; Syntax :- $$IsLedOfGroup: :
;; Return Value:- Logical
;;
;; $$IsWindows is a Tally Internal Function which checks whether the OS is Windows or not.
;; Syntax :- $$IsWindows
;; Return Value:- Logical
;;
;; $$GroupSundryDebtors is a Tally Internal Function
;; Syntax :- $$GroupSundryDebtors
;; Return Value:- String: The Group-Name for pre-defined Tally Group “Sundry Debtors”
;;
;; $$GroupSundryCreditors is a Tally Internal Function
;; Syntax :- $$GroupSundryCreditors
;; Return Value:- String: The Group-Name for pre-defined Tally Group “Sundry Creditors”