[GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-03-23 Thread Jonathan Francoeur
I have my accounts in dropbox and I was using a newer version of GNU 
cash on my 64bit computer.  Now I"m trying to use the files on my older 
32bit computer and I get the error:



This Dataset contains features not supported by this version of GnuCash. 
You must use a newer version of GnuCash in order to support the 
following features:
* Use account GUID as key for bayesian data and store KVP flat (requires 
at least Gnucash 2.6.19)



I have not been able to install the Gnucash 2.6.19 from the tar.gz 
files.  I'm used to using .deb files on following instructions by copy 
pasting in to the terminal.  I haven't found anything like that for 
installing a newer version on GNU cash on a 32bit linux machine.  Any ideas?


___
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] How to apply overpayment to new invoice?

2022-03-23 Thread Eric H. Bowen via gnucash-user
I was late with my property taxes this year and incurred a penalty. I 
had earlier entered the billed amount as an invoice payable to the tax 
collector. I finally got the funds together to pay the amount, including 
penalty, in full. I entered it as one payment transaction, of course, 
since it was one e-check, and now it's showing up in my "Accounts 
Payable" as two transactions, one for the remaining billed amount (I had 
made partial payments earlier), and a separate transaction for $136.63 
representing the penalty and interest which appears as an unassigned 
pre-payment.


OK so far. Well, now that I know the total penalty I entered another 
invoice for that amount. Fine. Now I want to pay the invoice with the 
pre-payment. I go to the payment screen and the pre-payment shows up 
there. But I can find no way to apply it to the new invoice. How do I 
close this [expletive!] out?


___
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] How to apply overpayment to new invoice?

2022-03-23 Thread Christopher Lam
Find the prepayment in the AP or bank register, right click, edit payment,
and use it to clear the later invoice.

On Wed, 23 Mar 2022, 6:45 pm Eric H. Bowen via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> I was late with my property taxes this year and incurred a penalty. I
> had earlier entered the billed amount as an invoice payable to the tax
> collector. I finally got the funds together to pay the amount, including
> penalty, in full. I entered it as one payment transaction, of course,
> since it was one e-check, and now it's showing up in my "Accounts
> Payable" as two transactions, one for the remaining billed amount (I had
> made partial payments earlier), and a separate transaction for $136.63
> representing the penalty and interest which appears as an unassigned
> pre-payment.
>
> OK so far. Well, now that I know the total penalty I entered another
> invoice for that amount. Fine. Now I want to pay the invoice with the
> pre-payment. I go to the payment screen and the pre-payment shows up
> there. But I can find no way to apply it to the new invoice. How do I
> close this [expletive!] out?
>
> ___
> 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] [GNC-dev] [MAINT] Planned network outage March 23, 7pm EDT (2300 UTC)

2022-03-23 Thread Derek Atkins
Hi,

Just a reminder that this is happening today.  The email from my ISP:

> A reminder about this. We’re arriving at 6pm and will likely start
> little earlier than 7pm.
>
> I will send an email out when we complete the router swap, and
> we’ll be monitoring slack for any issues.
>
> You can reach me via sms at xxx if there  are issues.
>
> After the Router swap is done, we will be replacing PDUs
> (one at a time), so please expect one side of your server’s
> power feed to drop during this work.

I expect there to be an outage when the router is down, but it should all
come back once the new router is online.  I will attempt to monitor the
situation as I can (I'm on the road today and expect to not be near my
laptop at 7pm EDT) but will let you all know updates when I get them.

Thanks,

-derek

On Wed, March 9, 2022 2:35 pm, Derek Atkins wrote:
> Hi,
>
> I just got word from my ISP that they are planning a router swap on March
> 23 at 7pm US/EDT.  They expect the outage to last up to an hour while they
> swap out the old router and install the new one (and update the PDUs in
> the process).
>
> During that time, code.gnucash.org will be inaccessible, which means git
> commits, email, wiki, IRC logs, etc will all be unavailable.
>
> Once the new router comes online I expect everything to return to normal
> quickly.
>
> Please let me know if there are any questions.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
   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] Report - Income Statement - Layout problem

2022-03-23 Thread Carl-Kensaku HERBORT

Hello,

Thanks to everyone for your help and time.

It is a shame that it is so complicated to make the Income Statement 
report look normal, like the Balance Sheet report, which also has two 
sections (Assets and Liabilities) that have no problem at all.


