How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread Fran_3 via gnucash-user
H E L P - hours spent on this so far and no joy:-( >From the Accounts Receivable or Sales ledger view... (can't remember which)... - I selected a customer invoice and duplicated it.- it asked for a date and id number- I entered the date but not the id number as I thought it would auto increment

Re: Can I automate any of this?

2018-02-02 Thread Alan Whiteman
Well, Bob Summers' dilemma would be a good place to start. On 02/01/2018 09:03 AM, Mark Lawrence wrote: On 01/02/18 14:44, Alan Whiteman wrote: Indeed... Can't wait to see what you can help us with! I can write Python if you have a specific job or jobs that need doing. My C is good but very

filter by transfer account?

2018-02-02 Thread Elmar
Looking at a particular account, I would like to filter by the transfer account within it, or perhaps just sort by the transfer account, which would accomplish the same thing.  How can this be done? - Elmar ___ gnucash-user mailing list

Re: How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread Maf. King
On Friday, 2 February 2018 15:43:10 GMT Fran_3 via gnucash-user wrote: > Thanks but unfortunately it didn't work... here is what I did... Clicked > Business> Customer > Find Invoice > Company Name > matches regex > "." > (without quotes) Shows the three invoices we have entered (num 01, >

Fwd: GNUCASH Free Accounting Software

2018-02-02 Thread Alex Aycinena
-- Forwarded message -- From: Bob Lehmann Date: Thu, Jan 4, 2018 at 11:29 PM Subject: GNUCASH Free Accounting Software To: Alex Aycinena Dear Sir: I am a senior citizen who used to use Money Counts which was discontinued years

Future change in handling the Alpha Vantage API key

2018-02-02 Thread Geert Janssens
Just a heads up that starting with gnucash 2.6.20 and 2.7.4 (beta release to become 3.0) it will no longer be necessary to edit the gnucash environment file to get Finance::Quote working with the Alpha Vantage quote source. Instead there will be a new option under Edit->Preferences->Online

Re: Themes

2018-02-02 Thread Fross, Michael
Hello Edwin, One way to remove any custom theme and get back to default is to remove the .gtkrc-2.0 file in your home directory (which is probably *C:\users\YourUserName* directory. To change your theme, run the program (assuming you installed in the default location): *c:\program files

Fwd: Themes

2018-02-02 Thread Alex Aycinena
-- Forwarded message -- From: Edwin Miller Date: Sat, Jan 6, 2018 at 9:08 PM Subject: Themes To: alex.aycin...@gmail.com Hello, How do you change the themes for GnuCash? Some reason the frame work changed to a very dark color and makes it hard to focus. I

Fwd: migrating account

2018-02-02 Thread Alex Aycinena
-- Forwarded message -- From: Blue Heron Date: Fri, Feb 2, 2018 at 9:21 AM Subject: migrating account To: alex.aycin...@gmail.com My computer is on the verge of dying and I'm trying to transfer my Gnu cash records and program to another computer via a

Re: How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread Fran_3 via gnucash-user
Thanks but unfortunately it didn't work... here is what I did... Clicked Business> Customer > Find Invoice > Company Name > matches regex > "." (without quotes) Shows the three invoices we have entered (num     01, 02, 03) but does not show the duplicated invoice. (fyi, we

Re: GNUCASH Free Accounting Software

2018-02-02 Thread David Carlson
Mr Lehmann, You may need to register for the Gnucash Users list to reply if you haven't already done so. It is not clear from your brief description what happened. There is a hint that you are on a Windows OS and if you have been using GnuCash for about a year and you probably have GnuCash

Re: filter by transfer account?

2018-02-02 Thread David Carlson
I think that the only choice would be to start in the account that you want to be your base for the filter then do ctrl-F and select the criteria All Accounts = . So, for example, to find transfers from Bank1 to Cash you would start in Bank1 and select Ctrl-F , select All Accounts from under

Re: GNUCASH Free Accounting Software

2018-02-02 Thread John Ralls
It looks to me that all he needs to do is change the report date in Report Options from "End of current Accounting Period" to something that covers the previous year. Regards, John Ralls > On Feb 2, 2018, at 10:33 AM, David Carlson > wrote: > > Mr Lehmann, > >

Re: Transfers not showing

2018-02-02 Thread David Carlson
One of the department stores that my wife shops at does not know how to correctly generate an OFX file from their website. That may be what is happening to you. David C On Fri, Feb 2, 2018 at 10:39 AM, dplank wrote: > I have entries in my checking account for payments

Re: How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread Geert Janssens
Op vrijdag 2 februari 2018 20:45:44 CET schreef Fran_3 via gnucash-user: > Running v2.6.19 on Windows 10 PC > When I duplicate an A/R or Sales Transaction there is no option to "Post" > Search -> is Posted -> untick > returns nothing > using an experimentl gnuCash file I created another

Re: Need help with opening my Gnucash software

2018-02-02 Thread Rick Copple
On 02/02/2018 07:57 PM, Lorrie E Clemens wrote: Hello, I have had this problem before and someone was able to help. I have loaded Gnucash onto my hard drive. That was the previous fix. But every time I try to open it up I get “the file URI/Users/Lorrie/Desktop/imbalance .gnucash could not be

Re: GNUCASH Free Accounting Software

2018-02-02 Thread Bob Lehmann
Dear GnuCash Friends: Thank you! It is good of you to "persevere" for me. I am really appreciative, of the Gnucash program ... it is quite similar, in several ways to the old Moneycounts program that I used for years, making it easier for me to "navigate" iin this program. I have version

Re: Need help with opening my Gnucash software

2018-02-02 Thread Rick Copple
On 02/02/2018 07:57 PM, Lorrie E Clemens wrote: Hello, I have had this problem before and someone was able to help. I have loaded Gnucash onto my hard drive. That was the previous fix. But every time I try to open it up I get “the file URI/Users/Lorrie/Desktop/imbalance .gnucash could not be

Re: Please remove me from the mailing list

2018-02-02 Thread Liz
On Wed, 31 Jan 2018 20:23:21 + Matt Graham wrote: > Sorry, you are probably all sick of this thread, but can the > unsubscribe process send an email to the person unsubscribing to tell > them "if you have a third party mail thing like Nabble, make sure you >

Re: Need help with opening my Gnucash software

2018-02-02 Thread David Carlson
Lorrie, From the forward slashes I surmise that you are using GnuCash on an Apple device which has a strange (at least to Linux or Windows users) way to find files. That said, I think that once you get to that error you can click on File> Open > then seach the directory to find your file. I

Re: Reconcile problem

2018-02-02 Thread DaveC49
If its any help the reconcile dialog should allow you to change both the date and the ending balance. The observed behaviour on Gnucash 2.6.18 ( and it hasn't changed for me since changing from 2.6.16 or from previous versions over the last 2-3 years) on Linux Mint 18.3 (Ubuntu 16.04) is that if

Re: Need help with opening my Gnucash software

2018-02-02 Thread David T. via gnucash-user
Rick, It is far easier for the OP simply to click the “Close” button (which continues starting GnuCash, but without loading the missing file) and then using the GnuCash File->Open command to locate their file. David > On Feb 3, 2018, at 11:10 AM, Rick Copple

Re: migrating account

2018-02-02 Thread David Carlson
Michael, Where did you get Alex's email address? You lost a month in getting a answer by not using this list in the first place. As has been posted in the help manual and on the GnuCash website and FAQ and WIKI, you only need to copy the data file to your thumb drive. There are some settings

Re: migrating account

2018-02-02 Thread Bram Mertens
Michael, Please check the FAQ: starting at https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_backup_my_data.3F. If that doesn't answer your question please provide more information. What OS are you using (both on the old and the new machine)? What have you tried so far? What errors if anything do

Re: filter by transfer account?

2018-02-02 Thread Elmar
That worked.  Thanks. - Elmar On 02/02/2018 12:57 PM, David Carlson wrote: I think that the only choice would be to start in the account that you want to be your base for the filter then do ctrl-F and select the criteria All Accounts = .  So, for example, to find transfers from Bank1 to Cash

Re: How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread Fran_3 via gnucash-user
Running v2.6.19 on Windows 10 PC When I duplicate an A/R or Sales Transaction there is no option to "Post" Search -> is Posted -> untick returns nothing using an experimentl gnuCash file I created another "duplicate" of an A/R transaction and did not click on the"?" and then attempted various

Transfers not showing

2018-02-02 Thread dplank
I have entries in my checking account for payments made to credit cards. Usually, when I import the data and then select the credit card account in the transfer column, it shows up as a payment when I look in the credit card account. That is not happening for one credit card account. Any

Need help with opening my Gnucash software

2018-02-02 Thread Lorrie E Clemens
Hello, I have had this problem before and someone was able to help. I have loaded Gnucash onto my hard drive. That was the previous fix. But every time I try to open it up I get “the file URI/Users/Lorrie/Desktop/imbalance .gnucash could not be found” How do I get into my file? Sincerely,

Re: Transfers not showing

2018-02-02 Thread David Carlson
Another possibility is that particular credit card account is not correctly configured as a liability account. David C On Fri, Feb 2, 2018 at 3:35 PM, David Carlson wrote: > One of the department stores that my wife shops at does not know how to > correctly

Re: How to edit and post 'duplicate' customer invoice?

2018-02-02 Thread Adrien Monteleone
If it turns out you can't edit it, then some sort of reversing transaction should be in order. However, doing that manually might be as equally problematic. (there is also a 'create reversing transaction' in one of the menus) I'd ask Geert, John or someone else to chime in on how best to adjust

Re: GNUCASH Free Accounting Software

2018-02-02 Thread David Carlson
Bob, Glad to see that you are again able to see the transactions. There is no single report that shows everything. I am guessing that you got lost in the process of trying to create a report. I would suggest that you experiment with the reports, perhaps first trying to do a balance report for

Re: File Format : XML v MySQL / postgres / sqllite

2018-02-02 Thread ebridges
Hi, Just catching up on the archives and came across this thread. I began work about a month ago, for my personal use, of a simple easy-to-use way to quickly get information out of a Gnucash Database: https://github.com/ebridges/accounting-reports Right now it's pretty minimal (balance reports,