[GNC] Error parsing server response

[Billy Chaney]

I keep getting an Error parsing server response. Any help with this would be 
Greatly appreciated.


AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user billchaney64
Sending request...
Connecting to server...
Resolving hostname "www.bankofamerica.com" ...
IP address is "171.161.206.100"
Connecting to "www.bankofamerica.com"
Connected to "www.bankofamerica.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-128-GCM:AEAD
Signer not found
Certificate is not trusted
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 301 (Moved Permanently)
HTTP: Moved permanently to 
https://www.bankofamerica.com/vanity/redirect.go?src=/cgi-forte/fortecgi&servicename=ofx_2-3&pagename=ofx
Error parsing server response
Unlocking user billchaney64
Postprocessing jobs
Job Get Balance: finished
Resetting provider queues

Sent from Mail for Windows 10

___
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] Adjusting column width

[Terence Wong]

I am using 3.4-1. For some accounts that have a long numeric figures in the
column, I tried to adjust the width to show the full figures but to no
avail.  This also applies to 2.6.21-2.

Is this a bug or there is a way to get around it?

Regards,
-- 
Terence Wong
___
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] Adjusting column width

[Colin Law]

On Tue, 5 Mar 2019 at 10:35, Terence Wong  wrote:
>
> I am using 3.4-1. For some accounts that have a long numeric figures in the
> column, I tried to adjust the width to show the full figures but to no
> avail.  This also applies to 2.6.21-2.

If you double click the column heading it should expand it so the
numbers fit in.

Colin
___
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] apply coefficient to an account

[Peter Münster]

Hi,

For a special report of type "Profit & Loss" I need to apply some
coefficients to some accounts. For example 0.7 to the account
"transport". Is this possible with Gnucash, and if yes: how please?

Thanks in advance for any hints. Kind regards,
-- 
   Peter
___
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] Music Teacher: tracking balances owed from students

[Adrien Monteleone]

Sure,

I’ll be out today for Mardi Gras but I should have it up tomorrow.

Regards,
Adrien

> On Mar 5, 2019, at 12:19 AM, David T.  wrote:
> 
> Adrien,
> 
> 
> Any chance you might add these tips to the Using Gnucash wiki page? "Simple 
> business advice for managing invoices" or some such...
> 
> 
> Adding it at the business features spot might make most sense. 
> 
> Cheers,
> David
> 
> 
> On Tue, Mar 5, 2019 at 2:36, Adrien Monteleone
>  wrote:
> The short answer is, the workflow here is primarily determined by your 
> business processes, not GnuCash.
> 
> You’ve agreed or decided to be paid per lesson, so that’s how you have to do 
> your accounting.
> 
> You can use the Duplicate Invoice button to repeat an invoice for a lesson 
> and just change the dates/invoice number. You can even do this for a 
> different customer and also change the customer if you need to bill someone 
> per-lesson that you had not previously.
> 
> You can also use manual transactions and rely on the duplicate and auto-fill 
> but then you’ll lose the ability to easily run account statements (Customer 
> Reports) if you need to send them to clients.
> 
> I keep my Receivables Due and Payables Due reports open at all times. When I 
> need to add an invoice or bill, I click the total figure which brings up a 
> Customer/Vendor Report I then click the invoice/bill I want to duplicate to 
> view it and then use the Duplicate Invoice button and edit any changes. 
> That’s much faster especially when I have multiple line numbers that stay the 
> same.
> 
> Regards,
> Adrien
> 
> 
> > On Mar 4, 2019, at 2:45 PM, musicteach  wrote:
> > 
> > Hi all,
> > My music teaching income is all over the map, I receive payments for
> > individual lessons, monthly payments - I have to cancel lessons for
> > performances; some lessons are rescheduled and some are skipped.  Bottom
> > line is that I understand the income tracking side of things (entering
> > payments), but I'm wondering what the best way to track balance owed would
> > be.
> > 
> > Is the best way to use the Account Receivable system?  It seems like a lot
> > of work to start a new invoice for every single lesson I teach.  Do you have
> > any other ideas to automate this process a bit as I'm spending quite a bit
> > of time on this stuff, and I'd like to break free.
> > thank you for your time
> > 
> > 
> > 
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > 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.


___
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] Error parsing server response

[John Ralls]

> On Mar 4, 2019, at 10:16 PM, Billy Chaney  wrote:
> 
> I keep getting an Error parsing server response. Any help with this would be 
> Greatly appreciated.
> 
> 
> AqBanking v5.7.8.0stable
> Sending jobs to the bank(s)
> Locking user billchaney64
> Sending request...
> Connecting to server...
> Resolving hostname "www.bankofamerica.com" ...
> IP address is "171.161.206.100"
> Connecting to "www.bankofamerica.com"
> Connected to "www.bankofamerica.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-128-GCM:AEAD
> Signer not found
> Certificate is not trusted
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 301 (Moved Permanently)
> HTTP: Moved permanently to 
> https://www.bankofamerica.com/vanity/redirect.go?src=/cgi-forte/fortecgi&servicename=ofx_2-3&pagename=ofx
> Error parsing server response
> Unlocking user billchaney64
> Postprocessing jobs
> Job Get Balance: finished
> Resetting provider queues

See https://wiki.gnucash.org/wiki/AqBanking#Debugging.

Regards,
John Ralls

___
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] apply coefficient to an account

[John Ralls]

> On Mar 5, 2019, at 5:28 AM, Peter Münster  wrote:
> 
> Hi,
> 
> For a special report of type "Profit & Loss" I need to apply some
> coefficients to some accounts. For example 0.7 to the account
> "transport". Is this possible with Gnucash, and if yes: how please?
> 
> Thanks in advance for any hints. Kind regards,

Probably not from the GUI, but you haven't explained very well. Apply the 
coefficients how and with what intended result? 

Failing there being a report that gets you close enough to what you need you 
can customize the P&L report: https://wiki.gnucash.org/wiki/Custom_Reports

Regards,
John Ralls

___
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] apply coefficient to an account

[Peter Münster]

On Tue, Mar 05 2019, John Ralls wrote:

> Apply the coefficients how and with what intended result?

It's just a multiplication. If there is for example 1000€ in an account
and 0.7 must be applied, then there must be 700€ instead of 1000€ in
the report. Our kayak club has a contract with a public organisation,
and we must deliver a report, that shows only a part of the whole
accounting of the club, only the part that concerns the contract. So for
example 75% of the salary, because the employee spends 25% of his time
with tasks, that are not connected to the contract.


> Failing there being a report that gets you close enough to what you need you
> can customize the P&L report: https://wiki.gnucash.org/wiki/Custom_Reports

Ok. So I need to learn Scheme, Guile and so on? Or can I hire somebody
here on the list, who could do that for me? That would be nice.

Kind regards,
-- 
   Peter
___
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] Payroll Management with Time Attendance Machine

[jason]

Hi,

I was wondering, does GNUCash support Payroll Management with Time
Attendance Machine
(e.g An employee has a meal allowance "transferred by the end of the month",
however if he/she do not come to work, he/she will not receive the meal
allowance by the end of the month)

I was also wondering, does GNUCash support to print the salary slip "act as
a receipt"?

I really need this one, thank you.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] apply coefficient to an account

[Derek Atkins]

I would recommend you run the existing P&L report, then take the output,
copy it into a spreadsheet, and then add your coefficients there.

-derek

On Tue, March 5, 2019 10:21 am, Peter Münster wrote:
> On Tue, Mar 05 2019, John Ralls wrote:
>
>> Apply the coefficients how and with what intended result?
>
> It's just a multiplication. If there is for example 1000€ in an account
> and 0.7 must be applied, then there must be 700€ instead of 1000€ in
> the report. Our kayak club has a contract with a public organisation,
> and we must deliver a report, that shows only a part of the whole
> accounting of the club, only the part that concerns the contract. So for
> example 75% of the salary, because the employee spends 25% of his time
> with tasks, that are not connected to the contract.
>
>
>> Failing there being a report that gets you close enough to what you need
>> you
>> can customize the P&L report:
>> https://wiki.gnucash.org/wiki/Custom_Reports
>
> Ok. So I need to learn Scheme, Guile and so on? Or can I hire somebody
> here on the list, who could do that for me? That would be nice.
>
> Kind regards,
> --
>Peter
> ___
> 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.
>


-- 
   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] Payroll Management with Time Attendance Machine

[Adrien Monteleone]

Jason,

