Code: Select all
Select $Name, $Createdby, $CreatedDate, $Masterid, $Alterid, $Alteredon, $Alteredby, $Updateddatetime, $LastVoucherDate, $Parent, $_PrimaryGroup, $$AscrAmt:$openingBalance, $$AscrAmt:$_ClosingBalance from ledger order by $Alterid descCopy paste the above code in the calculator Panel
Works without any TDL
Application of above Query in the Audit:
1. Helps in Identifying the Predated transactions in Tally.
2. List the Ledger on the basis of Date of Alteration.
3. Works even when the edit log is turned off or not used at all.
4. Last voucher date helps in indentifying the usage of the voucher
For feedback click here https://docs.google.com/forms/d/e/1FAI ... Q/viewform to inform the developer