can I get info on quanties from bill splits?
Derek Atkins
warlord at MIT.EDU
Wed Feb 1 11:07:53 EST 2012
Hi,
Shane Litherland <litherland-farm at bigpond.com> writes:
> Hi again,
>
> I decided to enter fuel purchases (using Bill splits) as
> 'quantity'=litres and 'unit price'=cents/litre.
> previously I'd just put in unit=1 and total price.
>
> I'd hoped to be able to report on the number of litres purchased in a
> given time (e.g. for fuel tax accounting).
>
> The detail that posts to A/P and onwards to expense/tax accounts though,
> seems only to be the total of each split (I don't accumulate splits).
> The quantity/units info seems only to be visible in the individual
> bills. Which means I have to look up each bill and note down the litres
> e.g. in a spreadsheet, in order to tally up litres for a period.
>
> Have I missed something basic here? Is there a way to 'see' the quantity
> info e.g. as part of a report on the fuel expense account? or as a field
> in the ledger of that account? My fiddling around with reports to date
> has not revealed an answer.
>
> The info has to be there somewhere for me to see it in individual
> bills... I just want to add it up... oh GNUcash why do you torment me
> so, with your carrot just out of reach... ;-}
There are no current reports to do what you want. But one could write
something based on a combination of the invoice report and aging report
to iterate over all the invoices to accumulate your information.
Patches (and home grown reports) always welcome.
> -shane
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-user
mailing list