[GNC] GC Transaction Report for investments displays shares not money
"My Transaction Report is displaying the proper transactions for my filter, but because these are mutual funds the totals are in numbers of shares instead of currency. Under a column heading "Amount" it shows FundA150 (shares) instead of the value, FundA $1,000. How do I display dollars?" Checking the "Common Currency" block in the General tab will allow money to display in lieu of share numbers. ___ gnucash-user mailing list gnucash-user@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.
[GNC] How to merge 2 vendors?
Apologize for re-posting this but I decided my earlier question was not clear.- The Question: How to merge 2 vendors... merge VenB into VenA... - Explanation: Actually they are the same vendor but appear twice in Business > Vendor > Vendor > Vendors Overview- So we inadvertent created two accounts for the same vendor and posted bills and payments to both.-Is there an easy way in GC to "merge" them into one vendor account? Like merge VenB into VenA... -Hopefully this question is articulated more clearly.-Thanks for any help ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] How to merge 2 vendors?
Hi, On Sat, October 5, 2019 9:38 am, Fran_3 via gnucash-user wrote: > Apologize for re-posting this but I decided my earlier question was not > clear.- > The Question: How to merge 2 vendors... merge VenB into VenA... > - > Explanation: Actually they are the same vendor but appear twice in > Business > Vendor > Vendor > Vendors Overview- > So we inadvertent created two accounts for the same vendor and posted > bills and payments to both.-Is there an easy way in GC to "merge" them > into one vendor account? Like merge VenB into VenA... > -Hopefully this question is articulated more clearly.-Thanks for any help I'm sorry, but no, there is currently no easy way to merge them. Assuming you want to merge VenB into VenA, the only way to do it is to manually go through every VenB invoice, unpost it, reaasign the VenA, and then re-post. Then you'll also have to repost all payments to VenB. There is no shortcut or automated way to do this. Sorry, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] How to Report Asset Allocation by Currency
>> I don't think we actually have such a report! One could be written, of course, but it would require scheme hacking. I don't know if the portfolio report would be helpful? << The portfolio report is quite useful; I have used it a lot. However, I have been unable to figure out how to adapt it to group accounts by currency. Scheme hacking is beyond me (at least at present ;-) ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] How to merge 2 vendors?
Derek, OK, That did it! Thanks. Hi, On Sat, October 5, 2019 9:38 am, Fran_3 via gnucash-user wrote: > Apologize for re-posting this but I decided my earlier question was not > clear.- > The Question: How to merge 2 vendors... merge VenB into VenA... > - > Explanation: Actually they are the same vendor but appear twice in > Business > Vendor > Vendor > Vendors Overview- > So we inadvertent created two accounts for the same vendor and posted > bills and payments to both.-Is there an easy way in GC to "merge" them > into one vendor account? Like merge VenB into VenA... > -Hopefully this question is articulated more clearly.-Thanks for any help I'm sorry, but no, there is currently no easy way to merge them. Assuming you want to merge VenB into VenA, the only way to do it is to manually go through every VenB invoice, unpost it, reaasign the VenA, and then re-post. Then you'll also have to repost all payments to VenB. There is no shortcut or automated way to do this. Sorry, > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@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.
[GNC] How to see which Bill a Payment was applied to?
For a particular vendor... is there an easy way to see which payment was applied to which bill? Thank for any help. PS - I have been able to look at the AP ledger, find a particular payment, right click, and then click "edit payment" but instead of hunting up every individual payment I was hoping there was a way to see all bills and associated payments for a particular vendor. . ___ gnucash-user mailing list gnucash-user@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.
[GNC] custom report freezing - work done gets lost.
Hi. Have a custom report that appears to be freezing, so I have to halt it. It in a 3000 item loop, and I suspect the overheads are growing as it progresses. I want to save the book periodically, which if nothing else will simplify the work in a future run. Is there a function I can call that is like "gnc-book-session-save"? Steve ___ gnucash-user mailing list gnucash-user@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.
[GNC] Charts with Multiple Currency
Hello, I'm using Gnucash with Japanese Yen and USD Some charts show the data by graph. But the graph is wrong. It seems all data is treated as Japanese Yen in the graph. For example, Networth line chart I have 100 JPY and US asset which worth 1 USD(1USD is almost 100 JPY), Gnucash draw the graph as 100 for currency and 1 for foreign asset value. I think JPY and USD asset should have same volume in the graph in this example. I guess gnucash don't have the feature to draw a graph with multi currency . Is there any workaround or fix for this? Thanks in advance. Risok ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] How to see which Bill a Payment was applied to?
The Customer Summary is probably what you want. It is the closest thing to a ’statement of account’ that GnuCash has. You can run them individually, or, I like to keep a Receivables Aging Report and a Payables Aging Report open at all times. If you click the total amount on those reports for a customer or vendor, you’ll get the Customer/Vendor Summary Report accordingly. There is also a new report in the works which will show what invoices/bills the payments in applied to. (similar to the Customer/Vendor Summary but with the extra info) But for now, you have to put this info in the notes/memo fields of the payment transaction. The author is looking for testers. If you check the August/September archives, you should find the GitHub link to download it. Finally, looking at the AR register, it is easy to see who made payments, but no easy way to see what they applied to. Regards, Adrien > On Oct 5, 2019 w40d278, at 10:48 AM, Fran_3 via gnucash-user > wrote: > > For a particular vendor... is there an easy way to see which payment was > applied to which bill? > Thank for any help. > PS - I have been able to look at the AP ledger, find a particular payment, > right click, and then click "edit payment" but instead of hunting up every > individual payment I was hoping there was a way to see all bills and > associated payments for a particular vendor. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Charts with Multiple Currency
For now I think you have to pick a currency. Though, it should value the foreign currency properly so you should get the correct proportions. If it isn’t doing that, then you should file a bug. Regards, Adrien > On Oct 5, 2019 w40d278, at 6:38 AM, risokei wrote: > > Hello, > > I'm using Gnucash with Japanese Yen and USD > Some charts show the data by graph. > But the graph is wrong. It seems all data is treated as Japanese Yen in the > graph. > > For example, Networth line chart > > I have 100 JPY and US asset which worth 1 USD(1USD is almost 100 JPY), > Gnucash draw the graph as 100 for currency and 1 for foreign asset value. > I think JPY and USD asset should have same volume in the graph in this > example. > > I guess gnucash don't have the feature to draw a graph with multi currency . > > Is there any workaround or fix for this? > > Thanks in advance. > > Risok ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] custom report freezing - work done gets lost.
qof-session isn't currently accessible to scheme. Why do you think you'll need to save session? It may help to publish your report on Bugzilla or devel mailing list. On Sun, 6 Oct 2019, 12:53 Steven Bruniges, wrote: > Hi. > > > > Have a custom report that appears to be freezing, so I have to halt it. It > in a 3000 item loop, and I suspect the overheads are growing as it > progresses. > > > > I want to save the book periodically, which if nothing else will simplify > the work in a future run. > > > > Is there a function I can call that is like "gnc-book-session-save"? > > > > Steve > > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Charts with Multiple Currency
Hello, nice to hear users using multiple currencies in reports. Most reports were designed to run converting all currencies into a "target" currency. It would be useful to know exactly what report options you are using, and exactly what you're trying to achieve. On Sun, 6 Oct 2019, 12:56 risokei, wrote: > Hello, > > I'm using Gnucash with Japanese Yen and USD > Some charts show the data by graph. > But the graph is wrong. It seems all data is treated as Japanese Yen in > the graph. > > For example, Networth line chart > > I have 100 JPY and US asset which worth 1 USD(1USD is almost 100 JPY), > Gnucash draw the graph as 100 for currency and 1 for foreign asset value. > I think JPY and USD asset should have same volume in the graph in this > example. > > I guess gnucash don't have the feature to draw a graph with multi currency > . > > Is there any workaround or fix for this? > > Thanks in advance. > > Risok > > ___ > gnucash-user mailing list > gnucash-user@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@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.
