Re: [GNC] GNC used side by side with GNC Andriod

[David Carlson]

Jeff,

When you 'upgraded' your cellphone did you re-install the GnuCash Android
app or do something else?  Do you have details of what actual data may have
triggered the error or the precise error message?  Is it repeatable?  Did
you keep copies of the import files?  Have you tried to create a trace
file? - I know that is difficult in a Windows environment, and I do not
know where the instructions are buried, I think they are in the website FAQ
somewhere.

On Sat, Jan 29, 2022 at 1:22 AM Jeff  wrote:

> I know that they are entirely separate and discrete applications.  So no
> lambasting please.
>
> I have successfully imported more qif files than I care to count from
> Android to GNC up until I "upgraded" my cell phone.  Great cooperation
> between you and the developers of the Android version.  Pat on many
> backs of both development teams.
>
> Now I am getting an error of invalid stock entries on import into GNC,
> when there are no stock entries on the Android side  ( I have looked at
> the qif file and there are no stock exchanges, nor do I own or sell sell
> stocks yet).  Only day to day cash, bank, or credit card transactions.
> I'll be flipped if I can find a stock entry in the Android qif files.
>
> Has anyone else encountered this or a similar issue?
>
> --
> --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.
>


-- 
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
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 properly import a csv with the correct settings.

[Liz]

On Thu, 27 Jan 2022 22:41:41 -0500
Glenn Fowler  wrote:

> It is.
> 
> FYI the list archives are here:
> https://lists.gnucash.org/pipermail/gnucash-user/
> 
> You'll see this thread in January 2022. Anything on the list gets
> sent to everyone subscribed to it.
> 
> 
> On Thu, Jan 27, 2022 at 10:30 PM W Velishek 
> wrote:
> 
> > Can anyone tell me if my post to this mailing list is showing up?
>


The disconnect here is seen by all users of gmail.
Gmail decides, on your behalf, that you don't need to see your posts to
a mailing list. Gmail just puts them in "Allmail".
You can either check the Allmail directory, or the Gnucash archives to
find your post.

Liz
___
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] credit card minimum payment due

[Liz]

On Fri, 28 Jan 2022 14:23:41 -0600
Adrien Monteleone  wrote:

> While formulas and variables are possible with Scheduled
> Transactions, unfortunately, they can't grab the current account
> balance. (and there are no 'if:then' logic functions possible anyway,
> just straight math)
> 
> But you can choose to schedule the payment regardless of the balance, 
> but set it as a reminder rather than auto-create. You can then
> preview and approve the transaction to be created if it is needed.
> 
> Regards,
> Adrien

I just put in an amount in the scheduled transaction, then set it be
checked before posting, and then update the amount to the actual charge
nvolved. In my case it is a purchase on Friday night - sometimes the
purchase is not made, so I delete the transaction, and other times I
edit it to reflect the actual purchase.

Liz
___
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] Could you please add a "reset to default" function?

[Geert Janssens]

Op vrijdag 28 januari 2022 21:19:45 CET schreef Adrien Monteleone:
> That is an interesting request.
> 
> In the meantime, you could start a new file, examine the default
> preferences, and write them down. 

Unfortunately that wouldn't work. The "Preferences" are stored in GSettings 
which is per user, not per book. Your suggestion could be used to figure out 
the default book "Properties", which are accessed via File->Properties. One 
could create an additional user on the computer and peek there.

Note though that GSettings itself does have a notion of default properties. So 
you can reset your preferences by going via gsettings rather than GnuCash.

Bite Gao didn't mention the OS s/he is using and the tools to manipulate 
gsettings differ per OS:

On Windows you can use "regedit" to manipulate the GSettigns data. The GnuCash 
specific settings are stored under key
HKEY_CURRENT_USER/Software/GSettings/org/gnucash/ (for gnucash older than 4.6) 
or 
HKEY_CURRENT_USER/Software/GSettings/org/gnucash/GnuCash (starting with 
gnucash 4.7)

On linux you can use either the gsettings command line tool or the graphical 
dconf-editor. In that tool all GnuCash related settings will be found under 
/org/gnucash (<4.6) or /org/gnucash/GnuCash (>4.7).

And on MacOS it can be accessed via the defaults system, of which I don't know 
the details. I believe our wiki (wiki.gnucash.org) will have a few references 
to this.

Regards,

Geert


___
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 used side by side with GNC Andriod

[David H]

Jeff,

Yes there's a couple of threads back in Oct/Nov 2021 - basically you've got
a crap record in your file exported from the Android app and it's split in
such a manner that the importer thinks you have a stock record in your
file.  See the following for all the gory details :-)

https://lists.gnucash.org/pipermail/gnucash-user/2021-October/098158.html
https://lists.gnucash.org/pipermail/gnucash-user/2021-November/098355.html
- Solution here which says the following...

" Hi ALL EXPERTS

Ultimately I split the QIF file in Text editor and isolated the
corrupted  record. In that record out of the text in Notes (Memo)
field, the letter capital "I" somehow came to occupy the first
position in the row, Now, as per the QIF file protocol, "I" indicates
Price. Hence the importing desktop program interpreted it as "share
price" and since there was some other text after "I" , the error
message got generated. I simply removed the "I" from the first
position of the row and imported the file successfully.
(Big)-Thanks to YOU ALL for your valuable guidance and persistent
follow-up on the issue."


Cheers David H.



On Sat, 29 Jan 2022 at 17:22, Jeff  wrote:

> I know that they are entirely separate and discrete applications.  So no
> lambasting please.
>
> I have successfully imported more qif files than I care to count from
> Android to GNC up until I "upgraded" my cell phone.  Great cooperation
> between you and the developers of the Android version.  Pat on many
> backs of both development teams.
>
> Now I am getting an error of invalid stock entries on import into GNC,
> when there are no stock entries on the Android side  ( I have looked at
> the qif file and there are no stock exchanges, nor do I own or sell sell
> stocks yet).  Only day to day cash, bank, or credit card transactions.
> I'll be flipped if I can find a stock entry in the Android qif files.
>
> Has anyone else encountered this or a similar issue?
>
> --
> --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] Printing reports

[Dorel Ciornei via gnucash-user]

 If you go through the Save Config As... it should work. 
Make sure when you want to open your custom report again you do it through: 
Reports > Saved Report Configurations, select the one you want then click "Load 
Report Configuration" (the little gearbox). 
It works fine for me. 
Dorel

On Wednesday, January 26, 2022, 12:07:31 PM CST, One-time queries 
 wrote:  
 
 Back to using Gnucash after many years absence.  It seems to have changed from 
what I remember.

My  problem is that I want to set ‘Print to File’ as my default on the Print 
window.

Additionally I want to save the choices for a report so that I can print that 
report again without having to set in all the variables.  I want, for example, 
all accounts to be selected.  I want the default dates to be from the beginning 
of the previous year to the end of the previous year-  I have tried to save 
these using both Save Config and Save Config As… but when I try to open the 
report it is back to default, that is no accounts, beginning of this year and 
end of this year.

What am I missing?
___
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] Can't get Scheduled Transactions to work

[Jed Taylor]

Thanks.  Good to know it’s not just me – lol!

 

The thing about the template that is presented when editing a scheduled 
transaction is that I expected that it would start out populated to match the 
one that was selected to drive the process in the first place.  Going in to 
edit and finding a blank template is, at the very least, confusing.

 

As others are going to have to learn how to use this work.  I think the easiest 
thing to do for most reoccurring transactions since most have a piece of data 
that changes from month-to-month is to just scroll back thru the G/J or use the 
search function and then duplicate a recent transaction.  So, I dumped the ST 
approach and just made a single, complex transaction for the 1st of the month 
that posts all units’ assessments owed to their accounts.  Now the first step 
each month will be to just duplicate that.

 

 

 

