Re: [GNC] Account Hierarchy

[Adrien Monteleone]

Thanks Stan,

I've bookmarked for future reference.

Regards,
Adrien

On 5/3/24 9:50 PM, Stan Brown (using GC 4.14) wrote:

https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix


___
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] Account Hierarchy

[Stan Brown (using GC 4.14)]

On 2024-05-03 14:36, Adrien Monteleone wrote:
> There is also a custom 'Tag' version of that report floating around on
> this list. Look for the user 'flywire' to find posts linking to it.
> (it's on Github I think)
Posted 2024-04-28 by flywire with subject "The equivalent for Quicken Tag":
> Use the custom transaction report at
>
https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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] New account

[Stan Brown (using GC 4.14)]

On 2024-05-03 13:05, Gary Cook wrote:
> I found the problem. The window that pops up to create a new account,
> was doing so on one of my monitors that was not powered-up. I just
> discovered it today, having turned the monitor on for another reason,
> earlier.
> 
> I've never directed the windows to come up on a different monitor, so it
> never occurred to me to check.

Thanks for letting us know the solution, Gary, and I'm glad it's working
for you.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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] New account

[Gary Cook]

Thank you, Stan.

I found the problem. The window that pops up to create a new account, 
was doing so on one of my monitors that was not powered-up. I just 
discovered it today, having turned the monitor on for another reason, 
earlier.


I've never directed the windows to come up on a different monitor, so it 
never occurred to me to check.


Thank you for your kind response. Have a great day,
Gary

___
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] Account Hierarchy

[Adrien Monteleone]

There is another, simpler, option, such as:

Sales

and that's it.

If you're using the Business Features and will be creating Invoices for 
your sales, then the invoice line items will contain the individual 
product sales data. (you also might have separate sub-accounts under 
Assets:Inventory for each item) By default, this is not exposed for 
reporting, but if you unset the preference to 'consolidate splits on 
posting' then each line item will appear in affected registers. From 
there, you can craft Transaction Reports that filter based on say, the 
name of the product allowing you to create an aggregate sales report. 
(you can do this per invoice, or set a global preference)


I'm not sure what your use of 'Shop A' and 'Shop B' is in the real 
world. Are these just separate physical locations of the same business? 
If not, and these are distinct business entities, the usual 
recommendation is they should have their own individual books.


If they are just different sales locations, you can put that info in the 
Invoice line items as noted, and use the Transaction Report filter tab 
on that text as well. Or, you can go so far as to create:


Sales:
 Shop A
 Shop B

The line items will contain the product data, and the posting account 
will segregate the sales locations. These can be selected per invoice.


There is also a custom 'Tag' version of that report floating around on 
this list. Look for the user 'flywire' to find posts linking to it. 
(it's on Github I think)


If you aren't going to use the business features and will simply be 
doing manual sales transactions (imported, or created individually), 
then you can use a similar approach with filtering and/or tagging and 
put the 'shop' location either in the Description, Notes, or Action 
field. (use Double Line view mode to see Notes) Or as above, create 
sub-accounts under Sales.


The only report that can't filter/tag nicely at present is the 
P/Income Statement, but you could craft something via the Transaction 
Report to get close.


Further possibilities open up if you export said reports to a 
spreadsheet app for further manipulation if you can't get exactly what 
you want within GnuCash.


Any of the above approaches would remove the either/or situation you're 
contemplating and open up more flexibility down the road should you need 
it without having to refactor your historical transactions or account 
structure as you find your needs change.


Regards,
Adrien

On 5/1/24 3:30 AM, Patrick Skelton wrote:

I am about to structure a new set of accounts for a business. GnuCash uses
a hierarchy, which I am currently trying to decide upon. Two
part-hierarchies come to mind:

*FIRST*

Sales

Shop A

Product 1

Product 2

Shop B

Product 1

Product 2


*SECOND*

Sales

Product 1

Shop A

Shop B

Product 2

Shop A

Shop B


The first would make it easy to see sales for each shop but harder to find
out the sales for each product. The second would make it easy to see sales
for each product but harder to find out the sales for each shop.

Both of these seem like reasonable questions to be able to ask of the
accounts. How do I choose which hierarchy to go with and is there any way I
can answer both of these questions?

Any advice would be most welcome as I am no accounting expert and have only
basic knowledge of GnuCash.


___
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] Finance::Quote PreRelease 1.61_03

[Bruce Schuck]

On 5/3/24 11:36 AM, Kalpesh Patel wrote:


I looked at Makefile.PL for 1.61 source at CPAN and it does NOT have CPAN
listed in PREREQ_PM or in %FallbackPrereqs. Might be worth adding to it...
Most GnuCash users can (and probably should...) likely ignore this post. 
Any further discussion should be taken offline of the GnuCash user list.


