Re: [GNC] UK VAT and "Making Tax Digital"

[Maf. King]

On Wednesday, 1 May 2019 01:14:34 BST you wrote:
> Oops realised that recording the capital purchase as expense then
> immediately create a kludge txn from expense to capital-asset won't work:
> it would be classed as a 'refund'. I have no other workaround.
> 
> Just wondering what exactly are the parameters for your reports?
> 

Ah, yes. that won't work!

I need to understand the Australian page more fully, but in the UK every VAT 
transaction *has* 3 or more spilts - eg Bank, Expenses:Widgets 
Asset:CapitalEquipment:WidgetSharpenerTool and VAT:Box4  

I'd imagine, without much detailed thought, that the GST report might struggle 
if a COGS account were ever involved too?

The UK VAT return needs 7 numbers.  

Box 1  : VAT Due on sales & other outputs
Box 2: Reverse VAT due on purchases from the EU
Box 3 is the sum of box 1&2 - Total VAT Due 
Box 4  Total VAT claimed on inputs - inc. EU purchases reverse VAT
Box 5 is return total ie Box 3 - Box 4 

My CoA has a sub tree called VAT (type Liability), under which there are 3 
accounts, for Box1, Box2 (both type Liability) and Box4 (type asset)

I don't do EU purchases very often, so I have done box 2 manually.
My current saved reports for Box 1 & 4 are simply transaction reports on the 
relevant VAT collection accounts, with a filter to exclude the actual VAT 
payment to the government that happens each quarter (is box 1 report has a 
single reporting account, and filter account excludes box4)

The more cumbersome boxes on the VAT return are 6 - 9.

Box 6 is Total ex VAT sales & outputs (inc box 8 subtotal)
Box 7 is Total ex VAT purchases & inputs (inc Box 9 subtotal)
Box 8 is supplies of goods ex VAT to EU member states (ie 0% VAT)
Box 9 is purchases of goods ex VAT  from EU (ie reverse VAT)

Box 6 & 8 is a transaction report produced from the relevant Income Accounts.  
I use the subtotal of the Income:EU_Reverse_VAT account for box 8 and the final 
total gives box 6

Box 7 is a transaction report across Assets:Capital Equipment and the relevant 
accounts from the Expenses Tree.   

I've done Box 9 manually by looking at the transaction report for box 2, with 
all splits showing.  My CoA is probably sub-optimal for reporting on EU 
purchases, but they are so infrequent for me that I've used the manual method 
perhaps twice in 3 years.

When I first set GC up for VAT, I was guided by a post from Vincent V to the 
User list on 2003-07-21 at 12:44 CDT that might offer you some insight. 

I can't see a way to not include the capital assets accounts in the reports.  
The whole point of the MTD is to remove the manual steps from the loop and 
keep everything in the computer.  

Let me know if you need any more info.  As I say, my VAT is not as complicated 
as others might have as most of my trade is within the UK, with a few sales of 
goods to EU member states and even fewer purchases from there.


Thanks for your time on this,
Maf.




___
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] * Unsaved book - Gnucash

[Michael Hendry]

I’m using version 3.4 on Mac OS X High Sierra.

This comes up briefly in the Gnucash title bar when I’ve finished working on 
one file and File->Open another one, although the file that is being closed has 
definitely been saved already.

It doesn’t seem to have any adverse effect (apart from operator anxiety).

Michael

___
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] * Unsaved book - Gnucash

[John Ralls]

> On May 1, 2019, at 6:46 AM, Michael Hendry  wrote:
> 
> I’m using version 3.4 on Mac OS X High Sierra.
> 
> This comes up briefly in the Gnucash title bar when I’ve finished working on 
> one file and File->Open another one, although the file that is being closed 
> has definitely been saved already.
> 
> It doesn’t seem to have any adverse effect (apart from operator anxiety).

Michael,

GnuCash is currently written to always have a book to the point that when 
switching from one to another it creates one for the brief interval while the 
old one is closed and the new one is loading. That's the indication you're 
seeing. 

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
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] * Unsaved book - Gnucash

[Michael Hendry]

> On 1 May 2019, at 16:02, John Ralls  wrote:
> 
> 
> 
>> On May 1, 2019, at 6:46 AM, Michael Hendry  wrote:
>> 
>> I’m using version 3.4 on Mac OS X High Sierra.
>> 
>> This comes up briefly in the Gnucash title bar when I’ve finished working on 
>> one file and File->Open another one, although the file that is being closed 
>> has definitely been saved already.
>> 
>> It doesn’t seem to have any adverse effect (apart from operator anxiety).
> 
> Michael,
> 
> GnuCash is currently written to always have a book to the point that when 
> switching from one to another it creates one for the brief interval while the 
> old one is closed and the new one is loading. That's the indication you're 
> seeing. 
> 
> Regards,
> John Ralls
> 

Thanks, John.

I had suffered from premature Gnucash shutdown during file saving when I first 
started using 3.4, so I was alarmed that something similar might be happening.

IIRC that particular bug is fixed in 3.5.

Regards,

Michael Hendry
___
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] I can't see above the current widow

[Jonathan Silvey]

I have suspected that my problem may be my hardware or OS, to my
embarrassment. Thanks to all for trying.
Jonathan



On Tue, 30 Apr 2019 at 11:52, Nigel Stapley  wrote:

> I, too, am using 3.5 on WIndows 10 with no apparent problems.
>
> Nigel
>
> On Tue, 30 Apr 2019 at 06:00, Tony Vanson  wrote:
>
> > Hi Jonathan,
> > For the record, I'm using Gnucash V 3.5+(2019-03-30) and Windows 10
> > V10.0.17134 Build 17134.
> > I have attempted to duplicate your problem, with no result.
> > I can scroll fully up and down with the scroll wheel on the scroll bar,
> and
> > also when placed inside the body of all the registers.
> > Dragging the scroll bar up and down with the mouse also works for me as
> do
> > the arrow keys, both on the keyboard and the number pad. with the NumLock
> > off.
> > I may be way off base, but suspect more of an OS or hardware problem then
> > something to do with Gnucash.
> > Cheers
> >
> > On Tue, Apr 30, 2019 at 9:34 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> > > Not sure what you mean by ‘very full’ as there is no such thing as far
> as
> > > I am aware. But if the account has only a handful of transactions in
> it,
> > > then certainly, the scroll bar won’t be very long/tall.
> > >
> > >
> > >
> > > If the bug already has been filed, then when it is fixed, you’ll see it
> > > listed in the release notes here on the list. (also posted to the
> > website I
> > > believe)
> > >
> > > If the bug has not been filed, then you’d need to file one or it will
> > > likely never get fixed.
> > >
> > > Goto bugzilla.gnucash.org, sign up for an account, and file the bug so
> > > the devs know there is a potential problem.
> > >
> > > Regards,
> > > Adrien
> > >
> > > > On Apr 29, 2019, at 5:20 PM, Jonathan Silvey <
> > jonathan.sil...@gmail.com>
> > > wrote:
> > > >
> > > > It happens whether an account is very full or nearly empty.
> > > >
> > > > If there is a bug when using Windows 10 and Gnucash 3.5, will I be
> told
> > > whenit is fixed?
> > > >
> > > > Thanks for trying.
> > > >
> > > > Jonathan
> > > >
> > >
> > >
> > > ___
> > > 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.
> > >
> >
> >
> > --
> > *Tony Vanson*
> >
> > *The older I get,*
> > *the better I was*
> > ___
> > 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.
>
___
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] Please respond to this request for help!

[David Jaggar]

Hello Sachin,
I'm in Britain, so with the time difference, it has meant a delay in
following up.
Good thinking to install on another computer. I did that on a friend's
computer (also Windows 10) and it installed with no problem. However, I
downloaded the 3.5 version again, and still have the problem. I also find
that I can no longer reinstall my earlier version (2.1.16 ver) because I
have the same problem: the dtaus.xml file stops in the installation and
task manager indicates that the setup is suspended.

I am completely unfamiliar with Linux.

Thanks for suggestions,
David.


On Tue, 30 Apr 2019 at 21:25, Sachin Danave  wrote:

> Hi David
>
> Some basic points. Did you try downloading the program again and
> reinstalling it? Can you try installing on another computer?
>
> I have installed and am using Gnucash on Windows 10 without much hiccups.
>
> If you have a good RAM on your machine, you can install a VM of a Linux
> distro and try installing.
>
> Hope this helps
>
> Regards
>
> Sachin
>
> On Wed, 1 May 2019, 01:37 David Jaggar,  wrote:
>
>> Hello Maf King,
>>
>> Thanks for getting back to me. Since I sent my post to the list, I
>> actually
>> did find an earlier version and installed that with no problem. However, I
>> then ended up with more problems! The GnuCash software program seems to
>> work OK, but when I open my Gnucash data file, I have this error message:
>> "Gnucash could not obtain the lock for [and then it lists the directory of
>> folders to get to the location of the file]. That database may be in use
>> by
>> another user, in which case you should not save the database. Do you want
>> to proceed with saving the database?"
>> It gives me the option to open the database anyway, which I then do.
>>
>> However, when I come to save the file, I get this error message:
>> "Could not make a backup of this file [and then it lists the folder tree
>> and ends with the database filename.gnucash]"
>>
>> I am forced to close the software program without being able to save the
>> new entries.
>> Then I have the option to cancel or save. However, if I choose to save, it
>> asks for a new file name, but then that doesn't work, and I'm forced to
>> close the file without being able to save it.
>>
>> I just don't know how I can actually use my database to enter new data and
>> save it again. I can read my previously entered data though.
>>
>> Any ideas?
>> David.
>> davidjag...@gmail.com
>>
>> On Tue, 30 Apr 2019 at 19:22, Maf. King  wrote:
>>
>> > On Tuesday, 30 April 2019 19:02:07 BST David Jaggar wrote:
>> > > Hello All:
>> > > This is my second request; no response to my first one.
>> > > I cannot get Gnucash 3.5 to install on Windows 10. The dtaus.xml file
>> is
>> > > suspended during the installation process and the whole installation
>> > hangs
>> > > up. Gnucash 3.5 has removed the earlier version, so I can't go back to
>> > > that. Right now I am unable to use the accounting program. I have 5
>> years
>> > > worth of records and need immediate assistance to be able to access my
>> > data.
>> > > Can someone please get in touch to help? I am just an end user, not
>> > skilled
>> > > in the software program itself.
>> > > I am also willing to pay for professional competent technical support
>> > > because I must have access to this data.
>> > > Cheers,
>> > > David.
>> >
>> > Hi David.
>> >
>> > Can you download an older version (3.4 or whatever) from links on the GC
>> > website and install that?
>> >
>> > 0.02
>> > Maf.
>> >
>> >
>> >
>> >
>> >
>> ___
>> 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 H. Jaggar, MRCVS, DC

Snail mail:
26th October 2018 to 16th April 2019:
1217 Cedar Avenue
Boulder
CO 80304
US of A
Voicemail:
+1 (303) 449-7131 - home
+1 (303) 506-0025 - mobile
E-mail: davidjag...@gmail.com

17th April 2019 to 17th October 2019:
Uwch y Don
Church Bay
Rhydwyn, Holyhead
Ynys Môn, Wales
LL65 4HA
The British Isles

Voicemail:
+44 (1407) 730-146 - home
+44 (7399) 304-685 - mobile
E-mail: davidjag...@gmail.com

The above also applies to Jenai Services.
This e-mail is sent on behalf of David H. Jaggar, MRCVS, DC. Its contents
are confidential to the intended recipient and may be legally privileged.
If you are not the intended recipient:
1) you must not disclose, copy, or distribute its contents to any other
person nor use its contents in any way;
2) please contact David H. Jaggar immediately on (1)303-506-0025  quoting
the name of the sender and the addressee, then delete it from your system.
David H. Jaggar has scanned this e-mail for viruses but does not accept any

Re: [GNC] Please respond to this request for help!

[David Jaggar]

Hello Adrien,
I had already done all your suggestions but there was no change in the
outcome.
Thanks,
David.

On Tue, 30 Apr 2019 at 21:34, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Removing the .lck file in your data directory before trying to re-open
> might do the trick. Normally choosing ‘open anyway’ will do this for you,
> but perhaps it is getting stuck. Also, be sure you are not accidentally
> opening a backup file. (contains a date string in the filename) Be certain
> to open GnuCash first, instead of double-clicking the data file. Verify the
> file name at the top of the window is what you want, else use File > Open
> to get to the correct one.
>
> Regards,
> Adrien
>
> > On Apr 30, 2019, at 3:25 PM, Sachin Danave 
> wrote:
> >
> > Hi David
> >
> > Some basic points. Did you try downloading the program again and
> > reinstalling it? Can you try installing on another computer?
> >
> > I have installed and am using Gnucash on Windows 10 without much hiccups.
> >
> > If you have a good RAM on your machine, you can install a VM of a Linux
> > distro and try installing.
> >
> > Hope this helps
> >
> > Regards
> >
> > Sachin
> >
> > On Wed, 1 May 2019, 01:37 David Jaggar,  wrote:
> >
> >> Hello Maf King,
> >>
> >> Thanks for getting back to me. Since I sent my post to the list, I
> actually
> >> did find an earlier version and installed that with no problem.
> However, I
> >> then ended up with more problems! The GnuCash software program seems to
> >> work OK, but when I open my Gnucash data file, I have this error
> message:
> >> "Gnucash could not obtain the lock for [and then it lists the directory
> of
> >> folders to get to the location of the file]. That database may be in
> use by
> >> another user, in which case you should not save the database. Do you
> want
> >> to proceed with saving the database?"
> >> It gives me the option to open the database anyway, which I then do.
> >>
> >> However, when I come to save the file, I get this error message:
> >> "Could not make a backup of this file [and then it lists the folder tree
> >> and ends with the database filename.gnucash]"
> >>
> >> I am forced to close the software program without being able to save the
> >> new entries.
> >> Then I have the option to cancel or save. However, if I choose to save,
> it
> >> asks for a new file name, but then that doesn't work, and I'm forced to
> >> close the file without being able to save it.
> >>
> >> I just don't know how I can actually use my database to enter new data
> and
> >> save it again. I can read my previously entered data though.
> >>
> >> Any ideas?
> >> David.
> >> davidjag...@gmail.com
> >>
> >> On Tue, 30 Apr 2019 at 19:22, Maf. King  wrote:
>
>
> ___
> 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 H. Jaggar, MRCVS, DC

Snail mail:
26th October 2018 to 16th April 2019:
1217 Cedar Avenue
Boulder
CO 80304
US of A
Voicemail:
+1 (303) 449-7131 - home
+1 (303) 506-0025 - mobile
E-mail: davidjag...@gmail.com

17th April 2019 to 17th October 2019:
Uwch y Don
Church Bay
Rhydwyn, Holyhead
Ynys Môn, Wales
LL65 4HA
The British Isles

Voicemail:
+44 (1407) 730-146 - home
+44 (7399) 304-685 - mobile
E-mail: davidjag...@gmail.com

The above also applies to Jenai Services.
This e-mail is sent on behalf of David H. Jaggar, MRCVS, DC. Its contents
are confidential to the intended recipient and may be legally privileged.
If you are not the intended recipient:
1) you must not disclose, copy, or distribute its contents to any other
person nor use its contents in any way;
2) please contact David H. Jaggar immediately on (1)303-506-0025  quoting
the name of the sender and the addressee, then delete it from your system.
David H. Jaggar has scanned this e-mail for viruses but does not accept any
responsibility for viruses once this e-mail has been transmitted. You
should scan attachments (if any) for viruses.
___
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] Please respond to this request for help!

[Derek Atkins]

Do you have a firewall or virus scanner installed and running?
Could you (temporarily) disable it while installing GnuCash?
It sounds like it might be interfering (false positive).
-derek

On Wed, May 1, 2019 12:32 pm, David Jaggar wrote:
> Hello Sachin,
> I'm in Britain, so with the time difference, it has meant a delay in
> following up.
> Good thinking to install on another computer. I did that on a friend's
> computer (also Windows 10) and it installed with no problem. However, I
> downloaded the 3.5 version again, and still have the problem. I also find
> that I can no longer reinstall my earlier version (2.1.16 ver) because I
> have the same problem: the dtaus.xml file stops in the installation and
> task manager indicates that the setup is suspended.
>
> I am completely unfamiliar with Linux.
>
> Thanks for suggestions,
> David.
>
>
> On Tue, 30 Apr 2019 at 21:25, Sachin Danave 
> wrote:
>
>> Hi David
>>
>> Some basic points. Did you try downloading the program again and
>> reinstalling it? Can you try installing on another computer?
>>
>> I have installed and am using Gnucash on Windows 10 without much
>> hiccups.
>>
>> If you have a good RAM on your machine, you can install a VM of a Linux
>> distro and try installing.
>>
>> Hope this helps
>>
>> Regards
>>
>> Sachin
>>
>> On Wed, 1 May 2019, 01:37 David Jaggar,  wrote:
>>
>>> Hello Maf King,
>>>
>>> Thanks for getting back to me. Since I sent my post to the list, I
>>> actually
>>> did find an earlier version and installed that with no problem.
>>> However, I
>>> then ended up with more problems! The GnuCash software program seems to
>>> work OK, but when I open my Gnucash data file, I have this error
>>> message:
>>> "Gnucash could not obtain the lock for [and then it lists the directory
>>> of
>>> folders to get to the location of the file]. That database may be in
>>> use
>>> by
>>> another user, in which case you should not save the database. Do you
>>> want
>>> to proceed with saving the database?"
>>> It gives me the option to open the database anyway, which I then do.
>>>
>>> However, when I come to save the file, I get this error message:
>>> "Could not make a backup of this file [and then it lists the folder
>>> tree
>>> and ends with the database filename.gnucash]"
>>>
>>> I am forced to close the software program without being able to save
>>> the
>>> new entries.
>>> Then I have the option to cancel or save. However, if I choose to save,
>>> it
>>> asks for a new file name, but then that doesn't work, and I'm forced to
>>> close the file without being able to save it.
>>>
>>> I just don't know how I can actually use my database to enter new data
>>> and
>>> save it again. I can read my previously entered data though.
>>>
>>> Any ideas?
>>> David.
>>> davidjag...@gmail.com
>>>
>>> On Tue, 30 Apr 2019 at 19:22, Maf. King  wrote:
>>>
>>> > On Tuesday, 30 April 2019 19:02:07 BST David Jaggar wrote:
>>> > > Hello All:
>>> > > This is my second request; no response to my first one.
>>> > > I cannot get Gnucash 3.5 to install on Windows 10. The dtaus.xml
>>> file
>>> is
>>> > > suspended during the installation process and the whole
>>> installation
>>> > hangs
>>> > > up. Gnucash 3.5 has removed the earlier version, so I can't go back
>>> to
>>> > > that. Right now I am unable to use the accounting program. I have 5
>>> years
>>> > > worth of records and need immediate assistance to be able to access
>>> my
>>> > data.
>>> > > Can someone please get in touch to help? I am just an end user, not
>>> > skilled
>>> > > in the software program itself.
>>> > > I am also willing to pay for professional competent technical
>>> support
>>> > > because I must have access to this data.
>>> > > Cheers,
>>> > > David.
>>> >
>>> > Hi David.
>>> >
>>> > Can you download an older version (3.4 or whatever) from links on the
>>> GC
>>> > website and install that?
>>> >
>>> > 0.02
>>> > Maf.
>>> >
>>> >
>>> >
>>> >
>>> >
>>> ___
>>> 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 H. Jaggar, MRCVS, DC
>
> Snail mail:
> 26th October 2018 to 16th April 2019:
> 1217 Cedar Avenue
> Boulder
> CO 80304
> US of A
> Voicemail:
> +1 (303) 449-7131 - home
> +1 (303) 506-0025 - mobile
> E-mail: davidjag...@gmail.com
>
> 17th April 2019 to 17th October 2019:
> Uwch y Don
> Church Bay
> Rhydwyn, Holyhead
> Ynys Môn, Wales
> LL65 4HA
> The British Isles
>
> Voicemail:
> +44 (1407) 730-146 - home
> +44 (7399) 304-685 - mobile
> E-mail: davidjag...@gmail.com
>
> The above also applies to Jenai Services.
> This e-mail is sent on behalf of David H

