./finance/gnucash, Personal or business finance management program

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 3.2nb2, Package name: gnucash-3.2nb2, Maintainer: wiz

GnuCash is a personal finance manager. A check-book like register
GUI allows you to enter and track bank accounts, stocks, income
and even currency trades. A full set of reports allow you to see
the state of your finances. The interface is designed to be simple
and easy to use, but is backed with double-entry accounting principles
to ensure balanced books. Features include:
- An easy-to-use interface.
- Scheduled Transactions
- Mortgage & Loan Repayment Druid
- Small Business Accounting Features
- OFX and Quicken File Import and HBCI Support
- Reconcile window with running reconciled and cleared balances
- Stock/Mutual Fund Portfolios
- Get Stock & Mutual Fund quotes from various web sites
- Reports
- Multiple Currencies & Currency Trading, Multi-Currency Handling
- Chart of Accounts
- Split Transactions
- Double Entry
- General Ledger
- International date handling, many different translations.


Required to run:
[sysutils/desktop-file-utils] [textproc/libxml2] [textproc/libxslt] [textproc/icu] [finance/p5-Finance-Quote] [finance/libofx] [graphics/hicolor-icon-theme] [lang/perl5] [devel/glib2] [devel/boost-libs] [devel/py-readline] [devel/p5-Date-Manip] [x11/gtkmm] [www/webkit-gtk] [databases/libdbi] [graphics/gdk-pixbuf2] [devel/dconf] [x11/gtk3] [devel/swig2] [lang/guile22] [devel/guile22-slib] [lang/python37]

Required to build:
[pkgtools/x11-links] [devel/boost-headers] [devel/gperf] [x11/xcb-proto] [devel/googletest] [databases/libdbi-driver-sqlite3] [x11/fixesproto4] [pkgtools/cwrappers] [lang/gcc5] [x11/xorgproto]

Package options: libdbi, libofx, python

Master sites:

SHA1: 91a2dbed3e08026e6d2765851361d698e377e4d3
RMD160: 9cd51ace65afb30a65aabd28ffd32b0703161a46
Filesize: 13070.32 KB

Version history: (Expand)


CVS history: (Expand)


   2018-08-16 20:55:17 by Adam Ciarcinski | Files touched by this commit (653) | Package updated
Log message:
revbump after boost-libs update
   2018-07-20 05:34:33 by Ryo ONODERA | Files touched by this commit (705)
Log message:
Recursive revbump from textproc/icu-62.1
   2018-06-25 10:02:36 by Thomas Klausner | Files touched by this commit (3) | Package updated
Log message:
gnucash: update to 3.2.

Between 3.0 and 3.2, the following bugfixes were accomplished:

	• Bug 787401 - Test Report System - Report Definition.
	• Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to scm-gnome-utils.
	• Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the check \ 
boxes.
	• Bug 795247 - datepicker broken in Persian. GnuCash passes dates as integer \ 
y/m/d without using locale-specific formats, so we need to strip out 'E' and 'O' \ 
from the format when scanning dates or determining separators in gnc-date. None \ 
of '-', 'E', or 'O' are supported by boost (and '-' causes errors), so strip \ 
them out from formatters in gnc-datetime as well.
	• Bug 795253 - Have problems input Chinese.
	• Bug 795272 - QIF importer causes application crash if action is invalid.
	• Bug 795276 - Invalid date on price stops file from being parsed.
	• Bug 795362 - Special variable "i" not parsed in function calls. \ 
Due to balance tests with insane random values.
	• Bug 795471 - Impossible to Edit Budget Unless Maximized.
	• Bug 795519 - Credit card payment after reconciliation.
	• Bug 795666 - Backslash '\' in Description field spoils CSV Import without \ 
helpful error message.
	• Bug 795831 - When read only threshold set, dates are silently changed. \ 
Display a message box informing the user of the change.
	• Bug 795944 - Cannot store change to Business Suppliers data.
	• Bug 796079 - Repeatable Crash in Tax Report Options.
	• Bug 796081 - Tax Schedule Report - An error occurred while running the report.
	• Bug 796083 - Reconcile Selection Doesn't Work Anymore.
	• Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. Provide \ 
a backup recovery function that instead of dropping primaries and restoring \ 
backups merges the primaries and backups. This should handle a worst-case \ 
safe-save failure where the backup tables don't have a complete set of rows for \ 
some reason.
	• Bug 796256 - Main Window stays hidden when starting after closing main \ 
window while minimized.
	• Bug 796369 - Notes lost or perhaps just not displaying when using SQLite \ 
backend. This bug caused data loss if you saved your SQLite3 database to a \ 
different file or database. The problem is that in SQLite3 (though not in MySQL \ 
or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) (note the \ 
double parentheses) returns only the first guid in the subquery's results. Some \ 
transactions are loaded by special queries and those queries are also used to \ 
retrieve the transaction's slots so they weren't affected.
	• Bug 796398 - Restrict accelerator keys to valid date range.
	• Bug 796409 - Incorrect Current Value for Stocks. Missed calculating the \ 
value in the register summary bar.
	• Bug 796423 - Cannot Input Chinese, seems does not work with other IME too. \ 
Toggles not in view with all rows selected weren't being redrawn.
	• Bug 796484 - csv import: iostream error. Unfortunately it turns out that we \ 
can't use filestreams because they can't take path arguments containing Unicode \ 
on Windows.
	• Bug 796527 - invalid currency on scheduled transactions.
		• Don't even check for price/exchange rate on template transactions, there's \ 
no point.
		• Check all split commodities are valid, abort transaction creation if not.
		• If the template transaction's currency isn't used by any of the splits set \ 
the new transaction's currency to the first-found currency if there is one, \ 
otherwise to the first-found commodity.
	• Bug 796537 - Transaction Report cannot sort by "num".
	• Bug 796586 - QIF import incorrectly converts unicode characters from UTF8 \ 
encoded file.
	• Bug 796595 - QIF Import Select Account button to add a new account is \ 
labled gnc-account-new but should be New.
	• Bug 796600 - stock split cash-in-lieu income/asset labels backwards.
	• Bug 796614 - Reconciliation report contains incorrect transactions.
	• Bug 796638 - configuration not properly saved for CSV transactions import form.
The Following fixes and improvemts were not associated with bug reports:

	• Transaction report improvements:
		• Performance: Do all filtering ops before sorting.
		• Move the options summary before the subtotals table.
		• New unit tests
		• Enable computing averages in subtotal grid.
		• Generate the subtotal grid only if the primary sort key enables subtotals.
		• Fix subtotal grid to support multiple commodities.
		• New filters.
		• Much cleaning and refactoring of the internals.
	• Cache the num-split-action book option to avoid thousands of KVP queries \ 
for the same value when loading a register.
	• Create a static string for book option KVPs to save an extra malloc/free on \ 
old compilers without small-string optimization.
	• Add tooltip support for register cells.
	• New unit tests for the balance sheet report and invoices.
	• Consolidate charting code into a single module.
	• Removed an incomplete and abandoned C implementation of QIF import.
	• Restored libsecret support that had been left out of CMake.
	• Replace old-style html style attributes with css.
	• Modify emitted html to be parseable by the Guile SXML module for testing.
	• Remove support for long-gone gtkhtml renderer.
	• Clean up code generating html tables.
	• Ensure full precision of doubles is saved to SQL. std::iostream's \ 
operator<<(double) uses only 6 digits of precision by default.
	• Make float database operations more consistent, working around \ 
dbd-sqlite3's failure to support doubles (dbd-sqlite3, not sqlite3 itself).
	• Prevent crash in gnc-tree-view.c: When getting information from the state \ 
file, protect against the key not having a '_' which is used to split the \ 
string.
	• Add the full account name to the saved register settings If you need to \ 
delete the layout for a register in the settings file, the only thing \ 
identifying it is the account guid. To make it easier for humans, add the full \ 
account name also.
	• When register pages are restored it uses the full account name. When \ 
register pages are restored, the account is found from the full name so if the \ 
separator changes it will fail. Instead, also save the account guid and use that \ 
as default to find the account falling back to the full name.
	• Fix misplaced try block that caused unhandled exception if year out of range.
	• Fix permanent storage of vendor details: Since the data types did not match \ 
for the billterms and taxtable, those references/guids were not saved to the \ 
database.
	• Update invoice reports to use totals calculate by gncInvoice. This should \ 
give a consistent representation of invoice data across the application.
	• Ensure gncEntry rounding is consistent. Internally calculated values in the \ 
entry are never rounded. Consumers of gncEntry's calculated values can request \ 
them either rounded or not. Next use a pragmatical approach for calculating \ 
values on invoices based on the entry values: do the rounding such that we never \ 
create an unbalanced transaction while posting. That means:
		• round each entry's net value before summing them in net total
		• accumulate all tax totals on invoice level per tax account before rounding
