Re: [GNC] importing csv multisplit multicurrency problems

[Gio Bacareza]

Adrien, results here
https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing

On Fri, Mar 6, 2020 at 3:05 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I might have misunderstood your earlier reply, but what if you leave off
> the Trading accounts from the import entirely and don’t have a price
> defined in the database? (that is, only 2 splits, not 4)
>
> What does GnuCash do then? I should think it should add the Trading
> account splits as exact based on the entered splits just as if you had done
> the transaction manually and enter the resulting exchange rate in the price
> db. But I could be mistaken. Perhaps that was one of the bugs Geert was
> referring to.
>
> Regards,
> Adrien
>
> > On Mar 5, 2020 w10d65, at 10:23 PM, Gio Bacareza 
> wrote:
> >
> > As mentioned I did some follow through tests with empty and pre-populated
> > currency price databases. Sharing it here:
> >
> > Conclusions:
> > When doing multi-currency csv imports, it works when the price database
> is
> > pre-populated with exchange rates consistent with exchange rates used in
> > the import.
> > The issue I have with this is that pre-populating the price DB is
> > cumbersome.
> > There has to be a better way.
> >
> > More details of test here
> >
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
>
>
> ___
> 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.
>


-- 
cheers,

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

Re: [GNC] How to use Budget ?

[Adrien Monteleone]

I’m not quite following you on how you think GnuCash is telling you that you 
are overspending.

The way the budget module works, you input how much you budget to receive in a 
period.

You then budget how much you are going to spend on various expenses, as well as 
transfers, if any. (transfers would be ’to’ savings or ‘paying off’ liabilities)

The more recent version (3.8) made this more difficult by removing the ’total’ 
line from the bottom summary. This has been fixed in the development version 
and should be available when 3.9 is released in a few weeks. The result will be 
that you see how much of the budgeted revenue has not been budgeted to be spent 
or transferred to other assets or paying down liabilities. (or seeing that you 
have ‘over-budgeted’ outflows)

If you have built up a savings from a previous period and budget some of that 
to be spent you should not be seeing an ‘overspending’ condition. If you are, 
then that might be a bug in the current way the summary is calculated.

For example, if in January you budgeted:

Revenue: 1000
Savings: 200
Expenses: 700
Liabilities: 100

That would ’net’ to zero, all revenue has been allocated - so far - so good.

Then in February you budgeted:

Revenue: 1000
Savings: -200
Expenses: 1100
Liabilities: 100

That should still net to zero. You’ve used 200 from savings to make up for the 
lack of revenue to cover expenses and liability payments.

If the budget module is *not* showing this, then you’ve found a bug. Please 
report it soon so it can be fixed in time for 3.9.

Regards,
Adrien

> On Mar 5, 2020 w10d65, at 10:38 PM, Long  wrote:
> 
> Hello,
> 
> i want to planning my finances follow 50/30/20 style. Because i don't want
> to budgeting for each accounts which i never know will i buy it for that
> month, that take so much things to do.
> 
> But when i do that, i will have some trouble.
> i assume that, every month i will spend about 1000, and i had budgeting my
> expense for 1000 and saving to buy something if i want, And When i spent, i
> open Budget Report, I will overspending because GnuCash Budget always add
> All my actual to the Top Level Expense.
> This is weird, i don't overspending, Because i'm only used 1000 for that
> month like i planned, i just use my saving (budgeted) to buy what i need, i
> don't overspending because I'm not used over 1000 for that month.
> 
> Please help me, tell me if i misunderstanding something.
> 
> Thank for take your time to help me and sorry for my bad English.

___
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] The Tutorial and Concepts Guide

[Adrien Monteleone]

It seems those are placeholders for sections. Perhaps they should not have been 
listed in the TOC. I’m not sure what ‘discussion’ means, but my guess would be 
there is a working bug report on the topic or specific list threads the 
documentation will be derived from.

But to the issue at hand, the Importing sections (not Appendices) should get 
you going.

If you can get your data in QIF, you should be okay, but that is not optimal. 
(that format has issues, especially with duplication)

I think from what I’ve been following in other import discussions, CSV has more 
versatility and is easier to work with and manipulate if needed prior to 
importing.

What can Reckon export?

Regards,
Adrien

> On Mar 5, 2020 w10d65, at 10:35 PM, Rick Squires  
> wrote:
> 
> Hello,
> 
> 
> 
> I'm just starting with GnuCash and want to migrate from Reckon Accounts
> Personal Plus 2019 Release R 1.
> 
> 
> 
> In the Tutorial and Concepts Guide there is a section called Appendix A.
> Migration Guide.
> 
> The ones I am particularly interested in are:
> 
> A.2. Organization of QIF Files (Discussion)
> 
> A.3. Common Duplication Issues (Discussion)
> 
> A.4. Checking QIF Data (Discussion)
> 
> 
> 
> When I try to read each of these discussions the heading loads but the page
> is blank. Am I doing something wrong? I can read the rest of the
> documentation OK.
> 
> 
> 
> Before I move from Reckon I would really like to ensure that I can transfer
> all my data accurately.
> 
> 
> 
> Suggestions for alternative reading would be appreciated.

___
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] importing csv multisplit multicurrency problems

[Adrien Monteleone]

I might have misunderstood your earlier reply, but what if you leave off the 
Trading accounts from the import entirely and don’t have a price defined in the 
database? (that is, only 2 splits, not 4)

What does GnuCash do then? I should think it should add the Trading account 
splits as exact based on the entered splits just as if you had done the 
transaction manually and enter the resulting exchange rate in the price db. But 
I could be mistaken. Perhaps that was one of the bugs Geert was referring to.

Regards,
Adrien

> On Mar 5, 2020 w10d65, at 10:23 PM, Gio Bacareza  wrote:
> 
> As mentioned I did some follow through tests with empty and pre-populated
> currency price databases. Sharing it here:
> 
> Conclusions:
> When doing multi-currency csv imports, it works when the price database is
> pre-populated with exchange rates consistent with exchange rates used in
> the import.
> The issue I have with this is that pre-populating the price DB is
> cumbersome.
> There has to be a better way.
> 
> More details of test here
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing


___
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] importing csv multisplit multicurrency problems

[pobox . deva]

Gio,

If you are using the 3.x series, there’s a convenient CSV price importer that 
works well. You can even save the CSV price file template for future use, so 
you’d have to set it up only once.

That should alleviate a lot of burden in entering prices in price database 
manually.

Cheers.

> On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 6 Mar 2020 12:23:17 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] importing csv multisplit multicurrency problems
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> As mentioned I did some follow through tests with empty and pre-populated
> currency price databases. Sharing it here:
> 
> Conclusions:
> When doing multi-currency csv imports, it works when the price database is
> pre-populated with exchange rates consistent with exchange rates used in
> the import.
> The issue I have with this is that pre-populating the price DB is
> cumbersome.
> There has to be a better way.
> 
> More details of test here
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
>  
> 
___
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] How to use Budget ?

[Long]

Hello,

i want to planning my finances follow 50/30/20 style. Because i don't want
to budgeting for each accounts which i never know will i buy it for that
month, that take so much things to do.

But when i do that, i will have some trouble.
i assume that, every month i will spend about 1000, and i had budgeting my
expense for 1000 and saving to buy something if i want, And When i spent, i
open Budget Report, I will overspending because GnuCash Budget always add
All my actual to the Top Level Expense.
This is weird, i don't overspending, Because i'm only used 1000 for that
month like i planned, i just use my saving (budgeted) to buy what i need, i
don't overspending because I'm not used over 1000 for that month.

Please help me, tell me if i misunderstanding something.

Thank for take your time to help me and sorry for my bad English. 



--
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] The Tutorial and Concepts Guide

[Rick Squires]

Hello,

 

I'm just starting with GnuCash and want to migrate from Reckon Accounts
Personal Plus 2019 Release R 1.

 

In the Tutorial and Concepts Guide there is a section called Appendix A.
Migration Guide.