I already have to use two separate software: an ERP/CRM for invoicing 
and daily accounting and GnuCash for heavier monthly/yearly accounting, 
mainly to produce the Income Statement Report and Balance Sheet report 
(or so was my plan). I didn't know that GnuCash was not made for that 
and that a third software (or SCHEME/HTML coding & modifications) was 
needed just to get even basic reports that all SME business need.


I guess there is a first for everything: I am giving up.

Again, thanks a lot to everyone who took on their free time to answer my 
questions.


Have a nice day

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 22.03.22 à 05:24, Adrien Monteleone a écrit :

I stand corrected, this can happen regardless of the depth preference.

The issue is entirely caused (best I can tell) by using separate tables 
for the Income & Expense sections.


Since the browser will adjust the label column to fit the content, if 
those content widths differ, you'll see misalignment.


In my case, due to some long account names, my Income section was 
slightly wider than the Expense section despite being depth limited to 
4. (the reverse of the OP's image and what I found at depth > 4)


The quickest solution is simply to put the Income & Expense sections in 
one HTML table element. This will cause the browser to size all 1st  
elements on each row to the same maximum to fit the widest content. 
(effectively sizing the first column all the same)


There might be a complication with the ordering since there is a report 
option to turn off 'default Income section first' in the report.


One small additional issue, is that this approach provides no spacing 
between sections.


This can be solved by adding:


     
      
     


after the first section's total row. (this generates a blank table row 
with content height as a visual spacer, which can be adjusted with a 
font-size declaration if desired.)


I don't like that approach, but it is quick and easy. (the report HTML 
is full of presentation hacks, and one such hack, possibly causing this 
problem, is the use of   being inserted as an account label 
indention mechanism rather than generating additional columns.)


I'm not sure of the table semantics with this approach either.

Technically, the report is a single entity, so perhaps a single table is 
better in that regard even though each section has its own subtotal.


I did play with adding cell padding-right to the first label-cell and it 
worked, but that requires some calculation based on which column will 
end up wider, and very likely a magic number or two for refinement, so 
that's likely out as a solution.


It might also be possible to calculate and add em-based padding-left to 
the account label cells, (rather than multiple   entities) but that 
doesn't really solve the variable overall column-width problem. (it just 
changes how the indention is accomplished)


Fixed-width would very likely be a mess too. (and still have to be 
calculated, and that might break on a per-browser basis)


There might still be an out playing with box-sizing and/or display 
properties but I don't really see any magic happening since the widths 
are calculated independently.


One final stretch might be to play with the size of the containers of 
the two tables, but I seriously doubt it as that affects overflow 
usually, not expanding something smaller.


Regards,
Adrien

On 3/21/22 9:47 PM, Adrien Monteleone wrote:

For me, this only happens at depths 5,6, & 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.

___
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] Report - Income Statement - Layout problem

2022-03-23 Thread Christopher Lam
Please be aware that GnuCash is a volunteer effort. In so many (20+) years
of users there have been no complaints about this particular layout issue
in the Income Statement. A fresh pair of eyes, however, found this genuine
layout issue. The Multicolumn Income Statement report in the Experimental
menu may be more suitable; it is much more capable and has a more
conventional layout.

Meanwhile, now that this is now known, and Adrien has kindly found the root
cause, it is likely that the developers will be able to fix the Income
Statement.

On Wed, 23 Mar 2022 at 13:49, Carl-Kensaku HERBORT  wrote:

> Hello,
>
> Thanks to everyone for your help and time.
>
> It is a shame that it is so complicated to make the Income Statement
> report look normal, like the Balance Sheet report, which also has two
> sections (Assets and Liabilities) that have no problem at all.
>
> I already have to use two separate software: an ERP/CRM for invoicing
> and daily accounting and GnuCash for heavier monthly/yearly accounting,
> mainly to produce the Income Statement Report and Balance Sheet report
> (or so was my plan). I didn't know that GnuCash was not made for that
> and that a third software (or SCHEME/HTML coding & modifications) was
> needed just to get even basic reports that all SME business need.
>
> I guess there is a first for everything: I am giving up.
>
> Again, thanks a lot to everyone who took on their free time to answer my
> questions.
>
> Have a nice day
>
> Best regards
>
> --
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
>
> +41 (0) 21 320 22 66
>
> Le 22.03.22 à 05:24, Adrien Monteleone a écrit :
> > I stand corrected, this can happen regardless of the depth preference.
> >
> > The issue is entirely caused (best I can tell) by using separate tables
> > for the Income & Expense sections.
> >
> > Since the browser will adjust the label column to fit the content, if
> > those content widths differ, you'll see misalignment.
> >
> > In my case, due to some long account names, my Income section was
> > slightly wider than the Expense section despite being depth limited to
> > 4. (the reverse of the OP's image and what I found at depth > 4)
> >
> > The quickest solution is simply to put the Income & Expense sections in
> > one HTML table element. This will cause the browser to size all 1st 
> > elements on each row to the same maximum to fit the widest content.
> > (effectively sizing the first column all the same)
> >
> > There might be a complication with the ordering since there is a report
> > option to turn off 'default Income section first' in the report.
> >
> > One small additional issue, is that this approach provides no spacing
> > between sections.
> >
> > This can be solved by adding:
> >
> > 
> >  
> >   
> >  
> > 
> >
> > after the first section's total row. (this generates a blank table row
> > with content height as a visual spacer, which can be adjusted with a
> > font-size declaration if desired.)
> >
> > I don't like that approach, but it is quick and easy. (the report HTML
> > is full of presentation hacks, and one such hack, possibly causing this
> > problem, is the use of   being inserted as an account label
> > indention mechanism rather than generating additional columns.)
> >
> > I'm not sure of the table semantics with this approach either.
> >
> > Technically, the report is a single entity, so perhaps a single table is
> > better in that regard even though each section has its own subtotal.
> >
> > I did play with adding cell padding-right to the first label-cell and it
> > worked, but that requires some calculation based on which column will
> > end up wider, and very likely a magic number or two for refinement, so
> > that's likely out as a solution.
> >
> > It might also be possible to calculate and add em-based padding-left to
> > the account label cells, (rather than multiple   entities) but that
> > doesn't really solve the variable overall column-width problem. (it just
> > changes how the indention is accomplished)
> >
> > Fixed-width would very likely be a mess too. (and still have to be
> > calculated, and that might break on a per-browser basis)
> >
> > There might still be an out playing with box-sizing and/or display
> > properties but I don't really see any magic happening since the widths
> > are calculated independently.
> >
> > One final stretch might be to play with the size of the containers of
> > the two tables, but I seriously doubt it as that affects overflow
> > usually, not expanding something smaller.
> >
> > Regards,
> > Adrien
> >
> > On 3/21/22 9:47 PM, Adrien Monteleone wrote:
> >> For me, this only happens at depths 5,6, & 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
>

Re: [GNC] Report - Income Statement - Layout problem

2022-03-23 Thread Michael or Penny Novack

On 3/23/2022 9:48 AM, Carl-Kensaku HERBORT wrote:

I already have to use two separate software: an ERP/CRM for invoicing 
and daily accounting and GnuCash for heavier monthly/yearly 
accounting, mainly to produce the Income Statement Report and Balance 
Sheet report (or so was my plan). I didn't know that GnuCash was not 
made for that and that a third software (or SCHEME/HTML coding & 
modifications) was needed just to get even basic reports that all SME 
business need.


I guess there is a first for everything: I am giving up. 



Hopefully you are still here to read this, but if not, might clarify a 
misconception others might also have.


That an "application" might not all be implemented in the same computer 
language does NOT make it "multiple software". In fact, it is advisable 
to design any sizeable program in pieces (for SEVERAL reasons) and the 
pieces can be in different languages, choosing the language based on 
what makes that part easier to code. Keep in mind that the pieces, once 
compiled, aren't "in" their source code language any more.


OK, all the programmers in a large "shop" might not know all of the 
languages and so only work on a part of the system whee they do know the 
language. Others, like myself, might be fluent in all the main languages 
used and a least be able to read all of them.


You CAN write anything in any "complete" computer language but some are 
particularly well suited to some task but clumsy for other things. To 
give you an example, early in my working days, when learning the IBM 
mainframe string processing language CLIST I came up with a "case 
problem" for myself, a "palindrome tester" -- prompts the user to enter 
a string and reports if that string is a palindrome (by TEXT palindrome 
rules, not mathematical palindrome rules which it trivial) and then asks 
the user for another or to quit. After that I used this "case problem" 
with every new language I learned to investigate its string processing 
capability. Typically a program of a hundred or two lines. But if having 
the standard tools of any 'nix operating system (linux, for example) can 
be done in bash + the library of standard 'nix utilities in about 5 
lines (say a hundred or two CHARACTERS).