and round before before summing them in a global tax total Hopefully this will \ 
catch a few more rounding issues in this area. A complete solution can only \ 
offered if we allow users to manually correct tax entries. This requires changes \ 
to user interface and data format so that's not going to happen in gnucash 3.x.
	• Use Scheme SRFI-64 test framework for new Scheme unit tests.
	• New compilers (gcc-8.0 and Xcode 9) bring new warnings, so several fixups \ 
to mollify them.
	• Lowercase all cmake commands for better readability.
	• Metadate migration (2.6.x->3.x) fixes for Windows.
	• Ensure timezone is set correctly in FreeBSD.
The following translations are updated: Dutch
   2018-04-30 08:06:07 by Thomas Klausner | Files touched by this commit (3) | Package updated
Log message:
gnucash: update to 3.1.

3.1    - 29 April 2018
The second release of the 3.0 stable series.

The following bugs have been fixed:
    Bug 118391 - Long currency names untranslated
    Bug 769686 - Notes not imported when using update and reconcile in
                 import transactions from CSV
    Bug 772776 - VERY large queries (over 11000 fields in IN clause) slow
                 down GnuCash
    Bug 782144 - git-master - Save Corrupts Data File / Not Open Data File
    Bug 792105 - Startup takes several minutes
    Bug 793461 - Transaction matcher window blank when importing QFX
    Bug 794767 - Dates default to 01/01/1970
    Bug 794916 - Fails to find environment file at startup when installation
                 prefix is '/opt'
    Bug 794936 - 3.0 does not open previously saved sqlite3 files properly
                 - corrupted business data
    Bug 794941 - Both print icons export to pdf
    Bug 794953 - Ellipsize on short tab labels
                 Correct error on when to ellipsize tab labels. Also as this
                 is used in two places separate out this to new function so
                 it is not duplicated.
    Bug 794990 - Double click does not work on saved reports
                 When you double click on the saved report description nothing
                 happens. This was down to a conflict on a couple of call
                 backs and one of them was incorrectly setup.
    Bug 794994 - Display Alphavantage key in full
                 Set the entry to expand so all the space is used to display.
    Bug 795031 - 3.0 Crashes on loading when opening 2.6.19 file
    Bug 795039 - Crash on startup using Technicolor Style sheet in report
    Bug 795040 - GnuCash crashes when searching for a newly created bill
    Bug 795049 - GnuCash 2.6.20-1 (Fedora Linux package) is unable to open
                 MariaDB.
    Bug 795064 - Enable subtotal-only if either sortkeys are dates
                 This will allow 'show subtotals only' if sortkeys are
                 date-types. This allows, for example, prime-sortkey=date,
                 yearly. sec-sortkey=date, monthly.
    Bug 795068 - src/optional/python-bindings missing several files
    Bug 795080 - Some dates reset to 01/01/1970
                 An odd corner case: BST apparently came off of DST at 23:00
                 26 Oct 2014, so midnight that day was ambiguous about being
                 DST or not; that causes the local_date_time constructor to
                 throw in spite of the tm.is_dst element being 0 (meaning pick
                 standard time). Instead of just failing in that case, try
                 constructing a local_date_time three hours later then adjust
                 it back three hours. If *that* doesn't work then throw a
                 std::invalid argument.
    Bug 795082 - CSV import crashes if a transaction's 'Account' field is
                 empty and no default Account set
    Bug 795101 - Scrollbar floats and covers toggle buttons
                 When the scrollbar appears for the reconcile windows it can
                 float above the reconcile toggle button which make it
                 difficult to toggle. Move this column to the start which has
                 the advantage of aligning the amount column above the Total
                 value.
    Bug 795142 - Unable to enter account codes in business sheets
                 In Bills, Invoices and Expense vouchers you can not enter an
                 account code in an account field like you can on a normal
                 register, enable this.
    Bug 795155 - CSV import does not distinguish between deposit and withdrawal
    Bug 795347 - Australian (GMT+10) OFX transactions imported have previous
                 days date
    Bug 795377 - Reads and saves Gnucash 2.6.19 XML file, then can't reread
                 it, due to bad date in old file
    Bug 795389 - Hard to see figures in the budget window
                 The budget view had hard coded black for normal values and
                 dark grey for other values. Changed this so normal values
                 are reset to default color and adjusted the grey based on
                 default color for theme.
    Bug 795405 - All Dates in Price Database Off-By-One After 3.0 Upgrade
    Bug 795446 - On Windows there is a blank tip of the day
                 When the tip_of_the_day.list is created a new line is
                 appended to the list file and on Windows this causes a blank
                 tip so remove the adding of the extra line.
    Bug 795471 - Budget window scrolls edited cell out of site
                  When editing cells that have been revealed on the right by
                  scrolling the window snaps back to the left hiding the cell
                  being edited. This may be due to an underlying gtk issue
                  but these changes fix the issue visually.