Kalpesh,

Makefile.PL gets created when Dist::Zilla (aka dzil) creates the tarball 
for uploading to CPAN.


Please understand what the prerequisites listed in the GitHub repo 
dist.ini file and package Makefile.PL and META files are. Those are 
modules that the module being installed requires to build, run, and 
test. Technically CPAN is *not* required for that. CPAN (and CPAN Minus) 
is a tool that simplifies the module install process for both novice and 
expert Perl users. One would not be able to execute "cpan 
Finance::Quote" or "perl -MCPAN -e shell" *unless* CPAN were already 
installed. Your suggestion to add it to the module prereqs is the same 
as suggesting that *every* single Perl module on CPAN should have it 
included as a prerequisite.


But that said, either the GnuCash and/or F::Q docs/wiki would probably 
benefit from an overview on how to check if CPAN is installed, and how 
to install CPAN if it is not already installed.


Bruce S.
___
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] Finance::Quote PreRelease 1.61_03

[Kalpesh Patel]

My bad here ... since working with Perl 5.005 ... 

-- Original Message --
Received: Fri, 03 May 2024 02:37:19 PM EDT
From: "Kalpesh Patel" 
To: Bruce Schuck , GnuCash User
Cc: Kalpesh Patel , Fred
Tydeman 
Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03

> Hi Bruce,
> 
> Indeed it is old school way to generate make file and install Perl modules.
I
> do recall doing so on many iterations since working with Perl 5.10 days
when
> CPAN was in its infancy for couple of Financial Houses I was employed at
that
> were big time into Perl. Especially trying to build SSLeay module with
> OpneSSL, z-lib (or was it libz) and other dependent libraries' headers on
SUN
> Ultra Sparc 2's back then. What a nightmare (or fun) that was...  
> 
> Anyways I was more interested in making sure that Fred had generated
correctly
> and not adopted from somewhere else that might be somewhat bastardized one.
I
> also got thrown off a bit in that when I cloned the repo for 1.61_03, it
> didn't have Makefile.PL so it was more to make sure it was installed from
> correct source.
> 
> I looked at Makefile.PL for 1.61 source at CPAN and it does NOT have CPAN
> listed in PREREQ_PM or in %FallbackPrereqs. Might be worth adding to it...
> 
> 
> -- Original Message --
> Received: Fri, 03 May 2024 11:30:22 AM EDT
> From: Bruce Schuck 
> To: GnuCash User Cc: Kalpesh Patel
> , Fred Tydeman 
> Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03
> 
> > On May 2, 2024 at 23:44:53 EDT Kalpesh wrote:
> > 
> > > That is possible that there is no depend target in the make file. 
> > > Just curious how you built/get the make file for it?
> > 
> > Kalpesh,
> > 
> > The old school method of installing Perl modules.
> > 
> > The makefile is created by running "perl Makefile.PL". Then one would 
> > execute "make", "make test", and "make install". When I first started 
> > using Perl, there was no "cpan" or "cpanm" that automated much of the 
> > process. Fetching prerequisites and installing them is one of the major 
> > reasons for using cpan/cpanm. It's been such a long time since I had 
> > used the OG module install method that I forgot that it does not have a 
> > mechanism for fetching and installing dependencies. Back in the day the 
> > dependencies were typically noted in the module's README file and one 
> > had to manually retrieve and install them.
> > 
> > This method is definitely not for Perl novices. These days it's more for 
> > those who display masochistic tendencies...
> > 
> > Bruce S.
> 
> 


___
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] Finance::Quote PreRelease 1.61_03

[Kalpesh Patel]

Hi Bruce,

Indeed it is old school way to generate make file and install Perl modules. I
do recall doing so on many iterations since working with Perl 5.10 days when
CPAN was in its infancy for couple of Financial Houses I was employed at that
were big time into Perl. Especially trying to build SSLeay module with
OpneSSL, z-lib (or was it libz) and other dependent libraries' headers on SUN
Ultra Sparc 2's back then. What a nightmare (or fun) that was...  

Anyways I was more interested in making sure that Fred had generated correctly
and not adopted from somewhere else that might be somewhat bastardized one. I
also got thrown off a bit in that when I cloned the repo for 1.61_03, it
didn't have Makefile.PL so it was more to make sure it was installed from
correct source.

I looked at Makefile.PL for 1.61 source at CPAN and it does NOT have CPAN
listed in PREREQ_PM or in %FallbackPrereqs. Might be worth adding to it...


-- Original Message --
Received: Fri, 03 May 2024 11:30:22 AM EDT
From: Bruce Schuck 
To: GnuCash User Cc: Kalpesh Patel
, Fred Tydeman 
Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03

