The advantage of getting the invoices in a spreadsheet is that, as far as I can tell (haven’t tested this) you can put the whole string of invoices in one file. Each line in the file has a field for invoice number, and I believe if you change the number it creates an additional invoice. So if there is more than one or two, I think the net number of mouse clicks would be reduced.
You might want to test it on a dummy gnucash file, as otherwise you might wind up with LOTS of garbage invoices from testing. > On Dec 7, 2020, at 5:45 PM, Samantha Payn <[email protected]> > wrote: > > > Thanks for the suggestion, Adrien. I’ve got entering the invoice data into > Gnucash down to a fine art (especially with the recent “predictive text” > input in my “product” fields! Thanks again for that, whoever it was!). It is > specifically the step to confirm the exchange rate when posting an invoice > which is the time consuming point. > Samantha Payn > >> On 7 Dec 2020, at 22:25, Adrien Monteleone <[email protected]> >> wrote: >> >> Samantha, you can import invoice data. >> >> Thus, if you have a way to easily create that data in a spreadsheet, you can >> save it as CSV, then import them to GnuCash. >> >> See the Help/Guide about importing business data for the required columns. >> >> I'm not certain if it works well with a foreign currency however. >> >> Regards, >> Adrien >> >>> On 12/7/20 4:11 PM, Samantha Payn wrote: >>> I’d find a “batch post invoice” function enormously helpful. I have a >>> foreign currency client who insists on a separate invoice for each >>> (sometimes inconsequential) amount and the multiple clicks to post the >>> invoice and confirm the exchange rate for each one are time consuming. >>> Currently the quickest I’ve got it is to create each invoice but not post >>> it, then use “find invoice” criteria to call all the invoices up, highlight >>> them all and then click “post” which prompts the exchange rate dialogue >>> (for every invoice). I use “fetch rate” for the first invoice, and just >>> “accept rate” for all the others, but that’s still three clicks per invoice >>> (I think). >>> Please could Santa bring me a “batch post invoice” function for Christmas? >> >> _______________________________________________ >> 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. _______________________________________________ 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.
