Re: [GNC] Blank reports

[Daffy Duck]

It's in Linux and possibly related to theme, or something.

When I access remotely with a different windows manager, it's fine.

Also, when I print the report, the PDF is fine.

But ANY reports from this particular Fedora desktop, while inside
gnucash, are blank.  You can only see the theme background.  But
clearly the report is there because when I look at the printed PDF,
it's fine.

On Tue, 2024-01-09 at 19:19 +1000, David H wrote:
> Probably this known Windows only bug discussed a few days ago on
> this mailing list -
>  https://lists.gnucash.org/pipermail/gnucash-user/2024-January/110256.html
> . ?
> 
> 
> 
> On Tue, 9 Jan 2024 at 18:50, Daffy Duck 
> wrote:
> > Hello,
> > 
> > On and off for a while, I would get blank reports(easy invoice,
> > etc) to
> > where you couldn't see anything, but if you printed, or printed to
> > PDF,
> > it looked fine.
> > 
> > Rebooting the computer seemed to fix that, but now I can't make it
> > go
> > away.
> > 
> > Any ideas?
> > 
> > The tab for the report just has the default gtk color background. 
> > 
> > gnucash-5.5-1.fc39.x86_64
> > ___
> > 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 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Printable Invoice is blank

[Rares Vernica]

Hello,

For some reason a recent update makes the Printable Invoice show up bank.
Saving to PDF works fine, but I can't preview/adjust the invoice.

Here is a screenshot:
[image: image.png]
Here is what I see in the terminal:

> gnucash
libEGL warning: DRI3: Screen seems not DRI3 capable
libEGL warning: failed to open /dev/dri/card0: Permission denied


libEGL warning: DRI2: could not open /dev/dri/card0 (Permission denied)
libEGL warning: DRI3: Screen seems not DRI3 capable
failed to open /dev/dri/card0: Permission denied
failed to open /dev/dri/card0: Permission denied
failed to load driver: iris
Failed to get GBM device


Here is the version info:

> gnucash --version
GnuCash 5.5
Build ID: 5.5+(2023-12-16)
> uname -a
Linux 6.6.14-200.fc39.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jan 26 20:12:16 UTC
2024 x86_64 GNU/Linux


Thank you!
Rares
___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reports not displaying.

[Andreas Heidemann]

Hello,

I'm also experiencing this problem. It comes with GnuCash 4.8, available 
at the current Ubuntu 22.04.4 LTS.
I'm running this Ubuntu version on two different notebooks, only one of 
them show this problem.


Listed GnuCash Version-ID at the problematic instance is 4.8a+(2021-09-28)

At the problematic notebook there is a nvidea chip detectable by "lshw" 
withe the following specs listed:

   *-display
    Beschreibung: 3D controller
    Produkt: GP107GLM [Quadro P620]
    Hersteller: NVIDIA Corporation
    Physische ID: 0
    Bus-Informationen: pci@:01:00.0
    Version: a1
    Breite: 64 bits
    Takt: 33MHz
    Fähigkeiten: pm msi pciexpress bus_master cap_list rom
    Konfiguration: driver=nvidia latency=0
    Ressourcen: irq:189 memory:ec00-ecff 
memory:c000-cfff memory:d000-d1ff ioport:3000(Größe=128) 
memory:ed00-ed07


The other notebook has follwing entry within the "lshw":
    *-display
 Beschreibung: VGA compatible controller
 Produkt: Skylake GT2 [HD Graphics 520]
 Hersteller: Intel Corporation
 Physische ID: 2
 Bus-Informationen: pci@:00:02.0
 Logischer Name: /dev/fb0
 Version: 07
 Breite: 64 bits
 Takt: 33MHz
 Fähigkeiten: vga_controller bus_master cap_list rom fb
 Konfiguration: depth=32 driver=i915 latency=0 
resolution=1920,1080
 Ressourcen: irq:127 memory:b000-b0ff 
memory:a000-afff ioport:3000(Größe=64) memory:c-d



--
Andreas Heidemann

Unnaer Str. 19, 59439 Holzwickede
fon: +49 177 2904819

___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reports

[Dennis Powless]

Thanks for all the help.  Adrien, you are correct I should have been more
specific.  The transaction report worked best for what I needed.
Interestingly, the file, export, export to csv output was each split as
a row of data (too much info for what I needed).  Not what I was looking
for, the report worked quite well for what I needed.

Thanks for your help.

D

On Sat, Mar 2, 2024 at 6:16 PM Kalpesh Patel  wrote:

> There are also non-report way to export transactions  latter one after
> focusing a specific register ...
>
> File --> Export --> Export Transaction to CSV
>
> -- OR --
>
> File --> Export --> Export Active Register to CSV
>
> -Original Message-
> From: Adrien Monteleone 
> Sent: Friday, March 01, 2024 8:20 PM
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] reports
>
> The 'best' is up to you to figure out based on your needs and what you
> want to see or do with the spreadsheet.
>
> Three possibilities immediately come to mind:
>
> 1. Budget Report — Even without using GnuCash to budget, it can still show
> consolidated Actuals by period, quarter, year, etc.
>
> 2. Account Report - Run this while viewing a checking register. You'll
> have to do this for each account separately.
>
> 3. Transaction Report - Can get you everything from multiple accounts and
> can sort and subtotal in various ways. Date ranges are highly customizable.
>
> ---
>
> Are you *certain* you want to export transactions based on their link to a
> checking account? Checking accounts are just sources of funds, not why you
> are spending the money.
>
> For budgeting purposes, you more likely want the transactions that touch
> your Expense accounts.
>
> Regards,
> Adrien
>
> On 3/1/24 3:44 PM, Dennis Powless wrote:
> > I'm using excel to budget.  I'm looking for the best report to export
> > data to excel that will show all transactions from my checking
> > accounts.  Which report is the best for this?  I'm using windows and
> > the latest version of gnucash for windows.
>
>
>
> ___
> 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 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reports

[Kalpesh Patel]

There are also non-report way to export transactions  latter one after 
focusing a specific register ...

File --> Export --> Export Transaction to CSV

-- OR --

File --> Export --> Export Active Register to CSV

-Original Message-
From: Adrien Monteleone  
Sent: Friday, March 01, 2024 8:20 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] reports

The 'best' is up to you to figure out based on your needs and what you want to 
see or do with the spreadsheet.

Three possibilities immediately come to mind:

1. Budget Report — Even without using GnuCash to budget, it can still show 
consolidated Actuals by period, quarter, year, etc.

2. Account Report - Run this while viewing a checking register. You'll have to 
do this for each account separately.

3. Transaction Report - Can get you everything from multiple accounts and can 
sort and subtotal in various ways. Date ranges are highly customizable.

---

Are you *certain* you want to export transactions based on their link to a 
checking account? Checking accounts are just sources of funds, not why you are 
spending the money.

For budgeting purposes, you more likely want the transactions that touch your 
Expense accounts.

Regards,
Adrien

On 3/1/24 3:44 PM, Dennis Powless wrote:
> I'm using excel to budget.  I'm looking for the best report to export 
> data to excel that will show all transactions from my checking 
> accounts.  Which report is the best for this?  I'm using windows and 
> the latest version of gnucash for windows.



___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reports

[Glenn Serre]

Good morning Dennis,

You could export your checking account transactions to csv for import
by excel using one of the File,Export options.  I used to use this to
send transactions to my accountants.  The export is modestly
labor-intensive, though, so recently I wrote a short python program to
automate my exports.  I would be happy to share, but you may need to
compile gnucash yourself to enable the python bindings and perhaps do
a little debugging, as I only run Linux nowadays.

-- Glenn S.

On Fri, Mar 1, 2024 at 1:46 PM Dennis Powless  wrote:
>
> I'm using excel to budget.  I'm looking for the best report to export data
> to excel that will show all transactions from my checking accounts.  Which
> report is the best for this?  I'm using windows and the latest version of
> gnucash for windows.
>
> Dennis
> ___
> 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 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Welcome To the World of Retail: Sales Tax and CC fees

[Eric H. Bowen via gnucash-user]

So my book is coming out at the end of this month, at long last. I 
expect that most of my sales will be through my distributor, who will 
handle things on the back end and just cut me a (very small!) check. (Or 
an invoice if it doesn't sell and copies are returned...but, as has been 
said, if your dreams don't scare you then they're not big enough!)