I’m not sure what ’Time Management Attendance Machine’ is, but in general, no, 
you’d need to keep your time sheets separately. (There are plenty of 
stand-alone software options for this, as well as spreadsheet templates, or you 
could roll your own spreadsheet)

GnuCash does not have a built-in payroll module but some people use it for 
payroll. Payroll calculation can be very difficult and is very locale specific. 
You might be able to use Scheduled Transactions for this but if your pay 
practices vary wildly, you might be better off doing the calculations in a 
spreadsheet, generating the resulting transaction, importing it to GnuCash and 
then printing your checks.

See the wiki on ‘Using GnuCash’ for more help in this area, or do a list search 
on the topic.

You will also find info there on using the check printing feature to create pay 
stubs with the checks.

As for tracking allowances automatically, you could utilize the Scheduled 
Transactions feature to generate a liability for each one as they are earned 
(similar to how cash pay is earned) and simply not approve the creation of the 
transaction for those who didn’t work that day/period.

Regards,
Adrien

> On Mar 5, 2019, at 9:59 AM, jason  wrote:
> 
> Hi,
> 
> I was wondering, does GNUCash support Payroll Management with Time
> Attendance Machine
> (e.g An employee has a meal allowance "transferred by the end of the month",
> however if he/she do not come to work, he/she will not receive the meal
> allowance by the end of the month)
> 
> I was also wondering, does GNUCash support to print the salary slip "act as
> a receipt"?
> 
> I really need this one, thank you.

___
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] Payroll Management with Time Attendance Machine

[John Ralls]

> On Mar 5, 2019, at 7:59 AM, jason  wrote:
> 
> Hi,
> 
> I was wondering, does GNUCash support Payroll Management with Time
> Attendance Machine
> (e.g An employee has a meal allowance "transferred by the end of the month",
> however if he/she do not come to work, he/she will not receive the meal
> allowance by the end of the month)
> 
> I was also wondering, does GNUCash support to print the salary slip "act as
> a receipt"?
> 
> I really need this one, thank you.

No to both.

Regards,
John Ralls

___
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] apply coefficient to an account

[John Ralls]

> On Mar 5, 2019, at 7:21 AM, Peter Münster  wrote:
> 
> On Tue, Mar 05 2019, John Ralls wrote:
> 
>> Apply the coefficients how and with what intended result?
> 
> It's just a multiplication. If there is for example 1000€ in an account
> and 0.7 must be applied, then there must be 700€ instead of 1000€ in
> the report. Our kayak club has a contract with a public organisation,
> and we must deliver a report, that shows only a part of the whole
> accounting of the club, only the part that concerns the contract. So for
> example 75% of the salary, because the employee spends 25% of his time
> with tasks, that are not connected to the contract.
> 
> 
>> Failing there being a report that gets you close enough to what you need you
>> can customize the P&L report: https://wiki.gnucash.org/wiki/Custom_Reports
> 
> Ok. So I need to learn Scheme, Guile and so on? Or can I hire somebody
> here on the list, who could do that for me? That would be nice.

Not necessarily. You could just create two payroll expense accounts, one 
chargeable and one not-chargeable and split the payroll expense between the 
two. Then you can run the P&L report with only the chargeable account selected.

Better still, have the employee keep a time sheet recording the time spent on 
each task and the bookkeeper can assign the expense to chargeable or 
not-chargeable depending on the actual time spent. That extends to other 
expenses as well.

But using a P&L report for billing is weird. More normally you'd negotiate a 
billing rate for the employee's time and for whatever other expenses you incur 
and use the business features to generate invoices to the funding organization.

Regards,
John Ralls

___
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] Payroll Management with Time Attendance Machine

[John Ralls]

> On Mar 5, 2019, at 8:16 AM, Adrien Monteleone 
>  wrote:
> 
> Jason,
> 
> I’m not sure what ’Time Management Attendance Machine’ is

It's a $10 name for https://en.wikipedia.org/wiki/Time_clock.

Regards,
John Ralls

___
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] Music Teacher: tracking balances owed from students

[D via gnucash-user]

Thanks!

On March 5, 2019, at 8:14 PM, Adrien Monteleone 
 wrote:

Sure,

I’ll be out today for Mardi Gras but I should have it up tomorrow.

Regards,
Adrien

> On Mar 5, 2019, at 12:19 AM, David T.  wrote:
> 
> Adrien,
> 
> 
> Any chance you might add these tips to the Using Gnucash wiki page? "Simple 
> business advice for managing invoices" or some such...
> 
> 
> Adding it at the business features spot might make most sense. 
> 
> Cheers,
> David
> 
> 
> On Tue, Mar 5, 2019 at 2:36, Adrien Monteleone
>  wrote:
> The short answer is, the workflow here is primarily determined by your 
> business processes, not GnuCash.
> 
> You’ve agreed or decided to be paid per lesson, so that’s how you have to do 
> your accounting.
> 
> You can use the Duplicate Invoice button to repeat an invoice for a lesson 
> and just change the dates/invoice number. You can even do this for a 
> different customer and also change the customer if you need to bill someone 
> per-lesson that you had not previously.
> 
> You can also use manual transactions and rely on the duplicate and auto-fill 
> but then you’ll lose the ability to easily run account statements (Customer 
> Reports) if you need to send them to clients.
> 
> I keep my Receivables Due and Payables Due reports open at all times. When I 
> need to add an invoice or bill, I click the total figure which brings up a 
> Customer/Vendor Report I then click the invoice/bill I want to duplicate to 
> view it and then use the Duplicate Invoice button and edit any changes. 
> That’s much faster especially when I have multiple line numbers that stay the 
> same.
> 
> Regards,
> Adrien
> 
> 
> > On Mar 4, 2019, at 2:45 PM, musicteach  wrote:
> > 
> > Hi all,
> > My music teaching income is all over the map, I receive payments for
> > individual lessons, monthly payments - I have to cancel lessons for
> > performances; some lessons are rescheduled and some are skipped.  Bottom
> > line is that I understand the income tracking side of things (entering
> > payments), but I'm wondering what the best way to track balance owed would
> > be.
> > 
> > Is the best way to use the Account Receivable system?  It seems like a lot
> > of work to start a new invoice for every single lesson I teach.  Do you have
> > any other ideas to automate this process a bit as I'm spending quite a bit
> > of time on this stuff, and I'd like to break free.
> > thank you for your time
> > 
> > 
> > 
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > 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.


___
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] apply coefficient to an account

[Stephen M. Butler]

On 3/5/19 7:07 AM, John Ralls wrote:
>
>> On Mar 5, 2019, at 5:28 AM, Peter Münster  wrote:
>>
>> Hi,
>>
>> For a special report of type "Profit & Loss" I need to apply some
>> coefficients to some accounts. For example 0.7 to the account
>> "transport". Is this possible with Gnucash, and if yes: how please?
>>
>> Thanks in advance for any hints. Kind regards,
> Probably not from the GUI, but you haven't explained very well. Apply the 
> coefficients how and with what intended result? 
>
> Failing there being a report that gets you close enough to what you need you 
> can customize the P&L report: https://wiki.gnucash.org/wiki/Custom_Reports
>
> Regards,
> John Ralls


Could those accounts be treated similar to stock?  Or another currency? 
You would have to enter a price entry in order for GnC to convert them
to the report "currency".

--Steve

PS.  I presume this is a mileage expense factor and Transport holds the
number of mile?


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Getting security prices - Funnies

[Eric Coates]

I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04.

In the course of some fairly standard (for me) work I have come across a 
couple of "funnies" and I'm wondering whether they are deliberate, 
"features" (from Microsoft's vocabulary meaning a bug that won't be 
fixed), bugs or me doing something wrong.


On the last day of the month I need to revalue my share portfolio. Like 
others, I have been a victim of Alphvantage's throttling of their 
service but unlike others I have not (yet) screwed up my courage and 
updated the the related file to incorporate the delays suggested.


I open the Securities Editor, make sure that the Get Quote column is 
shown (and, for simplicity at this stage, I'll assume no securities are 
ticked) and then, by double clicking on a security I get to the Security 
Information window and select Get Online Quotes, click Unknown and 
select Alphavantage from the drop down. I do this for five securities 
(no point in doing it for more because of the Alphavantage limitation). 
In the Price Editor I click Get Quotes and, after a wait, I get the 
prices for the five securities I selected.


Having got those five prices I need to select a second batch of 
securities. But (*first funny*) I cannot deselect the previously 
selected securities by clicking on the tick - I have to go back to the 
Security Information to do that. Is that intended?


Having deselected the Get Quote for a security, I have noted that if, in 
the same session of working with GnuCash, I return to the same security 
the Get Online Quotes option is not selected but the associated options 
are still intact. However (*second funny*), if I exit GnuCash (after 
saving of course) and then restart it and re-enter the Security Editor 
only those securities that were left ticked as Get Quotes retain the 
option information, all others are reset to the defaults.


These two funnies make getting security prices (using this method) 
somewhat tedious and may mean that I have to really screw up my courage 
and make the changes to the file.


Anticipating that one day I will screw up enough courage I have been 
investigating the file Alphavantage.pm. On my system I have five of 
them; in the directory ~/.cpan/build I have five directories three of 
the form


   Finance-Quote-1.44-0 (they are 1.44-0, 1.45-0 and 1.47-0)

and two of the form

   Finance-Quote-1.47-iGUjLI (both are for 1.47 but with different
   tails, one of them has a closed padlock superimposed on the folder icon)

Is this a *third funny*? Do I need all of them? If not, how do I 
determine which one I do need?


The *fourth **(or is it only the third?) **funny* I've noticed is that 
if I rename a data file the Get Quote column is no longer visible in the 
Security Editor window. It's easy to get back so this funny is trivial 
but, out of interest, as the data file has not changed, why does it happen?


Best wishes

Eric

___
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] Apologies

[Eric Coates]

My apologies. It appears that a messgae I sent with the heading "Getting 
security prices - Funnies" has appeared, twice!,  under the title "Re: 
[GNC] Payroll Management with Time Attendance Machine" as well as under 
its own title


I have no idea how this happened.

Sorry

Eric

It's also possible that this message will appear multiple times. If so, 
I need some sackchoth and ashes.


___
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] Importing buying shares transactions

[One Click To Qif]

Hi David:

I had version 2.6.14 installed and I installed 3.4.
However, it is obvious that this functionality does not work: GnuCash
cannot import transactions of shares, not even in the format exported
by itself.
I will have to manually introduce them.
Very disappointing.

Thanks for your answer in any case.
Regards


On Mon, Mar 4, 2019 at 10:50 PM David Cousens  wrote:
>
> The following refers primarily to importing in V3.3 and later. The CSV
> importer was rewritten going from 2.6.  to v3.0 and was likely only tested
> on basic functionality. At the moment I am doing extensive systematic
> testing of the CSV importer and settings with a view to identifying as many
> of the problems as possible and fixing them.
>
> The CSV importer currently does not work properly importing multi currency
> transactions. I have not yet tested it on trading accounts specifically but
> that is in the todo loop for the near future. With multicurrency imports one
> problem is associated with applying the price so it is possible the same
> problem extends to trading accounts.  There also appear to be some problems
> with the transaction export using File->Export Transactions to CSV as it
> only appears to export the headers and no data. I have found File->Export
> Transactions from Active Register is working correctly for single currency
> transactions and multicurrency transactions so far.
>
> To have a chance at importing it use the GnuCash Export Settings in the
> import and leave all the other settings at the default settings apart from
> the multisplit check box which needs to be checked to import multiline data
> and setting the correct date format. It is usually necessary to play around
> a bit with the assignment of columns as the headers and column labels aren't
> always a 1-1 match.  If you do find a combination of settings which works
> could you please let me know.
>
> There is a problem with date formats in that the locale setting is not
> currently being used to set the default date format. Once it is matched
> though it usually works OK. I usually have to reset it to my usual local
> format on all imports.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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] apply coefficient to an account

[Peter Münster]

On Tue, Mar 05 2019, Derek Atkins wrote:

> I would recommend you run the existing P&L report, then take the output,
> copy it into a spreadsheet, and then add your coefficients there.

That would be my last resort. Just to show you, that this would be some
work:
- http://pmrb.free.fr/tmp/gnucash-example.html is the output
- I would need to apply 50% to "équipement nautique" for example
- 70% to "salarié" for example
- then I need to adjust the "Total Dépenses" and the "Total Revenus"

Some automatic method would be preferable...

-- 
   Peter
___
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] apply coefficient to an account

[Peter Münster]

On Tue, Mar 05 2019, John Ralls wrote:

> You could just create two payroll expense accounts, one chargeable and
> one not-chargeable and split the payroll expense between the two.

The payroll expenses come from OFX files from the bank. After importing,
how can I split 30% into one account and 70% into another?


> Then you can run the P&L report with only the chargeable account
> selected.

Yes. If it's possible to do such splitting, then it will be ok.


> Better still, have the employee keep a time sheet recording the time spent on
> each task

No, not an option in our case. Anyway, the 70% split is fixed in the contract.


> and the bookkeeper can assign the expense to chargeable or
> not-chargeable depending on the actual time spent.

The bookkeeper, it's me... ;)


> But using a P&L report for billing is weird.

No, it's not for billing. It's just for showing the results of the
bookkeeping to the public organisation.

Kind regards,
-- 
   Peter
___
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] apply coefficient to an account

[Peter Münster]

On Tue, Mar 05 2019, Stephen M. Butler wrote:

> Could those accounts be treated similar to stock?  Or another
> currency?

I guess no. There are just 2 type of accounts: income in EUR and expense
in EUR. All is imported from the OFX file of the checking account. Here
is the result: http://pmrb.free.fr/tmp/gnucash-example.html


> You would have to enter a price entry in order for GnC to convert them
> to the report "currency".

It sounds like a possible option, kind of work-around.


> PS.  I presume this is a mileage expense factor and Transport holds the
> number of mile?

No, it's all in EUR. Transport is just an example.

-- 
   Peter
___
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] IRC access

[David Carlson]

It seems that the IRC channel has changed and now I need a voice.  How do I
do that?

-- 
David Carlson
___
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] apply coefficient to an account

[John Ralls]

> On Mar 5, 2019, at 10:21 AM, Peter Münster  wrote:
> 
>> ou could just create two payroll expense accounts, one chargeable and
>> one not-chargeable and split the payroll expense between the two.
> 
> The payroll expenses come from OFX files from the bank. After importing,
> how can I split 30% into one account and 70% into another?
> 

Just edit the transaction and add a split. You can type '.3*123.45' and 
'.7*123.45' in the expense debit column, no need to get out your calculator.

Regards,
John Ralls

___
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] IRC access

[Derek Atkins]

Hi,

On Tue, March 5, 2019 2:31 pm, David Carlson wrote:
> It seems that the IRC channel has changed and now I need a voice.  How do
> I
> do that?

If you read the topic when you join the channel, it specifically says:

* Topic for #gnucash is: Free GPL Personal and Small Business Accounting
|| Moderated mode: To get a voice, register with NickServ and then
re-join. || Please don't ask to ask, just ask and wait! (Possibly a few
hours!!) || publicly-logged channel || latest stable: 3.4 ||
www.gnucash.org || wiki.gnucash.org/wiki/

> 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] IRC access

[David Carlson]

I use Pidgin and I cannot figure out how to register with the nickserv.  I
enter

/server irc.gnome.org

  and nothing happens


On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins  wrote:

> Hi,
>
> On Tue, March 5, 2019 2:31 pm, David Carlson wrote:
> > It seems that the IRC channel has changed and now I need a voice.  How do
> > I
> > do that?
>
> If you read the topic when you join the channel, it specifically says:
>
> * Topic for #gnucash is: Free GPL Personal and Small Business Accounting
> || Moderated mode: To get a voice, register with NickServ and then
> re-join. || Please don't ask to ask, just ask and wait! (Possibly a few
> hours!!) || publicly-logged channel || latest stable: 3.4 ||
> www.gnucash.org || wiki.gnucash.org/wiki/
>
> > 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
>
>

-- 
David Carlson
___
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] Getting security prices - Funnies

[John Ralls]

