Re: [GNC] Discount / Coupon question - How to apply?

[Adrien Monteleone]

Alan,

Create a manual transaction between the desired expense account and 
Accounts Receivable. (Debit the Expense, Credit AR)


Then right click the transaction after committing it, and choose 'Assign 
as Payment'.


In the Process Payment window, select the invoice you want to apply this 
to and any other relevant info, then commit the payment.


Regards,
Adrien

On 12/30/23 6:16 PM, Alan Johnson via gnucash-user wrote:

I have a customer that I have created an invoice for.

How do I create a coupon/discount to pay for the invoice and charge it
to a marketing expense? I tried to choose the expense account but it
will only allow me to use income or liability accounts.


___
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] Discount / Coupon question - How to apply?

[Alan Johnson via gnucash-user]

Hello,

I have a customer that I have created an invoice for. 

How do I create a coupon/discount to pay for the invoice and charge it
to a marketing expense? I tried to choose the expense account but it
will only allow me to use income or liability accounts.

Thanks,

Alan


smime.p7s
Description: S/MIME cryptographic signature
___
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] Import Matcher Comments and Questions

[Dale Alspach]

Version: 5.5
Build ID: Flathub 5.5
Finance::Quote: 1.58
linux mint 21.1

TIAA is the source. format is Intuit/Quicken .qfx
The relevant account structure was implicit in what I wrote. It
approximates the structure of the TIAA accounts. More explicitly:
Asset Account 1-> employer contract A -> branch employer contract
subaccount A -> various mutual funds
Asset Account 1-> employer contract A -> branch employer contract
subaccount B -> restricted investments
Asset Account 1-> employer contract A-> branch IRA -> branch for brokerage
account-> stocks, ETFs
Asset Account 1-> employer contract A-> branch IRA -> branch for mutual
funds
Asset Account 1-> employer contract B ->  branch employer contract
subaccount C -> various mutual funds
Asset Account 1-> employer contract B -> branch employer contract
subaccount D -> restricted investments
Asset Account 1-> brokerage account  -> stocks, ETFs
IRA - > various mutual funds
Asset Account 2 -> other employer contract -> lifecycle fund of funds

"employer contract" indicates this is tax deferred so dividends, capital
gains, etc. are not currently taxable, RMDs are taxed
Asset Account 1-> brokerage account is not tax deferred
TIAA includes contract labels in the .qfx that drill down to the container
holding the actual securities, e.g.,  Asset Account 1-> employer contract A
-> branch employer contract subaccount A.
This is the "more detailed information" that I mentioned in the post.

Is this what you wanted?

Dale

On Sat, Dec 30, 2023 at 2:16 PM David Carlson 
wrote:

> It would be helpful to know what release pf GnuCash you are on, which
> import format you are using, and possibly which financial institution is
> providing the import files.
>
> If there is other informstion, possibly if you are using a certain report
> or have a specific accounting structure, that may slso help.  Sorry about
> my fat finger problem, my smartphone keyboard has tiiny keys and my cat is
> tryong to help me.
>
>
>
> On Sat, Dec 30, 2023, 12:18 PM Dale Alspach  wrote:
>
>> Recently there was some restructuring of some of my retirement accounts
>> (still under control of my former employer). This caused problems with
>> importing because the parent accounts of the securities were altered.
>> This led to a lot of questions from the importer. This entailed a tedious
>> process of selecting the correct "new" account. One particular difficulty
>> is that the same security may be used in more than one branch of the
>> account tree. Fortunately the importer actually supplies some detailed
>> information which greatly helps identify the correct branch.
>>
>> 1. I discovered that the importer does not require uniqueness. That is,
>> multiple accounts in the import file can be mapped to the same gnucash
>> account. My accounting is strictly personal so the restructuring just
>> meant
>> creating an appropriate branch for each investment and reparenting the
>> account. The nonuniqueness allowed me to point transactions corresponding
>> to the old and new versions of the investment to the new one. *Thus for me
>> the nonuniqueness is a desirable feature.*
>>
>> 2. The account selection process seems to make some unwarranted
>> assumptions
>> that resulted in extra steps and in some cases a difficult to resolve
>> ambiguity.
>> i. After I selected one branch for a matching account, the importer kept
>> suggesting that same branch for all subsequent selections. This resulted
>> in
>> extra steps to select the correct branch. It  would have been better for
>> the importer to suggest the branch of the last selection and not the very
>> first one.
>> ii. The ambiguity arose when the importer asked what income account to
>> associate with a security. In my setup, the assignment of any income
>> attributable to an investment depends on which branch of the accounts this
>> particular investment occurs. (taxable or not?, IRA, 403b, brokerage?) The
>> name/symbol of the security does not uniquely determine the branch. What I
>> needed was that more detailed information that appears when the account
>> corresponding to the investment is selected.
>>
>> Before I add a formal request for enhancement, I would be interested in
>> knowing whether others have the same or similar concerns. I checked
>> bugzilla and did not find anything.
>> Dale
>> ___
>> 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] Finance::Quote v1.59 Tentative Release Date

