Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread Adrien Monteleone
Face palm! Yes, thanks, John. Regards, Adrien > On Jul 10, 2019, at 7:44 PM, John Ralls wrote: > > > >> On Jul 10, 2019, at 2:52 PM, Adrien Monteleone >> wrote: >> >> The website has all the info needed to get started with the code. > > No, the *wiki* has some information needed to get

Re: [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread L. D. James
Thanks.  I don't fully understand it yet, but it appears to be working. I put Zero for both the Payment and Refund fields.  The View Invoice window show it's paid. It works great.  After playing with it a little more if I see a problem, I'll let you know. The application is smart and

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread John Ralls
> On Jul 10, 2019, at 2:52 PM, Adrien Monteleone > wrote: > > The website has all the info needed to get started with the code. No, the *wiki* has some information needed to get started with the code... but it's up to the prospective contributor to have learned the necessary programming

Re: [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Adrien Monteleone
Sorry, I forgot to mention you should zero out the ‘refund’ amount as well. That will leave it as a credit. Just edit the payment (via right-click) and you should be able to change this. If not, just delete it and process it again. You don’t need ‘jobs’ assigned for this to work. (they aren’t

Re: [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread L. D. James
Thanks, Christopher and Arien. It took me a while to get back because I was trying to organize the problem that I'm experiencing with the step.  I created a backup account to test the pre-payment process and get the following results. -- I have the following: Invoice:        13.07

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread Adrien Monteleone
The website has all the info needed to get started with the code. As for using spreadsheets, the advantage there is either customizing your views, or you could use one to combine the P/Balance Sheet with a Future Scheduled Transactions Summary Report to provide what you are looking for.

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread Adrien Monteleone
> On Jul 10, 2019, at 3:20 PM, AEG via gnucash-user > wrote: > > Adrien, > > Thanks for your input. > I don't really want to see the created transactions together. My comment about the checkbox was in reference to your comment about sometimes needing to edit them before they are committed

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread AEG via gnucash-user
Hi Stephen Stephen M. Butler wrote > So:  Edit - Preferences - Scheduled Transactions  and set the Create in > Advance # of days didn't work for you?  No, I had previously thought that the setting you refer to would allow global adjustments to be made but it only affects subsequently created

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread Colin Law
On Wed, 10 Jul 2019 at 21:23, AEG via gnucash-user wrote: > > Adrien, > > Thanks for your input. > I don't really want to see the created transactions together. I want to see > (in advance) the effect scheduled transactions will have on individual > account balances when they are created but to

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread AEG via gnucash-user
Adrien, Thanks for your input. I don't really want to see the created transactions together. I want to see (in advance) the effect scheduled transactions will have on individual account balances when they are created but to delay creation until the correct scheduled date. I am sure others would

Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread AEG via gnucash-user
Hi Liz, Liz wrote > On Sun, 7 Jul 2019 02:46:40 -0500 (CDT) > AEG via gnucash-user > gnucash-user@ > wrote: > >> This leaves me wondering how/why others use the >> "Create in Advance" feature because I'm finding it difficult to >> understand why it exists. > > The answer to all these

Re: [GNC] Getting previous reconciliation closing balances?

2019-07-10 Thread Stephen M. Butler
On 7/10/19 4:33 AM, Adam Funk wrote: > I've tried all the following: > >> or start the reconciliation and see what appears, >> >> or search for a transaction equal to GBP10 >> >> or sort the register by amount and look at transactions equal to GBP10 > ... >>> Try doing a search using the Reconcile

Re: [GNC] Getting previous reconciliation closing balances?

2019-07-10 Thread Adam Funk
Sorry about the confusion! What I meant was that it is a British "current account" in GBP, and I was trying to explain that that is the British equivalent of a "checking account". On 2019-07-10, David Carlson wrote: > I believe you mentioned in your original note that it was an American >

[GNC] Email inbox clutter (was Column Detection when Imp...)

2019-07-10 Thread Greg Feneis
Patrick, all, If you use Gmail and its web interface through a browser, you can make use of Gmail's labels (similar to folders) and Gmail's filtering rules (see settings) to make this list's emails have a label like "GnuCash Users" , and not have the usual inbox label. It has the effect of

Re: [GNC] Getting previous reconciliation closing balances?

2019-07-10 Thread John Griessen
On 7/9/19 8:41 AM, Adam Funk wrote: Hi, The problem is that I can't figure out what the missing transaction is! I was hoping to be able to pin it down to one previous statement. What I do when old reconciles get affected by new entries/deletions is look for a previous balance that aligns

Re: [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Adrien Monteleone
Nice! Does this work for invoices not assigned a ‘job’? (I might have to tackle my own bug report on that one as my first, it is a source of confusion) I think the second report example is cleaner, by the way. And while I don’t use multi-currency AR/AP, I can certainly see the ability to pull

Re: [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Adrien Monteleone
When you are processing a payment using a remaining credit due to an overpayment, you select both the credit remaining and the new invoice. You do not need to select a transfer account in this case. If there is still a balance due on the invoice and you are processing that payment as well, you

Re: [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Christopher Lam
How about running a "Customer Report" and checking the "Total Due" bottom total? If Total Due = negative, there's still prepayment to be used up. On Wed, 10 Jul 2019 at 13:40, L. D. James wrote: > The Gnucash Business Features, Chapter 7.6.1, says you can use the > residual when paying the next

[GNC] Column Detection when Importing Transactions from CSV

2019-07-10 Thread Patrick
Sorry, I just saw this response. (I had unsubsribed to try to reduce flow into inbox, and I just saw it when I was going back through the archives. I will turn digest back on.) Thank you for this additional helpful information. 73, Patrick ag4jq On 6/26/19 12:31 PM, Patrick wrote: >* When

[GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread L. D. James
The Gnucash Business Features, Chapter 7.6.1, says you can use the residual when paying the next invoice. Can someone provide the actual steps to properly do this?  I'm sure the resolution is in the wording on the page which says: "Payment for the total amount received. GnuCash will then

Re: [GNC] Getting previous reconciliation closing balances?

2019-07-10 Thread David Carlson
I believe you mentioned in your original note that it was an American checking account. If it is denominated in dollars you may have an additional variable in how you handle exchange rate. Also, I sometimes mistakenly assign a purchase to the wrong account, so there might be a similar error in

Re: [GNC] Finance-Quote 1.49 released!

2019-07-10 Thread Eric Coates
Hi The Finance-Quote team are a modest bunch! As well as the changes noted (see below) 1.49 also correctly reports prices London quoted (London Stock Exchange, LSE) securities when Yahoo-JSON is chosen as the source. Taking advantage of this means the "price getting" procedure is a lot

Re: [GNC] Getting previous reconciliation closing balances?

2019-07-10 Thread Maf. King
On Wednesday, 10 July 2019 12:33:48 BST Adam Funk wrote: > I've tried all the following: > > or start the reconciliation and see what appears, > > > > or search for a transaction equal to GBP10 > > > > or sort the register by amount and look at transactions equal to GBP10 > > ... > > >> Try

Re: [GNC] Getting previous reconciliation closing balances?

2019-07-10 Thread Adam Funk
I've tried all the following: > or start the reconciliation and see what appears, > > or search for a transaction equal to GBP10 > > or sort the register by amount and look at transactions equal to GBP10 ... >> Try doing a search using the Reconcile field for "Not cleared" or >> "Cleared" . That

Re: [GNC] Attach Memo to Transactions

2019-07-10 Thread b3821168
Thanks very much. Solved my problem too. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: