Re: [GNC] Locked file

[Roger Oliver]

I saved the file out under a different name. Worked fine. When I tried to
delete the old file it wouldn't, said it was open in another app. Turned
out to be Carbonite. Maybe backing up the file. Restarted the computer and
it allowed me to delete the old file. All better. Thanks.

On Tue, Jul 18, 2023, 8:44 PM David Carlson 
wrote:

> You are probably running out of memory or drive space
>
> On Tue, Jul 18, 2023 at 8:29 PM  wrote:
>
>> I'm getting an error message: GnuCash could not write to C. That database
>> may be on a read only file system, you may not have permission for the
>> directory or your anti-virus software is preventing this action.
>>
>>
>>
>> Problem just started. Has been working fine. Files are not locked.
>>
>>
>>
>> Thanks,
>>
>> Roger
>>
>> ___
>> 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.

Re: [GNC] Printing invoices and statements, Spanish language version stylesheets

[Roger Oliver]

Frank,

Where are those codes located? Sounds promising.

Thanks,
Roger
p.s. Gyle, I will check that out. I suspect file/print brings up the
printer's control panel. If so, it is set to letter. Thanks

On Wed, Aug 25, 2021, 2:26 PM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hi,
>
> Am 25.08.21 um 19:02 schrieb Gyle McCollam:
> > I use the English version and it shows letter size, maybe in Spanish it
> shows A4 as you said.
>
> es as short for es-ES should deliver A4, but
> es_MX should return Carta/Letter.
>
> Similar while
> en[_US] returns Letter, but
> en_GB returns A4.
>
> All formats depend on your region, not your language.
>
> Regards
> Frank
>
___
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] (no subject)

[Roger Oliver]

Thanks David T.

Puzzling to me too. It dawned on me that the only indication we saw that
the check and repair function was working was that the menus and icons at
the top of the page were grayed out and unavailable. Probably need to give
it more time until those come back to life.

Examining the file without check and repair shows the arrows to the left of
the accounts on the chart of accounts page but they do not respond to a
click.

You are correct, saved reports means adjustments to the existing reports.
We did move the .gnucash file from the old computer to the new before
installing the 3.11 and opening the GnuCash data file. The reports didn't
show up. Wonder if the .gnucash file in Windows 10 has a different name,
maybe GnuCash. At any rate, saved reports were not there when we opened the
data file in 3.11

Roger

Message: 5
Date: Tue, 18 May 2021 17:05:58 -0400
From: "D." 
To: rmom...@gmail.com
Cc: GnuCash 
Subject: Re: [GNC] Migrating and updating 2.6.21 in Windows 7 to 3.11
in Windows 10 No sub-accounts
Message-ID: <0f7274aa-55bb-4ccc-990f-ea8efbc53...@yahoo.com>
Content-Type: text/plain; charset=UTF-8

Roger,

Your experience is exceptional,? insofar as I've never heard that
particular problem before. Your description is puzzling to me; how is it
that your top level accounts show correct balances, if the subaccounts are
not there? Something is off there...

Here are some ideas:

I'll assume that you closed gnucash after the Check & Repair and restarted
it. I know sometimes that helps unstick things.

Since you're having trouble with the canonical upgrade process, what
happens if you examine the file without performing the Check & Repair?

I am going to assume that your statement that the saved reports are not
important implies that you haven't actually written Scheme-based custom
reports (because if you'd gone down THAT rabbit hole, those reports would
be important to you), but that you have saved a number of standard reports
with basic customization, such as a subset of accounts on an income report,
or a special date range, etc. If that is the case, you could simply copy
{yourfile}.gnucash from the Windows 7 box to the new machine, and open that
with 3.11. Later, you could try to find your saved-reports.2.x fileand copy
it over to the new machine (in the new folder for version 3 and above).

If none of those fix your problem, perhaps you can send a screen shot of
the Chart of Accounts. Maybe that will shed some light...

David T.
___
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] Migrating and updating 2.6.21 in Windows 7 to 3.11 in Windows 10 No sub-accounts

[Roger Oliver]

David,

This may be what is happening. We need to give it more time to check and
repair. The only indication that the process is still in progress is that
the menus and and icons at the top of the GnuCash page are grayed out and
unavailable. Dawned on me that when the process is finished the menus and
icons should once again become available.

Thanks,
Roger

Message: 3
Date: Tue, 18 May 2021 15:29:00 -0500
From: David Carlson 
To: Roger Oliver 
Cc: GnuCash 
Subject: Re: [GNC] Migrating and updating 2.6.21 in Windows 7 to 3.11
in Windows 10 No sub-accounts
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Unfortunately it is hard to tell where GnuCash is getting stuck, if it is.
 For a large data file or a computer with limited resources it may take
