which documentation to download

[Mitch]

when I upgraded to 2.6.18, the process removed prior version, including 
documentation, but did not offer to install fresh documentation ( or if 
it did I missed it ...)  .  so anyhooo, which documentation should I 
download so that the help > contents (F1)  works as expected?  I see 
PDF, epub, and mobipocket options on http://www.gnucash.org/docs.phtm*/l/*


I recently migrated from Quicken after too many paid upgrades and failed 
updates :-)

**

TIA,

Mitch, Lincoln, AR

479-824-2881 or 479-249-5614 (cell)




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@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.

Re: GnuCash 2.7.0 released

[Geert Janssens]

Thanks for your perseverance to get this release out John!

Op woensdag 18 oktober 2017 03:32:17 CEST schreef John Ralls:
>   • 429f9aef704fe9378aa400d3e29c22e383e184d54ed4bc364406e38356ac01ef 
> gnucash-2.6.18.tar.bz2 •
> afa303bfbc183a700f77013b214f0b25843ee5a8da83994daae1926af990e525 
> gnucash-2.6.18.tar.gz •
> 2c83e8f79042e997f624efdb1abd154f50aafa5c7afa30e837f34dd16e381d85 
> gnucash-2.6.18.setup.exe •
> 1b2fd8157c077dd2f2da2b1b1a7ffc88a57583ad931b0b4ed0e30a15fc2e7193 
> Gnucash-Intel-2.7.0-1.dmg
> 
I see several of these hashes suggest they are for gnucash 2.6.18. Can you 
check whether these are really 2.6.18 hashes or just a case of forgetting to 
update the version numbers behind the (new) hashes ?

Geert

P.S. The same is true for the hashes in the README file on sourceforge...
___
gnucash-user mailing list
gnucash-user@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.

Re: GnuCash 2.7.0 released

[John Ralls]

> On Oct 18, 2017, at 5:46 AM, Geert Janssens  
> wrote:
> 
> Thanks for your perseverance to get this release out John!
> 
> Op woensdag 18 oktober 2017 03:32:17 CEST schreef John Ralls:
>>  • 429f9aef704fe9378aa400d3e29c22e383e184d54ed4bc364406e38356ac01ef 
>> gnucash-2.6.18.tar.bz2 •
>> afa303bfbc183a700f77013b214f0b25843ee5a8da83994daae1926af990e525 
>> gnucash-2.6.18.tar.gz •
>> 2c83e8f79042e997f624efdb1abd154f50aafa5c7afa30e837f34dd16e381d85 
>> gnucash-2.6.18.setup.exe •
>> 1b2fd8157c077dd2f2da2b1b1a7ffc88a57583ad931b0b4ed0e30a15fc2e7193 
>> Gnucash-Intel-2.7.0-1.dmg
>> 
> I see several of these hashes suggest they are for gnucash 2.6.18. Can you 
> check whether these are really 2.6.18 hashes or just a case of forgetting to 
> update the version numbers behind the (new) hashes ?
> 
> Geert
> 
> P.S. The same is true for the hashes in the README file on sourceforge...

Sigh, I replaced the hashes and failed to change the versions, then copied the 
whole block to the README.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Version 2.6.18 help files

[Gary Holtum]

Version 2.6.18 has no help files. What do we do??

 

Gary

___
gnucash-user mailing list
gnucash-user@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.

Re: Version 2.6.18 help files

[Geert Janssens]

Op woensdag 18 oktober 2017 16:09:44 CEST schreef Gary Holtum:
> Version 2.6.18 has no help files. What do we do??
> 
> 
> 
> Gary
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.

Which OS ?

Regards,

Geert

___
gnucash-user mailing list
gnucash-user@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.

Re: which documentation to download

[Geert Janssens]

Op woensdag 18 oktober 2017 00:17:25 CEST schreef Mitch:
> when I upgraded to 2.6.18, the process removed prior version, including
> documentation, but did not offer to install fresh documentation ( or if
> it did I missed it ...)  .  so anyhooo, which documentation should I
> download so that the help > contents (F1)  works as expected?  I see
> PDF, epub, and mobipocket options on http://www.gnucash.org/docs.phtm*/l/*
> 
Which OS are you using ?

Geert
___
gnucash-user mailing list
gnucash-user@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.

Re: which documentation to download

[Keith N. McKenna]

