2019-01-19 GnuCash IRC logs
00:22:12 <derek> like a loan repayment?
00:24:46 <pehuagenio> no, depreciation for an assets like vehicle or machinery
00:27:27 <derek> I think you can put formulas in the credit/debit columns, I'm guessing there is a function for it
00:29:15 <derek> https://wiki.gnucash.org/wiki/Scheduled_Transactions
00:29:42 <derek> under variables and formulas there is a special variable "i" which increases
00:45:48 <pehuagenio> yes, thx, I got it, but I need for every month the asset value for the previus month to calculate the new value, how do can I get the balance value for an account?
00:52:04 <derek> so just (asset * .02) when it runs it asks you for the value of asset
00:52:38 <derek> then it credits the asset account and debits the depreciation account
00:53:09 <derek> next time it runs the account value will be less already
00:53:30 <derek> so it will be 2% of the new value not the original value
00:54:47 <derek> or maybe wait till someone who actually knows wakes up, I'm like 3 days new to gnuCash
00:59:08 <pehuagenio> ok derek, I 'm trying to find an automatic way, but for now I will use your way, thx a lot for your help, :)
01:01:04 <derek> The actual input of the depreciation amounts is done by hand every accounting period. There is no way in GnuCash (as of yet) to perform the depreciation scheme calculations automatically, or to input the values automatically into the appropriate accounts. However, since an accounting period is typically one year, this really is not much work to do by hand.
01:01:12 <derek> https://www.gnucash.org/docs/v3/C/gnucash-guide/dep_accounts1.html
01:01:39 <derek> according to the manual
01:25:52 <pehuagenio> ok, very very clear, thx
01:36:19 *** pehuagenio has left #gnucash
01:51:08 *** fell has quit IRC
01:52:26 *** fell has joined #gnucash
01:58:41 *** tienne has joined #gnucash
02:10:59 *** gour has joined #gnucash
02:11:38 *** gjanssens has joined #gnucash
02:11:39 *** ChanServ sets mode: +o gjanssens
02:37:09 <chris> gjanssens, he wants to hide transactions rows *and* transaction subtotals, yet display subtotal table. i.e. another option
02:38:24 <chris> although, if 'hide-transactions' is redefined to be 'hide transactions and subtotals if display/subtotal is enabled', it would cover most report types
02:59:25 *** tienne has joined #gnucash
03:43:18 *** jerryq has quit IRC
03:53:07 *** JayC has quit IRC
04:00:08 *** tienne has joined #gnucash
04:00:22 *** JayC has joined #gnucash
04:36:14 <gjanssens> chris: ok thanks for clarifying this
04:36:14 <gncbot> gjanssens: Sent 10 hours and 56 minutes ago: <chris> he wants to hide transactions rows *and* transaction subtotals, yet display subtotal table. i.e. another option *sigh*
04:36:55 <gjanssens> I prefer not to add yet another option if possible
04:40:50 <chris> +1
04:41:54 <chris> having said that, if Display/Subtotal-table=#t and Sorting/Hide-txns=#t, we could change behaviour to hide subtotals as well
05:00:50 *** tienne has joined #gnucash
05:04:33 <gjanssens> That could work
05:11:14 *** boldstripe has joined #gnucash
05:23:41 *** Yotson has quit IRC
05:24:24 *** Yotson has joined #gnucash
05:52:29 *** nimish has joined #gnucash
05:54:08 <chris> meanwhile, chartjs is progressing \o/
05:55:09 *** nimish has quit IRC
05:55:46 *** nimish has joined #gnucash
06:01:34 *** tienne has joined #gnucash
06:01:35 *** tienne has quit IRC
06:20:47 *** nimish has quit IRC
06:21:22 *** nimish has joined #gnucash
06:25:45 *** User_ has joined #gnucash
06:31:49 *** User_ has quit IRC
06:34:29 *** oozer has joined #gnucash
06:37:23 *** Zzz has quit IRC
06:37:53 *** derek has quit IRC
06:45:35 *** derek has joined #gnucash
06:53:40 *** tienne has joined #gnucash
07:05:22 *** boldstripe_ has joined #gnucash
07:05:37 *** boldstripe has quit IRC
07:05:37 *** boldstripe_ is now known as boldstripe
07:06:01 *** oozer has quit IRC
07:31:57 *** guiloma has joined #gnucash
07:40:02 *** guiloma has quit IRC
07:46:31 *** Mechtilde has quit IRC
07:51:43 *** Mechtilde has joined #gnucash
08:01:48 *** trying2Simplify has joined #gnucash
08:14:35 *** nimish has quit IRC
08:22:09 *** nimish has joined #gnucash
08:26:30 *** nimish has quit IRC
08:27:26 *** jerryq has joined #gnucash
08:29:34 *** tienne has quit IRC
08:32:54 *** nimish has joined #gnucash
08:41:03 *** nimish has quit IRC
08:52:55 *** tienne has joined #gnucash
08:53:41 *** oozer has joined #gnucash
08:56:28 *** trying2Simplify has quit IRC
08:56:29 *** shoonya has joined #gnucash
08:56:42 *** trying2Simplify has joined #gnucash
09:04:59 <warlord> derek, SX has no "current balance" function to do what pehuagenio wants.
09:10:43 *** nimish has joined #gnucash
09:14:35 *** nimish has quit IRC
09:15:03 *** nimish has joined #gnucash
09:16:21 *** tienne has quit IRC
09:21:21 *** fabior has joined #gnucash
09:28:07 *** nimish has quit IRC
10:00:52 *** tienne has joined #gnucash
10:03:28 *** bertbob has quit IRC
10:05:30 *** shoonya has quit IRC
10:05:49 *** bertbob has joined #gnucash
10:06:49 *** trying2Simplify has quit IRC
10:07:04 *** trying2Simplify has joined #gnucash
10:10:24 *** nimish has joined #gnucash
10:15:07 *** nimish has quit IRC
10:16:04 *** nimish has joined #gnucash
10:22:41 *** boldstripe has quit IRC
10:27:46 *** nimish has quit IRC
10:44:02 *** tienne has quit IRC
10:51:26 *** nimish has joined #gnucash
10:52:10 *** trying2Simplify has quit IRC
10:52:24 *** trying2Simplify has joined #gnucash
10:55:38 *** fabior has quit IRC
11:01:17 *** nimish has quit IRC
11:01:47 *** nimish has joined #gnucash
11:02:31 *** trying2Simplify has quit IRC
11:02:44 *** trying2Simplify has joined #gnucash
11:22:52 *** trying2Simplify has quit IRC
11:23:05 *** trying2Simplify has joined #gnucash
11:26:37 *** nimish has quit IRC
11:27:10 *** nimish has joined #gnucash
11:27:32 *** nimish has quit IRC
11:32:10 *** tienne has joined #gnucash
11:34:46 *** Zzz has joined #gnucash
11:48:54 <derek> warlord: SX is Scheduled Transactions?
12:04:40 <gjanssens> derek: yes
12:06:31 <derek> you cannot use a current balance variable like account.balance or something?
12:06:57 <derek> seems like a simple feature
12:13:13 *** trying2Simplify has quit IRC
12:13:26 *** trying2Simplify has joined #gnucash
12:28:06 *** gjanssens has quit IRC
12:33:34 *** trying2Simplify has quit IRC
12:33:48 *** trying2Simplify has joined #gnucash
12:42:36 *** tachi has joined #gnucash
12:54:54 *** Jimraehl1 has joined #gnucash
12:58:23 *** tachi has quit IRC
12:58:55 *** trying2Simplify has quit IRC
12:59:14 *** trying2Simplify has joined #gnucash
13:01:04 *** Jimraehl1 has left #gnucash
13:04:37 *** tienne has quit IRC
13:23:09 *** tachi has joined #gnucash
13:24:22 <jralls> derek: Spend some quality time with libgnucash/engine/--maybe a year or two, full time--before you say things like "a simple feature". Very little is "simple" in GnuCash.
13:31:14 <jralls> derek: Meanwhile, there's a patch on https://bugs.gnucash.org/show_bug.cgi?id=797028 that can be user-applied which adds basic depreciation formulas for scheduled transactions. fin.scm is in libgnucash/app-utils.
13:31:52 *** monkeyjuice has joined #gnucash
13:33:23 *** monkeyjuice has quit IRC
13:38:23 <tachi> Importing mt940 files does not seem to working after selecting the file. What should happen after File > Import > Import MT940 ?
13:39:42 <warlord> derek, yes.
13:47:11 <derek> I think what I meant was that the feature is simple, enough to understand why people would want it, I don't pretend to know how to implement it.
13:48:59 <warlord> Of course we understand why people want it..
13:49:12 <warlord> But the infrastructure to implement it does not exists.
13:49:26 <warlord> Yes, it is a "Simple" matter of programming, but really not all that simple.
14:26:39 *** frakturfreak has joined #gnucash
14:33:22 <derek> where in the libgnucash does it deal with formulas, I'm wading through code just to get an idea of how they are handled but I'm not seeing it
14:40:38 <warlord> derek, you mean like fin.scm formulas?
14:40:51 <warlord> Or do you mean the register real-time formula execution?
14:40:54 <derek> schedXaction.h has the i counter function
14:41:31 <derek> I'll see fin.scm
14:43:05 <warlord> what exactly are you looking for? which formula?
14:43:29 *** fell has quit IRC
14:43:35 <derek> in SX when you enter an expression, I was curious how gnuCash handled that
14:45:16 <derek> in schedXaction it mentions expressions and the "i" execution counter, but I'm not seeing how it handles other expressions
14:46:22 *** fell has joined #gnucash
14:46:23 <warlord> derek, it calls out to a scheme function, most of which are defined in fin.scm
14:46:52 <derek> yes, fin.scm is what I'm looking for, excellent thanks
14:47:09 *** gncbot sets mode: +o fell
14:50:05 <warlord> derek, you're welcome.
14:59:09 *** bertbob has quit IRC
15:06:04 <derek> so fin.scm is where the actual math functions are located and expression_parser.c is how gnuCash actually interprets the expressions you put into the SX
15:07:08 <derek> there's some complex code in the parser
15:15:37 <jralls> tachi: https://bugs.gnucash.org/show_bug.cgi?id=797050
15:21:07 <tachi> jrails: After editing the file it worked. Somehow the files from my bank ABNAMRO do not work.
15:26:01 <tachi> Is there a way to change some settings that gnucash interprets the file from the bank in a correct way?
15:33:43 <jralls> tachi: Not that I know about. That's all handled by some third-party libraries. Their homepage is https://www.aquamaniac.de. AFAICT the GnuCash import routine just pipes the file into the converter and hopes for the best.
15:34:40 <jralls> It would help others if you can explain what you did to make it work on bug 797050.
15:36:42 <tachi> That bug is about characters. In my case even a window did not open showing all the transactions from the MT940 file.
15:37:45 <tachi> What i did is delete every 3 lines from every transaction.
15:39:53 <tachi> After that I got the window showing all the transactions.
16:06:30 *** Mechtilde has quit IRC
16:44:18 <tachi> jralls: I solved my problem by changing in file /usr/share/aqbanking/imexporters/swift/profiles/swiftmt940.conf line int skipDocLines=0 into int skipDocLines=3
16:45:06 <jralls> tachi: Interesting, but doesn't that break importing from other banks? Or do you have only the one?
16:45:07 <tachi> there is also a file amro940.conf but that doesn't seem to be used by gnucash
16:45:31 <tachi> I have only one bank to compare
16:46:18 <tachi> So I guess it would break importing from other banks
16:48:44 <tachi> In my case each transaction starts with the following 3 lines: ABNANL2A 940 ABNANL2A
16:49:42 <tachi> and 4. line of every transaction is :20:ABN AMRO BANK NV
16:56:43 *** oozer has quit IRC
16:59:16 *** oozer has joined #gnucash
17:01:27 *** boldstripe has joined #gnucash
17:06:04 *** tienne has joined #gnucash
17:07:26 *** boldstripe has quit IRC
17:07:31 <jralls> tachi: There's code in GnuCash to have a preference for mt940 format which I suppose would allow you to pick the Amro config instead, but I can't find any UI to set it.
17:36:56 <tachi> jralls: If it's possible to do the change by editing a config-file, that would be also fine.
17:43:35 <jralls> tachi: Unfortunately the default is a compiled-in constant. The alternative to what you did would be to move swiftmt940.conf out of the way and copy amro940.conf in its place.
18:07:29 *** trying2Simplify has quit IRC
18:09:06 <tachi> jralls: Indeed that is a way to work around it. It could be a bit of a hassle for users working with different banks. Maybe it could be fixed in the future then. It´s getting late over here. Bye!
18:09:21 <jralls> Goodnight, tachi!
18:09:59 *** tachi has left #gnucash
18:12:51 *** jrp has joined #gnucash
18:14:40 *** tienne has quit IRC
18:14:45 *** jrp_ has quit IRC
18:22:36 *** tienne has joined #gnucash
18:31:25 *** Zzz has quit IRC
18:31:51 *** gour has quit IRC
19:29:09 <chris> @tell gjanssens I coded the hide-table functionality (no new option) via the last commit in #450
19:29:09 <gncbot> chris: The operation succeeded.
19:29:53 <chris> meanwhile #316 chartjs is ready for testing
19:38:27 *** bertbob has joined #gnucash
19:41:41 *** tienne has quit IRC
19:42:47 *** trying2Simplify has joined #gnucash
19:50:23 *** nimish has joined #gnucash
20:03:41 *** frakturfreak has quit IRC
20:10:17 *** frakturfreak has joined #gnucash
20:23:28 *** oozer has quit IRC
20:54:17 *** trying2Simplify has quit IRC
21:02:32 *** frakturfreak has quit IRC
22:33:06 *** nimish has quit IRC