[Bruce Schuck]

Happy Holidays everyone.

It's short notice, but I intend to push Finance::Quote v1.59 to CPAN 
tomorrow, December 31, 2023.


The changes from v1.58 to v1.59 are:

* Fixed XETRA, Tradegate and SInvestor after webpage was restructured - 
Issue #350


* Fidelity.pm temporarily disabled - Issue #346

* Finanzpartner.pm - Fix scraper, did not work if quote was higher than
  the previous day's quote.

* GoogleWeb.pm - Updated to retrieve mutual fund and BATS prices - Issue
  #355

* BSEIndia.pm - Updated to use standardised data file at URL
  https://www.bseindia.com/download/BhavCopy/Equity
  BSE_EQ_BHAVCOPY_{DDMM}.ZIP
  Eliminated need to use temp folders by storing standardized file
  data from URL into a variable.
  Updated names of source fields to conform to those in the
  standardized data file

* IndiaMutual.pm - Eliminated need to use temp folders by storing
  nav file data from URL into a variable.

* TMX.pm - Correct a self-reference in documentation - PR #345

* Stooq.pm - Added new currencies and a fix for commodities' prices

* YahooWeb.pm - Skip rows in the price table where the prices ar "-".
  This seems to happen sometimes with TIAA (and perhaps other)
  securities including TILIX and QCILIX

* TSP.pm - Was not returning hash when the HTTP GET failed completely
  or the content did not contain the expected CSV file. - Issue #338

* BSEIndia.pm - Removed print when symbol not found - Issue #335

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] Import Matcher Comments and Questions

[David Cousens]

Dale, 

The assignment of an internal GnuCash account to an external account during
import has a couple of levels. If a transfer account is specified in the import
record, then the first time that account description is encountered the external
name has to be assigned to a specific internal GnuCash account. 

If there is no explicit specification of an account in the import record, then a
probabalistic (Bayesian) procedure tries to assign an account on the basis of
what information is present in the import record and how well it matches
information in reords where the second account was manually assigned during the
import of previous similar records. There is also an older non-Bayesian matching
procedure (Edit->Preferences->Import->use bayesian matching) which is optionally
available but is generally less successful at providing a good match than the
Bayesian procedure.

Where an account structure is changed, the Bayesian procedure will "remember"
any assignment made prior to the restructure as the probability tables it has
accumulated and used to make the assignment will only change very slowly as
records with assignments to the new account structure are made manually during
import. If you import records without manually changing the assigned account
during the import matching process and change the account assigned after import
in the register, the probability tables do not change at all as that data is
only stored during the final stage of the import procedure.

It is possible to edit the data on which the account assignment on import is
made using Tools->Import Map Editor but this requires some considerable
understanding of the import matching process to avoid changing the wrong data.
There is not a lot of guidance about how to do this however. There have been
some historical posts in the user list which may help if you search for them