more than ten minutes, possibly an hour or more to do the repair steps.
You may need to use the task manager to monitor whether GnuCash is still
using cpu time.

Perhaps someone else has a suggestion.
___
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] Migrating and updating version 2 to 4

[Roger Oliver]

Thanks, very helpful. Roger

On Wed, Apr 7, 2021, 11:38 AM Alan A Holmes 
wrote:

> Roger,
>
> Adrian Monteleone gave a brilliant answer to this in the past. I can't work
> out how to link to his reply so, with apologies to Adrian, his reply was as
> follows :-
>
> 
>
> 
> 
>
> Per the FAQ in the Wiki, only upgrading from one major to the next
> major release is supported. Skipping major releases is *not* supported.
>
> Thus for you, 2.6.21 > 3.11 > 4.2 would be okay.
>
> However, 2.6.21 > 4.2 *might* result in issues which *may* include
> data loss or corruption. (no guarantees either way) You might get lucky,
> you
> might not. You might not, and not realize it for some time depending on the
> nature of the corruption/loss.
>
> Properly upgrading *should* result in custom reports and other
> settings being migrated properly. There were some migration issues with the
> early 3.x series, but that was solved at some point. (not sure of the
> cutoff
> release, see release notes starting with 3.0 till about 3.3 or so if
> curious.)
>
> Also per the FAQ and the Wiki, after opening your data file for the
> first time with each new major version, you should run Action > Check &
> Repair > Check & Repair All to make sure your book is adjusted to reflect
> any changes to how GnuCash internally records data. This also can prevent
> previous versions from reading the file after this point.
> (this will vary by book, according to what features you were using in the
> prior edition) The release notes for 3.0 and 4.0 should detail these
> changes.
>
> Regards,
> Adrien
>
> 
>
> 
> __
>
> The only difference is that GnuCash is now on version 4.5 rather than 4.2.
>
> As you're coming from 2.6.21 on Windows 7 you should be able to install
> 3.11
> on Windows 10, and use the data file from your Windows 7 PC.
>
> Good luck.
>
> Alan A Holmes
>
> -Original Message-
> From: gnucash-user
>  On Behalf Of
> Roger Oliver
> Sent: 07 April 2021 01:31
> To: Gnucash 
> Subject: [GNC] Migrating and updating version 2 to 4
>
> I'm running GnuCash 2.6.21 on a Windows 7 computer. I need to migrate the
> system to a Windows 10 computer. Just need to be sure I understand any
> complications I may encounter. Some questions.
>
> 1. Will I have any problems updating to version 4?
> 2. Reading about version 4 on the GnuCash website, I think the only thing
> we
> won't be able to migrate will be the saved customized reports and
> preferences. Is that correct?
> 3. Am I reading the manual correctly that all we need to migrate our data
> is
> to copy the current data file to the location where version 4 keeps these
> files. Is that still Documents/GunCash?
> 4. As in the past, will version 4 update the data file automatically?
>
> Probably obvious answers, just that we update once in a blue moon. Hope I
> haven't overlooked any protocols for this group.
>
> Thanks so much for the help,
> Roger
> ___
> 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.

[GNC] Migrating and updating version 2 to 4

[Roger Oliver]

I'm running GnuCash 2.6.21 on a Windows 7 computer. I need to migrate the
system to a Windows 10 computer. Just need to be sure I understand any
complications I may encounter. Some questions.

1. Will I have any problems updating to version 4?
2. Reading about version 4 on the GnuCash website, I think the only thing
we won't be able to migrate will be the saved customized reports and
preferences. Is that correct?
3. Am I reading the manual correctly that all we need to migrate our data
is to copy the current data file to the location where version 4 keeps
these files. Is that still Documents/GunCash?
4. As in the past, will version 4 update the data file automatically?

Probably obvious answers, just that we update once in a blue moon. Hope I
haven't overlooked any protocols for this group.

Thanks so much for the help,
Roger
___
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] Scheduled transactions

[Roger Oliver]

Good to know. At least I can stop looking for it. Future versions then.
Thanks David

On Fri, Mar 29, 2019, 7:21 PM David Carlson 
wrote:

> Roger, you are not the first to ask for this.   *Bug 727513*
> 
>
> David Carlson
>
>
> On Fri, Mar 29, 2019 at 5:12 PM  wrote:
>
>> Is there a way in the scheduled transactions tab to tell the system to
>> process a transaction right now rather than waiting for the normally
>> scheduled day? For example, a paycheck scheduled for the first may be
>> deposited on a Friday the last day of the month when the 1st of the
>> following month falls on a Saturday.
>>
>>
>>
>> Thanks,
>>
>> Roger
>>
>> ___
>> 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] Saved report configurations

[Roger Oliver]

That worked. Thanks. You are correct, my intention was to experiment with
3.4. I thought I would try copying the stylesheet file to the test computer
as well. That did not work, I suspect because the picture file is not in
the test computer.

I take it that 3.4 will install with the Spanish accounting terms, etc., on
a Window 7 computer with the Windows language set to Spanish. Is that
correct? Spanish is not a language choice on the list when installing the
program but it installed on our working computer in Spanish anyway. That
was a boon for us.

Roger

The program looks good. Seems familiar and maybe a little easier on the
eyes.

On Tue, Mar 19, 2019, 2:01 PM Geert Janssens 
wrote:

> Op dinsdag 19 maart 2019 20:33:32 CET schreef rmom...@gmail.com:
> > Thanks Geert,
> >
> > Windows 7. I found the file in
> C:/Users/TOSHIBA/.gnucash/saved-reports-2.4.
> > Out of curiosity, I looked for it on my Windows 10 computer and didn't
> find
> > it. I didn't see anything special for Windows 10 in the wiki. Not
> important
> > really as long as the update takes care of that.
> >
> > You said, " If you want to force the migration, you should move the
> > directory aside before running gnucash 3.x." Will it work to copy the 2.4
> > file to the 3.4 directory? I saved the 2.4 file from the working pc to a
> > USB.  I'm guessing I'll have to delete the 3.4 saved reports file, if it
> > even exists as I have not saved any reports on the test computer. I would
> > like to give it a try.
> >
> > Roger
>
> Hi Roger,
>
> If I understand correctly from your reply to John, the new computer is
> only to
> experiment with 3.4. It will not be used to actually upgrade from 2.6 to
> 3.4 ?
>
> In that case you can indeed copy the saved-reports-2.4 file to the new pc.
>
> If you enter a Windows Explorer on that PC, and type
> %appdata%\GnuCash
> in its address bar, that should open the proper location to store the
> saved
> reports file for gnucash 3.4 (provided you have run gnucash 3.4 before at
> least once). Note don't copy the file there while gnucash is running. It
> may
> be overwritten as gnucash closes.
>
> 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] Default invoice/statement

[Roger Oliver]

Very helpful, thanks. Pardon my ignorance, CSS?

Do I understand correctly that the customized reports are saved in the data
file so should be there when you open the file in the update?

Roger


On Sat, Mar 9, 2019, 9:25 AM Christopher Lam 
wrote:

> Like everything in Gnucash, backward compatibility is always the golden
> rule, but this is not always possible.
> Invoices have been merged i.e. easy/fancy/printable now share a common
> base and options. Styles can be customized via CSS and layout of header via
> other options.
> You shouldn't need to change your report options but you should definitely
> verify they produce satisfactory output.
>
>
> On Sat, 9 Mar 2019 at 14:56, Roger Oliver  wrote:
>
>> Thanks Christopher,
>>
>> By merged, do you mean the style sheets have been merged? Same options
>> for all of them or just one style sheet you can customize?
>>
>> When you upgrade, do you have to re-establish your saved report formats?
>>
>> Roger
>>
>>
>> On Fri, Mar 8, 2019, 10:39 PM Christopher Lam 
>> wrote:
>>
>>> On Fri, 8 Mar 2019 at 14:04,  wrote:
>>>
>>>> Thanks Derek,
>>>>
>>>> Good to know the feature has been added to Version 3.x. I take it by
>>>> current
>>>> you mean stable? Still a little reluctant to upgrade as version 2.6.17
>>>> is
>>>> working for us. If it ain't broke...
>>>>
>>>
>>> fwiw invoicing in 3.3 onwards has been merged; it is more flexible but
>>> awaiting bug 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
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] Default invoice/statement

[Roger Oliver]

Thanks Christopher,

By merged, do you mean the style sheets have been merged? Same options for
all of them or just one style sheet you can customize?

When you upgrade, do you have to re-establish your saved report formats?

Roger


On Fri, Mar 8, 2019, 10:39 PM Christopher Lam 
wrote:

> On Fri, 8 Mar 2019 at 14:04,  wrote:
>
>> Thanks Derek,
>>
>> Good to know the feature has been added to Version 3.x. I take it by
>> current
>> you mean stable? Still a little reluctant to upgrade as version 2.6.17 is
>> working for us. If it ain't broke...
>>
>
> fwiw invoicing in 3.3 onwards has been merged; it is more flexible but
> awaiting bug 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
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] Default invoice/statement

[Roger Oliver]

Adrian,

Good to know. May try the intermediate step of upgrading to 2.6.21 first. I
understand 3.5 should be out by the end of this month. I have a separate
computer I can experiment with first.

Thanks,
Roger

Message: 6
Date: Fri, 8 Mar 2019 13:30:46 -0600
From: Adrien Monteleone 
To: GnuCash 
Subject: Re: [GNC] Default invoice/statement
Message-ID: 
Content-Type: text/plain;   charset=utf-8

Roger,

If for some reason you just had to stick with the 2.6.x series for a while
longer, I?d recommend 2.6.21 as many bugs were fixed between it and 2.6.17.
It is the last stable release of the 2.6 series. But 3.4 is the current
release. (3.5 is due out at the end of the month I believe)

Regards,
Adrien

> On Mar 8, 2019, at 8:33 AM, Derek Atkins  wrote:
>
> Hi,
>
>  writes:
>
>> Thanks Derek,
>>
>> Good to know the feature has been added to Version 3.x. I take it by
current
>> you mean stable? Still a little reluctant to upgrade as version 2.6.17 is
>> working for us. If it ain't broke...
>
> Version 2.6.17 was released Q3 2017.  It is now Q1 (almost Q2) 2019, so
> it's almost two years old.  And yes, 3.4 is the current stable release.
>
>> Roger
>
> -derek
___
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] Default invoice/statement

[Roger Oliver]

Is there a way to move the Fancy invoice/statement layout up to replace the
default?

The default layout does not allow putting a logo on the masthead. I'm using
the last update of version 2 of GnuCash. It's stable and working for us so
haven't seen the need to update.

Thanks much,
Roger Oliver
___
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] Budget module transfers

[Roger Oliver]

At the bottom of the budget window their is a summary of income, expenses
and transfers. The transfer row was empty until I entered some amounts in
the current asset and liability accounts. I don't find anything in the
manual to explain how that row is calculated so I can make sense of it.
Might it reflect cash flows between asset and liability accounts?

Thanks
Roger
___
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] Disconnect between balance on client list and account statement

[Roger Oliver]

Adrien,

 

A challenge here is that the GnuCash I am using is in Spanish, that is the
accounting terms and reports and in Spanish so I’m guessing at what the
names are in English. I couldn’t figure out which report was the aging
report because of that. The best I can guess is the following:

 

Previsión de Clientes = Customer overview

Estado de cliente = Customer Report 

Calendario de cobros pendientes = Receivable aging 

 

This last may or may not be the receivable aging report. They are not in the
same order on the menu. 

 

I tracked down an open invoice that had not been paid. Somehow in the switch
to GnuCash from Quicken we missed a payment. Posting a payment to a current
asset cash/checking account would have messed up those balances.
Nevertheless, that is what I did by accident. 

 

I moved that payment elsewhere, to an income/returns account so it would not
effect the cash balances. That fixed the balance on the Customer Overview
but left a credit balance on the Customer Report. The calendario de cobros
pendients (Receivable aging?) report shows the customer with the same credit
balance as the Customer Report/Estado de Cliente even though the Customer
overview shows the correct balance. 

 

I had tried this before with the same result. I even tried issuing a credit
note using it to pay the open invoice and got the same result. Either the
Customer Overview shows the correct balance or the Customer Report shows the
correct balance but I can’t get them to match. All the other customers
match. I’m missing something but can’t figure it out for the life of me.

 

Thanks for the effort,

Roger

 

Message: 8

Date: Tue, 14 Aug 2018 20:30:31 -0500

From: Adrien Monteleone mailto:adrien.montele...@lusfiber.net> >

To: Gnucash Users mailto:gnucash-user@gnucash.org> >

Subject: Re: [GNC] Disconnect between balance on client list and

account statement

Message-ID: <91a3e255-86da-47db-92ee-528ec976b...@lusfiber.net
 >

Content-Type: text/plain; charset=utf-8

 

I think this is fixable. You should not need to create a new customer
account.

 

By ?Customer Statement? I?m presuming you mean the ?Customer Report?
correct?

 

If so, change the dates to reflect the entire time she?s been a customer. If
everything is paid and there are no remaining pre-payments (deposits) it
should balance to zero. You can check for remaining deposits by trying to
Process Payment on her account. If any pre-payment still shows up, then it
has not been applied. (same with any invoices that show up)

 

