Re: [GNC] business Accounts Payable questions

[Adrien Monteleone]

> On Jan 9, 2019, at 3:44 PM, Tim Kallmer  wrote:
> 
> i'm new to using GC for business.
> 
> i don't understand the format and behavior Accounts Payable account. can
> you explain the 'Ty' column that starts with '?', then toggles between 'I'
> and 'P'? are these 'type', 'invoiced', and 'paid'? can you explain why the
> due date cell cannot be edited in 'I' mode?

Yes, the column is ’Type’, if you expand the width you’ll see the full label. 
Yes, P & I are for ‘Payment’ and ‘Invoice’. (‘Bills’ are also listed as 
‘Invoices’ but in the A/R account) The ? is only on empty transactions. (which 
you should not be creating manually)

You can edit the due date cell, but not directly. You have to edit the bill or 
invoice, which will require unposting and reposting to change the date.

> 
> my small business doesn't have goods and vendor bills, or employees and
> expense vouchers. is Accounts Payable able to have transactions entered
> manually rather through bills or vouchers?

Then you probably don’t need to use the business features.

You can create a generic liability account and call it “Accounts Payable” and a 
generic asset account and call it “Accounts Receivable” if you like. *Those* 
generic accounts, you can manually edit, just don’t edit the default A/R and 
A/P accounts that were created when you turned on the business features.

You can’t (or shouldn’t) manually edit entries made in A/R or A/P using the 
business features of Bills, Invoices & Vouchers. You can edit payments on 
those, but still not wise. Better to use the payment feature to change the 
payment amount or what it applies to.

If you need or want to use the business features, but otherwise also want to 
track some payables (or receivables) manually, then create additional generic 
accounts and call them “Other Payables/Receivables” or whatever your CPA deems 
appropriate and use them for the manual transactions. Note, they can be 
children of the default A/R and A/P accounts if you like which will roll up 
their totals into the parent(s) in the Accounts tab, and on reports if you’ve 
chosen that option.

> 
> lastly, in trying to fiddle with A/P, i entered some temporary vendors,
> employees, and bills. is it true these cannot be deleted without somehow
> editing the XML? how would i go about deleting them?

Vendors, Customers and Employees can be edited at will. But you can’t delete 
them. (you can edit them to fill them with ‘dummy’ info and reuse them later)

The same goes for bills and invoices, but you can’t edit them in a posted 
state. You have to unpost them first.

If I errantly enter a bill or invoice, I’ll edit it to say ‘use next’ as the 
document number so I can find it and change the info for reuse next time I need 
one.

You should, dare I say, never, need to edit the XML directly. (unless you’ve 
been bitten by some sort of bug and that is the only sane route to recovery)

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.

Re: [GNC] Investment Accounts not Displaying Decimals

[Les]

No problem.  I solved this issue.  What I didn't realize was the dollar 
field was now expanded, so only a partial view of the price was being 
displayed.  Once I expanded the field. everything displays properly.  My 
bad :-(


On 1/9/19 6:54 PM, Adrien Monteleone wrote:

Yes, sorry, that preference was added later. I didn’t read well enough of your 
post to notice you were in the 2.6 series.

Regards,
Adrien


On Jan 9, 2019, at 10:09 AM, Les  wrote:

Thanks David.

I think you are right.

Les

On 1/9/19 10:07 AM, David Carlson wrote:

I believe you just have to live with it in release 2.6.21 or several other 
releases below 3.3.  You should be able to manually re save any particular 
entry in decimal form if it is really bothering you, but why bother if it does 
not appear that way in reports?

David C

On Wed, Jan 9, 2019 at 9:52 AM Tom Teixeira mailto:tjteixe...@earthlink.net>> wrote:

Maybe try Tools>Security Editor. Check the "Fraction Traded" field for
those securities which only show whole numbers. The other place to
look
is "Smallest Fraction" field for the account itself, though as I
recall,
the default is "Use Commodity Value" which is set by the Security
Editor.

On 1/9/19 10:06 AM, Les wrote:
> As far as I can determine, there is nothing in preferences that
> addresses this issue.  Also, there are only 2 maybe 20 investment
> accounts with this issue.
>
> Les
>
>
> On 1/9/19 8:14 AM, Geert Janssens wrote:
>> Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
>>> Check preferences. There is an option for this.
>>>
>>> Regards,
>>> Adrien
>> While I may be wrong I thought this was only introduced in the 3.x
>> series ?
>>
>> 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.
> ___
> 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.


___
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] GnuCash won't open

[Adrien Monteleone]

Ruth,

Privacy settings of your browser should have no effect on the download or the 
file opening, but occasionally downloads don’t complete properly and can get 
corrupted. The solution is to simply re-download.


Follow these steps *carefully*:

1. Download GnuCash 3.4, using either Safari or Firefox, but **DO NOT** choose 
to “open” the file when the save dialog comes up. Choose to SAVE it to your 
Downloads folder.

2. Once the download is complete, open Finder and navigate to Downloads.

3. In it you will find the GnuCash download file that ends in .dmg, 
double-click that file. It will open a new window with several icons. One of 
these will be GnuCash.app.

4. Now, in the Finder window that is viewing your Downloads folder, navigate to 
Applications. If you don’t have a shortcut to it already in the sidebar on the 
left, open your Macintosh HD (or whatever your hard drive is named) from that 
sidebar, and then open the Applications folder. (you may also have an icon for 
your hard drive on your desktop - they open the same folder, where you’ll see 
an ‘Applications’ folder)

5. Now, left-click and drag the GnuCash.app icon from the other window to the 
Applications folder, this will ‘install’ GnuCash to your Mac.

6. Close the Gnucash.dmg window.

7. In the Applications folder, right-click on GnuCash.app and choose “open”.

8. You will be asked if you are sure you want to open this file that was 
downloaded from the internet. Click the “open” button.

GnuCash should start, and appear in your Dock, where you can lock it there. If 
it begins to start, then fails, left double-click it again and it should open 
successfully that time and from there on out.

Hope that helps. If not, report back how far you got on this list and what 
happened and myself or someone else will try help you sort it out.

Regards,
Adrien

> On Jan 9, 2019, at 3:49 PM, Colin Law  wrote:
> 
> Ruth, you sent this to me personally rather than to the group, so I am
> forwarding it to the group.
> You should not give up, there will be those on the list who know how to
> help.
> 
> Colin
> 
> On Wed, 9 Jan 2019 at 21:31, Ruth L. Mazur  wrote:
> 
>> I have spent too much time trying to get this app, so I give up.  On
>> Safari it asks since it’s not an Apple product and I say, OPEN. In
>> preferences I select download from anywhere.  It verifies, shows in my Dock
>> and then disappears.
>> 
>> So I tried Firefox.  It wanted to download 2.6.21 but told me it was
>> “damaged” and I should eject it.
>> 
>> Sorry this just won’t work for me.
>> 
>> Ruth Mazur
>> 
>> 
>> 
>> 
>>> On Jan 3, 2019, at 1:16 AM, Colin Law  wrote:
>>> 
>>> On Thu, 3 Jan 2019 at 07:10, Ruth L. Mazur 
>> wrote:
 
 I have downloaded GnuCash 3.4-Intel to my Mac OS10.11.6  a dozen times