Alternatively you can remove all the data used by the matching procedure and
retrain the matcher on subsequent imports but that is a drastic solution and
will affect all accounts that are matched on import not just the ones which
changed in the restructure.

David Cousens


On Sat, 2023-12-30 at 12:17 -0600, Dale Alspach wrote:
> Recently there was some restructuring of some of my retirement accounts
> (still under control of my former employer). This caused problems with
> importing because the parent accounts of the securities were altered.
> This led to a lot of questions from the importer. This entailed a tedious
> process of selecting the correct "new" account. One particular difficulty
> is that the same security may be used in more than one branch of the
> account tree. Fortunately the importer actually supplies some detailed
> information which greatly helps identify the correct branch.
> 
> 1. I discovered that the importer does not require uniqueness. That is,
> multiple accounts in the import file can be mapped to the same gnucash
> account. My accounting is strictly personal so the restructuring just meant
> creating an appropriate branch for each investment and reparenting the
> account. The nonuniqueness allowed me to point transactions corresponding
> to the old and new versions of the investment to the new one. *Thus for me
> the nonuniqueness is a desirable feature.*
> 
> 2. The account selection process seems to make some unwarranted assumptions
> that resulted in extra steps and in some cases a difficult to resolve
> ambiguity.
> i. After I selected one branch for a matching account, the importer kept
> suggesting that same branch for all subsequent selections. This resulted in
> extra steps to select the correct branch. It  would have been better for
> the importer to suggest the branch of the last selection and not the very
> first one.
> ii. The ambiguity arose when the importer asked what income account to
> associate with a security. In my setup, the assignment of any income
> attributable to an investment depends on which branch of the accounts this
> particular investment occurs. (taxable or not?, IRA, 403b, brokerage?) The
> name/symbol of the security does not uniquely determine the branch. What I
> needed was that more detailed information that appears when the account
> corresponding to the investment is selected.
> 
> Before I add a formal request for enhancement, I would be interested in
> knowing whether others have the same or similar concerns. I checked
> bugzilla and did not find anything.
> Dale
> ___
> 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:

Re: [GNC] Ver 5.5 for Windows import issue

[David Carlson]

Is it possible that any of the settings on the Edit Preferences Import page
have changed from your previous settings?

On Sat, Dec 30, 2023 at 2:11 PM Gyle McCollam  wrote:

> Just tried importing information into my checking account and it exhibits
> the same strange behavior I mentioned with my cc account (different
> financial institutions).  Namely, it wants to add all the transactions as
> new, but when I click on (c)lear it finds the matching transaction.  I
> don't know what changed in the importer, but it was functioning correctly
> before the upgrade to 5.5.  However, going back to 5.3 doesn't solve the
> issue.  It was working fine for years and I thought the problem was with
> Citi Bank, but now that it is functioning the same with a different
> institution, I think it must be GC related.  I'll be curious, now that we
> are at the end of a month, if other users are experiencing the same issue.
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* David Carlson 
> *Sent:* Saturday, December 23, 2023 4:36 PM
> *To:* Gyle McCollam 
> *Cc:* Gnucash Users 
> *Subject:* Re: [GNC] Ver 5.5 for Windows import issue
>
> There is a bit of a learning curve with the process of importing files
> into GnuCash, and a major part of it is learning how GnuCash reacts to the
> particular text that the financial institution uses in the file.  I have
> found that I need to treat files from different banks quite differently.
> One FI even reverses the signs of purchases vs payments compared to the
> rest of the world (even from other merchants using the same credit card
> servicer) in their OFX files.
>
> OFX/QFX, and QIF files all use the generic importer for the bulk of the
> import process and CSV imports use a different process depending the
> purpose of the import.
>
> If you find that there are any quirks that appear to be wrong or strange
> come back here with specific questions.
>
>
>
> On Sat, Dec 23, 2023 at 12:37 PM Gyle McCollam  wrote:
>
> When I reached the end of the import file and continued to the
> reconciliation it eliminated all the duplicates and left only the original
> transactions.  So, I don't know what was going on, but the end result was
> normal?
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* David Carlson 
> *Sent:* Saturday, December 23, 2023 12:25 PM
> *To:* Gyle McCollam 
> *Cc:* Gnucash Users 
> *Subject:* Re: [GNC] Ver 5.5 for Windows import issue
>
> Just for the record, was that a qif import or ofx?
>
>
>
> On Sat, Dec 23, 2023, 11:09 AM Gyle McCollam  wrote:
>
> Just downloaded 5.5 for win 11.  Tried to import my cc info and the import
> wanted to add EVERY transaction as new.  When I clicked on (c)lear it found
> the matching transaction, but still was importing as new, which caused it
> to double everything.  I am reinstalling 5.3 until I can find out what is
> wrong.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
> ___
> 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.
>
>
>
> --
> David Carlson
>


