Multi-Column Invoice Report (solved)

[Nestor Stura]

Hi Derek,
After several tries I decided for a change. I am too old to start with
a new language :-)
I moved my data to SQLite, I connected through ODBC with Access and
generated my reports through it.
It is not so easy but after some work it does what I need.
Thanks a lot.
Néstor

2014-02-03 21:48 GMT+01:00 Derek Atkins <warlord at mit.edu>:
> 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