AITT.TECHCA.APP

Posted: **Tue Mar 18, 2025 1:37 am**

1. Extract Negative ledgers in Sundry Debtors

2. Extract Negative ledgers in Sundry Creditors

3. Extract Negative ledgers in Sundry Loans

4. Ledgers created during the year

5. Ledgers where opening and closing Balances were same

6. List of Bank Ledgers

7. GST registered Debtors and Creditors

8. Unregistered Suppliers

9. Address of all Debtors and creditors

10. Sales Register

11. Purchase Register

12. Journal Register

13. 40A(3) Register

14. Sales / Purchase Transactions without GST

15. List of sundry Debtors > 100000

16. List of Sundry Creditors > 100000

17. Sales Transactions Less than 1 Lakhs

18. Group Trial Balance

19. Cash Flow Affecting Transactions summary / List

20. Entry Altered in the last week.

21. Ledgers altered in the last week.

22. Ledgers with no transactions.

23. Ledgers where it is squared off during the year.

24. List of entries affecting revenue in Daybook

25. Top 10 High value transactions.

26. Cash Transactions passed through Journals

27. Sales / Purchases passed through Journals

28. List of additions to Fixed assets

29. Payments Register

30. Receipts Register

31. List of Transactions involving GST Payment

32. List of Transactions involving GST Ledgers

Posted: **Tue Mar 18, 2025 2:25 am**

Code: Select all

SELECT $Name, $_PRimaryGroup,  $$ascramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Sundry Debtors" AND NOT $$IsDr:$ClosingBalance

Posted: **Tue Mar 18, 2025 2:30 am**

Code: Select all

SELECT $Name, $_PRimaryGroup,  $$ascramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Loans (Liability)" AND NOT $$IsDr:$ClosingBalance

Posted: **Tue Mar 18, 2025 3:01 am**

Code: Select all

Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry Debtors' And $Closingbalance > 100000

Posted: **Tue Mar 18, 2025 3:04 am**

SELECT $Name, $_primaryGroup,$GSTRegistrationType FROM Ledger WHERE ($_primaryGroup LIKE 'Sundry Debtors' OR $_primaryGroup LIKE 'Sundry Creditors') AND $GSTRegistrationType = Regular

Posted: **Tue Mar 18, 2025 3:07 am**

Code: Select all

SELECT $Name, $LedgerName, $OpeningBalance, $_closingBalance  FROM Ledger WHERE $OpeningBalance = $_closingBalance

Posted: **Tue Mar 18, 2025 3:07 am**

Code: Select all

Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry Creditors' And $Closingbalance > 100000

Posted: **Tue Mar 18, 2025 3:08 am**

Code: Select all

SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__DayBook Where $VoucherTypeName is like 'Journal' And ($LedgerName is like 'Purchase' Or  $LedgerName is like 'Sales')

Posted: **Tue Mar 18, 2025 3:16 am**

Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry creditors' And $Closingbalance > 100000

Posted: **Tue Mar 18, 2025 3:17 am**

Select $Name, $Parent, $_PrimaryGroup, $CreatedDate from ledger where $CreatedDate >=$$Date: '01-04-2020'

AITT.TECHCA.APP

Tally DayBook and Ledger Exercises

Tally DayBook and Ledger Exercises

Re: Tally DayBook and Ledger Exercises Ex 1

Re: Tally DayBook and Ledger Exercises Ex 3

Re: Tally DayBook and Ledger Exercises Ex 15

Re: Tally DayBook and Ledger Exercises EX 7

Re: Tally DayBook and Ledger Exercise 5

Re: Tally DayBook and Ledger Exercises EX16

Re: Tally DayBook and Ledger Exercises EX 27

Re: Tally DayBook and Ledger Exercises 16

Re: Tally DayBook and Ledger Exercises