Report - Items sold, quantity and value

[Adrien Monteleone]

Eduardo,

What you are describing is really part of an inventory/point-of-sales package rather than an accounting package.

However, you can possibly manage something by combining a setting with a transaction report.

Be sure when posting invoices to UNCHECK the setting to ‘Accumulate Splits?’

This will put each line of the invoice as a separate split which will then show up individually in a transaction report, which you could then possibly open in LibreOffice or other software and massage into a proper Item Sales report with additional totals/sub-totals.

As for existing invoices that have already been posted and paid, you could go back and unpost and then re-post them all without the setting checked, but you’d have to do them in exact order by date and even then might have some issue with payments not getting properly re-applied.

Even with this, I don’t think quantities would show up unless you made them part of the description line. (a bit of data duplication however)

Otherwise, the only option I can think of would be to set up a script to parse html versions of each invoice and then aggregate them into a csv file and proceed from there.

Regards,
Adrien

> On Oct 11, 2017, at 12:48 PM, Eduardo Estefano Neto <eduardo.estefano.neto at gmail.com> wrote:
> 
> Thank you Christopher.  What I'm looking for is the aggregrated items
> report. Hope this is in the roadmap.
> 
> Eduardo
> 
> On Wed, Oct 11, 2017 at 3:21 AM Christopher Lam <christopher.lck at gmail.com>
> wrote:
> 
>> You can print a report of itemized sales in one invoice by running the
>> Reports/Business/Tax Invoice report.
>> 
>> I don't think there's a report which will aggregate items sold across
>> several invoices.
>> 
>> C
>> On 10 Oct 2017 22:04, "Eduardo Estefano Neto" <
>> eduardo.estefano.neto at gmail.com> wrote:
>> 
>>> Hi there everyone. Does anyone know how to extract a list of items sold? I
>>> would like to have a listing of items inside the invoices. Something like:
>>> 
>>> Client | Invoice Nr | Item | Quantity | Value
>>> 
>>> Thanks in advance
>>> 
>>> Eduardo
>>> --
>>> Eduardo Estefano Neto
>>> eduardo.estefano.neto at gmail.com
>>> (11) 9.9481-3450
>>> Linkedin: https://br.linkedin.com/pub/eduardo-estefano-neto/b/877/793
>>> 
>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> --
> Eduardo Estefano Neto
> eduardo.estefano.neto at gmail.com
> (11) 9.9481-3450
> Linkedin: https://br.linkedin.com/pub/eduardo-estefano-neto/b/877/793
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.