Re: [GNC] Multiple currencies and business functions

2018-11-06 Thread Matthew Pounsett
On Tue, 6 Nov 2018 at 15:30, Christian Kluge  wrote:

> > The currency logic is pretty simple: every amount you see in the invoice
> > entries is assumed to be in the customer's default currency. They income
> > account for each entry can be in a currency different from the invoice
> > account. In that case a currency conversion will be applied when posting
> this
> > amount to the income account. But as amounts for billable items come
> from the
> > entries, they are assumed to be in the customer's currency.
>
>
> That’s why my solution would be never to income and expense accounts in
> foreign currencies, but only assets and liability accounts in addition
> to the trading accounts.
>

Expense accounts mostly get smoothed into one currency by the effects of
having banks convert on deposit or charge in bank accounts and credit
cards.  Although I still have to deal with foreign currency service charges
on international wire transfers.

I don't think it's reasonable to expect to have only one income currency
with international clients.


> For the actual problem my solution would be as follows.
>
> [..]


> The last operation would be to add a transaction from the temporary CAD
> asset account to your normal USD income account.
>
>
I had to read it a few times, but I think I follow that.  I'll give it a
shot later and see what happens.
Thanks
___
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] Multiple currencies and business functions

2018-11-06 Thread Matthew Pounsett
On Tue, 6 Nov 2018 at 12:22, Geert Janssens 
wrote:

> I believe you have just pushed the boundaries of what to do with invoices
> further than anyone ever could have imagined :)
>

Good? :)


>
> I don't think anyone so far ever considered the case of having billable
> expenses in a different currency from the invoice currency. And from what
> you
> tell I gather it's currently not supported.
>

I'm a little surprised.  It seems like an obvious situation to me.  Between
travel, foreign clients, or just import/export it seems like something that
would come up at least occasionally.

In my case there's a combination of travel (I post expenses in a half dozen
currencies) and having International clients that want to be billed in
their home currency.


>
> Can I ask you to file this as a bug report in bugzilla ? Refer to http://
> wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker.
>
>
Sure.  I'll get that in tonight.


>
___
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] Accounting for Refund

2018-11-06 Thread Eric Rathhaus office
Thanks so much.  All is square!


Kind regards,

Eric W. Rathhaus
Law Office of Eric W. Rathhaus
484 Lake Park Avenue, Suite 50
Oakland, CA 94610
415.577.0920 tel
415.737.0603 fax

www.ewrlaw.com

Confidentiality : 

The information contained in this message is legally privileged and 
confidential information intended only for the use of the addressee(s) named 
above.  If the reader of this message is not the intended recipient, please be 
advised that any dissemination, distribution, or copy of the information in 
this message, and/or the name(s) of the person(s) it is addressed to, is 
prohibited.  If you have received this message in error, please notify us by 
returning this email to us.  If that is not possible, we will reimburse you for 
any costs in returning this message to us through other means.



> On Nov 6, 2018, at 12:32 PM, Geert Janssens  
> wrote:
> 
> Op dinsdag 6 november 2018 20:01:02 CET schreef Eric Rathhaus office:
>> Where’s the “refund” option?
> 
> * Business->Customer->Process Payment...
> * When the dialog opens, select the customer
> * In the list of documents click on the credit note
> => The open amount of the credit note will be filled in in the "Refund" field 
> instead of the "Payment" field.
> * Select the account you used to pay this amount to your customer
> * Click ok.
> 
> 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] Loan & Insurance Rate

2018-11-06 Thread David Cousens
Antoine,

There is no way you can simply incorporate the insurance payments into the
GnuCash loan calculations, at least at present, as the wizard does not have
the capacity to do this. It has not been programmed to treat this situation.
It is possibly better to set up the loan calculation in a spread sheet where
you can incorporate the additional insurancepayment into the balance of the
loan at each payment interval.

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] Multiple currencies and business functions

2018-11-06 Thread Christian Kluge
Hi,

just a minor addition.

