In this data file there is a transaction that converts from 540 to 424. It sounds like that is correct. My only guess as to the reporting is that there are PriceDB entries in your real data file that are "incorrect" for the actual transaction days. In the data file you posted, there is only a single PriceDB entry for USD to GBP with a value of 106/135.. And Lo! and Behold, 540 * 106 / 135 = 424.
I think this explains why the reports work for the test data. And you are correct, you cannot remove an INVOICE transaction from AR/AP directly, you need to unpost the invoice to remove it. This is by design. -derek On Thu, November 30, 2023 9:04 am, David Kirkby wrote: > This was the message I was thinking of - you can't delete from accounts > receivable without unposting. > > [image: image.png] > > > On Thu, 30 Nov 2023 at 13:37, David Kirkby > <drkir...@kirkbymicrowave.co.uk> > wrote: > >> The attached has the single USD/GBP transaction that I'm having problems >> with the reporting with. But the reporting is fine on this demo. >> >> On Thu, 30 Nov 2023 at 13:20, David Kirkby >> <drkir...@kirkbymicrowave.co.uk> >> wrote: >> >>> On Thu, 30 Nov 2023 at 12:13, Adrien Monteleone < >>> adrien.montele...@lusfiber.net> wrote: >>> >>>> Apparently so! >>>> >>> >>> I have lost the plot I think. >>> >>> I think there's a bug in the reporting. >>> >>> Here's a demo account, with the GBP shown correctly for USD sales, but >>> the value of the USD sales is not given. I don't know if that's >>> intentional >>> or not, but having both the GBP and USD would seem nice. >>> >>> [image: image.png] >>> >>> >>> But the ones I produced for my accountant have the foreign currency >>> too, >>> which is nice. I have not blanked out the $540 transaction, but left >>> that. >>> The GBP amount is wrong. But I'm not sure what the intended behavior of >>> the >>> report is. >>> >>> [image: image.png] >>> >>> Looking in the bank account for that transaction I see >>> [image: image.png] >>> In the trial balance >>> >>> [image: image.png] >>> >>> So there are 3 different GBP figures for these reports. >>> 1) $540 was converted by the bank into £424.00. It shown as that in the >>> bank account. >>> 2) P&L shows $540 and £441.67. The £441.67 is wrong (£17.67 too high). >>> 3) Trial balance shows £434.98 which is also wrong. (£10.98 too low) >>> >>> I suppose it's worth reporting this as a bug, despite the fact I can't >>> reproduce it in a test case, which would obviously be most helpful to >>> the >>> developers. >>> >> > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
