Re: [GNC] Account Currency Screwed Up Again!

[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 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 foreign currency account), various expense accounts in AUD 
> and an income account in AUD for interest.  The transactions between the 
> foreign currency account and the expense accounts were recoreded in AUD as 
> expected.  All other transactions were recorded with CHF exchange rates, 
> although no currency conversions were called for.  The prices of two of the 
> three securities were also recorded in CHF.  SInce the GC UI shows all 
> accounts in AUD (except for the securities accounts, which IIRC, do not have 
> a currency) it was unclear to me which account(s) I should duplicate.
> 
> @David,
> 
> My default currency is CHF; I live in Switzerland.  Trading accounts are 
> turned on.  I have tried to fix this in the XML based on the information you 
> provided.  I tried to look up more information about the file structure, but 
> the guide  
> wasn't much help, and the wiki  appears to be 
> down.
> 
> IAC, I edited the price records for the two securities which had incorrect 
> price currencies, as well as all transactions which refenenced any of the 
> three securities accounts, changing the currencies from CHF to AUD.  This 
> appears to have fixed the problems, but I am keeping a couple of pre-edit 
> backups, as you recommend.
> 
> Am I the only one to encounter problems like this?
> 
> SInce the problem seems to have been with the (implicitly determined) 
> currencies of the prices and the transactions, would it be possible to add an 
> option to the price editor dialog for each price and to the exchange rate 
> editor for each transaction to change or select the currency?  From what I 
> have learned about the data structure, this looks like the easiest way to 
> provide a less dangerous way to fix such problems.
> 
>> Date: Mon, 3 Feb 2020 10:31:58 -0600
>> From: Adrien Monteleone 
>> To: Gnucash Users 
>> Subject: Re: [GNC] Account Currency Screwed Up Again!
>> Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net>
>> Content-Type: text/plain;charset=utf-8
>> 
>> Would creating a new duplicate account with the proper assigned currency, 
>> then deleting the old account and choosing to transfer all transactions to 
>> the new currency work?
>> 
>> That would be significantly easier than manual editing.
>> 
>> I?m not sure how the use of Trading Accounts affects this, or if it should 
>> or should not be turned on.
>> 
>> 
>> Regards,
>> Adrien
>> 
>>> On Feb 3, 2020 w6d34, at 4:45 AM, David Cousens  
>>> wrote:
>>> 
>>> Have you checked the default currency used Edit->Preferences, Accounts tab,
>>> Default Currency. It is normally set to locale. I guess you are in Australia
>>> so it should be AUD. If not, diid you possibly create the book originally
>>> while overseas or the locale on your computer was not set to Australia.
>>> AFAIK it is not possible to edit the currency of an account once it is
>>> created in the Edit Account dialog only in the New Account dialog.
>>> 
>>> It should be possible to edit the file this but fraught with possible
>>> problems.  Work on a copy of your original file and don't save it over the
>>> original until you are really sure that the problem is fixed and other
>>> problems haven't been created. I would keep a copy of the original even
>>> after you reach this point just to be sure.
>>> 
>>> Your XML file will have to be uncompressed Edit ->Preferences General Tab
>>> and uncheck the box which says compress files. You may then have to force a
>>> Save. I did this by creating a dummy transaction in a register then hitting
>>> the Save button in the toolbar, deleting the dummy transaction and clicking
>>> Save again.
>>> 
>>> The section of the XMLfile which contains the commodity information for an
>>> account is reproduced below for a SGD account I have.
>>> 
>>>  TravelMoney_CC_SGD
>>>  *7db63ffa514d478191dea006748d7bd6*
>>>  LIABILITY
>>>  
>>>CURRENCY
>>>*SGD*
>>>  
>>> 
>>> You will have to have the commodity you wish to change the account to
>>> specified earlier in the file in a section like
>>> 
>>>  CURRENCY
>>>  SGD
>>>  
>>>  currency
>>>  
>>> 
>>> 
>>> Each transaction to the account will have the commodity specified in a
>>>  tag set. You would need to find all of these and change the
>>> commodity similarly
>>> 
>>>  4ec8a9416b31469bb1eeaf79c5557092
>>>  
>>>CURRENCY
>>>SGD
>>>  
>>>  
>>>2019-03-17 10:59:00 +
>>>  
>>>  

