Re: [GNC] Can't assign payment to multiple invoices
On 01/11/2018 10:39, Wail Yahyaoui wrote: Wm: If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. > > I wanted to clean the unpaid invoice list. # > What do you mean by "tidy it up occasionally"? If the person that is paying isn't specific (i.e. they don't say, I am paying 100 for this invoice and 50 for that) you are within your rights to allocate the payments as you see fit so long as you tell them. I'm presuming no dispute about services done, offered, etc. The normal accounting way is to allocate the payments to the oldest invoice, produce statements and keep communicating. This isn't gnc specific, the "tidy up occasionally" exercise should result in a statement of account, the number at the bottom being what you expect to be paid. If your client / customer / whoever disagrees with your allocation of payments then you have a conversation, this is generally a good thing. -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't assign payment to multiple invoices
I wanted to clean the unpaid invoice list. What do you mean by "tidy it up occasionally"? On 31/10/2018 16:43, Wm via gnucash-user wrote: On 27/10/2018 19:24, wail wrote: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. If I edit the payment again, only one invoice is selected. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't assign payment to multiple invoices
Op woensdag 31 oktober 2018 16:43:12 CET schreef Wm via gnucash-user: > On 27/10/2018 19:24, wail wrote: > > Hello, > > I have a list of invoices and a list of payments and I'm trying to assign > > payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). > > The problem is that my client pays sums that are not related to invoices, > > e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. > > So I need to assign a payment to two or three invoices. > > I just want to assign each payment to the oldest unpaid invoice(s). > > > > I was able to add a few payments to multiple invoices then it stopped > > working, that is, if I select two payments in the "Process payment" window > > and click ok, then only the last selected invoice will receive the > > payment. > > If I edit the payment again, only one invoice is selected. > > > > That may be unrelated but sometimes the right click menu on a transaction > > shows "edit payment" and sometimes it shows "assign as payment" instead > > (typically after I edit the payment once and it gets split). > > Also, in the "Process payment" window, when there are multiple invoices > > for > > a given date, the list of invoices does not always appear in order of > > invoices number. The list is ordered by Date but it would be better if it > > could be ordered by invoice number in a given date. > > If the payments really are unrelated to the invoices use the old > fashioned payment on account method, i.e. reduce the balance on the > Liability and tidy it up occasionally. Good point indeed. That's what GnuCash does if you don't select invoices while adding payments for a customer. Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't assign payment to multiple invoices
On 27/10/2018 19:24, wail wrote: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. If I edit the payment again, only one invoice is selected. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't assign payment to multiple invoices
Op woensdag 31 oktober 2018 18:12:28 CET schreef Wail Yahyaoui: > Hello Geert, > > Thanks for your reply. I now realize that the assignment to multiple > invoices was working all along but I got confused by the order of > invoices. Payments are indeed assigned to the oldest invoice first but > according to an order that is not the invoice number order (in a given > day) nor the order in which I posted the invoices. Anyway, I have been > able to assign all payments. > > I will file an enhancement request for this problem of ordering of > invoices in the Process Payment > Document and I will also explain the > problem that I had. > > I did not import transactions but I started with Gnucash 2.6.19 (Ubuntu > 18.04), entered invoices and payments then switched recently to Gnucash > 3.3 (Ubuntu 18.10). Maybe that changed the order of invoices in a given > day, although I unposted and posted again the invoices in the correct > order (invoice number number). Glad you got it working. I was asking how you had entered your transactions to give you a more precise way to solve your issue, but you found out on your own. Even better :) Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't assign payment to multiple invoices
Hello Geert, Thanks for your reply. I now realize that the assignment to multiple invoices was working all along but I got confused by the order of invoices. Payments are indeed assigned to the oldest invoice first but according to an order that is not the invoice number order (in a given day) nor the order in which I posted the invoices. Anyway, I have been able to assign all payments. I will file an enhancement request for this problem of ordering of invoices in the Process Payment > Document and I will also explain the problem that I had. I did not import transactions but I started with Gnucash 2.6.19 (Ubuntu 18.04), entered invoices and payments then switched recently to Gnucash 3.3 (Ubuntu 18.10). Maybe that changed the order of invoices in a given day, although I unposted and posted again the invoices in the correct order (invoice number number). Regards, Wail On 31/10/2018 10:21, Geert Janssens wrote: Op zaterdag 27 oktober 2018 20:24:47 CET schreef wail: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. Is the payment amount big enough to cover the two invoices ? I'd have to verify how GnuCash orders preselected invoices. I *thought* however that if you don't select invoices at all GnuCash will automatically assign the payment to oldest invoices first. If I edit the payment again, only one invoice is selected. That makes sense as only one invoice received the payment as to your previous statement. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). This is intentional and has meaning: If the context menu shows "Edit payment" that means this transactions has already been (partly) assigned to an invoice. If you choose to click "Edit payment" you are effectively telling GnuCash you want to *change* this existing assignment. Hence GnuCash will open the process payment window with the existing assignment reconfigured, ready for you to make changes. This can be a bit tricky to do. On the other hand if the contet menu "Assign as payment", this means GnuCash is unaware this transaction is related to a business payment and allows you to assign it to a customer (and optionally a preferred invoice. How do you enter the payment transactions themselves in gnucash ? Do you import them or create them by hand ? Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. That will need some programming to get fixed. Can you file an enhancement request for this in bugzilla [1] ? [1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Can't assign payment to multiple invoices
Op zaterdag 27 oktober 2018 20:24:47 CET schreef wail: > Hello, > I have a list of invoices and a list of payments and I'm trying to assign > payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). > The problem is that my client pays sums that are not related to invoices, > e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. > So I need to assign a payment to two or three invoices. > I just want to assign each payment to the oldest unpaid invoice(s). > > I was able to add a few payments to multiple invoices then it stopped > working, that is, if I select two payments in the "Process payment" window > and click ok, then only the last selected invoice will receive the payment. Is the payment amount big enough to cover the two invoices ? I'd have to verify how GnuCash orders preselected invoices. I *thought* however that if you don't select invoices at all GnuCash will automatically assign the payment to oldest invoices first. > If I edit the payment again, only one invoice is selected. That makes sense as only one invoice received the payment as to your previous statement. > That may be unrelated but sometimes the right click menu on a transaction > shows "edit payment" and sometimes it shows "assign as payment" instead > (typically after I edit the payment once and it gets split). This is intentional and has meaning: If the context menu shows "Edit payment" that means this transactions has already been (partly) assigned to an invoice. If you choose to click "Edit payment" you are effectively telling GnuCash you want to *change* this existing assignment. Hence GnuCash will open the process payment window with the existing assignment reconfigured, ready for you to make changes. This can be a bit tricky to do. On the other hand if the contet menu "Assign as payment", this means GnuCash is unaware this transaction is related to a business payment and allows you to assign it to a customer (and optionally a preferred invoice. How do you enter the payment transactions themselves in gnucash ? Do you import them or create them by hand ? > Also, in the "Process payment" window, when there are multiple invoices for > a given date, the list of invoices does not always appear in order of > invoices number. The list is ordered by Date but it would be better if it > could be ordered by invoice number in a given date. That will need some programming to get fixed. Can you file an enhancement request for this in bugzilla [1] ? [1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Can't assign payment to multiple invoices
Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while payments would be $2 $6 $2 $3 $5. So I need to assign a payment to two or three invoices. I just want to assign each payment to the oldest unpaid invoice(s). I was able to add a few payments to multiple invoices then it stopped working, that is, if I select two payments in the "Process payment" window and click ok, then only the last selected invoice will receive the payment. If I edit the payment again, only one invoice is selected. That may be unrelated but sometimes the right click menu on a transaction shows "edit payment" and sometimes it shows "assign as payment" instead (typically after I edit the payment once and it gets split). Also, in the "Process payment" window, when there are multiple invoices for a given date, the list of invoices does not always appear in order of invoices number. The list is ordered by Date but it would be better if it could be ordered by invoice number in a given date. -- 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: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.