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 are a number of fields which are “descriptive” in one way or another,
such that editing these fields outside Gnucash poses to risk to the integrity
of the data. The developers know best which fields these are. A number of users
have developed external means of editing databases (and I
From: flywire
Sent: Mon Dec 07 18:21:01 EST 2020
To: Gnucash Users
Subject: [GNC] bulk operations?
>* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*
*Seems reasonable.*
___
gnucas
Writing to the db is considered risky at this time. (and not supported)
Reading is fine though.
Regards,
Adrien
On 12/7/20 5:21 PM, flywire wrote:
* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*
*Seems reasonable.*
>* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*
*Seems reasonable.*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
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
wrote:
>
> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into
>
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
I saw it a few months ago. People still ask. One new (at the time)
volunteer offered to code it. I think it didn't get very far at the time
due to complexity. (and other 'fish to fry' in the code, so to speak)
Regards,
Adrien
On 12/7/20 4:00 PM, Weiwu Zhang wrote:
This issue comes up
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
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
This issue comes up regularly with new users. The short answer to the
question is, "no, there is not a bulk edit."
Instead of discouraging people to ask this because it's already discussed
and some suggestions are already archived, I feel starting the
conversation again is the only way to
12 matches
Mail list logo