[GNC] bulk operations?

Samantha Payn samantha at boorertranslations.com
Mon Dec 7 18:02:20 EST 2020


Yes, I agree that the exchange rate has to be input. Whether you fetch the rate (also permitted by HMRC as I understand it) or input the rate manually it still has to be confirmed for each invoice when posting in Gnucash. 

---- Christopher Lam wrote ----

>But it's crucial to input the exchange rate - and IIUC you are encouraged
>to use
>https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly
>
>On Mon, 7 Dec 2020 at 22:47, 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.
>>


More information about the gnucash-user mailing list