> On Mar 5, 2019, at 9:36 AM, Eric Coates  wrote:
> 
> I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04.
> 
> In the course of some fairly standard (for me) work I have come across a 
> couple of "funnies" and I'm wondering whether they are deliberate, "features" 
> (from Microsoft's vocabulary meaning a bug that won't be fixed), bugs or me 
> doing something wrong.
> 
> On the last day of the month I need to revalue my share portfolio. Like 
> others, I have been a victim of Alphvantage's throttling of their service but 
> unlike others I have not (yet) screwed up my courage and updated the the 
> related file to incorporate the delays suggested.
> 
> I open the Securities Editor, make sure that the Get Quote column is shown 
> (and, for simplicity at this stage, I'll assume no securities are ticked) and 
> then, by double clicking on a security I get to the Security Information 
> window and select Get Online Quotes, click Unknown and select Alphavantage 
> from the drop down. I do this for five securities (no point in doing it for 
> more because of the Alphavantage limitation). In the Price Editor I click Get 
> Quotes and, after a wait, I get the prices for the five securities I selected.
> 
> Having got those five prices I need to select a second batch of securities. 
> But (*first funny*) I cannot deselect the previously selected securities by 
> clicking on the tick - I have to go back to the Security Information to do 
> that. Is that intended?
> 
> Having deselected the Get Quote for a security, I have noted that if, in the 
> same session of working with GnuCash, I return to the same security the Get 
> Online Quotes option is not selected but the associated options are still 
> intact. However (*second funny*), if I exit GnuCash (after saving of course) 
> and then restart it and re-enter the Security Editor only those securities 
> that were left ticked as Get Quotes retain the option information, all others 
> are reset to the defaults.
> 
> These two funnies make getting security prices (using this method) somewhat 
> tedious and may mean that I have to really screw up my courage and make the 
> changes to the file.
> 
> Anticipating that one day I will screw up enough courage I have been 
> investigating the file Alphavantage.pm. On my system I have five of them; in 
> the directory ~/.cpan/build I have five directories three of the form
> 
>   Finance-Quote-1.44-0 (they are 1.44-0, 1.45-0 and 1.47-0)
> 
> and two of the form
> 
>   Finance-Quote-1.47-iGUjLI (both are for 1.47 but with different
>   tails, one of them has a closed padlock superimposed on the folder icon)
> 
> Is this a *third funny*? Do I need all of them? If not, how do I determine 
> which one I do need?
> 
> The *fourth **(or is it only the third?) **funny* I've noticed is that if I 
> rename a data file the Get Quote column is no longer visible in the Security 
> Editor window. It's easy to get back so this funny is trivial but, out of 
> interest, as the data file has not changed, why does it happen?

You might try using yahoo-json instead of Alphavantage. It's not throttled.

First funny: Yes, it's intentional. The check box in the Securities dialog box 
is display-only.
Second funny: That's an artifact of the difference between the in-memory state 
of the Security object and its representation on disk; if  "get quotes" is off 
then the quotes element isn't written out.
Third funny: I haven't seen that before. I've only seen the ones with the tail 
(which I think is randomly generated at build time). I imagine that the lock is 
because the directory belongs to another user. You can run ls -l on it in a 
terminal to see. Once F::Q is installed you don't need any of them.
Fourth funny: That's because the window state of all windows lives in a file 
named after the data file. When you rename the file outside of GnuCash the 
correspondence is lost.

Regards,
John Ralls
 

___
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] IRC access

[John Ralls]

LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/

Regards,
John Ralls

> On Mar 5, 2019, at 11:50 AM, David Carlson  
> wrote:
> 
> I use Pidgin and I cannot figure out how to register with the nickserv.  I
> enter
> 
> /server irc.gnome.org
> 
>  and nothing happens
> 
> 
> On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins  wrote:
> 
>> Hi,
>> 
>> On Tue, March 5, 2019 2:31 pm, David Carlson wrote:
>>> It seems that the IRC channel has changed and now I need a voice.  How do
>>> I
>>> do that?
>> 
>> If you read the topic when you join the channel, it specifically says:
>> 
>> * Topic for #gnucash is: Free GPL Personal and Small Business Accounting
>> || Moderated mode: To get a voice, register with NickServ and then
>> re-join. || Please don't ask to ask, just ask and wait! (Possibly a few
>> hours!!) || publicly-logged channel || latest stable: 3.4 ||
>> www.gnucash.org || wiki.gnucash.org/wiki/
>> 
>>> 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
>> 
>> 
> 
> -- 
> David Carlson
> ___
> 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.

[GNC] shared accounts

[Jeff Abrahamson]

I have some assets that I share with my spouse.  Two examples are our
home and a shared bank account.  In each case, when I compute my own net
worth, I want to consider these joint assets with a pre-determined fraction.

I can certainly create liabilities to offset those assets and then enter
transactions to keep them at the preset fraction.  And expenses paid
from a joint bank account I might record as splits, with half going
against equity (?), the other half to expense.  But I'd rather something
more automatic.  I've not found it, aside from my old standby of python
scripts to do checks and spot errors.  Does such a thing exist in gnucash?

Joint ownership is common in the business world, can anyone point me to
what it's called or how it's handled among accountants?  The closest
I've found is the equity method

for accounting for joint ventures.  This might just be overkill for my
house and a shared bank account.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://www.p27.eu/jeff/
https://www.transport-nantes.com/

___
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] apply coefficient to an account

[Peter Münster]

On Tue, Mar 05 2019, John Ralls wrote:

> Just edit the transaction and add a split. You can type '.3*123.45' and
> '.7*123.45' in the expense debit column, no need to get out your calculator.

Sure. But how can I split *all* transactions of an account the same way?
The only way, that I know, is to split the transactions manually one by one.

-- 
   Peter
___
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] Error on Receivable Ageing Report

[John Dablin via gnucash-user]

Has anyone any ideas about this? Should I have sent it to a different list?
John Dablin

On 01/03/2019 12:20, John Dablin wrote:
I have a small job in retirement maintaining several websites for the 
clients of my only customer, and I use Gnucash to keep track of 
invoices and payments. Something seems to have happened to my data 
file: if I go to Reports > Business > Receivable Ageing and click on 
the total figure for the customer I get the following error message:-


Bad URL: owner=c:
9323130f91d5ffe0b1f033d41994bbe9&acct=af38494ba8eadc84023395e32bdb71d1

I've decompressed the data file, and those numbers seem to be the 
correct GUIDs for the customer and the Accounts Receivable account 
respectively. I'm suspicious about the 'c:', I can't find that in the 
file, but maybe it's nothing to do with the error.


If I run with --debug I only get INFO and MESSG messages in the log, 
and none at the time of the error. It may not be relevant, but when I 
open the Receivable Ageing report I get these:-


* 12:08:18  INFO  [gnc_plugin_page_report_setup] report-id: 0
* 12:08:18  INFO  [gnc_plugin_page_report_setup] set needs save
* 12:08:18  INFO  [gnc_gsettings_register_cb] 
schema: general.report, key: default-zoom, settings_ptr: 
0x55e1473c8c30, handler_id: 7264
* 12:08:18  INFO  [gnc_plugin_page_report_realize_uri] 
Realized Container size is 1w x 1h

* 12:08:18  INFO  [qof_object_foreach] type=Split
* 12:08:18  INFO  [qof_collection_foreach] Hash Table size 
of Split before is 275
* 12:08:18  INFO  [qof_collection_foreach] Hash Table size 
of Split after is 275
* 12:08:18  INFO  [qof_query_run_internal] matching 
objects=0x55e1489ce560 count=275

* 12:08:18  INFO  [qof_object_foreach] type=Split
* 12:08:18  INFO  [qof_collection_foreach] Hash Table size 
of Split before is 275
* 12:08:18  INFO  [qof_collection_foreach] Hash Table size 
of Split after is 275
* 12:08:18  INFO  [qof_query_run_internal] matching 
objects=0x55e1488f82a0 count=147


This is Gnucash 3.3 running under KDE on Kubuntu 18.10.

Thanks in anticipation for any help in solving this.

John Dablin



___
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] IRC access

[Derek Atkins]

/msg nickserv help register


On Tue, March 5, 2019 2:50 pm, David Carlson wrote:
> I use Pidgin and I cannot figure out how to register with the nickserv.  I
> enter
>
> /server irc.gnome.org
>
>   and nothing happens
>
>
> On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins  wrote:
>
>> Hi,
>>
>> On Tue, March 5, 2019 2:31 pm, David Carlson wrote:
>> > It seems that the IRC channel has changed and now I need a voice.  How
>> do
>> > I
>> > do that?
>>
>> If you read the topic when you join the channel, it specifically says:
>>
>> * Topic for #gnucash is: Free GPL Personal and Small Business Accounting
>> || Moderated mode: To get a voice, register with NickServ and then
>> re-join. || Please don't ask to ask, just ask and wait! (Possibly a few
>> hours!!) || publicly-logged channel || latest stable: 3.4 ||
>> www.gnucash.org || wiki.gnucash.org/wiki/
>>
>> > 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
>>
>>
>
> --
> David Carlson
>


-- 
   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] MySQL

[Keith Bellairs]

For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
my xml file exportable to mysql? If so, is there a writeup? I tried a
couple of obvious things (save as, make myself a dba, create Gnucash schema
in mysql) and made no progress.