Re: [GNC] De-Reconciliation Settings

[Justin Vallon]

Just chiming in here.

The "Reset Warnings" is about whether GnuCash should ask again (and
again) and annoy you ("Save changes to transaction?"), or be silent
about its action (automatically save changes).  It only makes the
warning dialog choice automatic; it does not enable any additional features.

As to de-reconciling, it is not clear to me why changing the date
requires a re-reconcile.  Changing the date of a transaction does not
affect the reconciled balance.  After changing the date/description of a
split, I need to return the account(s), re-enter the last known
reconciled date and balance, and restore the reconciled-state, even
though nothing could possibly have changed that would affect the balance.

If the concern is that modifying transaction information should require
a re-review of the account, then de-reconciling should be an option.  On
the other hand, a warning about "You are editing a reconciled split;
proceed?" should give just as much feedback to make sure the user is
re-reviewing the edit (and leave the split reconciled).

Certainly, changing the account or amount will require a re-reconcile. 
However, I would rather not have to re-reconcile for immaterial changes
to transaction date, transaction number, transaction description, or
split description.

It would seem the opinion here is whether "transaction description" (and
the others) is a material change.  It seems like that would be a good
choice for an option, maybe per-attribute (tran date, tran num, tran
desc, split num, split desc).

-Justin


On 4/29/19 11:16 AM, David T. via gnucash-user wrote:
> John,
>
> I accept your points regarding the dialog. It would be nice still to see what 
> those options might be.
>
> As for editing transaction-level data and having splits de-reconciled, it may 
> be that changing the date makes sense, but I disagree when the description is 
> edited. To be sure, it is unfortunate that the data elements in common usage 
> do not fall into strictly acceptable boundaries; nonetheless, I think that 
> the Description field should not be one of those transaction-level fields 
> that forces a user to re-reconcile multiple accounts.
>
> Best,
> David
>
>> On Apr 29, 2019, at 8:28 PM, John Ralls  wrote:
>>
>>
>>
>>> On Apr 29, 2019, at 12:54 AM, David T. via gnucash-user 
>>>  wrote:
>>>
>>> It was pointed out to me in another thread that one can reset specific 
>>> warnings flags using Action->Reset Warnings. 
>>>
>>> I’d like to raise a couple of points with this dialog, now that I have been 
>>> introduced to it…
>>>
>>> First off, the dialog is quite opaque, insofar as it is (apparently) only 
>>> showing warnings for which I have selected options previously. There is no 
>>> way for me to determine what (if any) other options I have here. I imagine 
>>> it would be a whole lot clearer if I could have a listing of all the 
>>> various options, along with their current setting. It is counterintuitive 
>>> to me the way it is set up here.
>>>
>>> Be that as it may, I have three entries listed here: “Change contents of 
>>> reconciled split”“Remove a split from a transaction”“Commit changes to a 
>>> transaction”
>>>
>>> The first setting listed here refers to the behavior of de-reconciling a 
>>> split in GnuCash. However, if a user changes Transaction-level data 
>>> elements—such as the Description field—a split will become de-reconciled. 
>>> Therefore, this preference is misnamed, and should be changed, since I 
>>> should receive an alert if I change the description and the reconcile flag 
>>> gets reset. Perhaps “Change reconcile flag upon edit” would be better?
>>>
>>> Second, it seems to me that the boundary for when a split becomes 
>>> de-reconciled needs to be drawn differently. I know this issue was 
>>> discussed recently, and there were reasons given for why the logic falls 
>>> the way it does. However, reconciliation applies to the *split*, as shown 
>>> by the fact that each split in a transaction can be separately reconciled 
>>> in its own account. Changing the status of the split based on a change in 
>>> the transaction is inconsistent and illogical to me. 
>>>
>>> I have transactions with as many as ten splits, in which several splits are 
>>> reconciled. If, for some reason, I then change the description of the 
>>> transaction, then every one of those reconciled splits will get 
>>> de-reconciled-- requiring me to reconcile every linked account.
>>>
>>> Finally, I will note that the program is at least consistent, in that when 
>>> you change a description field, it does in fact change every cleared split 
>>> in that transaction. I do, however, question whether that is the correct 
>>> action to impose. 
>>>
>> David,
>>
>> Did you read the description at the top of the dialog? It says 
>> "You have requested that the following warning dialogs not be presented. To 
>> re-enable any of these dialogs, select the check box next to the dialog, 
>> then click OK."
>>
>> What's unclear 

Re: [GNC] Please respond to this request for help!

[David Jaggar]

Hello Derek,
Just as have installed from Windows 10 OS, so ought not to be any problem
as works on another Windows 10 computer with similar setup.
David

On Wed, 1 May 2019 at 17:37, Derek Atkins  wrote:

> Do you have a firewall or virus scanner installed and running?
> Could you (temporarily) disable it while installing GnuCash?
> It sounds like it might be interfering (false positive).
> -derek
>
> On Wed, May 1, 2019 12:32 pm, David Jaggar wrote:
> > Hello Sachin,
> > I'm in Britain, so with the time difference, it has meant a delay in
> > following up.
> > Good thinking to install on another computer. I did that on a friend's
> > computer (also Windows 10) and it installed with no problem. However, I
> > downloaded the 3.5 version again, and still have the problem. I also find
> > that I can no longer reinstall my earlier version (2.1.16 ver) because I
> > have the same problem: the dtaus.xml file stops in the installation and
> > task manager indicates that the setup is suspended.
> >
> > I am completely unfamiliar with Linux.
> >
> > Thanks for suggestions,
> > David.
> >
> >
> > On Tue, 30 Apr 2019 at 21:25, Sachin Danave 
> > wrote:
> >
> >> Hi David
> >>
> >> Some basic points. Did you try downloading the program again and
> >> reinstalling it? Can you try installing on another computer?
> >>
> >> I have installed and am using Gnucash on Windows 10 without much
> >> hiccups.
> >>
> >> If you have a good RAM on your machine, you can install a VM of a Linux
> >> distro and try installing.
> >>
> >> Hope this helps
> >>
> >> Regards
> >>
> >> Sachin
> >>
> >> On Wed, 1 May 2019, 01:37 David Jaggar,  wrote:
> >>
> >>> Hello Maf King,
> >>>
> >>> Thanks for getting back to me. Since I sent my post to the list, I
> >>> actually
> >>> did find an earlier version and installed that with no problem.
> >>> However, I
> >>> then ended up with more problems! The GnuCash software program seems to
> >>> work OK, but when I open my Gnucash data file, I have this error
> >>> message:
> >>> "Gnucash could not obtain the lock for [and then it lists the directory
> >>> of
> >>> folders to get to the location of the file]. That database may be in
> >>> use
> >>> by
> >>> another user, in which case you should not save the database. Do you
> >>> want
> >>> to proceed with saving the database?"
> >>> It gives me the option to open the database anyway, which I then do.
> >>>
> >>> However, when I come to save the file, I get this error message:
> >>> "Could not make a backup of this file [and then it lists the folder
> >>> tree
> >>> and ends with the database filename.gnucash]"
> >>>
> >>> I am forced to close the software program without being able to save
> >>> the
> >>> new entries.
> >>> Then I have the option to cancel or save. However, if I choose to save,
> >>> it
> >>> asks for a new file name, but then that doesn't work, and I'm forced to
> >>> close the file without being able to save it.
> >>>
> >>> I just don't know how I can actually use my database to enter new data
> >>> and
> >>> save it again. I can read my previously entered data though.
> >>>
> >>> Any ideas?
> >>> David.
> >>> davidjag...@gmail.com
> >>>
> >>> On Tue, 30 Apr 2019 at 19:22, Maf. King  wrote:
> >>>
> >>> > On Tuesday, 30 April 2019 19:02:07 BST David Jaggar wrote:
> >>> > > Hello All:
> >>> > > This is my second request; no response to my first one.
> >>> > > I cannot get Gnucash 3.5 to install on Windows 10. The dtaus.xml
> >>> file
> >>> is
> >>> > > suspended during the installation process and the whole
> >>> installation
> >>> > hangs
> >>> > > up. Gnucash 3.5 has removed the earlier version, so I can't go back
> >>> to
> >>> > > that. Right now I am unable to use the accounting program. I have 5
> >>> years
> >>> > > worth of records and need immediate assistance to be able to access
> >>> my
> >>> > data.
> >>> > > Can someone please get in touch to help? I am just an end user, not
> >>> > skilled
> >>> > > in the software program itself.
> >>> > > I am also willing to pay for professional competent technical
> >>> support
> >>> > > because I must have access to this data.
> >>> > > Cheers,
> >>> > > David.
> >>> >
> >>> > Hi David.
> >>> >
> >>> > Can you download an older version (3.4 or whatever) from links on the
> >>> GC
> >>> > website and install that?
> >>> >
> >>> > 0.02
> >>> > Maf.
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> ___
> >>> 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 H. Jaggar, MRCVS, DC
> >
> > Snail mail:
> > 26th October 2018 to 16th April 