-- 
David Carlson
___
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] Windows Customer Report Crash

[John Ralls]

> On Dec 30, 2023, at 11:08 AM, Mark at Lorimark  
> wrote:
> 
> Hi,
> 
> I have a Windows 5.5 installed and ran in to a crash on opening customer 
> report.  I then created a new data file (sql) and created a customer, created 
> an AR account, created an invoice for said customer, and for one thing is 
> said it could not write back to the database when trying to post the invoice, 
> but when trying to open a specific 'customer report' from the 'customers 
> list' screen, it crashes.
> 
> I would like to continue testing so that I can prepare a comprehensive 
> report, or/and fix it.
> 
> Where I find the logs or crashlogs for windows.

That's bug https://bugs.gnucash.org/show_bug.cgi?id=799183.

GnuCash 5.5 reports are broken on Windows. I suggest that you use GnuCash 5.4 
instead until I can get WebKitGtk fixed and do a new Windows build.

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] Import Matcher Comments and Questions

[David Carlson]

It would be helpful to know what release pf GnuCash you are on, which
import format you are using, and possibly which financial institution is
providing the import files.

If there is other informstion, possibly if you are using a certain report
or have a specific accounting structure, that may slso help.  Sorry about
my fat finger problem, my smartphone keyboard has tiiny keys and my cat is
tryong to help me.



On Sat, Dec 30, 2023, 12:18 PM Dale Alspach  wrote:

> Recently there was some restructuring of some of my retirement accounts
> (still under control of my former employer). This caused problems with
> importing because the parent accounts of the securities were altered.
> This led to a lot of questions from the importer. This entailed a tedious
> process of selecting the correct "new" account. One particular difficulty
> is that the same security may be used in more than one branch of the
> account tree. Fortunately the importer actually supplies some detailed
> information which greatly helps identify the correct branch.
>
> 1. I discovered that the importer does not require uniqueness. That is,
> multiple accounts in the import file can be mapped to the same gnucash
> account. My accounting is strictly personal so the restructuring just meant
> creating an appropriate branch for each investment and reparenting the
> account. The nonuniqueness allowed me to point transactions corresponding
> to the old and new versions of the investment to the new one. *Thus for me
> the nonuniqueness is a desirable feature.*
>
> 2. The account selection process seems to make some unwarranted assumptions
> that resulted in extra steps and in some cases a difficult to resolve
> ambiguity.
> i. After I selected one branch for a matching account, the importer kept
> suggesting that same branch for all subsequent selections. This resulted in
> extra steps to select the correct branch. It  would have been better for
> the importer to suggest the branch of the last selection and not the very
> first one.
> ii. The ambiguity arose when the importer asked what income account to
> associate with a security. In my setup, the assignment of any income
> attributable to an investment depends on which branch of the accounts this
> particular investment occurs. (taxable or not?, IRA, 403b, brokerage?) The
> name/symbol of the security does not uniquely determine the branch. What I
> needed was that more detailed information that appears when the account
> corresponding to the investment is selected.
>
> Before I add a formal request for enhancement, I would be interested in
> knowing whether others have the same or similar concerns. I checked
> bugzilla and did not find anything.
> Dale
> ___
> 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] Ver 5.5 for Windows import issue