Re: [GNC] Incorrect starting balance for 2019

[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 immediately after that book opening transaction.


Michael D Novack




On 2/10/2020 12:48 PM, Adrien Monteleone wrote:

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 opening balance transaction 
in the register for that account. You can also do it from the 'Equity:Opening 
Balances' account. Opening transactions are just simple transactions between 
the account in question and ‘Equity:Opening Balances’.

Of course, this will alter your balances in that account for the entire history 
of the book, but that is what you want to do.

If some period had worked out correctly before the edit, that means you had an 
error in that period. (because the opening balance was wrong, the ending 
balance should be wrong also, if it wasn’t, that means another error was 
present.)

After the edit, start reconciling one period at a time and *then* print 
reports. (You printed reports for non-reconciled periods? How did you know the 
were correct?)

Regards,
Adrien


On Feb 9, 2020 w7d40, at 11:05 PM, Richard Danielson  wrote:

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 all my accounting for the 
year.

Unfortunately, at this very late point in time, I discovered that I started the 
year with an incorrect total on one of my asset accounts.  If possible, would 
like to edit this starting amount for Jan 1/19 so that things work out 
correctly afterward and all the way up to the end of the year.

Being suspicious of my actions I waited to reconcile any bank or credit card 
accounts, so if it is possible to just change the starting balance on that one 
account, I will happily re-print all of my monthly reports and reconcile 
everything which should be reconciled before going into 2020.

All my life, I have followed the carpenter's rule - "There is always time to do a job 
twiceif you screw up, you have to do it again."  Of course, there is always at least one 
exception, for example - "If you cut a board too short, then cut it again!"

Can someone tell me whether in this case, the rule holds or does the exception 
hold?   Thanks.

Rick

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 list click Links and select one of the 
choices.I selected Simple then clicked Apply to see the report come upNow the 
last column is titled "Links" and at the end of each Payment row the Vendor 
Bill/Invoice/Reference number shows up so you can see that check was used to 
pay that bill.
Very Cool !
Thank you Adrien and also the GC dev Team.


On Monday, February 10, 2020, 01:05:15 PM EST, Adrien Monteleone 
 wrote:  
 
 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 choose a customer in 
Options.

Then in Options > Display you can choose to show the linked documents either in 
a simple, or detailed format. Play with both to see what works for you.

The dev working on this (and other beta reports) would much appreciate as many 
people using and testing it as possible and reporting any issues.

For some years now I have also been putting in my payment transaction 
notes/memos the bill# that is being paid by that transaction/split and if 
partial or final payment, indicate that as well.

Thus:

“for invoice #1234”
“1st partial for invoice #1234”
“2nd partial for invoice #1234”
“final for invoice #1234”

You could also repurpose the action field for applied invoice numbers, but memo 
is probably better unless you need that field for something else. (you have 
more space to see the number, for one)

Unfortunately, there is a bug still in the AR/AP registers that setting the 
text on a memo also changes the notes field to match, and setting the notes 
field changes the first memo to match, so keep that in mind.

Regards,
Adrien



> On Feb 10, 2020 w7d41, at 11:48 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> 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 showing Vendor's 
> Bill/Invoice number & date plus the Payment Check number and date...
> Is noting the vendors invoice/bill number in the Memo field the only way to 
> do it?
> We considered putting the vendors invoice/bill number in the Num field but 
> that field is for our check number...
> Am I missing something obvious? (Won't be the first time :-)
> Thanks for any help.

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 values in CSV 
files, and slashes are used by operating systems in file paths and as escape 
sequences. Unless you’ve tested a particular character and know it won’t cause 
an issue, better to avoid it.) Within GnuCash itself, I don’t think there is 
any issue or restriction. The only concern would be with exported data.

Anything else should work. Note that GnuCash won’t sort non-numbers, so the 
first non-number it encounters, sorting will stop. This may or may not be of 
any consequence to you.

Regards,
Adrien


> On Feb 10, 2020 w7d41, at 4:37 PM, Fran_3  wrote:
> 
> 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 num field like for check number 1423 and vendor bill number 08279 I would 
> enter...
> 1432 08279
> or maybe put a colon after the ck num.
> Wonder if that will break something in one of the reports or else where?


___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 
num field like for check number 1423 and vendor bill number 08279 I would 
enter...1432 08279or maybe put a colon after the ck num.Wonder if that will 
break something in one of the reports or else where?


On Monday, February 10, 2020, 01:05:15 PM EST, Adrien Monteleone 
 wrote:  
 
 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 choose a customer in 
Options.

Then in Options > Display you can choose to show the linked documents either in 
a simple, or detailed format. Play with both to see what works for you.

The dev working on this (and other beta reports) would much appreciate as many 
people using and testing it as possible and reporting any issues.

For some years now I have also been putting in my payment transaction 
notes/memos the bill# that is being paid by that transaction/split and if 
partial or final payment, indicate that as well.

Thus:

“for invoice #1234”
“1st partial for invoice #1234”
“2nd partial for invoice #1234”
“final for invoice #1234”

You could also repurpose the action field for applied invoice numbers, but memo 
is probably better unless you need that field for something else. (you have 
more space to see the number, for one)

Unfortunately, there is a bug still in the AR/AP registers that setting the 
text on a memo also changes the notes field to match, and setting the notes 
field changes the first memo to match, so keep that in mind.

Regards,
Adrien



> On Feb 10, 2020 w7d41, at 11:48 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> 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 showing Vendor's 
> Bill/Invoice number & date plus the Payment Check number and date...
> Is noting the vendors invoice/bill number in the Memo field the only way to 
> do it?
> We considered putting the vendors invoice/bill number in the Num field but 
> that field is for our check number...
> Am I missing something obvious? (Won't be the first time :-)
> Thanks for any help.

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 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, and
> > config locations, with dates being the only one I can think of that
> > certainly affected the data file)
> > 
> The training data collected by the import matcher will indeed be stored in a 
> different format in the 3.x series. In the 2.6.x series only the very last 
> version, 2.6.21 will be able to process it.
>  
> Geert


___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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, 
but I
> can’t think of them at the moment. (so far, we’ve listed this, dates, and
> config locations, with dates being the only one I can think of that
> certainly affected the data file)
> 
The training data collected by the import matcher will indeed be stored in 
a different format in the 3.x series. In the 2.6.x series only the very last 
version, 2.6.21 will be able to process it.

Geert
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Currency Screwed Up Again!

[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 traded on the ASX.

A lot will depend upon what you are required to supply to your tax authorities, 
where tax is paid, and what rules apply
on timing of conversion from AUD to CHF for tax recording purposes. For that 
sort of info you will need a Swiss tax
accountant with foreign tax experience. 

In Australia companies operate under a company tax regime where tax paid on 
company profits is not normally taxed again
as a dividend in the hands of a shareholder. The shareholder receives a 
franking credit for the tax paid in the hands of
the company to offset against their income tax. Not all share dividends are 
franked however. This of course only applies
to Australian shareholders who pay income tax in Australia unless  some sort of 
reciprocal tax agreement between
countries exists covering these taxes.


On Mon, 2020-02-10 at 14:21 +0100, rsbrux via gnucash-user wrote:
> 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 foreign currency account), various expense 
> accounts in AUD and an income account in AUD for interest.  The 
> transactions between the foreign currency account and the expense 
> accounts were recoreded in AUD as expected.  All other transactions were 
> recorded with CHF exchange rates, although no currency conversions were 
> called for.  The prices of two of the three securities were also 
> recorded in CHF.  SInce the GC UI shows all accounts in AUD (except for 
> the securities accounts, which IIRC, do not have a currency) it was 
> unclear to me which account(s) I should duplicate.
> 
> @David,
> 
> My default currency is CHF; I live in Switzerland.  Trading accounts are 
> turned on.  I have tried to fix this in the XML based on the information 
> you provided.  I tried to look up more information about the file 
> structure, but the guide 
>  wasn't 
> much help, and the wiki  appears to be down.
> 
> IAC, I edited the price records for the two securities which had 
> incorrect price currencies, as well as all transactions which refenenced 
> any of the three securities accounts, changing the currencies from CHF 
> to AUD.  This appears to have fixed the problems, but I am keeping a 
> couple of pre-edit backups, as you recommend.
> 
> Am I the only one to encounter problems like this?
> 
> SInce the problem seems to have been with the (implicitly determined) 
> currencies of the prices and the transactions, would it be possible to 
> add an option to the price editor dialog for each price and to the 
> exchange rate editor for each transaction to change or select the 
> currency?  From what I have learned about the data structure, this looks 
> like the easiest way to provide a less dangerous way to fix such problems.
> 
> > Date: Mon, 3 Feb 2020 10:31:58 -0600
> > From: Adrien Monteleone 
> > To: Gnucash Users 
> > Subject: Re: [GNC] Account Currency Screwed Up Again!
> > Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net>
> > Content-Type: text/plain;   charset=utf-8
> > 
> > Would creating a new duplicate account with the proper assigned currency, 
> > then deleting the old account and choosing
> > to transfer all transactions to the new currency work?
> > 
> > That would be significantly easier than manual editing.
> > 
> > I?m not sure how the use of Trading Accounts affects this, or if it should 
> > or should not be turned on.
> > 
> > 
> > Regards,
> > Adrien
> > 
> > > On Feb 3, 2020 w6d34, at 4:45 AM, David Cousens 
> > >  wrote:
> > > 
> > > Have you checked the default currency used Edit->Preferences, Accounts 
> > > tab,
> > > Default Currency. It is normally set to locale. I guess you are in 
> > > Australia
> > > so it should be AUD. If not, diid you possibly create the book originally
> > > while overseas or the locale on your computer was not set to Australia.
> > > AFAIK it is not possible to edit the currency of an account once it is
> > > created in the Edit Account dialog only in the New Account dialog.
> > > 
> > > It should be possible to edit the file this but fraught with possible
> > > problems.  Work on a copy of your original file and don't save it over the
> > > original until you are really sure that the problem is fixed and other
> > > problems haven't been created. I would keep a copy of the original even
> > > after you reach this point just to be sure.
> > > 
> > > Your XML file will have to be 

Re: [GNC] GNUCash XML format compatibility

[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, and config 
locations, with dates being the only one I can think of that certainly affected 
the data file)

Regards,
Adrien

> On Feb 10, 2020 w7d41, at 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 


___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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
>
>
> On Mon, Feb 10, 2020, 11:57 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> 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 <
>> david.carlson@gmail.com> wrote:
>> >
>> > 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 be at least partially mentioned in other threads here.  They do not
>> > specify if there are any changes in the database variations, but there
>> > probably are.
>> >
>> > David Carlson
>>
>> ___
>> 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 you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 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 <
> david.carlson@gmail.com> wrote:
> >
> > 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 be at least partially mentioned in other threads here.  They do not
> > specify if there are any changes in the database variations, but there
> > probably are.
> >
> > David Carlson
>
> ___
> 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 you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Currency Screwed Up Again!

[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 this time, I don’t think you can have mixed currency accounts in one 
brokerage parent. You’ll have to create separate brokerage parent accounts for 
each currency.

Regards,
Adrien

> On Feb 10, 2020 w7d41, at 7:21 AM, rsbrux via gnucash-user 
>  wrote:
> 
> 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 foreign currency account), various expense accounts in AUD 
> and an income account in AUD for interest.  The transactions between the 
> foreign currency account and the expense accounts were recoreded in AUD as 
> expected.  All other transactions were recorded with CHF exchange rates, 
> although no currency conversions were called for.  The prices of two of the 
> three securities were also recorded in CHF.  SInce the GC UI shows all 
> accounts in AUD (except for the securities accounts, which IIRC, do not have 
> a currency) it was unclear to me which account(s) I should duplicate.

> 
> @David,
> 
> My default currency is CHF; I live in Switzerland.  Trading accounts are 
> turned on.  I have tried to fix this in the XML based on the information you 
> provided.  I tried to look up more information about the file structure, but 
> the guide  
> wasn't much help, and the wiki  appears to be 
> down.
> 
> IAC, I edited the price records for the two securities which had incorrect 
> price currencies, as well as all transactions which refenenced any of the 
> three securities accounts, changing the currencies from CHF to AUD.  This 
> appears to have fixed the problems, but I am keeping a couple of pre-edit 
> backups, as you recommend.
> 
> Am I the only one to encounter problems like this?
> 
> SInce the problem seems to have been with the (implicitly determined) 
> currencies of the prices and the transactions, would it be possible to add an 
> option to the price editor dialog for each price and to the exchange rate 
> editor for each transaction to change or select the currency?  From what I 
> have learned about the data structure, this looks like the easiest way to 
> provide a less dangerous way to fix such problems.


___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 choose a customer in 
Options.

Then in Options > Display you can choose to show the linked documents either in 
a simple, or detailed format. Play with both to see what works for you.

The dev working on this (and other beta reports) would much appreciate as many 
people using and testing it as possible and reporting any issues.

For some years now I have also been putting in my payment transaction 
notes/memos the bill# that is being paid by that transaction/split and if 
partial or final payment, indicate that as well.

Thus:

“for invoice #1234”
“1st partial for invoice #1234”
“2nd partial for invoice #1234”
“final for invoice #1234”

You could also repurpose the action field for applied invoice numbers, but memo 
is probably better unless you need that field for something else. (you have 
more space to see the number, for one)

Unfortunately, there is a bug still in the AR/AP registers that setting the 
text on a memo also changes the notes field to match, and setting the notes 
field changes the first memo to match, so keep that in mind.

Regards,
Adrien



> On Feb 10, 2020 w7d41, at 11:48 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> 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 showing Vendor's 
> Bill/Invoice number & date plus the Payment Check number and date...
> Is noting the vendors invoice/bill number in the Memo field the only way to 
> do it?
> We considered putting the vendors invoice/bill number in the Num field but 
> that field is for our check number...
> Am I missing something obvious? (Won't be the first time :-)
> Thanks for any help.

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 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 be at least partially mentioned in other threads here.  They do not
> specify if there are any changes in the database variations, but there
> probably are.
> 
> David Carlson

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect starting balance for 2019

[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 opening balance transaction 
in the register for that account. You can also do it from the 'Equity:Opening 
Balances' account. Opening transactions are just simple transactions between 
the account in question and ‘Equity:Opening Balances’.

Of course, this will alter your balances in that account for the entire history 
of the book, but that is what you want to do.

If some period had worked out correctly before the edit, that means you had an 
error in that period. (because the opening balance was wrong, the ending 
balance should be wrong also, if it wasn’t, that means another error was 
present.)

After the edit, start reconciling one period at a time and *then* print 
reports. (You printed reports for non-reconciled periods? How did you know the 
were correct?)

Regards,
Adrien

> On Feb 9, 2020 w7d40, at 11:05 PM, Richard Danielson  
> wrote:
> 
> 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 all my accounting 
> for the year.
> 
> Unfortunately, at this very late point in time, I discovered that I started 
> the year with an incorrect total on one of my asset accounts.  If possible, 
> would like to edit this starting amount for Jan 1/19 so that things work out 
> correctly afterward and all the way up to the end of the year.
> 
> Being suspicious of my actions I waited to reconcile any bank or credit card 
> accounts, so if it is possible to just change the starting balance on that 
> one account, I will happily re-print all of my monthly reports and reconcile 
> everything which should be reconciled before going into 2020.
> 
> All my life, I have followed the carpenter's rule - "There is always time to 
> do a job twiceif you screw up, you have to do it again."  Of course, 
> there is always at least one exception, for example - "If you cut a board too 
> short, then cut it again!"
> 
> Can someone tell me whether in this case, the rule holds or does the 
> exception hold?   Thanks.
> 
> Rick

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 showing Vendor's Bill/Invoice 
number & date plus the Payment Check number and date...
Is noting the vendors invoice/bill number in the Memo field the only way to do 
it?
We considered putting the vendors invoice/bill number in the Num field but that 
field is for our check number...
Am I missing something obvious? (Won't be the first time :-)
Thanks for any help.

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 be at least partially mentioned in other threads here.  They do not
specify if there are any changes in the database variations, but there
probably are.

David Carlson

On Sun, Feb 9, 2020 at 9:08 PM Wirawan Purwanto  wrote:

> Hi,
>
> I wonder if anyone has a pointer on the changes in Gnucash XML format
> that can cause incompatibility across program versions. I have a
> scenario where one OS uses Gnucash 2.6.x series whereas the other uses
> 3.5. I am concerned when transporting data file back and forth, if
> there is corruption due to incompatible file format.
>
> In my recent trial to migrate files back and forth between 2.6 and
> 3.5, I noted that data seems to be intact. But in the 2.6 series, the
> "cmdty:space" field has the value of "ISO4217" whereas in 3.5 it was
> "CURRENCY". But I noted that a very old GNUCash version (2.4.10)
> failed to read the dates correctly from the file that was saved by
> 3.5. All dates became "1969-12-31" when read in the 2.4 program.
> Because of this I am not quite sure what is safe to do or not safe.
> Would be nice if there is a prominent / easy-to-find web page which
> tells end-user like me regarding file version incompatibility.
>
> --
> Wirawan Purwanto
>
> ~ https://bfa.org ~
> "Get your own copy of a free study Bible"
> ___
> 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 you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 is no guarantee that a 3.x file will work in
2.x though in practice it may be ok.

Colin

>
> 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 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 be at least partially mentioned in other threads here.  They do not 
> > specify if there are any changes in the database variations, but there 
> > probably are.
> >
> > David Carlson
> >
> > On Sun, Feb 9, 2020 at 9:08 PM Wirawan Purwanto  wrote:
> >>
> >> Hi,
> >>
> >> I wonder if anyone has a pointer on the changes in Gnucash XML format
> >> that can cause incompatibility across program versions. I have a
> >> scenario where one OS uses Gnucash 2.6.x series whereas the other uses
> >> 3.5. I am concerned when transporting data file back and forth, if
> >> there is corruption due to incompatible file format.
> >>
> >> In my recent trial to migrate files back and forth between 2.6 and
> >> 3.5, I noted that data seems to be intact. But in the 2.6 series, the
> >> "cmdty:space" field has the value of "ISO4217" whereas in 3.5 it was
> >> "CURRENCY". But I noted that a very old GNUCash version (2.4.10)
> >> failed to read the dates correctly from the file that was saved by
> >> 3.5. All dates became "1969-12-31" when read in the 2.4 program.
> >> Because of this I am not quite sure what is safe to do or not safe.
> >> Would be nice if there is a prominent / easy-to-find web page which
> >> tells end-user like me regarding file version incompatibility.
> ___
> 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 you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect starting balance for 2019

[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 account statement from
the bank or is that what you are trying to correct for?  If you have
been successfully reconciling it against the bank statement then I
don't see how the initial balance can be off.

Colin

On Mon, 10 Feb 2020 at 15:16, Richard Danielson  wrote:
>
> 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
> all my accounting for the year.
>
> Unfortunately, at this very late point in time, I discovered that I
> started the year with an incorrect total on one of my asset accounts.
> If possible, would like to edit this starting amount for Jan 1/19 so
> that things work out correctly afterward and all the way up to the end
> of the year.
>
> Being suspicious of my actions I waited to reconcile any bank or credit
> card accounts, so if it is possible to just change the starting balance
> on that one account, I will happily re-print all of my monthly reports
> and reconcile everything which should be reconciled before going into 2020.
>
> All my life, I have followed the carpenter's rule - "There is always
> time to do a job twiceif you screw up, you have to do it again."  Of
> course, there is always at least one exception, for example - "If you
> cut a board too short, then cut it again!"
>
> Can someone tell me whether in this case, the rule holds or does the
> exception hold?   Thanks.
>
> Rick
>
> ___
> 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 you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 ovirt host rebooted last night around 10:45pm
local time and the script to start the VMs on reboot didn't work.  I've
spent the past 3 hours debugging and determined the problem with the
script was that the ovirt engine reports invalid state immediately upon
reboot.  Specifically, it reports that the storage domains are "up" even
when they are not.  It corrects itself shortly, but the startup script
sees the storage as "up" and then tries to start the VMs (which fail to
start).  This has been fixed by adding a short delay between when the
engine reports as "up" and when the script starts testing for the
storage domains.  I know this works because it ran from a clean restart
of the ovirt host system.

Still of concern is why the machine rebooted last night in the first
place.  I do not have an answer for that, and the logs don't really show
anything of substance.

I plan to continue to monitor the situation, and I will add some
additional debugging in case it decides to reboot itself yet again.
But at least if it does, we know the VMs will come back!  :)

Sorry for the downtime.

-derek

-- 
   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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 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 be at least partially mentioned in other threads here.  They do not 
> specify if there are any changes in the database variations, but there 
> probably are.
>
> David Carlson
>
> On Sun, Feb 9, 2020 at 9:08 PM Wirawan Purwanto  wrote:
>>
>> Hi,
>>
>> I wonder if anyone has a pointer on the changes in Gnucash XML format
>> that can cause incompatibility across program versions. I have a
>> scenario where one OS uses Gnucash 2.6.x series whereas the other uses
>> 3.5. I am concerned when transporting data file back and forth, if
>> there is corruption due to incompatible file format.
>>
>> In my recent trial to migrate files back and forth between 2.6 and
>> 3.5, I noted that data seems to be intact. But in the 2.6 series, the
>> "cmdty:space" field has the value of "ISO4217" whereas in 3.5 it was
>> "CURRENCY". But I noted that a very old GNUCash version (2.4.10)
>> failed to read the dates correctly from the file that was saved by
>> 3.5. All dates became "1969-12-31" when read in the 2.4 program.
>> Because of this I am not quite sure what is safe to do or not safe.
>> Would be nice if there is a prominent / easy-to-find web page which
>> tells end-user like me regarding file version incompatibility.
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Incorrect starting balance for 2019

[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 
all my accounting for the year.


Unfortunately, at this very late point in time, I discovered that I 
started the year with an incorrect total on one of my asset accounts.  
If possible, would like to edit this starting amount for Jan 1/19 so 
that things work out correctly afterward and all the way up to the end 
of the year.


Being suspicious of my actions I waited to reconcile any bank or credit 
card accounts, so if it is possible to just change the starting balance 
on that one account, I will happily re-print all of my monthly reports 
and reconcile everything which should be reconciled before going into 2020.


All my life, I have followed the carpenter's rule - "There is always 
time to do a job twiceif you screw up, you have to do it again."  Of 
course, there is always at least one exception, for example - "If you 
cut a board too short, then cut it again!"


Can someone tell me whether in this case, the rule holds or does the 
exception hold?   Thanks.


Rick

___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash XML format compatibility

[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 detailed
in the wiki at https://wiki.gnucash.org/wiki/Configuration_Locations but I
am not sure about any data file changes. I don't remember there being any. 
I think the transition was from ~2.6.21 as the last stable version of the
2.6 series to V3.1 and I have seen recommendations to upgrade to at least
2.6.19 before moving to the V3 series for minimum disruption. AFAIK once the
data has been migrated to V3 it is not usually possible to go back to the
v2.6 series but this may simply be the effect of the configuration file
locations and not necessarily any changes in the XML file itself. 

If possible it would be better to go to the same V3 version on both systems
at the same time. I access my datafiles which are located in a Dropbox from
both a Linux and Windows systems but upgrade both to the most recent version
at the same time. recent changes in Dropbox have affected the ability to do
this though.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Currency Screwed Up Again!

[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 foreign currency account), various expense 
accounts in AUD and an income account in AUD for interest.  The 
transactions between the foreign currency account and the expense 
accounts were recoreded in AUD as expected.  All other transactions were 
recorded with CHF exchange rates, although no currency conversions were 
called for.  The prices of two of the three securities were also 
recorded in CHF.  SInce the GC UI shows all accounts in AUD (except for 
the securities accounts, which IIRC, do not have a currency) it was 
unclear to me which account(s) I should duplicate.


@David,

My default currency is CHF; I live in Switzerland.  Trading accounts are 
turned on.  I have tried to fix this in the XML based on the information 
you provided.  I tried to look up more information about the file 
structure, but the guide 
 wasn't 
much help, and the wiki  appears to be down.


IAC, I edited the price records for the two securities which had 
incorrect price currencies, as well as all transactions which refenenced 
any of the three securities accounts, changing the currencies from CHF 
to AUD.  This appears to have fixed the problems, but I am keeping a 
couple of pre-edit backups, as you recommend.


Am I the only one to encounter problems like this?

SInce the problem seems to have been with the (implicitly determined) 
currencies of the prices and the transactions, would it be possible to 
add an option to the price editor dialog for each price and to the 
exchange rate editor for each transaction to change or select the 
currency?  From what I have learned about the data structure, this looks 
like the easiest way to provide a less dangerous way to fix such problems.



Date: Mon, 3 Feb 2020 10:31:58 -0600
From: Adrien Monteleone 
To: Gnucash Users 
Subject: Re: [GNC] Account Currency Screwed Up Again!
Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

Would creating a new duplicate account with the proper assigned currency, then 
deleting the old account and choosing to transfer all transactions to the new 
currency work?

That would be significantly easier than manual editing.

I?m not sure how the use of Trading Accounts affects this, or if it should or 
should not be turned on.


Regards,
Adrien


On Feb 3, 2020 w6d34, at 4:45 AM, David Cousens  
wrote:

Have you checked the default currency used Edit->Preferences, Accounts tab,
Default Currency. It is normally set to locale. I guess you are in Australia
so it should be AUD. If not, diid you possibly create the book originally
while overseas or the locale on your computer was not set to Australia.
AFAIK it is not possible to edit the currency of an account once it is
created in the Edit Account dialog only in the New Account dialog.

It should be possible to edit the file this but fraught with possible
problems.  Work on a copy of your original file and don't save it over the
original until you are really sure that the problem is fixed and other
problems haven't been created. I would keep a copy of the original even
after you reach this point just to be sure.

Your XML file will have to be uncompressed Edit ->Preferences General Tab
and uncheck the box which says compress files. You may then have to force a
Save. I did this by creating a dummy transaction in a register then hitting
the Save button in the toolbar, deleting the dummy transaction and clicking
Save again.

The section of the XMLfile which contains the commodity information for an
account is reproduced below for a SGD account I have.

  TravelMoney_CC_SGD
  *7db63ffa514d478191dea006748d7bd6*
  LIABILITY
  
CURRENCY
*SGD*
  

You will have to have the commodity you wish to change the account to
specified earlier in the file in a section like

  CURRENCY
  SGD
  
  currency
  


Each transaction to the account will have the commodity specified in a
 tag set. You would need to find all of these and change the
commodity similarly

  4ec8a9416b31469bb1eeaf79c5557092
  
CURRENCY
SGD
  
  
2019-03-17 10:59:00 +
  
  
2019-05-14 03:25:18 +
  
  XX 1897  BP-BOOKSACTUALLY
  

  date-posted
  
2019-03-17
  

  
  

  2bf944df822042849e1cbd5a2b6db3c8
  n
  6100/100
  6654/100
  7be97b5f738386fd2272881dc33a0272


  4ef42d767cc748f79ce09d6d8f2d3043
  y
  
2019-05-14 13:59:59 +
  
  -6100/100
  -6100/100
  *7db63ffa514d478191dea006748d7bd6*

  


Make sure the guid for the account matches up (bolded in the above examples)
in the