Re: [GNC] Handling Prepayments

[Adrien Monteleone]

Your welcome!

Please, always be sure to copy the list, especially for ’that solved my 
problem’ sorts of replies so others can know in the future if the question was 
answered/problem resolved in case they are seeking help on a similar topic.

Regards,
Adrien

> On May 1, 2019, at 9:13 AM, David Burleigh  wrote:
> 
> Thank you for your response to my question about prepayments. That solved my 
> problem!


___
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] 8.1 Find (^F) set default search preferences?

[Adrien Monteleone]

I would think having to move the window around/send it to the background (and 
then bring it up front again when you need it) is more of a pain than hitting 
^F / ⌘F.

Remember, GnuCash has to accommodate many screen sizes, not just people with 
1080 and larger WXGA displays that have the room to keep a Find dialog open 
next to the main window. Some people are using this app on netbooks.

But if it is simple enough to implement, I could see that it would be a nice 
option. (and I have plenty of screen space, so I’d be happy to have it as well)

Regards,
Adrien



> On Apr 29, 2019, at 3:40 PM, Colin Law  wrote:
> 
> I would very much like the search window to remember the previous
> settings when it is re-opened.  Very often I find myself just making a
> small change and it is a pain to have to re-enter it.
> 


___
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] Please respond to this request for help!

[Maf. King]

On Wednesday, 1 May 2019 17:32:49 BST David Jaggar wrote:
> Hello Sachin,
> I'm in Britain, so with the time difference, it has meant a delay in
> following up.
> Good thinking to install on another computer. I did that on a friend's
> computer (also Windows 10) and it installed with no problem. However, I
> downloaded the 3.5 version again, and still have the problem. I also find
> that I can no longer reinstall my earlier version (2.1.16 ver) because I
> have the same problem: the dtaus.xml file stops in the installation and
> task manager indicates that the setup is suspended.
> 

Hi David,

2.1.16 is *very* old, and probably a development version too.

Can you try 3.4  https://sourceforge.net/projects/gnucash/files/
gnucash%20%28stable%29/3.4/, 

or at least 2.6.21
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.21/

(both found from the  gnucash.org  index page then the "More Downloads" link


Maf.





___
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] 8.1 Find (^F) set default search preferences?

[Jeff Albrecht]

The major pain, for me at least, is not so much the ^F but the constant 
changing of the 'Find Transaction' options from 'Description' to 'Value' 
It's the only way I've used ^F so far - Value and has credits or debits 
-> equal to. I can see that flexibility of 'Find Transaction' will be 
very useful at some time. In my current marathon accounting balancing 
sessions (Still converting from Quicken*) I'm sure I've entered ^F 
nearly a hundred times or more.


How about something like some combinations of these;
- A Boolean check box to save the options on close in the "Find 
Transaction' window.

 -- Perhaps another check box for windows to remain open.
- A preference to save the last used options in the 'Find Transaction' 
window.
- An additional 'quick find' initiated by ^F that uses the value->has 
credits or debits->equal to and move the full find to menu initiated only.




* ProTip; Don't procrastinate more than three months to import new .OFX 
transactions as many institutions only save three months available online.


 - Jeff


On 5/1/2019 10:16 AM, Adrien Monteleone wrote:

I would think having to move the window around/send it to the background (and 
then bring it up front again when you need it) is more of a pain than hitting 
^F / ⌘F.

Remember, GnuCash has to accommodate many screen sizes, not just people with 
1080 and larger WXGA displays that have the room to keep a Find dialog open 
next to the main window. Some people are using this app on netbooks.

But if it is simple enough to implement, I could see that it would be a nice 
option. (and I have plenty of screen space, so I’d be happy to have it as well)

Regards,
Adrien




On Apr 29, 2019, at 3:40 PM, Colin Law  wrote:

I would very much like the search window to remember the previous
settings when it is re-opened.  Very often I find myself just making a
small change and it is a pain to have to re-enter it.



___
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] Equity Calculation on the Balance Sheet

[Adrien Monteleone]

Tom,

I just re-read over this reply and have few things you may want to consider:

Assuming you still don’t have any entries this year in AP,

1. What is the date of the Balance Sheet you are running? (end of 2018? today?)

2. Are there any future posted transactions in the AP register, if you see a 
blue line between any two transactions, the ones below it are in the future.

3. Have you entered *anything* manually in the AP register? (pre-payments?)

4. The lots might all be matched, but have you verified that they are matched 
correctly?

-

1. is what I meant by ‘dates’ being an issue. The BS will only agree with the 
register if it is on the same (or later) date. It certainly wouldn’t agree with 
it if the BS was for a date where there are later transactions in the register.

2. considering #1, future transactions would then certainly make the two not 
agree unless you ran the BS for a date that would include those future 
transactions in the calculation.

3. The Business Features are not cognizant of any manually entered transactions 
in AP. While the BS should see them, I don’t know what that report code 
actually looks at. (It should simply grab the AP balance) Certainly the Aging 
report wouldn’t see such entries.

4. At one time, I was making a mess of my AR & AP accounts by unposting and 
reposting historical invoices because I was adding info I didn’t think to 
record previously. (and refactoring some expense and revenue accounts) While 
GnuCash tries to keep up and re-apply payments correctly, sometimes it gets it 
wrong, especially if there are outstanding pre-payments yet to be applied. At 
one time, I found a situation that after manually fixing many lot assignments 
and re-applying payments, I must have made a mess of things and had some 
duplicate payment lots. (not really sure exactly how that happened) I had to 
walk back through the register and the lots window transaction by transaction, 
bill by bill, invoice by invoice, and payment by payment to get it all 
straight. I know that sounds daunting, but a full lot review (not just a 
cursory glance) may be in order. If you do so, pay special attention to lot 
dates on payments as one or more may show up more than once on different bills.

-

Finally, or maybe something to look for first, the difference between the two 
figures is $382.10. Do you have any transactions (in any account or missing 
from any account) for that exact amount? (you have a missing entry error, a 
double posting error, or an account assignment error)

For exactly half that amount $191.05? (you have this debit/credit backwards)

The difference isn’t divisible by 9 so it isn’t a transposition error, and it 
isn’t 3, 30, 300 so it isn’t a 10-key error.

Does the AP balance reported by the BS of $465.75 appear as the exact balance 
of the account at the end of *any* transaction in the AP Register? If so, 
transactions after this one are suspect.



Regards,
Adrien

> On Apr 16, 2019, at 10:41 AM, Tom Balaban  wrote:
> 
> Hi Adrien,
> 
> Thanks for that explanation.
> 
> On the issue of different amounts in the BS and the aged payables, I don't 
> know where to go to get this resolved.
> 
> The Aged Payables report show $83.65, The bottom of the AP ledger shows 
> $83.65. There are no unmatched lots in the AP ledger. Since we are a 
> seasonable business there have been no changes yet this year so the dates are 
> not an issue. Still the BS shows $465.75. AR is OK.
> 
> Any thoughts on how to track this down will be greatly appreciated,
> 
> Tom
> 
>> h.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] De-Reconciliation Settings

[Adrien Monteleone]

Justin,


> On May 1, 2019, at 11:46 AM, Justin Vallon  wrote:
> 
> Just chiming in here.
> 
> The "Reset Warnings" is about whether GnuCash should ask again (and
> again) and annoy you ("Save changes to transaction?"), or be silent
> about its action (automatically save changes).  It only makes the
> warning dialog choice automatic; it does not enable any additional features.
> 
> As to de-reconciling, it is not clear to me why changing the date
> requires a re-reconcile.  Changing the date of a transaction does not
> affect the reconciled balance.  After changing the date/description of a
> split, I need to return the account(s), re-enter the last known
> reconciled date and balance, and restore the reconciled-state, even
> though nothing could possibly have changed that would affect the balance.