Still, I want to do some local sales and I want to account for them 
properly. My personal sales are likely to fall into one of three categories:


 * Wholesale (discounted) sales to resellers who do not have a sales
   account with my wholesaler/distributor. I've identified one such
   outlet and offered them a 53% reseller discount off the cover price
   to stock it at their location. They'll be responsible for any CC
   fees and taxes, so no problem there.
 * Retail sales through agents: There is a local non-book store I
   frequent (actually, it's a donut shop) which offered to let me sell
   the book through them when I mentioned it...and they didn't even ask
   for a cut, even though I offered them one. With such friendly
   treatment I want to make things as easy as possible for them, and I
   want to offer a price break to their/my customers by eating the
   8.25% local sales tax. Generally for one-off sales I just divide the
   sale price by 1.0825 and use the standard tax table; it comes out
   even. Here, though, it won't be a one-off but (hopefully) an ongoing
   thing. What's the best way to set this up? I had in mind creating a
   sales sub-account for tax-included purchases and then every quarter
   when the tax return is due divide by 1.0825, send the 8 and a
   quarter to my sales tax liability account and the remainder to my
   regular sales account. Does that sound workable, or is there a
   better way?
 * Retail sales at shows, by mail, special requests such as signed
   copies, etc. In the local state they'll have sales tax due, but
   shipped out of state as I understand it I won't need to collect
   until/unless I cross the sales nexus threshold (highly unlikely).
   But what of potential overseas direct sales? Even my CPA is unlikely
   to know all of the hoops...and tiger traps...standing out in that
   field. Can someone direct me to a concise primer to sales from
   overseas in Great Britain, the UK, Australia, and Canada (the main
   markets I can ship to)?

Thanks again. This community has proven wonderfully helpful over the 
yearsEric.

___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple Fiscal Years

[john]

Adrien,

If you follow the mailing list link in Flywire's original, 
https://lists.gnucash.org/pipermail/gnucash-user/2021-October/097880.html, 
you'll see that it shares a hack of the Scheme relative-date code to shift the 
calendar year by a hard-coded 6 months. GnuCash 5 includes a rewrite of the 
option system in C++ so the hack can't be applied any more.

But I think it's unnecessary since changing the accounting period in 
preferences to e.g. 1 July 2023 - 30 June 2024 accompanies the same thing, the 
only problem being that you annually have to update the years. Note, though, 
that the accounting period preference is a bit too flexible: The relative dates 
are hard-coded to the first or last day of the calendar month, so they won't 
work if the period starts and ends in the middle of a month, and they assume a 
12-month period so using some of the relative dates with an accounting period 
of more or less than 12 months will create reports that don't align with the 
period.

Regards,
John Ralls

> On Mar 2, 2024, at 06:21, Adrien Monteleone  
> wrote:
> 
> I'm still not understanding what change you are referring to.
> 
> In both 4.x and 5.x you can set your Accounting Period to a relative date or 
> an absolute date such as Jul 1 2024 to Jun 30 2024 and when you run reports, 
> choose relative dates such as 'Start/End of Accounting Period' or 'start/end 
> of previous year' which would line up with Jul 1 2023 to Jun 30 2023.
> 
> I've never seen a relative option for 2 years prior. You can always run a 
> separate report with those absolute dates however.
> 
> But it sounds like you made your own code modifications to do something 
> GnuCash didn't support, and now they don't work. That's not a fault of 
> GnuCash. That's a fault of your assumption that whatever code you relied on 
> to do it wouldn't change. Your solution isn't to insist the devs revert their 
> changes, but to fix your own code.
> 
> Now, if any change in GnuCash *does* affect the intended and supported 
> behavior/functions, that would be a bug.
> 
> Otherwise, reverting the change would need to have a very good case (beyond 
> helping you avoid changing your own hack) made in an RFE.
> 
> Regards,
> Adrien
> 
> On 3/1/24 8:28 PM, flywire wrote:
>> Follow the links through to the code - cur-year and cal-year. The hack
>> supports: this, last and 2 years prior fiscal years which is about
>> what you want preparing tax reports.
> 
> ___
> 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 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-user Digest, Vol 252, Issue 3

[Eric H. Bowen via gnucash-user]

Thanks for pointing that out; it helped with the outstanding $200 check 
I had trouble getting rid of. However, since it won't extend back any 
farther than 50 days, I think it won't be likely to help when (if?) that 
check I wrote to the nonprofit back in December finally clears.


Eric.

On 3/2/2024 12:26 AM, gnucash-user-requ...@gnucash.org wrote:

Message: 3
Date: Fri, 1 Mar 2024 13:29:47 -0800
From: john
To: "Eric H. Bowen"
Cc:gnucash-user@gnucash.org
Subject: Re: [GNC] Improving GnuCash's Processing of Outstanding
Checks
Message-ID:<1459e1cf-dbc7-431a-8beb-7180011ff...@ceridwen.us>
Content-Type: text/plain;   charset=us-ascii




On Mar 1, 2024, at 08:53, Eric H. Bowen via 
gnucash-user  wrote:

Is it possible to extend the time for outstanding checks to show up in the "manual 
match" window?

That's controlled by the two  match day thresholds in Preferences>Import.

Regards,
John Ralls

___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple Fiscal Years

[Adrien Monteleone]

I'm still not understanding what change you are referring to.

In both 4.x and 5.x you can set your Accounting Period to a relative 
date or an absolute date such as Jul 1 2024 to Jun 30 2024 and when you 
run reports, choose relative dates such as 'Start/End of Accounting 
Period' or 'start/end of previous year' which would line up with Jul 1 
2023 to Jun 30 2023.


I've never seen a relative option for 2 years prior. You can always run 
a separate report with those absolute dates however.


But it sounds like you made your own code modifications to do something 
GnuCash didn't support, and now they don't work. That's not a fault of 
GnuCash. That's a fault of your assumption that whatever code you relied 
on to do it wouldn't change. Your solution isn't to insist the devs 
revert their changes, but to fix your own code.


Now, if any change in GnuCash *does* affect the intended and supported 
behavior/functions, that would be a bug.


Otherwise, reverting the change would need to have a very good case 
(beyond helping you avoid changing your own hack) made in an RFE.


Regards,
Adrien

On 3/1/24 8:28 PM, flywire wrote:

Follow the links through to the code - cur-year and cal-year. The hack
supports: this, last and 2 years prior fiscal years which is about
what you want preparing tax reports.


___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple Fiscal Years

[Adrien Monteleone]

Wow, an accounting period of 54 years? I'm not sure I'd ever need to do 
so, but glad to know it works!


Regards,
Adrien

On 3/2/24 12:26 AM, Geoff wrote:
Maybe I am missing something here, but I created a book with a start 
date of 1-Jan-1970 and an end date of 31-Dec-2024, keyed transactions 
dated 2-Feb-1970 and 3-Mar-2024, and the Balance Sheet and Profit & Loss 
reports are behaving as expected.


___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple Fiscal Years

[flywire]

On Sat, 2 Mar 2024 at 17:26, Geoff  wrote:

> Maybe I am missing something here


Absolutely.

Say the height of a sporting team member was given as 2.2m high. Was the
measurement correct? Who knows! You can use relative values to assess the
credibility of a number. Given two other members measured 2.1m and 2.3m the
measurement looks credible.

Let's do profit and loss, and balance sheet reports for tax reporting in
GnuCash. You'll want to run the reports the previous year, and you can
compare them to two years previous to assess the credibility of the values.
(If your tax reports are for calendar year then congratulations, and the
next paragraph won't mean much to you.)

GnuCash allows you to define Accounting Period but that doesn't allow a
simple comparison between the previous fiscal year and two fiscal years
previous. The hack for GnuCash V4 does allow that by defining the current
year other than the calendar year (example is 1 Jul to 30 Jun) so the
reports are similar to most financial software.
___
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 your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] borrom margins on pdf export

[sunfish62--- via gnucash-user]

Or save the report to HTML, open in a browser, and print.  

⁣David T. ​

On Mar 1, 2024, 6:46 PM, at 6:46 PM, Murugan Muruganandam 
 wrote:
>you can alter the bottom margins from file->page setup.
>
>you may have to do couple of trials to get it correct. again each
>report you may have different margin
>
>
>
>
>Saludos Cordiales
>
>
>Murugan
>
>
>From: gnucash-user
> on behalf
>of Eric Beversluis via gnucash-user 
>Sent: Thursday, February 29, 2024 7:25 PM
>To: gnucash-user@gnucash.org 
>Subject: [GNC] borrom margins on pdf export
>
>When I export a report to pdf, there is no proper bottom margin--the
>info just runs off the bottom, with the top half of a line on one page
>and the bottom half on the next. I can't find any place to adjust the
>relevant settings.
>
>Is there a way to fix this?
>
>I'm using 3.11 on Mac Monterey.
>
>Thanks.
>--
>Eric Beversluis
>www.ericbeversluis.com
>2x Honorable Mention--Writer's Digest Contest
>___
>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 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
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.