No, but you can use Edit>Find to select transactions and then run an Account Report.
Regards, John Ralls > On Jul 6, 2019, at 5:44 PM, Su Fan <[email protected]> wrote: > > Hi, > > Is there any way to select specific transactions to be printed on the > General Journal Report? > > Fred > > > > > > > On Sun, Jul 7, 2019 at 12:01 AM <[email protected]> wrote: > >> Send gnucash-user mailing list submissions to >> [email protected] >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> or, via email, send a message with subject or body 'help' to >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of gnucash-user digest..." >> >> >> Today's Topics: >> >> 1. Re: Reconcile Flag when Importing Transactions from CSV (Patrick) >> 2. Bulk export/import of transactions? (Eric H. Bowen) >> 3. Re: Bulk export/import of transactions? (D) >> 4. Re: Bulk export/import of transactions? (Eric H. Bowen) >> 5. Re: Multi column Income Statement (Christopher Lam) >> 6. Re: Bulk export/import of transactions? ([email protected]) >> 7. Re: Bulk export/import of transactions? (Geert Janssens) >> 8. Re: Multi column Income Statement (Stephen C. Camidge) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Fri, 5 Jul 2019 14:52:05 -0500 >> From: Patrick <[email protected]> >> To: Gnucash Users <[email protected]> >> Subject: Re: [GNC] Reconcile Flag when Importing Transactions from CSV >> Message-ID: >> < >> cajockq6ckkfslxi9e2uvxzk_upztc3gxq0p-7p-cdo0ejsx...@mail.gmail.com> >> Content-Type: text/plain; charset="UTF-8" >> >> In case someone else comes across this and is looking for a temporary >> workaround, this is what I did. >> >> In my local copy, I changed this line >> >> >> https://github.com/Gnucash/gnucash/blob/maint/gnucash/import-export/import-backend.c#L924 >> >> to use "NREC" instead of "CREC". >> >> File: gnucash/import-export/import-backend.c >> Function: gnc_import_process_trans_item() >> case GNCImport_ADD >> >> Old line >> xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), CREC); >> >> New line >> xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), NREC); >> >> On Tue, Jul 2, 2019 at 6:58 AM Patrick <[email protected]> wrote: >> >>> I was looking through the bug reports on Bugzilla, and I think there >> might >>> already be an outstanding request (#796890) to adjust this behavior. >>> >>> I think that means my best options are to be patient or to stare >>> at gnc-imp-props-tx.cpp for a while. >>> >>> https://bugs.gnucash.org/show_bug.cgi?id=796890 >>> >>> On Mon, Jul 1, 2019 at 7:33 AM Patrick <[email protected]> wrote: >>> >>>> When I am importing transactions from a CSV, I have a "Reconcile" column >>>> that I select as the "Transfer Reconciled" column in the import wizard. >> I >>>> have all of the entries marked as "n" in this column, but after >> importing >>>> them, some of them seem to still show up as "c". Am I misunderstanding >> the >>>> "Transfer Reconciled" option, or am I likely doing something else wrong? >>>> >>>> I'm not sure if it is relevant, but I am importing in multi-split mode. >>>> >>>> Regards, >>>> Patrick >>>> >>> >> >> >> ------------------------------ >> >> Message: 2 >> Date: Fri, 5 Jul 2019 20:34:04 -0500 >> From: "Eric H. Bowen" <[email protected]> >> To: [email protected] >> Subject: [GNC] Bulk export/import of transactions? >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset="utf-8" >> >> I'm a fairly new GnuCash user, and last year I set up an account for a >> part-time business which i have doing video work. Unfortunately, being >> unfamiliar with GnuCash, I made some mistakes while reconciling accounts >> in the early months which I now cannot change or correct. I'd like to >> basically start over with a new worksheet, but I spent a lot of time >> entering split transactions and such in the old one to account for >> equipment costs and depreciation. I'd rather not re-invent the wheel. Is >> there a way to bulk export transactions from the old worksheet and then >> re-import them into the new worksheet which preserves split information >> and other notes? >> >> -- >> >> --------Eric H. Bowen >> [email protected] <mailto:[email protected]> >> -------------- next part -------------- >> A non-text attachment was scrubbed... >> Name: smime.p7s >> Type: application/pkcs7-signature >> Size: 3993 bytes >> Desc: S/MIME Cryptographic Signature >> URL: < >> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190705/8c54f4af/attachment-0001.p7s >>> >> >> ------------------------------ >> >> Message: 3 >> Date: Sat, 06 Jul 2019 08:43:53 +0530 >> From: D <[email protected]> >> To: "Eric H. Bowen" <[email protected]>, Gnucash Users >> <[email protected]> >> Subject: Re: [GNC] Bulk export/import of transactions? >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset=utf-8 >> >> Eric, >> >> In version 3, there is an export to csv that can be used, I believe. >> >> Before you do that however, perhaps you could explain why you say you >> cannot change or correct the problems? Maybe those problems aren't as >> intractable as you think. It's been my experience that most any problem can >> be fixed in Gnucash. >> >> David T. >> >> On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" < >> [email protected]> wrote: >> >> I'm a fairly new GnuCash user, and last year I set up an account for a >> part-time business which i have doing video work. Unfortunately, being >> unfamiliar with GnuCash, I made some mistakes while reconciling accounts >> in the early months which I now cannot change or correct. I'd like to >> basically start over with a new worksheet, but I spent a lot of time >> entering split transactions and such in the old one to account for >> equipment costs and depreciation. I'd rather not re-invent the wheel. Is >> there a way to bulk export transactions from the old worksheet and then >> re-import them into the new worksheet which preserves split information >> and other notes? >> >> -- >> >> --------Eric H. Bowen >> [email protected] <mailto:[email protected]> >> >> ------------------------------ >> >> Message: 4 >> Date: Fri, 05 Jul 2019 22:50:29 -0500 >> From: "Eric H. Bowen" <[email protected]> >> To: D <[email protected]>, Gnucash Users <[email protected]> >> Subject: Re: [GNC] Bulk export/import of transactions? >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset=utf-8 >> >> My problem stems from the fact that I started the business in April, but >> was purchasing equipment for it from the beginning of the year. After I had >> the first few months (April to July) in and reconciled, I belatedly >> realized that I needed to go back and include my purchase transactions from >> the first of the year. But since I already had several months reconciled, >> when I added the earlier transactions I ended up with a mess. If there's >> any way to reverse the reconciliations as they stand now, I'm not aware of >> it. That would be preferable to starting over. >> >> >> >> Sent from my BlackBerry - the most secure mobile device >> >> >> ? Original Message ? >> >> >> >> From: [email protected] >> Sent: July 5, 2019 10:14 PM >> To: [email protected]; [email protected] >> Subject: Re: [GNC] Bulk export/import of transactions? >> >> >> Eric, >> >> In version 3, there is an export to csv that can be used, I believe. >> >> Before you do that however, perhaps you could explain why you say you >> cannot change or correct the problems? Maybe those problems aren't as >> intractable as you think. It's been my experience that most any problem can >> be fixed in Gnucash. >> >> David T. >> >> On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" < >> [email protected]> wrote: >> >> I'm a fairly new GnuCash user, and last year I set up an account for a >> part-time business which i have doing video work. Unfortunately, being >> unfamiliar with GnuCash, I made some mistakes while reconciling accounts >> in the early months which I now cannot change or correct. I'd like to >> basically start over with a new worksheet, but I spent a lot of time >> entering split transactions and such in the old one to account for >> equipment costs and depreciation. I'd rather not re-invent the wheel. Is >> there a way to bulk export transactions from the old worksheet and then >> re-import them into the new worksheet which preserves split information >> and other notes? >> >> -- >> >> --------Eric H. Bowen >> [email protected] <mailto:[email protected]> >> >> ------------------------------ >> >> Message: 5 >> Date: Sat, 6 Jul 2019 03:59:14 +0000 >> From: Christopher Lam <[email protected]> >> To: Stephen Camidge <[email protected]> >> Cc: GnuCash users group <[email protected]> >> Subject: Re: [GNC] Multi column Income Statement >> Message-ID: >> <CAKVAZZJ2+kyx0SckH8EgzOVT0y3L= >> [email protected]> >> Content-Type: text/plain; charset="UTF-8" >> >> Glad you like it. The subtotals are styled as such to highlight they >> include >1 account totals. >> Try Display/Parent account amounts include children option. >> >> On Fri, 5 Jul 2019 at 12:54, Stephen Camidge <[email protected]> wrote: >> >>> Most welcome report! >>> >>> Flaw - subaccount totals are double size & black >>> >>> >>> -- >>> >>> Stephen C. [email protected](519) 363-3912 >>> >>> >>> >>> >>> <https://www.postbox-inc.com> >>> _______________________________________________ >>> gnucash-user mailing list >>> [email protected] >>> 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. >>> >> >> >> ------------------------------ >> >> Message: 6 >> Date: Sat, 6 Jul 2019 11:31:30 +0530 >> From: <[email protected]> >> To: "'Eric H. Bowen'" <[email protected]>, "'Gnucash Users'" >> <[email protected]> >> Subject: Re: [GNC] Bulk export/import of transactions? >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset="utf-8" >> >> Ok. This comes up from time to time. Others may chime in with additional >> pointers, but here's how I'd go about it. >> >> 1) I would change the date of the Opening Balance transaction to the day >> before your starting date (December 31, 2017 for example), and change the >> amounts of both lines in this transaction (i.e., both the debit and the >> credit) to reflect the amount on that date. So, if your checking account >> April 1 opening balance entry is $500, but your December 31 balance was >> $350, change the debit and credit amount in the Opening Balance transaction >> from $500 to $350 and set the date to December 31. >> 2) I would then enter every transaction in the gap period. >> 3) I would then take the hopeful step of pulling my *most recent* >> reconciled statement and trying to re-reconcile. Presumably, the only >> differences between the previous reconciliation and this pass will be the >> transactions you entered from the previous gap period, and when you select >> all these earlier transactions, it should balance out, and you can finish >> the reconciliation. If this works, then you are done with the process. >> >> If for some reason this doesn't work, you'd most likely have to >> de-reconcile everything then and work through month by month from bank >> statements, which would pinpoint the discrepancies and allow you to work >> them out. This, admittedly, is much more painful, and off the top of my >> head, I cannot think of a simple way to reset the reconcile tag. This is >> not to say it can't be done; just that I haven't really given it thought. >> If it were me, I'd probably take the data into an SQL backend, and figure >> out how to use SQL to change the reconcile flag for that account. Of >> course, that's a quick way to screw up you data permanently, so if you need >> to go that route, the usual warnings apply (Work on a backup, damages >> cannot be fixed by others, etc.) >> >> HTH, >> David T. >> >> >> -----Original Message----- >> From: Eric H. Bowen <[email protected]> >> Sent: Saturday, July 6, 2019 9:20 AM >> To: D <[email protected]>; Gnucash Users <[email protected]> >> Subject: Re: [GNC] Bulk export/import of transactions? >> >> My problem stems from the fact that I started the business in April, but >> was purchasing equipment for it from the beginning of the year. After I had >> the first few months (April to July) in and reconciled, I belatedly >> realized that I needed to go back and include my purchase transactions from >> the first of the year. But since I already had several months reconciled, >> when I added the earlier transactions I ended up with a mess. If there's >> any way to reverse the reconciliations as they stand now, I'm not aware of >> it. That would be preferable to starting over. >> >> >> >> Sent from my BlackBerry - the most secure mobile device >> >> >> Original Message >> >> >> >> From: [email protected] >> Sent: July 5, 2019 10:14 PM >> To: [email protected]; [email protected] >> Subject: Re: [GNC] Bulk export/import of transactions? >> >> >> Eric, >> >> In version 3, there is an export to csv that can be used, I believe. >> >> Before you do that however, perhaps you could explain why you say you >> cannot change or correct the problems? Maybe those problems aren't as >> intractable as you think. It's been my experience that most any problem can >> be fixed in Gnucash. >> >> David T. >> >> On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" < >> [email protected]> wrote: >> >> I'm a fairly new GnuCash user, and last year I set up an account for a >> part-time business which i have doing video work. Unfortunately, being >> unfamiliar with GnuCash, I made some mistakes while reconciling accounts in >> the early months which I now cannot change or correct. I'd like to >> basically start over with a new worksheet, but I spent a lot of time >> entering split transactions and such in the old one to account for >> equipment costs and depreciation. I'd rather not re-invent the wheel. Is >> there a way to bulk export transactions from the old worksheet and then >> re-import them into the new worksheet which preserves split information and >> other notes? >> >> -- >> >> --------Eric H. Bowen >> [email protected] <mailto:[email protected]> >> >> >> >> ------------------------------ >> >> Message: 7 >> Date: Sat, 06 Jul 2019 11:03:57 +0200 >> From: Geert Janssens <[email protected]> >> To: [email protected], [email protected] >> Cc: "'Eric H. Bowen'" <[email protected]> >> Subject: Re: [GNC] Bulk export/import of transactions? >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset="us-ascii" >> >> Op zaterdag 6 juli 2019 08:01:30 CEST schreef sunfish62--- via >> gnucash-user: >>> Ok. This comes up from time to time. Others may chime in with additional >>> pointers, but here's how I'd go about it. >>> >>> 1) I would change the date of the Opening Balance transaction to the day >>> before your starting date (December 31, 2017 for example), and change the >>> amounts of both lines in this transaction (i.e., both the debit and the >>> credit) to reflect the amount on that date. So, if your checking account >>> April 1 opening balance entry is $500, but your December 31 balance was >>> $350, change the debit and credit amount in the Opening Balance >> transaction >>> from $500 to $350 and set the date to December 31. 2) I would then enter >>> every transaction in the gap period. >>> 3) I would then take the hopeful step of pulling my *most recent* >> reconciled >>> statement and trying to re-reconcile. Presumably, the only differences >>> between the previous reconciliation and this pass will be the >> transactions >>> you entered from the previous gap period, and when you select all these >>> earlier transactions, it should balance out, and you can finish the >>> reconciliation. If this works, then you are done with the process. >>> >>> If for some reason this doesn't work, you'd most likely have to >> de-reconcile >>> everything then and work through month by month from bank statements, >> which >>> would pinpoint the discrepancies and allow you to work them out. This, >>> admittedly, is much more painful, and off the top of my head, I cannot >>> think of a simple way to reset the reconcile tag. >> >> That's actually really simple: you click on each "Y" in the reconcile >> column >> to unreconcile a transaction. You will get a warning for what you are >> about to >> undo. If you have many to unreconcile, save your choice for the current >> session so the warning will not continue to pop up while you're resetting. >> >> If you don't get this warning and instead can't unreconcile, that probably >> means you have in the past told gnucash to not carry on with the action >> and >> remember that decision for the future. That warning can then be reset via >> Actions->Reset warnings. >> >> Do note that this may give unexpected starting balances on the next >> reconciliation action. Normally whatever gnucash proposes a starting >> balance >> should be kept. Only the ending balance on the reconcile date should be >> set to >> what is on the bank statements. >> >> Regards, >> >> Geert >> >> >> >> >> ------------------------------ >> >> Message: 8 >> Date: Sat, 06 Jul 2019 07:19:27 -0400 >> From: "Stephen C. Camidge" <[email protected]> >> To: "Christopher Lam" <[email protected]> >> Cc: "GnuCash users group" <[email protected]> >> Subject: Re: [GNC] Multi column Income Statement >> Message-ID: <[email protected]> >> Content-Type: text/plain >> >> No change, subaccounts still double size & black. >> >> >> On Fri, Jul 5, 2019, at 11:59 PM, Christopher Lam wrote: >>> Glad you like it. The subtotals are styled as such to highlight they >> include >1 account totals. >>> Try Display/Parent account amounts include children option. >>> >>> On Fri, 5 Jul 2019 at 12:54, Stephen Camidge <[email protected]> >> wrote: >>>> Most welcome report! >>>> >>>> Flaw - subaccount totals are double size & black >>>> >>>> >>>> -- >>>> >>>> Stephen C. [email protected](519) 363-3912 >>>> >>>> >>>> >>>> >>>> <https://www.postbox-inc.com> >>>> _______________________________________________ >>>> gnucash-user mailing list >>>> [email protected] >>>> 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. >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> >> gnucash-user mailing list >> [email protected] >> 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. >> >> >> ------------------------------ >> >> End of gnucash-user Digest, Vol 196, Issue 17 >> ********************************************* >> > _______________________________________________ > gnucash-user mailing list > [email protected] > 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 [email protected] 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.
