Re: [GNC] Export Invoice to CSV
Thank you Adrien!! :-D - Axel — Axel Essbaum a...@essbaum.com > On 5 Dec 2019, at 18:05, Adrien Monteleone > wrote: > > Not explicitly, but there are two methods that might get you something useful. > > #1 - ‘Print’ the invoice (to the screen) then either copy/paste into a > spreadsheet (Excel has issues at times, but Open/Libreoffice works well, as > does Numbers) export it to html and then open with said spreadsheet. This > will get you all the info in individual cells, but it will look like the > printed version, and won’t be laid out like a CSV with rows as line items. > > #2 - For posted invoices, make sure the option to ‘Accumulate Splits’ is > *not* selected. This will make each invoice line item its own split in the > affected registers. You can then export or run a Transaction Report (and then > copy/paste) on the AR/AP or other relevant registers. > > Regards, > Adrien > >> On Dec 5, 2019 w49d339, at 10:28 AM, Axel Essbaum wrote: >> >> >> Hello all, >> >> I have been using GnuCash for 10 years, currently running GC 3.6 under macOS >> Mojave. >> >> Is it possible to export an invoice (both unposted and posted) to a CSV >> file? Or a way to copy-paste all of the lines and columns I see when >> looking at an invoice into Numbers / Excel is also fine. >> >> Thanks all! >> >> - Axel > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
Re: [GNC] Export Invoice to CSV
Not explicitly, but there are two methods that might get you something useful. #1 - ‘Print’ the invoice (to the screen) then either copy/paste into a spreadsheet (Excel has issues at times, but Open/Libreoffice works well, as does Numbers) export it to html and then open with said spreadsheet. This will get you all the info in individual cells, but it will look like the printed version, and won’t be laid out like a CSV with rows as line items. #2 - For posted invoices, make sure the option to ‘Accumulate Splits’ is *not* selected. This will make each invoice line item its own split in the affected registers. You can then export or run a Transaction Report (and then copy/paste) on the AR/AP or other relevant registers. Regards, Adrien > On Dec 5, 2019 w49d339, at 10:28 AM, Axel Essbaum wrote: > > > Hello all, > > I have been using GnuCash for 10 years, currently running GC 3.6 under macOS > Mojave. > > Is it possible to export an invoice (both unposted and posted) to a CSV file? > Or a way to copy-paste all of the lines and columns I see when looking at an > invoice into Numbers / Excel is also fine. > > Thanks all! > > - Axel ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Export Invoice to CSV
Hello all, I have been using GnuCash for 10 years, currently running GC 3.6 under macOS Mojave. Is it possible to export an invoice (both unposted and posted) to a CSV file? Or a way to copy-paste all of the lines and columns I see when looking at an invoice into Numbers / Excel is also fine. Thanks all! - Axel — Axel Essbaum a...@essbaum.com ___ gnucash-user mailing list gnucash-user@gnucash.org 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.