Now, run a Reports > Business > Receivable Aging report. It should show she
has a zero balance. If not, double check the options to make sure the ?To?
date matches the end date of the Customer Report. (usually ?Today?) These
numbers *should* match what is shown on the Customer Overview Balance
column.

 

If when these dates match, you still have non-zero balances, then there are
one or more invoices posted for her that aren?t paid. You?ll have to track
them down. Do an invoice find with her as the customer and check them all to
make sure they are paid. (one possibility is you might have a duplicate
somewhere.)

 

If the balances are zero when the dates match, but non-zero when you extend
the ?to? past ?today? then you?ve posted a future invoice to her account and
your report option for the Aging Report (and possibly the overview does this
as well) is set to that later date. She might be current ?today? but based
on what is posted, does (or will) owe $1500.

 

So the end result is there is likely a misapplied payment or not-applied
payment, or a future dated invoice. If you posted and un-posted an invoice,
it is possible the payment was not successfully re-applied and you need to
re-associate it to the proper invoice.

 

Regards,

Adrien

 

> On Aug 14, 2018, at 7:38 PM, mailto:rmom...@gmail.com>
> mailto:rmom...@gmail.com> > wrote:

> 

> I have a customer who ended the last fiscal year (school year) with a zero

> balance owed but still shows owing $1500 in the customer overview but her

> statement shows zero balance. I use the customer overview to manage
overdue

> accounts by sorting according to the balance due. In her case it should be

> zero but isn't. If I give her a credit note the customer overview will
show

> the correct amount but the statement will be off by the same amount. She

> paid ahead last year and I posted the total amount she paid against the

> invoice due at that time leaving a balance in her favor. I paid each

> following invoice with the credit balance. In every other case this works

> perfectly. 

> 

> 

> 

> I can't find where the error is or how to correct it.  If I can't figure
out

> how to correct it, one option is to deactivate her customer account
attached

> to last year's invoices and create a new account for her and start all
over

> this year.

Re: [GNC] Disconnect between balance on client list and account statement

[Roger Oliver]

Adrien,

A challenge here is that the GnuCash I am using is in Spanish, that is the
accounting terms and reports and in Spanish so I’m guessing at what the
names are in English. I couldn’t figure out which report was the aging
report because of that. The best I can guess is the following:

Previsión de Clientes = Customer overview
Estado de cliente = Customer Report
Calendario de cobros pendientes = Receivable aging

This last may or may not be the receivable aging report. They are not in
the same order on the menu.

I tracked down an open invoice that had not been paid. Somehow in the
switch to GnuCash from Quicken we missed a payment. Posting a payment to a
current asset cash/checking account would have messed up those balances.
Nevertheless, that is what I did by accident.

I moved that payment elsewhere, to an income/returns account so it would
not effect the cash balances. That fixed the balance on the Customer
Overview but left a credit balance on the Customer Report. The calendario
de cobros pendients (Receivable aging?) report shows the customer with the
same credit balance as the Customer Report/Estado de Cliente even though
the Customer overview shows the correct balance.

I had tried this before with the same result. I even tried issuing a credit
note using it to pay the open invoice and got the same result. Either the
Customer Overview shows the correct balance or the Customer Report shows
the correct balance but I can’t get them to match. All the other customers
match. I’m missing something but can’t figure it out for the life of me.

Thanks for the effort,
Roger

Message: 8

Date: Tue, 14 Aug 2018 20:30:31 -0500

From: Adrien Monteleone 

To: Gnucash Users 

Subject: Re: [GNC] Disconnect between balance on client list and account
statement

Message-ID: <91a3e255-86da-47db-92ee-528ec976b...@lusfiber.net>

Content-Type: text/plain; charset=utf-8

I think this is fixable. You should not need to create a new customer
account.

By ?Customer Statement? I?m presuming you mean the ?Customer Report?
correct?

If so, change the dates to reflect the entire time she?s been a customer.
If everything is paid and there are no remaining pre-payments (deposits) it
should balance to zero. You can check for remaining deposits by trying to
Process Payment on her account. If any pre-payment still shows up, then it
has not been applied. (same with any invoices that show up)

Now, run a Reports > Business > Receivable Aging report. It should show she
has a zero balance. If not, double check the options to make sure the ?To?
date matches the end date of the Customer Report. (usually ?Today?) These
numbers *should* match what is shown on the Customer Overview Balance
column.

If when these dates match, you still have non-zero balances, then there are
one or more invoices posted for her that aren?t paid. You?ll have to track
them down. Do an invoice find with her as the customer and check them all
to make sure they are paid. (one possibility is you might have a duplicate
somewhere.)

If the balances are zero when the dates match, but non-zero when you extend
the ?to? past ?today? then you?ve posted a future invoice to her account
and your report option for the Aging Report (and possibly the overview does
this as well) is set to that later date. She might be current ?today? but
based on what is posted, does (or will) owe $1500.

So the end result is there is likely a misapplied payment or not-applied
payment, or a future dated invoice. If you posted and un-posted an invoice,
it is possible the payment was not successfully re-applied and you need to
re-associate it to the proper invoice.

Regards,
Adrien



> On Aug 14, 2018, at 7:38 PM,  
wrote:

>

> I have a customer who ended the last fiscal year (school year) with a zero

> balance owed but still shows owing $1500 in the customer overview but her

> statement shows zero balance. I use the customer overview to manage
overdue

> accounts by sorting according to the balance due. In her case it should be

> zero but isn't. If I give her a credit note the customer overview will
show

> the correct amount but the statement will be off by the same amount. She

> paid ahead last year and I posted the total amount she paid against the

> invoice due at that time leaving a balance in her favor. I paid each

> following invoice with the credit balance. In every other case this works

> perfectly.

>

>

>

> I can't find where the error is or how to correct it.  If I can't figure
out

> how to correct it, one option is to deactivate her customer account
attached

> to last year's invoices and create a new account for her and start all
over

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

Re: Reports crashing GnuCash

[Roger Oliver]

That worked. Thank you. Think it happened because I uninstalled and
reinstalled the program to see if I could fix another problem.

On Mar 3, 2018 2:55 PM, "Dave H"  wrote:

If you're running on Windows and running a report for the first time it
takes a few minutes even on a small gnucash data file, this is a known
issue.  Be patient it may say it's not responding but wait - after the
first report finishes ok the others all behave as expected.

You're getting the lock file message because you "killed" gnucash - select
open anyway if you're sure no one else is accessing your data file ..

Cheers Dave H.


On 4 March 2018 at 06:46,  wrote:

> All the reports are locking up the program. There is no option other than
> to
> close the program through the Windows task manager. When I open the program
> again, I get the error message, "GnuCash could not obtain the lock for
> file:."
>
>
>
> Thanks,
>
> Roger
>
> ___
> 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: Language change mystery (John Ralls)

[Roger Oliver]

Original message

You do have an editor: Notepad. It comes with Windows. Just click the Start
menu and then type the name to find it. Once it's visible in the menu bar,
right-click on it and select "run as administrator" to get the privilege
escalation to edit environment.

 

Regards,

John Ralls

 

Results

John,

 

I opened Notepad as administrator and went looking for the environment file
in C:\\Program Files (x86)\gnucash\etc\gnucash. The file shows in explorer
but not in Notepad. A check of the properties doesn't show what kind of file
it is either. 

 

What would happen if I uninstalled and reinstalled the program in the
English environment? I think I've done this before moving to a new computer
and when a laptop crashed.

 

Thanks,

Roger

 

 

 

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

Language change mystery

[Roger Oliver]

I live in Mexico so when my tech works on my computer he changes the
operating language of Windows to Spanish. Somehow that changed the language
of GnuCash and I can't seem to get it to change back. The names of the
accounts are the names I gave them in English but all the menus and tabs
are in Spanish. It even changed the primary currency to the Mexican peso.

It may have something to do with Windows Defender. For some reason it
blocked GnuCash from making changes to the file. It was treating GnuCash as
a virus. I think we fixed that.

Thanks,
Roger
___
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: General Journal - history limit and search

[Roger Oliver]

I thought so too but it doesn't seem to work that way. I keep the general
journal open on the desktop. It isn't that difficult to open it again, just
a curiosity that it didn't show the search results in a new window like the
account journals.

Once it shows the search results, I haven't figured out a way to get the
general journal back to showing all the transactions after doing a search
other than by opening another general journal. Might be able to do it by
changing the filter settings in view. I'll try that tomorrow. Thanks

On Oct 31, 2017 7:20 PM, "David Carlson" <david.carlson@gmail.com>
wrote:

> Roger, for your second question, I think that a search in the General
> ledger view should produce it's results in a new results view rather than
> the first General Ledger view.
>
> However, if I am wrong about that, it should be simple to open a new
> General Ledger view from the menu.  You should not need to close the
> previous results views unless you do not expect to go back to them and you
> would rather have less clutter on your desktop.
>
> David C
>
> On Tue, Oct 31, 2017 at 12:23 PM, Roger Oliver <rmom...@gmail.com> wrote:
>
>> Perfect. Thanks
>>
>> On Oct 31, 2017 11:08 AM, "Aaron Laws" <dartm...@gmail.com> wrote:
>>
>> > On Tue, Oct 31, 2017 at 12:39 PM, Roger Oliver <rmom...@gmail.com>
>> wrote:
>> >
>> >> I notice my general journal only goes back to the beginning of Octuber.
>> >> Transactions from September don't show. A search by date doesn't find
>> any
>> >> transactions earlier than October either. Is there a setting I'm
>> >> overlooking to include everything in the general journal?
>> >>
>> >> Also, when I search the general journal the results are shows in the
>> same
>> >> journal, not in another register. Don't know how to get the general
>> >> journal
>> >> back to showing all the transactions. I just close it and open the
>> general
>> >> journal again from the tools menu. Is there a better way? Something I'm
>> >> not
>> >> doing correctly in the search criteria window?
>> >>
>> >> Thanks,
>> >> Roger
>> >
>> >
>> > With the General Ledger open, click "View" then "Filter By..." and
>> adjust
>> > the filter to your liking. It doesn't remember this setting, so you'll
>> have
>> > to do it any time you close then reopen gnucash.
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
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: General Journal - history limit and search

[Roger Oliver]

Perfect. Thanks

On Oct 31, 2017 11:08 AM, "Aaron Laws" <dartm...@gmail.com> wrote:

> On Tue, Oct 31, 2017 at 12:39 PM, Roger Oliver <rmom...@gmail.com> wrote:
>
>> I notice my general journal only goes back to the beginning of Octuber.
>> Transactions from September don't show. A search by date doesn't find any
>> transactions earlier than October either. Is there a setting I'm
>> overlooking to include everything in the general journal?
>>
>> Also, when I search the general journal the results are shows in the same
>> journal, not in another register. Don't know how to get the general
>> journal
>> back to showing all the transactions. I just close it and open the general
>> journal again from the tools menu. Is there a better way? Something I'm
>> not
>> doing correctly in the search criteria window?
>>
>> Thanks,
>> Roger
>
>
> With the General Ledger open, click "View" then "Filter By..." and adjust
> the filter to your liking. It doesn't remember this setting, so you'll have
> to do it any time you close then reopen gnucash.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: General Journal - history limit and search

[Roger Oliver]

Perfect. Thanks

On Oct 31, 2017 11:01 AM, "Maf. King" <m...@chilwell.net> wrote:

> On Tuesday, 31 October 2017 16:39:28 GMT Roger Oliver wrote:
> > I notice my general journal only goes back to the beginning of Octuber.
> > Transactions from September don't show. A search by date doesn't find any
> > transactions earlier than October either. Is there a setting I'm
> > overlooking to include everything in the general journal?
> >
>
> Hi,
>
> ISTR that the GL defaults to showing the current month only.  View ->
> Filter
> By -> [Date] should get you going...
>
> HTH,
> Maf.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

General Journal - history limit and search

[Roger Oliver]

I notice my general journal only goes back to the beginning of Octuber.
Transactions from September don't show. A search by date doesn't find any
transactions earlier than October either. Is there a setting I'm
overlooking to include everything in the general journal?

Also, when I search the general journal the results are shows in the same
journal, not in another register. Don't know how to get the general journal
back to showing all the transactions. I just close it and open the general
journal again from the tools menu. Is there a better way? Something I'm not
doing correctly in the search criteria window?

Thanks,
Roger
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Sales report by item

[Roger Oliver]

Thanks. So I'm not losing my mind after all.

On Oct 18, 2017 2:13 PM, "Derek Atkins"  wrote:

> Hi,
>
> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> > Is there a way to get a sales report by item? Total sales for a day by
> > item
> > for example. The only indicators I can find would be the description
> field
> > on the invoice or the income or other account credited for the sale.
> > Thanks!
> > Roger
>
> You would certainly have to write your own report to do that.  You would
> need to search through all posted invoices, and for each invoice line-item
> determine the date and amount, and then collect all those tuples.  Then
> you can display it out.
>
> There is definitely no existing report that would do this.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Receiving payments on invoices

[Roger Oliver]

How can you apply an overpayment on an invoice to future invoices or to
other outstanding invoices to the same customer? Thank you, Roger
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Backup database

[Roger Oliver]

Yes it does help. Thanks. GnuCash appears to work well with Microsoft
OneDrive.

On Sep 18, 2017 2:07 PM, "Derek Atkins" <de...@ihtfp.com> wrote:

> Hi,
>
> Please remember to CC the list on all replies using your mailer's
> reply-to-list or reply-all functionality.
>
> Roger Oliver <rmom...@gmail.com> writes:
>
> > Wasn't working with a detachable hard drive but I got it to work with a
> USB
> > memory. Appears to be a problem with the detachable hard drive.
>
> Ah.  GnuCash has no control over that. ;)
>
> > Can you open a file in the cloud directly into GnuCash? Tried and failed
> once
> > but I could be doing something wrong.
>
> If depends how the cloud service is connected.  If it looks like any
> other "local" drive then sure, just point GnuCash at /path/to/the/cloud.
> However some apps don't do that and only provide a service to copy;
> gnucash cannot directly use that.  So it all depends on what service you
> want to use.
>
> Hope this helps,
>
> > Thanks,
> > Roger
>
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Backup help

[Roger Oliver]

Thanks. I'll try that. Everything worked as advertised on a simple USB
drive so it may be a Windows issue or power on the old Windows 7 machine.

On Sep 15, 2017 7:29 PM, "Art" <pina...@yahoo.com> wrote:

> I'm not familiar with "WinDrive". My 5TB USB drive is Seagate Backup Plus
> formatted to NTFS with a GPT (to handle drives larger than 2TB).
>
> Since you said you could see the files from the first machine, the data
> was likely there. If you cannot see any files on the same drive from the
> second machine, I'd get another Windows 10 machine to see if it can read
> any files on the same drive. If not,the "WinDrive" is suspect.
>
> BTW, I also have a 2TB drive powered by the USB port - that device
> occasionally fails if the host cannot  power the drive, i.e., the port
> can't handle the 500 mA peak demand from the drive, so it disconnects and
> the data corrupts. It's a nuisance, but it works most of the time. I
> generate checksums for my critical files so I can just destroy corrupt
> files and get another copy (I keep three copies of all my critical stuff).
>
> - Art
>
> On Friday, September 15, 2017, 7:21:13 PM EDT, Roger Oliver <
> ro...@olivermx.net> wrote:
>
>
> Windows 7 and 10. Mostly interested in a backup copy off the main computer
> in case it crashes. Mine did, the Windows 10 machine. All my GC data was
> restored from the Carbonite backup. Grateful it worked. The 7 machine is at
> the school dedicated to accounting. I think there is something wrong with
> the WinDrive external hard drive. Thanks!
>
> On Sep 15, 2017 6:08 PM, "Art" <pina...@yahoo.com> wrote:
>
> What are the OSes on the source and target computers?
> What is the external hard disk filesystem and how do you know it's
> compatible with both computers?
>
> I assume you are able to run GC on both computers, hence the point of
> copying the db to the second one. E.g., I routinely archive my db from my
> Ubuntu 17.04 machine to a 5TB USB drive so I can restore it to my Windows
> 10 laptop when I'm on the road and vice versa to sync my backup repository.
>
> - Art
>
> On Friday, September 15, 2017, 6:13:36 PM EDT, Roger Oliver <
> ro...@olivermx.net> wrote:
>
>
> I can't seem to get the GnuCash files to back up to an external hard disk.
> The files show that they are there but when I try to find them on another
> computer to have a copy off site, the files are not there. What am I doing
> wrong? Thanks, Roger Oliver
>
> __ _
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/ mailman/listinfo/gnucash-user
> <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
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: Backup help

[Roger Oliver]

Windows 7 and 10. Mostly interested in a backup copy off the main computer
in case it crashes. Mine did, the Windows 10 machine. All my GC data was
restored from the Carbonite backup. Grateful it worked. The 7 machine is at
the school dedicated to accounting. I think there is something wrong with
the WinDrive external hard drive. Thanks!

On Sep 15, 2017 6:08 PM, "Art" <pina...@yahoo.com> wrote:

What are the OSes on the source and target computers?
What is the external hard disk filesystem and how do you know it's
compatible with both computers?

I assume you are able to run GC on both computers, hence the point of
copying the db to the second one. E.g., I routinely archive my db from my
Ubuntu 17.04 machine to a 5TB USB drive so I can restore it to my Windows
10 laptop when I'm on the road and vice versa to sync my backup repository.

- Art

On Friday, September 15, 2017, 6:13:36 PM EDT, Roger Oliver <
ro...@olivermx.net> wrote:


I can't seem to get the GnuCash files to back up to an external hard disk.
The files show that they are there but when I try to find them on another
computer to have a copy off site, the files are not there. What am I doing
wrong? Thanks, Roger Oliver

___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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.