BUT  this is very much to the point here. Gnucash is accounting 
software. I expect it to be able to do THAT well. I do not expect of it 
the capabilities of a powerful general purpose editor (program designed 
to edit/format data). So while I could get by in SCHEME (not fluent in 
LISP but can read it OK and it doesn't take me long to learn another 
language) I do NOT try to edit gnucash reports IN GNUCASH. I don't care 
how messed up in appearance as long as all the DATA is present in the 
report and correct. I can simply export the raw report and then edit to 
my heart's content with a powerful editor designed for THAT purpose.


Michael D Novack

___
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] Report - Income Statement - Layout problem

2022-03-23 Thread Carl-Kensaku HERBORT

Hello,

Yes, I know GnuCash is an open-source volunteer effort, hence all the 
thank you, and answering sometimes to the same questions several times 
from different people. It's normal in a volunteer project.


I am myself a long-time grateful and enthusiastic open-source software 
user and IRL helper (you won't find me in many forums answering 
questions but I am doing it in the physical world).


But, I don't think users should be sorry or ashamed to have some level 
of expectation that a software will work when it comes to a core, basic 
and widely used/needed function (even if it is an open-source volunteer 
project). For most SMEs (at least in my country), the whole point and 
sole purpose of an accounting software is to produce two reports: Income 
Statement and Balance Sheet (non-multicolumn). It is a legal requirement 
for most SMEs for the tax declaration and other formalities.


It didn't work out in GnuCash (so far). No problem, no hard feelings and 
certainly no blame: it is a wonderful piece of software. And I am happy 
if it gets solved sometime in the future by some hard-working generous 
programmers giving their free time.


But I will not feel sorry or ashamed to just have expectations.

On the other hand, I am really sorry if that hurt your feelings, that 
wasn't the intent. My apologies.


Again, thank you all so much for all your help.

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 23.03.22 à 15:21, Christopher Lam a écrit :
Please be aware that GnuCash is a volunteer effort. In so many (20+) 
years of users there have been no complaints about this particular 
layout issue in the Income Statement. A fresh pair of eyes, however, 
found this genuine layout issue. The Multicolumn Income Statement report 
in the Experimental menu may be more suitable; it is much more capable 
and has a more conventional layout.


Meanwhile, now that this is now known, and Adrien has kindly found the 
root cause, it is likely that the developers will be able to fix the 
Income Statement.


On Wed, 23 Mar 2022 at 13:49, Carl-Kensaku HERBORT > wrote:


Hello,

Thanks to everyone for your help and time.

It is a shame that it is so complicated to make the Income Statement
report look normal, like the Balance Sheet report, which also has two
sections (Assets and Liabilities) that have no problem at all.

I already have to use two separate software: an ERP/CRM for invoicing
and daily accounting and GnuCash for heavier monthly/yearly accounting,
mainly to produce the Income Statement Report and Balance Sheet report
(or so was my plan). I didn't know that GnuCash was not made for that
and that a third software (or SCHEME/HTML coding & modifications) was
needed just to get even basic reports that all SME business need.

I guess there is a first for everything: I am giving up.

Again, thanks a lot to everyone who took on their free time to
answer my
questions.

Have a nice day

Best regards

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 22.03.22 à 05:24, Adrien Monteleone a écrit :
 > I stand corrected, this can happen regardless of the depth
preference.
 >
 > The issue is entirely caused (best I can tell) by using separate
tables
 > for the Income & Expense sections.
 >
 > Since the browser will adjust the label column to fit the
content, if
 > those content widths differ, you'll see misalignment.
 >
 > In my case, due to some long account names, my Income section was
 > slightly wider than the Expense section despite being depth
limited to
 > 4. (the reverse of the OP's image and what I found at depth > 4)
 >
 > The quickest solution is simply to put the Income & Expense
sections in
 > one HTML table element. This will cause the browser to size all
1st 
 > elements on each row to the same maximum to fit the widest content.
 > (effectively sizing the first column all the same)
 >
 > There might be a complication with the ordering since there is a
report
 > option to turn off 'default Income section first' in the report.
 >
 > One small additional issue, is that this approach provides no
spacing
 > between sections.
 >
 > This can be solved by adding:
 >
 > 
 >      
 >       
 >      
 > 
 >
 > after the first section's total row. (this generates a blank
table row
 > with content height as a visual spacer, which can be adjusted with a
 > font-size declaration if desired.)
 >
 > I don't like that approach, but it is quick and easy. (the report