Keith
___
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] Fwd: Relative paths in transaction associations

[Justin Haynes]

This all worked very well and was very simple in a text editor.  The
process was deterministic - there was no text that matched my searches
other than what needed to be replaced.  I'll summarize for posterity:

Problem:  The problem was that I wanted to be able to use GNUCash from
multiple computers with multiple OSes and to have access to the files
associated to the transactions, such as receipts.

Solution:  The solution was twofold.

1. Enable the already-present feature meant for this very purpose in   Edit
-> Preferences -> General -> Path head for Transaction Association Files,
so that all future files I attach to transactions would be to relative
paths, and so that GNUCash would know where to find the files when I right
click on a transaction and click
Open Associated File/Location.
2. Replace all my absolute paths in my xml file with relative ones.  This
was as simple as replacing all occurrences of  "file:///" with
"file:/" where  was any number of things for the past 3
computers I used over the years.  I did the replacement for as many sets of
absolute paths corresponded to past locations on those computers.  This
left only a relative path.

Since the path head is stored in preferences local to the current
installation, I don't have to do anything special moving from one computer
to the next.  GNUCash knows where to look for files under the path head.

Additionally I use a cloud service to synchronize my files to the correct
location on each computer so that I only have to attach once from whichever
computer I happen to be using.  And likewise from any computer I can refer
to the receipts by simply right clicking on the transaction -> Open
Associated File/Location

As David said, work from a backup.  Meaning:

1. close gnucash.
2. copy the gnucash file to another location entirely.
3. use a utiilty that can extract .zip files, and open this .gnucash file
(only necessary if your gnucash is zipping your files . This is the default
behavior).
4. Edit the resulting file.  Rezip it and rename it so that the zip file is
ending in .gnucash.
5. When satisfied, BACKUP the original file AGAIN, and replace the original
with your edited zipped gnucash file.


Redundant to put this all in the same email, I know, but perhaps a future
user will find all this in one place and be happy.



On Fri, Feb 15, 2019 at 8:24 PM D  wrote:

> Justin,
>
> Probably, your best bet is to dig in to the data file directly and change
> the entries there.
>
> NOTE: editing your data file directly can be risky. Always work on a
> backup copy!!!
>
> How you go about this depends on the way you have your data stored (XML,
> database).
>
> XML is straight text, although by default it's compressed (change the
> setting in preferences to store it without compression), so a find and
> replace in a text editor would suffice.
>
> The db backend will require digging around for the table in question, and
> developing an appropriate SQL command.
>
> Oh. Did I mention that you should do this on a backup? You should.
>
> David
>
> On February 16, 2019, at 12:44 AM, Justin Haynes 
> wrote:
>
> OK everything worked as expected, and I can switch between disparate
> machines and still have access to associations!
>
> So I only have one remaining question:Where should I look in the data file
> or in the code or documentation to discover how to programmatically or
> using a text editor change all the absolute paths in my current
> associations to relative ones?
>
> Thanks!,
>
> Justin
>
>
>
> On Feb 13, 2019, at 11:18 AM, Justin Haynes 
> wrote:
>
> OK, so I can see that with a populated "Path head for Transaction
> Association Files", that linking transactions to files after this is
> populated, results in the "Relative" field being checked next to the
> corresponding entry in the "All Transaction Associations" window, and an
> absolute path in the window.  When I have my other laptop, I can experiment
> to see if changing the Path head configured in GNUCash on that laptop will
> result in GNUCash on that machine finding the files associated when I click
> on Open Associated File/Location from the corresponding Transaction.
>
> Second Question: if my experiment works, and GNUCash behaves the way I
> would like, how can I go back and change the links to all previously
> created transaction associations to be relative links to the same files?
>
> Thanks,
>
> Justin
>
> On Wed, Feb 13, 2019 at 10:46 AM Justin Haynes 
> wrote:
>
> > Found it.
> >
> > Edit -> Preferences -> General -> Path head for Transaction Association
> > Files.
> >
> > Now i just need to experiment with it to see how it behaves.
> >
> > On Wed, Feb 13, 2019 at 10:43 AM Justin Haynes 
> > wrote:
> >
> >> What provision is there for relative paths in transaction associations?
> >> I often associate transactions with files where the files are almost
> always
> >> receipts.  This results in a URL to an absolute path which appears in
> the
> >> Tools -> Transaction Associations dialog. 

Re: [GNC] IRC access

[David Carlson]

That looks like what I need.  Could that link and perhaps more for other
clients be added to the GnuCash faq for IRC access, probably in section on
client setup with a reference by the section about getting a voice.

David Carlson

On Tue, Mar 5, 2019, 1:56 PM John Ralls 
wrote:

> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/
>
> Regards,
> John Ralls
>
> > On Mar 5, 2019, at 11:50 AM, David Carlson 
> wrote:
> >
> > I use Pidgin and I cannot figure out how to register with the nickserv.
> I
> > enter
> >
> > /server irc.gnome.org
> >
> >  and nothing happens
> >
> >
> > On Tue, Mar 5, 2019 at 1:40 PM Derek Atkins  wrote:
> >
> >> Hi,
> >>
> >> On Tue, March 5, 2019 2:31 pm, David Carlson wrote:
> >>> It seems that the IRC channel has changed and now I need a voice.  How
> do
> >>> I
> >>> do that?
> >>
> >> If you read the topic when you join the channel, it specifically says:
> >>
> >> * Topic for #gnucash is: Free GPL Personal and Small Business Accounting
> >> || Moderated mode: To get a voice, register with NickServ and then
> >> re-join. || Please don't ask to ask, just ask and wait! (Possibly a few
> >> hours!!) || publicly-logged channel || latest stable: 3.4 ||
> >> www.gnucash.org || wiki.gnucash.org/wiki/
> >>
> >>> 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
> >>
> >>
> >
> > --
> > David Carlson
> > ___
> > 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] gnucash-user Digest, Vol 192, Issue 7

[varda241--- via gnucash-user]

Is there any way to select more than one transaction for deleting or 
duplicating? I normally start a new checking account each January, but did not 
do it this year till now, due to 
moving.Sent from my Verizon ASUS tablet

 Original Message 
From:gnucash-user-requ...@gnucash.org
Sent:Tue, 05 Mar 2019 12:00:01 -0500
To:gnucash-user@gnucash.org
Subject:gnucash-user Digest, Vol 192, Issue 7

>Send gnucash-user mailing list submissions to
>   gnucash-user@gnucash.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
>   https://lists.gnucash.org/mailman/listinfo/gnucash-user
>or, via email, send a message with subject or body 'help' to
>   gnucash-user-requ...@gnucash.org
>
>You can reach the person managing the list at
>   gnucash-user-ow...@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:  apply coefficient to an account (Derek Atkins)
>   2. Re:  Payroll Management with Time Attendance Machine
>  (Adrien Monteleone)
>   3. Re:  Payroll Management with Time Attendance Machine (John Ralls)
>   4. Re:  apply coefficient to an account (John Ralls)
>   5. Re:  Payroll Management with Time Attendance Machine (John Ralls)
>
>
>--
>
>Message: 1
>Date: Tue, 5 Mar 2019 11:07:47 -0500
>From: "Derek Atkins" 
>To: "Gnucash User" 
>Subject: Re: [GNC] apply coefficient to an account
>Message-ID:
>   <2718171290716f7eeb77ddb5f6c80d56.squir...@mail2.ihtfp.org>
>Content-Type: text/plain;charset=utf-8
>
>I would recommend you run the existing P&L report, then take the output,
>copy it into a spreadsheet, and then add your coefficients there.
>
>-derek
>
>On Tue, March 5, 2019 10:21 am, Peter M?nster wrote:
>> On Tue, Mar 05 2019, John Ralls wrote:
>>
>>> Apply the coefficients how and with what intended result?
>>
>> It's just a multiplication. If there is for example 1000? in an account
>> and 0.7 must be applied, then there must be 700? instead of 1000? in
>> the report. Our kayak club has a contract with a public organisation,
>> and we must deliver a report, that shows only a part of the whole
>> accounting of the club, only the part that concerns the contract. So for
>> example 75% of the salary, because the employee spends 25% of his time
>> with tasks, that are not connected to the contract.
>>
>>
>>> Failing there being a report that gets you close enough to what you need
>>> you
>>> can customize the P&L report:
>>> https://wiki.gnucash.org/wiki/Custom_Reports
>>
>> Ok. So I need to learn Scheme, Guile and so on? Or can I hire somebody
>> here on the list, who could do that for me? That would be nice.
>>
>> Kind regards,
>> --
>>Peter
>> ___
>> 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.
>>
>
>
>-- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
>
>
>
>--
>
>Message: 2
>Date: Tue, 5 Mar 2019 10:16:38 -0600
>From: Adrien Monteleone 
>To: gnucash-user 
>Subject: Re: [GNC] Payroll Management with Time Attendance Machine
>Message-ID: <40e2da94-8218-482a-b75c-a56347395...@lusfiber.net>
>Content-Type: text/plain;  charset=utf-8
>
>Jason,
>
>I?m not sure what ?Time Management Attendance Machine? is, but in general, no, 
>you?d need to keep your time sheets separately. (There are plenty of 
>stand-alone software options for this, as well as spreadsheet templates, or 
>you could roll your own spreadsheet)
>
>GnuCash does not have a built-in payroll module but some people use it for 
>payroll. Payroll calculation can be very difficult and is very locale 
>specific. You might be able to use Scheduled Transactions for this but if your 
>pay practices vary wildly, you might be better off doing the calculations in a 
>spreadsheet, generating the resulting transaction, importing it to GnuCash and 
>then printing your checks.
>
>See the wiki on ?Using GnuCash? for more help in this area, or do a list 
>search on the topic.
>
>You will also find info there on using the check printing feature to create 
>pay stubs with the checks.
>
>As for tracking allowances automatically, you could utilize the Scheduled 
>Transactions feature to generate a liability for each one as they are earned 
>(similar to how cash pay is earned) and simply not approve the creation of the 
>transaction for those who didn?t work that day/period.
>
>Regards,
>Adrien
>
>> On Mar 5, 

