Multi-Column Invoice Report

Nestor Stura nestor.stura at gmail.com
Thu Jan 30 12:55:12 EST 2014


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

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



More information about the gnucash-user mailing list