HTML
 > is full of presentation hacks, and one such hack, possibly
causing this
 > problem, is the use of   being inserted as an account label
   

Re: [GNC] Report - Income Statement - Layout problem

2022-03-23 Thread Carl-Kensaku HERBORT

Hello,

Yes, I know all that. I love doing bash scripting.

But thanks for taking the time to explain (might benefit someone else too).

Thank you very much

Best regards,

--
Carl-Kensaku HERBORT
DIGIENE
Case postale
CH-1002 Lausanne
Suisse

+41 (0) 21 320 22 66

Le 23.03.22 à 16:26, Michael or Penny Novack a écrit :

On 3/23/2022 9:48 AM, Carl-Kensaku HERBORT wrote:

I already have to use two separate software: an ERP/CRM for invoicing 
and daily accounting and GnuCash for heavier monthly/yearly 
accounting, mainly to produce the Income Statement Report and Balance 
Sheet report (or so was my plan). I didn't know that GnuCash was not 
made for that and that a third software (or SCHEME/HTML coding & 
modifications) was needed just to get even basic reports that all SME 
business need.


I guess there is a first for everything: I am giving up. 



Hopefully you are still here to read this, but if not, might clarify a 
misconception others might also have.


That an "application" might not all be implemented in the same computer 
language does NOT make it "multiple software". In fact, it is advisable 
to design any sizeable program in pieces (for SEVERAL reasons) and the 
pieces can be in different languages, choosing the language based on 
what makes that part easier to code. Keep in mind that the pieces, once 
compiled, aren't "in" their source code language any more.


OK, all the programmers in a large "shop" might not know all of the 
languages and so only work on a part of the system whee they do know the 
language. Others, like myself, might be fluent in all the main languages 
used and a least be able to read all of them.


You CAN write anything in any "complete" computer language but some are 
particularly well suited to some task but clumsy for other things. To 
give you an example, early in my working days, when learning the IBM 
mainframe string processing language CLIST I came up with a "case 
problem" for myself, a "palindrome tester" -- prompts the user to enter 
a string and reports if that string is a palindrome (by TEXT palindrome 
rules, not mathematical palindrome rules which it trivial) and then asks 
the user for another or to quit. After that I used this "case problem" 
with every new language I learned to investigate its string processing 
capability. Typically a program of a hundred or two lines. But if having 
the standard tools of any 'nix operating system (linux, for example) can 
be done in bash + the library of standard 'nix utilities in about 5 
lines (say a hundred or two CHARACTERS).


BUT  this is very much to the point here. Gnucash is accounting 
software. I expect it to be able to do THAT well. I do not expect of it 
the capabilities of a powerful general purpose editor (program designed 
to edit/format data). So while I could get by in SCHEME (not fluent in 
LISP but can read it OK and it doesn't take me long to learn another 
language) I do NOT try to edit gnucash reports IN GNUCASH. I don't care 
how messed up in appearance as long as all the DATA is present in the 
report and correct. I can simply export the raw report and then edit to 
my heart's content with a powerful editor designed for THAT purpose.


Michael D Novack

___
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] How to apply overpayment to new invoice?

2022-03-23 Thread Adrien Monteleone
If you have both a pre-payment and an invoice unpaid, simply select both 
of them in the Process Payments window. If the net is zero then they 
will both be cleared out.


If there is still pre-payment left, that remainder will be their next time.

If there is still invoice left, it will continue to show as unpaid.

You may need to use the 'Edit Payment' in the right-click menu on the 
transaction however.


Regards,
Adrien

On 3/23/22 5:35 AM, Eric H. Bowen via gnucash-user wrote:
I was late with my property taxes this year and incurred a penalty. I 
had earlier entered the billed amount as an invoice payable to the tax 
collector. I finally got the funds together to pay the amount, including 
penalty, in full. I entered it as one payment transaction, of course, 
since it was one e-check, and now it's showing up in my "Accounts 
Payable" as two transactions, one for the remaining billed amount (I had 
made partial payments earlier), and a separate transaction for $136.63 
representing the penalty and interest which appears as an unassigned 
pre-payment.


OK so far. Well, now that I know the total penalty I entered another 
invoice for that amount. Fine. Now I want to pay the invoice with the 
pre-payment. I go to the payment screen and the pre-payment shows up 
there. But I can find no way to apply it to the new invoice. How do I 
close this [expletive!] out?