>> but I can not get it to open. For Privacy I’m set to sites that I visit.
>> Once I set it to Anyone and that didn’t work either.
>>> 
>>> Did you carefully follow the installation instructions for Mac?
>>> https://wiki.gnucash.org/wiki/Installation
>>> 
>>> Colin
>>> 
 
 This has been very frustrating.  I’m disillusioned with Quicken and
>> want something else, and free is good! What do I need to know to get this
>> app?
 
 Thanks for any help,
 
 Ruth Mazur
 Grass Valley, CA
 
 
 
 ___
 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] Present Reconcile Is Showing Previous Reconciled Items UnReconciled

[David Cousens]

Normally the only way a reconciled transaction becomes unreconciled is if the
split to the account which has been reconciled is editied, either in the
register for the reconciled account or in another register conatining the
split from the reconciled account to that registers. The splits of a
transaction can be edited from any register for any account which contains
splits to it from the transaction. In V3.4 editing details (description,
memo) other than the amount, date and account does not affect the
reconciliation flag status.  You will normally get a dialogue indicating
that you are editing a reconciled split. 

 I think earlier versions of GnuCash may have also changed the status when
other splits and any information in a reconciled transaction were edited
were edited but I am unsure of this and when only editing specific fields in
the reconciled split triggered changing of the status was introduced. 

The easiest way to fix this is to rerun the reconciliation process for
periods covering the earliest unreconciled transaction forward, checking
that opening balances, closing balances and transaction amounts agree with
the statements. GnuCash will often start the reconciliation window with some
transactions marked even if that period has not been previously reconciled
as it attempts to identify transactions which lead to a reconciliation. I
have been caught believing this in the past and I now clear (uncheck) all
transactions in the reconciliation window and match them individually by
hand. Tedious but it can pick up 2 errors cancelling each other out so that
the opening and closing balances are OK but the transactions are incorrect.

Any unreconciled transaction should show up in the reconciliation procedure
window as unchecked with any already reconciled splits being initially
checked which can help identify the unreconciled transactions

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] Does CSV importer work with foreign currencies?

[David Cousens]

A major problem with the CSV importer at present is fairly sparse
documentation on the options and what their effect is. After making some
changes in the import matcher towards the end of last year I started to
update the documentation in that area but rapidly got out of my depth with
understanding how to use thevarious optional features. At the same time
david T was starting a reorganization of the concepts and tutorial guide. 

I am hoping to learn enough by going through a systematic exploration
initally of the multiline importation of GnuCash's own exported data to
identify any problems and bugs and update the documentation. This may not
make it into the docs until a later version but I will also reflect it here
an/or create a wiki page when I get the information together.

David



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

[GNC] Copy a month's budget

[Patrick]

Hello,

I recently started using GnuCash. Is there a way to copy one month's budget
to the next month? I have a budget with a large number of entries, and
copying each entry individually is somewhat cumbersome.

Any help is appeciated.

Regards,
Patrick
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] business Accounts Payable questions

[David Cousens]

Tim,

The Accounts Payable account Type is explicitly tied into the Invoice Bills
payments and Credit Notes etc of the business features. The I appears
against transaction records in the register to indicate that these are
generated by an Invoice and the P indicates a payment which can be linked to
a specific invoice. Some fields in the transactionscan only be edited from
the 
Business-> Find Invoice which brings up an editor when the Invoice is opened
as this would affect the integrity of the business features.

If you don't want to use the Business Features, you can just setup an Asset
account of Type Asset rather than of Type Accounts Payable in the New
Account Dialog and still give it the name Accounts Payable and just manually
add the requisite transactions for the events you wish to record. None of
the Business reports for Bills and Invoices will work with this.

I don't know of any way to edit/delete customers/vendors other than editing
the XML .gnucash file. First you need to ensure it is in
uncompressed format. Edit->Preferences->General tab and look for the Files
section on that tab and unselect the Compress Files check box and then save
the file.

Open the file with a text editor. The records for the Customer and Vendor
look like


  6960dc95031246b1ac97ef94008f9d72
  Alpha
  01
  
Tom Tom
16 Nowhere Pde
  
  
TomTom
15 Anywhere St
Nowhere
  
  USEGLOBAL
  1
  0/1
  0/1
  
CURRENCY
AUD
  
  0


with GncVendor for vendor records. Delete everything between the opening
 and closing  tags and
similarly for the vendor records. It may pay to remove any Invoices/Bills
etc you have created first as they may be more difficult to find after the
customer and vendor records are deleted. the search is for a Regex
expression so searching for "." will find all customers and all vendors or
Invoices or Bills.

GnucCash can have more than one instance running (at least on Linux not sure
about Windows/Mac) so if I am exploring new features I create a test file
named as such rather than test out stuff on my actual accounting records.

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] Does CSV importer work with foreign currencies?

[D via gnucash-user]

David,

On January 10, 2019, at 4:01 AM, David Cousens  wrote:




>At the same time
>david T was starting a reorganization of the concepts and tutorial guide. 

For the record, I am in favor of moving substantive content from Help to the 
Guide, which is what I think you're referring to here. I made an attempt to do 
this last year, but that set of changes has gotten stalled in the Git process. 
Having done the editing, I await some resolution to that issue before 
proceeding on any other changes to the documentation. I am, unfortunately, not 
one of those people who can keep multiple balls in the air; it's one thing set 
a time. So, it sits.

I have additionally been on a long process of reorganizing the Guide in a more 
logical way, which has been ongoing for quite some time. That is a different 
set of issues.

David T.

>
>David
>-
>David Cousens

___
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] Investment Accounts not Displaying Decimals

[Adrien Monteleone]

Yes, sorry, that preference was added later. I didn’t read well enough of your 
post to notice you were in the 2.6 series.

Regards,
Adrien

> On Jan 9, 2019, at 10:09 AM, Les  wrote:
> 
> Thanks David.
> 
> I think you are right.
> 
> Les
> 
> On 1/9/19 10:07 AM, David Carlson wrote:
>> I believe you just have to live with it in release 2.6.21 or several other 
>> releases below 3.3.  You should be able to manually re save any particular 
>> entry in decimal form if it is really bothering you, but why bother if it 
>> does not appear that way in reports?
>> 
>> David C
>> 
>> On Wed, Jan 9, 2019 at 9:52 AM Tom Teixeira > > wrote:
>> 
>>Maybe try Tools>Security Editor. Check the "Fraction Traded" field for
>>those securities which only show whole numbers. The other place to
>>look
>>is "Smallest Fraction" field for the account itself, though as I
>>recall,
>>the default is "Use Commodity Value" which is set by the Security
>>Editor.
>> 
>>On 1/9/19 10:06 AM, Les wrote:
>>> As far as I can determine, there is nothing in preferences that
>>> addresses this issue.  Also, there are only 2 maybe 20 investment
>>> accounts with this issue.
>>>
>>> Les
>>>
>>>
>>> On 1/9/19 8:14 AM, Geert Janssens wrote:
>>>> Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
>>>>> Check preferences. There is an option for this.
>>>>>
>>>>> Regards,
>>>>> Adrien
>>>> While I may be wrong I thought this was only introduced in the 3.x
>>>> series ?
>>>>
>>>> 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.
>>> ___
>>> 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.