Most certainly, changing the date *could* affect the balance. Indeed, the date 
and the amount are the only things that can.

Your case might have been one of changing the date to a new one -in the same 
period-. In that case, no, it wouldn’t affect the balance. But any other date 
change would. While your accounting periods may be simple and end on monthly 
boundaries, others may use a different calendar or boundary. (their periods 
might end on the 15th, or they might use 13 4-week periods per year)

While changing the date from say April to March won’t affect the overall 
account balance for April, it *will* affect the reconciled balance for March 
(since it was supposed to be included originally when that month was 
reconciled, but was not) and so that transaction should be marked as 
un-reconciled.

It is trivial to re-reconcile a period if the edit was minor and you do this 
quickly after the edit. (which is why the warning is there, and probably should 
not be turned off, so there is no ‘hidden’ clearing of flags)

> 
> If the concern is that modifying transaction information should require
> a re-review of the account, then de-reconciling should be an option.  On
> the other hand, a warning about "You are editing a reconciled split;
> proceed?" should give just as much feedback to make sure the user is
> re-reviewing the edit (and leave the split reconciled).

That’s what the warning does, it lets you know this is a reconciled 
transaction. Don’t turn it off if you want to see it. (I know, there is no 
option *not* to clear the flag. The workflow is to proceed with the edit and 
then re-reconcile the account)

> Certainly, changing the account or amount will require a re-reconcile. 
> However, I would rather not have to re-reconcile for immaterial changes
> to transaction date, transaction number, transaction description, or
> split description.

If *you* know the change was immaterial, simply click the Reconcile button in 
the toolbar while *still* viewing the account, change the date to the end of 
the affected period, check off the one transaction and click the button to 
complete the reconciliation.

We had a thread a few months back about what really needs to trigger the 
clearing of the flag. I’m of the opinion that only date and amount matter, I 
can see that perhaps NUM *might* be wise to keep, but personally don’t use it 
as a transaction number often. Certainly, correcting a typo in Description, 
notes, memo splits, or any splits that don’t affect the current register, 
should not clear the flag.

> 
> It would seem the opinion here is whether "transaction description" (and
> the others) is a material change.  It seems like that would be a good
> choice for an option, maybe per-attribute (tran date, tran num, tran
> desc, split num, split desc).

File an RFE on Bugzilla and/or contribute code to make it happen...

> 
> -Justin
> 


___
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] Please respond to this request for help!

[Adrien Monteleone]

As noted by Maf., 2.1.16 is ancient. It will not read the 3.x file. (if you got 
that far) I don’t think 2.1 will even install on Win10. (if you can even find 
it)

dtaus.xml has to do with Aqbanking. (allows you to make a transaction in your 
bank account *from* GnuCash) They dropped DTAUS support in their new version 6 
and GnuCash 3.5 is supposed to work with Aqbanking-v6, so not sure why you are 
getting that error. (the file, I should think, shouldn’t even be part of the 
package, unless it was retained for backwards compatibility with older systems.)

First, I’d do a system-wide search for the file and completely trash it. (the 
file might already be on the system and corrupted, causing a problem)

Then, download 2.6.21 and try that.

If that installs and you can successfully open your file, look over your data 
and make sure there are no problems.

When you are satisfied everything is okay, download 3.5-1 (an updated Windows 
installer) and install it.

Barring that, since you mention you’ve successfully installed 3.5 on a 
different Win10 machine, maybe a ‘refresh’ of Win10 is in order? (be sure to 
make a backup of everything first)

Regards,
Adrien



> On May 1, 2019, at 11:32 AM, David Jaggar  wrote:
> 
> Hello Sachin,
> I'm in Britain, so with the time difference, it has meant a delay in
> following up.
> Good thinking to install on another computer. I did that on a friend's
> computer (also Windows 10) and it installed with no problem. However, I
> downloaded the 3.5 version again, and still have the problem. I also find
> that I can no longer reinstall my earlier version (2.1.16 ver) because I
> have the same problem: the dtaus.xml file stops in the installation and
> task manager indicates that the setup is suspended.
> 
> I am completely unfamiliar with Linux.
> 
> Thanks for suggestions,
> David.
> 


___
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] De-Reconciliation Settings

[Geert Janssens]

Op woensdag 1 mei 2019 20:24:23 CEST schreef Adrien Monteleone:
> > Certainly, changing the account or amount will require a re-reconcile.
> > However, I would rather not have to re-reconcile for immaterial changes
> > to transaction date, transaction number, transaction description, or
> > split description.
> 
> If *you* know the change was immaterial, simply click the Reconcile button
> in the toolbar while *still* viewing the account, change the date to the
> end of the affected period, check off the one transaction and click the
> button to complete the reconciliation.
> 
> We had a thread a few months back about what really needs to trigger the
> clearing of the flag. I’m of the opinion that only date and amount matter,
> I can see that perhaps NUM *might* be wise to keep, but personally don’t
> use it as a transaction number often. Certainly, correcting a typo in
> Description, notes, memo splits, or any splits that don’t affect the
> current register, should not clear the flag.

Thanks for bringing that up. While I see the point, I am not fully convinced. 
Of course fixing a typo should not matter for reconciliation. But what if you 
accidentally change a description to something completely different (say you 
were confused and really wanted to change the transaction right above, a bad 
copy/paste, whatever human error you can think of, ...) and not immediately 
notice.

That means you now have changed the meaning of that transaction and it may be 
hard to find it back later in queries.

I believe the issue is there are several definitions of what reconciliation 
really is supposed to mean and hence what should or should not be protected.

For what it's worth all business accounting packages I have used in Belgium 
protect the full transaction once reconciled. There's not a single field I can 
still change.

I have no hard opinion on what is best or how to best tackle this to work for 
most people. Though I think getting a warning you're about to alter a 
reconciled transaction should not be that bad. It prevents accidental changes 
and still allows deliberate changes (which currently require a reconcile).

What we could perhaps do is this: keep the warning pretty strict, but only 
undo reconciliation if the change would alter the reconciliation balance 
(either a date change causes the transaction to fall outside of the 
reconciliation period is was in or the amount was changed). And document 
clearly what gnucash does.

> > It would seem the opinion here is whether "transaction description" (and
> > the others) is a material change.  It seems like that would be a good
> > choice for an option, maybe per-attribute (tran date, tran num, tran
> > desc, split num, split desc).
> 
> File an RFE on Bugzilla and/or contribute code to make it happen...

Preferably the latter...

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] 8.1 Find (^F) set default search preferences?

[Adrien Monteleone]

Jeff,

All three of those would be nice options. On that last one, office apps usually 
have a Find along with a more powerful Find & Replace as separate dialogs with 
their own shortcuts. (you don’t have to replace if you don’t want to, but the 
Find is more powerful in that iteration). I conceive something similar would be 
useful for finding transactions/splits of a certain value quickly, but 
retaining the full power for when you need it.

I agree, I rarely use ‘Description’ and would prefer at the least, it remember 
what I last used. (which is almost always `Memo` for me)

I’ll offer you a glimmer of light at the end of the tunnel that once you get 
through your conversion, you’ll probably be using Find much less often. I used 
it extensively the first 6 months I was entering data, now, maybe once a month 
at best.

I *find* that entering transactions each and every single day, rather then 
letting them pile up, also helps reduce the need to research via Find.

While many institutions only offer 90-days of online history, you could 
probably write, call, or visit in person (if possible) for a full history. 
Expect maybe they’ll charge you for the favor, though they might do it for free 
if they just export a file to you rather than send a printout. (and you 
probably don’t want the paper and manual data entry anyway)

Regards,
Adrien

> On May 1, 2019, at 12:55 PM, Jeff Albrecht  wrote:
> 
> The major pain, for me at least, is not so much the ^F but the constant 
> changing of the 'Find Transaction' options from 'Description' to 'Value' It's 
> the only way I've used ^F so far - Value and has credits or debits -> equal 
> to. I can see that flexibility of 'Find Transaction' will be very useful at 
> some time. In my current marathon accounting balancing sessions (Still 
> converting from Quicken*) I'm sure I've entered ^F nearly a hundred times or 
> more.
> 
> How about something like some combinations of these;
> - A Boolean check box to save the options on close in the "Find Transaction' 
> window.
>  -- Perhaps another check box for windows to remain open.
> - A preference to save the last used options in the 'Find Transaction' window.
> - An additional 'quick find' initiated by ^F that uses the value->has credits 
> or debits->equal to and move the full find to menu initiated only.
> 
> 
> 
> * ProTip; Don't procrastinate more than three months to import new .OFX 
> transactions as many institutions only save three months available online.
> 
>  - Jeff


___
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] De-Reconciliation Settings

[Adrien Monteleone]

> On May 1, 2019, at 1:40 PM, Geert Janssens  wrote:
> 
> 
> 
> For what it's worth all business accounting packages I have used in Belgium 
> protect the full transaction once reconciled. There's not a single field I 
> can 
> still change.

Even on paper, I was taught to do all accounting in ink and make correcting 
entries to fix errors. No editing or erasing was allowed.

A strict implementation of this would be possible since GnuCash already has the 
‘reverse transaction’ feature, but I doubt many would be happy with that move.

If this were a corporate accounting package, that would probably be a 
necessity. (and likely address, though not solve, many questions of ’security’ 
some people have from time to time on the list - hey, look, another option!)


> 
> I have no hard opinion on what is best or how to best tackle this to work for 
> most people. Though I think getting a warning you're about to alter a 
> reconciled transaction should not be that bad. It prevents accidental changes 
> and still allows deliberate changes (which currently require a reconcile).
> 
> What we could perhaps do is this: keep the warning pretty strict, but only 
> undo reconciliation if the change would alter the reconciliation balance 
> (either a date change causes the transaction to fall outside of the 
> reconciliation period is was in or the amount was changed). And document 
> clearly what gnucash does.

Not sure which would be easier, fire the warning on one set of criteria, but 
only clear the flag based on a subset, or fire the warning for everything, but 
only clear the flag if there is a boolean option in the dialog set to do so. 
(checked by default, or implemented as action buttons)

I would think the latter would involve less code, or at least less testing of 
criteria, thus a little cheaper. (I’m aware things that look cheap for code, 
aren’t always, but it sure looks that way abstractly to me for now) Do you have 
to test the transaction data against the criteria twice? Or just once and store 
the results temporarily to make the decision to clear flags? (and then read 
that stored data, trash it and clean up)

Regards,
Adrien
___
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] Account remains red after void that would put it in black

[Jeff Albrecht]

Is this a know bug? and/or could someone forward it to gnucash-devel if 
appropriate?


Windows 10 GNUCash version Version: 3.5 Build ID: 3.5+(2019-03-30)

I'm balancing a checking account. It has a positive amount for Present 
and Future in black. I don't specifically remember the Balance column.
I enter an adjusting entry that puts the account in negative and the 
Present and Future change to reflect that and change to parenthesis and red.
Doh! I entered that wrong so I void the transaction. (IMHO deleting a 
transaction should never be allowed. It voids the audit trail.)
After voiding the transaction the account is now positive however the 
color is still red.
I close and reopen the account, the Present and Future are now black as 
I would expect. It was a real head scratcher for a while as I just saw 
red (PUN intended) before realizing that the amount was displayed wrong, 
red instead of black.


FWIW I've had this happen several times in the last couple days of 
marathon balancing after Quicken Conversion last year. I couldn't put a 
finger on when it happens but It just occurred again so I wrote down the 
steps that I just completed. This behavior _may_ appear any time an 
account goes from red negative to black positive.



 - Jeff


___
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] De-Reconciliation Settings

[Geert Janssens]

Op woensdag 1 mei 2019 21:01:19 CEST schreef Adrien Monteleone:
> > On May 1, 2019, at 1:40 PM, Geert Janssens 
> > wrote:
> > 
> > 
> > 
> > For what it's worth all business accounting packages I have used in
> > Belgium
> > protect the full transaction once reconciled. There's not a single field I
> > can still change.
> 
> Even on paper, I was taught to do all accounting in ink and make correcting
> entries to fix errors. No editing or erasing was allowed.
> 
> A strict implementation of this would be possible since GnuCash already has
> the ‘reverse transaction’ feature, but I doubt many would be happy with
> that move.
> 
> If this were a corporate accounting package, that would probably be a
> necessity. (and likely address, though not solve, many questions of
> ’security’ some people have from time to time on the list - hey, look,
> another option!)
> > I have no hard opinion on what is best or how to best tackle this to work
> > for most people. Though I think getting a warning you're about to alter a
> > reconciled transaction should not be that bad. It prevents accidental
> > changes and still allows deliberate changes (which currently require a
> > reconcile).
> > 
> > What we could perhaps do is this: keep the warning pretty strict, but only
> > undo reconciliation if the change would alter the reconciliation balance
> > (either a date change causes the transaction to fall outside of the
> > reconciliation period is was in or the amount was changed). And document
> > clearly what gnucash does.
> 
> Not sure which would be easier, fire the warning on one set of criteria, but
> only clear the flag based on a subset, or fire the warning for everything,
> but only clear the flag if there is a boolean option in the dialog set to
> do so. (checked by default, or implemented as action buttons)
> 
> I would think the latter would involve less code, or at least less testing
> of criteria, thus a little cheaper. (I’m aware things that look cheap for
> code, aren’t always, but it sure looks that way abstractly to me for now)

It's one of those cases... The dialog that's currently used to pop-up the 
"change a reconciled transaction" is a generic one that's used for all the 
warnings we have. And that generic dialog has no provision for an extra 
boolean option. So if we want to go that route that means creating a separate  
dialog specifically for this use case. In addition the choice the user makes 
in this dialog has to be stored. Again this is one common method for all 
warnings. Adding a boolean option means we have to special case the storage of 
this warning.

Having said all that perhaps giving the user the choice is wiser after all in 
this case.

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.

[GNC] Problems with getting European share prices

[Eric Coates]

Hi

This is so weird it must be me ??? otherwise pandemonium would have 
reigned here!


About two weeks ago I upgraded my system to Ubuntu 18.10 and a few days 
later to 19.04 (ironically, I was trying to get around some problems) 
and installed GnuCash from the standard repository; so I am running 
GnuCash 3.4 with Finance::Quote 1.47 on Ubuntu 19.04.


As part of my usual work process, on 30^th April I updated my share 
prices as in the past I was using Alphavantage to get UK share prices 
and Yahoo-JSON to retrieve European prices. Then, as usual, went to 
check that everything was OK.


Although there were no error messages and all the names of my European 
shares were shown in the Price Database window there were no prices 
against any of them ??? and I mean NO prices. I know that there were some 
there at the end of March but everything had gone. Even the little 
triangular thingies were missing. As there are only half a dozen shares 
in this group I thought to add the prices ???by hand??? but I couldn???t do 
it, although I could fill I the fields and clicking Apply gave no 
messages nothing appeared in the database.


A further oddity is that in the table of accounts there is a Present 
value against each of the European shares ??? to get that GnuCash must be 
picking up some price from somewhere. I???ve done some checking around and 
I can???t find a reasonable explanation of how the price is determined.


I take an archive copy of the data file at the end of each month. I have 
opened several of them (using the standard GnuCash 3.4) and get the same 
behaviour with each of them.


As I said, it must be me but - any ideas of what I???m doing wrong.

Or failing that, would I be able to open the 3.5 data file with GnuCash 
2.6.21?


Eric

PS: For completeness:

I had not changed the Symbol for any share since the successful update 
at the end of March. The Yahoo site shows Deutsche Post as DPW.DE (not 
the DPW.F I had been using). Changing the symbol to DPW.DE gave no 
different result (again, not even no error message)



___
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] Unique entry date and transaction date availability?

[Jeff Albrecht]

I had quicken for a decade or more. Several accountant / bookkeepers 
worked on it with me.


I've found a transaction, now imported into GNUCash, that I feel may 
have been entered less than optimally. It's dated 4/9/2015 however I 
suspect it was entered at some other time when someone made an adjusting 
entry. They didn't document the transaction very much. I'm curious when 
the transaction was created vs the date it represents.


Is there a transaction creation date available and if so how may I 
display it.


I did find an email thread from September 2013...

"Starting with releases in the 2.5 series (which is still in alpha or
beta, depending on your opinion), the date entered will be visible if
you have your preferences set to show it."
https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050587.html

Searched through preferences a couple times. I'm not seeing it.

   - Jeff

___
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] Unique entry date and transaction date availability?

[Christian Kluge]

Am 01.05.2019 um 22:55 schrieb Jeff Albrecht:

> Is there a transaction creation date available and if so how may I
> display it.
> 
> I did find an email thread from September 2013...
> 
> "Starting with releases in the 2.5 series (which is still in alpha or
> beta, depending on your opinion), the date entered will be visible if
> you have your preferences set to show it."
> https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050587.html
> 
> Searched through preferences a couple times. I'm not seeing it.
> 

I don’t know which OS you’re using but on Linux with the experimental
features compile option I can start gnucash with the --extra option and
can enable this view in the Extensions/Register 2 General Journal

Kind regards

Christian Kluge


___
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] UK VAT and "Making Tax Digital"

[David Cousens]

Maf

The ATO portal last time I used it a couple of years ago is a copy of
physical form (which also has PAYG income tax payments added to it which I
have attached). 
BUS25195Nat4190s.pdf
   
I no longer have a business registered for GST so I no longer have access
the current portal. There is also a new Standard Business Reporting scheme
being introduced in which SBR enabled software (XML-JSON XBRL at the
lmessage level with encryption and authenticationnwrapers around that), and
that will directly upload and digitally sign returns.

I have tried digging around the message formats. The information on the ATO
site seems to be changing rapidly at the moment as the working group posts
more information on it. Initially the lack of information made me think that
the protocols were only being made available to the software developers in
the associated working group. To get access to the API and SDK you have to
register  asa developer with the ATO. If no-one else associated with GnuCash
has done that, I can see if they will let me register.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Unique entry date and transaction date availability?

[Jeff Albrecht]

Doh! Forgot to include platform and version. Windows 10 Version: 3.5 
Build ID: 3.5+(2019-03-30)


Working on it since 2013 and it's still experimental? :-) I'd sure like 
it to go into the Main branch. I feel it's a very important feature to 
have although not often used.


I looked around for a while "windows gnucash startup command line 
options" I guess there aren't any?


 - Jeff