Am 06.11.2018 um 21:29 schrieb Christian Kluge:
> Hi,
> 
> Am 06.11.2018 um 18:22 schrieb Geert Janssens:
>> Op dinsdag 6 november 2018 17:16:16 CET schreef Matthew Pounsett:
>>> I have cases with both billable employee expenses (vouchers) and billable
>>> purchases (vendor bills) which need to go on customer invoices.   This is
>>> fairly straight forward... the problem I'm having is how to deal with these
>>> when the currency I'm entering the voucher or bill in is not the same as
>>> the customer's invoice currency.
>>>
>>> To use a concrete example, say I've got a $100 employee expense in CAD that
>>> gets marked as billable.  If I have a client whose default currency is USD,
>>> when the item is added it appears with the CAD value ($100) but is added up
>>> in the total at the bottom as if it's USD.
>>>
>>> Is there a step I'm missing somewhere to get it to show up as a USD value
>>> in the invoice?
>>
>> I believe you have just pushed the boundaries of what to do with invoices 
>> further than anyone ever could have imagined :)
>>
>> I don't think anyone so far ever considered the case of having billable 
>> expenses in a different currency from the invoice currency. And from what 
>> you 
>> tell I gather it's currently not supported.
>>
>> The currency logic is pretty simple: every amount you see in the invoice 
>> entries is assumed to be in the customer's default currency. They income 
>> account for each entry can be in a currency different from the invoice 
>> account. In that case a currency conversion will be applied when posting 
>> this 
>> amount to the income account. But as amounts for billable items come from 
>> the 
>> entries, they are assumed to be in the customer's currency.
> 
> 
> That’s why my solution would be never to income and expense accounts in
> foreign currencies, but only assets and liability accounts in addition
> to the trading accounts.
> 
>>
>> This is a bug either way: or gnucash should prevent an entry from appearing 
>> as 
>> billable if it's original bill is not in the same currency as the invoice, 
>> or 
>> gnucash should support this and properly handle currency conversions.
>> The first solution will be far more easy to implement than the second though.
>>
>> Can I ask you to file this as a bug report in bugzilla ? Refer to http://
>> wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker.
> 
> 
> For the actual problem my solution would be as follows.
> 
> Firstly I would grab the current conversion rate via Finance-Quote or
> get it from somewhere else.
> 
> That next thing would be to setup an temporary assset account in CAD so
> that you can record your income later on.
> 
> After this I would write the invoice and use the account previously set
> up as the Income Account.
> 
> Beware when writing the invoice you’d have to write the converted amount
> in USD in the unit collumn. Luckily gnucash has rudimentary calculator
> functions so that you can just write 100.00 press ÷ or × depending which
> way the quote is given and paste the rate and you should get the
> converted amount.
u>
> I would mention the CAD amount in the description and maybe also add the
> conversion rate there or after the total invoice amount.
> 
> Then go on and add your other billable lines.
> 
> If you’re going to post the invoice, you’ll get asked for the conversion
> rates.
> 
> If everything plays out you should get the same amount in CAD, else just
> change it, there sometimes are little rounding errors.
> 

The other solution would be to cancel the posting and change the unit price.

> The last operation would be to add a transaction from the temporary CAD
> asset account to your normal USD income account.
>
___
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] Accounting for Refund

2018-11-06 Thread Geert Janssens
Op dinsdag 6 november 2018 20:01:02 CET schreef Eric Rathhaus office:
> Where’s the “refund” option?

* Business->Customer->Process Payment...
* When the dialog opens, select the customer
* In the list of documents click on the credit note
=> The open amount of the credit note will be filled in in the "Refund" field 
instead of the "Payment" field.
* Select the account you used to pay this amount to your customer
* Click ok.

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] Multiple currencies and business functions

2018-11-06 Thread Christian Kluge
Hi,

Am 06.11.2018 um 18:22 schrieb Geert Janssens:
> Op dinsdag 6 november 2018 17:16:16 CET schreef Matthew Pounsett:
>> I have cases with both billable employee expenses (vouchers) and billable
>> purchases (vendor bills) which need to go on customer invoices.   This is
>> fairly straight forward... the problem I'm having is how to deal with these
>> when the currency I'm entering the voucher or bill in is not the same as
>> the customer's invoice currency.
>>
>> To use a concrete example, say I've got a $100 employee expense in CAD that
>> gets marked as billable.  If I have a client whose default currency is USD,
>> when the item is added it appears with the CAD value ($100) but is added up
>> in the total at the bottom as if it's USD.
>>
>> Is there a step I'm missing somewhere to get it to show up as a USD value
>> in the invoice?
> 
> I believe you have just pushed the boundaries of what to do with invoices 
> further than anyone ever could have imagined :)
> 
> I don't think anyone so far ever considered the case of having billable 
> expenses in a different currency from the invoice currency. And from what you 
> tell I gather it's currently not supported.
> 
> The currency logic is pretty simple: every amount you see in the invoice 
> entries is assumed to be in the customer's default currency. They income 
> account for each entry can be in a currency different from the invoice 
> account. In that case a currency conversion will be applied when posting this 
> amount to the income account. But as amounts for billable items come from the 
> entries, they are assumed to be in the customer's currency.