[GNC] A/R, A/P and Balance Sheet Discrepancies

[Tom Balaban]

Hello,

I am experiencing some strange behavior with my Aged A/R, Aged A/P and 
Balance Sheet.


When I run the three reports using "Today" the amounts showing in the 
Balance Sheet completely agrees with what appears on the respective 
aging reports.


When I change the date on all 3 to the "End of previous month" the aging 
reports are unchanged (as they should be at this moment) but the Balance 
Sheet no longer shows the correct AP or AR


To be specific, my aged AR balance from the aging report is ($525.35) 
both using today and Feb 28.


My aged AP balance from the aging report is $83.65 both using today and 
Feb 28.


My Balance Sheet as of "Today" shows AR: ($525.35) and AP: $83.65. Both 
correct.


My Balance Sheet as of "End of previous month" shows AR: ($377.35) and 
AP: $274.90. Neither correct.


Any thoughts?

Thanks for reading
___
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] Suggestions for personal use of GnuCash

[rrowan]

I ran dual last year with MMEX (using since 2013) and GnuCash for personal 
finances. Today I tried to set up loans/mortgages that I have lent, not 
borrowed, but could not select from assets.

Please consider those of us who are lenders and not borrowers.

Also, personal use does not require vendors and customers as distinct entities. 
A simpler approach would be to tie to a contacts file. I use the "description" 
field inconsistencies can result from not using a source file when typing in a 
name in another account. 

To simplify the development of such a feature, consider a common 
contact list such as from gmail as most every user would have access to that 
file. Later releases could add other databases such as Apple's. 

Thank you very much.
Richard E. Rowan
___
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] MySQL

[David Cousens]

Keith,

See the following links for setup on MacOSX with MySQL

https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html
https://wiki.gnucash.org/wiki/MacOS_Installation
https://lists.gnucash.org/pipermail/gnucash-user/2011-February/038511.html
http://www.matt-thornton.net/tech/databases/gnucash-mysql-os-x-10-10-getting-it-running

I'm not a mySQL or MacOSX user. Someone else may be able to give you more
specific information.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Error on Receivable Ageing Report

[Christopher Lam]

https://bugs.gnucash.org/show_bug.cgi?id=796772
Should be fixed in 3.4

On Wed, 6 Mar 2019 at 04:33, John Dablin via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Has anyone any ideas about this? Should I have sent it to a different list?
> John Dablin
>
> On 01/03/2019 12:20, John Dablin wrote:
> > I have a small job in retirement maintaining several websites for the
> > clients of my only customer, and I use Gnucash to keep track of
> > invoices and payments. Something seems to have happened to my data
> > file: if I go to Reports > Business > Receivable Ageing and click on
> > the total figure for the customer I get the following error message:-
> >
> > Bad URL: owner=c:
> > 9323130f91d5ffe0b1f033d41994bbe9&acct=af38494ba8eadc84023395e32bdb71d1
> >
> > I've decompressed the data file, and those numbers seem to be the
> > correct GUIDs for the customer and the Accounts Receivable account
> > respectively. I'm suspicious about the 'c:', I can't find that in the
> > file, but maybe it's nothing to do with the error.
> >
> > If I run with --debug I only get INFO and MESSG messages in the log,
> > and none at the time of the error. It may not be relevant, but when I
> > open the Receivable Ageing report I get these:-
> >
> > * 12:08:18  INFO  [gnc_plugin_page_report_setup] report-id: 0
> > * 12:08:18  INFO  [gnc_plugin_page_report_setup] set needs save
> > * 12:08:18  INFO  [gnc_gsettings_register_cb]
> > schema: general.report, key: default-zoom, settings_ptr:
> > 0x55e1473c8c30, handler_id: 7264
> > * 12:08:18  INFO  [gnc_plugin_page_report_realize_uri]
> > Realized Container size is 1w x 1h
> > * 12:08:18  INFO  [qof_object_foreach] type=Split
> > * 12:08:18  INFO  [qof_collection_foreach] Hash Table size
> > of Split before is 275
> > * 12:08:18  INFO  [qof_collection_foreach] Hash Table size
> > of Split after is 275
> > * 12:08:18  INFO  [qof_query_run_internal] matching
> > objects=0x55e1489ce560 count=275
> > * 12:08:18  INFO  [qof_object_foreach] type=Split
> > * 12:08:18  INFO  [qof_collection_foreach] Hash Table size
> > of Split before is 275
> > * 12:08:18  INFO  [qof_collection_foreach] Hash Table size
> > of Split after is 275
> > * 12:08:18  INFO  [qof_query_run_internal] matching
> > objects=0x55e1488f82a0 count=147
> >
> > This is Gnucash 3.3 running under KDE on Kubuntu 18.10.
> >
> > Thanks in anticipation for any help in solving this.
> >
> > John Dablin
> >
> >
> ___
> 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] Suggestions for personal use of GnuCash

[Rich Shepard]

On Tue, 5 Mar 2019, rro...@pdsconnect.me wrote:


I ran dual last year with MMEX (using since 2013) and GnuCash for personal
finances. Today I tried to set up loans/mortgages that I have lent, not
borrowed, but could not select from assets.


Richard,

I am not an accountant but my off-hand idea is to your loans/mortgages as
accounts receiveable assets. Set up A/R and as many sub-accounts as you
need. Your accountant has the final say, of course.


Also, personal use does not require vendors and customers as distinct
entities.


So, ignore them. For contacts use a Palm Pilot.


To simplify the development of such a feature, consider a common
contact list such as from gmail as most every user would have access to
that file. Later releases could add other databases such as Apple's.


Except not all of us use gmail, Apple products, or Microsoft's stuff.

Why don't you set up your mortgagees and loan recipients as customers and
put their information in that table?

Be innovative and make GnuCash work for you rather than asking the devs to
fulfill your specific needs.

Rich
___
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] A/R, A/P and Balance Sheet Discrepancies

[Rich Shepard]

On Tue, 5 Mar 2019, Tom Balaban wrote:


Any thoughts?


Hi Tom,

Have you looked to see if some transactions are still marked as uncleared?
Perhaps that makes a difference when the report end date is prior to the
current date.

Rich
___
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] gnucash-user Digest, Vol 192, Issue 7

[David Cousens]

At present there is no way to multiply select transaction records in the
account registers for actions upon them including deleting them.

Why do you need to start a new checking account? You can use the
View->FilterBy to restrict displays to a specific date period and you can
set the current accounting period in the Edit->Preferences dialog. All
reports can have the date or a date range specified for them. 

GnuCash does have an Accounting Close Books function to zero out the income
ans expense accounts for a new accounting period for those of us who stick
to formal accounting procedure, but it is not necessary to use it as GnuCash
is setup that way. This would not normally be done toasset accounts in any
case.

Consult the Tutorial and User Guide
https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html and Help manuals
https://www.gnucash.org/docs/v3/C/gnucash-help/help.html for detailed
instructions on using GnuCash.


David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] apply coefficient to an account

