On Wed, Aug 9, 2023 at 1:38 PM Daniele Nicolodi <[email protected]> wrote:
> >
> > At first I thought acquisition dates were not shown because SUM() is
> > aggregating the amounts of lots with different dates, but now I'm not
> > sure. Is acquisition date tracked? Should it be? If it's not, is it
> > likely user error in how I entered my transactions?
>
> AFAIK acquisition date is always tracked. However, when I implemented
> the column rendering code for columns reporting postings and inventories
> I decided to use a compact representation without the date and optional
> labels. This choice can be revisited.
>
Thank you for the confirmation and explanation. The compact representation
is reasonable. I discovered the cost_date column which allowed me to debug
this and see what was going on inside.
> > *2. How exactly is cost munged in an asset transfer?*
> >
> > I'm looking at inventories (as reported by the previous query) before
> > and after a transfer from one account to another. I can see a selection
> > of lots disappear from the inventory of the debited account. I had
> > thought these lots would appear in the same form in the credited
> > account, but instead I see them aggregated into a single lot with what
> > appears to be an averaged cost.
> >
> > Is it possible to transfer the lots without collapsing? In conjunction
> > with my previous question, I think it will be necessary to transfer
> > without collapsing in order to preserve acquisition dates on the cost,
> > which will be needed to determine STCG vs LTCG. Or perhaps the lots are
> > being collapsed /because/ I don't have dates attached, perhaps due to
> > user error?
>
> I'm not sure I understand what you are trying to do, what beancount
> does, and what you expect it to be doing. Can you present a minimal
> ledger that shows the problem?
>
Sure, here is one. Perhaps my understanding or expectations are wrong (or
I've made a dumb typo).
2000-01-01 open Equity:Opening-Balances
2020-01-01 open Assets:BrokerA:USD USD
2020-01-01 open Assets:BrokerA:ASSET ASSET
2020-01-01 open Assets:BrokerB:ASSET ASSET
2020-01-01 pad Assets:BrokerA:USD Equity:Opening-Balances
2020-01-02 balance Assets:BrokerA:USD 100.00 USD
2020-02-01 * "Buy some ASSET"
Assets:BrokerA:ASSET 5.00 ASSET {10.00 USD}
Assets:BrokerA:USD -50.00 USD
2020-03-01 * "Buy some more ASSET"
Assets:BrokerA:ASSET 4.00 ASSET {12.50 USD}
Assets:BrokerA:USD -50.00 USD
2020-05-01 * "Transfer ASSET"
Assets:BrokerA:ASSET -9.00 ASSET
Assets:BrokerB:ASSET 9.00 ASSET
Now I try these two queries on the ledger:
beanquery> SELECT account, position, cost_date FROM has_account("Assets")
CLOSE ON 2020-04-01
account position cost_date
----------------------- ------------------------- ----------
Assets:BrokerA:USD 100.00 USD
Equity:Opening-Balances -100.00 USD
Assets:BrokerA:ASSET 5.00 ASSET {10.00 USD} 2020-02-01
Assets:BrokerA:USD -50.00 USD
Assets:BrokerA:ASSET 4.00 ASSET {12.50 USD} 2020-03-01
Assets:BrokerA:USD -50.00 USD
beanquery> SELECT account, position, cost_date FROM has_account("Assets")
CLOSE ON 2020-06-01
account position cost_date
----------------------- ------------------------- ----------
Assets:BrokerA:USD 100.00 USD
Equity:Opening-Balances -100.00 USD
Assets:BrokerA:ASSET 5.00 ASSET {10.00 USD} 2020-02-01
Assets:BrokerA:USD -50.00 USD
Assets:BrokerA:ASSET 4.00 ASSET {12.50 USD} 2020-03-01
Assets:BrokerA:USD -50.00 USD
Assets:BrokerA:ASSET -9.00 ASSET
Assets:BrokerB:ASSET 9.00 ASSET
Before the transfer, it appears the the two lots appear separately in
BrokerA with a cost and date. After the transfer, in the BrokerB account,
they've been merged with no cost or date.
If I annotate one, the other, or both legs of the transfer transaction in
the ledger, with either "{USD}" or "{}" cost specs, I can induce various
other behaviors, but I'm just acting like a monkey with a keyboard :) , and
none of them are what I want, which is for BrokerB to contain both lots
with the original cost info.
I think this is the same question I asked here:
https://groups.google.com/g/beancount/c/vDX1oA2mJXA/m/Y8yZqUqPAQAJ
eric
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/CAFXPr0uekELQ0feQYDNFrN8VD%2BS59vTcZOivfApaWOTW3nvmNg%40mail.gmail.com.