That’s why my solution would be never to income and expense accounts in
foreign currencies, but only assets and liability accounts in addition
to the trading accounts.

> 
> This is a bug either way: or gnucash should prevent an entry from appearing 
> as 
> billable if it's original bill is not in the same currency as the invoice, or 
> gnucash should support this and properly handle currency conversions.
> The first solution will be far more easy to implement than the second though.
> 
> Can I ask you to file this as a bug report in bugzilla ? Refer to http://
> wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker.


For the actual problem my solution would be as follows.

Firstly I would grab the current conversion rate via Finance-Quote or
get it from somewhere else.

That next thing would be to setup an temporary assset account in CAD so
that you can record your income later on.

After this I would write the invoice and use the account previously set
up as the Income Account.

Beware when writing the invoice you’d have to write the converted amount
in USD in the unit collumn. Luckily gnucash has rudimentary calculator
functions so that you can just write 100.00 press ÷ or × depending which
way the quote is given and paste the rate and you should get the
converted amount.

I would mention the CAD amount in the description and maybe also add the
conversion rate there or after the total invoice amount.

Then go on and add your other billable lines.

If you’re going to post the invoice, you’ll get asked for the conversion
rates.

If everything plays out you should get the same amount in CAD, else just
change it, there sometimes are little rounding errors.

The last operation would be to add a transaction from the temporary CAD
asset account to your normal USD income account.

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] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues (Solved)

2018-11-06 Thread Geert Janssens
Glad you got it working and thanks for sharing your solution !

Geert

Op dinsdag 6 november 2018 20:02:06 CET schreef Wolfram Wagner:
> Dear List,
> for the next running into these issues.
> 
> My Problem:
> I am running debian stable/strech 9. The stable version delivers a
> pretty old gnucash. I have used gnucash on fedora before, was there on
> 3.2 already and could not use the more recent database in the old
> version.
> So I removed the old gnucash and installed gnucash 3.2 via flatpak in
> this way:
> (1) I installed flatpak via apt.
> (2) Opened the application "Software" and installed gnucash.
> 
> The cause:
> Gnucash started in English, no matter what I have tried.
> This process has not installed the locales for gnucash.
> 
> You can recognize this situation by starting it from command line via
> 
> $ flatpak run org.gnucash.GnuCash
> 
> It will give you "The locale defined in the environment isn't
> supported. Falling back to the 'C' (US English) locale".
> 
> 
> I found a hint [1] and issued:
> $ flatpak remote-ls flathub | grep gnucash
> org.gnucash.GnuCash
> org.gnucash.GnuCash.Debug  
> org.gnucash.GnuCash.Locale 
> org.gnucash.GnuCash.Sources 
> 
> This shows, that gnucash seems to have a subpackage .Locale that smells
>   like my missing translations.
> 
> As I had modified my local flatpak installation, I removed gnucash with
> $ sudo flatpak --system uninstall org.gnucash.GnuCash
> 
> and installed them again with:
> 
> $ sudo flatpak --system install flathub org.gnucash.GnuCash
> org.gnucash.GnuCash.Locale
> 
> And it worked:
> flatpak run org.gnucash.GnuCash
> 
> => German
> 
> Thanks for your patience with me! If I can help others, I am glad!
> 
> Wolfram
> 
> The hint that helped me understanding flatpak
> [1] https://github.com/flathub/org.blender.Blender/issues/5#issuecommen
> t-390494396
> ___
> 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] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues (Solved)

2018-11-06 Thread Wolfram Wagner
Dear List,
for the next running into these issues.