On 10/18/2017 10:23 AM, Geert Janssens wrote:
> Op woensdag 18 oktober 2017 00:17:25 CEST schreef Mitch:
>> when I upgraded to 2.6.18, the process removed prior version, including
>> documentation, but did not offer to install fresh documentation ( or if
>> it did I missed it ...)  .  so anyhooo, which documentation should I
>> download so that the help > contents (F1)  works as expected?  I see
>> PDF, epub, and mobipocket options on http://www.gnucash.org/docs.phtm*/l/*
>>
> Which OS are you using ?
> 
> Geert
> ___
> gnucash-user mailing list
> gnucash-user@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.
> 
Geert;

I can confirm that this happens on Windows.

Regards
Keith N. McKenna




signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[John R. Sowden]

I keep a copy of Gnucash on my computer, in the remote chance that some 
of the obvious anti-user issues would be resolved.  I ran it a moment 
ago.  I keep a copy of my chart of accounts on line, and the copy I use 
is to test various types of transactions.  The easiest for me is paying 
the rent.


1. The program opens in the Cash-Checking Account journal register.  I 
entered the check number.  For "Description", instead of a description, 
I put the name of the payee, in this case "Landlord", I entered the 
account name "Rent" I put the cursor into the credit column because I am 
reducing the cash account.  I hit enter to end the transaction.  The 
transaction I entered disappeared.  Let me clarify that: THE TRANSACTION 
DISAPPEARED.  I scrolled up, in case it scrolled off the screen, even 
though only one transaction was on the screen.  Where did the 
transaction go?  I don't know.  I am sure if I do a trial balance, I 
might find it.  If I made an error, a window should have popped up 
telling me of my error.


2.  Actually this item is not an "assertion", it is an offered solution, 
as I have written a few accounting programs in my 36 years of using 
micro-computers.  By a "preference" switch, I am referring to an option 
in the "preferences" section allowing the user to select, via a check 
box, similar to choosing "Debit" or Credit" vs. the non-accounting 
titles, another transaction data entry option, one that is more user 
friendly to a bookkeeping/accounting person, even on who is not Intuit 
aware.


3. I appreciate your interest in it.  Actually, because I bought my copy 
from an Egghead store years ago, I have had no need to find another.  As 
I wrote, years ago Intuit bought IHA from Craig Carlson and Stephen 
Pollack, and hired the two of them.  I received the notice in February 
of 1992.  I kept it as a compliment to IHA for their product being 
purchased by a worthy competitor.


Note:
There is more to item one.  If you create an unbalanced transaction, the 
difference is silently placed into an account that is not in your chart 
of accounts.  This was discussed by several 'veterans' of this list, 
when I addressed it, and it was determined by the programmers that it 
was best to not create a pop-up "error message" window.  I disagree.  
The solution, of course is a simple if/then structure that looks at a 
'preferences' option, and, inside the if/then structure is the pop-up 
window. Those who choose to see a warning of their error, will see it, 
so they can correct it while all is fresh in their mind, while those 
who, like the ostrich with its head in the sand, wish to not be bothered 
with such trivialities, would merrily go on to the next transaction.


John



On 10/17/2017 10:05 AM, David Carlson wrote:

John R. Sowden,

Could you please elaborate on your assertions that

1. "errors, often based on changing amounts (2 debits, etc.,) are 
hidden from the user."


2. "A 'preference' switch to allow users who are familiar and 
comfortable with the 'Intuit Way' to continue, vs. those with 
accounting knowledge who want a transaction to look like a 
transaction, could have it that way, is a possibility."


3. is "In House Accountant" available on the internet?

David C

On Tue, Oct 17, 2017 at 10:36 AM, John R. Sowden 
mailto:jsow...@americansentry.net>> wrote:


To: Liz, the moderator, and the list:

Actually Gnucash seems to strike a strong resemblance to Quicken. 
The data entry in the journal mode with no payee in the check or
source account entry (from cash, checking, or credit cards), and
where the amounts of the entry change in during the data entry
process, and where errors, often based on changing amounts (2
debits, etc.,) are hidden from the user.

It makes sense that users of the Intuit family of products want to
leave, due to some of their business practices; and some desire to
use an operating system that is not founded on enhancing the
profits of the publishers at the user's expense.

I watch Gnucash for fixes to these problems, but all I see are
justifications of why they exist.  A 'preference' switch to allow
users who are familiar and comfortable with the 'Intuit Way' to
continue, vs. those with accounting knowledge who want a
transaction to look like a transaction, could have it that way, is
a possibility.  The end result would be a transaction posted to
the appropriate accounts.

I use a DOS program run under Dosemu in Ubuntu, written by 2
programmers who sold their program to Intuit.  Intuit buried their
program, "In House Accountant", and use some of its code in
Quickbooks.  I declined their offer to 'switch'.

John Sowden
American Sentry Systems, Inc.



On 10/16/2017 07:06 PM, Liz wrote:

On Mon, 16 Oct 2017 06:52:17 -0700 (MST)
Nelson mailto:fkjasdhf...@mailinator.com>> wrote:

You're getting very defensive here David and your posts

Re: command line QIF import

[David T. via gnucash-user]

> On Oct 18, 2017, at 9:14 PM, John R. Sowden  
> wrote:
> 
> 1. The program opens in the Cash-Checking Account journal register.  I 
> entered the check number.  For "Description", instead of a description, I put 
> the name of the payee, in this case "Landlord", I entered the account name 
> "Rent" I put the cursor into the credit column because I am reducing the cash 
> account.  I hit enter to end the transaction.  The transaction I entered 
> disappeared.  Let me clarify that: THE TRANSACTION DISAPPEARED.  I scrolled 
> up, in case it scrolled off the screen, even though only one transaction was 
> on the screen.  Where did the transaction go?  I don't know.  I am sure if I 
> do a trial balance, I might find it.  If I made an error, a window should 
> have popped up telling me of my error.

[snip]

> Note:
> There is more to item one.  If you create an unbalanced transaction, the 
> difference is silently placed into an account that is not in your chart of 
> accounts.  This was discussed by several 'veterans' of this list, when I 
> addressed it, and it was determined by the programmers that it was best to 
> not create a pop-up "error message" window.  I disagree.  The solution, of 
> course is a simple if/then structure that looks at a 'preferences' option, 
> and, inside the if/then structure is the pop-up window. Those who choose to 
> see a warning of their error, will see it, so they can correct it while all 
> is fresh in their mind, while those who, like the ostrich with its head in 
> the sand, wish to not be bothered with such trivialities, would merrily go on 
> to the next transaction.
> 
> John

John,

I will assume that you are using the register in Transaction View mode, since 
basic view doesn’t behave in the way that confuses you. As an accountant, you 
understand the concept of double-entry accounting. That means that each 
transaction will have (at least) two accounts, which in GnuCash are represented 
in the register on separate lines, called splits.

When you follow the entry steps you have done, you are telling GnuCash that you 
wish to Credit the ***Rent*** account (not the Checking Account, as you 
believe). Thus far, you have only entered one split in the transaction. Then, 
when you press Enter (as opposed to tab—an unfortunate distinction that GnuCash 
makes), you are telling GnuCash that you are done editing the transaction, and 
GnuCash—seeing your failure to balance your transaction—adds a split for the 
missing second part of the transaction, and assigns that split to Imbalance-USD 
(the name of the account that you mention in your note). Having fixed the 
problem for you, GnuCash updates the display—and since the transaction you just 
created has no splits linked to the Checking Account, it removes the entry from 
the current register. 

While these aspects may not be ideal, they are not mysterious—they are, in fact 
explained in numerous places in the documentation. To assert some mysterious 
hidden agenda is willful ignorance on your part. 

I understand that you don’t agree with the design choices implemented in 
GnuCash—I know *I* don’t—however, these points have (as you point out) been 
discussed quite thoroughly by the developer and user community, and the choice 
has been made to retain the current functionality. Since your solution is so 
easy to you, join the volunteer developer crew and submit a patch to the 
project to implement it. Me, I have just learned how to open the Imbalance-USD 
account when I make such a mistake, correct it, and get on with the next 
transaction.

David T.
___
gnucash-user mailing list
gnucash-user@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.

Re: command line QIF import

[Derek Atkins]

John,

On Wed, October 18, 2017 12:14 pm, John R. Sowden wrote:
> I keep a copy of Gnucash on my computer, in the remote chance that some
> of the obvious anti-user issues would be resolved.  I ran it a moment
> ago.  I keep a copy of my chart of accounts on line, and the copy I use
> is to test various types of transactions.  The easiest for me is paying
> the rent.
>
> 1. The program opens in the Cash-Checking Account journal register.  I
> entered the check number.  For "Description", instead of a description,
> I put the name of the payee, in this case "Landlord", I entered the
> account name "Rent" I put the cursor into the credit column because I am
> reducing the cash account.  I hit enter to end the transaction.  The
> transaction I entered disappeared.  Let me clarify that: THE TRANSACTION
> DISAPPEARED.  I scrolled up, in case it scrolled off the screen, even
> though only one transaction was on the screen.  Where did the
> transaction go?  I don't know.  I am sure if I do a trial balance, I
> might find it.  If I made an error, a window should have popped up
> telling me of my error.