___
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] Currencies not being converted

[John Ralls]

Please remember to copy the list on all replies.

If “Get Quote” returns an error it means that either you don’t have online 
quote retrieval setup or that there’s a problem with it. Please study 
https://www.gnucash.org/docs/v3/C/gnucash-guide/currency_howto1.html 
 for your 
options in getting current exchange rates.

Regards,
John Ralls

> On Jan 9, 2019, at 7:41 AM, Tom Delarge  wrote:
> 
> I did that and it worked, thank you very much. 
> 
> But...the prices that GNUcash gives don't reflect the real price that I see 
> on google.
> 
> On the chart of accounts screen in GC I have it show me New Taiwan Dollars 
> (for many accounts are in that currency) and have a columb showing me the USD 
> balance. But it is using a very incorrect conversion rate and I'm not sure 
> why it won't update. I hit "get quote" and it just tells me there is an 
> error. 
> 
> Is there no way way I can keep my accounting data and have the program itself 
> properly update the prices? 
> 
> On Thu, Jan 3, 2019 at 10:29 AM John Ralls  > wrote:
> 
> 
> > On Jan 2, 2019, at 9:43 AM, salmichaels  > > wrote:
> > 
> > I have just returned from overseas with laptop and now gnucash does not
> > convert currencies. I have some accounts in a foreign currency, others in
> > USD. In making reports or having a Total (USD) column, GC doesn't convert
> > the accts in foreign currency to USD, but just lists the amounts as if they
> > are US dollars. If I change the report currency to the foreign currency, it
> > handles it fine; it converts the USD accounts to the foreign currency, no
> > issues. 
> > 
> > The program is set to default to local (US) currency, and was even when I
> > was overseas as far as I know. Now it is also set to local US. My local
> > settings on my computer are also set for the US. So yeah, I cannot for the
> > life of me figure this out. 
> > 
> > thanks in advance! 
> 
> Check the price database for both USD->??? and ???->USD and make sure that 
> the most recent price is correct in both directions.
> 
> 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.

[GNC] Present Reconcile Is Showing Previous Reconciled Items UnReconciled

[ringmaster]

Hello,

Over the past few months, GnuCash has been showing past items that were once
reconciled as reconciled transactions. What once closed with a correct
beginning amount is now showing a number of the previous months items now
unreconciled. I have no idea what to do or what might be happening. 

This is causing me some struggles in trying to determine how to handle these
transactions that once was reconciled. I have been using the software
religiously for my personal account since 6/2014 and recently with my
business the last couple years. The personal account is the one having
problems with the business account acting fine. Any assistance or questions
would be appreciated as I do not want to move away from this software.

Thanks! M



--
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] Present Reconcile Is Showing Previous Reconciled Items UnReconciled

[D via gnucash-user]

David's points here are all well-considered. See notes inline.

On January 10, 2019, at 9:42 AM, David Cousens  wrote:

>Normally the only way a reconciled transaction becomes unreconciled is if the
>split to the account which has been reconciled is editied, either in the
>register for the reconciled account or in another register conatining the
>split from the reconciled account to that registers. The splits of a
>transaction can be edited from any register for any account which contains
>splits to it from the transaction. In V3.4 editing details (description,
>memo) other than the amount, date and account does not affect the
>reconciliation flag status.  You will normally get a dialogue indicating
>that you are editing a reconciled split. 
>I think earlier versions of GnuCash may have also changed the status when
>other splits and any information in a reconciled transaction were edited
>were edited but I am unsure of this and when only editing specific fields in
>the reconciled split triggered changing of the status was introduced. 
>The easiest way to fix this is to rerun the reconciliation process for
>periods covering the earliest unreconciled transaction forward, checking
>that opening balances, closing balances and transaction amounts agree with

I disagree here. I think the easiest first method is to enter the *last* 
statement balance (ignoring the opening balance altogether), and see whether 
checking those earlier entries results in a zero balance. I often find that it 
does. 

I only go to more specificity if this one doesn't work.

>the statements. GnuCash will often start the reconciliation window with some
>transactions marked even if that period has not been previously reconciled
>as it attempts to identify transactions which lead to a reconciliation. I

For the record, Gnucash pre-checks only those transactions that have a 
reconcile status of "c," which usually occurs with imported transactions. Users 
can also set this status in the register themselves.

>have been caught believing this in the past and I now clear (uncheck) all
>transactions in the reconciliation window and match them individually by
>hand. Tedious but it can pick up 2 errors cancelling each other out so that
>the opening and closing balances are OK but the transactions are incorrect.
>Any unreconciled transaction should show up in the reconciliation procedure
>window as unchecked with any already reconciled splits being initially

Again, transactions with a status "c" will be checked; reconciled items by 
definition will be excluded from the window (except insofar as they contribute 
to the opening balance figure).

OP might check to see whether he accidentally re-entered transactions that have 
already been entered and reconciled, as might happen, for example when 
importing transactions from a second account (say a credit card) whose 
transaction details don't fully match the existing entry.

The OP could supply further details (OS, Gnucash version, specific 
circumstances of his problem) to get better answers. Until then, we are 
speculating on a host of possibilities.

David T.


>checked which can help identify the unreconciled transactions
>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.
___
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] Loan Mortgage repayment assistant problem

[Michael or Penny Novack]

On 1/8/2019 11:50 PM, John Ralls wrote:

The answer is probably in app-utils/calculation. All of that was probably 
written before Guile grew a rational number class and I think that GncNumerics 
get converted to doubles before being passed to the interest functions. That 
would pretty much guarantee rounding issues.

Regards,
John Ralls

 I will repeat, this sort of "rounding error" is not a bug.

If two persons set out to perform a calculation which can be done by a 
number of methods with rounding involved at numerous places and no 
agreement as to either the method to be used or the precision maintained 
at each step THERE IS NO REASONABLE EXPECTATION THAT THEIR ANSWERS WILL 
MATCH EXACTLY.


Treated as a "bug", it might* be possible to change the code so as to 
match the answers of a particular lending institution, but then could be 
wrong for another lending institution that used different methods or 
rounding than the first.


Michael D Novack<< who in my working days often had to compute the 
"fuzz" for comparisons >>


* Might, because you have no reason to suppose that a lending 
institution necessarily used the same methods/rounding for car loans as 
for house mortgages.

___
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] Loan Mortgage repayment assistant problem

[John Ralls]

> On Jan 9, 2019, at 6:26 AM, Michael or Penny Novack 
>  wrote:
> 
> On 1/8/2019 11:50 PM, John Ralls wrote:
>> The answer is probably in app-utils/calculation. All of that was probably 
>> written before Guile grew a rational number class and I think that 
>> GncNumerics get converted to doubles before being passed to the interest 
>> functions. That would pretty much guarantee rounding issues.
>> 
>> Regards,
>> John Ralls
> I will repeat, this sort of "rounding error" is not a bug.
> 
> If two persons set out to perform a calculation which can be done by a number 
> of methods with rounding involved at numerous places and no agreement as to 
> either the method to be used or the precision maintained at each step THERE 
> IS NO REASONABLE EXPECTATION THAT THEIR ANSWERS WILL MATCH EXACTLY.
> 
> Treated as a "bug", it might* be possible to change the code so as to match 
> the answers of a particular lending institution, but then could be wrong for 
> another lending institution that used different methods or rounding than the 
> first.
> 
> Michael D Novack<< who in my working days often had to compute the "fuzz" 
> for comparisons >>
> 
> * Might, because you have no reason to suppose that a lending institution 
> necessarily used the same methods/rounding for car loans as for house 
> mortgages.

