[GNC] Vendor report beta errors

2020-07-07 Thread Finfort
Debit and Credit totals are wrong - when filtering by period of time it shows these totals for all the period. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Tax tables changing

2020-06-21 Thread Finfort
I say yes, reset the tax tables and I choose the tax table with new name but it shows me the same old tax table name. Is it correct??? > > On Jun 21, 2020 at 20:13, (mailto:adrien.montele...@lusfiber.net)> wrote: > > > > The current terminology is:

Re: [GNC] Fwd: Wrong running balances in reports

2020-05-28 Thread Finfort
> > Your example had two transactions for the same day.If they are not sorted > in the default sort order, the end-of-day running balance is not the last > balance displayed. > > > > On Thu, May 28, 2020 at 1:16 AM Finfo

[GNC] Fwd: Wrong running balances in reports

2020-05-28 Thread Finfort
Begin forwarded message: > > From: Finfort mailto:finf...@gmail.com)> > Date: May 28, 2020 at 09:13 > To: David Carlson (mailto:david.carlson@gmail.com)> > Subject: Re: [GNC] Wrong runnin

Re: [GNC] Wrong running balances in reports

2020-05-27 Thread Finfort
But this is wrong and should be recalculated when changing sort order, isn't it? > > On May 27, 2020 at 17:39, mailto:de...@ihtfp.com)> wrote: > > > > Hi, "finf...@gmail.com"writes: > Appears in reports > when you sorting by date and you have

Re: [GNC] XML vs SQL data integrity question

2020-05-07 Thread Finfort
I use Ubuntu with Postgresql, saving sometimes to XML. Had a lot of troubles in Windows with XML. > > On May 7, 2020 at 19:21, mailto:rollenwi...@fastmail.net)> > wrote: > > > > Sounds like you have a couple of issues happening there. I have no > experience

Re: [GNC] Working with dates in Postgresql DB

2020-05-01 Thread Finfort
;D."Cc: finf...@gmail.com, "D. via gnucash-user"Subject: Re: [GNC] Working with dates in Postgresql DB David, You're not thinking it through: It's about 11:00 on Friday 1 May here in California but it's 03:00 on Saturday 2 May in Western Australia. Chopping off the time does

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread Finfort
d be always, since you're in a time zone east of the prime meridian. So you also want to increment the day on those. I think it would be safest to do it in two queries, the first one being > >> > >> update transactions post_date = post_date + interval '1 day' where post_date::TIME != '10:59:00

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread Finfort
e prime meridian. So you also want to > increment the day on those. I think it would be safest to do it in two > queries, the first one being >> >> update transactions post_date = > post_date + interval '1 day' where post_date::TIME != '10:59:00'; >> >>

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread Finfort
connected to the database when you run that. Regards, John Ralls > On Apr > 30, 2020, at 10:45 AM, Finfortwrote: > > How can I > help? > > I can send you my gnucash file if it helps to find all the > bugs. > > And how can I change now my wrong

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread Finfort
a bug. I easily found the wrong code and I'll fix it > for 3.903 and 3.11. The query actually accounts for only 543 of the 547 wrong > times, so there's another error somewhere else. Regards, John Ralls > On > Apr 30, 2020, at 10:27 AM, Finfortwrote: > > Also > I

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread Finfort
gt; t.post_date::TIME count(t.post_date::TIME) from transactions as t inner join > invoices as i on i.post_txn = t.guid group by t.post_date::TIME; > > > Regards, > John Ralls > > >> On Apr 29, 2020, at 1:41 PM, Finfort > wrote: >> >>

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread Finfort
the source of the problem. Run this query: > > select > t.post_date::TIME count(t.post_date::TIME) from transactions as t inner join > invoices as i on i.post_txn = t.guid group by t.post_date::TIME; > > > Regards, > John Ralls > > >> On Apr 29,

Re: [GNC] Change account type by editing XML?

2020-04-29 Thread Finfort
It is a good idea to automatically split (in settings options) all the accounts receivable and accounts payable by customers and vendors having separate accounts for the reports usable by the owner and auditors! > > On Apr 29, 2020 at 21:28,

Re: [GNC] Working with dates in Postgresql DB

2020-04-29 Thread Finfort
Hi John! You are here finally! Waiting for you all the day :) All my data I have entered inside Gnucash 3.7,Ubuntu. No imports! Scheduled are ok! Just simple invoices inside the program! The SQL type conversions inside Postgres give better results with 22:00 but 21:00

Re: [GNC] cMakeError.log errors - building Gnucash 3.10

2020-04-12 Thread Finfort
Ofx lib is installed by instructions, anyway... > > On Apr 12, 2020 at 19:40, mailto:jra...@ceridwen.us)> wrote: > > > > > On Apr 12, 2020, at 4:25 AM, finf...@gmail.com wrote: > > I have > these errors in cMakeError.log after cmake: > > Can

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Finfort
unch a > flatpak app from the command line'. Sorry, I don’t use them so I don’t know > the syntax right-off. Regards, Adrien > On Apr 7, 2020 w15d98, at 1:26 PM, > Finfortwrote: > > Thank you, but what is the > command to start it? > Just "gnucash" d

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Finfort
start it from the command line > and see if there is any output that lends some clues. Regards, Adrien > On > Apr 7, 2020 w15d98, at 6:28 AM, Finfortwrote: > > > > > > Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, > 19.10 when s

[GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Finfort
Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 when starting. After that shows it’s logo,boots and works normally. Sometimes it freezes all the system when starting and all you can do is only cold restart. Does anybody have the same problem?