Re: [GNC] 3.7 - Budget reports - accumulated accounts - can "envelope budgeting" logic be implemented?
This is a nice idea. Please file enhancement request on bugzilla (component Reports), attaching a sample datafile, current report, and desired report. For various reasons this would appear in 4.x onwards only. C On Fri, 4 Oct 2019 at 09:43, Antonio07 wrote: > Hi > > In version 3.7 accumulated accounts option was introduced in Budget reports > > However by using it I have found that logic is that Budget and Actual - > simply summing all "period" amount > > For Example: > 1. I have 24 month budget > 2. For each month I budgeted 320$ in category 'Food' > - now I'm in October - it's 22nd month of my Budget > - if I use accumulated amount it shows that I have budget for October > 7040$ for 'Food' (but in reality I have only 320$) > > 3. Each month I have spent from 300 to 330 as actuals and now have > accumulated Actuals for October - 6500$ > 4. So accumulated difference 540$ > > Can it be change report format to show "Rolling" accumulated amounts? > > > For Example > > 1. Period 21 - we have budgeted for 'Food' +320$ > 2. Period 21 - we have actuals for 'Food' -300$ > 3. Period 21 - We have difference for 'Food' +20$ (positive) > > 4. Period 22 - we have budgeted for 'Food' +300$ > 5. Period 22 - we have actuals for 'Food' -100$ (so far) > 6. Period 22 - we have difference = (Difference amount from period 21 > '+20$' ) + (Budgeted amount from period 22 '+300$') - (Actuals from period > 22 '-100$') = 20$ + 300$ - 100$ = 220$ > > > By using we can avoid confusing end-user with huge accumulated numbers - > and > also keep concept if accumulating budget for some Big Goal - like budget > 100$ every month for 1200$ vacation in the end of the year > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash 3.7 and Portfolio Report
Hello John. I'm on ver 3.7, Flatpak, Linux Mint 18.3 My file : portfolio.scm is different. There is no "report-currency" to change into "currency" at line 199 or anywhere else in the file. * portfolio.scm :* (define-module (gnucash report standard-reports portfolio)) (use-modules (gnucash main)) ;; FIXME: delete after we finish modularizing. (use-modules (srfi srfi-1)) (use-modules (gnucash gnc-module)) (use-modules (gnucash gettext)) (use-modules (gnucash printf)) (gnc:module-load "gnucash/report/report-system" 0) (define reportname (N_ "Investment Portfolio")) (define optname-price-source (N_ "Price Source")) (define optname-shares-digits (N_ "Share decimal places")) (define optname-zero-shares (N_ "Include accounts with no shares")) (define (options-generator) (let* ((options (gnc:new-options)) ;; This is just a helper function for making options. ;; See gnucash/src/scm/options.scm for details. (add-option (lambda (new-option) (gnc:register-option options new-option ;; General Tab ;; date at which to report balance (gnc:options-add-report-date! options gnc:pagename-general (N_ "Date") "a") (gnc:options-add-currency! options gnc:pagename-general (N_ "Report's currency") "c") (gnc:options-add-price-source! options gnc:pagename-general optname-price-source "d" 'pricedb-latest) (add-option (gnc:make-number-range-option gnc:pagename-general optname-shares-digits "e" (N_ "The number of decimal places to use for share numbers.") 2 0 6 0 1)) ;; Account tab (add-option (gnc:make-account-list-option gnc:pagename-accounts (N_ "Accounts") "b" (N_ "Stock Accounts to report on.") (lambda () (filter gnc:account-is-stock? (gnc-account-get-descendants-sorted (gnc-get-current-root-account (lambda (accounts) (list #t (filter gnc:account-is-stock? accounts))) #t)) (gnc:register-option options (gnc:make-simple-boolean-option gnc:pagename-accounts optname-zero-shares "e" (N_ "Include accounts that have a zero share balances.") #f)) (gnc:options-set-default-section options gnc:pagename-general) options)) ;; This is the rendering function. It accepts a database of options ;; and generates an object of type . See the file ;; report-html.txt for documentation; the file report-html.scm ;; includes all the relevant Scheme code. The option database passed ;; to the function is one created by the options-generator function ;; defined above. (define (portfolio-renderer report-obj) (let ((work-done 0) (work-to-do 0)) ;; These are some helper functions for looking up option values. (define (get-op section name) (gnc:lookup-option (gnc:report-options report-obj) section name)) (define (get-option section name) (gnc:option-value (get-op section name))) (define (table-add-stock-rows table accounts to-date currency exchange-fn price-fn include-empty collector) (let ((share-print-info (gnc-share-print-info-places (inexact->exact (get-option gnc:pagename-general optname-shares-digits) (define (table-add-stock-rows-internal accounts odd-row?) (if (null? accounts) collector (let* ((row-style (if odd-row? "normal-row" "alternate-row")) (current (car accounts)) (rest (cdr accounts)) (commodity (xaccAccountGetCommodity current)) (ticker-symbol (gnc-commodity-get-mnemonic commodity)) (listing (gnc-commodity-get-namespace commodity)) (unit-collector (gnc:account-get-comm-balance-at-date current to-date #f)) (units (cadr (unit-collector 'getpair commodity #f))) (price-info (price-fn commodity to-date)) (price (car price-info)) (price-monetary (if price (gnc:make-gnc-monetary (gnc-price-get-currency price) (gnc-price-get-value price)) (gnc:make-gnc-monetary currency (cdr price-info (value (exchange-fn (gnc:make-gnc-monetary commodity units) currency))) (set! work-done (+ 1 work-done)) (gnc:report-percent-done (* 100 (/ work-done work-to-do))) (if (or include-empty (not (gnc-numeric-zero-p units))) (begin (collector 'add currency (gnc:gnc-monetary-amount value)) (gnc:html-table-append-row/markup!
Re: [GNC] GnuCash 3.7 and Portfolio Report
Hello If you're using flatpak your portfolio.scm is probably located in another folder. I am sorry I don't know where exactly. Does anyone know if there is a flatpak nightly available? On Sun, 6 Oct 2019 at 13:02, NOSTOP wrote: > Hello John. > > I'm on ver 3.7, Flatpak, Linux Mint 18.3 > > My file : portfolio.scm is different. There is no "report-currency" to > change into "currency" at line 199 or anywhere else in the file. > > > * > portfolio.scm :* > > > > (define-module (gnucash report standard-reports portfolio)) > > (use-modules (gnucash main)) ;; FIXME: delete after we finish modularizing. > (use-modules (srfi srfi-1)) > (use-modules (gnucash gnc-module)) > (use-modules (gnucash gettext)) > > (use-modules (gnucash printf)) > > (gnc:module-load "gnucash/report/report-system" 0) > > (define reportname (N_ "Investment Portfolio")) > > (define optname-price-source (N_ "Price Source")) > (define optname-shares-digits (N_ "Share decimal places")) > (define optname-zero-shares (N_ "Include accounts with no shares")) > > (define (options-generator) > (let* ((options (gnc:new-options)) > ;; This is just a helper function for making options. > ;; See gnucash/src/scm/options.scm for details. > (add-option > (lambda (new-option) > (gnc:register-option options new-option > > ;; General Tab > ;; date at which to report balance > (gnc:options-add-report-date! > options gnc:pagename-general > (N_ "Date") "a") > > (gnc:options-add-currency! > options gnc:pagename-general (N_ "Report's currency") "c") > > (gnc:options-add-price-source! > options gnc:pagename-general > optname-price-source "d" 'pricedb-latest) > > (add-option > (gnc:make-number-range-option > gnc:pagename-general optname-shares-digits > "e" (N_ "The number of decimal places to use for share numbers.") 2 > 0 6 0 1)) > > ;; Account tab > (add-option > (gnc:make-account-list-option > gnc:pagename-accounts (N_ "Accounts") > "b" > (N_ "Stock Accounts to report on.") > (lambda () (filter gnc:account-is-stock? > (gnc-account-get-descendants-sorted > (gnc-get-current-root-account > (lambda (accounts) (list #t > (filter gnc:account-is-stock? accounts))) > #t)) > > (gnc:register-option > options > (gnc:make-simple-boolean-option > gnc:pagename-accounts optname-zero-shares "e" > (N_ "Include accounts that have a zero share balances.") > #f)) > > (gnc:options-set-default-section options gnc:pagename-general) > options)) > > ;; This is the rendering function. It accepts a database of options > ;; and generates an object of type . See the file > ;; report-html.txt for documentation; the file report-html.scm > ;; includes all the relevant Scheme code. The option database passed > ;; to the function is one created by the options-generator function > ;; defined above. > (define (portfolio-renderer report-obj) > > (let ((work-done 0) >(work-to-do 0)) > > ;; These are some helper functions for looking up option values. > (define (get-op section name) > (gnc:lookup-option (gnc:report-options report-obj) section name)) > > (define (get-option section name) > (gnc:option-value (get-op section name))) > > (define (table-add-stock-rows table accounts to-date currency > exchange-fn price-fn include-empty > collector) > >(let ((share-print-info > (gnc-share-print-info-places >(inexact->exact (get-option gnc:pagename-general >optname-shares-digits) > > (define (table-add-stock-rows-internal accounts odd-row?) > (if (null? accounts) collector > (let* ((row-style (if odd-row? "normal-row" "alternate-row")) > (current (car accounts)) > (rest (cdr accounts)) > (commodity (xaccAccountGetCommodity current)) > (ticker-symbol (gnc-commodity-get-mnemonic commodity)) > (listing (gnc-commodity-get-namespace commodity)) > (unit-collector (gnc:account-get-comm-balance-at-date > current to-date #f)) > (units (cadr (unit-collector 'getpair commodity #f))) > > (price-info (price-fn commodity to-date)) > (price (car price-info)) > (price-monetary (if price > (gnc:make-gnc-monetary > (gnc-price-get-currency price) > (gnc-price-get-value price)) > (gnc:make-gnc-monetary > currency > (cdr price-info > (value
Re: [GNC] GnuCash 3.7 and Portfolio Report
Hi John, I deleted my post before seeing your reply. I realized I was trying to edit portfolio.scm for the old repo version 2.6.19 still installed on the machine, instead of portfolio.scm for ver 3.7 (flatpak) located /var/lib/flatpak/app/org.gnucash.GnuCash/x/x/x/ . I thought I was able to delete my post since before anyone read it, so as not to waste anyone's time. Thank you -- 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] GnuCash 3.7 and Portfolio Report
It is an e-mail list, so once it is out there, it is out there. You are using Nabble which takes the e-mail list and offers a forum-like interface. That doesn’t change the list, however. Regards, Adrien > On Oct 6, 2019 w41d279, at 8:54 AM, NOSTOP wrote: > > Hi John, > > I deleted my post before seeing your reply. I realized I was trying to edit > portfolio.scm for the old repo version 2.6.19 still installed on the > machine, instead of portfolio.scm for ver 3.7 (flatpak) located > /var/lib/flatpak/app/org.gnucash.GnuCash/x/x/x/ . > > I thought I was able to delete my post since before anyone read it, so as > not to waste anyone's time. > > Thank you ___ 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] 3.7 - Budget reports - accumulated accounts - can "envelope budgeting" logic be implemented?
I had written my own report for version 2.6 that does this. Now I see that it won't run in 3.7. This email prompted me to look at 3.7 and this report. I found that if I enable accumulated amounts and the diff column, then turn off the budget and actual columns the report works rather nicely for envelope budgeting. At this point you just see how much money is left in each budget per month. On 10/4/19 4:41 AM, Antonio07 wrote: Hi In version 3.7 accumulated accounts option was introduced in Budget reports However by using it I have found that logic is that Budget and Actual - simply summing all "period" amount For Example: 1. I have 24 month budget 2. For each month I budgeted 320$ in category 'Food' - now I'm in October - it's 22nd month of my Budget - if I use accumulated amount it shows that I have budget for October 7040$ for 'Food' (but in reality I have only 320$) 3. Each month I have spent from 300 to 330 as actuals and now have accumulated Actuals for October - 6500$ 4. So accumulated difference 540$ Can it be change report format to show "Rolling" accumulated amounts? For Example 1. Period 21 - we have budgeted for 'Food' +320$ 2. Period 21 - we have actuals for 'Food' -300$ 3. Period 21 - We have difference for 'Food' +20$ (positive) 4. Period 22 - we have budgeted for 'Food' +300$ 5. Period 22 - we have actuals for 'Food' -100$ (so far) 6. Period 22 - we have difference = (Difference amount from period 21 '+20$' ) + (Budgeted amount from period 22 '+300$') - (Actuals from period 22 '-100$') = 20$ + 300$ - 100$ = 220$ By using we can avoid confusing end-user with huge accumulated numbers - and also keep concept if accumulating budget for some Big Goal - like budget 100$ every month for 1200$ vacation in the end of the year -- 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. -- http://mtu.net/~jpschewe ___ 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.7 crash in online banking
Eric Haszlakiewicz wrote > When I start it again, I can't even delete the aqbanking user because it > tries to acquire a lock and fails with error -109, so I need to remove the > aqbanking folder again. If I remove just the *lck* files, I can get it to > crash by clicking the "Retrieve Account List" button inside the online > banking setup. > > Is anyone else having this problem? Any possible fixes or workarounds? > > Thanks, > Eric > ___ *Eric... I continue to have the same issue when trying to set up aqbanking... it crashes when I try and retrieve my accounts, and then when i try and delete the aqbanking user i had set up, i get an error that the removal attempt fails, error - 109. Did you ever figure out what was going on? * -- 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-dev] custom report freezing - work done gets lost.
You mean why does it hang instead of crashing? Possibly because the memory was reallocated back to the program for something else and the attempt to free the splits is freeing whatever that is and that's resulting in a hang. But why would a report create or delete splits or transactions? A report should be describing the book as it is, not changing it. Regards, John Ralls > On Oct 6, 2019, at 2:36 AM, Christopher Lam wrote: > > Ok forwarding to people who have better idea. > > -- Forwarded message - > From: Steven Bruniges > Date: Sun, 6 Oct 2019 at 09:34 > Subject: Re: [GNC] custom report freezing - work done gets lost. > To: Christopher Lam > > > Have identifies my issue. Was calling xaccTransDestroy with pointers to > splits that had been destroyed in an earlier loop. Not sure why this locks > up gnucash. > > Steve > > On Sun, 6 Oct 2019, 22:20 Christopher Lam, > wrote: > >> Sorry without specific detail what you're trying to do, we can't help. >> Moreover this is open-source, including open-source help requests. >> cc: devel >> >> On Sun, 6 Oct 2019 at 05:58, Steven Bruniges >> wrote: >> >>> Not even sure it’s the session I want to save (hoping for the function >>> underlying the save option in the file menu). >>> >>> >>> >>> Working through a process of elimination. I’d love to find the >>> transaction that’s triggering this behaviour. If I can reduce the 3000 >>> splits to something more manageable I may find the issue? >>> >>> >>> >>> The report typically hangs and Task manager shows the system is at rest. >>> If I modify the code to open warning dialogs it crashes after a number of >>> loops. No output in the trace file. Either way, I get no diagnostic >>> feedback. >>> >>> >>> >>> Its possible I am retaining pointers to a deleted split, or running >>> across a temporary split that was never finished, etc, (or both). >>> >>> >>> >>> On that point, is there any test if a split is deleted? >>> >>> >>> >>> Steve >>> >>> >>> >>> *From:* Christopher Lam [mailto:christopher@gmail.com] >>> *Sent:* Sunday, 6 October 2019 6:17 PM >>> *To:* Steven Bruniges >>> *Cc:* GnuCash users group >>> *Subject:* Re: [GNC] custom report freezing - work done gets lost. >>> >>> >>> >>> qof-session isn't currently accessible to scheme. Why do you think you'll >>> need to save session? >>> >>> >>> >>> It may help to publish your report on Bugzilla or devel mailing list. >>> >>> >>> >>> On Sun, 6 Oct 2019, 12:53 Steven Bruniges, >>> wrote: >>> >>> Hi. >>> >>> >>> >>> Have a custom report that appears to be freezing, so I have to halt it. >>> It >>> in a 3000 item loop, and I suspect the overheads are growing as it >>> progresses. >>> >>> >>> >>> I want to save the book periodically, which if nothing else will simplify >>> the work in a future run. >>> >>> >>> >>> Is there a function I can call that is like "gnc-book-session-save"? >>> >>> >>> >>> Steve >>> >>> ___ >>> 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-devel mailing list > gnucash-de...@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ 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] Correcting Bayesian rules?
I suspect I corrupted the Bayesian reasoning, accidentally. I did an import and matched things badly, then quit GC without saving. I understand there is a bug report indicating that quit-before-save does not correct Bayesian errors. So, how do you correct a Bayesian reasoning error that you have caused, other than manually repairing every transaction? ___ 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] Correcting Bayesian rules?
Tools->Import Map Editor Locate the token string you feel is recorded in error and delete it . If you imported the data I think it is the importing action which writes the mapping data to the data file. This will not however correct transactions you have already imported. You can either delete tham ( also a one by one operation) and then reimport them or simply modify them in the account registers in GnuCash. Even if the Import Matcher assigns the "wrong" account you can always override it by double clicking the row to bring up the account selection dialog and then choosing the correct account. This will then save the correct matching info when you do the final import of data. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Correcting Bayesian rules?
One additional point. While the Bayesian matcher is 'trained' with specific examples, it applies the process by looking for similarities rather than exact matches, so it generates a similarity score and that may still result in 'mistakes' now and then. Generally, it gets better with more examples, but never perfect. David Carlson On Sun, Oct 6, 2019 at 8:53 PM David Cousens wrote: > > Tools->Import Map Editor > > > Locate the token string you feel is recorded in error and delete it . If > you > imported the data I think it is the importing action which writes the > mapping data to the data file. This will not however correct transactions > you have already imported. You can either delete tham ( also a one by one > operation) and then reimport them or simply modify them in the account > registers in GnuCash. > > Even if the Import Matcher assigns the "wrong" account you can always > override it by double clicking the row to bring up the account selection > dialog and then choosing the correct account. This will then save the > correct matching info when you do the final import of data. > > David > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ 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 can I add statement balances to my accounts as checks?
Adrien Monteleone-2 wrote > Software can’t fix you. Only you can fix you. You shouldn’t do the > reconciliation till you have time not to rush it. The software won’t > explode if you don’t reconcile by a certain date. Yeah I fundamentally disagree with this, almost at a philosophical level. If we take the view that mistakes are symptomatic of broken users we'll never make software that's actually useful to anyone. I also think there's a bit of irony as you seem to be suggesting that in order to use a feature designed to correct for human errors, we should just not make human errors. I don't get it. -- 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.
