2015-07-13 GnuCash IRC logs
00:06:01 *** ron_frown has quit IRC
00:06:15 *** ron_frown has joined #gnucash
00:13:01 *** cartsoftware has quit IRC
00:28:05 *** ron_frown has quit IRC
00:31:03 *** ron_frown has joined #gnucash
00:51:21 *** ron_frown has quit IRC
01:19:31 *** MechtiIde has joined #gnucash
01:26:00 *** MechtiIde has quit IRC
01:26:25 *** O01eg has quit IRC
01:26:47 *** MechtiIde has joined #gnucash
02:00:05 *** MechtiIde has quit IRC
02:38:15 *** aqua___ has joined #gnucash
03:05:53 *** fabior has joined #gnucash
04:19:53 *** cartsoftware has joined #gnucash
04:23:57 *** aqua___ has quit IRC
04:33:49 *** cartsoftware has quit IRC
04:36:21 *** k4i has joined #gnucash
04:48:53 *** cartsoftware has joined #gnucash
04:51:57 *** cartsoftware has quit IRC
05:11:37 *** andy has quit IRC
05:21:28 *** andy has joined #gnucash
05:22:10 *** nomeata has joined #gnucash
05:27:06 *** rubdos has joined #gnucash
05:51:42 *** cartsoftware has joined #gnucash
06:10:36 *** storyjesse has joined #gnucash
06:20:13 *** mlncn has joined #gnucash
06:27:16 *** mlncn has quit IRC
06:31:44 <chazdiezal> jralls: thanks for the reply, i'm using the sql backend, do you know which table the attachments are stored in?
06:58:28 *** Jimraehl1 has left #gnucash
06:59:10 *** Jimraehl1 has joined #gnucash
07:03:20 *** cartsoftware has quit IRC
07:08:00 *** fabior has quit IRC
07:31:50 *** mlncn has joined #gnucash
07:37:24 *** chazdiezal has quit IRC
07:40:54 *** mlncn__ has joined #gnucash
07:42:52 *** mlncn has quit IRC
07:45:38 *** himaxx has joined #gnucash
07:48:22 *** rickoehn has joined #gnucash
07:51:07 *** himaxx has quit IRC
07:59:29 *** rickoehn1 has joined #gnucash
08:00:07 *** rickoehn has quit IRC
08:12:30 *** mlncn__ has quit IRC
08:12:44 *** chazdiezal has joined #gnucash
08:13:07 *** mlncn_ has joined #gnucash
08:31:11 *** mlncn_ has quit IRC
08:31:22 *** mlncn has joined #gnucash
08:38:41 <warlord> chazdiezal: the attachments are not stored in the database, only the URI is stored, in the KVP (slots)
09:02:45 *** rickoehn1 has quit IRC
09:13:12 *** rickoehn has joined #gnucash
09:20:54 *** rickoehn has quit IRC
09:26:23 *** fabior has joined #gnucash
09:28:47 *** rickoehn has joined #gnucash
09:35:38 *** storyjesse has quit IRC
09:35:54 *** rickoehn has quit IRC
09:43:02 *** andy has quit IRC
09:48:10 *** himaxx has joined #gnucash
09:48:45 *** himaxx has quit IRC
10:28:41 *** andy has joined #gnucash
10:33:21 *** nomeata has quit IRC
10:40:29 *** chazdiezal1 has joined #gnucash
10:41:15 *** chazdiezal has quit IRC
11:08:29 *** rickoehn has joined #gnucash
11:17:03 *** cartsoftware has joined #gnucash
11:28:20 *** rubdos has quit IRC
11:30:54 *** chazdiezal has joined #gnucash
11:33:12 *** chazdiezal1 has quit IRC
12:01:53 *** O01eg has joined #gnucash
12:12:59 *** cartsoftware has quit IRC
12:13:19 *** himaxx has joined #gnucash
12:16:14 *** mlncn has quit IRC
12:16:38 *** mlncn has joined #gnucash
12:18:42 *** himaxx has quit IRC
12:19:47 *** edogawaconan1 has joined #gnucash
12:19:49 *** edogawaconan1 is now known as nanaya
12:19:51 *** nomeata has joined #gnucash
12:23:26 *** cartsoftware has joined #gnucash
12:25:36 <nanaya> hi, I'm migrating data from my excel file to gnucash but I don't know how to handle this kind of transaction: https://0paste.tk/7693-ec58d565.txt
12:27:21 <nanaya> should I put the first transaction to liability/accounts-payable + expense and then later add another entry to a/p + creditcard?
12:31:25 *** chazdiezal has quit IRC
12:32:53 *** chazdiezal has joined #gnucash
12:37:39 <warlord> I dont understand these two transactions -- what exactly does it mean?
12:38:04 <nanaya> it's single entry book
12:38:28 <nanaya> I pre-order something using credit card (which will be charged in the future)
12:38:46 <nanaya> I mark it as current date's expense but the charge date will happen in the future
12:39:02 <nanaya> charge date is mainly to match it with credit card statement
12:39:26 <nanaya> entry date is when the expense happen
12:39:58 <warlord> Ignore #2
12:40:29 <nanaya> which account should #1 marked against
12:41:28 <warlord> the correct expense account
12:41:35 <warlord> #1 is CC -> Expense
12:41:44 <warlord> #2 --- is not a real transaction
12:42:22 <nanaya> I'd have problem matching it with credit card statement
12:42:38 <warlord> during reconciliation?
12:42:57 <warlord> I dont understand what "problem" you're having
12:43:08 <nanaya> sometimes I don't know which entry is which purchase from card statement
12:43:23 <warlord> Do you have many purchases at the same amount?
12:43:31 <nanaya> sometimes, yeah
12:43:40 <nanaya> also new statements don't always appear at the bottom
12:43:57 <nanaya> it sometimes just appear at the top... or wherever it's charged
12:45:13 <nanaya> (I check the statement almost daily)
12:47:24 <warlord> This is what the reconcile process is for -- to give you the ability to match your statement to your account on a monthly basis. Order doesn't matter
12:48:28 <nanaya> hmm
12:50:00 <nanaya> I'll try
12:51:12 <nanaya> also, can I, for example, import my account from one point (say jan 1st this year) with opening balance and all and then later readd data from previous years?
12:54:10 <warlord> Not if you reconcile.
12:54:31 <warlord> Once you reconcile you've locked your start-date
12:55:45 <nanaya> so I just keep the opening balances open?
12:56:08 <nanaya> ergh, can it even work
12:58:00 <nanaya> (also I still need to read more about reconcile process)
12:59:16 <warlord> Or you just start cleanly
12:59:28 <nanaya> cleanly?
12:59:32 <warlord> Yep.
12:59:40 <warlord> Make a clean break/start
12:59:49 <warlord> (i.e., ignore history from before your start date)
13:00:50 <elb> while there's activity ... I have set my invoice format to 2015-%06d for a business book, but the format being used for invoices appears to be %06d; glancing at the source code suggests that it should be doing what I expect, which is creating an invoice ID that is (e.g.) 2015-000033 for invoice counter value 33; any ideas what I'm doing wrong?
13:01:46 <nanaya> I guess I should do that to familiarise myself with gnucash
13:01:59 <warlord> elb: Are you sure that %06d is the correct format string?
13:03:07 <elb> I don't understand the question
13:03:35 <elb> I am sure that sprintf(dest, "2015-%06d", 33) wuld result in "2015-000033" formatted into dest
13:03:57 *** MechtiIde has joined #gnucash
13:03:58 <nanaya> also, is there common convention for structuring accounts in multi currency? assets > (cash-usd, cash-eur)? or assets > cash > (usd, eur)? Last time I tried the latter I hit into weird problem (autocomplete was it?)
13:04:34 <warlord> elb: yes, but.... that input isn't a "fully sprint compliant" input string.
13:04:48 <elb> OK, the docs said it was a printf format
13:05:04 <warlord> It's a printf-like format, but it needs to be "correct" for your platform.
13:05:13 <elb> and the qof formatting function uses g_strdup_printf
13:05:22 <elb> (which would work with that format)
13:05:39 <warlord> nanaya: you're probably better off asking on the gnucash-user mailing list.
13:05:48 <warlord> elb: what OS/Distro/CPU are you using?
13:06:00 <elb> Debian 8, AMD64
13:06:09 <nanaya> ok
13:09:18 <warlord> hmm.. I think %d should work, then
13:10:20 <elb> that was my conclusion
13:10:35 <elb> I traced this all the way from the business-invoice dialog source to teh qof book counter manipulation
13:10:39 <elb> and I don't see why it wouldn'tw ork
13:10:43 <elb> but I didn't know if there was something I'm missing
13:11:19 <elb> it gets the counter value correctly, just not the format
13:11:43 <elb> or it doesn't apply it correctly, or it's being truncated somewhere, or *something*
13:11:58 <elb> I didn't know if maybe - was illegal in an invoice number and I just couldn't find it, or what
13:12:28 <warlord> Nah,the InvoiceID is just a string
13:17:37 *** mlncn has quit IRC
13:32:14 *** chazdiezal1 has joined #gnucash
13:33:32 *** chazdiezal has quit IRC
13:33:48 *** mlncn_ has joined #gnucash
13:56:58 *** mlncn_ has quit IRC
13:59:04 *** fabior has quit IRC
14:21:49 *** andy_ has joined #gnucash
14:21:50 *** andy has quit IRC
14:31:50 <elb> well, if any ideas come up, I'm all ears
14:32:10 <elb> becuase I'd really like to continue to keep year numbers on my invoice IDs, but not enter them all manually :-)
14:32:16 *** chazdiezal1 has quit IRC
14:32:42 *** chazdiezal has joined #gnucash
14:33:27 <warlord> I've never used that feature, so I'm afraid I don't know what to suggest. You could try asking on -user?
14:33:53 *** chazdiezal1 has joined #gnucash
14:35:54 *** chazdiezal has quit IRC
14:38:35 *** chazdiezal1 has quit IRC
14:39:33 *** MechtiIde has quit IRC
14:42:28 *** chazdiezal has joined #gnucash
14:50:31 <elb> fair
14:54:35 *** chazdiezal1 has joined #gnucash
14:54:39 *** chazdiezal has quit IRC
14:55:34 *** andy__ has joined #gnucash
14:55:44 *** andy_ has quit IRC
14:55:45 *** chazdiezal1 has quit IRC
14:56:07 *** chazdiezal has joined #gnucash
15:08:27 *** mlncn has joined #gnucash
15:18:13 *** chazdiezal has quit IRC
15:18:34 *** chazdiezal has joined #gnucash
15:23:17 *** rpg has joined #gnucash
15:32:10 *** fabior has joined #gnucash
15:34:51 *** himaxx has joined #gnucash
15:49:30 *** himaxx has quit IRC
15:51:29 *** mlncn has quit IRC
15:59:19 *** andy has joined #gnucash
15:59:20 *** andy__ has quit IRC
16:09:40 *** jeffsf has quit IRC
16:09:41 *** jeffsf has joined #gnucash
16:14:14 *** chazdiezal1 has joined #gnucash
16:16:12 *** chazdiezal has quit IRC
16:16:58 *** nomeata has quit IRC
16:20:47 *** andy has quit IRC
16:20:57 *** andy has joined #gnucash
16:25:17 *** aqua___ has joined #gnucash
16:35:03 *** rpg has quit IRC
16:35:10 *** cartsoftware has quit IRC
16:35:42 *** cartsoftware has joined #gnucash
16:36:53 *** mlncn has joined #gnucash
16:43:30 *** fabior has quit IRC
17:08:26 *** aqua___ has quit IRC
17:11:26 *** rpg has joined #gnucash
17:33:25 *** rpg has quit IRC
17:59:38 *** rickoehn has quit IRC
18:13:27 *** mlncn has quit IRC
19:04:00 *** Nytram has joined #gnucash
19:14:45 *** Nytram has quit IRC
19:32:24 *** warlord has quit IRC
20:22:02 *** jimvideo has joined #gnucash
20:37:04 *** mlncn has joined #gnucash
21:51:08 *** mlncn has quit IRC
21:56:01 *** rpg has joined #gnucash
22:01:55 *** ron_frown has joined #gnucash
22:36:29 *** fell has joined #gnucash
22:37:31 *** rpg has quit IRC
23:02:17 *** rpg has joined #gnucash
23:28:39 *** warlord has joined #gnucash
23:28:40 *** gncbot sets mode: +o warlord
23:39:11 *** mlncn has joined #gnucash
23:58:23 *** fell_ has joined #gnucash