The ones I am particularly interested in are:

A.2. Organization of QIF Files (Discussion)

A.3. Common Duplication Issues (Discussion)

A.4. Checking QIF Data (Discussion)

 

When I try to read each of these discussions the heading loads but the page
is blank. Am I doing something wrong? I can read the rest of the
documentation OK.

 

Before I move from Reckon I would really like to ensure that I can transfer
all my data accurately.

 

Suggestions for alternative reading would be appreciated.

 

Cheers, Rick

 

 

 

___
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] importing csv multisplit multicurrency problems

[Gio Bacareza]

As mentioned I did some follow through tests with empty and pre-populated
currency price databases. Sharing it here:

Conclusions:
When doing multi-currency csv imports, it works when the price database is
pre-populated with exchange rates consistent with exchange rates used in
the import.
The issue I have with this is that pre-populating the price DB is
cumbersome.
There has to be a better way.

More details of test here
https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing

On Fri, Mar 6, 2020 at 11:48 AM Gio Bacareza  wrote:

> Thank you Adrien. Inspired by your answers I did a few more tests.
> 1. I got rid of the lines with the trading accounts assuming from past
> behavior that gnucash will autopopulate with trading currency accounts
> based on price database:
> Date Description Account Deposit Withdrawal
> 3/6/2020 Description test_foreign 200
> test_local 10013
>
> it was a success! gnucash added trading currency accounts automatically
> and there was no imbalance line.
>
> 2. So I applied it to the actual transaction data using the same method.
> FAILED. gnucash added the imbalances again :(
>
> 3. So I changed the price database for USD then made it all the same
> value. Then I deleted and re-created the account. Then I reimported the
> transactions.
> SUCCESS!!!
>
> So conclusion: As long as price is consistent, you can import
> multi-currency transactions using multiplit with 1 side currency 1 and the
> other side converted currency 2.
>
> i'll do some test with a blank price database and let everyone know.
>
>
> On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>>
>>
>> > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza 
>> wrote:
>> >
>> > I'm encountering problems with importing transactions in csv when
>> accounts
>> > have different currencies.
>> >
>> > I've been reading the debates. So this is not about definitions of
>> > multi-split or terminology.
>> >
>> > I did a test with a sample csv with the following contents:
>> >
>> > Date,Description,Account,Deposit,Withdrawal
>> > 1/3/2019,Description,test_foreign,,200
>> > ,,Trading:CURRENCY:PHP,,10013
>> > ,,Trading:CURRENCY:USD,200,
>> > ,,test_local,10013,
>> >
>> > gnucash imported successfully but it created an extra line
>> Imbalance-USD.
>> > See results below:
>> > Date   Description   Account   Deposit   Withdrawal
>> > 1/3/2019   Description 200
>> >  Trading:CURRENCY:USD   197.78
>> >  test_local   10013
>> >  Imbalance-USD   2.22
>> >  test_foreign 200
>> >  Trading:CURRENCY:PHP  10013
>> >
>> > 1. Why does it do that when imported transactions is already balanced in
>> > the first place?
>>
>> Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in
>> the database that is conflicting and GnuCash is trying to use that rather
>> than set a new price based on the transaction. (I’m not intimately familiar
>> with multi-currency import)
>>
>> See below about manual entries, as I’d suspect either some step is
>> missing for the import, or there is a bug.
>>
>> > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
>> > allow me. It keeps the imbalance no matter what I do.
>>
>> I’m not certain if this will work with editing an existing imported
>> transaction, but doing a manual version of your test I was able to get it
>> to behave properly.
>>
>> > 3. How do I solve this?
>>
>> I entered these splits first: (Dr/Cr. reversed for my book which is in
>> USD)
>>
>> Dr. test_local 200
>> Cr. test_foreign 10013
>>
>> When I tabbed off the last one, the exchange rate dialog popped up. It
>> defaulted to having me enter or fetch the rate, instead I chose Debit
>> Amount (credit in your case) and entered the amount in the test_local
>> account that I wanted to debit and committed the dialog.
>>
>> This created 2 more splits in their respective trading accounts that were
>> exact @ 200 and 10013 respectively as they should be.
>>
>> Your post reminded me of an issue I had a few months ago that I couldn’t
>> get rid of a similar Imbalance split involving trading accounts. I solved
>> it by switching to using the debit/credit amount field instead of the
>> exchange rate field. This makes sense because if you know the exact
>> amounts, you are defining a new price, you don’t need to fetch or employ an
>> existing one. I find that fetching or using price db figures are good for
>> current-value reports of my foreign currency and commodity assets. They
>> aren’t as useful (to me) for transaction entry.
>>
>> 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.

Re: [GNC] importing csv multisplit multicurrency problems

[Gio Bacareza]

Hi Geert, thanks for the feedback.

Questions:
Is it advisable then to convert csvs to another format?
What is the preferred format for multicurency imports?
Any other tips on doing multicurrency imports?

Thanks!

On Fri, Mar 6, 2020 at 1:01 AM Geert Janssens 
wrote:

> There are several bugs with multi-currency csv imports. I don't think it's
> currently possible to do such imports. Sorry.
>
> Geert
>
> Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> > I'm encountering problems with importing transactions in csv when
> accounts
> > have different currencies.
> >
> > I've been reading the debates. So this is not about definitions of
> > multi-split or terminology.
> >
> > I did a test with a sample csv with the following contents:
> >
> > Date,Description,Account,Deposit,Withdrawal
> > 1/3/2019,Description,test_foreign,,200
> > ,,Trading:CURRENCY:PHP,,10013
> > ,,Trading:CURRENCY:USD,200,
> > ,,test_local,10013,
> >
> > gnucash imported successfully but it created an extra line Imbalance-USD.
> > See results below:
> > Date   Description   Account   Deposit   Withdrawal
> > 1/3/2019   Description 200
> >   Trading:CURRENCY:USD   197.78
> >   test_local   10013
> >   Imbalance-USD   2.22
> >   test_foreign 200
> >   Trading:CURRENCY:PHP  10013
> >
> > 1. Why does it do that when imported transactions is already balanced in
> > the first place?
> > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> > allow me. It keeps the imbalance no matter what I do.
> > 3. How do I solve this?
> >
> > Thanks,
> >
> > gio
>
>
>
>
>

-- 
cheers,

Gio
___
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] importing csv multisplit multicurrency problems