___
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] Report - Income Statement - Layout problem

2022-03-23 Thread Adrien Monteleone

Carl-Kensaku,

No need to dig into Scheme or HTML to fix this.

The devs will address it soon enough I'm sure, but this is a 
'presentation' issue.


That can always be fixed in the short term by either exporting and 
opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet.


From there you can easily fix the first label column to the same size. 
(it might even do it automatically since it will import both tables into 
one sheet)


Many people make their reports 'pretty' using spreadsheet apps. It also 
allows for additional math that would be difficult to write having to 
learn Scheme. (such as Variance columns or other various aggregate 
subtotals)


Regards,
Adrien

On 3/23/22 10:26 AM, Carl-Kensaku HERBORT wrote:

Hello,

Yes, I know GnuCash is an open-source volunteer effort, hence all the 
thank you, and answering sometimes to the same questions several times 
from different people. It's normal in a volunteer project.


I am myself a long-time grateful and enthusiastic open-source software 
user and IRL helper (you won't find me in many forums answering 
questions but I am doing it in the physical world).


But, I don't think users should be sorry or ashamed to have some level 
of expectation that a software will work when it comes to a core, basic 
and widely used/needed function (even if it is an open-source volunteer 
project). For most SMEs (at least in my country), the whole point and 
sole purpose of an accounting software is to produce two reports: Income 
Statement and Balance Sheet (non-multicolumn). It is a legal requirement 
for most SMEs for the tax declaration and other formalities.


It didn't work out in GnuCash (so far). No problem, no hard feelings and 
certainly no blame: it is a wonderful piece of software. And I am happy 
if it gets solved sometime in the future by some hard-working generous 
programmers giving their free time.


But I will not feel sorry or ashamed to just have expectations.

On the other hand, I am really sorry if that hurt your feelings, that 
wasn't the intent. My apologies.


Again, thank you all so much for all your 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] Report - Income Statement - Layout problem

2022-03-23 Thread Adrien Monteleone

And indeed, I just tested this in LibreOffice.

Both methods work to automatically resize the columns to line up, though 
export/open retains fonts, background, etc.


Select-All followed by Copy/Paste into a blank sheet brings up the Text 
Import dialog, and I left the default options.


This method will stick everything in the spreadsheet cells with no 
formatting carried over. (it will insert as plain text, so your 
spreadsheet styles will override)


You may find this easier as you can define your spreadsheet styles 
perhaps more intuitively using an office app than via CSS in GnuCash.


Then simply multi-select and apply those styles to the relevant cells.

The amount of setup work you need to do just depends on how you want it 
to look and how often you need to do this. Templates can help here 
considerably.


Regards,
Adrien

On 3/23/22 12:34 PM, Adrien Monteleone wrote:

Carl-Kensaku,

No need to dig into Scheme or HTML to fix this.

The devs will address it soon enough I'm sure, but this is a 
'presentation' issue.


That can always be fixed in the short term by either exporting and 
opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet.


 From there you can easily fix the first label column to the same size. 
(it might even do it automatically since it will import both tables into 
one sheet)


Many people make their reports 'pretty' using spreadsheet apps. It also 
allows for additional math that would be difficult to write having to 
learn Scheme. (such as Variance columns or other various aggregate 
subtotals)


___
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] change default behavior of ctrl-PgDn

2022-03-23 Thread Jeff

Running:

Version: 4.9
Build ID: Flathub 4.9-2
Finance::Quote: 1.49GNC 4.9

on Ubuntu.

When I need to enter a new transaction (that I missed) and hit ctrl-PgDn 
it throws me to the bottom of the register as expected. But the caret is 
on the third number line down, not in the date column where I would 
expect it to.


Is there a simple fix to change this behavior?  I have the default view 
set for view double line, transactional.


--
--JEffrey Black M.B.A.

___
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] change default behavior of ctrl-PgDn

2022-03-23 Thread Glenn Fowler
Wouldn't pressing  be easier than Ctrl+PgDn?


On Wed, Mar 23, 2022 at 5:23 PM Jeff  wrote:

> Running:
>
> Version: 4.9
> Build ID: Flathub 4.9-2
> Finance::Quote: 1.49GNC 4.9
>
> on Ubuntu.
>
> When I need to enter a new transaction (that I missed) and hit ctrl-PgDn
> it throws me to the bottom of the register as expected. But the caret is
> on the third number line down, not in the date column where I would
> expect it to.
>
> Is there a simple fix to change this behavior?  I have the default view
> set for view double line, transactional.
>
> --
> --JEffrey Black M.B.A.
>
> ___
> 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] change default behavior of ctrl-PgDn

