Struct SqliteGeneralLedgerRepository 

pub struct SqliteGeneralLedgerRepository { /* private fields */ }

Available on crate feature sqlite only.

Implementations

impl SqliteGeneralLedgerRepository

pub const fn new(pool: Pool<SqliteConnectionManager>) -> Self

Trait Implementations

impl Debug for SqliteGeneralLedgerRepository

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl GeneralLedgerRepository for SqliteGeneralLedgerRepository

fn create_account(&self, input: CreateGlAccount) -> Result<GlAccount>

Create a GL account

fn get_account(&self, id: Uuid) -> Result<Option<GlAccount>>

Get account by ID

fn get_account_by_number( &self, account_number: &str, ) -> Result<Option<GlAccount>>

Get account by account number

fn update_account(&self, id: Uuid, input: UpdateGlAccount) -> Result<GlAccount>

Update account

fn list_accounts(&self, filter: GlAccountFilter) -> Result<Vec<GlAccount>>

List accounts (Chart of Accounts)

fn get_account_hierarchy(&self) -> Result<Vec<GlAccount>>

Get account hierarchy (parent-child)

fn delete_account(&self, id: Uuid) -> Result<()>

Delete account (only if no transactions)

fn initialize_chart_of_accounts(&self) -> Result<Vec<GlAccount>>

Initialize default Chart of Accounts

fn create_period(&self, input: CreateGlPeriod) -> Result<GlPeriod>

Create a GL period

fn get_period(&self, id: Uuid) -> Result<Option<GlPeriod>>

Get period by ID

fn get_current_period(&self) -> Result<Option<GlPeriod>>

Get current open period

fn get_period_for_date(&self, date: NaiveDate) -> Result<Option<GlPeriod>>

Get period for a date

fn list_periods(&self, filter: GlPeriodFilter) -> Result<Vec<GlPeriod>>

List periods

fn open_period(&self, id: Uuid) -> Result<GlPeriod>

Open a period

fn close_period(&self, id: Uuid, closed_by: &str) -> Result<GlPeriod>

Close a period

fn lock_period(&self, id: Uuid, locked_by: &str) -> Result<GlPeriod>

Lock a period (prevents any changes)

fn reopen_period(&self, id: Uuid) -> Result<GlPeriod>

Reopen a closed period (not locked)

fn create_journal_entry( &self, input: CreateJournalEntry, ) -> Result<JournalEntry>

Create a journal entry

fn get_journal_entry(&self, id: Uuid) -> Result<Option<JournalEntry>>

Get journal entry by ID

fn get_journal_entry_by_number( &self, number: &str, ) -> Result<Option<JournalEntry>>

Get journal entry by number

fn list_journal_entries( &self, filter: JournalEntryFilter, ) -> Result<Vec<JournalEntry>>

List journal entries

fn post_journal_entry(&self, id: Uuid, posted_by: &str) -> Result<JournalEntry>

Post a journal entry (update account balances)

fn void_journal_entry(&self, id: Uuid) -> Result<JournalEntry>

Void a journal entry

fn reverse_journal_entry( &self, id: Uuid, reversal_date: NaiveDate, ) -> Result<JournalEntry>

Reverse a journal entry (creates reversing entry)

fn get_journal_entry_lines( &self, journal_entry_id: Uuid, ) -> Result<Vec<JournalEntryLine>>

Get journal entry lines

fn get_auto_posting_config(&self) -> Result<Option<AutoPostingConfig>>

Get active auto-posting config

fn set_auto_posting_config( &self, input: CreateAutoPostingConfig, ) -> Result<AutoPostingConfig>

Create/update auto-posting config

fn auto_post_invoice(&self, invoice_id: InvoiceId) -> Result<JournalEntry>

Auto-post invoice creation (DR AR / CR Revenue)

fn auto_post_payment_received(&self, payment_id: Uuid) -> Result<JournalEntry>

Auto-post payment received (DR Cash / CR AR)

fn auto_post_bill(&self, bill_id: Uuid) -> Result<JournalEntry>

Auto-post bill creation (DR Expense / CR AP)

fn auto_post_bill_payment(&self, payment_id: Uuid) -> Result<JournalEntry>

Auto-post bill payment (DR AP / CR Cash)

fn auto_post_inventory_cost( &self, cost_transaction_id: Uuid, ) -> Result<JournalEntry>

Auto-post inventory cost transaction (DR/CR Inventory/COGS)

fn auto_post_write_off(&self, write_off_id: Uuid) -> Result<JournalEntry>

Auto-post write-off (DR Bad Debt / CR AR)

fn get_trial_balance(&self, as_of_date: NaiveDate) -> Result<TrialBalance>

Generate trial balance

fn get_balance_sheet(&self, as_of_date: NaiveDate) -> Result<BalanceSheet>

Generate balance sheet

fn get_income_statement( &self, start_date: NaiveDate, end_date: NaiveDate, ) -> Result<IncomeStatement>

Generate income statement

fn get_account_balance( &self, account_id: Uuid, _as_of_date: Option<NaiveDate>, ) -> Result<Option<Decimal>>

Get account balance (None if account is not found)

fn get_account_transactions( &self, account_id: Uuid, filter: JournalEntryFilter, ) -> Result<Vec<JournalEntryLine>>

Get account transaction history

fn run_period_close( &self, period_id: Uuid, closed_by: &str, ) -> Result<JournalEntry>

Run period close (creates closing entries)

fn revalue( &self, as_of_date: NaiveDate, base_currency: Option<Currency>, ) -> Result<RevaluationResult>

Revalue foreign-currency account balances at the as-of exchange rate, posting the net unrealized gain/loss as a balanced adjusting entry.

fn create_accounts_batch( &self, inputs: Vec<CreateGlAccount>, ) -> Result<BatchResult<GlAccount>>

fn get_accounts_batch(&self, ids: Vec<Uuid>) -> Result<Vec<GlAccount>>