My Problem:
I am running debian stable/strech 9. The stable version delivers a
pretty old gnucash. I have used gnucash on fedora before, was there on
3.2 already and could not use the more recent database in the old
version.
So I removed the old gnucash and installed gnucash 3.2 via flatpak in
this way:
(1) I installed flatpak via apt. 
(2) Opened the application "Software" and installed gnucash.

The cause:
Gnucash started in English, no matter what I have tried. 
This process has not installed the locales for gnucash. 

You can recognize this situation by starting it from command line via

$ flatpak run org.gnucash.GnuCash

It will give you "The locale defined in the environment isn't
supported. Falling back to the 'C' (US English) locale".


I found a hint [1] and issued:
$ flatpak remote-ls flathub | grep gnucash
org.gnucash.GnuCash
org.gnucash.GnuCash.Debug  
org.gnucash.GnuCash.Locale 
org.gnucash.GnuCash.Sources 

This shows, that gnucash seems to have a subpackage .Locale that smells
  like my missing translations.

As I had modified my local flatpak installation, I removed gnucash with
$ sudo flatpak --system uninstall org.gnucash.GnuCash

and installed them again with:

$ sudo flatpak --system install flathub org.gnucash.GnuCash
org.gnucash.GnuCash.Locale

And it worked:
flatpak run org.gnucash.GnuCash

=> German

Thanks for your patience with me! If I can help others, I am glad!

Wolfram 

The hint that helped me understanding flatpak
[1] https://github.com/flathub/org.blender.Blender/issues/5#issuecommen
t-390494396
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins


On Tue, November 6, 2018 1:46 pm, btrib wrote:
> Thank you that's good to know if it ever occurs again.
> Now, I need to find a workaround that will allow me mark the invoice as
> paid.

RE-apply the payment transaction.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
How are invoices designated as paid in the xml file?



--
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] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
Thank you that's good to know if it ever occurs again. 
Now, I need to find a workaround that will allow me mark the invoice as
paid.



--
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] Accounting for Refund

2018-11-06 Thread Eric Rathhaus office
Thanks, Geert.  Here’s my situation. I invoiced client for a number of costs I 
would incur for them, some of which I did not ending paying.  They don’t want 
me to apply this as a credit against outstanding invoices.  They want me to 
return the $.  I wanted to use the credit note as a way of detailing what funds 
I am returning and to balance out the income I received for which thee’s no 
corresponding expense.  But it seems to only understand the credit note as a 
form of income.  

Kind regards,

Eric W. Rathhaus
Law Office of Eric W. Rathhaus
484 Lake Park Avenue, Suite 50
Oakland, CA 94610
415.577.0920 tel
415.737.0603 fax

www.ewrlaw.com

Confidentiality : 

The information contained in this message is legally privileged and 
confidential information intended only for the use of the addressee(s) named 
above.  If the reader of this message is not the intended recipient, please be 
advised that any dissemination, distribution, or copy of the information in 
this message, and/or the name(s) of the person(s) it is addressed to, is 
prohibited.  If you have received this message in error, please notify us by 
returning this email to us.  If that is not possible, we will reimburse you for 
any costs in returning this message to us through other means.



> On Nov 6, 2018, at 10:01 AM, Geert Janssens  
> wrote:
> 
> Op dinsdag 6 november 2018 05:30:32 CET schreef Eric Rathhaus office:
>> I do have a f/u question. When I create a credit note, the program only
>> allows me to account for it as income and it appears as a positive number
>> in my accounts receivable.  How can I account for this transaction so that
>> gnu cash recognizes this transaction should be a debit against previously
>> income?
> 
> I'm not sure I understand what you're saying here. Customer invoices are 
> debits in Accounts Receivable and Credit notes are credits. What is a 
> "positive" number for you in this context ?
> 
> If you want to use the credit note to balance the outstanding invoices 
> balance, you can "pay" your invoices with that credit note. You do so by 
> opening Business->Customer->Process Payment...
> Enter the customer and select the invoices/credit notes you wish to offset. 
> If 
> there's a remaining balance you may want to set it to 0, unless you also want 
> to record a payment for this remaining balance in one go.
> Is this what you were looking for ?
> 
> By the way there was a bug in gnucash 3.0-3.2 where credit notes were of the 
> wrong sign. So be sure to work with the most recent version for proper credit 
> note handling.
> 
> Regards,
> 
> Geert
> 
> 

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

Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
Hi,