If you're in an Account Register, and in Basic Mode, then the transaction
you entered must be somewhere in the current account.  The first question
would be, what was the date you entered?  Second would be, what's the
current sort order?  Third, do you have a limit on the number of displayed
transactions?

The transaction didn't disappear (well, okay, it disappeared from *view*),
but it still exists in your books, somewhere.  Maybe you MEANT to put in a
different date.  How is GnuCash supposed to know that you meant e.g. six
months in the past vs six months in the future?  I.e., I'm not sure how
GnuCash could detect that you made an "error"; so if it scrolled to the
where the new transaction got put, then you'd have to manually scroll back
to the blank split for your *next* entry.  So the question is:  what's
more common?  Someone mistakenly entering the date, or someone entering a
date far enough in the past (or future) that the new transaction goes off
the screen?

> 2.  Actually this item is not an "assertion", it is an offered solution,
> as I have written a few accounting programs in my 36 years of using
> micro-computers.  By a "preference" switch, I am referring to an option
> in the "preferences" section allowing the user to select, via a check
> box, similar to choosing "Debit" or Credit" vs. the non-accounting
> titles, another transaction data entry option, one that is more user
> friendly to a bookkeeping/accounting person, even on who is not Intuit
> aware.

Um, you mean like Edit -> Preferences -> Register Defaults -> Default
Style?  The preference that's been in there for years?  You can choose
between the three modes, Basic, Auto-Split, and Journal modes.

Note that in either Auto-Split or Journal mode then you CAN enter a
transaction in a way that would make it disappear from the current open
register!  Specifically, if you don't enter the split to the current
account first (to anchor the transaction to the current register) then it
will disappear.

> Note:
> There is more to item one.  If you create an unbalanced transaction, the
> difference is silently placed into an account that is not in your chart
> of accounts.  This was discussed by several 'veterans' of this list,
> when I addressed it, and it was determined by the programmers that it
> was best to not create a pop-up "error message" window.  I disagree. 
> The solution, of course is a simple if/then structure that looks at a
> 'preferences' option, and, inside the if/then structure is the pop-up
> window. Those who choose to see a warning of their error, will see it,
> so they can correct it while all is fresh in their mind, while those
> who, like the ostrich with its head in the sand, wish to not be bothered
> with such trivialities, would merrily go on to the next transaction.

I happen to agree with you on this one -- the automatic balancing into the
Imbalance Account is annoying.  That change went in somewhere around
1.6/1.8 (I don't recall exactly when) as part of the "new" scrubbing
routines.  Personally, I'm with you -- I'd rather GnuCash force me to
create the balance, or at least pop up a dialog that would let me choose
to balance it myself or have GnuCash create the Imbalance split.

Patches always welcome!  :)

> John

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

Sales report by item

[rmomxtx]

Is there a way to get a sales report by item? Total sales for a day by item
for example. The only indicators I can find would be the description field
on the invoice or the income or other account credited for the sale. Thanks!
Roger

___
gnucash-user mailing list
gnucash-user@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.

Re: Sales report by item

[Derek Atkins]

Hi,

On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> Is there a way to get a sales report by item? Total sales for a day by
> item
> for example. The only indicators I can find would be the description field
> on the invoice or the income or other account credited for the sale.
> Thanks!
> Roger

You would certainly have to write your own report to do that.  You would
need to search through all posted invoices, and for each invoice line-item
determine the date and amount, and then collect all those tuples.  Then
you can display it out.

There is definitely no existing report that would do this.

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

Re: Sales report by item

[Eduardo Estefano Neto]

I have no skills to write such report. If someone eventually does write
one, please let me know. It would be greatly appreciated.

At the moment we are doing the report manually.

On Wed, Oct 18, 2017 at 4:21 PM Derek Atkins  wrote:

> Hi,
>
> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> > Is there a way to get a sales report by item? Total sales for a day by
> > item
> > for example. The only indicators I can find would be the description
> field
> > on the invoice or the income or other account credited for the sale.
> > Thanks!
> > Roger
>
> You would certainly have to write your own report to do that.  You would
> need to search through all posted invoices, and for each invoice line-item
> determine the date and amount, and then collect all those tuples.  Then
> you can display it out.
>
> There is definitely no existing report that would do this.
>
> > 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 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@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.n...@gmail.com
(11) 9.9481-3450
Linkedin: https://br.linkedin.com/pub/eduardo-estefano-neto/b/877/793
___
gnucash-user mailing list
gnucash-user@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.

Re: Sales report by item

[Roger Oliver]

Thanks. So I'm not losing my mind after all.

On Oct 18, 2017 2:13 PM, "Derek Atkins"  wrote:

> Hi,
>
> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> > Is there a way to get a sales report by item? Total sales for a day by
> > item
> > for example. The only indicators I can find would be the description
> field
> > on the invoice or the income or other account credited for the sale.
> > Thanks!
> > Roger
>
> You would certainly have to write your own report to do that.  You would
> need to search through all posted invoices, and for each invoice line-item
> determine the date and amount, and then collect all those tuples.  Then
> you can display it out.
>
> There is definitely no existing report that would do this.
>
> > 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 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
gnucash-user mailing list
gnucash-user@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.

Re: Sales report by item

[R. Victor Klassen]

This seems like something that ought to be doable by the database-savvy among 
us.  Especially if you have a database (sqlite) back end.
Unfortunately I’m not one of those.   The information is certainly there.  
Other useful queries along similar lines are “tell me, by customer, how much of 
X was sold”, where X might be the description line in an invoice, or even the 
account.  And give me a massive report of all sales by customer within item or 
item within customer, and so on.

> On Oct 18, 2017, at 3:43 PM, Roger Oliver  wrote:
> 
> Thanks. So I'm not losing my mind after all.
> 
> On Oct 18, 2017 2:13 PM, "Derek Atkins"  wrote:
> 
>> Hi,
>> 
>> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
>>> Is there a way to get a sales report by item? Total sales for a day by
>>> item
>>> for example. The only indicators I can find would be the description
>> field
>>> on the invoice or the income or other account credited for the sale.
>>> Thanks!
>>> Roger
>> 
>> You would certainly have to write your own report to do that.  You would
>> need to search through all posted invoices, and for each invoice line-item
>> determine the date and amount, and then collect all those tuples.  Then
>> you can display it out.
>> 
>> There is definitely no existing report that would do this.
>> 
>>> 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 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: Sales report by item

[Roger Oliver]

Are the queries in your second paragraph thinks you can do now or something
we'd like to see? Thanks

On Oct 18, 2017 5:13 PM, "R. Victor Klassen"  wrote:

> This seems like something that ought to be doable by the database-savvy
> among us.  Especially if you have a database (sqlite) back end.
> Unfortunately I’m not one of those.   The information is certainly there.
> Other useful queries along similar lines are “tell me, by customer, how
> much of X was sold”, where X might be the description line in an invoice,
> or even the account.  And give me a massive report of all sales by customer
> within item or item within customer, and so on.
>
> > On Oct 18, 2017, at 3:43 PM, Roger Oliver  wrote:
> >
> > Thanks. So I'm not losing my mind after all.
> >
> > On Oct 18, 2017 2:13 PM, "Derek Atkins"  wrote:
> >
> >> Hi,
> >>
> >> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> >>> Is there a way to get a sales report by item? Total sales for a day by
> >>> item
> >>> for example. The only indicators I can find would be the description
> >> field
> >>> on the invoice or the income or other account credited for the sale.
> >>> Thanks!
> >>> Roger
> >>
> >> You would certainly have to write your own report to do that.  You would
> >> need to search through all posted invoices, and for each invoice
> line-item
> >> determine the date and amount, and then collect all those tuples.  Then
> >> you can display it out.
> >>
> >> There is definitely no existing report that would do this.
> >>
> >>> 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 617-623-3745
> >>   de...@ihtfp.com www.ihtfp.com
> >>   Computer and Internet Security Consultant
> >>
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@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@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.

Re: Sales report by item

[R. Victor Klassen]

Things I’d like to be able to do, and I’m sure I could if I knew how to 
formulate and run database queries on the sqlite database.

