There are a number of fields which are “descriptive” in one way or another,
such that editing these fields outside Gnucash poses to risk to the integrity
of the data. The developers know best which fields these are. A number of users
have developed external means of editing databases (and I
Reboot finished and everything should be back to normal.
Please let me know if you notice any issues.
Thanks!
-derek
On Sun, December 6, 2020 9:15 pm, Derek Atkins wrote:
> TL;DR: Unless I hear major objections, I plan to reboot the VM server
> tomorrow, Monday, Dec 7, around 8pm US/EST (0100
Of course, one can edit the data using SQL (for a file stored in one of the
database formats) or even a text editor (for an uncompressed XML file). Many do
so. But bear in mind that any edits made outside the Gnucash API may affect
the reliability of your data set, or even corrupt the data.
Writing to the db is considered risky at this time. (and not supported)
Reading is fine though.
Regards,
Adrien
On 12/7/20 5:21 PM, flywire wrote:
* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*
*Seems reasonable.*
>* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*
*Seems reasonable.*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Harold,
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
-- Forwarded message -
From: Harold
Date: Mon, Dec 7, 2020 at 4:10 PM
Subject: Re: [GNC] gnucash fonts
To: David Carlson
David,
I dropped my resolution down one
Before installing 4.2, I tested with the sample file. It threw the
errors as ya'll have indicated.
I re-assigned all of the higher level asset transactions to Level 7, and
while it still threw the error, it only did so for one iteration with
option '6' and did not throw it for option 'All'.
Yes, I agree that the exchange rate has to be input. Whether you fetch the rate
(also permitted by HMRC as I understand it) or input the rate manually it still
has to be confirmed for each invoice when posting in Gnucash.
Christopher Lam wrote
>But it's crucial to input the exchange
But it's crucial to input the exchange rate - and IIUC you are encouraged
to use
https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly
On Mon, 7 Dec 2020 at 22:47, Samantha Payn
wrote:
>
> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into
>
No, but I am still on 4.1, about to jump to 4.2 and see if that makes a
difference. (I normally have no reason for waiting, I've just been busy)
Regards,
Adrien
On 12/7/20 4:40 PM, David H wrote:
So you're not seeing this message at all ???
I'm using the bog standard download versions on
Thanks for the suggestion, Adrien. I’ve got entering the invoice data into
Gnucash down to a fine art (especially with the recent “predictive text” input
in my “product” fields! Thanks again for that, whoever it was!). It is
specifically the step to confirm the exchange rate when posting an
So you're not seeing this message at all ???
I'm using the bog standard download versions on MacOS Big Sur and Win 10
Pro and the flatpak version on Ubuntu 20.10 and see the error in all of
them with David T's test file
Cheers David H.
On Tue, 8 Dec 2020 at 08:21, Adrien Monteleone <
I saw it a few months ago. People still ask. One new (at the time)
volunteer offered to code it. I think it didn't get very far at the time
due to complexity. (and other 'fish to fry' in the code, so to speak)
Regards,
Adrien
On 12/7/20 4:00 PM, Weiwu Zhang wrote:
This issue comes up
Samantha, you can import invoice data.
Thus, if you have a way to easily create that data in a spreadsheet, you
can save it as CSV, then import them to GnuCash.
See the Help/Guide about importing business data for the required columns.
I'm not certain if it works well with a foreign currency
Not on Mac. I use the standard bundle. I've built on Ubuntu in the past
for testing but haven't done so in some time.
Regards,
Adrien
On 12/7/20 3:11 PM, David H wrote:
And also using the Flatpak version 4.2 on Ubuntu. I'm guessing Adrien
compiles his own version - maybe that's why he
I’d find a “batch post invoice” function enormously helpful. I have a foreign
currency client who insists on a separate invoice for each (sometimes
inconsequential) amount and the multiple clicks to post the invoice and confirm
the exchange rate for each one are time consuming.
Currently the
This issue comes up regularly with new users. The short answer to the
question is, "no, there is not a bulk edit."
Instead of discouraging people to ask this because it's already discussed
and some suggestions are already archived, I feel starting the
conversation again is the only way to
And also using the Flatpak version 4.2 on Ubuntu. I'm guessing Adrien
compiles his own version - maybe that's why he doesn't see the error, I
always download the compiled version and install it ???
Cheers David H.
On Tue, 8 Dec 2020 at 06:43, David H wrote:
> Ha ha - same result on MacOS Big
I did wonder about that sig :-) Initially I got a "no txns" error from the
report options, had to change the report currency to US$ - I don't normally
bother with running reports, never had much use for them even with all the
accounts I've got. It would seem to suggest that perhaps a different
Thank you. Yes. At least now I know that it's not just my personal
electromagnetic signature causing the problem.
As for the levels on display, if you've followed the thread (and even my
eyes glaze over reading through it), you will know that I am quite
puzzled about this error.
David T.
Odd.
I don't think it has to do with the account type, since I replicated the
problem for both assets and liabilities accounts.
I don't believe my accounts have something in them that could generate
this error. I've been able to create a brand new file with an account
structure and just a
I created several level-7 and level-8 asset accounts and put a
transaction in one at level-8.
I then tried both the Bar & Pie charts, both using '6' and 'All' options
and all executed properly without errors.
Perhaps something is amiss with one (or more) your accounts at that depth?
Maybe
That is quite interesting.
As noted, I don't have any >6 level Asset (or Liability) accounts. But I
do have level-7 Expense accounts. I tried the Expense Chart & Expense
Pie Charts, and both execute without errors for both All and '6'
options. (and yes, those level-7 accounts have many
Further to this: you asked whether the problem occurs with level All.
Interestingly, this option does result in the error occurring again.
However, when All is selected, the default report triggers the error with a
different option number and a different number of iterations. This time, the
fixed it, thanks.
that explains my question re dropbox usage.
--
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
25 matches
Mail list logo
