Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread John Ralls
What is the parent account of the three stock accounts and what is the commodity of that parent account? Regards, John Ralls > On Feb 10, 2020, at 5:21 AM, rsbrux via gnucash-user > wrote: > > Many thanks to both of you for your suggestions! > > @Adrien, > > The accounts in question

Re: [GNC] Incorrect starting balance for 2019

2020-02-10 Thread Michael or Penny Novack
But I would NOT simply edit the amount. It is better accounting practice to leave an audit trail for corrections. You can create a "correction transaction". If, as described, you want the effect to be as if you had entered the correct amount initially, date the transaction so it will appear

Re: [GNC] Payment paid which Bill? How to see which check paid which bill?

2020-02-10 Thread Fran_3 via gnucash-user
OK, I've brought up the Vendor Report (beta) by clicking Reports > Experimental  > Vendor Report (beta) Then  click Edit Options in the popup windowThen in the next window on the General Tab select the date range, enter the vendor nameThen click the Display Columns TabThen at the bottom of the

Re: [GNC] Payment paid which Bill? How to see which check paid which bill?

2020-02-10 Thread Adrien Monteleone
Not certain, but I’d steer clear of whatever you’re using as an account separator just for good measure. (by default, this is a colon) I’d also avoid slashes, and commas for exporting and processing purposes, but if you don’t do any of that, they are likely fine. (commas of course separate

Re: [GNC] Payment paid which Bill? How to see which check paid which bill?

2020-02-10 Thread Fran_3 via gnucash-user
Thanks Adrien! I'll give the experimental report a test run. I also like your technique of putting the vendors bill@ in the notes/memos. One untested idea I came up with was to enter the check number in the Payment "Num" field followed by a space & then the vendors bill/invoice id# all in the

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread Adrien Monteleone
Thanks Geert, good to know. Regards, Adrien > On Feb 10, 2020 w7d41, at 3:24 PM, Geert Janssens > wrote: > > Op maandag 10 februari 2020 21:17:22 CET schreef Adrien Monteleone: > > The importer did see great improvement in this area in 3.x, but I don’t know > > how much that affected the data

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread Geert Janssens
Op maandag 10 februari 2020 21:17:22 CET schreef Adrien Monteleone: > The importer did see great improvement in this area in 3.x, but I don’t know > how much that affected the data in the file. (unless some field/flag was > added to assist the revamped code) I’m sure there were other changes,

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread David Cousens
Not sure, but I don't understand why the prices of the securites were in CHF. Since you have AUD income and expense accounts associated with the securities and you record their purchase/sale against an AUD foreign currency account I would have thought the securities would have been in AUD if

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread Adrien Monteleone
The importer did see great improvement in this area in 3.x, but I don’t know how much that affected the data in the file. (unless some field/flag was added to assist the revamped code) I’m sure there were other changes, but I can’t think of them at the moment. (so far, we’ve listed this, dates,

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread David Carlson
I omitted the word import as in transaction import matching scheme. David Carlson On Mon, Feb 10, 2020, 2:10 PM David Carlson wrote: > Isn't there also a change to the transaction matching scheme ? I thought > that was the main reason that only 2.6.21 could read both forms. > > David Carlson

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread David Carlson
Isn't there also a change to the transaction matching scheme ? I thought that was the main reason that only 2.6.21 could read both forms. David Carlson On Mon, Feb 10, 2020, 11:57 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I recall correctly, dates are represented

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread Adrien Monteleone
Glad to hear you managed to fix the data, but that raises the question why retrieving prices is grabbing CHF instead of AUD. Is the parent of the affected securities set for AUD? This is usually an account representing the brokerage that handles the individual securities for you. Note, at

Re: [GNC] Payment paid which Bill? How to see which check paid which bill?

2020-02-10 Thread Adrien Monteleone
There is a way, but it is quite cumbersome. (using the Lot viewer) I won’t go into any detail on that because there is a much simpler method using a new Customer Report (still in beta, introduced in 3.8) found in Reports > Experimental. At first the report will come up blank and you’ll need to

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread Adrien Monteleone
If I recall correctly, dates are represented differently at some point in the 3.x series, but this might only be for SQL. Regards, Adrien > On Feb 9, 2020 w7d40, at 10:21 PM, David Carlson > wrote: > > According to the developers, the only pre-3.x version of GnuCash that is > expected to

Re: [GNC] Incorrect starting balance for 2019

2020-02-10 Thread Adrien Monteleone
The carpenter’s rule I learned was, “Measure twice, cut once.” Those other two rules, while true, produce lots of waste in materials and time. All three lend credence to the maxim, “You can have it right, or right now, but not both." --- But to the question, yes, you can simply change the

[GNC] Payment paid which Bill? How to see which check paid which bill?

2020-02-10 Thread Fran_3 via gnucash-user
There is no way to see what bill a check paid... is there? When paying a bill you get 5 fields...DatePaymentRefundNumMemo Date, Payment, and Refund won't do it.Num is for the check numberMemo could be used but that is just a visual association...  Seems like the system ought out to have a report

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread David Carlson
According to the developers, the only pre-3.x version of GnuCash that is expected to read data files that have been touched by a 3.x version is release 2.6.21, possibly with a suffix depending on the OS it is run in. When a file is first touched by 3.x there are some unspecified changes that may

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread Colin Law
On Mon, 10 Feb 2020 at 15:21, Wirawan Purwanto wrote: > > Hi David, thanks for clarification. For every major release (either > 2.x or 3.x series), is there a guarantee for file format > compatibility? Upwards, yes I believe so. Any migration necessary would be handled by gnucash itself. There

Re: [GNC] Incorrect starting balance for 2019

2020-02-10 Thread Colin Law
First make a backup copy of your .gnucash file, in fact no doubt you are backing up your data file regularly anyway. That is the file that has the name that you gave it when you first saved it in gnucash and probably has the extension .gnucash. Does the account currently match that in the

[GNC] [MAINT] Unexpected reboot/downtime of code (gnucash server)

2020-02-10 Thread Derek Atkins
Hi, TL;DR: The Ovirt VM system rebooted last night but the VMs didn't come back up. They are now back up and running normally (and the cause of the lack of restart has been corrected). Long Version: Some of you may have noticed that code was unavailable for the past 12 hours. Apparently the

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread Wirawan Purwanto
Hi David, thanks for clarification. For every major release (either 2.x or 3.x series), is there a guarantee for file format compatibility? Wirawan On Sun, Feb 9, 2020 at 11:21 PM David Carlson wrote: > > According to the developers, the only pre-3.x version of GnuCash that is > expected to

[GNC] Incorrect starting balance for 2019

2020-02-10 Thread Richard Danielson
Hello all, I moved my accounting from Simply Accounting 7 (something) on Win 7 to GC 2.6.19 on ubuntu linux back in January/19.  For starting balances I used my trial balance from 2018 on Simply Accounting to get the values for Jan 1/19 on GC.  I subsequently worked like a bionic beaver to do

Re: [GNC] GNUCash XML format compatibility

2020-02-10 Thread David Cousens
Wirawan, I don't think anyone has mapped out the changes in data file structures. That information will be contained in the Release Notes for each version. The 2.6 to 3 transition involved some changes in the locations that user configuration files are located in on the various systems which are

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread rsbrux via gnucash-user
Many thanks to both of you for your suggestions! @Adrien, The accounts in question already had the correct currency (AUD) assigned.  The accounts in question are a foreign currency account in AUD, three accounts for AUD-denominated securities (which I bought/sold in the above-mentioned