Re: [GNC] Problem Editing Payment - Customer Job

2022-08-08 Thread Keith Fetterman
Hi Adrien, Thanks for the feedback. I downloaded the latest version of GnuCash 4.11, and the issue still exists. When I edit an existing payment, the job name appears where the customer name should appear in the payment dialog. If you try to remove the job name, you can’t enter or find the cust

Re: [GNC] How to Return a GDate?

2022-08-08 Thread Robert Simmons
> GDates are provided by GLib Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all y

Re: [GNC] How to Return a GDate?

2022-08-08 Thread John Ralls
GDates are provided by GLib, and its python bindings are provided by PyGobjectIntrospection. The Debian package is https://packages.debian.org/buster/gobject-introspection. The documentation is at https://pygobject.readthedocs.io/en/latest/. Regards, John Ralls > On Aug 8, 2022, at 3:50 PM, R

Re: [GNC] gnucash-user Digest, Vol 233, Issue 27

2022-08-08 Thread Glenn Fowler
I'm assuming you saw the software license for GnuCash which is licensed under the GNU GPL license. A lot of software licenses are designed to restrict your freedom with what you can do with the software. GNU promotes software freedom so you are free to run the program how you wish, free to distribu

[GNC] License (was Re: gnucash-user Digest, Vol 233, Issue 27)

2022-08-08 Thread Derek Atkins
Hi, On Mon, August 8, 2022 8:06 pm, David Carlson wrote: > You need a license to go fishing, a different license to drive a car. We > don't know what you are reading. > > On Mon, Aug 8, 2022, 7:01 PM James Baxter via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> I am reading something a

Re: [GNC] gnucash-user Digest, Vol 233, Issue 27

2022-08-08 Thread David Carlson
You need a license to go fishing, a different license to drive a car. We don't know what you are reading. On Mon, Aug 8, 2022, 7:01 PM James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > I am reading something about a license. I read most of it. As I don't > understand it. What i

Re: [GNC] gnucash-user Digest, Vol 233, Issue 27

2022-08-08 Thread James Baxter via gnucash-user
I am reading something about a license. I read most of it. As I don't understand it. What is it all about. ThanksJames Baxter kangaro...@yahoo.com  Sent from Yahoo Mail on Android On Mon, Aug 8, 2022 at 6:54 PM, gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submi

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread john
There's no hidden feature in GnuCash. SQL: select count(*) from transactions; and select count(*) from splits; grep an uncompressed XML file: grep -c '' path/to/file.gnucash; use '' to count the splits. You can also look at the top of your XML file between the book slots and the commodities t

[GNC] How to Return a GDate?

2022-08-08 Thread Robert Simmons
Following the documentation: https://code.gnucash.org/docs/MAINT/gncEntry_8h.html When creating an Entry (for a Bill or Invoice), the date is to be set using a GDate: "DEPRECATED - use gncEntrySetDateGDate() instead!" I see a number of functions that return an existing GDate, so something like th

[GNC] Incrementing Counters Saga Continues

2022-08-08 Thread Robert Simmons
In the theme of "the code is the documentation" I've found a method that is almost what I need to increment a counter, but it doesn't look fully implemented. >From the site-packages directory of the Python bindings directory, running a grep for "increment" shows one line that is interesting. gnuc

Re: [GNC] gnucash-user Digest, Vol 233, Issue 22

2022-08-08 Thread davidcousens49
James, If you are not seeing the transactions you have already entered and the accounts in the account tab it is possible that you have not saved the datafile. To do this use the File-Save As menu item immediately after starting GnuCash up. It will then automatically open the same file next tim

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread R. Victor Klassen
Just out of curiosity, how does one determine those numbers? An SQL query? grep | wc on the xml? Some feature of gnuCash I’ve never discovered? > On Aug 8, 2022, at 3:54 PM, Derek Atkins wrote: > > > On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote: >>> Accounting systems primarily

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Derek Atkins
On Mon, August 8, 2022 4:33 pm, Robert Simmons wrote: > That makes sense. So, performance would not be an argument for SQL and > against a graph database. Nor would it be an argument for graph and against SQL. But transactional data is so structured that SQL really does make sense. > Please re

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
That makes sense. So, performance would not be an argument for SQL and against a graph database. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/g

Re: [GNC] Request for two new features in GnuCash

2022-08-08 Thread Adrien Monteleone
That's just another workaround though. It creates multiple transactions when in the real world, there was only one event. The Process Payment feature doesn't really 'support' the desired function, but can still be used to accomplish the the task. I'm personally comfortable using the 'assign p

Re: [GNC] Request for two new features in GnuCash

2022-08-08 Thread R. Victor Klassen
Actually you can edit the suggested payment amount, and only “process” a partial payment. Then you can pay again, using Process Payment, and pay with a different account for the second payment. > On Aug 8, 2022, at 11:40 AM, Adrien Monteleone > wrote: > > I agree, this is already possible, b

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Derek Atkins
On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote: >> Accounting systems primarily perform the same operation on large numbers > of data elements. > > I wish I had time to devote to this. I use graph databases in many of the > other systems that I develop. This would be a great pivot point on

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
> Accounting systems primarily perform the same operation on large numbers of data elements. I wish I had time to devote to this. I use graph databases in many of the other systems that I develop. This would be a great pivot point on which to create a new open source project and see which paradigm

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
> we should consider changing the license to GPL-Affero to preclude someone using GnuCash in a non-Free software-as-a-service scheme That is a consideration. When I hit the point of needing to write quite a lot of code to get GnuCash to do exactly what I want, I looked into other projects. I took

Re: [GNC] gnucash-user Digest, Vol 233, Issue 22

