sync_to_sql
Pulls ledgers, groups, and stock items from TallyPrime into a temporary SQL cache, enabling fast arbitrary queries without repeated Tally calls. Replaces cache on company switch or re-sync.
Instructions
Pull ledgers, groups, and stock items from TallyPrime into this session's SQL cache (in-memory — gone when this session ends, and replaced whenever you switch company and re-sync, so nothing lingers between different companies), so query_sql can run fast arbitrary queries without hitting Tally each time. Does NOT sync vouchers — use sync_vouchers_to_sql for those, one date range at a time.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||