[Gio Bacareza]

Thank you Adrien. Inspired by your answers I did a few more tests.
1. I got rid of the lines with the trading accounts assuming from past
behavior that gnucash will autopopulate with trading currency accounts
based on price database:
Date Description Account Deposit Withdrawal
3/6/2020 Description test_foreign 200
test_local 10013

it was a success! gnucash added trading currency accounts automatically and
there was no imbalance line.

2. So I applied it to the actual transaction data using the same method.
FAILED. gnucash added the imbalances again :(

3. So I changed the price database for USD then made it all the same value.
Then I deleted and re-created the account. Then I reimported the
transactions.
SUCCESS!!!

So conclusion: As long as price is consistent, you can import
multi-currency transactions using multiplit with 1 side currency 1 and the
other side converted currency 2.

i'll do some test with a blank price database and let everyone know.


On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

>
>
> > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza 
> wrote:
> >
> > I'm encountering problems with importing transactions in csv when
> accounts
> > have different currencies.
> >
> > I've been reading the debates. So this is not about definitions of
> > multi-split or terminology.
> >
> > I did a test with a sample csv with the following contents:
> >
> > Date,Description,Account,Deposit,Withdrawal
> > 1/3/2019,Description,test_foreign,,200
> > ,,Trading:CURRENCY:PHP,,10013
> > ,,Trading:CURRENCY:USD,200,
> > ,,test_local,10013,
> >
> > gnucash imported successfully but it created an extra line Imbalance-USD.
> > See results below:
> > Date   Description   Account   Deposit   Withdrawal
> > 1/3/2019   Description 200
> >  Trading:CURRENCY:USD   197.78
> >  test_local   10013
> >  Imbalance-USD   2.22
> >  test_foreign 200
> >  Trading:CURRENCY:PHP  10013
> >
> > 1. Why does it do that when imported transactions is already balanced in
> > the first place?
>
> Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in
> the database that is conflicting and GnuCash is trying to use that rather
> than set a new price based on the transaction. (I’m not intimately familiar
> with multi-currency import)
>
> See below about manual entries, as I’d suspect either some step is missing
> for the import, or there is a bug.
>
> > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> > allow me. It keeps the imbalance no matter what I do.
>
> I’m not certain if this will work with editing an existing imported
> transaction, but doing a manual version of your test I was able to get it
> to behave properly.
>
> > 3. How do I solve this?
>
> I entered these splits first: (Dr/Cr. reversed for my book which is in USD)
>
> Dr. test_local 200
> Cr. test_foreign 10013
>
> When I tabbed off the last one, the exchange rate dialog popped up. It
> defaulted to having me enter or fetch the rate, instead I chose Debit
> Amount (credit in your case) and entered the amount in the test_local
> account that I wanted to debit and committed the dialog.
>
> This created 2 more splits in their respective trading accounts that were
> exact @ 200 and 10013 respectively as they should be.
>
> Your post reminded me of an issue I had a few months ago that I couldn’t
> get rid of a similar Imbalance split involving trading accounts. I solved
> it by switching to using the debit/credit amount field instead of the
> exchange rate field. This makes sense because if you know the exact
> amounts, you are defining a new price, you don’t need to fetch or employ an
> existing one. I find that fetching or using price db figures are good for
> current-value reports of my foreign currency and commodity assets. They
> aren’t as useful (to me) for transaction entry.
>
> 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.
>


-- 
cheers,

Gio
___
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] Invoice Date