Other repairs or enhancements not marked as bugs:
    On Windows the tooltip for saved reports was incorrect
        When the mouse was placed over a saved report description on Windows an
        empty tooltip was displayed. Setup the query tooltip callback so it does
        not display a tooltip for description column.
    Fix crash when loading sql book with posted transactions
    Add ability to recognize and use a pre-compiled libgmock.so.
    html-font: add default font family
        Windows ships with GTK2 in which the default font styles are named
        "Sans" "Sans Bold" "Sans Normal" etc. \ 
There is no "Sans" font in
        Windows; I vote to add a default "Sans-Serif" font-family which is
        valid CSS. This ensures exported reports are shown as intended.
    Several improvements to the Transaction and GST reports.
    csv-impport - Allow empty amount fields
        Treat empty amount fields as 0. This is necessary for example in
        the case the csv import file has both a deposit and a withdrawal
        column.
    Remove the set transient parent setting for Reconcile window
        The Reconcile option is already a window so it is not necessary to set
        this value which allows the jump to transaction to work properly.
    Date Format dialog flashes up when file/properties used
        When you select the File/Properties dialog, in the construction of that
        a 'Date Format' dialog flashes up while the date component is moved to
        the properties dialog. Can mainly be seen on Windows so remove the
        visible setting in glade file.
    Prevent throw in gnc-pricedb.
        If a price lookup is given an invalid time64/timespec (i.e. INT64_MAX)
        then just return NULL instead of trying to find the nearest price.
    Set GNC_VCS at build time instead of when making the tarball.
        Because the tarball is always made from a VCS repo.
    If there are no prices in the db, critical errors are flagged
        When dialog transfer is used between two commodities and there are no
        prices in the db a critical error is logged. Test for price object
        being NULL before retrieving the price for the error message.

The following translations are updated: Slovak, Spanish

Known Problems:
    It is not possible to overwrite SQL Databases from within GnuCash, even
        though GnuCash will ask if you want to. Bug 789594
    Several dates, including Accounting Period, are subject to change with
        time zone and daylight-time changes. Bug 791825
    Some HBCI information is not loaded correctly so the first transaction
        download will re-retrieve transactions unless the beginning date is
        set explicitly. Bug 792397.
    The new CSV importer's Price of Shares column doesn't work. Bug 793306
    The new CSV importer's numeric parser can't parse numbers of the form
        x + y/z. Bug 793556.
    Python bindings may not work in some installations because the bindings
        are unable to find the backend modules (libgncmod-backend-dbi and
        libgncmod-backend-xml). Bug 794526
    Get Quotes can be slow if one has a large number of saved prices.
        Bug 794644.
    The Mac localization code can set the wrong encoding for strftime causing
        the register's date picker to label months "Null" in some locales.
        Bug 794807
    On Mac, the File Open dialog will crash if one types anything.
        (This is a Gtk+ bug). Bug 794809
    An open register is not immediately updated when the Since Last Run
        dialog creates transaction splits in the register's account. Bug 794854
    GnuCash asks if one wants to save changes when quitting or opening a file
        even if there's no book open. Bug 794870
    Windows Defender falsly identifies the GnuCash installer as a Trojan.
        Bug 794967
    Some Windows users have trouble using Chinese input methods on the
        Register; other controls work. Bug 795253
    On Microsoft Windows the Tab key does not work in the register if the
        caps-lock key is on. Bug 795294
    GnuCash will crash if one attempts to import a CSV file with more than
        1400 transactions. Bug 795383
    Invalid input into a formula (Debit/Credit) field is inconsistent
        depending on the input. Bug 795614.
   2018-04-29 23:32:09 by Adam Ciarcinski | Files touched by this commit (629) | Package updated
Log message:
revbump for boost-libs update
   2018-04-21 12:22:56 by Thomas Klausner | Files touched by this commit (1)
Log message:
gnucash: add TEST_TARGET

37% tests passed, 67 tests failed out of 107
   2018-04-16 16:35:28 by Thomas Klausner | Files touched by this commit (1284)
Log message:
Recursive bump for new fribidi dependency in pango.
   2018-04-14 09:34:46 by Adam Ciarcinski | Files touched by this commit (681) | Package updated
Log message:
revbump after icu update