On Tue, November 6, 2018 12:58 pm, btrib wrote:
> I've updated to 3.3 and recovered all but the missing invoices.
> In recreating the missing invoices the challenge is that duplicate
> receivable entries will be created as well. Does anyone have a method they
> would recommend to recreate invoices that will not throw off the
> receivable
> account?

Are you saying you replayed log files?

That absolutely does not work with business features, and you will lose
data if you attempt to do so.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

2018-11-06 Thread Geert Janssens
Op dinsdag 6 november 2018 05:30:32 CET schreef Eric Rathhaus office:
> I do have a f/u question. When I create a credit note, the program only
> allows me to account for it as income and it appears as a positive number
> in my accounts receivable.  How can I account for this transaction so that
> gnu cash recognizes this transaction should be a debit against previously
> income?

I'm not sure I understand what you're saying here. Customer invoices are 
debits in Accounts Receivable and Credit notes are credits. What is a 
"positive" number for you in this context ?

If you want to use the credit note to balance the outstanding invoices 
balance, you can "pay" your invoices with that credit note. You do so by 
opening Business->Customer->Process Payment...
Enter the customer and select the invoices/credit notes you wish to offset. If 
there's a remaining balance you may want to set it to 0, unless you also want 
to record a payment for this remaining balance in one go.
Is this what you were looking for ?

By the way there was a bug in gnucash 3.0-3.2 where credit notes were of the 
wrong sign. So be sure to work with the most recent version for proper credit 
note handling.

Regards,

Geert


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


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
I've updated to 3.3 and recovered all but the missing invoices.
In recreating the missing invoices the challenge is that duplicate
receivable entries will be created as well. Does anyone have a method they
would recommend to recreate invoices that will not throw off the receivable
account?



--
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] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
Hi,

On Tue, November 6, 2018 12:37 pm, btrib wrote:
> Autosave simply updates the log file whereas closing the program updates
> the
> main file, correct?

No, autosave automatically saves the full data file every N minutes (where
you set N in your preferences) --- if there has been any changes to your
data.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Geert Janssens
Op dinsdag 6 november 2018 18:37:30 CET schreef btrib:
> Autosave simply updates the log file whereas closing the program updates the
> main file, correct?

No. Autosave is a full save and as such updates the main file. The log files 
are updated while you create/modify/delete a transaction.

Closing the program will do nothing if nothing changed since the last time the 
file was saved. If there are changes it will ask whether you want to save 
those before closing the program.

Regards,

Geert


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


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Maf. King
On Tuesday, 6 November 2018 17:37:30 GMT btrib wrote:
> Autosave simply updates the log file whereas closing the program updates the
> main file, correct?
> 

Incorrect, AFAIK

Assuming you are using the XML back end to save your file (not SQLite), then 
triggering a save (autosave, or File->Save)  renames the currently open file 
with the backup timestamp and then writes out the current data-in-RAM to a new 
file.

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] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread btrib
Autosave simply updates the log file whereas closing the program updates the
main file, correct?



--
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] Multiple currencies and business functions

2018-11-06 Thread Geert Janssens
Op dinsdag 6 november 2018 17:16:16 CET schreef Matthew Pounsett:
> I have cases with both billable employee expenses (vouchers) and billable
> purchases (vendor bills) which need to go on customer invoices.   This is
> fairly straight forward... the problem I'm having is how to deal with these
> when the currency I'm entering the voucher or bill in is not the same as
> the customer's invoice currency.
> 
> To use a concrete example, say I've got a $100 employee expense in CAD that
> gets marked as billable.  If I have a client whose default currency is USD,
> when the item is added it appears with the CAD value ($100) but is added up
> in the total at the bottom as if it's USD.
> 
> Is there a step I'm missing somewhere to get it to show up as a USD value
> in the invoice?

I believe you have just pushed the boundaries of what to do with invoices 
further than anyone ever could have imagined :)

I don't think anyone so far ever considered the case of having billable 
expenses in a different currency from the invoice currency. And from what you 
tell I gather it's currently not supported.

The currency logic is pretty simple: every amount you see in the invoice 
entries is assumed to be in the customer's default currency. They income 
account for each entry can be in a currency different from the invoice 
account. In that case a currency conversion will be applied when posting this 
amount to the income account. But as amounts for billable items come from the 
entries, they are assumed to be in the customer's currency.

This is a bug either way: or gnucash should prevent an entry from appearing as 
billable if it's original bill is not in the same currency as the invoice, or 
gnucash should support this and properly handle currency conversions.
The first solution will be far more easy to implement than the second though.

Can I ask you to file this as a bug report in bugzilla ? Refer to http://
wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker.

Thanks,

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] Loan & Insurance Rate

2018-11-06 Thread Antoine Michard
Hi,

Today, I'm going to make a car loan at my bank, and I would like to add
to my GnuCash account.So I ran Loan Wizard and follow it like my house loan...
But, I take death insurance and it's a percentage of my present value.
How can I add my Insurance amount in load wizard ??

Thx
(Sorry for my poor English)
--
Antoine Michard
GPG Key: 0xF5C9E7CD0882B381
___
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] Multiple currencies and business functions

2018-11-06 Thread Matthew Pounsett
I have cases with both billable employee expenses (vouchers) and billable
purchases (vendor bills) which need to go on customer invoices.   This is
fairly straight forward... the problem I'm having is how to deal with these
when the currency I'm entering the voucher or bill in is not the same as
the customer's invoice currency.

To use a concrete example, say I've got a $100 employee expense in CAD that
gets marked as billable.  If I have a client whose default currency is USD,
when the item is added it appears with the CAD value ($100) but is added up
in the total at the bottom as if it's USD.

Is there a step I'm missing somewhere to get it to show up as a USD value
in the invoice?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

2018-11-06 Thread Derek Atkins
btrib  writes:

> Is there a setting to save and make backups automatically? I've looked but
> cannot find.

Yes, turn on Autosave.  But it will only save if there are changes.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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 3.x corrupts data file

2018-11-06 Thread Derek Atkins
Jörg Schaible  writes:

> [snip]
>
> Yes. I don't know how gnucash managed to add this, but one of the used
> versions from 1.7.x to 2.7.4 in the
> last decade must have been able to do so ;-)

The 1.7.x and 2.7.x series are both Alpha-release (testing releases) and
should never be (have been?) used for real production data.

> Cheers,
> Jörg

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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] Fedora => Debian 3.2 => 2.1.15 Data Conversion Issues

2018-11-06 Thread Wolfram Wagner
Good morning,
I have analyzed this issue a bit more.

Seemingly, the flatpak image does not contain the german localizations.
When I start gnucash manually, I get the error, that the localization is broken 
and that it is falling back onto English. 

Until now I added:
(1) in /etc/... there is an environment file. I added a environment.local file 
and added LANG=de_DE.UTF-8 (Maybe this is not needed, if German is available as 
locale)

(2) I noticed that in the locale directory there is only one valid sub 
directory containing the english Texts. The other language dirs are links to 
non-existing places. I have deleted the dir link for German and copied a 
gnucash.mo file out of an RPM into a new created dir, hoping that the MO files 
are compatible. It did not work yet. I still get the same error message.

My plan for the next step is to try to remove the wrong directory links. Maybe 
they break the searching for available locales.

In case I am able to fix it, I will come back, report here and in the already 
existing issue in the ticket system for flatpak gnucash.

Thanks for your help!
Wolfram

> On 06 November 2018 at 02:43 "Frank H. Ellenberger" 
>  wrote:
> 
> 
> Hello Wolfram,
> 
> Am 05.11.18 um 22:02 schrieb Wolfram Wagner:
> > Hello Adrien,
> > 
> > Thanks for your help. I forgot flatpak at all.
> > 
> > As flatpak means (almost) no influence on the other packages, I try
> > this first. I installed it already, found that all my needed features
> > work (including banking data exchange). The only issue I see, is that
> > gnucash came up in an US american locale. I have changed all settings
> > to EUR, but found no way to enable the German translations.
> 
> Does
> https://wiki.gnucash.org/wiki/De/Konfiguration#Lokalisierung_.28Einstellung_der_Sprache.2C_W.C3.A4hrung.2C_Formate_29
> or
> https://wiki.gnucash.org/wiki/Locale_Settings
> help?
> 
> > I have to do half of my work in English, so this is not a big issue, as
> > long as there is no issue with the reports... I need to check further.
> > 
> > Thank you!
> > Wolfram
> 
> Regards
> Frank
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.