[Nith Valley Organics]

And just one other thing.  If you’ve already posted it and want to change 
anything - including the posting date - you do need to unpost it first.

> On Mar 5, 2020, at 7:18 PM, Adrien Monteleone 
>  wrote:
> 
> Printing is a different matter.
> 
> With v3.8 the default stylesheet allows for 4 places to print a date. It 
> seems one of them is not controllable.
> 
> In the Display tab, you can opt to show the Date Due. (set when posting)
> 
> In the Display Columns tab, you can opt to show dates on individual line 
> items. (set when entering the line items)
> 
> In the Layout Tab, you can set one of the header blocks to show Today’s Date. 
> (taken from the system date) This one does not have any label on the invoice 
> for it. It just shows today’s date.
> 
> There is also simply ‘Date’ at the top of the invoice - this is the posting 
> date - which you *can* control, as I noted when posting, but you can’t not 
> display it on the printed copy. (maybe with CSS, but not by an included 
> option)
> 
> If none of that is working for you, what version of GnuCash and OS?
> 
> Regards,
> Adrien
> 
>> On Mar 5, 2020 w10d65, at 4:03 PM, Robert Vander Pyl  
>> wrote:
>> 
>> It doesn’t seem to matter what I set as the opening date, IE today is March 
>> 5th, I am doing billing until the end of Feb, so I entered Feb 29 as my 
>> opening date.  But when I print the invoice it has a date of March 05. I 
>> have to set the workstation date of Feb 29 to get that date on 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.

___
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] Invoice Date

[Adrien Monteleone]

Printing is a different matter.

With v3.8 the default stylesheet allows for 4 places to print a date. It seems 
one of them is not controllable.

In the Display tab, you can opt to show the Date Due. (set when posting)

In the Display Columns tab, you can opt to show dates on individual line items. 
(set when entering the line items)

In the Layout Tab, you can set one of the header blocks to show Today’s Date. 
(taken from the system date) This one does not have any label on the invoice 
for it. It just shows today’s date.

There is also simply ‘Date’ at the top of the invoice - this is the posting 
date - which you *can* control, as I noted when posting, but you can’t not 
display it on the printed copy. (maybe with CSS, but not by an included option)

If none of that is working for you, what version of GnuCash and OS?

Regards,
Adrien

> On Mar 5, 2020 w10d65, at 4:03 PM, Robert Vander Pyl  
> wrote:
> 
> It doesn’t seem to matter what I set as the opening date, IE today is March 
> 5th, I am doing billing until the end of Feb, so I entered Feb 29 as my 
> opening date.  But when I print the invoice it has a date of March 05. I have 
> to set the workstation date of Feb 29 to get that date on 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] Invoice Date

[Robert Vander Pyl]

It doesn’t seem to matter what I set as the opening date, IE today is March 
5th, I am doing billing until the end of Feb, so I entered Feb 29 as my opening 
date.  But when I print the invoice it has a date of March 05. I have to set 
the workstation date of Feb 29 to get that date on the invoice.

Robert Vander Pyl
Sent from my iPad Air, please excuse any spelling mistakes.

> On Mar 5, 2020, at 1:59 PM, Adrien Monteleone 
>  wrote:
> 
> When you click New Invoice the pop-up window contains a ‘Date Opened’ field 
> that you can set. (the default is ’today’)
> 
> The individual line items can be set independently, but that is just for 
> reference, those dates have no bearing on when those line items hit your 
> books.
> 
> When you post an invoice, you get to set another date, again, either 
> defaulting to ’today’ or you can change it. All line items will post as of 
> this date. (if you check the box to ‘accumulate splits’ you won’t see the 
> line item detail in the relevant accounts, but if you don’t check the box, 
> all line items will show in the transactions in the relevant registers)
> 
> You also get to set a due date, but if you’ve chosen defined terms, it will 
> be calculated for you and you can’t edit it. Simply don’t use terms in the 
> posting window (or when you create the invoice) and you’ll be able to set a 
> custom due date.
> 
> Regards,
> Adrien
> 
>> On Mar 5, 2020 w10d65, at 3:52 PM, Robert Vander Pyl  
>> wrote:
>> 
>> It appears that it is not possible to specify an invoice date, it always 
>> uses the current date of the workstation.  Is this something that could be 
>> added as an option when setting up 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.
___
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] Invoice Date

[Adrien Monteleone]

I forgot to mention, if you didn’t notice the ‘date opened’ field in the 
pop-up, and you are already in the invoice, click the Edit Invoice button to 
change it. The date cannot be changed from the invoice viewing screen. (this is 
a known bug)

Regards,
Adrien

> On Mar 5, 2020 w10d65, at 3:59 PM, Adrien Monteleone 
>  wrote:
> 
> When you click New Invoice the pop-up window contains a ‘Date Opened’ field 
> that you can set. (the default is ’today’)
> 
> The individual line items can be set independently, but that is just for 
> reference, those dates have no bearing on when those line items hit your 
> books.
> 
> When you post an invoice, you get to set another date, again, either 
> defaulting to ’today’ or you can change it. All line items will post as of 
> this date. (if you check the box to ‘accumulate splits’ you won’t see the 
> line item detail in the relevant accounts, but if you don’t check the box, 
> all line items will show in the transactions in the relevant registers)
> 
> You also get to set a due date, but if you’ve chosen defined terms, it will 
> be calculated for you and you can’t edit it. Simply don’t use terms in the 
> posting window (or when you create the invoice) and you’ll be able to set a 
> custom due date.
> 
> Regards,
> Adrien
> 
>> On Mar 5, 2020 w10d65, at 3:52 PM, Robert Vander Pyl  
>> wrote:
>> 
>> It appears that it is not possible to specify an invoice date, it always 
>> uses the current date of the workstation.  Is this something that could be 
>> added as an option when setting up 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] Invoice Date

[Adrien Monteleone]

When you click New Invoice the pop-up window contains a ‘Date Opened’ field 
that you can set. (the default is ’today’)

The individual line items can be set independently, but that is just for 
reference, those dates have no bearing on when those line items hit your books.

When you post an invoice, you get to set another date, again, either defaulting 
to ’today’ or you can change it. All line items will post as of this date. (if 
you check the box to ‘accumulate splits’ you won’t see the line item detail in 
the relevant accounts, but if you don’t check the box, all line items will show 
in the transactions in the relevant registers)

You also get to set a due date, but if you’ve chosen defined terms, it will be 
calculated for you and you can’t edit it. Simply don’t use terms in the posting 
window (or when you create the invoice) and you’ll be able to set a custom due 
date.

Regards,
Adrien

> On Mar 5, 2020 w10d65, at 3:52 PM, Robert Vander Pyl  
> wrote:
> 
> It appears that it is not possible to specify an invoice date, it always uses 
> the current date of the workstation.  Is this something that could be added 
> as an option when setting up 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.

[GNC] Invoice Date

[Robert Vander Pyl]

It appears that it is not possible to specify an invoice date, it always uses 
the current date of the workstation.  Is this something that could be added as 
an option when setting up the invoice?

Robert Vander Pyl
Sent from my iPad Air, please excuse any spelling mistakes.
___
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] Transactions association to accounts (automatically)

[Stelvio Rosset]

Hi Greg and all, thanks for your comment, your "do a lot of manual
processing" gave me a kind push to review completely the way I am importing
the transactions.

Now I just export CSV files out of the bank account (or export XLS and
convert into CSV) monthly, and I leave to GNU CASH the job to import into
based on the Import Settings saved for each account (bank or card). With the
help of a spreadsheet table, I record the import done in order to avoid
duplicates.

I guess this is the way to receive reasonable help by the Bayesian method.

Thanks
Stelvio
 



--
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] importing csv multisplit multicurrency problems

[Geert Janssens]

There are several bugs with multi-currency csv imports. I don't think it's 
currently possible to do such imports. Sorry.

Geert

Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> I'm encountering problems with importing transactions in csv when accounts
> have different currencies.
> 
> I've been reading the debates. So this is not about definitions of
> multi-split or terminology.
> 
> I did a test with a sample csv with the following contents:
> 
> Date,Description,Account,Deposit,Withdrawal
> 1/3/2019,Description,test_foreign,,200
> ,,Trading:CURRENCY:PHP,,10013
> ,,Trading:CURRENCY:USD,200,
> ,,test_local,10013,
> 
> gnucash imported successfully but it created an extra line Imbalance-USD.
> See results below:
> Date   Description   Account   Deposit   Withdrawal
> 1/3/2019   Description 200
>   Trading:CURRENCY:USD   197.78
>   test_local   10013
>   Imbalance-USD   2.22
>   test_foreign 200
>   Trading:CURRENCY:PHP  10013
> 
> 1. Why does it do that when imported transactions is already balanced in
> the first place?
> 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> allow me. It keeps the imbalance no matter what I do.
> 3. How do I solve this?
> 
> Thanks,
> 
> gio




___
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] importing csv multisplit multicurrency problems

[Adrien Monteleone]

> On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza  wrote:
> 
> I'm encountering problems with importing transactions in csv when accounts
> have different currencies.
> 
> I've been reading the debates. So this is not about definitions of
> multi-split or terminology.
> 
> I did a test with a sample csv with the following contents:
> 
> Date,Description,Account,Deposit,Withdrawal
> 1/3/2019,Description,test_foreign,,200
> ,,Trading:CURRENCY:PHP,,10013
> ,,Trading:CURRENCY:USD,200,
> ,,test_local,10013,
> 
> gnucash imported successfully but it created an extra line Imbalance-USD.
> See results below:
> Date   Description   Account   Deposit   Withdrawal
> 1/3/2019   Description 200
>  Trading:CURRENCY:USD   197.78
>  test_local   10013
>  Imbalance-USD   2.22
>  test_foreign 200
>  Trading:CURRENCY:PHP  10013
> 
> 1. Why does it do that when imported transactions is already balanced in
> the first place?

Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in the 
database that is conflicting and GnuCash is trying to use that rather than set 
a new price based on the transaction. (I’m not intimately familiar with 
multi-currency import)

See below about manual entries, as I’d suspect either some step is missing for 
the import, or there is a bug.

> 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> allow me. It keeps the imbalance no matter what I do.

I’m not certain if this will work with editing an existing imported 
transaction, but doing a manual version of your test I was able to get it to 
behave properly.

> 3. How do I solve this?

I entered these splits first: (Dr/Cr. reversed for my book which is in USD)

Dr. test_local 200
Cr. test_foreign 10013

When I tabbed off the last one, the exchange rate dialog popped up. It 
defaulted to having me enter or fetch the rate, instead I chose Debit Amount 
(credit in your case) and entered the amount in the test_local account that I 
wanted to debit and committed the dialog.

This created 2 more splits in their respective trading accounts that were exact 
@ 200 and 10013 respectively as they should be.

Your post reminded me of an issue I had a few months ago that I couldn’t get 
rid of a similar Imbalance split involving trading accounts. I solved it by 
switching to using the debit/credit amount field instead of the exchange rate 
field. This makes sense because if you know the exact amounts, you are defining 
a new price, you don’t need to fetch or employ an existing one. I find that 
fetching or using price db figures are good for current-value reports of my 
foreign currency and commodity assets. They aren’t as useful (to me) for 
transaction entry.

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] GC 2.6.19 & GC 3.8

[Les]

Thanks for the update Tommy.

On 3/4/20 5:52 PM, Tommy Trussell wrote:
On Wed, Mar 4, 2020 at 4:20 PM Les > wrote:


After using the 3.8 version on Linux Mint 19.1, I find that is much
faster than the 2.6.19 version.  I have one issue regarding the
accounts
page, I entered an incorrect amount for a payment and then tried to
remove it (even deleting the line) but nothing worked.  I finally
closed
GC without saving and reopened it and entered the correct information.

Is this a known bug?


I have noticed this, too; I believe it's a screen refresh issue. I'm 
trying to replicate it on Ubuntu 19.10 and cannot, so I think it's an 
issue with a build based upon Ubuntu 18.04 LTS (which your Mint 
probably is). That's the version I use in my office.


Here's what I have noticed -- I click on a transaction and choose 
Delete from the toolbar. A confirmation dialog pops up, and I agree 
that I want to delete, but the transaction does not disappear from the 
register. HOWEVER if I close and reopen the register, (or maybe if I 
choose View --> Refresh ?) the transaction is gone.


I have noticed a few other display issues with GnuCash built for 
Ubuntu 18.04. The register colors are strange around the text, 
especially noticeably on the date field.


Unfortunately I also noticed that the spacing of items on the register 
changed slightly when I installed the GTK Inspector (as was discussed 
on this list a few days ago in reference to CSS issues). I say 
"unfortunately" because I believe it was the act of installing the 
libraries and other components of the development tools that subtly 
changed the way the application appears, which I presume might make it 
harder to fix.


I glanced through the bug reports in bugzilla and didn't see one but 
maybe I missed it.


-
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] importing csv multisplit multicurrency problems

[Gio Bacareza]

I'm encountering problems with importing transactions in csv when accounts
have different currencies.

I've been reading the debates. So this is not about definitions of
multi-split or terminology.

I did a test with a sample csv with the following contents:

Date,Description,Account,Deposit,Withdrawal
1/3/2019,Description,test_foreign,,200
,,Trading:CURRENCY:PHP,,10013
,,Trading:CURRENCY:USD,200,
,,test_local,10013,

gnucash imported successfully but it created an extra line Imbalance-USD.
See results below:
Date   Description   Account   Deposit   Withdrawal
1/3/2019   Description 200
  Trading:CURRENCY:USD   197.78
  test_local   10013
  Imbalance-USD   2.22
  test_foreign 200
  Trading:CURRENCY:PHP  10013

1. Why does it do that when imported transactions is already balanced in
the first place?
2. When I try to manually correct in gnucash (197.78->200), it wouldn't
allow me. It keeps the imbalance no matter what I do.
3. How do I solve this?

Thanks,

gio

-- 
cheers,

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