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