[John Ralls]

> On Mar 5, 2019, at 12:10 PM, Peter Münster  wrote:
> 
> On Tue, Mar 05 2019, John Ralls wrote:
> 
>> Just edit the transaction and add a split. You can type '.3*123.45' and
>> '.7*123.45' in the expense debit column, no need to get out your calculator.
> 
> Sure. But how can I split *all* transactions of an account the same way?
> The only way, that I know, is to split the transactions manually one by one.

Unfortunately for that you're back to programming, though you can choose Python 
or C as well as Scheme.

Regards,
John Ralls

___
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] MySQL

[John Ralls]

> On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> 
> For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> my xml file exportable to mysql? If so, is there a writeup? I tried a
> couple of obvious things (save as, make myself a dba, create Gnucash schema
> in mysql) and made no progress.

You need to create a user and grant it pretty much everything, then provide 
that userid and password and let GnuCash create the database.

Regards,
John Ralls

___
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] apply coefficient to an account

[Stephen M. Butler]

On 3/5/19 10:29 AM, Peter Münster wrote:
> On Tue, Mar 05 2019, Stephen M. Butler wrote:
>
>> Could those accounts be treated similar to stock?  Or another
>> currency?
> I guess no. There are just 2 type of accounts: income in EUR and expense
> in EUR. All is imported from the OFX file of the checking account. Here
> is the result: http://pmrb.free.fr/tmp/gnucash-example.html
>
>
>> You would have to enter a price entry in order for GnC to convert them
>> to the report "currency".
> It sounds like a possible option, kind of work-around.


After reading your other emails, this weird work-around probably isn't
an option.

>
>
>> PS.  I presume this is a mileage expense factor and Transport holds the
>> number of mile?
> No, it's all in EUR. Transport is just an example.
>
Shucks!


Oh, are you using a Sqlite data store?  If so, you might be able to
write a query to pull those accounts and apply the percentages.  You
could load the account names and percentages into a new table and drive
the query from there. 


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Error on Receivable Ageing Report

[John Dablin via gnucash-user]

Thanks for the link, it's reassuring that it's not a corruption of my 
data file. I've no wish to get bogged down with building GC from source, 
so I'll keep my fingers crossed that Ubuntu 19.4 provides version 3.4. 
It's not a show-stopper anyway.


John Dablin

On 05/03/2019 21:54, Christopher Lam wrote:

https://bugs.gnucash.org/show_bug.cgi?id=796772
Should be fixed in 3.4

On Wed, 6 Mar 2019 at 04:33, John Dablin via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


Has anyone any ideas about this? Should I have sent it to a
different list?
John Dablin

On 01/03/2019 12:20, John Dablin wrote:
> I have a small job in retirement maintaining several websites
for the
> clients of my only customer, and I use Gnucash to keep track of
> invoices and payments. Something seems to have happened to my data
> file: if I go to Reports > Business > Receivable Ageing and
click on
> the total figure for the customer I get the following error
message:-
>
> Bad URL: owner=c:
>
9323130f91d5ffe0b1f033d41994bbe9&acct=af38494ba8eadc84023395e32bdb71d1
>
> I've decompressed the data file, and those numbers seem to be the
> correct GUIDs for the customer and the Accounts Receivable account
> respectively. I'm suspicious about the 'c:', I can't find that
in the
> file, but maybe it's nothing to do with the error.
>
> If I run with --debug I only get INFO and MESSG messages in the
log,
> and none at the time of the error. It may not be relevant, but
when I
> open the Receivable Ageing report I get these:-
>
> * 12:08:18  INFO  [gnc_plugin_page_report_setup]
report-id: 0
> * 12:08:18  INFO  [gnc_plugin_page_report_setup] set
needs save
> * 12:08:18  INFO 
[gnc_gsettings_register_cb]
> schema: general.report, key: default-zoom, settings_ptr:
> 0x55e1473c8c30, handler_id: 7264
> * 12:08:18  INFO  [gnc_plugin_page_report_realize_uri]
> Realized Container size is 1w x 1h
> * 12:08:18  INFO  [qof_object_foreach] type=Split
> * 12:08:18  INFO  [qof_collection_foreach] Hash
Table size
> of Split before is 275
> * 12:08:18  INFO  [qof_collection_foreach] Hash
Table size
> of Split after is 275
> * 12:08:18  INFO  [qof_query_run_internal] matching
> objects=0x55e1489ce560 count=275
> * 12:08:18  INFO  [qof_object_foreach] type=Split
> * 12:08:18  INFO  [qof_collection_foreach] Hash
Table size
> of Split before is 275
> * 12:08:18  INFO  [qof_collection_foreach] Hash
Table size
> of Split after is 275
> * 12:08:18  INFO  [qof_query_run_internal] matching
> objects=0x55e1488f82a0 count=147
>
> This is Gnucash 3.3 running under KDE on Kubuntu 18.10.
>
> Thanks in anticipation for any help in solving this.
>
> John Dablin
>
>
___
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] Suggestions for personal use of GnuCash

[David Cousens]

Richard,

Rich Shepherd's approach is aprt of the way to accounting for a loan made
but one would not usually use the business features for doing this. When you
borrow money the loan is setup as a liability account as you are obligated
to pay it back. Where you make a loan it will be setup as an asset. You will
need to create an appropriate loan account depending upon the term of the
loan. If it is short term and to be repaid within an accounting year you
would set it upunder current assets otherwise you can use a general asset
account. E.g.

Asset:Loan

Normally when accounting for a loan you need to know what the principal
originally was, what  interest has accumulated on the loan, what repayments
of the principal have been made and what the current outstanding value of
the loan is. This can be achieved  by creating a number of subaccounts to
the above account as follows with the Asset:Loan account as a placeholder
account only. 

Asset:Loan
Asset:Loan:Principal
Asset:Loan:Accumulated interest
Asset:Loan:Repayments

When you make the loan, you credit (withdraw from) an appropriate bank
account and debit the Asset:Loan:Principal account by the same amount.

When you add interest to the loan amount, you debit the
Asset:Loan:Accumulated interest account and credit an appropriate
Income:Interest account.

When the creditor makes a payment to you, you credit the
Asset:Loan:Repayments account and debit an appropriate bank account for the
payment loan.

The total displayed by the placeholder account will be the outstanding loan
amount.

If the transactions are regular you can use the scheduled transaction
editor. Where values change , e.g. interest the amount of the scheduled
transaction can be edited to the correct value.

See https://www.gnucash.org/docs/v3/C/gnucash-help/setup-accounts.html for
deatils of creating and editing accounts.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Error on Receivable Ageing Report

[Stephen M. Butler]

On 3/5/19 2:33 PM, John Dablin via gnucash-user wrote:
> Thanks for the link, it's reassuring that it's not a corruption of my
> data file. I've no wish to get bogged down with building GC from
> source, so I'll keep my fingers crossed that Ubuntu 19.4 provides
> version 3.4. It's not a show-stopper anyway.
>
> John Dablin
>
> On 05/03/2019 21:54, Christopher Lam wrote:
>> https://bugs.gnucash.org/show_bug.cgi?id=796772
>> Should be fixed in 3.4

If you are willing to trust my compilation of 3.4, try the files from
this folder in Google Drive (others have had success):

https://drive.google.com/open?id=1fV_fURy6c77e7gf6S41lTacM7dFyy7VD


You should find:

gnucash_3.4_amd64.deb

gnucash-common.3.4_all.deb

python3-gncucash_3.4_amd64.deb


Please uninstall your current version and the:

cd Downloads