> On May 2, 2024 at 23:44:53 EDT Kalpesh wrote:
> 
> > That is possible that there is no depend target in the make file. 
> > Just curious how you built/get the make file for it?
> 
> Kalpesh,
> 
> The old school method of installing Perl modules.
> 
> The makefile is created by running "perl Makefile.PL". Then one would 
> execute "make", "make test", and "make install". When I first started 
> using Perl, there was no "cpan" or "cpanm" that automated much of the 
> process. Fetching prerequisites and installing them is one of the major 
> reasons for using cpan/cpanm. It's been such a long time since I had 
> used the OG module install method that I forgot that it does not have a 
> mechanism for fetching and installing dependencies. Back in the day the 
> dependencies were typically noted in the module's README file and one 
> had to manually retrieve and install them.
> 
> This method is definitely not for Perl novices. These days it's more for 
> those who display masochistic tendencies...
> 
> Bruce S.


___
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] Finance::Quote PreRelease 1.61_03

[John Ralls]

> On May 3, 2024, at 10:35 AM, Bruce Schuck  wrote:
> 
> On 5/3/24 9:58 AM, John Ralls wrote:
> 
>> It’s normal for Linux distros to package perl modules. Fedora’s is 
>> https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/
>> .
>> Note that there are back ports of 1.61 for Fedoras 38, 39, and 40.
> 
> John,
> 
> I am well aware of that. In this message yesterday 
> (https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111771.html) I 
> suggested that Fred install perl-CPAN and also maybe perl-App-cpanminus.
> 
> What threw me is one of Fred's earlier comments where he stated
> something like "I am now able to get quotes *again*". "Again" being the
> operative word, as it sounded like he would have already had F::Q
> installed, which typically means CPAN and/or CPAN Minus is already
> installed. Or maybe I got mixed up with another response from someone else.
> 
>> Debian/Ubuntu also package F::Q 
>> https://packages.ubuntu.com/search?keywords=libfinance-quote-perl 
>> 
>> but are nowhere near as conscientious about keeping up with your
>> releases so patience won’t work for their users. Keeping out of the
>> way of the package manager is still a good practice so I think their
>> users should also point cpan at a user-space directory.
> 
> Again, not new to me. My primary desktop at home has been an Ubuntu LTS 
> release since 12.04LTS. I've been alternating between in place upgrades and 
> doing a fresh install and restoring what I need from backups. And the fresh 
> install path means I first have to install the Canonical CPAN and CPAN Minus 
> before I install the modules I use regularly. At home I go back and forth WRT 
> installing using sudo or using local::lib to install modules outside of the 
> normal @INC path. On my work macbook, I install all extra modules in 
> directories under $HOME.
> 
> I've been around Perl a *long* time. Hell, if you grab the Perl source code 
> from Git, I'm in the list of authors…

Bruce,

I didn’t mean to impugn your experience, I’m just trying to keep things clear 
for the less experienced users who read this.

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] Finance::Quote PreRelease 1.61_03

[Bruce Schuck]

On 5/3/24 9:58 AM, John Ralls wrote:

It’s normal for Linux distros to package perl modules. Fedora’s is 
https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/

.
Note that there are back ports of 1.61 for Fedoras 38, 39, and 40.


John,

I am well aware of that. In this message yesterday 
(https://lists.gnucash.org/pipermail/gnucash-user/2024-May/111771.html) 
I suggested that Fred install perl-CPAN and also maybe perl-App-cpanminus.


What threw me is one of Fred's earlier comments where he stated
something like "I am now able to get quotes *again*". "Again" being the
operative word, as it sounded like he would have already had F::Q
installed, which typically means CPAN and/or CPAN Minus is already
installed. Or maybe I got mixed up with another response from someone else.

Debian/Ubuntu also package F::Q 
https://packages.ubuntu.com/search?keywords=libfinance-quote-perl 


but are nowhere near as conscientious about keeping up with your
releases so patience won’t work for their users. Keeping out of the
way of the package manager is still a good practice so I think their
users should also point cpan at a user-space directory.


Again, not new to me. My primary desktop at home has been an Ubuntu LTS 
release since 12.04LTS. I've been alternating between in place upgrades 
and doing a fresh install and restoring what I need from backups. And 
the fresh install path means I first have to install the Canonical CPAN 
and CPAN Minus before I install the modules I use regularly. At home I 
go back and forth WRT installing using sudo or using local::lib to 
install modules outside of the normal @INC path. On my work macbook, I 
install all extra modules in directories under $HOME.


I've been around Perl a *long* time. Hell, if you grab the Perl source 
code from Git, I'm in the list of authors...


You're across the bay, one of these days we should meet up for a beer.

Regards,

Bruce S.
___
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] Finance::Quote PreRelease 1.61_03

[John Ralls]

