[GNC] Batch posting of foreign currency invoices
Samantha Payn
samantha at boorertranslations.com
Mon Apr 6 02:30:12 EDT 2020
Thank you, Adrien.
On 4 April 2020 21:05 [1]gnucash-user-request at gnucash.org wrote:
Send gnucash-user mailing list submissions to
[2]gnucash-user at gnucash.org
To subscribe or unsubscribe via the World Wide Web, visit
[3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
[4]gnucash-user-request at gnucash.org
You can reach the person managing the list at
[5]gnucash-user-owner at gnucash.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."
Today's Topics:
1. Re: Batch posting of foreign currency invoices
(Adrien Monteleone)
2. GNU 3.9 WIn 10 menus completely disconnected from app
( [6]fciani at gmail.com)
3. Re: How To Set Tax Report Options (Adrien Monteleone)
4. FW: GNU 3.9 WIn 10 menus completely disconnected from app in
dual monitor mode ( [7]fciani at gmail.com)
5. Re: How To Set Tax Report Options (Adrien Monteleone)
6. Re: Badly formed URL (Bruce Irving)
7. Re: How To Set Tax Report Options (D.)
8. Re: How To Set Tax Report Options (D.)
9. Re: How To Set Tax Report Options (Alex Aycinena)
10. Re: How To Set Tax Report Options (Keith Fetterman)
11. Re: GNU 3.9 WIn 10 menus completely disconnected from app in
dual monitor mode (John Ralls)
_______________________________________________
gnucash-user mailing list
[8]gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
[9]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[10]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.
That is an interesting problem.
There isn’t a batch posting feature, so you still have to post them
individually, but I can see how removing lots of extra clicks would
help the workflow.
Somewhere in the process, GnuCash needs to confirm with the user what
the exchange rate will be. Outside of a separate batch posting
function, I don’t see how this could be implemented presently. If a
batch posting function were added, it should include an *option* to
only confirm an exchange rate once per currency per run.
Regards,
Adrien
On Apr 4, 2020 w14d95, at 9:09 AM, Samantha Payn <
[11]samantha at boorertranslations.com> wrote:
Hi Rob
No, I'm not referring to importing bills. I issue invoices in various
currencies. If I am issuing a number of invoices at once, all in the
same currency which is not my own, I currently have to click ok for the
currency conversion for each invoice when I post them, even if I post
them all at once. Is there a way to OK the conversion rate for a number
of invoices in a foreign currency all at once when they are posted
together?
Cheers
Hi
I upgraded to 3.9 on Wins 10. The app menu items do not appear in a
drop-down. They are totally disconnected from the app off to the side.
Not sure how this happened.
Thanks
Frank
Sadly, it is one account at a time. (unless there is a trick I don’t
know about)
Regards,
Adrien
On Apr 4, 2020 w14d95, at 10:30 AM, Keith Fetterman <
[12]keithfetterman at gmail.com> wrote:
Is there documentation on how to set tax report options for multiple
accounts? I am trying to set the income tax classifications (TXF
Categories) for multiple expense and income accounts, but it doesn’t
seem to be able to do more than one account at a time. Here is what I
am doing.
Set income tax identity to “Individual, Joint …”
Select an expense account
Click the Tax Related checkbox
Select a TXF Category
Select another expense account
Click the Tax Related checkbox
Select a TXF Category
etc.
When I return to a previous expense account, the Tax Related checkbox
is unchecked and the TXF Category assignment is cleared.
Do you have to run the “Tax Report Options” assignment separately for
each account? By this I mean, perform the steps above for a single
account then click the “OK” button to close the dialog?
Thanks
Keith
I have an update - the menu items appear normal when the application is
on
my primary monitor. However, if the main app is on my secondary
monitor,
the menu items appear on the primary monitor.
So there is an issue with the use of dual monitors.
Frank
From: [13]fciani at gmail.com < [14]fciani at gmail.com>
Sent: Saturday, April 4, 2020 12:25 PM
To: [15]'gnucash-devel at gnucash.org' < [16]gnucash-user at gnucash.org>
Subject: GNU 3.9 WIn 10 menus completely disconnected from app
Hi
I upgraded to 3.9 on Wins 10. The app menu items do not appear in a
drop-down. They are totally disconnected from the app off to the side.
Not sure how this happened.
Thanks
Frank
For this and other tax setup documentation see the Help @ § "10.5
Setting Tax Report Options”:
[17]https://www.gnucash.org/docs/v3/C/gnucash-help/set-tax-options.html
(Payer Name Source and Copy Number explained near the end)
Regards,
Adrien
On Apr 4, 2020 w14d95, at 10:33 AM, Keith Fetterman <
[18]keithfetterman at gmail.com> wrote:
A follow up question related to using the "Tax Report Options” feature.
What are the fields “Payer Name Source” and “Copy Number” used for?
Thanks
On Apr 4, 2020, at 8:30 AM, Keith Fetterman <
[19]keithfetterman at gmail.com> wrote:
Is there documentation on how to set tax report options for multiple
accounts? I am trying to set the income tax classifications (TXF
Categories) for multiple expense and income accounts, but it doesn’t
seem to be able to do more than one account at a time. Here is what I
am doing.
Set income tax identity to “Individual, Joint …”
Select an expense account
Click the Tax Related checkbox
Select a TXF Category
Select another expense account
Click the Tax Related checkbox
Select a TXF Category
etc.
When I return to a previous expense account, the Tax Related checkbox
is unchecked and the TXF Category assignment is cleared.
Do you have to run the “Tax Report Options” assignment separately for
each account? By this I mean, perform the steps above for a single
account then click the “OK” button to close the dialog?
Thanks
Keith
OK. The Experimental report shows the customer name on the entry
mentioned.Now, it is saying one was not processed as it has
(Quote)Invalid Txn Type(/Quote). This was a transaction that I had
recorded manually to the old AR account then,later, corrected it by
entering an invoice from the old AR account.
Bruce Preach the Gospel wherever you go. If necessary, use words.
On Saturday, April 4, 2020, 9:50:19 AM MDT, Christopher Lam <
[20]christopher.lck at gmail.com> wrote:
The aging report cannot handle payments unattached to a customer or
vendor. Try the experimental aging report instead.
On Sat, 4 Apr 2020, 11:17 pm Bruce Irving via gnucash-user, <
[21]gnucash-user at gnucash.org> wrote:
The above is a screenshot of Receivables Aging. The Company name was
blank. When I clicked on the amount, it showed that it was a badly
formed URL. I have tracked it to a customer that wanted an amount owed
him to be put on account.Ideally, this would show his name.Should I
delete the payment and create a new one.This occurred on 3.8 Flatpak
Peppermint 10 on an Acer Laptop. (I have since upgraded to 3.9
Flatpak.)Thanks.
Bruce Preach the Gospel wherever you go. If necessary, use
words._______________________________________________
gnucash-user mailing list
[22]gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
[23]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[24]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.
There is one exception I know: you can set an account and all its
children to the same TXF category. Otherwise, Adrien is correct.
David T.
-------- Original Message --------
From: Adrien Monteleone < [25]adrien.monteleone at lusfiber.net>
Sent: Sat Apr 04 21:56:32 GMT+05:30 2020
To: Gnucash Users < [26]gnucash-user at gnucash.org>
Subject: Re: [GNC] How To Set Tax Report Options
Sadly, it is one account at a time. (unless there is a trick I don’t
know about)
Regards,
Adrien
On Apr 4, 2020 w14d95, at 10:30 AM, Keith Fetterman <
[27]keithfetterman at gmail.com> wrote:
Is there documentation on how to set tax report options for multiple
accounts? I am trying to set the income tax classifications (TXF
Categories) for multiple expense and income accounts, but it doesn’t
seem to be able to do more than one account at a time. Here is what I
am doing.
Set income tax identity to “Individual, Joint …”
Select an expense account
Click the Tax Related checkbox
Select a TXF Category
Select another expense account
Click the Tax Related checkbox
Select a TXF Category
etc.
When I return to a previous expense account, the Tax Related checkbox
is unchecked and the TXF Category assignment is cleared.
Do you have to run the “Tax Report Options” assignment separately for
each account? By this I mean, perform the steps above for a single
account then click the “OK” button to close the dialog?
Thanks
Keith
_______________________________________________
gnucash-user mailing list
[28]gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
[29]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[30]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.
There is one exception I know: you can set an account and all its
children to the same TXF category. Otherwise, Adrien is correct.
David T.
-------- Original Message --------
From: Adrien Monteleone < [31]adrien.monteleone at lusfiber.net>
Sent: Sat Apr 04 21:56:32 GMT+05:30 2020
To: Gnucash Users < [32]gnucash-user at gnucash.org>
Subject: Re: [GNC] How To Set Tax Report Options
Sadly, it is one account at a time. (unless there is a trick I don’t
know about)
Regards,
Adrien
On Apr 4, 2020 w14d95, at 10:30 AM, Keith Fetterman <
[33]keithfetterman at gmail.com> wrote:
Is there documentation on how to set tax report options for multiple
accounts? I am trying to set the income tax classifications (TXF
Categories) for multiple expense and income accounts, but it doesn’t
seem to be able to do more than one account at a time. Here is what I
am doing.
Set income tax identity to “Individual, Joint …”
Select an expense account
Click the Tax Related checkbox
Select a TXF Category
Select another expense account
Click the Tax Related checkbox
Select a TXF Category
etc.
When I return to a previous expense account, the Tax Related checkbox
is unchecked and the TXF Category assignment is cleared.
Do you have to run the “Tax Report Options” assignment separately for
each account? By this I mean, perform the steps above for a single
account then click the “OK” button to close the dialog?
Thanks
Keith
_______________________________________________
gnucash-user mailing list
[34]gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
[35]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[36]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.
>
>
From: Keith Fetterman < [37]keithfetterman at gmail.com>
To: GnuCash users group < [38]gnucash-user at gnucash.org>
Cc:
Bcc:
Date: Sat, 4 Apr 2020 08:33:43 -0700
Subject: Re: [GNC] How To Set Tax Report Options
A follow up question related to using the "Tax Report Options” feature.
What are the fields “Payer Name Source” and “Copy Number” used for?
>
See "Setting Tax Report Options" in Gnucash help manual:
"For codes for which the "Payer Name Source" is not grayed, the payer
on
the TXF record will be based on what is specified here, either the
account
name of the account or the account name of the account’s parent
account.
This feature is typically used for interest accounts or stocks or
mutual
funds that pay dividends where the individual payees are shown on the
tax
schedule. For example, if the parent account’s name is the name of your
broker and the sub-account’s names are the names of individual stocks
that
pay dividends and the name on the 1099-DIV received is that of the
broker,
in order to match that name, you would select ’Parent Account’; the
total
dividends from the broker would be exported and, if you had several
brokers, there would be an amount exported and a subtotal for each
broker,
along with each brokers name. Alternatively, if you had a parent
account
named *Directly Held*, for example, and below it sub-accounts for one
or
more stocks, you would receive a 1099-DIV from the issuer of each stock
separately and, in order to match that name, you would select Current
Account; the total dividends from each stock would be exported and, if
you
had several stocks, there would be an amount exported and a subtotal
for
each stock, along with each stock’s name as the payer.
Some tax Forms/Schedules need to have multiple copies filed under some
circumstances (for example, Schedule C if a taxpayer and spouse have
separate businesses). For tax categories on these Forms/Schedules, the
Copy
Number is not grayed out and can be used to segregate accounts by copy
number."
Thanks
On Apr 4, 2020, at 8:30 AM, Keith Fetterman <
[39]keithfetterman at gmail.com>
wrote:
>
Is there documentation on how to set tax report options for multiple
accounts? I am trying to set the income tax classifications (TXF
Categories) for multiple expense and income accounts, but it doesn’t
seem
to be able to do more than one account at a time. Here is what I am
doing.
>
Set income tax identity to “Individual, Joint …”
Select an expense account
Click the Tax Related checkbox
Select a TXF Category
Select another expense account
Click the Tax Related checkbox
Select a TXF Category
etc.
When I return to a previous expense account, the Tax Related checkbox
is
unchecked and the TXF Category assignment is cleared.
>
Do you have to run the “Tax Report Options” assignment separately for
each account? By this I mean, perform the steps above for a single
account
then click the “OK” button to close the dialog?
Unfortunately, you have to do them one-at-a-time. There is a
long-standing
feature request to allow them to be done in batches but it hasn't been
implemented. At least it is just a big effort once at the beginning;
once
set up, ongoing maintenance is not as onerous. Note that, as it says in
the
manual,:
"If the Income Tax features are used, it is strongly recommended that
the Tax
Info column be made visible on the accounts tab (click large
downward-pointing arrow and select Tax Info check box). The Tax Info
column
will display the Form/Schedule and tax category (e.g., Schedule D
Dividend,
cap gain distrib.) assigned to an account, if any."
This allows you to scan down the chart-of-accounts and see that all
accounts that should be tagged are and that those that shouldn't be
aren't.
The whole US Income Tax feature is a bit cumbersome and needs to be
re-implemented, but that is a big task.
Thanks
Keith
>
Regards,
Alex
Hi Alex,
Thank you finding this. I dug deeper in the Gnucash help manual and
found the sections that you referred to. Thanks for the clarification
about the copy number. I’ve seen that used in TurboTax. It all makes
sense.
Keith
On Apr 4, 2020, at 11:15 AM, Alex Aycinena <
[40]alex.aycinena at gmail.com> wrote:
From: Keith Fetterman < [41]keithfetterman at gmail.com <mailto:
[42]keithfetterman at gmail.com>>
To: GnuCash users group < [43]gnucash-user at gnucash.org <mailto:
[44]gnucash-user at gnucash.org>>
Cc:
Bcc:
Date: Sat, 4 Apr 2020 08:33:43 -0700
Subject: Re: [GNC] How To Set Tax Report Options
A follow up question related to using the "Tax Report Options” feature.
What are the fields “Payer Name Source” and “Copy Number” used for?
See "Setting Tax Report Options" in Gnucash help manual:
"For codes for which the "Payer Name Source" is not grayed, the payer
on the TXF record will be based on what is specified here, either the
account name of the account or the account name of the account’s parent
account. This feature is typically used for interest accounts or stocks
or mutual funds that pay dividends where the individual payees are
shown on the tax schedule. For example, if the parent account’s name is
the name of your broker and the sub-account’s names are the names of
individual stocks that pay dividends and the name on the 1099-DIV
received is that of the broker, in order to match that name, you would
select ’Parent Account’; the total dividends from the broker would be
exported and, if you had several brokers, there would be an amount
exported and a subtotal for each broker, along with each brokers name.
Alternatively, if you had a parent account named Directly Held, for
example, and below it sub-accounts for one or more stocks, you would
receive a 1099-DIV from the issuer of each stock separately and, in
order to match that name, you would select Current Account; the total
dividends from each stock would be exported and, if you had several
stocks, there would be an amount exported and a subtotal for each
stock, along with each stock’s name as the payer.
Some tax Forms/Schedules need to have multiple copies filed under some
circumstances (for example, Schedule C if a taxpayer and spouse have
separate businesses). For tax categories on these Forms/Schedules, the
Copy Number is not grayed out and can be used to segregate accounts by
copy number."
Thanks
On Apr 4, 2020, at 8:30 AM, Keith Fetterman <
[45]keithfetterman at gmail.com <mailto: [46]keithfetterman at gmail.com>>
wrote:
Is there documentation on how to set tax report options for multiple
accounts? I am trying to set the income tax classifications (TXF
Categories) for multiple expense and income accounts, but it doesn’t
seem to be able to do more than one account at a time. Here is what I
am doing.
Set income tax identity to “Individual, Joint …”
Select an expense account
Click the Tax Related checkbox
Select a TXF Category
Select another expense account
Click the Tax Related checkbox
Select a TXF Category
etc.
When I return to a previous expense account, the Tax Related checkbox
is unchecked and the TXF Category assignment is cleared.
Do you have to run the “Tax Report Options” assignment separately for
each account? By this I mean, perform the steps above for a single
account then click the “OK” button to close the dialog?
Unfortunately, you have to do them one-at-a-time. There is a
long-standing feature request to allow them to be done in batches but
it hasn't been implemented. At least it is just a big effort once at
the beginning; once set up, ongoing maintenance is not as onerous. Note
that, as it says in the manual,:
"If the Income Tax features are used, it is strongly recommended that
the Tax Info column be made visible on the accounts tab (click large
downward-pointing arrow and select Tax Info check box). The Tax Info
column will display the Form/Schedule and tax category (e.g., Schedule
D Dividend, cap gain distrib.) assigned to an account, if any."
This allows you to scan down the chart-of-accounts and see that all
accounts that should be tagged are and that those that shouldn't be
aren't.
The whole US Income Tax feature is a bit cumbersome and needs to be
re-implemented, but that is a big task.
Thanks
Keith
Regards,
Alex
Could you try
[47]https://code.gnucash.org/builds/win32/maint/gnucash-3.9-2020-04-03-
git-3.9-5-gbedc9631f+.setup.exe? MinGW64 upgraded gtk from 3.24.14 to
3.24.16 two days after the 3.9 release.
Regards,
John Ralls
On Apr 4, 2020, at 9:33 AM, < [48]fciani at gmail.com> <
[49]fciani at gmail.com> wrote:
I have an update - the menu items appear normal when the application is
on
my primary monitor. However, if the main app is on my secondary
monitor,
the menu items appear on the primary monitor.
So there is an issue with the use of dual monitors.
Frank
From: [50]fciani at gmail.com < [51]fciani at gmail.com>
Sent: Saturday, April 4, 2020 12:25 PM
To: [52]'gnucash-devel at gnucash.org' < [53]gnucash-user at gnucash.org>
Subject: GNU 3.9 WIn 10 menus completely disconnected from app
Hi
I upgraded to 3.9 on Wins 10. The app menu items do not appear in a
drop-down. They are totally disconnected from the app off to the side.
Not sure how this happened.
Thanks
Frank
_______________________________________________
gnucash-user mailing list
[54]gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
[55]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[56]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.
References
1. mailto:gnucash-user-request at gnucash.org
2. mailto:gnucash-user at gnucash.org
3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
4. mailto:gnucash-user-request at gnucash.org
5. mailto:gnucash-user-owner at gnucash.org
6. mailto:fciani at gmail.com
7. mailto:fciani at gmail.com
8. mailto:gnucash-user at gnucash.org
9. https://lists.gnucash.org/mailman/listinfo/gnucash-user
10. https://wiki.gnucash.org/wiki/Mailing_Lists
11. mailto:samantha at boorertranslations.com
12. mailto:keithfetterman at gmail.com
13. mailto:fciani at gmail.com
14. mailto:fciani at gmail.com
15. mailto:'gnucash-devel at gnucash.org
16. mailto:gnucash-user at gnucash.org
17. https://www.gnucash.org/docs/v3/C/gnucash-help/set-tax-options.html
18. mailto:keithfetterman at gmail.com
19. mailto:keithfetterman at gmail.com
20. mailto:christopher.lck at gmail.com
21. mailto:gnucash-user at gnucash.org
22. mailto:gnucash-user at gnucash.org
23. https://lists.gnucash.org/mailman/listinfo/gnucash-user
24. https://wiki.gnucash.org/wiki/Mailing_Lists
25. mailto:adrien.monteleone at lusfiber.net
26. mailto:gnucash-user at gnucash.org
27. mailto:keithfetterman at gmail.com
28. mailto:gnucash-user at gnucash.org
29. https://lists.gnucash.org/mailman/listinfo/gnucash-user
30. https://wiki.gnucash.org/wiki/Mailing_Lists
31. mailto:adrien.monteleone at lusfiber.net
32. mailto:gnucash-user at gnucash.org
33. mailto:keithfetterman at gmail.com
34. mailto:gnucash-user at gnucash.org
35. https://lists.gnucash.org/mailman/listinfo/gnucash-user
36. https://wiki.gnucash.org/wiki/Mailing_Lists
37. mailto:keithfetterman at gmail.com
38. mailto:gnucash-user at gnucash.org
39. mailto:keithfetterman at gmail.com
40. mailto:alex.aycinena at gmail.com
41. mailto:keithfetterman at gmail.com
42. mailto:keithfetterman at gmail.com
43. mailto:gnucash-user at gnucash.org
44. mailto:gnucash-user at gnucash.org
45. mailto:keithfetterman at gmail.com
46. mailto:keithfetterman at gmail.com
47. https://code.gnucash.org/builds/win32/maint/gnucash-3.9-2020-04-03-git-3.9-5-gbedc9631f+.setup.exe
48. mailto:fciani at gmail.com
49. mailto:fciani at gmail.com
50. mailto:fciani at gmail.com
51. mailto:fciani at gmail.com
52. mailto:'gnucash-devel at gnucash.org
53. mailto:gnucash-user at gnucash.org
54. mailto:gnucash-user at gnucash.org
55. https://lists.gnucash.org/mailman/listinfo/gnucash-user
56. https://wiki.gnucash.org/wiki/Mailing_Lists
More information about the gnucash-user
mailing list