[Gyle McCollam]

Just tried importing information into my checking account and it exhibits the 
same strange behavior I mentioned with my cc account (different financial 
institutions).  Namely, it wants to add all the transactions as new, but when I 
click on (c)lear it finds the matching transaction.  I don't know what changed 
in the importer, but it was functioning correctly before the upgrade to 5.5.  
However, going back to 5.3 doesn't solve the issue.  It was working fine for 
years and I thought the problem was with Citi Bank, but now that it is 
functioning the same with a different institution, I think it must be GC 
related.  I'll be curious, now that we are at the end of a month, if other 
users are experiencing the same issue.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: David Carlson 
Sent: Saturday, December 23, 2023 4:36 PM
To: Gyle McCollam 
Cc: Gnucash Users 
Subject: Re: [GNC] Ver 5.5 for Windows import issue

There is a bit of a learning curve with the process of importing files into 
GnuCash, and a major part of it is learning how GnuCash reacts to the 
particular text that the financial institution uses in the file.  I have found 
that I need to treat files from different banks quite differently.  One FI even 
reverses the signs of purchases vs payments compared to the rest of the world 
(even from other merchants using the same credit card servicer) in their OFX 
files.

OFX/QFX, and QIF files all use the generic importer for the bulk of the import 
process and CSV imports use a different process depending the purpose of the 
import.

If you find that there are any quirks that appear to be wrong or strange come 
back here with specific questions.



On Sat, Dec 23, 2023 at 12:37 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
When I reached the end of the import file and continued to the reconciliation 
it eliminated all the duplicates and left only the original transactions.  So, 
I don't know what was going on, but the end result was normal?


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: David Carlson 
mailto:david.carlson@gmail.com>>
Sent: Saturday, December 23, 2023 12:25 PM
To: Gyle McCollam mailto:gmccol...@live.com>>
Cc: Gnucash Users mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Ver 5.5 for Windows import issue

Just for the record, was that a qif import or ofx?



On Sat, Dec 23, 2023, 11:09 AM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Just downloaded 5.5 for win 11.  Tried to import my cc info and the import 
wanted to add EVERY transaction as new.  When I clicked on (c)lear it found the 
matching transaction, but still was importing as new, which caused it to double 
everything.  I am reinstalling 5.3 until I can find out what is wrong.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com>
   email
___
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.


--
David Carlson
___
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] Windows Customer Report Crash

[Mark at Lorimark]

Hi,

I have a Windows 5.5 installed and ran in to a crash on opening customer 
report.  I then created a new data file (sql) and created a customer, 
created an AR account, created an invoice for said customer, and for one 
thing is said it could not write back to the database when trying to 
post the invoice, but when trying to open a specific 'customer report' 
from the 'customers list' screen, it crashes.


I would like to continue testing so that I can prepare a comprehensive 
report, or/and fix it.


Where I find the logs or crashlogs for windows.

--
~mark petryk
~w:http://www.lorimarksolutions.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] Thoughts on Online Quotes documentation

[orange]

   I built GNUcash a couple of years back on a Raspberry pi, got the
   quotes working IIRC (I had definitely installed Finance::Quote and even
   applied an update to a new version), started trying to learn how to use
   it but ended up not doing anything much with it all for various time
   related reasons.

   I've recently built the 5.4 version to have another try at adopting
   this but the quotes gives me an error.  From what I can gather, things
   have moved on since my last attempt and quotes via Yahoo are no longer
   available.  So, I'm looking for what I need to do to get this all
   working (primarily with UK listed stocks).

   I haven't found a simple guide to follow and, as per Jim's
   observations, the wiki just doesn't seem to cover the required
   information and still talks about Yahoo.  It isn't helping at all with
   my level of confusion!

   A revamp of the documentation in this area, with a simple guide to the
   current situation and what is required, would be greatly appreciated
   and would be a great help to adoption by newbies like myself.

   I would like to thank Jim for the suggestions and all those involved in
   making GNUcash available.

   All the best
   Simon
