Multi-Column Invoice Report

[Derek Atkins]

Hi,

Nestor Stura <nestor.stura at gmail.com> writes:

> Thanks Derek,
> One question: when you say "pull out" what do you mean? Is there any
> way to export transactions to Excel or HTML?

By "pull out" I literally mean "extract".  A report is a scheme program
that uses the GnuCash Scheme API to extract data from the GnuCash data
objects.  It generates HTML.  However you could theoretically write a
report that generates something other than HTML.

> Thanks again,
> Nestor

-derek

> 2014-01-30 Derek Atkins <warlord at mit.edu>:
>> Hi,
>>
>> Nestor Stura <nestor.stura at gmail.com> writes:
>>
>>> Hi all.
>>> For tax reasons, I need to develop a different invoices report.
>>>         I need a multi-column report with the data of all the invoices created
>>>         during the fiscal year.
>>>         For example,
>>>         ISSUE DATE ; NUMBER ; CUSTOMER ; PRICE(TAXABLE AMMOUNT) ; VAT(%) ;
>>>     VAT(EURO)
>>>         Where can I get this data from?
>>>         I reviewed all the Business Reports and the only similar is Customer
>>>         Summary although it does not have all the columns I need and it has some
>>>         figures that I do not know where they come from.
>>>         Thanks in advance.
>>>         Néstor
>>
>> No such report currently exists.  You will have to write one.  The data
>> is available through the A/R account.  Iterate over the
>> splits/transactions in the account for the time period, pull out the
>> Invoice and Payment transactions (or just the invoice transactions in
>> your case) and then you can pull the data out from the txn and invoice
>> as you need.
>>
>>> 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
>
>

-- 
       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