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