___
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] Import Matcher Comments and Questions

[Dale Alspach]

Recently there was some restructuring of some of my retirement accounts
(still under control of my former employer). This caused problems with
importing because the parent accounts of the securities were altered.
This led to a lot of questions from the importer. This entailed a tedious
process of selecting the correct "new" account. One particular difficulty
is that the same security may be used in more than one branch of the
account tree. Fortunately the importer actually supplies some detailed
information which greatly helps identify the correct branch.

1. I discovered that the importer does not require uniqueness. That is,
multiple accounts in the import file can be mapped to the same gnucash
account. My accounting is strictly personal so the restructuring just meant
creating an appropriate branch for each investment and reparenting the
account. The nonuniqueness allowed me to point transactions corresponding
to the old and new versions of the investment to the new one. *Thus for me
the nonuniqueness is a desirable feature.*

2. The account selection process seems to make some unwarranted assumptions
that resulted in extra steps and in some cases a difficult to resolve
ambiguity.
i. After I selected one branch for a matching account, the importer kept
suggesting that same branch for all subsequent selections. This resulted in
extra steps to select the correct branch. It  would have been better for
the importer to suggest the branch of the last selection and not the very
first one.
ii. The ambiguity arose when the importer asked what income account to
associate with a security. In my setup, the assignment of any income
attributable to an investment depends on which branch of the accounts this
particular investment occurs. (taxable or not?, IRA, 403b, brokerage?) The
name/symbol of the security does not uniquely determine the branch. What I
needed was that more detailed information that appears when the account
corresponding to the investment is selected.

Before I add a formal request for enhancement, I would be interested in
knowing whether others have the same or similar concerns. I checked
bugzilla and did not find anything.
Dale
___
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 with aqbanking

[john]

They all do. It's just broken in 5.5 because of a library mismatch, see the 
GnuCash 5.5 Error Message thread, in particular the work-around in 
https://lists.gnucash.org/pipermail/gnucash-user/2023-December/110194.html.

Regards,
John Ralls


> On Dec 28, 2023, at 13:08, Claudia Turner via gnucash-user 
>  wrote:
> 
> Is it possible to download a Windows executable that already has aqbanking 
> compiled into it?
> 
> CT
> ___
> 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] Strange bug in Reports after upgrading to 5.4

[R Losey]

On Sat, Dec 30, 2023 at 3:10 AM Leo Braga via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> I'm a long time home user (for personal finances) and I was "stuck" in
> 2.6.12 for a long time, until deciding to upgrade to 5.4 last month.
> Everything was looking good, but now I found a very strange bug in my
> Reports (Expense or Income Charts to be precise).
>
> What happens is that some entries dated the 1st of the month are reported
> in the previous month! So an entry dated Nov 1st is computed in the Expense
> Over Time report for October, for instance.
>
> I don't think this is affecting all entries dated on the 1st of a month,
> but maybe yes? What I tested is that if I go to such an entry, change it to
> the 2nd day of the month for instance, *then change back to the 1st*, and
> then refresh the report, the reporting is now correct!
>
>  Any help would be greatly appreciated, as it will be crazy to go through
> all entries for 2023 to fix this (for 2022 and earlier I have different
> back-ups and thus don't care so much).
>
> Thanks,
> Leo.
>



Didn't we just see this? And there was a good response as well.


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] GUID Register Codes

[G R Hewitt]

