2020-10-16 GnuCash IRC logs

01:06:43 *** sbluhm has joined #gnucash
01:06:43 *** ChanServ sets mode: +v sbluhm
01:14:48 *** Mechtilde has joined #gnucash
01:22:28 *** sbluhm has quit IRC
01:40:08 *** sbluhm has joined #gnucash
01:56:00 *** Mechtilde has quit IRC
02:01:45 *** fell has quit IRC
02:02:37 *** vuamw has joined #gnucash
02:03:02 *** fell has joined #gnucash
02:03:02 *** ChanServ sets mode: +o fell
02:52:20 *** vuamw has quit IRC
02:52:56 *** vuamw has joined #gnucash
03:08:09 *** vuamw has quit IRC
03:16:53 *** gjanssens has joined #gnucash
03:16:53 *** ChanServ sets mode: +o gjanssens
03:23:56 *** Mechtilde has joined #gnucash
03:28:05 *** hussam has quit IRC
03:28:27 *** vuamw has joined #gnucash
05:06:35 *** rangerrr has joined #gnucash
05:13:50 <rangerrr> How do I export account overview report as a csv? For example -- Account;Name;Summe 0320;PKW;27320,21 1200;Bank Account;143290,19
05:21:15 *** hussam has joined #gnucash
05:21:15 *** ChanServ sets mode: +v hussam
05:22:02 *** hussam has quit IRC
05:22:50 *** hussam has joined #gnucash
05:22:50 *** ChanServ sets mode: +v hussam
05:23:32 *** hussam has quit IRC
05:24:20 *** hussam has joined #gnucash
05:24:20 *** ChanServ sets mode: +v hussam
05:28:29 *** User has joined #gnucash
05:31:25 <chris> rangerr: no such mechanism exists. you can export report HTML and import HTML from any spreadsheet.
05:42:36 <rangerrr> chris Thanks.
05:52:08 *** Aussie_matt has joined #gnucash
06:07:24 *** ramontjunior has joined #gnucash
06:52:21 *** warlord has quit IRC
06:53:40 *** rIMpossible has quit IRC
06:55:00 *** warlord has joined #gnucash
06:55:00 *** gncbot sets mode: +o warlord
06:58:21 *** warlord has quit IRC
06:58:47 *** warlord has joined #gnucash
06:58:47 *** gncbot sets mode: +o warlord
06:59:51 *** warlord has quit IRC
07:00:12 *** warlord has joined #gnucash
07:00:12 *** gncbot sets mode: +o warlord
07:01:19 *** Herbert has joined #gnucash
07:05:21 *** warlord has quit IRC
07:05:34 *** warlord has joined #gnucash
07:05:34 *** gncbot sets mode: +o warlord
07:07:03 *** rIMpossible has joined #gnucash
07:07:03 *** ChanServ sets mode: +v rIMpossible
07:12:21 *** warlord has quit IRC
07:12:34 *** warlord has joined #gnucash
07:12:34 *** gncbot sets mode: +o warlord
07:20:39 *** joe7 has quit IRC
07:28:36 *** joe7 has joined #gnucash
07:44:15 *** o01eg has joined #gnucash
07:53:09 *** Herbert has joined #gnucash
07:53:13 *** Herbert has quit IRC
07:59:20 <warlord> jralls, well, it's not the gnucash.pot that matters, it's all the various languages that matter. The various languages are committed, but I don't think we want to msgmerge on every commit because I think it would *lose* translations frequently and cause more work for translators.
08:34:30 <chris> jralls: my interest in auto-clear mainly lies in "practice" and setting an example of a self-contained utility function... anyone wishing to add a new module e.g. a data-entry wizard could use it as a template.
08:58:03 *** Jimraehl1 has joined #gnucash
08:58:59 *** Jimraehl1 has quit IRC
09:13:00 *** halipaul has quit IRC
09:13:59 *** halipaul has joined #gnucash
09:33:04 *** jervin has joined #gnucash
09:37:12 *** jervin has quit IRC
10:15:23 *** sbluhm has quit IRC
10:32:59 *** sbluhm has joined #gnucash
10:32:59 *** ChanServ sets mode: +v sbluhm
10:34:27 *** Agfarmer18 has joined #gnucash
10:44:00 *** ChanServ sets mode: +v halipaul
10:49:00 *** chris has quit IRC
10:51:02 *** chris has joined #gnucash
10:51:02 *** ChanServ sets mode: +v chris
10:51:02 *** gncbot sets mode: +o chris
10:54:11 *** Agfarmer18 has quit IRC
11:24:18 *** Mechtilde has quit IRC
11:27:22 *** joe7 has joined #gnucash
11:27:27 *** joe7 has joined #gnucash
11:44:13 *** sbluhm has quit IRC
11:45:46 <fell> Sorry, I had fallen asleep yesterday.
11:48:04 <fell> warlord, if you change a string in a source file, the translation IS lost, because gettext can no longer find a msgstr for that msgid in the existing mo file.
11:48:55 <fell> msgfmt -c is lying if the last merged pot is outdated.
11:50:58 <fell> But msgmerge will keep obsolete pairs prefixed with ~ in the po file until the translator removes them.
11:52:07 <fell> So, if you revert a string changing commit before the translator cleans the po file, it will get reused.
11:58:50 *** sbluhm has joined #gnucash
11:58:50 *** ChanServ sets mode: +v sbluhm
12:00:27 *** o01eg has quit IRC
12:02:34 <warlord> Hmm. ok.
12:07:19 *** guak has joined #gnucash
12:18:20 *** sbluhm has quit IRC
12:20:43 <CDB-Man> [07:57:39] <@9d54b3chris> CDB-Man_ eventually I'd think a wiki entry like https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS would be invaluable for various stock activity <-- chris indeed, though that's probably a good final step after everything actually works :)
12:21:18 <CDB-Man> On the bug tracker wm.tarr, who is that on this channel? Assuming they are on this channel
12:22:53 <CDB-Man> jralls: I saw your fix for the comma separated crash -- I will test that out on the weekend. Lioking at the other positive replies, I have high hopes!
12:25:46 <chris> CDB-Man: DNFTT is the current GAAP for that person...
12:26:24 <warlord> CDB-Man, Wm doesn't often show up here..
12:26:39 <chris> 797977: jralls or gjanssens some support would be nice -- either fix datafile to meet gnc standards or expose old report which means maintain it forever
12:27:23 <chris> I'm not sure I can bug fix new-reports to support old bad data
12:29:06 * chris wish bugzilla had a +m option, or shadowban
12:30:27 *** jervin has joined #gnucash
12:30:50 <warlord> chris, lol. Yeah.
12:32:51 *** Agfarmer18 has joined #gnucash
12:37:17 *** jervin has quit IRC
12:37:26 *** jervin has joined #gnucash
12:37:58 <warlord> Alas, BZ does not have a good anti-spam story.
12:38:57 *** sbluhm has joined #gnucash
12:38:57 *** ChanServ sets mode: +v sbluhm
12:40:50 *** storyjesse has quit IRC
12:45:28 *** Mechtilde has joined #gnucash
13:02:53 *** sbluhm has quit IRC
13:07:59 <CDB-Man> [12:25:46] <@9d54b3chris> CDB-Man: DNFTT is the current GAAP for that person... <-- Hmm?
13:09:03 *** chris has quit IRC
13:11:17 <CDB-Man> Looked it up. Ok, will avoid
14:26:13 <fell> gjanssens, I am just running a test build for https://github.com/flathub/org.gnucash.GnuCash/issues/35. Do you see additional recommend changes from https://gitlab.com/freedesktop-sdk/freedesktop-sdk/-/blob/release/20.08/NEWS?
14:28:57 <fell> jralls, you saw https://github.com/Gnucash/gnucash-on-windows/pull/46ß
14:29:07 *** frakturfreak has joined #gnucash
14:50:47 <jralls> fell, yes, I just haven't had a chance to process it.
14:52:10 <fell> NP :-)
14:53:35 <jralls> chris, unfortunately auto-clear is an example of how not to implement the knapsack problem algorithm. But your extraction of the model code out of the UI module is welcome.
14:58:02 *** gjanssens has quit IRC
15:07:05 <jralls> chris, as for 797977 are you looking for me to make a caustic remark about GnuCash expecting users to keep their books up to date if they want the reports to be accurate?
15:14:03 <CDB-Man> jralls, while you are at it, care to respond to wm in 797796 in a similar manner?
15:15:49 <CDB-Man> As for Bob Jenkins and 797977, this is actually a common audit finding, that companies have poor book keeping
15:19:25 <jralls> CDB-Man, You want me to feed Wm? I try to respond to him only when he has a concrete issue as on 797959 and ignore his various raving. I did start to point out that unlike him or me you actually have a license but decided that it's probably better not to.
15:19:54 <fell> @tell gjanssens The flatpak Gnome3.38 build failed with "
15:19:54 <gncbot> fell: Error: No closing quotation
15:19:56 <fell> CMake Generate step failed. Build files cannot be regenerated correctly.
15:19:57 <fell> Error: module mariadb: Der Kindprozess wurde mit Status 1 beendet
15:20:15 <CDB-Man> Ah, so you're saying we should quite literally ignore him, and just carry on our conversation as if he was transparent?
15:20:24 <jralls> Yes.
15:20:30 <CDB-Man> Will do then
15:21:07 <jralls> That what chris meant by DNFTT.
15:21:11 <CDB-Man> As to 797977, I've replied with some insight and a "compromise" of sorts
15:21:36 <CDB-Man> Much to my chagrin, it is a common (but far from ideal) practice
15:21:58 <fell> @tell gjanssens The flatpak Gnome3.38 build failed with "CMake Generate step failed. Build files cannot be regenerated correctly. Error: module mariadb: Der Kindprozess wurde mit Status 1 beendet"
15:21:58 <gncbot> fell: The operation succeeded.
15:22:33 <jralls> I don't really see the point, why not just apply the stupid payments?
15:23:04 <CDB-Man> One entity I audit literally has hundreds of system generated payments every day
15:23:13 <CDB-Man> They apply once a month, otherwise it's too much work
15:23:44 <CDB-Man> We give them an earful each year when we audit them
15:24:27 *** CDB-Work has joined #gnucash
15:24:27 *** ChanServ sets mode: +v CDB-Work
15:24:35 <jralls> <retorical>If the system can generate the payments why can't it apply them? </retorical>
15:24:55 <CDB-Work> that is actually a very good question and one that is often asked
15:25:25 <CDB-Work> the most common answer is that data from the payment system typically does not contain sufficient info to (automatically) apply a payment against an invoice
15:25:49 <CDB-Work> e.g. "$100 received at front desk POS" says nothing about which of your customers was at the front desk
15:26:06 <CDB-Work> same with "WIRE -- WELLS FARGO" $100
15:28:01 <jralls> That's a reason to have a better-integrated payment system. The data connecting the customer and invoice to the payment has to exist somewhere.
15:29:06 <CDB-Work> typically, it exists via an email or a phone call. the customer emails and says "i just wired you $100 today"
15:29:09 <CDB-Work> hence the manual matching
15:29:46 <CDB-Work> or if at the front desk POS, the cash payment has a remittance slip attached. but the POS register lacks the ability for the desk clerk to apply the payment, so someone in Finance has to do it when they do the daily cash clearing
15:30:32 <CDB-Work> in other words, the data exists yes, but sadly in a non-system format
15:30:42 <CDB-Work> and typically involves manual matching
15:31:30 <CDB-Work> large businesses like Walmart require their customers to enter the payment details into their web portal, eg entire the Wire #, so that Walmart system can find that Wire # and auto apply the payment to the AR register
15:31:53 <CDB-Work> but that requires 1) you have that extra bit of software and 2) you have the right sticks and carrots to get your customers to behave and use that system
15:32:11 <CDB-Work> (walmart's business customers that is, not retail ones of course)
15:33:51 <jralls> Well, it requires the software, obviously. But it can work by just having the clerk at the POS or the person who gets the phone call to have an easy way to match the invoice instead of writing out a note.
15:35:09 <jralls> And I'd think a business that piles up thousands of those notes until the end of the month would have a retention problem among the clerks who have to process them when they could do a little bit every day instead.
15:35:43 <jralls> *And* not get yelled at by the auditor every year! ;-)
15:35:47 <CDB-Work> indeed, though most (especially the more rudimentary) systems don't have a way that gives the clerk a limited user role that only has access to 1 function, and/or it does but the business doesn't want to purchase a 2nd comptuer terminal to sit beside the POS
15:36:21 <CDB-Work> And I'd think a business that piles up thousands of those notes... <--- indeed, we tell them this EVERY YEAR :)
15:36:53 <CDB-Work> perhaps it's still worthwhile for you to add that caustic remark
15:37:15 <CDB-Work> with some comment like "CDB's solution works, but as a business this is still a horrible practice as he rightly pointed out"
15:37:24 <jralls> Doesn't need access to the payment function, just need to be able to key in the invoice number. I haven't seen a POS that wasn't either a PC or an iPad in several years, but then I live in Silicon Valley not the real world.
15:37:54 <CDB-Work> the entity I'm using as an example here is an NPO sports/recreation facility
15:38:05 <CDB-Work> as in pool, basketball court, gym, etc
15:38:11 <CDB-Work> and as an NPO... they have no money
15:38:22 <jralls> I'd go more down the "GnuCash can't report what you don't tell it" route for 797977.
15:38:48 <CDB-Work> up to you, but i think your caustic remark is still a good idea to slap some common sense
15:39:16 <CDB-Work> if anything, the unapplied payments is a "warning flag" as well to tell you to get off your behind, and cleanup your register
15:39:33 <CDB-Work> still a good feature to have regardless of the requester's lack of hygiene
15:45:38 <jralls> warlord, the reporter on https://bugs.gnucash.org/show_bug.cgi?id=797977 asks if it would be possible to automagically apply overpayments to future invoices. ISTR you and gjanssens discussing exactly that, but I don't remember the details. Am I misremembering and if not do you remember why we don't?
15:47:14 <CDB-Work> typically, in systems where I do see auto payments, it usually uses the following logic:
15:47:23 <CDB-Work> 1. if there is an outstanding invoice with exact $ match, apply there
15:47:36 <CDB-Work> 2. else, apply partial payments, starting with the oldest outstanding invoice first
15:47:57 <CDB-Work> (systems that do not have unique identifier matching that is, e.g. invoice #)
15:48:46 *** jw4 has quit IRC
15:48:57 <jralls> Yeah, thats the process I remember being discussed.
15:50:00 *** jw4 has joined #gnucash
15:50:01 *** ChanServ sets mode: +v jw4
15:50:54 *** Mechtilde has quit IRC
15:54:57 <fell> @tell gjanssens There have been several CMake [3.18.3] Deprecation Warnings like CMP0022, CMP0026, CMP0045, CMP0042, CMP0075, see cmake-policies(7). Finally CMake Error NOTFOUND: LZ4_LIBS linked by target "libgroonga" in directory /run/build/mariadb/storage/mroonga/vendor/groonga/lib.
15:54:57 <gncbot> fell: Error: "3.18.3" is not a valid command.
15:55:31 <fell> @tell gjanssens There have been several CMake (3.18.3) Deprecation Warnings like CMP0022, CMP0026, CMP0045, CMP0042, CMP0075, see cmake-policies(7). Finally CMake Error NOTFOUND: LZ4_LIBS linked by target "libgroonga" in directory /run/build/mariadb/storage/mroonga/vendor/groonga/lib.
15:55:31 <gncbot> fell: The operation succeeded.
16:00:25 *** ramontjunior has quit IRC
16:14:29 *** sbluhm has joined #gnucash
16:14:30 *** ChanServ sets mode: +v sbluhm
16:25:01 *** rangerrr has quit IRC
16:34:59 *** KaiForce has joined #gnucash
17:09:05 *** bertbob has quit IRC
17:19:26 *** gnomey has quit IRC
17:22:06 *** User has quit IRC
17:40:19 *** frakturfreak has quit IRC
17:46:59 *** gnomey has joined #gnucash
17:49:21 *** sbluhm has quit IRC
17:53:20 <fell> It seems, I have to update MariaDB.
18:01:15 <warlord> And Maria is happy for you! :)
18:56:35 *** AdrienM has quit IRC
19:02:40 *** AdrienM has joined #gnucash
19:02:40 *** ChanServ sets mode: +v AdrienM
19:02:57 *** bertbob has joined #gnucash
19:02:58 *** ChanServ sets mode: +v bertbob
19:19:03 *** chris has joined #gnucash
19:19:04 *** ChanServ sets mode: +v chris
19:19:07 *** gncbot sets mode: +o chris
19:20:06 <chris> jralls: auto-clear amen. moving model into libgnucash is one good thing coming out of it, and also force-recruiting another contributor.
19:21:32 <chris> jralls: 797977 thanks :)
19:22:45 <jralls> So that was what you had in mind?
19:24:01 <chris> kinda, nice that cristi is happy to come back
19:28:21 *** Aussie_matt has quit IRC
19:28:45 <jralls> We'll see how for how long and whether he's willing to branch out. I guess I shouldn't be too upset about him not understanding how to implement the dynamic programming method for solving the knapsack problem, it's pretty stiff math.
19:30:16 * chris doesnt euther
19:34:45 <jralls> But it's simple matrix math! ;-)
19:41:42 <chris> gtg weekend chores!
19:46:10 <CDB-Work> chris: i tihnk it's been 2(?) weeks now since the newborn? honestly with all this stay at home, I've lost track of time. hope the little one is doing well
19:46:19 <CDB-Work> s/weeks/months....
20:09:35 *** AdrienM has quit IRC
21:03:01 *** AdrienM has joined #gnucash
21:03:01 *** ChanServ sets mode: +v AdrienM
21:17:58 *** guak has quit IRC
21:22:00 *** Agfarmer18 has quit IRC
22:56:00 *** Aussie_matt has joined #gnucash
23:38:37 <chris> cdb-work: 2months and counting! doing very well thx