> On May 2, 2024, at 09:01, Bruce Schuck  wrote:
> 
>> This is Fedora Linux 40 (the most recent)
> 
> I find it odd that your system *ever* had Finance::Quote installed,

Bruce,

It’s normal for Linux distros to package perl modules. Fedora’s is 
https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/. 
Note that there are back ports of 1.61 for Fedoras 38, 39, and 40. 

They also package cpan as https://packages.fedoraproject.org/pkgs/perl-CPAN/.

I suggest that he best course for Fedora users who want to get ahead of their 
distro for selected perl packages is to set up cpan to install to a directory 
in $HOME and use $PERL5LIB to put it at the top of @INC. That avoids contention 
with their package manager and for the most part leaves the dependencies to the 
distro to maintain. For most users a few days of patience will get them 

Debian/Ubuntu also package F::Q 
https://packages.ubuntu.com/search?keywords=libfinance-quote-perl but are 
nowhere near as conscientious about keeping up with your releases so patience 
won’t work for their users. Keeping out of the way of the package manager is 
still a good practice so I think their users should also point cpan at a 
user-space directory.

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] Finance::Quote PreRelease 1.61_03

[Bruce Schuck]

On May 2, 2024 at 23:44:53 EDT Kalpesh wrote:

That is possible that there is no depend target in the make file. 
Just curious how you built/get the make file for it?


Kalpesh,

The old school method of installing Perl modules.

The makefile is created by running "perl Makefile.PL". Then one would 
execute "make", "make test", and "make install". When I first started 
using Perl, there was no "cpan" or "cpanm" that automated much of the 
process. Fetching prerequisites and installing them is one of the major 
reasons for using cpan/cpanm. It's been such a long time since I had 
used the OG module install method that I forgot that it does not have a 
mechanism for fetching and installing dependencies. Back in the day the 
dependencies were typically noted in the module's README file and one 
had to manually retrieve and install them.


This method is definitely not for Perl novices. These days it's more for 
those who display masochistic tendencies...


Bruce S.
___
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] New account

[Stan Brown (using GC 4.14)]

On 2024-05-01 11:05, Gary Cook wrote:
> When I try to create a new account under "Expenses:Auto", no new window
> opens, it just freezes. The same happens if I try "Actions/New Account"
> or if I select the "New" icon in the tool bar.

Gary, please remember always to say which version of GnuCash you're
using, and which operation system and version. That's _especially_
important when you're reporting a problem.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com/
___
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] Account Hierarchy

[Patrick Skelton]

Hi,

I am about to structure a new set of accounts for a business. GnuCash uses
a hierarchy, which I am currently trying to decide upon. Two
part-hierarchies come to mind:

*FIRST*

Sales

Shop A

Product 1

Product 2

Shop B

Product 1

Product 2


*SECOND*

Sales

Product 1

Shop A

Shop B

Product 2

Shop A

Shop B


The first would make it easy to see sales for each shop but harder to find
out the sales for each product. The second would make it easy to see sales
for each product but harder to find out the sales for each shop.

Both of these seem like reasonable questions to be able to ask of the
accounts. How do I choose which hierarchy to go with and is there any way I
can answer both of these questions?

Any advice would be most welcome as I am no accounting expert and have only
basic knowledge of GnuCash.

Kind wishes - Patrick
___
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] New account

[Gary Cook]

When I try to create a new account under "Expenses:Auto", no new window 
opens, it just freezes. The same happens if I try "Actions/New Account" 
or if I select the "New" icon in the tool bar.


Thanks,
Gary

___
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] Export Transactions to CSV - Exclude Assets entry

[Wesley Werner]

Hello everyone.

I recently upgraded to GnuCash 5.6, when I export all transactions to CSV
it writes both sides to the file, where before it only wrote the side of
the account I chose within the export dialog.

To demonstrate,
1. File -> Export -> Transactions to CSV
2. Pick *only* Assets:Savings Account

The CSV contain two rows for each transaction, one from "Assets:Savings
Account" (-$13) and a second to "Expenses:Groceries" ($13). Prior to 5.6 it
would only export the "Expenses:Groceries" row.

I import this CSV into other programs for budgeting purposes, and since the
two rows balance each other out it is causing unexpected totals.

I tried only selecting the Expense sub-accounts in the export dialog. The
outcome is the same. I also could not find any relevant preference setting
to affect this.

I don't really want to revert to 5.5, as I found it's process did not shut
down on Windows 11, causing lots of orphaned exe processes to hang around
and I got tired of mopping these up manually. Ideally I'd like to get
exporting to CSV to only honor the account I chose in the export dialog.
Hoping this is just something silly I missed?

Windows 11 Pro
Version 23H2
GnuCash 5.6 for Windows 64bit, Build ID: 5.6+(2024-03-30)

--
Regards
Wesley Werner
___
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.