Re: [GNC] importing csv multisplit multicurrency problems

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

Re: [GNC] How to use Budget ?

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

Re: [GNC] The Tutorial and Concepts Guide

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,

Re: [GNC] importing csv multisplit multicurrency problems

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

Re: [GNC] importing csv multisplit multicurrency problems

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

[GNC] How to use Budget ?

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

[GNC] The Tutorial and Concepts Guide

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

Re: [GNC] importing csv multisplit multicurrency problems

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

Re: [GNC] importing csv multisplit multicurrency problems

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

Re: [GNC] importing csv multisplit multicurrency problems

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

Re: [GNC] Invoice Date

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

Re: [GNC] Invoice Date

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

Re: [GNC] Invoice Date

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

Re: [GNC] Invoice Date

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

Re: [GNC] Invoice Date

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

[GNC] Invoice Date

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.

Re: [GNC] Transactions association to accounts (automatically)

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

Re: [GNC] importing csv multisplit multicurrency problems

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

Re: [GNC] importing csv multisplit multicurrency problems

> 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

Re: [GNC] GC 2.6.19 & GC 3.8

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

[GNC] importing csv multisplit multicurrency problems

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: