[GNC] bulk operations?

[R. Victor Klassen]

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 <samantha at boorertranslations.com> 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 <adrien.monteleone at lusfiber.net> 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
>> gnucash-user at 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 at 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.