2022-03-23 Thread Jeff
I'm talking about entering transactions in prior months, not adding new 
sequential transactions at the end of the journal.


On 3/23/22 4:45 PM, Glenn Fowler wrote:

Wouldn't pressing  be easier than Ctrl+PgDn?


On Wed, Mar 23, 2022 at 5:23 PM Jeff > wrote:


Running:

Version: 4.9
Build ID: Flathub 4.9-2
Finance::Quote: 1.49GNC 4.9

on Ubuntu.

When I need to enter a new transaction (that I missed) and hit
ctrl-PgDn
it throws me to the bottom of the register as expected. But the
caret is
on the third number line down, not in the date column where I would
expect it to.

Is there a simple fix to change this behavior?  I have the default
view
set for view double line, transactional.

-- 
--JEffrey Black M.B.A.


___
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.



--
--JEffrey Black M.B.A.

___
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] change default behavior of ctrl-PgDn

2022-03-23 Thread Gyle McCollam
You can enter them at the end with the correct date and gnucash will put them 
in date order where they belong,  even if it is months or even years ago.



Sent from Samsung Galaxy smartphone.



 Original message 
From: Jeff 
Date: 3/23/22 7:34 PM (GMT-05:00)
To: Glenn Fowler 
Cc: Gnucash userlist 
Subject: Re: [GNC] change default behavior of ctrl-PgDn

I'm talking about entering transactions in prior months, not adding new
sequential transactions at the end of the journal.

On 3/23/22 4:45 PM, Glenn Fowler wrote:
> Wouldn't pressing  be easier than Ctrl+PgDn?
>
>
> On Wed, Mar 23, 2022 at 5:23 PM Jeff  > wrote:
>
> Running:
>
> Version: 4.9
> Build ID: Flathub 4.9-2
> Finance::Quote: 1.49GNC 4.9
>
> on Ubuntu.
>
> When I need to enter a new transaction (that I missed) and hit
> ctrl-PgDn
> it throws me to the bottom of the register as expected. But the
> caret is
> on the third number line down, not in the date column where I would
> expect it to.
>
> Is there a simple fix to change this behavior?  I have the default
> view
> set for view double line, transactional.
>
> --
> --JEffrey Black M.B.A.
>
> ___
> 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.
>

--
--JEffrey Black M.B.A.

___
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] [GNC-dev] [MAINT] Planned network outage March 23, 7pm EDT (2300 UTC)

2022-03-23 Thread Derek Atkins
Hi,
This work has been completed.
Please let me know if you have an issue so I can contact them.
-derek

On Wed, March 23, 2022 8:57 am, Derek Atkins wrote:
> Hi,
>
> Just a reminder that this is happening today.  The email from my ISP:
>
>> A reminder about this. We’re arriving at 6pm and will likely start
>> little earlier than 7pm.
>>
>> I will send an email out when we complete the router swap, and
>> we’ll be monitoring slack for any issues.
>>
>> You can reach me via sms at xxx if there  are issues.
>>
>> After the Router swap is done, we will be replacing PDUs
>> (one at a time), so please expect one side of your server’s
>> power feed to drop during this work.
>
> I expect there to be an outage when the router is down, but it should all
> come back once the new router is online.  I will attempt to monitor the
> situation as I can (I'm on the road today and expect to not be near my
> laptop at 7pm EDT) but will let you all know updates when I get them.
>
> Thanks,
>
> -derek
>
> On Wed, March 9, 2022 2:35 pm, Derek Atkins wrote:
>> Hi,
>>
>> I just got word from my ISP that they are planning a router swap on
>> March
>> 23 at 7pm US/EDT.  They expect the outage to last up to an hour while
>> they
>> swap out the old router and install the new one (and update the PDUs in
>> the process).
>>
>> During that time, code.gnucash.org will be inaccessible, which means git
>> commits, email, wiki, IRC logs, etc will all be unavailable.
>>
>> Once the new router comes online I expect everything to return to normal
>> quickly.
>>
>> Please let me know if there are any questions.
>>
>> -derek
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>> ___
>> gnucash-devel mailing list
>> gnucash-de...@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>


-- 
   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.