From: David Carlson  
Sent: Saturday, January 29, 2022 01:31
To: Jed Taylor 
Cc: Gnucash Users 
Subject: Re: [GNC] Can't get Scheduled Transactions to work

 

Jed,

 

Scheduled transactions have had an issue for a long time that may explain part 
of what you are seeing, as it involves templates showing up unexpectedly in 
certain situations.  see https://bugs.gnucash.org/show_bug.cgi?id=741674, 
which, coincidentally is just now being addressed, but it does not explain 
everything that you are describing.  One other characteristic of scheduled 
transactions that is not obvious is the fact that when an existing transaction 
is taken as a template to create a new scheduled transaction, that transaction 
does not become a vector to use to point the editor to the template for further 
editing like transactions which have actually been created by the Since Last 
Run demon.  In other words, I can add a little information but I do not have 
enough information to solve your concern.  Sorry that I cannot help more.

 

  

 

On Fri, Jan 28, 2022 at 8:38 PM Jed Taylor mailto:vend...@offthedial.com> > wrote:

Second update -

Well, more issues.

I went into the ST editor to look at what I've done so far, and for each of
the five I've created so far, the template is empty.  If the template is
empty, instead of having the correct accounts to post the transaction to,
how is it going work on 2022-02-01?


-Original Message-
From: gnucash-user mailto:offthedial@gnucash.org> >
On Behalf Of Jed Taylor
Sent: Friday, January 28, 2022 15:49
To: gnucash-user@gnucash.org  
Subject: [GNC] Can't get Scheduled Transactions to work

GnuCash v4.6 on Windows 10.



I'm working on setting up the books for my condo association, which has 20
units.  With 20 units, I'd like to have GnuCash automatically post the
monthly assessment due from each unit, which is a different amount for each,
on the first of the month to the G/J.



I've read the Help on STs, and followed the steps, as well as gotten into
editing the ST.  So far, I simply can't get this feature to work.



I'm testing this feature using only one unit to start.  The books open in
late 2020-09, so the first entry for assessments is dated 2020-10-01. 



I created a G/J entry that posts the amount for the unit to its A/R & Income
accounts.  So far, so good.  Then, I select that transaction and click on
the "Schedule" button and tell the dialog I want a monthly transaction.
I've tried this using both 10-01 and 11-01 as the start date for the ST, and
I'm getting the same results.  I have also tried this using the current date
for my PC's date as well as resetting my PCs date to 2020-11-01.



Each time I can get the ST to post, the two account fields are filled with
hexadecimal characters rather than actual accounts from the template
transaction.  The account balances remain unchanged.  If I go to the G/J and
click on the entry, GC tells me the account doesn't exist and asks me if I
want to create it.



If I examine the entry for the ST, when I go to the Template window, the
information for the transaction is blank.  When I fill in the information
there, it accepts it, but when it posts, again, I get the same nonsense hex
for the accounts rather than what I've assigned.



What I expected to happen when I set up the ST is for every month between
2020-10-01 and 2022-01-01 to post to the G/J and have the ST slice of the
app tell me that the next one ready to post would be for 2022-02.



Clearly, I'm missing something.  What is it?



TIA.



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

Re: [GNC] credit card minimum payment due

[Tommy Trussell]

On Sat, Jan 29, 2022 at 2:51 AM Liz  wrote:

> On Fri, 28 Jan 2022 14:23:41 -0600
> Adrien Monteleone  wrote:
>
> > While formulas and variables are possible with Scheduled
> > Transactions, unfortunately, they can't grab the current account
> > balance. (and there are no 'if:then' logic functions possible anyway,
> > just straight math)
> >
> > But you can choose to schedule the payment regardless of the balance,
> > but set it as a reminder rather than auto-create. You can then
> > preview and approve the transaction to be created if it is needed.
> >
> > Regards,
> > Adrien
>
> I just put in an amount in the scheduled transaction, then set it be
> checked before posting, and then update the amount to the actual charge
> nvolved. In my case it is a purchase on Friday night - sometimes the
> purchase is not made, so I delete the transaction, and other times I
> edit it to reflect the actual purchase.
>

I use Scheduled Transactions to help remind me to download a card or
utility statement -- I have it remind me (however many number of days)
before the payment is due, picking a day right around the time the
statement is available to download. Then when the statement is available, I
let it create the transaction on the draft date and I update the amount for
the payment amount and update the exact date it will be drafted from the
bank.

>From the "Since Last Run" scheduled transactions window you can also change
the status to Ignore the scheduled transaction (for months you don't have a
payment to draft) or put the transaction's status back to Remind if you're
not ready for it to create the amount yet.

If you want to get really fancy you can define the payment amount as a
variable in the scheduled transaction editor and the Since Last Run window
will prompt you to fill in the amount. I usually DON'T use variables,
however, because it requires me to have the payment amount right at hand as
soon as I deal with the window, and usually I'm in the middle of some other
things and prefer to "correct" the amounts in the "created transactions"
tab after they have been created.

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

[GNC] Adding late charges to a vendor bill after posting?

[Eric H. Bowen via gnucash-user]

Property taxes are due. Actually, by the time you read this, they will 
be past due... I used the "vendor bill" Payables system to track this 
when I got the tax bill in November and I've made a partial payment, but 
the funds just are not there to choke down the whole thing. So I'm going 
to get gigged for a late fee, and possibly even more if I can't settle 
up by the end of February.


What's the proper way to track this? If it gets to the point where I 
need to make a monthly payment arrangement (basically a 12 month note) I 
was going to enter the note as a new liability and credit that towards 
the tax payment due. But if I can get this cleared up by late February 
or mid-March then I'll just have a month or two of late fees/interest 
due. Is there a way to associate that with the tax payment after the 
bill has been posted? How should it properly be handled?


Asking for a friend

___
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] Adding late charges to a vendor bill after posting?

[Stephen M. Butler]

I setup an Asset account as a sub-account to the Bank's Saving account 
called "Sinking Fund". In a spreadsheet I list all the "one-time" 
[quarterly, semi-annual, annual] payments that need to be made.  Add 
these up then divide by 12.  This is how much you MUST move from 
checking to savings each month in order to have funds available as 
needed. You may need to preload an amount to keep from going negative 
sometime during the year.


I then setup an automated monthly transfer at the bank to fire each 
month to move that amount each month from checking to savings.


I also setup a monthly scheduled transaction in GnC to fire on the same 
day as the automated bank transfer.   This transaction is set to load 15 
days before the scheduled date so I can watch the checking account 
register to be sure the funds will be there for the automated transaction.


Then as each of these amounts come due, I move the funds from savings 
back to checking and then write the check to make the payment (in my 
account I setup the payment on the bank's system for them to draw the 
funds from checking).  Be sure to enter both transactions in GnC:

1.  Move the funds from Sinking to Checking.
2.  Make the payment on the date the bank says the check will arrive at 
the payee.





On 1/29/22 17:57, Eric H. Bowen via gnucash-user wrote:
Property taxes are due. Actually, by the time you read this, they will 
be past due... I used the "vendor bill" Payables system to track this 
when I got the tax bill in November and I've made a partial payment, 
but the funds just are not there to choke down the whole thing. So I'm 
going to get gigged for a late fee, and possibly even more if I can't 
settle up by the end of February.


What's the proper way to track this? If it gets to the point where I 
need to make a monthly payment arrangement (basically a 12 month note) 
I was going to enter the note as a new liability and credit that 
towards the tax payment due. But if I can get this cleared up by late 
February or mid-March then I'll just have a month or two of late 
fees/interest due. Is there a way to associate that with the tax 
payment after the bill has been posted? How should it properly be 
handled?


Asking for a friend

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



--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

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