2022-08-08 Thread James Baxter via gnucash-user
David.Thanks for the email. I am not shore about data file. I did get a transfee going. But I should know next month if it works. ThanksJames Baxter kangaro...@yahoo.com  Sent from Yahoo Mail on Android On Mon, Aug 8, 2022 at 2:16 PM, David Carlson wrote: James,Have you been able to creat

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread John Ralls
> On Aug 8, 2022, at 11:04 AM, Robert Simmons wrote: > > Another observation: the current GnuCash mixes data and display layers. > > For a new system, I would suggest separating everything completely. Have a > database and lib layer that interacts with the database. Then expose the > lib to C

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread John Ralls
> On Aug 8, 2022, at 10:53 AM, Robert Simmons wrote: > > Understood. > > After looking under the hood a good bit as well as thinking about the > problems of accounting and databases in general I have a side question: > > If you're working on a rewrite of some kind, why not use a graph databa

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Fred Bone
On 08 August 2022 at 10:30, Adrien Monteleone said: > Kalpesh, > > Thanks for the links. I have a need for a PDF to CSV solution for other > software and this looks like it is a good fit for me. (folks may be > shocked how many large businesses in 2022 can't generate decent business > documents/d

Re: [GNC] gnucash-user Digest, Vol 233, Issue 22

2022-08-08 Thread David Carlson
James, Have you been able to create a test data file and enter a few transactions modelled on the information in the help manual? On Mon, Aug 8, 2022 at 10:01 AM Fred Bone wrote: > On 08 August 2022 at 13:54, James Baxter said: > > > I am looking for something that I may have already. I have ha

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
Another observation: the current GnuCash mixes data and display layers. For a new system, I would suggest separating everything completely. Have a database and lib layer that interacts with the database. Then expose the lib to C, Python, C++, Rust, Go, whatever. You can then have a REST layer buil

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
Understood. After looking under the hood a good bit as well as thinking about the problems of accounting and databases in general I have a side question: If you're working on a rewrite of some kind, why not use a graph database as the back end rather than SQL? The reason is that a graph database

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Derek Atkins
On Mon, August 8, 2022 1:44 pm, john wrote: > The intended end-user process is to use the program, not the bindings. > > As to why the job-creating functions don't increment the counters, I think > because the design allows the user to override the counter-based ids in > the GUI. Derek wrote the

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread john
The intended end-user process is to use the program, not the bindings. As to why the job-creating functions don't increment the counters, I think because the design allows the user to override the counter-based ids in the GUI. Derek wrote the code so he's the authority on the why's and wherefore

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Glenn Fowler
I couldn't agree more. I took all of my automations and scripts and roughly calculated that I am saving at least a week every year in time. That's a free week of vacation! Now multiply that every single year and with the scripts and automations continually being added it has a compound effect. Al

Re: [GNC] Request for two new features in GnuCash

2022-08-08 Thread Adrien Monteleone
Eric, you didn't specify your OS. To clarify other replies: If you are on Mac, you can't open your data file by clicking on it. But you can create a simple Automator Workflow or AppleScript (or other script) to create a shortcut for each book. (or use the Terminal) That would be useful if you

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Adrien Monteleone
Here's a use case: Vendor invoices containing 10+ line items that need to be entered into both an accounting package and an inventory/POS system. Multiply that case by a dozen or more a week. And compound it by said 'PDF' invoice being a *scan*. (which of course means really good OCR needs t

Re: [GNC] Request for two new features in GnuCash

2022-08-08 Thread Adrien Monteleone
I agree, this is already possible, but *not* using the 'Process Payment' feature as it is currently implemented. (that is, if one is paying on a Vendor invoice.) To accomplish this, you have to enter the payment with multiple source splits as Frank and others have noted, and AP as the debit sp

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Adrien Monteleone
Kalpesh, Thanks for the links. I have a need for a PDF to CSV solution for other software and this looks like it is a good fit for me. (folks may be shocked how many large businesses in 2022 can't generate decent business documents/data in a proper electronic format for using in various softwa

Re: [GNC] Build From Source Near Impossible

2022-08-08 Thread Adrien Monteleone
Ditto concerning Ubuntu versions. In my experience so far building on older versions of Ubuntu, you can stumble into a nasty nearly un-resolvable dependency hell. It *can* be resolved (best I have figured out so far) by pinning lots of packages, but that may not always be the best solution for

Re: [GNC] Problem Editing Payment - Customer Job

2022-08-08 Thread Adrien Monteleone
After you re-create the payment, does it show as 'owned by' the Customer or the Job? (as before) I'm going to hazard a guess this is due to the following: In order to match payments, each payment and invoice need a common 'owner'. There can be only one 'owner' of a document. (payment, invoice,

Re: [GNC] gnucash-user Digest, Vol 233, Issue 22

2022-08-08 Thread Fred Bone
On 08 August 2022 at 13:54, James Baxter said: > I am looking for something that I may have already. I have had Linux Mint > loaded on this laptop for about a month. also have been playing with > Gnucash about 3 weeks. still getting us to this, As I find it very nice > program. > As i dont kno

Re: [GNC] Problem Editing Payment - Customer Job

2022-08-08 Thread Adrien Monteleone
Keith, sorry I don't use the Jobs feature so can't comment specifically. Is there something holding you back from v4.11? 4.5 is over 2 years old and there are 5 regular releases since then. (and 1 snap release, so only small changes for that one.) Maybe do a search on the release notes for v

Re: [GNC] gnucash-user Digest, Vol 233, Issue 22

2022-08-08 Thread James Baxter via gnucash-user
I am looking for something that I may have already. I have had Linux Mint loaded on this laptop for about a month. also have been playing with Gnucash about 3 weeks. still getting us to this, As I find it very nice program. As i dont know if I have a problem with the two of them, I don't know. S

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
> unless your script is going to create jobs and immediately exit Yes. I see no other way to do this other than directly changing the database. There is nothing in the Python bindings that can do it. I'm keeping a count "job_num" that I'm using with "str(job_num).zfill(6)" to make it look correct

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

2022-08-08 Thread Robert Simmons
If these functions are not public, why don't the proper functions for creating Jobs and other objects increment the counters? If I'm understanding correctly, Python bindings provide no way to increment counters (since exposing some of those incrementX functions were mistakenly not in the private h