Gl Accounting

bench get-app https://github.com/glascutr/gl_accounting

[![Listed on Frappe Gems](https://frappegems.com/api/method/frappe_gems.seo.badge?app=glascutr%2Fgl_accounting)](https://frappegems.com/gems/apps/glascutr/gl_accounting)

### GL Accounting Simple Acounting for money craft. ### Installation You can install this app using the [bench](https://github.com/frappe/bench) CLI: ```bash cd $PATH_TO_YOUR_BENCH bench get-app $URL_OF_THIS_REPO --branch main bench install-app gl_accounting ``` ### Contributing This app uses `pre-commit` for code formatting and linting. Please [install pre-commit](https://pre-commit.com/#installation) and enable it for this repository: ```bash cd apps/gl_accounting pre-commit install ``` Pre-commit is configured to use the following tools for checking and formatting your code: - ruff - eslint - prettier - pyupgrade ### CI This app can use GitHub Actions for CI. The following workflows are configured: - CI: Installs this app and runs unit tests on every push to `develop` branch. - Linters: Runs [Frappe Semgrep Rules](https://github.com/frappe/semgrep-rules) and [pip-audit](https://pypi.org/project/pip-audit/) on every pull request. ### License mit # HTML ``` ``` # Context ``` context.transactions = frappe.db.get_all("Transaction", fields="*") ``` # Script ``` function printTable() { let printContents = document.getElementById("print-area").innerHTML; let originalContents = document.body.innerHTML; document.body.innerHTML = printContents; window.print(); document.body.innerHTML = originalContents; location.reload(); } ``` # Style ``` @media print { .no-print { display: none !important; } } ``` # SQL with python script ``` total_cash_amount = frappe.db.sql(""" SELECT SUM(amount) FROM `tabTransaction` WHERE type='Cash Amount' """)[0][0] print("Total Cash =", total_cash_amount) # # ------------------- # total_cash_amount = frappe.db.sql(""" SELECT SUM(amount) FROM `tabTransaction` WHERE type='Cash Amount' or type='Bank Credit' """)[0][0] print("Total Cash =", total_cash_amount) ``` transactions = frappe.db.sql(""" SELECT tr.date, tr.particulars, tr.cheque, tr.voucher_type, tr.folio_no, tr.type, tr.amount, ah.name1 FROM `tabTransaction` tr INNER JOIN `tabAccounts Head` ah ON tr.accounts_head = ah.name """)