2015-01-08 GnuCash IRC logs
00:41:36 *** alexjj has joined #gnucash
01:23:47 *** MechtiIde has joined #gnucash
01:57:31 *** MechtiIde has quit IRC
02:14:51 *** gour has joined #gnucash
02:28:26 *** uXus has quit IRC
03:23:51 *** rubdos has joined #gnucash
03:43:53 *** StuM has joined #gnucash
03:48:54 *** uXus has joined #gnucash
03:52:18 *** pacon has joined #gnucash
04:59:08 *** uXus has quit IRC
05:03:38 *** len has quit IRC
05:30:14 *** pacon has quit IRC
06:03:12 *** asfasfaf has quit IRC
06:16:56 *** gour_ has joined #gnucash
06:22:07 *** gour has quit IRC
06:24:34 *** rubdos has quit IRC
06:40:48 *** aqua___ has joined #gnucash
06:56:21 *** himaxx has joined #gnucash
06:57:08 *** Jimraehl1 has left #gnucash
07:08:31 *** Jimraehl1 has joined #gnucash
07:19:07 *** himaxx has quit IRC
07:33:31 *** aqua___ has quit IRC
07:41:09 *** StuM has quit IRC
07:46:25 *** rickoehn has joined #gnucash
07:54:45 *** andy has quit IRC
08:01:09 *** andy has joined #gnucash
08:11:27 *** himaxx has joined #gnucash
08:35:23 *** StuM has joined #gnucash
08:47:49 *** lmat has quit IRC
08:52:37 *** aqua___ has joined #gnucash
09:07:32 *** lmat_ has joined #gnucash
09:11:34 *** lmat has joined #gnucash
09:12:43 *** StuM has quit IRC
09:12:46 *** aqua___ has quit IRC
09:15:26 *** lmat_ has quit IRC
09:29:33 *** squidly has joined #gnucash
09:30:20 <squidly> I have an issue with my scheduled Transactions. I messed up the starting date. Is there a way I can undo the creation of the transactions?
09:33:00 *** lmat has quit IRC
09:36:49 <cphuntington97> squidly: would it be really tedious to fix them manually? that's what I'd do...
09:38:07 <squidly> cphuntington97: over 100 years of deleting transactions?
09:38:27 <cphuntington97> oh, wow. lol
09:38:29 <squidly> let me rephrase that, sorry.
09:38:44 <squidly> It's over 100 years of transcations that were entered.
09:39:29 <cphuntington97> I definitely don't know how to script anything
09:41:01 <squidly> Yea..
09:41:24 <squidly> Funny thing is it's not a lot of money.. enough to throw my balance off by 75k
09:42:11 <cphuntington97> my only thought is to do some sort of search to fix them all, or revert to before you added them
09:42:43 <squidly> cphuntington97: cant really do that. My backend is a mysql engine and the data's alreday committed by the schedule
09:43:48 *** lmat has joined #gnucash
09:44:00 <cphuntington97> your problem is out of my knowledge space.. I'd just be fixing them by hand I think
09:44:24 <cphuntington97> maybe someone here will chime in
09:45:00 <squidly> That's what I'm hopeing as well.
09:46:08 <cphuntington97> you could probably do some sort of thing in sql to remove them all at once.. I have no idea what gnucash looks like on the database side
09:47:29 <lmat> Didn't hear the question
09:49:13 <squidly> lmat: how can I undo a number of scheduled transactions at once.
09:49:22 <squidly> or rever the last run of the scheduler
09:49:33 <squidly> revert*
09:49:44 <lmat> squidly: Ah, you want the last instance of a few scheduled transactions undone?
09:50:02 <squidly> lmat: no ALL of them.
09:50:06 <lmat> squidly: I'm pretty sure that once a transaction posts, it's not associated with the scheduled transactions anymore. In other words, you can't modify the scheduled transaction to
09:50:09 <lmat> oh
09:50:19 <lmat> yeah, you'll have to delete them like any other transaciton.
09:50:22 <squidly> that last run was a mistake and I need to delete about 100 years of a mistake.
09:50:30 <lmat> Usually, there should be something similar between them all? (especially
09:50:31 <lmat> ahha!
09:50:42 <lmat> That's quite a mistake!
09:50:52 <squidly> Yep
09:51:19 <lmat> "A good man leaveth an inheritance to his children's children:..."
09:52:13 <lmat> (especially since they were all created from the same scheduled transaction...)
09:52:30 <squidly> Yea.. It's just going to be fun
09:52:43 <lmat> For instance, do all of them have a description like "scheduled transaction 152"? In which case, you can use gnucash to search for those transactions and maybe there's a quick way to delete them all.
09:52:53 <lmat> squidly: I would be doing this from sql.
09:52:58 <squidly> Not that I have seen.
09:53:22 <squidly> lmat: lmat I though of that but I don't want to mees around in the DB that much.
09:53:38 <squidly> I'm not sure how the DB is setup.. (speaking of which I guess I need to learn)
09:54:01 <cphuntington97> delete ____ from ____ where ____ .... that kind of thing? probably the easiest way.. just make a backup first
09:55:11 <lmat> cphuntington97: yup
09:55:27 <lmat> squidly: It's remarkably straightforward. I've seen some database schemata in my day, and the gnucash schema is refreshing.
09:55:39 <cphuntington97> that's heartening, lmat :-)
09:56:01 <lmat> there's a table called 'transactions' and one called 'splits' ... so simple! (compared to ... others ^_^)
09:56:20 <squidly> lmat: I have as well but I have not looked the db schema at all.
09:58:19 <squidly> Forunitally they are not all that intermixed
10:12:18 *** wol has joined #gnucash
10:37:24 *** GabrieleV_ has joined #gnucash
10:37:27 *** GabrieleV has quit IRC
10:37:28 *** GabrieleV_ is now known as GabrieleV
10:39:00 *** gour_ has quit IRC
10:52:42 *** aqua___ has joined #gnucash
10:53:44 *** mlncn has quit IRC
11:02:41 *** uXus has joined #gnucash
11:02:53 <warlord> cphuntington97: Um, revert to a backup file from just before they were entered?
11:03:08 <warlord> Oh, missed the "using mysql".
11:03:22 <warlord> Sorry, best option will be to remove them by hand.
11:04:08 <warlord> lmat: I wouldn't do it from sql -- too much chance for damage.
11:04:20 <warlord> However, this WOULD be a useful use of the python (or scheme) bindings
11:05:24 *** aqua___ has quit IRC
11:06:29 *** mlncn has joined #gnucash
11:07:33 <cphuntington97> warlord: binding that do not currently exist?
11:13:19 <warlord> cphuntington97: ??? What do you mean?
11:14:09 <cphuntington97> warlord: er, I dunno. I'm not a developer. I guess I'm asking if gnucash is currently scriptable with python or the like, or if it would require modifications to gnucash first
11:19:19 <warlord> If you compile with the bindings then yes, it is.
11:19:29 <warlord> The scheme bindings have been there for over a decade .
11:19:37 <warlord> ... and are required for gnucash to even run
11:19:47 <warlord> python---- you need to build them. They are not built on Mac or Windows
11:22:10 * squidly nods
11:22:24 <squidly> warlord: I though I was going to have to do it the same time.
11:22:35 <squidly> is there a reason why I cant select multiple entries at the same time?
11:22:55 <cphuntington97> warlord: cool.
11:26:59 <warlord> squidly: the UI doesn't allow it.
11:28:05 <warlord> squidly: but you can do it relatively quickly. Do a Search to find only the txns you want to delete, then just use the keyboard macros to delete each txn. You can turn off the warning dialogs to make it faster, so effectively you just need to hit "Delete" x100 times.
11:29:27 *** himaxx has joined #gnucash
11:30:28 <squidly> Yea that's what I ended up doing. I'm more wondering why the UI was not setup to allow that
11:33:26 *** himaxx has quit IRC
11:34:39 *** wol has quit IRC
11:34:52 *** wol has joined #gnucash
11:35:33 <warlord> squidly: many many MANY reasons -- the first of them being that the register widgets used don't allow it.
11:36:20 <warlord> There was a project to rewrite the register using more modern widgets, but that code never finished completely -- it was still majorly buggy before the 2.6 release so it was turned off. AFAIK nobody has been working on trying to fix those issues.
11:37:52 <warlord> Then logically I'm not sure how you would even present that to the User. It's not a spreadsheet; there are no row indicators to grab onto in order to select a full row/transaction. And what would it mean to operate on multiple transactions at once?
11:40:45 <squidly> warlord: ok Understandable
11:58:01 *** wol has quit IRC
12:30:10 *** wol has joined #gnucash
12:33:21 *** wol has joined #gnucash
12:33:56 *** MechtiIde has joined #gnucash
12:35:04 *** wol has quit IRC
12:48:04 <lmat> Ah, I see that boost got up to 1.50 minimum dependency :)
12:55:12 *** aqua___ has joined #gnucash
12:56:23 *** lmat has quit IRC
13:10:36 *** aqua___ has quit IRC
13:11:45 *** aqua___ has joined #gnucash
13:13:25 *** aqua___ has quit IRC
13:52:06 *** Krzysiek_K has joined #gnucash
13:53:58 *** aqua___ has joined #gnucash
13:57:32 *** aqua___ has joined #gnucash
14:12:27 *** cartsoftware has quit IRC
14:12:37 *** aqua___ has quit IRC
14:12:56 *** GabrieleV_ has joined #gnucash
14:12:58 *** GabrieleV has quit IRC
14:12:59 *** GabrieleV_ is now known as GabrieleV
14:13:26 *** cartsoftware has joined #gnucash
14:16:36 *** aqua___ has joined #gnucash
14:20:35 *** wizkid238 has quit IRC
14:23:53 *** aqua___ has quit IRC
14:28:06 *** aqua___ has joined #gnucash
14:28:07 *** wizkid238 has joined #gnucash
14:28:19 *** aqua___ has quit IRC
14:29:42 *** aqua___ has joined #gnucash
14:32:24 *** aqua___ has quit IRC
14:35:22 *** aqua___ has joined #gnucash
14:50:15 *** Hinnerk has joined #gnucash
14:50:18 <Hinnerk> hi
14:50:23 <Hinnerk> question about sx
14:50:32 <Hinnerk> I had a monthly sx.
14:50:39 <Hinnerk> for a few years now.
14:50:45 <Hinnerk> and discovered a mistake.
14:51:04 <Hinnerk> so I would like to rerun the entire sx's of the last couple of years.
14:51:31 <Hinnerk> So I went into the editor and changed everything (formula, starting date, end date)
14:51:42 <Hinnerk> then I triggered "Since last..."
14:51:46 <Hinnerk> nothing happened.
14:51:48 <Hinnerk> Why?
14:51:58 <Hinnerk> What do I need to do to reuse the old sx?
14:52:04 <Hinnerk> Or do I have to create a new one?
14:52:33 <Hinnerk> (copying it is tedious work, as there is no fast way to copy these, right?)
14:55:58 <cphuntington97> is it repeat day on here? :P
14:56:39 <warlord> Hinnerk: there is no way in the UI (AFAIK) to reset the 'most recent run date'
15:17:07 <Hinnerk> and no way to copy an existing sx definition?
15:19:04 *** mlncn has quit IRC
15:19:12 *** angeloreale has joined #gnucash
15:26:01 <Hinnerk> umpf
15:26:10 <Hinnerk> so I now entered the sx manually.
15:26:14 <Hinnerk> didn't work.
15:26:23 <Hinnerk> the variable parts do not change over time.
15:26:29 <Hinnerk> I didn't use the wizzard.
15:26:35 <Hinnerk> Should be ok anyway?
15:26:44 <Hinnerk> I'm using latest version of course.
15:37:09 *** MechtiIde has quit IRC
15:38:03 *** nomeata has joined #gnucash
16:22:38 *** codesmythe has joined #gnucash
16:29:36 *** angeloreale has quit IRC
16:32:19 *** len has joined #gnucash
16:34:09 *** mlncn has joined #gnucash
16:52:45 *** Hinnerk has quit IRC
17:16:49 *** nomeata has quit IRC
17:23:42 *** mlncn has quit IRC
17:44:11 *** aqua___ has quit IRC
17:49:05 *** codesmythe has quit IRC
17:57:09 *** rickoehn has quit IRC
18:03:40 *** cartsoftware has quit IRC
18:04:12 *** cartsoftware has joined #gnucash
18:12:25 *** mlncn has joined #gnucash
18:14:41 *** Krzysiek_K has left #gnucash
18:26:56 *** StuM has joined #gnucash
18:45:45 *** mlncn has quit IRC
19:49:39 *** mlncn has joined #gnucash
20:08:10 *** anything has joined #gnucash
20:08:36 <anything> using gnucash 2.6.0 on mageia 4
20:08:52 <anything> created several STOCK subaccounts under one ASSET account. Added some transactions to the STOCK accounts with non-zero prices, but total no longer appears in the ASSET account total.
20:09:06 <anything> It did originally, but no longer shows the ttotal value of the stock accounts.
20:09:20 <anything> I am using STOCK in lieu of a true inventory module, as advised in several forums re gnucash
20:09:32 <anything> (I am referring to the ACCOUNTS tab when I talk about account hierarchy and values)
20:09:40 <anything> thank you for any help you can offer
20:10:43 *** cartsoftware has quit IRC
20:12:46 <anything> I'm building 2.6.5 here just to see if that resolves the problem.
20:14:57 <warlord> anything: yeah, 2.6.5 is current.
20:15:24 <warlord> Do you have a PriceDB entry for the current prices of you stocks?
20:15:35 <warlord> and do you have a Total(CUR) column enabled in your CoA?
20:19:45 <anything> oh, no. I don't think so. I am using it for inventory, but the rules still aply?
20:24:31 <anything> I am still installing packages to support building 2.6.5, and there's a lot. Meanwhile, gnucash 2.6.0 has stopped behaving as expected -- edit account is not working.
20:25:35 <anything> I am thinking some libraries are changing while gnucash is running, though that shoudln't affect a running Linux program, unless ldconfig is still running in background...
20:27:05 <anything> oh! I see. Installing these newer libraries forced removal of gnucash 2.6.0 -- drat.
20:35:35 *** codesmythe has joined #gnucash
20:45:44 <warlord> That would do it...
20:46:37 <anything> thanks for your help. I have a total column in the accounts, otherwise, I would not have seen it originally. But as far as the pricedb, is that a feature of 2.6.0? Since I can no longer run it, I cannot tell.
20:47:36 <anything> I am (finally!) building 2.6.5
20:49:52 <warlord> pricedb has been in gnucash as long as I can remember
20:50:14 <anything> I don't recall if I created entries in pricedb.
20:50:29 <warlord> and I don't mean "total" column, I mean "Total(CUR)".. E.g. Total(USD). Also, this total column is in the Chart of Accounts, on the Asset Register.
20:51:33 <anything> 2.6.5 is still building. As soon as I can run it, I will check. Again, thanks so much
20:51:40 <warlord> No problem.
20:51:49 <anything> (I just don't remember off top of my head right now)
20:51:52 <warlord> I may be AFK here and there.
20:52:01 <warlord> Well, were you looking in the CoA or register?
20:52:57 <anything> In the tab "ACCOUNTS" I saw totals for each account, and there were totals for subaccounts also. Except recently when those totals disappeared.
20:53:44 <anything> the superaccount is a placeholder
20:53:50 <anything> (or is that wrong?)
20:53:51 <warlord> sure.
20:53:54 <warlord> no, not wrong
20:53:59 <anything> (I tried it both ways)
20:54:00 <anything> OK
20:54:40 <warlord> Lack of total(USD) (note I keep saying that, not 'total') implies no price entry.
20:55:08 <warlord> 'total' will remain empty because you have no transactions in the top level; it cannot roll up.
20:55:22 <anything> !!!
20:55:39 <warlord> Actually, that's wrong.
20:55:42 <anything> well, let me explain what I was thinking and I know it may be wrong
20:55:55 <warlord> The parent account total should still give you totals, but you still need pricedb entries.
20:56:06 <anything> still building...
20:56:30 <anything> This is a 4 year old HW architecture (AMD 3, not even 3+)
20:57:11 <anything> and I had to downgrade my mainboard due to the old one failing and not having funds for anything similar. Ridiculous, but that's how titght it has been here.
20:57:33 <warlord> :(
20:59:25 <anything> yeah, 12GB to 8GB. I do virtualization so that's not a lot to work with really
20:59:41 <anything> good grief, still building
21:03:12 <anything> bad build I think. I'm getting an error at launch
21:03:34 <anything> "(process:20274): GLib-WARNING **: GError set over the top of a previous GError or uninitialized memory. This indicates a bug in someone's code. You must ensure an error is NULL before it's set. The overwriting error message was: No such file or directory Trace/breakpoint trap"
21:03:53 <anything> I did nothing to the code, honestly. Just ./configure and make
21:04:35 <anything> I'm wondering if I should revert to 2.6.0 for now. Just to get this problem sorted out, since I know your time must be valuable.
21:12:04 <warlord> anything: that might be worthwhile..
21:17:55 *** anything has quit IRC
21:20:55 *** anything has joined #gnucash
21:21:10 <anything> just got knocked off
21:24:10 <anything> warlord: I see the price editor and it looks like all my products have the same code -- I am guessing that is a fail, huh?
21:24:22 <anything> each product needs to have its own ID?
21:24:34 <anything> because it has to have its own price, etc.
21:38:19 <anything> YES!
21:38:41 <anything> thanks. After filling in the required info, the CofA now displays the total values of the products.
21:38:55 <anything> (helps if one understands what they are SUPPOSED to do...)
21:39:19 <anything> Now my only question is should these be my cost, or my selling prices?
21:39:32 <anything> I put them in as my own cost, and I'll charge them off as COGS.
21:39:41 <anything> but maybe there is a better or more correct way?
22:04:00 *** GabrieleV_ has joined #gnucash
22:04:04 *** GabrieleV has quit IRC
22:04:04 *** GabrieleV_ is now known as GabrieleV
22:16:59 <warlord> anything: well, what's in the pricedb is your 'value'. you should enter your 'purchase' at the price you buy, and your 'sale' at the privce you sell.
22:18:00 <anything> Being this is inventory, this means there will be 2 entries (at different points of course) for the purchase and the sale, and each will have a different "value" -- do I have this right?
22:18:50 <anything> but what I was going to do was simply make a 4-entry transaction, debiting cash and COGS and crediting revenue and inventory.
22:19:01 <anything> (at the time of sale)
22:19:38 <anything> otherwise, the transaction will be unbalanced (I tried this). then what to do with the imbalance, which is actually profit
22:20:04 <anything> I suppose that could be recorded as revenue or maybe a new account called profit
22:20:28 <anything> It's been 30 years or more since I took Accounting
22:23:08 <anything> I guess either way is OK, but I think it could be confusing to my client using one or the other method.
22:23:40 *** StuM has quit IRC
22:50:35 *** codesmythe has quit IRC