On 5/1/2019 2:12 PM, Christian Kluge wrote:

Am 01.05.2019 um 22:55 schrieb Jeff Albrecht:


Is there a transaction creation date available and if so how may I
display it.

I did find an email thread from September 2013...

"Starting with releases in the 2.5 series (which is still in alpha or
beta, depending on your opinion), the date entered will be visible if
you have your preferences set to show it."
https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050587.html

Searched through preferences a couple times. I'm not seeing it.


I don’t know which OS you’re using but on Linux with the experimental
features compile option I can start gnucash with the --extra option and
can enable this view in the Extensions/Register 2 General Journal

Kind regards

Christian Kluge


___
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] * Unsaved book - Gnucash

[John Ralls]

I sure hope so.

Regards,
John Ralls


> On May 1, 2019, at 8:32 AM, Michael Hendry  wrote:
> 
>> On 1 May 2019, at 16:02, John Ralls  wrote:
>> 
>> 
>> 
>>> On May 1, 2019, at 6:46 AM, Michael Hendry  wrote:
>>> 
>>> I’m using version 3.4 on Mac OS X High Sierra.
>>> 
>>> This comes up briefly in the Gnucash title bar when I’ve finished working 
>>> on one file and File->Open another one, although the file that is being 
>>> closed has definitely been saved already.
>>> 
>>> It doesn’t seem to have any adverse effect (apart from operator anxiety).
>> 
>> Michael,
>> 
>> GnuCash is currently written to always have a book to the point that when 
>> switching from one to another it creates one for the brief interval while 
>> the old one is closed and the new one is loading. That's the indication 
>> you're seeing. 
>> 
>> Regards,
>> John Ralls
>> 
> 
> Thanks, John.
> 
> I had suffered from premature Gnucash shutdown during file saving when I 
> first started using 3.4, so I was alarmed that something similar might be 
> happening.
> 
> IIRC that particular bug is fixed in 3.5.
> 
> Regards,
> 
> Michael Hendry

___
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] Please respond to this request for help!

[John Ralls]

Adrien,

AQBanking *will* drop DTAUS support in Version 6 when that's released. As of 
today it still hasn't been, and the Windows and MacOS bundles still provide 
AQBanking 5.7.8, the latest stable release that still supports DTAUS and 
includes dtaus.xml.

Regards,
John Ralls


> On May 1, 2019, at 11:37 AM, Adrien Monteleone 
>  wrote:
> 
> As noted by Maf., 2.1.16 is ancient. It will not read the 3.x file. (if you 
> got that far) I don’t think 2.1 will even install on Win10. (if you can even 
> find it)
> 
> dtaus.xml has to do with Aqbanking. (allows you to make a transaction in your 
> bank account *from* GnuCash) They dropped DTAUS support in their new version 
> 6 and GnuCash 3.5 is supposed to work with Aqbanking-v6, so not sure why you 
> are getting that error. (the file, I should think, shouldn’t even be part of 
> the package, unless it was retained for backwards compatibility with older 
> systems.)
> 
> First, I’d do a system-wide search for the file and completely trash it. (the 
> file might already be on the system and corrupted, causing a problem)
> 
> Then, download 2.6.21 and try that.
> 
> If that installs and you can successfully open your file, look over your data 
> and make sure there are no problems.
> 
> When you are satisfied everything is okay, download 3.5-1 (an updated Windows 
> installer) and install it.
> 
> Barring that, since you mention you’ve successfully installed 3.5 on a 
> different Win10 machine, maybe a ‘refresh’ of Win10 is in order? (be sure to 
> make a backup of everything first)
> 
> Regards,
> Adrien
> 
> 
> 
>> On May 1, 2019, at 11:32 AM, David Jaggar  wrote:
>> 
>> Hello Sachin,
>> I'm in Britain, so with the time difference, it has meant a delay in
>> following up.
>> Good thinking to install on another computer. I did that on a friend's
>> computer (also Windows 10) and it installed with no problem. However, I
>> downloaded the 3.5 version again, and still have the problem. I also find
>> that I can no longer reinstall my earlier version (2.1.16 ver) because I
>> have the same problem: the dtaus.xml file stops in the installation and
>> task manager indicates that the setup is suspended.
>> 
>> I am completely unfamiliar with Linux.
>> 
>> Thanks for suggestions,
>> David.
>> 
> 
> 
> ___
> 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] Problems with getting European share prices

[John Ralls]

> On May 1, 2019, at 1:34 PM, Eric Coates  wrote:
> 
> Hi
> 
> This is so weird it must be me ??? otherwise pandemonium would have reigned 
> here!
> 
> About two weeks ago I upgraded my system to Ubuntu 18.10 and a few days later 
> to 19.04 (ironically, I was trying to get around some problems) and installed 
> GnuCash from the standard repository; so I am running GnuCash 3.4 with 
> Finance::Quote 1.47 on Ubuntu 19.04.
> 
> As part of my usual work process, on 30^th April I updated my share prices as 
> in the past I was using Alphavantage to get UK share prices and Yahoo-JSON to 
> retrieve European prices. Then, as usual, went to check that everything was 
> OK.
> 
> Although there were no error messages and all the names of my European shares 
> were shown in the Price Database window there were no prices against any of 
> them ??? and I mean NO prices. I know that there were some there at the end 
> of March but everything had gone. Even the little triangular thingies were 
> missing. As there are only half a dozen shares in this group I thought to add 
> the prices ???by hand??? but I couldn???t do it, although I could fill I the 
> fields and clicking Apply gave no messages nothing appeared in the database.
> 
> A further oddity is that in the table of accounts there is a Present value 
> against each of the European shares ??? to get that GnuCash must be picking 
> up some price from somewhere. I???ve done some checking around and I can???t 
> find a reasonable explanation of how the price is determined.
> 
> I take an archive copy of the data file at the end of each month. I have 
> opened several of them (using the standard GnuCash 3.4) and get the same 
> behaviour with each of them.
> 
> As I said, it must be me but - any ideas of what I???m doing wrong.
> 
> Or failing that, would I be able to open the 3.5 data file with GnuCash 
> 2.6.21?
> 
> Eric
> 
> PS: For completeness:
> 
> I had not changed the Symbol for any share since the successful update at the 
> end of March. The Yahoo site shows Deutsche Post as DPW.DE (not the DPW.F I 
> had been using). Changing the symbol to DPW.DE gave no different result 
> (again, not even no error message)


Sounds like https://bugs.gnucash.org/show_bug.cgi?id=797046, fixed in GnuCash 
3.5.

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
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] Unique entry date and transaction date availability?

[John Ralls]

Unfortunately it was part of the Register rewrite called Register2. That had 
some serious stability problems that the contributor wasn't able to resolve so 
it remains hidden away behind the "--extra" command-line flag.

Regards,
John Ralls

> On May 1, 2019, at 2:55 PM, Jeff Albrecht  wrote:
> 
> Doh! Forgot to include platform and version. Windows 10 Version: 3.5 Build 
> ID: 3.5+(2019-03-30)
> 
> Working on it since 2013 and it's still experimental? :-) I'd sure like it to 
> go into the Main branch. I feel it's a very important feature to have 
> although not often used.
> 
> I looked around for a while "windows gnucash startup command line options" I 
> guess there aren't any?
> 
>  - Jeff
> 
> 
> On 5/1/2019 2:12 PM, Christian Kluge wrote:
>> Am 01.05.2019 um 22:55 schrieb Jeff Albrecht:
>> 
>>> Is there a transaction creation date available and if so how may I
>>> display it.
>>> 
>>> I did find an email thread from September 2013...
>>> 
>>> "Starting with releases in the 2.5 series (which is still in alpha or
>>> beta, depending on your opinion), the date entered will be visible if
>>> you have your preferences set to show it."
>>> https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050587.html
>>> 
>>> Searched through preferences a couple times. I'm not seeing it.
>>> 
>> I don’t know which OS you’re using but on Linux with the experimental
>> features compile option I can start gnucash with the --extra option and
>> can enable this view in the Extensions/Register 2 General Journal
>> 
>> Kind regards
>> 
>> Christian Kluge
>> 
>> 
>> ___
>> 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.

___
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] Account remains red after void that would put it in black

[D via gnucash-user]

Jeff,

Assuming that you're referring to the figures in the reconciliation window, I 
have noticed that issue as well. It seems that once they are displayed as red, 
the color setting is never revisited. 


I just ignored it, knowing that the color was wrong; since a red zero (I never 
knew that zero was negative number!) doesn't prevent me from clicking that all 
important Finish button, I just let it go.

David

On May 2, 2019, at 12:40 AM, Jeff Albrecht  wrote:

Is this a know bug? and/or could someone forward it to gnucash-devel if 
appropriate?

Windows 10 GNUCash version Version: 3.5 Build ID: 3.5+(2019-03-30)

I'm balancing a checking account. It has a positive amount for Present 
and Future in black. I don't specifically remember the Balance column.
I enter an adjusting entry that puts the account in negative and the 
Present and Future change to reflect that and change to parenthesis and red.
Doh! I entered that wrong so I void the transaction. (IMHO deleting a 
transaction should never be allowed. It voids the audit trail.)
After voiding the transaction the account is now positive however the 
color is still red.
I close and reopen the account, the Present and Future are now black as 
I would expect. It was a real head scratcher for a while as I just saw 
red (PUN intended) before realizing that the amount was displayed wrong, 
red instead of black.

FWIW I've had this happen several times in the last couple days of 
marathon balancing after Quicken Conversion last year. I couldn't put a 
finger on when it happens but It just occurred again so I wrote down the 
steps that I just completed. This behavior _may_ appear any time an 
account goes from red negative to black positive.


  - Jeff


___
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] Please respond to this request for help!

[Adrien Monteleone]

Thanks for the clarification John, I was piecing things together based on 
release notes and some searches.

Definitive answers from you and other developers are always, of course, the 
most helpful.

Any idea why the OP’s installation is hanging on that file? Possible solutions 
other than my guess of just trying again? I’ve seen weird things, but hanging 
on simply copying a single file hasn’t been one of them. (personally, yet)

Regards,
Adrien

> On May 1, 2019, at 6:56 PM, John Ralls  wrote:
> 
> Adrien,
> 
> AQBanking *will* drop DTAUS support in Version 6 when that's released. As of 
> today it still hasn't been, and the Windows and MacOS bundles still provide 
> AQBanking 5.7.8, the latest stable release that still supports DTAUS and 
> includes dtaus.xml.
> 
> 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
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] De-Reconciliation Settings

[D via gnucash-user]

On May 1, 2019, at 11:55 PM, Adrien Monteleone  
wrote:

>Justin,
>> On May 1, 2019, at 11:46 AM, Justin Vallon  wrote:
>> 



>It is trivial to re-reconcile a period if the edit was minor and you do this 
>quickly after the edit. (which is why the warning is there, and probably 
>should not be turned off, so there is no ‘hidden’ clearing of flags)

Adrien, re-reconciling a simple transaction may be trivial (and it may 
not)--but it becomes deeply challenging if you change the description on a 
complex transaction that has 7 or 8 reconciled splits in different accounts. 
Pay check transactions for me are like this. If, by chance, you are changing 
how you recorded these regular transactions, you will quick have hundreds of 
splits across the chart of accounts to rework. That has happened to me, and 
it's no fun tracking it all down.


David

>If *you* know the change was immaterial, simply click the Reconcile button in 
>the toolbar while *still* viewing the account, change the date to the end of 
>the affected period, check off the one transaction and click the button to 
>complete the reconciliation.
>We had a thread a few months back about what really needs to trigger the 
>clearing of the flag. I’m of the opinion that only date and amount matter, I 
>can see that perhaps NUM *might* be wise to keep, but personally don’t use it 
>as a transaction number often. Certainly, correcting a typo in Description, 
>notes, memo splits, or any splits that don’t affect the current register, 
>should not clear the flag.
>> 
>> It would seem the opinion here is whether "transaction description" (and
>> the others) is a material change.  It seems like that would be a good
>> choice for an option, maybe per-attribute (tran date, tran num, tran
>> desc, split num, split desc).
>File an RFE on Bugzilla and/or contribute code to make it happen...
>> 
>> -Justin
>> 
>___
>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] Account remains red after void that would put it in black

[Adrien Monteleone]

I’ve seen zero as a negative (or red) number before with other applications. 
(notably, OOo/LO Calc)

It usually results from a rounding situation where the color is set before the 
rounding down to zero. So the real amount was a negative closer to zero than 
`-1`.

It is fixable, but would require either a second test to recolor the zero, or 
test for color only after rounding.

Regards,
Adrien

> On May 1, 2019, at 8:34 PM, D via gnucash-user  
> wrote:
> 
> Jeff,
> 
> Assuming that you're referring to the figures in the reconciliation window, I 
> have noticed that issue as well. It seems that once they are displayed as 
> red, the color setting is never revisited. 
> 
> 
> I just ignored it, knowing that the color was wrong; since a red zero (I 
> never knew that zero was negative number!) doesn't prevent me from clicking 
> that all important Finish button, I just let it go.
> 
> David
> 


___
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] Account remains red after void that would put it in black

[Adrien Monteleone]

Have you tested the following:

Delete the transaction instead of using the `Void Transaction` function?

Add a reversing transaction either manually?

or using the `Add Reversing Transaction` function?

Curious to see if this discrepancy holds against all workflows.

Regards,
Adrien



> On May 1, 2019, at 2:08 PM, Jeff Albrecht  wrote:
> 
> Is this a know bug? and/or could someone forward it to gnucash-devel if 
> appropriate?
> 
> Windows 10 GNUCash version Version: 3.5 Build ID: 3.5+(2019-03-30)
> 
> I'm balancing a checking account. It has a positive amount for Present and 
> Future in black. I don't specifically remember the Balance column.
> I enter an adjusting entry that puts the account in negative and the Present 
> and Future change to reflect that and change to parenthesis and red.
> Doh! I entered that wrong so I void the transaction. (IMHO deleting a 
> transaction should never be allowed. It voids the audit trail.)
> After voiding the transaction the account is now positive however the color 
> is still red.
> I close and reopen the account, the Present and Future are now black as I 
> would expect. It was a real head scratcher for a while as I just saw red (PUN 
> intended) before realizing that the amount was displayed wrong, red instead 
> of black.
> 
> FWIW I've had this happen several times in the last couple days of marathon 
> balancing after Quicken Conversion last year. I couldn't put a finger on when 
> it happens but It just occurred again so I wrote down the steps that I just 
> completed. This behavior _may_ appear any time an account goes from red 
> negative to black positive.
> 
> 
>  - Jeff

___
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] De-Reconciliation Settings

[Adrien Monteleone]

David,

At first, I was going to suggest always editing a reconciled transaction from 
the account you do the reconciliation on.

Of course, that isn’t always part of the workflow, and isn’t always optimal.

And then, based on what it appear you are describing though in a different 
case, I considered what I hadn’t thought of before — refactoring a 
non-reconciled expense/liability/income/equity account that is a split of 
hundreds of reconciled transactions.

The fundamentals of the reconciliation aren’t changing. (date/amount, even 
description) But the current behavior is clearing the flag on all of those 
transactions.

Certainly, that is not ’trivial’.

Point taken.

And another case for narrowing the criteria for clearing the flag, or making it 
a user preference.

Regards,
Adrien

> On May 1, 2019, at 8:53 PM, D  wrote:
> 
> 
> On May 1, 2019, at 11:55 PM, Adrien Monteleone 
>  wrote:
> 
> >Justin,
> >> On May 1, 2019, at 11:46 AM, Justin Vallon  wrote:
> >> 
> 
> 
> 
> >It is trivial to re-reconcile a period if the edit was minor and you do this 
> >quickly after the edit. (which is why the warning is there, and probably 
> >should not be turned off, so there is no ‘hidden’ clearing of flags)
> 
> Adrien, re-reconciling a simple transaction may be trivial (and it may 
> not)--but it becomes deeply challenging if you change the description on a 
> complex transaction that has 7 or 8 reconciled splits in different accounts. 
> Pay check transactions for me are like this. If, by chance, you are changing 
> how you recorded these regular transactions, you will quick have hundreds of 
> splits across the chart of accounts to rework. That has happened to me, and 
> it's no fun tracking it all down.
> 
> David
> 


___
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] Please respond to this request for help!

[John Ralls]

Adrien,

No, but one can always use Windows Settings to remove the old installation and 
then run Windows Exploder as Admin and delete c:\Program Files (x86)\gnucash. 

Regards,
John Ralls

> On May 1, 2019, at 6:57 PM, Adrien Monteleone 
>  wrote:
> 
> Thanks for the clarification John, I was piecing things together based on 
> release notes and some searches.
> 
> Definitive answers from you and other developers are always, of course, the 
> most helpful.
> 
> Any idea why the OP’s installation is hanging on that file? Possible 
> solutions other than my guess of just trying again? I’ve seen weird things, 
> but hanging on simply copying a single file hasn’t been one of them. 
> (personally, yet)
> 
> Regards,
> Adrien
> 
>> On May 1, 2019, at 6:56 PM, John Ralls  wrote:
>> 
>> Adrien,
>> 
>> AQBanking *will* drop DTAUS support in Version 6 when that's released. As of 
>> today it still hasn't been, and the Windows and MacOS bundles still provide 
>> AQBanking 5.7.8, the latest stable release that still supports DTAUS and 
>> includes dtaus.xml.
>> 
>> 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
> 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] Account remains red after void that would put it in black

[Jean-David Beyer via gnucash-user]

On 5/1/19 9:34 PM, D via gnucash-user wrote:
> I never knew that zero was negative number!

In IBM computers of the 704, 709, 7090, 7094 line, the numbers were in
sign-magnitude form, different from the two's complement form in common
use today. So there were both Positive zero ane Negative zero on the
machine, and there were different test instructions depending on what
you wanted to do

TZE Transfer (jump, branch) on zero
TNZ Transfer on no zero
TPL Transfer on plus
TMI Transfer on minus
CAS compares two numbers and takes the next instruction if smaller, the
instruction after that if equal, and the one after that if larger.
Positive zero was considered greater than negative zero for this
instruction.

-- 
  .~.  Jean-David Beyer
  /V\  PGP-Key:166D840A 0C610C8B
 /( )\ Shrewsbury, New Jersey
 ^^-^^ 22:25:01 up 9 days, 12:26, 2 users, load average: 4.39, 4.46, 4.49
___
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.