If one customer has several jobs, I invoice each one separately. However, the customer usually pays several invoices at once. This is recorded correctly in splits, and if I run a printable invoice report on one of the paid invoices, the correct amount is given for the payment. If I run a Job Report where an invoice payment was a split, the 'payment' for that invoice is wrongly listed as the total payment rather than the split. This is possibly because the customer report on which this is based would not have this situation arising, but for the job report results in incorrect totals. System is Linux Mint 17.3, Gnucash 2.6.9 from getdeb repository. Discussion of bug on gnucash-user mailing list 6 May 2016. Thanks, Katie
confirming that bug. Having exactly the same behavior here
The aging report has been overhauled recently. Would be keen to know if it still has buggy behaviour.
I can confirm that the buggy behaviour is still there on GnuCash 4.5 FlatPak version (Linux Mint 20.1): the amount for each invoice for the job is correct, but the payments show the full payment rather than the split linked to the relevant invoice, so the payments and balance columns show nonsense figures. Let me know if you need a sample report output with customer report for comparison, and I'll blank out the confidential parts from one... regards, Katie
Further note: the figures in the summary table at the bottom are correct. regards, Katie
Yes a sample report would be useful. Even better, a sample data file. If this is not possible then an explanation of the job details would be useful so that we can replicate the bug.
Created attachment 374095 [details] exported test customer report this is the report for the same customer and period as the job report, with the correct figures - the description field differentiates between each job. Katie
Created attachment 374096 [details] exported test job report This is the export of the job report to show the bug: the way the payments and balance are calculated make these two columns totally wrong when a single payment has only one split relating to that job. Katie
I've attached a sample job report together with a customer report for the same customer and period (so includes all items in the job report). Hopefully this gives you the info you need - I don't know how to produce a sample file from my test file (which is just a copy of my live file) to get something a reasonable file size and anonymised, so if you need this you would have to explain... Katie
Created attachment 374097 [details] patch to use job payment splits only Thanks Katie, I've now understood this bug. This fix should work. Previously the PAYMENT splits would tally all payment amounts from APAR account. Now it will choose from job splits only. If you can apply patch and test, I'll be very grateful.
fixed in maint. tomorrow's flatpak build (after 2021-06-30) will have the fix. https://code.gnucash.org/builds/flatpak/maint/