sudo apt install ./*_3.4_*.deb


Please note the leading ./ on the file names.  Else apt will attempt to
install from the Ubuntu repository.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
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] Suggestions for personal use of GnuCash

[David Cousens]

Richard

For personal use just select Common Accounts and deselect the Business
Accounts when creating the account heirarchy. This is usually the default
setup. For an existing heirarchy make sure there are no transactions to the
A/R, A/P accounts ( transfer them to other accounts as appropriate) and
delete them from the account heirarchy.

There is no contacts database outside the customer/vendor lists in the
business features and I don't think there are any plans to add one.

You can use cut and paste within the description field or even simpler use
Transaction->Transaction Duplicate to duplicate an existing transaction
containing the description item you wish to use and then edit the date
description accounts and amounts in the duplicated transaction as
appropriate to create a new transaction using a common descriptor item as a
tag. You could also maintain a list in another text file open in a text
editor or spreadsheet (at least sortable) and cut and paste from it as
required.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] MySQL

[David T. via gnucash-user]

John, for MySQL, don't Mac users have to build Gnucash with the appropriate 
libdbd-mysql dependency added in? ISTR at some point that we needed to build 
gnucash ourselves to add this functionality.  Or am I misremembering?

David T.
 
 
  On Wed, Mar 6, 2019 at 3:50, John Ralls wrote: 
  

> On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> 
> For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> my xml file exportable to mysql? If so, is there a writeup? I tried a
> couple of obvious things (save as, make myself a dba, create Gnucash schema
> in mysql) and made no progress.

You need to create a user and grant it pretty much everything, then provide 
that userid and password and let GnuCash create the database.

Regards,
John Ralls

___
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] Delete multiple transactions (was: gnucash-user Digest, Vol 192, Issue 7)

[David T. via gnucash-user]

Of course, should the user wish to delete all records after a given date (or 
before) they could use the same filtering technique to create a view of the 
offending records and one by one delete them until the view is empty. This can 
happen pretty quickly, once the user tells gnucash to delete without 
confirmation for the rest of the session. 
David T. 
P.S. to the original poster: common etiquette when replying to a digest is to 
change the subject line from Digest to something meaningful. Better yet, create 
a new message altogether and put your subject in that. 

 
 
  On Wed, Mar 6, 2019 at 3:45, David Cousens wrote:   
At present there is no way to multiply select transaction records in the
account registers for actions upon them including deleting them.

Why do you need to start a new checking account? You can use the
View->FilterBy to restrict displays to a specific date period and you can
set the current accounting period in the Edit->Preferences dialog. All
reports can have the date or a date range specified for them. 

GnuCash does have an Accounting Close Books function to zero out the income
ans expense accounts for a new accounting period for those of us who stick
to formal accounting procedure, but it is not necessary to use it as GnuCash
is setup that way. This would not normally be done toasset accounts in any
case.

Consult the Tutorial and User Guide
https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html and Help manuals
https://www.gnucash.org/docs/v3/C/gnucash-help/help.html for detailed
instructions on using GnuCash.


David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

[GNC] GNUCash 3.4 has bug for US Tax forms which is using wrong beginning value.

[Brian via gnucash-user]

I discovered that my 1120S entity had the wrong totals for the
Cash/Assets on the Tax Income/Deductible Expenses Report (tax report)
compared to the Transaction Record for the Account. I then ran the tax
report with show transaction detail and noticed that the beginning
balance was wrong.  On looking at the accounts it appeared any
transaction with a 12/31 date of the previous account period was being
excluded from the beginning balance total.  

On looking at bugzilla closed and open issues, there was  the same
problem with a fix closing the issue reported on January 19, 2019.  The
simple fix is available by going to the maint branch and downloading
the taxtxf.scm from
https://github.com/Gnucash/gnucash/tree/maint/gnucash/report/locale-specific/us

On Linux I renamed 
/usr/share/gnucash/scm/gnucash/report/taxtxf.scm 
to
taxtxf.scm.orig
 and replaced the file with the one from maint git,
restated GNUCash and all was corrected. 

FYI.  Hope the Helps some one else.
Cheers, Brian Amundsen, Mounds View MN
___
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] IRC access

[Frank H. Ellenberger]

Am 05.03.19 um 20:56 schrieb John Ralls:
> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/
> 
> Regards,
> John Ralls

or read (and improve) the wiki ;.)
https://wiki.gnucash.org/wiki/IRC#Usage

~Frank

___
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] MySQL

[John Ralls]

David,

For 2.6 yes. For 3.x everything is in the bundle for all three database 
backends just like Windows.

Regards,
John Ralls

> On Mar 5, 2019, at 6:12 PM, David T.  wrote:
> 
> John, for MySQL, don't Mac users have to build Gnucash with the appropriate 
> libdbd-mysql dependency added in? ISTR at some point that we needed to build 
> gnucash ourselves to add this functionality.  Or am I misremembering?
> 
> 
> David T.
> 
> 
> On Wed, Mar 6, 2019 at 3:50, John Ralls
>  wrote:
> 
> 
> > On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> > 
> > For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> > my xml file exportable to mysql? If so, is there a writeup? I tried a
> > couple of obvious things (save as, make myself a dba, create Gnucash schema
> > in mysql) and made no progress.
> 
> You need to create a user and grant it pretty much everything, then provide 
> that userid and password and let GnuCash create the database.
> 
> Regards,
> John Ralls
> 
> 
> ___
> 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.

[GNC] printing from version 3.2

[Chris Roy-Smith]

Hi,

up until there was an update to gnucash v3.2 I had no problems printing, 
as all available printers were listed in the print dialogue.


After the update to 3.2, I only get the option to print to file, or lpt. 
Printing to file works exactly as I would expect. However, printing to 
lpt appears to do nothing. The is an input field labeled "Command 
line:", and "lpt" is already in this field.


How am I supposed to print (to a printer)?

All hints gratefully received

Chris Roy-Smith

___
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] IRC access

[John Ralls]

> On Mar 5, 2019, at 8:01 PM, Frank H. Ellenberger 
>  wrote:
> 
> Am 05.03.19 um 20:56 schrieb John Ralls:
>> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/
>> 
>> Regards,
>> John Ralls
> 
> or read (and improve) the wiki ;.)
> https://wiki.gnucash.org/wiki/IRC#Usage

I don't think it's reasonable or practical to replicate all of mankind's 
knowledge in our Wiki. It makes sense that we include information about GnuCash 
itself. It does not make sense to document every random piece of software that 
some user may use to communicate with us, particularly if that documentation is 
readily available on the web.

Regards,
John Ralls

___
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] MySQL

[David T. via gnucash-user]

Thanks for clarifying.

I'm probably also mixing some of this in with the whole Python on Macs issue.


David
 
 
  On Wed, Mar 6, 2019 at 10:11, John Ralls 
wrote:   David,

For 2.6 yes. For 3.x everything is in the bundle for all three database 
backends just like Windows.

Regards,
John Ralls

> On Mar 5, 2019, at 6:12 PM, David T.  wrote:
> 
> John, for MySQL, don't Mac users have to build Gnucash with the appropriate 
> libdbd-mysql dependency added in? ISTR at some point that we needed to build 
> gnucash ourselves to add this functionality.  Or am I misremembering?
> 
> 
> David T.
> 
> 
> On Wed, Mar 6, 2019 at 3:50, John Ralls
>  wrote:
> 
> 
> > On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> > 
> > For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> > my xml file exportable to mysql? If so, is there a writeup? I tried a
> > couple of obvious things (save as, make myself a dba, create Gnucash schema
> > in mysql) and made no progress.
> 
> You need to create a user and grant it pretty much everything, then provide 
> that userid and password and let GnuCash create the database.
> 
> Regards,
> John Ralls
> 
> 
> ___
> 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] IRC access

[David T. via gnucash-user]

I agree. It would be appropriate to have brief information related to gnucash 
on IRC, with pointers to official resources. 
90% of the content in the current page should go. The introductory paragraph 
followed by the server, channel, and link to IRC download and help pages should 
be it. 
David T.

 
 
  On Wed, Mar 6, 2019 at 10:18, John Ralls 
wrote:   

> On Mar 5, 2019, at 8:01 PM, Frank H. Ellenberger 
>  wrote:
> 
> Am 05.03.19 um 20:56 schrieb John Ralls:
>> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/
>> 
>> Regards,
>> John Ralls
> 
> or read (and improve) the wiki ;.)
> https://wiki.gnucash.org/wiki/IRC#Usage
 
I don't think it's reasonable or practical to replicate all of mankind's 
knowledge in our Wiki. It makes sense that we include information about GnuCash 
itself. It does not make sense to document every random piece of software that 
some user may use to communicate with us, particularly if that documentation is 
readily available on the web.

Regards,
John Ralls

___
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] apply coefficient to an account

[elvis]

Hi Peter,

I have a program in python to add a split like that to a qif file.

I had it written to add Australian GST to my transactions after years of 
splitting them manually.



So I download my bank file, run the program, then import with all the 
splits added.



You might need to alter it to suit your split values,


if you are interested let me know.


Lawrence





On 6/3/19 6:10 am, Peter Münster wrote:

On Tue, Mar 05 2019, John Ralls wrote:


Just edit the transaction and add a split. You can type '.3*123.45' and
'.7*123.45' in the expense debit column, no need to get out your calculator.

Sure. But how can I split *all* transactions of an account the same way?
The only way, that I know, is to split the transactions manually one by one.


--
Treat her like a lady and she'll always bring you home.

___
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.