Re: [GNC] Merger

2019-07-30 Thread Les
Thanks John, That makes very good sense. I really appreciate you assistance. Les On 7/30/19 4:05 PM, John Ralls wrote: On Jul 30, 2019, at 12:03 PM, Les wrote: Hi John, thanks for the reply. I guess I omitted the fact that the existing stock had a different name (symbol) that the new

Re: [GNC] Fwd: how to copy "Customers Overview" table for spreadsheet.

2019-07-30 Thread david whiting
I'm a few pages into a book about xslt so I thought I'd give this a go. I'm sure it's not the best xslt and anyone who knows how to use xslt properly will probably feel unwell after looking at this, but it does seem to work, i.e. produce a summary html table with the customers overview info (and a

Re: [GNC] Merger

2019-07-30 Thread John Ralls
> On Jul 30, 2019, at 12:03 PM, Les wrote: > > Hi John, thanks for the reply. I guess I omitted the fact that the existing > stock had a different name (symbol) that the new stock. So is this more of a > transfer? > > Thanks, > > On 7/30/19 1:41 PM, John Ralls wrote: >> >>> On Jul 30,

Re: [GNC] Merger

2019-07-30 Thread John Ralls
> On Jul 30, 2019, at 11:05 AM, Les wrote: > > Hi all: > > I had a merger transaction on one of my Canadian stocks where my existing > holding was acquired on a 33 for 20 basis (new for old). From 500 of the > existing shares for 825 shares of the new. I also had a net gain in cash of >

Re: [GNC] Saving UI settings

2019-07-30 Thread Geert Janssens
Op dinsdag 30 juli 2019 08:00:58 CEST schreef David Carlson: > Should I take the deafening silence to indicate that there is no > accelerator or shortcut to save the window arrangement and report settings > without closing and re-opening the entire program? > > David Carlson We're in the summer

[GNC] Merger

2019-07-30 Thread Les
Hi all: I had a merger transaction on one of my Canadian stocks where my existing holding was acquired on a 33 for 20 basis (new for old). From 500 of the existing shares for 825 shares of the new.  I also had a net gain in cash of C$16.75. I am uncertain on how to handle this transaction

[GNC] RE Merger

2019-07-30 Thread Les
Sorry, I should have stated that I am using LInux Mint 19.0 and GC 2.6.19. Les ___ 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

Re: [GNC] Concern with the lengthy list of "Known Issues"

2019-07-30 Thread Geert Janssens
Op maandag 22 juli 2019 00:09:02 CEST schreef David Cousens via gnucash-user: > Scott, > > I have been using GnuCash 3.6 on Linux Mint 19.1 since it was released (and > most of the V3 releases usually within a few days of their release) without > any significant issues at all. My usage is mainly

Re: [GNC] Help with Export

2019-07-30 Thread Jack Lockard
As others have said, Windows 7 and 10 do not allow users to save files to the root of the C: drive nor in any system folder. It is best to save in C:\Users\YourName or sub-folder under there. Jack -Original Message- From: gnucash-user On Behalf Of David Carlson Sent: Monday, July 29,

Re: [GNC] Miscalculation in cashflow reports

2019-07-30 Thread Frank H. Ellenberger
Hi, Am 30.07.19 um 16:13 schrieb Geert Janssens: > Does it even make sense to try to determine the "cash flow" on a single > account ? I can imagine one would see the cash flow for a business and the > details of how that cash flow was generated. Trying to to so on a single > account may yield

Re: [GNC] best accounting practice for refund

2019-07-30 Thread Geert Janssens
It took me a while to respond as I was on holidays :) First off, I can't read the second screenshot, so I don't know what's in there. In your first screenshot I see three transactions: 1. An "Invoice type" (I) transaction, named Credit Note 2019 (don't worry about it being called "Invoice

Re: [GNC] How to update Description info in Payment Field of Customer Report?

2019-07-30 Thread Adrien Monteleone
Thanks Geert, that’s probably the safest and certainly most consistent option. Regards, Adrien > On Jul 30, 2019, at 12:03 PM, Geert Janssens > wrote: > > The other (more conservative) option is to right-click on the payment > transaction in the AR account and then select "Edit Payment...".

Re: [GNC] Miscalculation in cashflow reports

