Putting a date in a transaction

[Daniel Loureiro]

Is there a way to put a date in a transaction?

Ex.

transaction = Plutus::Transaction.build(
                :description => "Sold some widgets",
                :date => '2014-04-01',
                :debits => [
                  {:account => "Accounts Receivable", :amount => 50],
                :credits => [
                  {:account => "Sales Revenue", :amount => 40},
                  {:account => "Sales Tax Payable", :amount => 10}])
transaction.save

And to get a balance by some date?

>> cash = Plutus::Asset.find_by_name("Cash", "2014-04-30")
>> cash.balance
=> #<BigDecimal:103259bb8,'0.2E4',4(12)>

[mbulat]

Yes.. every transaction has a timestamp (created_at field). 

Getting the balance is not pretty at the moment but can be accomplished as follows:

First specify your date range: 

time_range = (Time.now.midnight - 30.days)..Time.now.midnight

Get the debit and credit balances via query:

Plutus::Asset.joins(:debit_transactions).where(:name => "Cash", :plutus_transactions => {:created_at => time_range}).sum(:amount)

Plutus::Asset.joins(:credit_transactions).where(:name => "Cash", :plutus_transactions => {:created_at => time_range}).sum(:amount)