GNOME Bugzilla – Bug 108570
assign transaction splits to customer payments
Last modified: 2018-06-29 20:30:06 UTC
Thought i'd submit it anyway, they call me a dreamer.... It would be nice to be able to take transaction splits from a transaction and assign them to customer payments. This would help facilitate reconciling bank statements with large deposits containing payments from multiple customers. One could use standard transactions but then the super-fancy customer reports are not available. For example: --------Customer #1 payment ($100) / Checking account deposit ($200.00) -------------Customer #2 payment ($50) \ --------Misc Deposit ($50) Thanks... welch@c-wsolutions.com
I just realized that you can do this, but only with one payment transaction. to do it follow these steps: Create a payment via 'process payment' Navigate to the matching transaction in the account it was posted to (Checking or whatever) Add additional splits, adjust the total This transaction now has the 'tracked by customer' payment split, and additional regular splits. Not sure if this helps, but if you can do it with one payment transaction, perhaps there is a way to assign additional splits to pre-existing payment transactions, or perhaps a menu selection called 'Process Payment to Selected Split' or something. Thanks!
ok, sorry for all the additional posts, but I have found a way to do this, at least by editing the XML directly. So, I assume that there is a way to do it with the gui. But, I realize that perhaps this functionality is more in the general user-interface realm. Should I post it there instead? Anycase - you can cut and paste the tracked payment split out of one transaction into another, even one with multiple tracked payment splits, you just have to adjust the total split amount manually. Other than that it just works. If you want I can send you the XML chunk I used to try it out. That's the best this web designer can do without learning glade and C... ;)
Aaron, did you ever get more feedback on this? See my bug# 396580 http://bugzilla.gnome.org/show_bug.cgi?id=396580 for more detials on my proposal. This issue has been around a long time, but I don't detect a willingness to address this.
It's not a question of willingness.. It's a question of getting the right underlying hooks into the register, and nobody ELSE'S willingness to donate code. I have near zero time to work on gnucash, and nobody else works on the business features.. So, basically, unless it's a crasher bug, or someone sends in a patch, or it's just so simple that I can do the work in under an hour, these feature requests have been languishing. I WILL point out (as I did in your other bug report) that in 2.0 you CAN assign a payment to a specific invoice. But yes, you still must use the Process Payment and cannot do it straight through the register. That's not going to change for a long time unless I either find a LARGE chunk of time to work on GnuCash, decide to tackle that particular issue (as opposed to bigger issues, like the QIF Importer or Modularization or large-scale application architecture issues), and can get it working in the time I have..... Or someone else donates the code.
Ok, then I will see who I can find to sponsor some code here in South Africa. I'm not making any promises, but I like GnuCash and it's current feature set, and am suitably impressed with what has been done to date. I'm not a C or Guile programmer, but I've dug around in the code here and there to try and figure out what's happening. If I had the required skills, I would help though - pity I can't really. Regarding "willingness" :-) I saw some older discussions in the GnuCash forums where it seemed as if you thought that these feature were not neccessary, but if I understood that wrong, then I apologize.
Has there been any more work done on this? I'd really like to be able to go into the register, and assign a transaction as a payment for an invoice. I've heard mention of digging around in the XML file... I guess I'll just have to delete the transaction and then enter it again through the "Receive Payments" thingy.
Nope, no more work done.
I too would like to have the ability to assign payments to invoices. Though from the age of this I can see it is not going to happen. I'm a fairly handy engineer but I've no idea how complex this area of GnuCash is or any knowledge of the internal structure and workings, however with a few pointers I am willing to donate some of my time to try and make this work. I can't promise this any time soon though, but in the meanwhile where's the best place to start the learning curve? cheers, J.
I believe Christian implemented this a little while ago in the development branch of GnuCash. I have CC'd him to this bug so he can confirm or deny this.
Upon re-reading, it's not really clear to me what is asked that would not be possible right now. You can for quite a while now (at least since 2.2) use "Process Payment" to create a payment for a specific invoice. What Christian added recently was the possibility to select an existing transaction in any asset register and using right-click assign it to an invoice. This allows you to match payments to invoices if the payments came from an importer for example. Is anything more required to consider this request fulfilled ?
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for. Thanks!
This issue has not been addressed as of 2.6.15 The problem has to do with assigning split transactions as payments to multiple different invoices. An example: I make a single bank deposit of $95. In this deposit, there are three checks. Customer A paid invoice 1 for $20 Customer B paid invoice 2 for $30 Insurance company issued a refund check for $45, no invoice related. I create a new transaction: Bank account Credit: $95 Imbalance Debit: $20 Imbalance Debit: $30 Insurance Expense Debit: $45 I open the split, right click on the $20 debitand choose "Assign as payment..." I select Company A, select Invoice 1, change the payment amount to $20, and the memo to "Company A Payment." I click OK. The transaction is now: Bank account Credit: $95 Accounts Receivable Debit: $20 Blank debit: $75 The $20 is reflected in Customer A's Customer Report. I open the split, right click on the $75 debit and choose "Assign as payment..." I select Company B, select Invoice 2, change the payment amount to $30, and the memo to "Company B Payment." I click OK. The transaction is now: Bank account Credit: $95 Accounts Receivable Debit: $30 Blank debit: $65 The $30 is reflected in Customer B's Customer Report. The $20 is no longer reflected in Customer A's Customer report. There's no way to get the payments to register on both Customer A and Customer B's reports using "Assign as payment..." Let's go a little further down the rabbit hole. I'll manually edit the transaction as follows: Bank account Credit: $95 Accounts Receivable Debit: $20 Accounts Receivable: $30 Insurance Expense Debit: $45 I open Accounts Receivable and go to Actions -> View Lots... I can now move the payments from "Splits Free" to "Splits in lot" for each appropriate invoice. I update the customer reports and... BOTH customer reports reflect a payment of $50 instead of Customer A's reflecting a $20 payment while Customer B's reflects a $30 payment.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=108570. Please update any external references or bookmarks.