Re: [GNC] coalesce the stock accounts in the report

2023-01-26 Thread R Losey
I have a similar setup, whereby I have "BBB" (and others) in multiple brokers... so, in GnuCash, the "BBB" account is "Bank1-BBB" and "Bank2-BBB", even though the stock is "BBB". I have had no problems transferring stock between accounts. On Wed, Jan 25, 2023 at 3:27 PM Mattia Rizzolo wrote: >

Re: [GNC] coalesce the stock accounts in the report

2023-01-26 Thread Adrien Monteleone
Saved reports are HTML tables. Any spreadsheet app should be able to open them properly. Exactly how would depend on that app. Otherwise, you can run the report, Select All, Copy, Paste into a new spreadsheet. Regards, Adrien On 1/26/23 2:07 PM, Mattia Rizzolo wrote: Could you please tell m

Re: [GNC] coalesce the stock accounts in the report

2023-01-26 Thread Murugan Muruganandam
Mattia a faster and less invasive solution is to extract the Advanced Portfolio into a spread sheet and create a Pivot table which can consolidate the data at Stock level I have a question though, when you moved your stocks between broker what was the operation you did which reflected 100% los

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

2023-01-26 Thread Adrien Monteleone
Fred, see my last reply before this one. I was able to reproduce this issue using an exchange rate *other* than 1:1 with Trading Accounts turned off and trying to pay the bill in a currency other than the one the bill is denominated in. (in this case, trying to pay a USD bill with GBP) Turnin

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

2023-01-26 Thread Fred Bone
On 25 January 2023 at 21:09, Dr. David Kirkby said: > On Wed, 25 Jan 2023 at 20:52, Fred Bone wrote: > > > On 25 January 2023 at 20:35, Dr. David Kirkby said: > > > > > On Wed, 25 Jan 2023 at 19:29, Dr. David Kirkby < > > > drkir...@kirkbymicrowave.co.uk> wrote: > > > > > > > > > > > I have the

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

2023-01-26 Thread Adrien Monteleone
Dave, First off, let's get this out of the way: I noticed in your last screenshots, the window title bar is included with a 'Reconciled ...' file name. Name your file whatever you want, but I can imagine that will get tedious as time goes on to keep renaming the file. (but I suppose if you're