Hayes re: I need a report

Sat Mar 12 19:28:54 EST 2016

Katie and Mike Novack...
THANK YOU!...

so... no - it does not have to print...
and I tried immediately the find invoice "is paid?" NOT set true...
and it shows me all the PAID invoices...

tried it several times - is paid?... IS... set true = all paid invoices
is paid?... IS NOT... set true = all paid invoices

so yes! that would have worked great!... but it doesnt work...
sigh (I will write it down and keep an eye on it though - cuz that
might get fixed... )...
it should work.

the rest of what you both said - is the secret that I cannot decipher...
"finding the code for that dialog"
Yes!!!... but ?? HOW??...
same thing goes for that receivables aging report -
If I could figure out how to SEE the code that makes that report - I
could CHANGE that code to show me what I want it to...
but I dont know how to see it...
How do I get to it?

so Mr. Novack says:
>>Also remember, when you need a report, that does not NECESSARILY have to be directly from gnucash (from within gnucash). As long as you can create a report that HAS the necessary information, though not structured the way that you need it, you create THAT report, export it, then sort or otherwise extract and reformat.

and I'm like .. yeah! I even kinda Know this... and I can create a
template for the report I want (in text, and/ or in xml - actually) -
but how do I get the information from inside GNUCash to interact with
my "report" which would then be on the outside of GNUCash?

I hear (in these replies) ... that there apparently is a way to ... do
this... to get inside... "export" (?)... implies "import"...
taking things out - messing them about and putting them back...

but HOW? where do I find the instructions that will let me in...

and indeed: THIS
>>Here the "aging" report was suggested. Yes, it would be grouping by age, not grouping by customer. But as long as customer was part of the data in the aging report, you could resort (say customer, date) to get what you want. The issue then becomes what sorting routines you can access (what operating system are you using? If a 'nix, your shell can probably* do this, even putting in subtotaling at customer break.

THIS is actually what I have been trying to figure out how to do for
the last 20 or 30 hours... (and really for the last couple years... I
just dont have any idea how to get in... so I flail about for 50 or 60
hours and then give up again and go back to getting other things
done...
in my head - its all beautiful - (and actually pretty easy -
but I have looked at Every Single Report (including the "customize"
reports).. and I just dont see where there is any ability for me to
say ... gee this dialog is really limited - what I really want is for
it to do THIS...
and then... open up the back end and make it do that.

anyway -
Thank you Thank you for the idea of the "find" option... it didn't
work -but it got me a whole step forward in the right direction before
I hit the wall again...

and for all the other hopeful stuff... what do I need to search online
to get directions as to how to interact with the ghost behind the
reports?

Thank you for your help
Terri Hayes

----- Original Message -----
From: "Katie Eldridge" <eldridgetideswell-katie at yahoo.co.uk>
To: gnucash-user at gnucash.org
Date: Sat, Mar 12, 2016 at 3:26 PM
Subject: Re: Hayes re: I need a report

> Hi Terri,
> Not a programmer either, but does it need to be a 'report'?
> You can get this information (as a list but not printable as far as I can see) from the find invoice dialog, using the search 'Is paid?' > is not > set true.
>
> If you do need a report, finding the code for that dialog will hopefully give a clue as to how to set up such a report...
>
> If you're using the 'Receivable ageing' report then when you click through from the company total you could edit the report options so you don't see transactions earlier than the earliest unpaid one, but how useful that would be depends on the volumes of transactions per customer...
>
> Hope that helps,
>
> Katie
>
> On 12/03/16 14:32, Terri Hayes wrote:
> Hi, I need a report showing invoices not yet paid... in a list..
> preferably grouped by company (but can be grouped by due date)..
> but a LIST... the account report gives me a cumulative total of whats
> due - thats nice - but it doesnt tell me which invoices have not been
> paid... when you click the  total - you get a register dump of every
> transaction... yeah - somewhere in there are the invoices that have
> not been paid - but because payments dont happen on the same date as
> invoices - those not yet paid are interspersed among rows and rows of
> payments for invoices (both of which I dont care about anymore)...
>
> I have been struggling with this for about 20 hours... (and 3 or 4 years)...
> there has to be a way to see this.
>   help?
>
> ps - I am not a programmer - and I *am* a business owner - so I dont
> really have the time to learn to program...
> this kind of very basic functionality should not be this difficult -
> I'm still reeling that the person who crated the invoice process in
> GNUCash didn't include this as a basic report..
> I dont get it - what kind of business doesn't need to know a list of
> what's outstanding?
>
> Thanks again for any help you can give me.
> Terri Hayes
>
> ----- Original Message -----
> From: "Larry Evans" <cppljevans at suddenlink.net>
> To: gnucash-user at lists.gnucash.org
> Date: Sat, Mar 12, 2016 at 8:41 AM
> Subject: Re: One click export from spreadsheets to GnuCash
>
> On 03/11/2016 06:29 PM, Tommy Trussell wrote:
> On Tue, Mar 8, 2016 at 10:46 AM, One Click To Qif <oneclicktoqif at gmail.com>
> wrote:
>
> I created OneClickToQIF: a freeware and open source
> project: with OneClickToQIF is very quick and easy to move data from
> spreadsheets to GnuCash or other bookkeeping application, using the
> former for insertion and some calculations, and the latter for all the
> functionality of a double-entry bookkeeping application.
>
> Github project:  https://github.com/OneClickToQif/OneClickToQif
>
>
> [snip]
> I downloaded two of the spreadsheets from GitHub, and I was able to open
> them with LibreOffice. Unfortunately they were not usable at all on my
> Linux system.
> [snip]
>
> It looks like the VBA code includes Windows-only .dll functions (for the
> file selector), so this alone would make the spreadsheets usable only for
> Microsoft Excel in Windows. (I believe Excel on a Macintosh cannot use .dll
> functions.)
>
> To make your utility more widely available to GnuCash users, you might
> research whether it's possible to use more generic VBA functions that can
> run under LibreOffice. (LibreOffice and its cousin OpenOffice are open
> source and freely available on Windows, Macintosh and Linux.)
>
> +1
>
> Since libreoffice can convert its spreadsheets to excel, just use
> libreoffice to provide an excel version of your spreadsheet for
> those users who don't want to install the free libreoffice on
> their windows machines.
>
> Otherwise, you might clearly identify your project as being for Microsoft
> Windows and Microsoft Office only.
> +2
>
>
>
>
> _______________________________________________
> 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.
>
> _______________________________________________
> 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.
>
>
>
> _______________________________________________
> 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.
>