*note, while there are many ways to view the tables in one of the SQL
backends, an easy one is to use the SQLite manager plugin for Firefox
with the SQLite3 backend. (it is an older type plugin, so I keep a copy
of Waterfox Classic around to use it.)

Or you could use DBeaver database tool - Win Mac and Linux Free versions
https://dbeaver.io/
Very useful and covers a wide range of databases.

On Sat, 30 Dec 2023 at 04:09, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> That's how I would do it with the XML backend too.
>
> If you are crafty with scripts, you can likely create a table/file,
> mapping the account names to GUIDs for future reference.
>
> or,
>
> Switch to one of the SQL backends and write a query, or just examine the
> "accounts" table directly. Of course, in this case, you have the added
> complication that only the end leaf account names are saved in plain
> text. But the 'parent GUID' is also stored, so it is possible to sort
> out similarly named accounts.
>
> *note, while there are many ways to view the tables in one of the SQL
> backends, an easy one is to use the SQLite manager plugin for Firefox
> with the SQLite3 backend. (it is an older type plugin, so I keep a copy
> of Waterfox Classic around to use it.)
>
> Regards,
> Adrien
>
> On 12/29/23 6:56 PM, Jim DeLaHunt wrote:
> > Stephen:
> >
> > I can't answer your question fully, but I can give you some insight.
> >
> > "GUID" stands for "Globally Unique Identifier". Each GUID is a large
> > number, which is generated in such a way that it is highly likely to be
> > different than any other GUID generated on any computer at any time
> > according to the same rules. On the other hand, the same GUID value
> > might show up in multiple places. Sometimes software developers generate
> > a GUID and embed it their code, so that everyone gets a copy of the same
> > GUID value. Another name for GUID is UUID, meaning "Universally" instead
> > of "Globally".
> >
> > GUIDs are written to SQL databases, but they are not a creature of SQL.
> > GnuCash also generates them when the book file is stored in XML form (as
> > a ".gnucash" file).   And, because they are globally unique, it is
> > likely that your book contains different GUIDs than anybody else's book.
> > Each account has a GUID associated, but there is no reason to believe
> > that anyone else will have the same GUIDs for their accounts as you have
> > for yours.
> >
> > I don't have an easy way to find out which GUID corresponds what account
> > or other object. My way of doing that is to save my book as an XML file,
> > open the file with a text editor, and search for the GUID value.
> > Somewhere in the file will be data which defines the account, and it
> > will include the GUID value and account name in close proximity. But
> > that may or may not be the best way for you to proceed.
>
> ___
> 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] GnuCash with aqbanking

[Claudia Turner via gnucash-user]

Is it possible to download a Windows executable that already has aqbanking 
compiled into it?

CT
___
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] Strange bug in Reports after upgrading to 5.4

[Leo Braga via gnucash-user]

Hi,

I'm a long time home user (for personal finances) and I was "stuck" in
2.6.12 for a long time, until deciding to upgrade to 5.4 last month.
Everything was looking good, but now I found a very strange bug in my
Reports (Expense or Income Charts to be precise).

What happens is that some entries dated the 1st of the month are reported
in the previous month! So an entry dated Nov 1st is computed in the Expense
Over Time report for October, for instance.

I don't think this is affecting all entries dated on the 1st of a month,
but maybe yes? What I tested is that if I go to such an entry, change it to
the 2nd day of the month for instance, *then change back to the 1st*, and
then refresh the report, the reporting is now correct!

 Any help would be greatly appreciated, as it will be crazy to go through
all entries for 2023 to fix this (for 2022 and earlier I have different
back-ups and thus don't care so much).

Thanks,
Leo.
___
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] GUID Register Codes

[Jim DeLaHunt]

On 2023-12-29 22:53, Stephen wrote:
…Having the GUID … could have GUIDed me perhaps. I really appreciate 
y'alls help.


I saw what you did there. Bravo!
 —Jim "I am not a dad but I tell dad jokes" DeLaHunt


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