Hello all,
I am new to GNUcash - spent many hours getting to grips with the new
system (came from Quick Books) and finally got my small business
accounts set up and working reasonably well.
However, I operate two trading names of the same business and need to be
able to invoice the two types
This seems to do the trick. Not sure if I'm doing something terrible here.
I don't recommend you do this unless you know what you're doing (I don't
lol).
https://gist.github.com/utkonos/1dad74716828c591c9839711fdb12f22
import pathlib
import sqlite3
bills = [{'id': '01',
'date_opened': '12/
I've run this after an import of 19 bills. The "Business Linked Documents"
function in the UI is able to successfully run the "Reload and Locate
Linked Documents" for all linked documents including the ones created using
the kludge. Navigating to each individual bill and clicking on the document
li
You are definitely doing something terrible.
You are modifying the database from under GnuCash.
That is completely not supported and you may destroy your data.
-derek
Sent using my mobile device. Please excuse any typos.
On July 25, 2022 7:42:04 AM Robert Simmons wrote:
This seems to do the tri
Hello,
I'm seeking advice from the group about the best way to handle a ticker/name
change for a held stock.
For example, Facebook renamed itself Meta a while back, and in June they
changed their ticker from FB to META. Naturally, I wish the Gnucash books to
reflect these changes; I also wan
I definitely wouldn't expect this to be supported. I did take a look at
PieCash and see how it handles working with the "slots" table. There
doesn't appear to be any other housekeeping that is done other than the
INSERT commands. As long as the INSERTS are properly formed and I'm not
doing this wit
> On Jul 25, 2022, at 3:42 AM, peter wrote:
>
> Hello all,
>
> I am new to GNUcash - spent many hours getting to grips with the new system
> (came from Quick Books) and finally got my small business accounts set up and
> working reasonably well.
>
> However, I operate two trading names of
> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user
> wrote:
>
> Hello,
>
> I'm seeking advice from the group about the best way to handle a ticker/name
> change for a held stock.
>
> For example, Facebook renamed itself Meta a while back, and in June they
> changed their ticker fr
To me, the former name and the date of the change are important. It is
easy to add a dummy transaction in the register to record those pieces of
information plus whatever other details might be important. Then editing
the stock names and tickers allow price downloads to resume.
However, someti
Piecash isn't supported either, because it also doesn't use the GnuCash API to
write to the database.
The supported way--that works with either the XML or SQL backend--is to use the
Guile or Python bindings to the GnuCash libraries. You can also write your
program in any compiled language that
Thank you all for valuable input on this.
Version 4.10 appears to have resolved the issue, I can now enter invoices,
bills and payments with the needed accounts.
Victor, I don't know how my entries were different from yours. Now it works for
me too. Thanks
Eric
Victor: I w
Date: Thu, 14 Jul 2
Are there tutorial examples / videos for using Python and/or Sqlite3 to work
with GnuCash.
I have never used Sqlite, and my Python experience is mostly industrial, and
outdated.
(Like, what are bindings?)
Thanks for any and all help
Eric
*
___
Thanks John. I appreciate it.
On July 25, 2022 6:58:12 PM GMT+03:00, john wrote:
>
>
>> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user
>> wrote:
>>
>> Hello,
>>
>> I'm seeking advice from the group about the best way to handle a ticker/name
>> change for a held stock.
>>
>> For e
Thanks for your perspective on this. With my recent experiences with lots, I
think I'll keep this simple.
On July 25, 2022 7:01:41 PM GMT+03:00, David Carlson
wrote:
>To me, the former name and the date of the change are important. It is
>easy to add a dummy transaction in the register to re
> On Jul 25, 2022, at 9:30 AM, Eric Hammond wrote:
>
> Are there tutorial examples / videos for using Python and/or Sqlite3 to work
> with GnuCash.
> I have never used Sqlite, and my Python experience is mostly industrial, and
> outdated.
> (Like, what are bindings?)
Google found no GnuCash
* The account is your bank account and the transfer account is the
other account.
Thanks, this helped a lot!
* Options, when you mess up importing many transactions, don't save
the file or delete them and import again.
I don't see how can I bulk delete transactions.
On 7/25/22 00:01, flywire
Hey Phyllis, thanks for the advice!
Sadly my bank only offers my transaction history in CSV and HTML format...
I'll definitely make backups before I do any work and minimize how often
I import transactions.
Too bad there isn't an undo button in GnuCash, yet. :)
On 7/25/22 00:28, Phyllis Bruce w
TLDR: GnuCash Windows version is compiled on linux so, considering the
note below, you are unlikely to get python bindings working in
Windows.
> Important
> The Python extensions are an optional feature which creates additional
> dependencies. To be
> able to use Python scripts, GnuCash must ha
18 matches
Mail list logo