> On Oct 18, 2017, at 6:23 PM, Roger Oliver  wrote:
> 
> Are the queries in your second paragraph thinks you can do now or something 
> we'd like to see? Thanks
> 
> On Oct 18, 2017 5:13 PM, "R. Victor Klassen"  > wrote:
> This seems like something that ought to be doable by the database-savvy among 
> us.  Especially if you have a database (sqlite) back end.
> Unfortunately I’m not one of those.   The information is certainly there.  
> Other useful queries along similar lines are “tell me, by customer, how much 
> of X was sold”, where X might be the description line in an invoice, or even 
> the account.  And give me a massive report of all sales by customer within 
> item or item within customer, and so on.
> 
> > On Oct 18, 2017, at 3:43 PM, Roger Oliver  > > wrote:
> >
> > Thanks. So I'm not losing my mind after all.
> >
> > On Oct 18, 2017 2:13 PM, "Derek Atkins"  > > wrote:
> >
> >> Hi,
> >>
> >> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com 
> >>  wrote:
> >>> Is there a way to get a sales report by item? Total sales for a day by
> >>> item
> >>> for example. The only indicators I can find would be the description
> >> field
> >>> on the invoice or the income or other account credited for the sale.
> >>> Thanks!
> >>> Roger
> >>
> >> You would certainly have to write your own report to do that.  You would
> >> need to search through all posted invoices, and for each invoice line-item
> >> determine the date and amount, and then collect all those tuples.  Then
> >> you can display it out.
> >>
> >> There is definitely no existing report that would do this.
> >>
> >>> 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 617-623-3745
> >>   de...@ihtfp.com  www.ihtfp.com 
> >> 
> >>   Computer and Internet Security Consultant
> >>
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@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@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.

Re: which documentation to download

[John Ralls]

Make sure that you get gnucash-2.6.18-3.setup.exe, That’s what’s been available 
on our project sites at SourceForge and Github and what’s linked at 
www.gnucash.org  since October 8 when the problem was 
first raised.

Regards,
John Ralls

> On Oct 18, 2017, at 8:08 AM, Keith N. McKenna  
> wrote:
> 
> On 10/18/2017 10:23 AM, Geert Janssens wrote:
>> Op woensdag 18 oktober 2017 00:17:25 CEST schreef Mitch:
>>> when I upgraded to 2.6.18, the process removed prior version, including
>>> documentation, but did not offer to install fresh documentation ( or if
>>> it did I missed it ...)  .  so anyhooo, which documentation should I
>>> download so that the help > contents (F1)  works as expected?  I see
>>> PDF, epub, and mobipocket options on http://www.gnucash.org/docs.phtm*/l/*
>>> 
>> Which OS are you using ?
>> 
>> Geert
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>> 
> Geert;
> 
> I can confirm that this happens on Windows.
> 
> Regards
> Keith N. McKenna
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Quantity total below create / view / edit invoice

[Amish]

Hello

Recently in India GST was implemented.

The government requires to report sale / purchase quantity too in invoice.

When I create / view / edit invoice, I can see Invoice total and tax 
total in status bar.


Is it possible to add Quantity total too? Or is there any other way?

Thanks in advance.

Amish

___
gnucash-user mailing list
gnucash-user@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.

Re: which documentation to download

[Keith N. McKenna]

On 10/18/2017 8:30 PM, John Ralls wrote:
> Make sure that you get gnucash-2.6.18-3.setup.exe, That’s what’s been 
> available on our project sites at SourceForge and Github and what’s linked at 
> www.gnucash.org  since October 8 when the problem 
> was first raised.
> 
> Regards,
> John Ralls
> 
Thanks John I must have missed the announcement of 2.6.18-3

Regards
Keith

>> On Oct 18, 2017, at 8:08 AM, Keith N. McKenna  
>> wrote:
>>
>> On 10/18/2017 10:23 AM, Geert Janssens wrote:
>>> Op woensdag 18 oktober 2017 00:17:25 CEST schreef Mitch:
 when I upgraded to 2.6.18, the process removed prior version, including
 documentation, but did not offer to install fresh documentation ( or if
 it did I missed it ...)  .  so anyhooo, which documentation should I
 download so that the help > contents (F1)  works as expected?  I see
 PDF, epub, and mobipocket options on http://www.gnucash.org/docs.phtm*/l/*

>>> Which OS are you using ?
>>>
>>> Geert
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>>>
>> Geert;
>>
>> I can confirm that this happens on Windows.
>>
>> Regards
>> Keith N. McKenna
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@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@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.
> 




signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@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.