Which is why GnuCash mostly uses rational numbers and no rounding for internal 
calculations. Using binary floating-point in financial software is a bug on its 
own, so that “mostly” is a bug. It needs to be “only”.

This isn’t about matching the results with someone else’s computer, this is 
about internal consistency in GnuCash.

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] Investment Accounts not Displaying Decimals

[Les]

As far as I can determine, there is nothing in preferences that 
addresses this issue.  Also, there are only 2 maybe 20 investment 
accounts with this issue.


Les


On 1/9/19 8:14 AM, Geert Janssens wrote:

Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:

Check preferences. There is an option for this.

Regards,
Adrien

While I may be wrong I thought this was only introduced in the 3.x series ?

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.

___
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] Investment Accounts not Displaying Decimals

[John Ralls]

> On Jan 9, 2019, at 6:14 AM, Geert Janssens  wrote:
> 
> Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
>> Check preferences. There is an option for this.
>> 
>> Regards,
>> Adrien
> 
> While I may be wrong I thought this was only introduced in the 3.x series ?

3.3 and later.

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] Investment Accounts not Displaying Decimals

[Geert Janssens]

Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
> Check preferences. There is an option for this.
> 
> Regards,
> Adrien

While I may be wrong I thought this was only introduced in the 3.x series ?

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] Deb 3.4.0.1 not working for me in ubuntu 18.04

[Geert Janssens]

Op dinsdag 8 januari 2019 22:11:29 CET schreef Colin Law:
> On Tue, 8 Jan 2019 at 17:52, Stephen M. Butler  wrote:
> > I am trying to get a better deb via Launchpad were we can put up a ppa
> > for folks to point to.  Probably name it "gnucash-daily", although I
> > don't see it changing daily but as commits are made to the maint branch.
> 
> From my personal point of view the most useful ppa would be one that has
> the latest released version rather than a daily or similar version.
> 
> > However, I am having problems with one of the tools (pbuilder-dest) and
> > have a query out in the Ubuntu Forums for input.  Nothing back when I
> > checked a minute ago.  I suspect I'm going to have to read the code
> > (shell script) for pbuild-dest and the debootstrap script it invokes
> > (also shell script).  The later complains that gpgv can't be found --
> > but I can invoke it just fine.  I am comfortable in ksh and hope that
> > transfers well to bsh.
> > 
> > Wish I had better news and was making progress to get something really
> > useful.  My research indicates the check-install is not up to the task
> > of dealing with multiple O/S version.

Indeed. Last time I checked (which is 10+ years ago already) checkinstall 
didn't do dependency tracking. What it does is recording everything that gets 
installed by 'make install' and wrapping that in a .deb package (or .rpm 
package for that matter).

As far as I understand it's not really meant to prepare packages for 
distribution, but to make your package manager aware that you have installed 
something you built from scratch. The advantages are
1. your package manager is made aware of  what got installed and hence can 
properly manage file conflicts on later system updates.
2. your package manager can be used to remove the package cleanly if you no 
longer need it.

Packaging for distribution is more complicated than that. Such a package needs 
dependency information to help the package manager install the proper 
dependencies.

The best way to get there is indeed starting from the package sources of a 
working package. I'm used to the rpm world in which a source package 
essentially consists of a package spec file, a source tarball and optionally a 
number of patch files. The spec file contains all the details, including 
dependencies (with minimum versions), how to build from source and how to 
install. These source packages can be "installed" into a development 
environment and then adjusted before composing a final rpm file. A long time 
ago I have created my own rpms that way:
In the installed source package I replaced the source tarball with a more 
recent one and then tweaked the spec file as required. This I could then be 
compiled into a final rpm ready for distribution.

I assume something similar can be done with .deb package. No doubt they also 
have some source format you can download somewhere, update and the recompose 
into a proper .deb file. Dmitri's work is probably a good starting point. To 
make it more universally installable (as opposed to only for a specific ubuntu 
release) you'd need to find a way to adjust the dependencies to declare 
minimum versions rather than exact versions (like for libboost >= 1.54 instead 
of libboost = 1.65). Rpm allows this and I expect the deb format to allow this 
as well in some form or another. GnuCash' minimal dependencies are nicely 
recorded by David Cousens in our wiki:
https://wiki.gnucash.org/wiki/Dependencies
So that can also be useful for you.

Good luck!

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] Investment Accounts not Displaying Decimals

[Adrien Monteleone]

Check preferences. There is an option for this.

Regards,
Adrien

> On Jan 9, 2019, at 5:45 AM, Les  wrote:
> 
> I have two investment accounts that are not displaying decimals, but 
> fractions.  All other investment accounts are displaying decimals (except 
> foreign accounts).  How to fix this please?  This occurred after upgrading 
> Linux Mint from 18.2 to 19.1 and GC from 2.6.17 to 2.6.21.
> 
> Thanks,
> 
> Les
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Investment Accounts not Displaying Decimals

[Les]

I have two investment accounts that are not displaying decimals, but 
fractions.  All other investment accounts are displaying decimals 
(except foreign accounts).  How to fix this please?  This occurred after 
upgrading Linux Mint from 18.2 to 19.1 and GC from 2.6.17 to 2.6.21.


Thanks,

Les


___
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] Loan Mortgage repayment assistant problem

[David Carlson]

With those numbers payment number 2 has an error.

David C

On Wed, Jan 9, 2019 at 2:23 AM David Carlson 
wrote:

> I am working on a test scenario.The interest formula is ipmt( 0.03500 /
> 12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers
> and the 71st payment contains the error.  I am using these numbers because
> they are exactly the same as the numbers that have already generated an
> error.
> i started the test loan in Jan 2000 with the first repayment in February
> and I am creating one month at a time in case that makes a difference.  If
> the test can repeat it I will submit the bug report.
>
> David C
>
> On Tue, Jan 8, 2019 at 10:52 PM John Ralls  wrote:
>
>> The answer is probably in app-utils/calculation. All of that was probably
>> written before Guile grew a rational number class and I think that
>> GncNumerics get converted to doubles before being passed to the interest
>> functions. That would pretty much guarantee rounding issues.
>>
>> Regards,
>> John Ralls
>>
>> > On Jan 8, 2019, at 5:46 PM, Christopher Lam 
>> wrote:
>> >
>> > Well the SCM has numerous references to "round" and "rounding errors"
>> so it's to be expected.
>> >
>> > Please file a bug with example numbers, and hopefully these errors may
>> be fixed.
>> >
>> > On 9/1/19 7:35 am, David Carlson wrote:
>> >> John,
>> >>
>> >> Thanks for the reference.  Alas, I will need to do some homework to
>> >> properly read SCM.  There must still be some sort of rounding issue
>> >> creeping in if the Scheduled Transaction SLR sometimes generates an
>> >> imbalance from ppmt = pmt - ipmt.
>> >>
>> >> David C
>> >>
>> >> On Tue, Jan 8, 2019 at 3:44 PM John Ralls  wrote:
>> >>
>> >>> The thee functions are defined in
>> >>>
>> https://github.com/Gnucash/gnucash/blob/maint/libgnucash/app-utils/fin.scm
>> ,
>> >>> prefixed with gnc: (so gnc:ipmt etc.).
>> >>>
>> >>> At line 41ff you'll see that ppmt = pmt - ipmt.
>> >>>
>> >>> Regards,
>> >>> John Ralls
>> >>>
>> >>>
>>  On Jan 8, 2019, at 12:48 PM, David Carlson <
>> david.carlson@gmail.com>
>> >>> wrote:
>>  My point is that the equations are defined by the assistant, and I
>> think
>> >>> that they can be expressed in a form that concentrates all the errors
>> into
>> >>> one line where a simple rounding would not generate a problem where
>> the
>> >>> parts do not add up to 100%.  Granted, the errors may sometimes cause
>> >>> inaccurate results, but they would not add the imbalance line to the
>> >>> transaction.
>>  The current equations are three  evaluations called pmt(numbers),
>> >>> ppmt(numbers) and ipmt(numbers) with no clue how they are actually
>> >>> evaluated.
>>  Apparently pmt is not always the sum of ppmt and ipmt. when rounding
>> >>> happens.  If ipmt were expressed as pmt-ppmt, there would be no
>> imbalance,
>> >>> but one of the other two ways to express all three may be less likely
>> to
>> >>> generate inaccurate results.
>>  David C
>> 
>>  On Mon, Jan 7, 2019 at 10:19 PM John Ralls 
>> wrote:
>> 
>> 
>> > On Jan 7, 2019, at 3:14 PM, David Carlson <
>> david.carlson@gmail.com>
>> >>> wrote:
>> > I just had a scheduled transaction that was set up by the
>> loan/mortgage
>> > repayment assistant appear with 0.01 Imbalance-USD.
>> >
>> > I would think that GnuCash should have an accuracy method that would
>> > prevent this from happening.  Is this a bug?
>> >
>> > I am using GnuCash 2.6.17 in Ubuntu 16.04 today.
>>  The accuracy method is what created the imbalance entry. ;-)
>> 
>>  There’s nothing in the SX system to pre-instantiate future scheduled
>> >>> transactions and ensure that they’re balanced. What would you have the
>> >>> check function do if it found an imbalanced case? How would you handle
>> >>> variables whose values are set by the user in the SLR dialog?
>>  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.
>>
>> ___
>> gnucash-user 

Re: [GNC] Loan Mortgage repayment assistant problem

[David Carlson]

I have created https://bugs.gnucash.org/show_bug.cgi?id=797032.

David C

On Wed, Jan 9, 2019 at 2:29 AM David Carlson 
wrote:

> With those numbers payment number 2 has an error.
>
> David C
>
> On Wed, Jan 9, 2019 at 2:23 AM David Carlson 
> wrote:
>
>> I am working on a test scenario.The interest formula is ipmt( 0.03500 /
>> 12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers
>> and the 71st payment contains the error.  I am using these numbers because
>> they are exactly the same as the numbers that have already generated an
>> error.
>> i started the test loan in Jan 2000 with the first repayment in February
>> and I am creating one month at a time in case that makes a difference.  If
>> the test can repeat it I will submit the bug report.
>>
>> David C
>>
>> On Tue, Jan 8, 2019 at 10:52 PM John Ralls  wrote:
>>
>>> The answer is probably in app-utils/calculation. All of that was
>>> probably written before Guile grew a rational number class and I think that
>>> GncNumerics get converted to doubles before being passed to the interest
>>> functions. That would pretty much guarantee rounding issues.
>>>
>>> Regards,
>>> John Ralls
>>>
>>> > On Jan 8, 2019, at 5:46 PM, Christopher Lam 
>>> wrote:
>>> >
>>> > Well the SCM has numerous references to "round" and "rounding errors"
>>> so it's to be expected.
>>> >
>>> > Please file a bug with example numbers, and hopefully these errors may
>>> be fixed.
>>> >
>>> > On 9/1/19 7:35 am, David Carlson wrote:
>>> >> John,
>>> >>
>>> >> Thanks for the reference.  Alas, I will need to do some homework to
>>> >> properly read SCM.  There must still be some sort of rounding issue
>>> >> creeping in if the Scheduled Transaction SLR sometimes generates an
>>> >> imbalance from ppmt = pmt - ipmt.
>>> >>
>>> >> David C
>>> >>
>>> >> On Tue, Jan 8, 2019 at 3:44 PM John Ralls  wrote:
>>> >>
>>> >>> The thee functions are defined in
>>> >>>
>>> https://github.com/Gnucash/gnucash/blob/maint/libgnucash/app-utils/fin.scm
>>> ,
>>> >>> prefixed with gnc: (so gnc:ipmt etc.).
>>> >>>
>>> >>> At line 41ff you'll see that ppmt = pmt - ipmt.
>>> >>>
>>> >>> Regards,
>>> >>> John Ralls
>>> >>>
>>> >>>
>>>  On Jan 8, 2019, at 12:48 PM, David Carlson <
>>> david.carlson@gmail.com>
>>> >>> wrote:
>>>  My point is that the equations are defined by the assistant, and I
>>> think
>>> >>> that they can be expressed in a form that concentrates all the
>>> errors into
>>> >>> one line where a simple rounding would not generate a problem where
>>> the
>>> >>> parts do not add up to 100%.  Granted, the errors may sometimes cause
>>> >>> inaccurate results, but they would not add the imbalance line to the
>>> >>> transaction.
>>>  The current equations are three  evaluations called pmt(numbers),
>>> >>> ppmt(numbers) and ipmt(numbers) with no clue how they are actually
>>> >>> evaluated.
>>>  Apparently pmt is not always the sum of ppmt and ipmt. when rounding
>>> >>> happens.  If ipmt were expressed as pmt-ppmt, there would be no
>>> imbalance,
>>> >>> but one of the other two ways to express all three may be less
>>> likely to
>>> >>> generate inaccurate results.
>>>  David C
>>> 
>>>  On Mon, Jan 7, 2019 at 10:19 PM John Ralls 
>>> wrote:
>>> 
>>> 
>>> > On Jan 7, 2019, at 3:14 PM, David Carlson <
>>> david.carlson@gmail.com>
>>> >>> wrote:
>>> > I just had a scheduled transaction that was set up by the
>>> loan/mortgage
>>> > repayment assistant appear with 0.01 Imbalance-USD.
>>> >
>>> > I would think that GnuCash should have an accuracy method that
>>> would
>>> > prevent this from happening.  Is this a bug?
>>> >
>>> > I am using GnuCash 2.6.17 in Ubuntu 16.04 today.
>>>  The accuracy method is what created the imbalance entry. ;-)
>>> 
>>>  There’s nothing in the SX system to pre-instantiate future scheduled
>>> >>> transactions and ensure that they’re balanced. What would you have
>>> the
>>> >>> check function do if it found an imbalanced case? How would you
>>> handle
>>> >>> variables whose values are set by the user in the SLR dialog?
>>>  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 

Re: [GNC] Should the CSV Importer obey with the "automatic digital point" setting?

[Geert Janssens]

Hi Christoph,

I agree that's a bug. Can you file a bug report for this in our bug tracker 
please ? That way the report won't get lost.

Thanks,


Geert
[1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug 
tracker

Op dinsdag 8 januari 2019 17:34:24 CET schreef Christoph R:
> Hi,
> 
> currently the CSV importer obeys with the “automatic digital point” setting
> in Preferences->General.
> 
> IMO this should be changed. The above setting is a convenience for manual
> input. But csv files are normally generated automatically and often do not
> include a point for whole figures. In that case the imported figure will be
> wrong - which happened to me.
> 
> Any opinions?
> 
> Cheers,
> Christoph
> 
> ___
> 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] Loan Mortgage repayment assistant problem

[David Carlson]

I am working on a test scenario.The interest formula is ipmt( 0.03500 /
12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers
and the 71st payment contains the error.  I am using these numbers because
they are exactly the same as the numbers that have already generated an
error.
i started the test loan in Jan 2000 with the first repayment in February
and I am creating one month at a time in case that makes a difference.  If
the test can repeat it I will submit the bug report.

David C

On Tue, Jan 8, 2019 at 10:52 PM John Ralls  wrote:

> The answer is probably in app-utils/calculation. All of that was probably
> written before Guile grew a rational number class and I think that
> GncNumerics get converted to doubles before being passed to the interest
> functions. That would pretty much guarantee rounding issues.
>
> Regards,
> John Ralls
>
> > On Jan 8, 2019, at 5:46 PM, Christopher Lam 
> wrote:
> >
> > Well the SCM has numerous references to "round" and "rounding errors" so
> it's to be expected.
> >
> > Please file a bug with example numbers, and hopefully these errors may
> be fixed.
> >
> > On 9/1/19 7:35 am, David Carlson wrote:
> >> John,
> >>
> >> Thanks for the reference.  Alas, I will need to do some homework to
> >> properly read SCM.  There must still be some sort of rounding issue
> >> creeping in if the Scheduled Transaction SLR sometimes generates an
> >> imbalance from ppmt = pmt - ipmt.
> >>
> >> David C
> >>
> >> On Tue, Jan 8, 2019 at 3:44 PM John Ralls  wrote:
> >>
> >>> The thee functions are defined in
> >>>
> https://github.com/Gnucash/gnucash/blob/maint/libgnucash/app-utils/fin.scm
> ,
> >>> prefixed with gnc: (so gnc:ipmt etc.).
> >>>
> >>> At line 41ff you'll see that ppmt = pmt - ipmt.
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
> >>>
>  On Jan 8, 2019, at 12:48 PM, David Carlson <
> david.carlson@gmail.com>
> >>> wrote:
>  My point is that the equations are defined by the assistant, and I
> think
> >>> that they can be expressed in a form that concentrates all the errors
> into
> >>> one line where a simple rounding would not generate a problem where the
> >>> parts do not add up to 100%.  Granted, the errors may sometimes cause
> >>> inaccurate results, but they would not add the imbalance line to the
> >>> transaction.
>  The current equations are three  evaluations called pmt(numbers),
> >>> ppmt(numbers) and ipmt(numbers) with no clue how they are actually
> >>> evaluated.
>  Apparently pmt is not always the sum of ppmt and ipmt. when rounding
> >>> happens.  If ipmt were expressed as pmt-ppmt, there would be no
> imbalance,
> >>> but one of the other two ways to express all three may be less likely
> to
> >>> generate inaccurate results.
>  David C
> 
>  On Mon, Jan 7, 2019 at 10:19 PM John Ralls 
> wrote:
> 
> 
> > On Jan 7, 2019, at 3:14 PM, David Carlson <
> david.carlson@gmail.com>
> >>> wrote:
> > I just had a scheduled transaction that was set up by the
> loan/mortgage
> > repayment assistant appear with 0.01 Imbalance-USD.
> >
> > I would think that GnuCash should have an accuracy method that would
> > prevent this from happening.  Is this a bug?
> >
> > I am using GnuCash 2.6.17 in Ubuntu 16.04 today.
>  The accuracy method is what created the imbalance entry. ;-)
> 
>  There’s nothing in the SX system to pre-instantiate future scheduled
> >>> transactions and ensure that they’re balanced. What would you have the
> >>> check function do if it found an imbalanced case? How would you handle
> >>> variables whose values are set by the user in the SLR dialog?
>  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.
>
> ___
> 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 

Re: [GNC] Investment Accounts not Displaying Decimals

[Les]

Thanks David.

I think you are right.

Les

On 1/9/19 10:07 AM, David Carlson wrote:
I believe you just have to live with it in release 2.6.21 or several 
other releases below 3.3.  You should be able to manually re save any 
particular entry in decimal form if it is really bothering you, but 
why bother if it does not appear that way in reports?


David C

On Wed, Jan 9, 2019 at 9:52 AM Tom Teixeira > wrote:


Maybe try Tools>Security Editor. Check the "Fraction Traded" field for
those securities which only show whole numbers. The other place to
look
is "Smallest Fraction" field for the account itself, though as I
recall,
the default is "Use Commodity Value" which is set by the Security
Editor.

On 1/9/19 10:06 AM, Les wrote:
> As far as I can determine, there is nothing in preferences that
> addresses this issue.  Also, there are only 2 maybe 20 investment
> accounts with this issue.
>
> Les
>
>
> On 1/9/19 8:14 AM, Geert Janssens wrote:
>> Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
>>> Check preferences. There is an option for this.
>>>
>>> Regards,
>>> Adrien
>> While I may be wrong I thought this was only introduced in the 3.x
>> series ?
>>
>> 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.
> ___
> 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] Maybe a bug? Alt-Tab losing partial focus.

[Jack Slater]

It is indeed fixed. Thanks!

On Mon, Jan 7, 2019 at 1:04 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I’m pretty sure it was included in 3.4 that was released at the end of
> December.
>
> Regards,
> Adrien
>
> > On Jan 7, 2019, at 11:24 AM, Jack Slater  wrote:
> >
> > Any news on this fix?
> >
> > On Wed, Nov 28, 2018 at 2:07 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> > There is at least one bug filed on text selection issues. I’m not sure
> if this is part of the same problem.
> >
> > Regards,
> > Adrien
> >
> > > On Nov 28, 2018, at 12:08 PM, Jack Slater 
> wrote:
> > >
> > > Windows 10
> > > GnuCash 3.3
> > >
> > > If cursor focus is on the numeric total in the CHARGE field (Example:
> the
> > > entire 15.22 is highlighted) and I Alt-Tab to a web browser to verify
> the
> > > amount from an invoice and then Alt-Tab back, only the .22 of field
> hold
> > > the focus.
> > > ___
> > > 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.
___
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] Investment Accounts not Displaying Decimals

[David Carlson]

I believe you just have to live with it in release 2.6.21 or several other
releases below 3.3.  You should be able to manually re save any particular
entry in decimal form if it is really bothering you, but why bother if it
does not appear that way in reports?

David C

On Wed, Jan 9, 2019 at 9:52 AM Tom Teixeira 
wrote:

> Maybe try Tools>Security Editor. Check the "Fraction Traded" field for
> those securities which only show whole numbers. The other place to look
> is "Smallest Fraction" field for the account itself, though as I recall,
> the default is "Use Commodity Value" which is set by the Security Editor.
>
> On 1/9/19 10:06 AM, Les wrote:
> > As far as I can determine, there is nothing in preferences that
> > addresses this issue.  Also, there are only 2 maybe 20 investment
> > accounts with this issue.
> >
> > Les
> >
> >
> > On 1/9/19 8:14 AM, Geert Janssens wrote:
> >> Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
> >>> Check preferences. There is an option for this.
> >>>
> >>> Regards,
> >>> Adrien
> >> While I may be wrong I thought this was only introduced in the 3.x
> >> series ?
> >>
> >> 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.
> > ___
> > 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] Loan Mortgage repayment assistant problem

[Fred Bone]

On Wednesday, January 9, 2019 at 9:44, David Carlson said:

> Absolutely, I was not expecting agreement with the bank, I just think the
> creation of an unbalanced transaction is bad form.

There is no reason to expect that taking three rational numbers A, B and 
C, such that A=B+C, converting to decimal and rounding to two decimal 
places, will never result in imbalance.

The simplest example I can come up with is 9/7, 5/7 and 4/7 where
 9/7 = 1.285714... -> 1.29
 5/7 = 0.714285... -> 0.71
 4/7 = 0.571428... -> 0.57
with imbalance 0.01


___
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] Investment Accounts not Displaying Decimals

[Les]

Thanks for the suggestions, but I have already checked these accounts 
and they are the same as all the others (1/1).


Les

On 1/9/19 9:45 AM, Tom Teixeira wrote:

Maybe try Tools>Security Editor. Check the "Fraction Traded" field for
those securities which only show whole numbers. The other place to look
is "Smallest Fraction" field for the account itself, though as I recall,
the default is "Use Commodity Value" which is set by the Security Editor.

On 1/9/19 10:06 AM, Les wrote:

As far as I can determine, there is nothing in preferences that
addresses this issue.  Also, there are only 2 maybe 20 investment
accounts with this issue.

Les


On 1/9/19 8:14 AM, Geert Janssens wrote:

Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:

Check preferences. There is an option for this.

Regards,
Adrien

While I may be wrong I thought this was only introduced in the 3.x
series ?

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.

___
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] Does CSV importer work with foreign currencies?

[boldstripe]

With the current CSV Importer interface, it is not immediately clear to me
what exchange rate would be used for the conversion of an individual
imported transaction to the base currency. 

My first assumption would be that the imported values are simply numbers and
assume the currency of the account only once they have been imported to a
foreign-currency account, as if the same numbers had been manually entered;
and that the exchange rate used to calculate the base-currency amount on the
other side of any one transaction is whatever prevails in the Price Database
on the date of that transaction.

If that is how it is supposed to work then the existing CSV importer GUI is
sufficient, but if I have got this wrong then I and other users could use
some help there :-)



--
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] Loan Mortgage repayment assistant problem

[David Carlson]

Absolutely, I was not expecting agreement with the bank, I just think the
creation of an unbalanced transaction is bad form.

David Carlson

On Wed, Jan 9, 2019, 9:03 AM John Ralls 
>
> > On Jan 9, 2019, at 6:26 AM, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> >
> > On 1/8/2019 11:50 PM, John Ralls wrote:
> >> The answer is probably in app-utils/calculation. All of that was
> probably written before Guile grew a rational number class and I think that
> GncNumerics get converted to doubles before being passed to the interest
> functions. That would pretty much guarantee rounding issues.
> >>
> >> Regards,
> >> John Ralls
> > I will repeat, this sort of "rounding error" is not a bug.
> >
> > If two persons set out to perform a calculation which can be done by a
> number of methods with rounding involved at numerous places and no
> agreement as to either the method to be used or the precision maintained at
> each step THERE IS NO REASONABLE EXPECTATION THAT THEIR ANSWERS WILL MATCH
> EXACTLY.
> >
> > Treated as a "bug", it might* be possible to change the code so as to
> match the answers of a particular lending institution, but then could be
> wrong for another lending institution that used different methods or
> rounding than the first.
> >
> > Michael D Novack<< who in my working days often had to compute the
> "fuzz" for comparisons >>
> >
> > * Might, because you have no reason to suppose that a lending
> institution necessarily used the same methods/rounding for car loans as for
> house mortgages.
>
> Which is why GnuCash mostly uses rational numbers and no rounding for
> internal calculations. Using binary floating-point in financial software is
> a bug on its own, so that “mostly” is a bug. It needs to be “only”.
>
> This isn’t about matching the results with someone else’s computer, this
> is about internal consistency in GnuCash.
>
> 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] Investment Accounts not Displaying Decimals

[Tom Teixeira]

Maybe try Tools>Security Editor. Check the "Fraction Traded" field for
those securities which only show whole numbers. The other place to look
is "Smallest Fraction" field for the account itself, though as I recall,
the default is "Use Commodity Value" which is set by the Security Editor.

On 1/9/19 10:06 AM, Les wrote:
> As far as I can determine, there is nothing in preferences that
> addresses this issue.  Also, there are only 2 maybe 20 investment
> accounts with this issue.
>
> Les
>
>
> On 1/9/19 8:14 AM, Geert Janssens wrote:
>> Op woensdag 9 januari 2019 12:51:45 CET schreef Adrien Monteleone:
>>> Check preferences. There is an option for this.
>>>
>>> Regards,
>>> Adrien
>> While I may be wrong I thought this was only introduced in the 3.x
>> series ?
>>
>> 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.
> ___
> 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] Loan Mortgage repayment assistant problem

[Stephen M. Butler]

On 1/9/19 6:26 AM, Michael or Penny Novack wrote:
> On 1/8/2019 11:50 PM, John Ralls wrote:
>> The answer is probably in app-utils/calculation. All of that was
>> probably written before Guile grew a rational number class and I
>> think that GncNumerics get converted to doubles before being passed
>> to the interest functions. That would pretty much guarantee rounding
>> issues.
>>
>> Regards,
>> John Ralls
>  I will repeat, this sort of "rounding error" is not a bug.
>
> If two persons set out to perform a calculation which can be done by a
> number of methods with rounding involved at numerous places and no
> agreement as to either the method to be used or the precision
> maintained at each step THERE IS NO REASONABLE EXPECTATION THAT THEIR
> ANSWERS WILL MATCH EXACTLY.
>
> Treated as a "bug", it might* be possible to change the code so as to
> match the answers of a particular lending institution, but then could
> be wrong for another lending institution that used different methods
> or rounding than the first.
>
> Michael D Novack    << who in my working days often had to compute the
> "fuzz" for comparisons >>
>
> * Might, because you have no reason to suppose that a lending
> institution necessarily used the same methods/rounding for car loans
> as for house mortgages.
And some use generic 30 day months while others use the actual number of
days in each month.  Some compound daily while others use simple interest.

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Loan Mortgage repayment assistant problem

[David Carlson]

Yup!

On the other hand, 1.29-0.71 = 0.58, so while one solution might be to
create a transaction with those particular numbers, that method generates
too much error for some calculations or combinations of values.  That is
why the developers are working to use real math whenever possible.

I recently found the hp49g+ calculator that i bought about a decade ago and
discovered that it can work either in exact or approximate CAS modes, as
they describe them.  And it still works!

David C

On Wed, Jan 9, 2019 at 11:31 AM Fred Bone  wrote:

> On Wednesday, January 9, 2019 at 9:44, David Carlson said:
>
> > Absolutely, I was not expecting agreement with the bank, I just think the
> > creation of an unbalanced transaction is bad form.
>
> There is no reason to expect that taking three rational numbers A, B and
> C, such that A=B+C, converting to decimal and rounding to two decimal
> places, will never result in imbalance.
>
> The simplest example I can come up with is 9/7, 5/7 and 4/7 where
>  9/7 = 1.285714... -> 1.29
>  5/7 = 0.714285... -> 0.71
>  4/7 = 0.571428... -> 0.57
> with imbalance 0.01
>
>
> ___
> 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] Deb 3.4.0.1 not working for me in ubuntu 18.04

[Stephen M. Butler]

On 1/9/19 3:36 AM, Geert Janssens wrote:
> Op dinsdag 8 januari 2019 22:11:29 CET schreef Colin Law:
>> On Tue, 8 Jan 2019 at 17:52, Stephen M. Butler  wrote:
>>> I am trying to get a better deb via Launchpad were we can put up a ppa
>>> for folks to point to.  Probably name it "gnucash-daily", although I
>>> don't see it changing daily but as commits are made to the maint branch.
>> From my personal point of view the most useful ppa would be one that has
>> the latest released version rather than a daily or similar version.
>>
>>> However, I am having problems with one of the tools (pbuilder-dest) and
>>> have a query out in the Ubuntu Forums for input.  Nothing back when I
>>> checked a minute ago.  I suspect I'm going to have to read the code
>>> (shell script) for pbuild-dest and the debootstrap script it invokes
>>> (also shell script).  The later complains that gpgv can't be found --
>>> but I can invoke it just fine.  I am comfortable in ksh and hope that
>>> transfers well to bsh.
>>>
>>> Wish I had better news and was making progress to get something really
>>> useful.  My research indicates the check-install is not up to the task
>>> of dealing with multiple O/S version.
> Indeed. Last time I checked (which is 10+ years ago already) checkinstall 
> didn't do dependency tracking. What it does is recording everything that gets 
> installed by 'make install' and wrapping that in a .deb package (or .rpm 
> package for that matter).
>
> As far as I understand it's not really meant to prepare packages for 
> distribution, but to make your package manager aware that you have installed 
> something you built from scratch. The advantages are
> 1. your package manager is made aware of  what got installed and hence can 
> properly manage file conflicts on later system updates.
> 2. your package manager can be used to remove the package cleanly if you no 
> longer need it.
>
> Packaging for distribution is more complicated than that. Such a package 
> needs 
> dependency information to help the package manager install the proper 
> dependencies.
>
> The best way to get there is indeed starting from the package sources of a 
> working package. I'm used to the rpm world in which a source package 
> essentially consists of a package spec file, a source tarball and optionally 
> a 
> number of patch files. The spec file contains all the details, including 
> dependencies (with minimum versions), how to build from source and how to 
> install. These source packages can be "installed" into a development 
> environment and then adjusted before composing a final rpm file. A long time 
> ago I have created my own rpms that way:
> In the installed source package I replaced the source tarball with a more 
> recent one and then tweaked the spec file as required. This I could then be 
> compiled into a final rpm ready for distribution.
>
> I assume something similar can be done with .deb package. No doubt they also 
> have some source format you can download somewhere, update and the recompose 
> into a proper .deb file. Dmitri's work is probably a good starting point. To 
> make it more universally installable (as opposed to only for a specific 
> ubuntu 
> release) you'd need to find a way to adjust the dependencies to declare 
> minimum versions rather than exact versions (like for libboost >= 1.54 
> instead 
> of libboost = 1.65). Rpm allows this and I expect the deb format to allow 
> this 
> as well in some form or another. GnuCash' minimal dependencies are nicely 
> recorded by David Cousens in our wiki:
> https://wiki.gnucash.org/wiki/Dependencies
> So that can also be useful for you.
>
> Good luck!
>
> Geert


That is also my understanding of .deb files.  I'll keep the wiki in mind
as I move forward. 

In the last 24 hours found that sbuilder is an alternative (older?) to
pbuilder and it installed/ran on my box.  So I'm switching to use that
tool.  It also has hooks for a git-buildpackage utility that will allow
direct interaction with a local git clone.  I'm hoping all I have to do
is do a git pull on the maint branch, add in the local spec files and
let sbuild do its thing.

I'm either approaching the knee or into it on the learning curve here!

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] business Accounts Payable questions

[Tim Kallmer]

i'm new to using GC for business.

i don't understand the format and behavior Accounts Payable account. can
you explain the 'Ty' column that starts with '?', then toggles between 'I'
and 'P'? are these 'type', 'invoiced', and 'paid'? can you explain why the
due date cell cannot be edited in 'I' mode?

my small business doesn't have goods and vendor bills, or employees and
expense vouchers. is Accounts Payable able to have transactions entered
manually rather through bills or vouchers?

lastly, in trying to fiddle with A/P, i entered some temporary vendors,
employees, and bills. is it true these cannot be deleted without somehow
editing the XML? how would i go about deleting them?
___
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] GnuCash won't open

[Colin Law]

Ruth, you sent this to me personally rather than to the group, so I am
forwarding it to the group.
You should not give up, there will be those on the list who know how to
help.

Colin

On Wed, 9 Jan 2019 at 21:31, Ruth L. Mazur  wrote:

> I have spent too much time trying to get this app, so I give up.  On
> Safari it asks since it’s not an Apple product and I say, OPEN. In
> preferences I select download from anywhere.  It verifies, shows in my Dock
> and then disappears.
>
> So I tried Firefox.  It wanted to download 2.6.21 but told me it was
> “damaged” and I should eject it.
>
> Sorry this just won’t work for me.
>
> Ruth Mazur
>
>
>
>
> > On Jan 3, 2019, at 1:16 AM, Colin Law  wrote:
> >
> > On Thu, 3 Jan 2019 at 07:10, Ruth L. Mazur 
> wrote:
> >>
> >> I have downloaded GnuCash 3.4-Intel to my Mac OS10.11.6  a dozen times
> but I can not get it to open. For Privacy I’m set to sites that I visit.
> Once I set it to Anyone and that didn’t work either.
> >
> > Did you carefully follow the installation instructions for Mac?
> > https://wiki.gnucash.org/wiki/Installation
> >
> > Colin
> >
> >>
> >> This has been very frustrating.  I’m disillusioned with Quicken and
> want something else, and free is good! What do I need to know to get this
> app?
> >>
> >> Thanks for any help,
> >>
> >> Ruth Mazur
> >> Grass Valley, CA
> >>
> >>
> >>
> >> ___
> >> 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.