2019-07-30 Thread Adrien Monteleone
> On Jul 30, 2019, at 10:57 AM, Adrien Monteleone > wrote: > > The basic form is something like this: > > -- > Cash & Cash Equivalents, beginning of period: > > Cash Flow from Operations: > Cash Flow from Financing: > Cash Flow from Investing: > > Net Increase in Cash & Cash

Re: [GNC] How to update Description info in Payment Field of Customer Report?

2019-07-30 Thread Geert Janssens
The other (more conservative) option is to right-click on the payment transaction in the AR account and then select "Edit Payment...". That way you're consistently using the same window to set all your payment memos. Regards, Geert Op vrijdag 12 juli 2019 16:45:46 CEST schreef Adrien

Re: [GNC] Miscalculation in cashflow reports

2019-07-30 Thread Adrien Monteleone
> On Jul 30, 2019, at 10:57 AM, Adrien Monteleone > wrote: > > > What I have found so far, is that certainly the Operations section will > contain several adjustments to account for anything accrued or transacted in > credit as opposed to cash. (i.e., changes to AR/AP, Inventory,

Re: [GNC] Fwd: how to copy "Customers Overview" table for spreadsheet.

2019-07-30 Thread Geert Janssens
Op maandag 8 juli 2019 21:46:23 CEST schreef Adrien Monteleone: > David, > > The OP was asking about the Customer Overview, not Customer Summary Report. > > The Customer Summary Report doesn’t show the same info as the Customer > Overview. Notably, customer ID, address, and phone#. The overview

Re: [GNC] how to copy "Customers Overview" table for spreadsheet.

2019-07-30 Thread Geert Janssens
Op maandag 8 juli 2019 19:15:43 CEST schreef Jonathan Francoeur via gnucash- user: > I'd like to copy and paste the data from the "Customers Overview" table > into a spreadsheet. Any ideas how? Sure: * Select the table by dragging your mouse cursor over it (I only selected the table) * Hit

Re: [GNC] Miscalculation in cashflow reports

2019-07-30 Thread Adrien Monteleone
I’ll provide something more detailed later, but the current report seems either way off, or just a first attempt that didn’t get fully fleshed out. A Statement of Cashflows has 3 main parts: Operating Activities Financing Activities Investing Activities There are rule differences between GAAP

Re: [GNC] Miscalculation in cashflow reports

2019-07-30 Thread Adrien Monteleone
> On Jul 30, 2019, at 9:13 AM, Geert Janssens > wrote: > > > > I really would like to have input from users with actual accounting > backgrounds on > 1. what a cash flow report really should display > 2. whether our current cash flow report actually does that or is in effect a > totally

Re: [GNC] Miscalculation in cashflow reports

2019-07-30 Thread Geert Janssens
Op zaterdag 13 juli 2019 17:20:41 CEST schreef John Ralls: > There hasn't been much of a response, perhaps because the presentation here > isn't clear. > > The bug, https://bugs.gnucash.org/show_bug.cgi?id=797093, complains that the > Cash Flow report on a single bank account reports the

Re: [GNC] Gnucash bug

2019-07-30 Thread Mike or Penny Novack
On 7/30/2019 3:52 AM, Wm via gnucash-user wrote: On 09/07/2019 03:45, John Ralls wrote: On 8 juil. 2019, at 08:55, R. Victor Klassen wrote: Perhaps this has been fixed. I’m using 2.6.21 for production. Using SQLite I am expecting every transaction to hit disk immediately. Saturday we

Re: [GNC] Gnucash bug

2019-07-30 Thread Wm via gnucash-user
On 09/07/2019 03:45, John Ralls wrote: On 8 juil. 2019, at 08:55, R. Victor Klassen wrote: Perhaps this has been fixed. I’m using 2.6.21 for production. Using SQLite I am expecting every transaction to hit disk immediately. Saturday we had a power failure and lost about five days’ worth

Re: [GNC] How can I make GnuCash store all dates in only 1 format?

2019-07-30 Thread Mark Debian via gnucash-user
Sorry, that should have read: When I look at the transactions table I have dates in the following formats: 1:  mmddHHMMSS 2:  -mm-dd HH:MM:SS Unfortunately, the sqlite date, datetime, strftime functions will not recognise the first format as a date.

Re: [GNC] Saving UI settings

2019-07-30 Thread David Carlson
Should I take the deafening silence to indicate that there is no accelerator or shortcut to save the window arrangement and report settings without closing and re-opening the entire program? David Carlson On Thu, Jul 18, 2019 at 11:05 AM David Carlson wrote: > I noticed recently that if