Re: [GNC] Reconciling subaccounts

2022-10-07 Thread Uttam Chakravorty
Many thanks Adrien.  I will go to bugs.gnucash.org and take a look at how to 
submit my experience.



 From:   Adrien Monteleone  
 To:
 Sent:   06/10/2022 7:17 PM 
 Subject:   Re: [GNC] Reconciling subaccounts 

Thanks for the details. 
 
I'd say this is a bug, as the expected result would be to have the  
reconcile status of sub-accounts updated. 
 
You should file that on bugs.gnucash.org 
 
It *might* be designed that way however. I could be wrong, but I think  
the idea for this feature is to be used for 'virtual' sub-accounts that  
are used for segregating funds in your own books, but not actual  
multiple real-world accounts with an institution. 
 
The parent is the real account in such a case, so that might be why it  
is the only one marked reconciled with a date. (it is the only one with  
a statement to reconcile against) 
 
In your case, you seem to be trying to reconcile multiple real accounts  
through a placeholder parent. But GnuCash doesn't know that. (or  
'reconciling' non-institution accounts, such as Expenses.) 
 
Until it is 'fixed' or changed, I guess your option is to continue to  
reconcile-finish the sub-accounts to update them, or else just reconcile  
them all individually rather than together as sub-accounts. 
 
Regards, 
Adrien 
 
On 10/3/22 4:56 PM, Uttam Chakravorty wrote: 
>  
> My apologies Adrien, I will be more specific.  Line 2 - >Sales -> A/c No 01: 
> all the subsequent lines starting '01-' are the subaccounts.  Reconciling 01 
> with subaccounts ticked will reconcile all of them, but only update 01's date 
> field.  I then step through the subaccounts and as they are all already 
> reconciled I just press 'Finish' to update their date. 
>  
>  
> Line 11 is a single entry with no subaccounts. 
>  
>  
> Line 12 is similar to Line 2, a Placeholder with three subaccounts. 
>  
>  
> I have tried to indicate the above in Column E, however I have made a mistake 
> with Lines 64, 71 and 77.  They have no subaccounts, I annotated them in 
> error as all the top level accounts are reconciled.  In terms of consistency 
> I failed to annotate Lines 12, 17 and 59.  Looking back this is a scrappy 
> piece of work put together in haste.  I hope you will be able to extract 
> something useful, or I will happily do it again.  Please advise. 
>  
>  
>  
> Line 18 (A/c code 5 (should be 05)) is particularly interesting.  This has 
> subaccounts and they have Placeholders which have subaccounts i.e. three 
> levels deep.  Reconciling the top level reconciles all the other levels, 
> however once more it only updates the date at the top level. 
>  
>  
> I do not find it too onerous to live with this little extra keyboard 
> activity.  I just wondered if I was doing something wrong again. 
 
 
 



If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Reconciling subaccounts

2022-10-03 Thread Uttam Chakravorty

My apologies Adrien, I will be more specific.  Line 2 - >Sales -> A/c No 01: 
all the subsequent lines starting '01-' are the subaccounts.  Reconciling 01 
with subaccounts ticked will reconcile all of them, but only update 01's date 
field.  I then step through the subaccounts and as they are all already 
reconciled I just press 'Finish' to update their date.


Line 11 is a single entry with no subaccounts.


Line 12 is similar to Line 2, a Placeholder with three subaccounts.


I have tried to indicate the above in Column E, however I have made a mistake 
with Lines 64, 71 and 77.  They have no subaccounts, I annotated them in error 
as all the top level accounts are reconciled.  In terms of consistency I failed 
to annotate Lines 12, 17 and 59.  Looking back this is a scrappy piece of work 
put together in haste.  I hope you will be able to extract something useful, or 
I will happily do it again.  Please advise.



Line 18 (A/c code 5 (should be 05)) is particularly interesting.  This has 
subaccounts and they have Placeholders which have subaccounts i.e. three levels 
deep.  Reconciling the top level reconciles all the other levels, however once 
more it only updates the date at the top level.


I do not find it too onerous to live with this little extra keyboard activity.  
I just wondered if I was doing something wrong again.


Many thank again, Uttam




 From:   Adrien Monteleone  
 To:
 Sent:   03/10/2022 3:19 PM 
 Subject:   Re: [GNC] Reconciling subaccounts 

Okay, so now we see the account structure, but now, can you give an  
example of which parent account you were trying to reconcile with  
sub-accounts that did not update their last-reconciled dates? 
 
Regards, 
Adrien 
 
On 10/3/22 8:41 AM, Uttam Chakravorty wrote: 
>  
> Dear Adrien, 
>  
>  
> This is what I use for a small VAT Registered UK limited company as per what 
> my son and wife's business requires.  I have a very different one based on 
> income and expenditure as in UK they have to file a personal annual 
> Self-Assessment Return.  I hope this gives you the information that you 
> require and should it help any others with their Gnucash Odyssey I will be 
> delighted. 
>  
>  
>  
> I have attached it as accounts_tree.csv.  I hope this works. 
 
 
 



If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-03 Thread Uttam Chakravorty

Dear Michael,



Many thanks to both you and Adrien.  Both the answers are far more considered 
than my initial comment had intended to provoke, thank you.  I had made my 
original comment by way of explaining how I was approaching the puzzle i.e. in 
the early eighties I would parse the software through a hexadecimal editor such 
as Norton and then check the search results in plain English by interrogating 
the Audit Trail.  It seems so primitive compared to what I have just learned.


In general today I'm very happy to use the TB as my critical check at the risk 
of missing out on any reciprocating errors.  I find they either prove de 
minimis or so big that they don't stay hidden.


The first part part of what I was seeking has been addressed by Adrien.  If 
there is a way to get the average debtor/creditor days this would be the icing 
on the cake.


 
Returning to Gnucash I find it the best piece of software I have used in 40yrs 
and it handles our needs brilliantly.  I love the way it sticks to the T-bar 
principles, I'm sure the Medici would have loved it and could have avoided so 
much bloodshed.  I appreciate it is far more capable than simple bookkeeping, 
the limitation is that is all I know.  I was put out to grass nearly a decade 
ago and I only get to do this as it is a small business (just my wife and son 
evangelising Linux - fun but not particularly business-like).  The multi-user 
issues that you recall bring a smile to my face as they can no longer strike 
terror into my soul.



With many thanks and best wishes, Uttam (and a beer or three (who's counting) 
if you are ever in my neighbourhood)






 From:   Michael or Penny Novack  
 To:
 Sent:   02/10/2022 3:46 PM 
 Subject:   Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing 
transactions 

 
> 
> And in that case of 'breadcrumbs' the entirety of GnuCash is an audit  
> trail, as that is how double-entry accounting works. 
> 
> If you are looking for some record of exactly who entered which  
> transactions and the date/time stamps, no, that is not available.  
> Technically I think the posting date/time does get recorded, but it is  
> not readily available to users. If you really need it, perhaps start a  
> thread just on that question. 
> 
> Certainly the 'who' will be impossible, because GnuCash is not a  
> multi-user application. Whomever has access to run the app, and access  
> to the file, can post or edit transactions.  
 
As somebody who used to do this (for one of the world's largest  
"financials") my comment might (or might not) be useful. 
 
a) The accounting system itself (its own reporting functions) would not  
provide a way of reporting when/who by. It is important to understand  
that this information is NOT part of the accounting system. Accounting  
is not a "real time" process nor would who by (what worker bee) be  
relevant to the question of correctness in an accounting sense. 
 
b) But there are OTHER ways in which general ledger might be audited.  
Internally correct is one matter, but externally correct is another. For  
example,here we have an invoice marked paid by check. But WAS there  
actually such a check, and if not, who (falsely) entered that invoice as  
paid and when. How many of you when first learning to use gnucash  
created a set of "test books" and into these entered a number of "test  
transactions"? Understand? There was nothing wrong internally with this  
set of test books you were using to learn gnucash but they matched  
nothing in the real world. 
 
c) Like I said, there would be no functions PART of the accounting  
system to be used for this sort of purpose. But when the auditors  
(checking against the real world) found something suspicious, this sort  
of problem would come t my desk. "Mike, figure out who entered THIS  
transaction and when". So I would figure out what feed to the system  
would have fed that transaction to general ledger, get the right backup  
tape recovered from the vaults, and with a little "ad hoc" program I'd  
write for the purpose, get that information. It's not as if I'd be  
writing a lot of these ad hoc programs from scratch, just take to one I  
used last time and change a line or two of code. 
 
    THIS sort of "check against the real world" was rare. I [probably  
did only a few times a year. More often it was personal and quickly  
enough after that fact I didn't have to have backups recovered from the  
vault. Thus suppose I was handed a problem from a client area "here's  
what one of our worker bees entered but it didn't "take", figure out the  
bug". Well actually MOST of the time no bug. Just a typo, what was on  
the piece of paper (as what was entered) didn't match what the worker  
bee actually entered at the terminal. We all do typos, and that's how I  
would report the problem as solved. No harm done. I probably did a few  
of THESE per week. It'd have been a waste of programmer time my handing  
off to one of our 

Re: [GNC] Reconciling subaccounts

2022-10-03 Thread Uttam Chakravorty

Dear Adrien,


This is what I use for a small VAT Registered UK limited company as per what my 
son and wife's business requires.  I have a very different one based on income 
and expenditure as in UK they have to file a personal annual Self-Assessment 
Return.  I hope this gives you the information that you require and should it 
help any others with their Gnucash Odyssey I will be delighted.



I have attached it as accounts_tree.csv.  I hope this works.



Best Regards, Uttam





 From:   Adrien Monteleone  
 To:
 Sent:   02/10/2022 3:49 AM 
 Subject:   Re: [GNC] Reconciling subaccounts 

What account *exactly* are you selecting that is a placeholder? 
 
It sounds like you're trying to reconcile a very top-level account and  
then including sub-accounts. 
 
If so, I don't think that is how the feature was intended to work.  
(though maybe it *could* regardless, I honestly never thought to try  
that approach) 
 
If not, then perhaps you found a bug. 
 
Can you provide a screenshot or typed version of the part of the account  
tree in question? 
 
That is, what is the 'placeholder' account you are referring to? (where  
does it lie in the tree, Assets, Liabilities, Expenses, Income, Equity?  
Then what is the next level? and the next level if any? et cetera...) 
 
Then, what are the sub-accounts? And importantly, can you verify that  
those sub-accounts are all of the same *type* as their parent? (you can  
see the type in the bottom left of the window that displays when you  
highlight an account in the Accounts tab and click the 'Edit' button or  
right-click the account and choose 'edit') 
 
Regards, 
Adrien 
 
On 10/1/22 7:58 PM, Uttam Chakravorty wrote: 
> Dear All, 
>  
>  From 'Accounts' I highlight one that is a Placeholder -> 
>   right click on 'Reconcile...' -> 
>   select the 'include subaccounts' checkbox. 
>  
> This works perfectly and the Placeholder accounts 'Last Reconcile Date' is 
> updated accordingly.  However the 'subaccounts' last reconciled dates are not 
> updated. 
>  
> Any suggestions? 
>  
> Background: I like to reconcile the bank account, the input/output ledgers 
> and the trade creditors/debtors every month.  As a small business there are 
> only a few dozen entries. 
 
 
 



If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

"Type","Full Account Name","Placeholder","Account Code",
"INCOME","Sales","T","01","Reconcile"
"INCOME","Sales:01",,"01-05",
"INCOME","Sales:02",,"01-10",
"INCOME","Sales:03",,"01-15",
"INCOME","Sales:04",,"01-20",
"INCOME","Sales:05",,"01-25",
"INCOME","Sales:06",,"01-30",
"INCOME","Sales:07",,"01-35",
"INCOME","Sales:08",,"01-40",
"INCOME","Sales:Disbursements",,"01-45",
"INCOME","Bank Interest Earned",,"02",
"EXPENSE","Purchases","T","03-15","Reconcile"
"EXPENSE","Purchases:01",,"03-05",
"EXPENSE","Purchases:02",,"03-10",
"EXPENSE","Purchases:Subcontract",,"03-15",
"EXPENSE","Staff Wages",,"4",
"EXPENSE","Overheads","T","5","Reconcile"
"EXPENSE","Overheads:Rent",,"05-05",
"EXPENSE","Overheads:Insurance",,"05-10",
"EXPENSE","Overheads:Telephone and Internet",,"05-15",
"EXPENSE","Overheads:Post and Stationery",,"05-20",
"EXPENSE","Overheads:Advertising & Marketing",,"05-25",
"EXPENSE","Overheads:Motor Expenses","T","05-30",
"EXPENSE","Overheads:Motor Expenses:EV Charging",,"05-30-05",
"EXPENSE","Overheads:Motor Expenses:Fuel and Oil",,"05-30-10",
"EXPENSE","Overheads:Motor Expenses:Motor Ins & Tax",,"05-30-15",
"EXPENSE","Overheads:Motor Expenses:Repairs and Servicing",,"05-30-20",
"EXPENSE","Overheads:Motor Expenses:Tolls and Parking",,"05-30-25",
"EXPENSE","Overheads:Motor Expenses:Staff Mileage",,"05-30-30",
"EXPENSE","Overheads:Travel","T","05-35",
"EXPENSE","Overheads:Travel:Travel - UK",,"05-35-05",
"EXPENSE","Overheads:

[GNC] Reconciling subaccounts

2022-10-01 Thread Uttam Chakravorty
Dear All,

From 'Accounts' I highlight one that is a Placeholder ->
 right click on 'Reconcile...' ->
 select the 'include subaccounts' checkbox.

This works perfectly and the Placeholder accounts 'Last Reconcile Date' is 
updated accordingly.  However the 'subaccounts' last reconciled dates are not 
updated.

Any suggestions?

Background: I like to reconcile the bank account, the input/output ledgers and 
the trade creditors/debtors every month.  As a small business there are only a 
few dozen entries.

Many thanks and best wishes, Uttam


If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-01 Thread Uttam Chakravorty

Dear Adrien



Your advice meets all my needs.  Many thanks to all the others who offered 
advice, they add to my knowledge.  Its good to know I was peering through the 
wrong end of the telescope.



I used 'breadcrumb' as an alternative to 'audit trail'.


Buoyed by the wonderful support I have received I would like to ask the 
community another question.  I will raise it as a separate topic = 'Reconciling 
subaccounts'.


Many thanks again, Uttam



 From:   Adrien Monteleone  
 To:
 Sent:   30/09/2022 7:23 PM 
 Subject:   Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing 
transactions 

On 9/30/22 12:48 PM, Uttam Chakravorty wrote: 
> Dear All, 
>  
> I am using the Reconciliation Report configured as: 
>  
>  
>  
> Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> 
> General - current period selected -> 
>  
> Sorting by Description then Date. 
>  
>  
> Is there a way to use this pool of information and pair a receipt with an 
> Invoice as per the case when the transaction was entered? 
 
If you mean to match up payments with Invoices, yes, but not with that  
report. What you are looking for is the Customer Report. (Reports >  
Business > Customer Report — or from an Accounts Payable Report, click  
an *amount* for a customer.) 
 
You'll want to set Options > Display Columns > Transaction Links to  
either 'simple' or 'detailed' per your preference for the level of  
information. (I personally like detailed best) 
 
Note, this requires using the Business Features to enter invoices &  
payments. (using the Process Payment feature to link payments to invoices) 
 
The result is a Statement of Account type report showing which payments  
were applied to which invoices & vice versa. 
 
 
> Is there a breadcrumb trail? 
 
Not sure what you mean by this. 'Breadcrumbs' leading you from where to  
where? 
 
Regards, 
Adrien 
 
 
 



If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-09-30 Thread Uttam Chakravorty
Dear All,

I am using the Reconciliation Report configured as:



Accounts = Trade Debtors ->Currency / Display / Filter = defaults ->
General - current period selected ->

Sorting by Description then Date.


Is there a way to use this pool of information and pair a receipt with an 
Invoice as per the case when the transaction was entered?
Is there a breadcrumb trail?
Am I going about this the wrong way?


Background: we are a small business supporting small businesses.  We are 
sympathetic to some clients needing to pay us monthly.  However simple we try 
to be a few still manage to lose their way and then we have to go back and 
match receipts to invoices made difficult by the fact that the monthly sums are 
the same.  The good thing is if we hold their hand eventually they get 
organised and the problem goes away.  Sadly we have only managed to use this as 
an opportunity to move them to Gnucash on only one occasion so far.  We live in 
hope.



All comments will be gratefully received.  Many thanks and best wishes, Uttam




If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Last Reconcile Date fails to update for subaccounts

2021-04-29 Thread Uttam Chakravorty

Dear All,

First my thanks to the GnuCash team for the software.  I'm running V4.x 
under W10 or Mint (flatpak) depending on need.


My wife and son work together operating as a small UK Limited Company.
Their chart of accounts has several parent accounts with subaccounts
e.g. Motoring with Fuel, Dent Removal, etc,
or Bank with Current a/c, GK a/c (God only knows), etc.

The parent accounts are placeholders with no transactions.

Action:  Accounts screen → select placeholder → right click and select 
reconcile → set date → include subaccounts → reconcile.


All being well the reconcile date of the placeholder will update.  The 
subaccounts' date will not, though the transactions will be correctly 
reconciled.  Where do I start looking for the right question?


Many thanks and best wishes to all, Uttam


--
If this email is not for you, please excuse me as it is a genuine 
mistake.

Please accept my sincere apologies and I hope you have a great day.
___
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] [MAINT] Unplaned network outage yesterday, April 2, 2020

2020-04-03 Thread Uttam Chakravorty
Self-isolation?  I'm very (and easily) perplexed.  Thanks for everything 
as always, Uttam



Subject: Re: [GNC] [MAINT] Unplaned network outage yesterday, April 2, 
2020

From: Adrien Monteleone 
Date: Fri 17:22

Unless you were the one who cut the line, no need to apologize. Thanks 
for keeping things running!


Regards,
Adrien


On Apr 3, 2020 w14d94, at 11:09 AM, Derek Atkins  
wrote:


HI,

There was a fiber break in my neighborhood yesterday which took out my
network (and others) for multiple hours.  It was eventually repaired 
and
everything came back.  Not much I could do about it.  I called AT 
within

10 minutes to work on getting it repaired, but there was a truck at the
site quickly and unrelated to my technician call.

Once they repaired the line everything came back and mail started 
flowing

again.

Sorry for any inconvenience.

-derek

--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant



--
If this email is not for you, please excuse me as it is a genuine 
mistake.

Please accept my sincere apologies and I hope you have a great day.
___
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] Am I being a muppet?

2020-03-03 Thread Uttam Chakravorty

   1. Re:  show previous years totals on account page?
  (Adrien Monteleone)
   "you can run the multicolumn Income Statement, from the Reports > 
Experimental menu. Select a range of several years in Options > General 
and also set Period duration to ‘Year’"



The topic and Adrien's advice resonated so I had to have a go.  And it 
works well.


However, I did a 'close books' on 31st December 2018 (year = Jan - Dec). 
 I am therefore getting nothing in the 2018 column and assume I won't 
get anything even in the 2019 (Dec 2019) once I close it.  This is not 
too horrible as I keep the html reports.  However, I would like to know 
if I'm missing a trick or just being stupid.


Please note I think all the muppets are brilliant.  I created the 
'subject' drawing on the vernacular.  I offer my unreserved apologies to 
any muppet who may be offended.  Please know that you are my hero.


Best Regards, Uttam
___
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] Happy New Year

2019-12-31 Thread Uttam Chakravorty via gnucash-user
I hope this is not inappropriate to post this here.  Please accept my 
apology in advance just in case.


I would very much like to thank the people at GnuCash and the community 
for all their help and support last year.


I hope everyone enjoys a happy and healthy 2020.


--
If this email is not for you, please excuse me as it is a genuine 
mistake.

Please accept my sincere apologies and I hope you have a great day.
___
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] Badly formed URL unknown-type

2019-09-20 Thread Uttam Chakravorty
Dear Geert,

In our GnuCash working directory I ran "cat *.log | grep 'Google' >
test.csv"

In a moment of contemplation I questioned if I am chasing down the wrong
rabbit hole?  To go back a little, I have become so sure of GnuCash I
have become lazy about taking a milestone backup after every session.  I
have no excuse as we do the books every 3-6 weeks so it was not really
too hard to do.

Anyway the long and the short of it is that this year I have only taken
milestones backups on 18/2/19, 25/4/19, 6/9/19 and 13/9/19 when I
spotted the 'Payable Ageing' anomaly.

I have now restored each of the above and I have to go back to the
18/2/19 backup before the error disappears.

I'm now ruminating about my next step.  I switched my son's and wife's
business over to GnuCash on 13/9/2016.  I wonder if it needs a thorough
audit.  I'm not sure who to ask as it is not well supported by the
accountants even though it is the best double entry system I have come
across in 30yrs.  I appreciate that from your point of view it is a
great deal more than that.

Hey ho, it is Friday evening.  A Belgian beer is called for and then
perhaps inspiration may strike overnight.

My thanks to you, the team, and the community.  As always, intervention
and advice will be gratefully received.  I'm happy to do the digging
once I work out where to dig.  The Lot viewer continues to hide from me.


Best Regards, Uttam

> Tue Sep 17 05:11:34 EDT 2019
> 
> I can see now this is another bug still.
> 
> It appears you have managed to create an outstanding balance somehow that's
> not related to any vendor. This is a situation the code wasn't designed for
> and hence the link error.
> 
> At this point I'm not sure how that would happen.
> Can you try to figure out where that -£2.54 comes from exactly in your A/P
> account and make a screenshot of that transaction ? It may not be obvious in
> the A/P account. It may also be you'd have to open the Lot viewer on that
> account and inspect the lots.
> 
> It's important we figure out how this situation was created to either adjust
> to code to prevent it or to update the reports to be able to handle it.
> 
> Regards,
> 
> Geert

-- 
If this email is not for you, please excuse me as it is a genuine
mistake.
Please accept my sincere apologies and I hope you have a great day.
___
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] Badly formed URL unknown-type

2019-09-17 Thread Uttam Chakravorty
I'm at a loss.  I do not know what I can do.  I do not have a copy to
hand for reasons given elsewhere.  Please accept my apology. 

Best Regards, Uttam

> The rest of us haven't seen any screenshot attached to the original email 
___
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] Badly formed URL unknown-type

2019-09-17 Thread Uttam Chakravorty
Dear Geert, 

Please accept this largely as a best guess. 

I suspect the problem stems from the Google Adwords account.  Google
withdraw money every month and send bills without consideration to what
they withdraw.  Tying up payments against invoices only clears down once
in a blue moon. 

I think I recall seeing in the bill payment screen a couple of of part
prepayments and an invoice, so I decided to select all the entries ->
enter the date & amount of the latest payment and hoped it would all
work out.  I find GnuCash logical and robust and my faith remains
unshaken.  I vaguely recall checking the Vendors report and amending
some entries/dates.  I am sorry to be so vague. 

Now that you mention it, I have not gone back and reconciled all the
entries in the Vendor's report by hand.  Truth is that due to
circumstances we had to catch up on two month's entries and were trying
to get through it as quickly as we could.  Though it would take some
time, I can return to an earlier backup and re-enter everything again if
this would help. 

I understand about looking through the A/P, but I do not know about 'the
Lot viewer'.  Thinking about the restoring from backup idea, perhaps I
can grep the automated backups for '2.54'?  Do you think this would be
useful?  Is this the Lot viewer? 

For full disclosure, I am beyond retirement age and my wife and son have
put me out to grass to enjoy my days.  This invariably means that I have
more to do each day than I can fit in.  We run GnuCash on a dedicated
computer so that while we can link to the internet, we can also work
independently should we wish to.  This means I have to go to their
office to work.  Kindly allow me a few days. 

Thank you, the team and the community, for all your support.  Please
bear with me while I try to master how to reply to the list. 

Best Regards, Uttam 

>You picture and extra details are very helpful.
>
>I can see now this is another bug still.
>
>It appears you have managed to create an outstanding balance somehow that's
>not related to any vendor. This is a situation the code wasn't designed for
>and hence the link error.
>
>At this point I'm not sure how that would happen.
>Can you try to figure out where that -£2.54 comes from exactly in your A/P
>account and make a screenshot of that transaction ? It may not be obvious in
>the A/P account. It may also be you'd have to open the Lot viewer on that
>account and inspect the lots.
>
>It's important we figure out how this situation was created to either adjust
>to code to prevent it or to update the reports to be able to handle it.
>
>Regards,
>
>Geert
>
>Op zaterdag 14 september 2019 17:06:53 CEST schreef Uttam Chakravorty: 

> Many thanks for looking at this.  Details are:
> 
> GnuCash 3.7
> Build ID: 3.7+(2019-09-07)
> 
> Static hostname: abacus.home
> Icon name: computer-desktop
> Chassis: desktop
> Operating System: Ubuntu 18.04.3 LTS
> Kernel: Linux 5.0.0-27-generic
> Architecture: x86-64
> 
> I'm inserting an image in case it helps, however if this is not done
> please tell me and I will know for the future.
> 
> Best Regards, Uttam
> 
> On 13/09/2019 20:18, Geert Janssens wrote: Op vrijdag 13 september 2019 
> 20:50:35 CEST schreef Uttam Chakravorty: Firstly I apologise if I should be 
> trying something other than posting
> here.  If so, any guidance would be appreciated.
> 
> I'm running Gnucash on Ubuntu 18.04 desktop to look after a small UK VAT
> registered company (two people: my wife and our son).
> 
> When I run 'Reports' -> 'Payable Ageing' (Trade Creditors). In the first
> entry the Company is blank, the days are zero and there is -£2.54 in the
> total column.
> 
> Clicking on -£2.54 calls up a box displaying 'Badly formed URL
> unknown-type==48dfa64b05d642c5f5c4cc
> 051 3dba700'
> 
> I have run 'Actions' -> 'Check & Repair' globally and on each individual
> account to no avail.  I'm stumbling around in the dark. 
> Hi,
> 
> Which version of GnuCash are you using ? I seem to remember fixing this in
> one of the more recent releases.
> 
> Regards,
> 
> Geert
___
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] Badly formed URL unknown-type

2019-09-17 Thread Uttam Chakravorty
Dear Adrien 

Thank you for your advice.  This is my first effort as executing it, or
at least some of it.  Let's see how well it slots back into the thread. 

Best Regards, Uttam 

>Uttam,
>
>From the list site, simply right-click and 'copy link' for the link next to 
>the senders name at the top of the message. (just under the subject line and 
>to the right of their name)
>
>This is a properly formed mailto link that is addressed only to the list, with 
>the subject line already included for you. (it isn't necessary to also send to 
>the others in the thread, >they'll get it from the list)
>
>Then copy/paste the relevant portion of the previous message you want to reply 
>to and add your reply. (if the quoted material looks like your own message, 
>put a ">" at the beginning of each >line and other e-mail programs will treat 
>it as a quote)
>
>If you don't need to review the entire thread first, you can reply to the 
>digest message just fine from within RoundCube.
>
>You *should* see a 'Reply all' button on your toolbar. It will have a down 
>arrow next to it. If you click that, you'll get an option to 'Reply list' and 
>is really the better option.
>
>If you click to Settings > Composing Messages, there is an option for 'Default 
>action of [Reply all] button'. You can switch this to "reply to mailing list 
>only (if found)" if you need it >more often.
>
>There is also Settings > User Interface > Browser Options to 'Register 
>protocol handler for mailto: links'. This will allow you to set RoundCube as 
>the default app to open when you click >such a link in Brave, like in the 
>lists.gnucash.org site when viewing a thread. (you will already need to be 
>logged in to your mail account if I am not mistaken, or else it might bring 
>you >to your log in page) Once that is set up, clicking that link directly, 
>instead of having to copy and paste it, will auto-generate a new e-mail as a 
>reply to the list with the proper subject >and most likely, the content 
>already quoted. (which you might have to adjust)
>
>If you reply to the digest thread directly using 'Reply List' please make sure 
>to change the subject line accordingly, and trim any automatically quoted 
>material that isn't relevant.
>
>Regards,
>Adrien
>
>

> On Sep 16, 2019 w38d259, at 6:58 PM, Uttam Chakravorty  
> wrote:
> 
> My apologies for the bump.  Thank you Liz and thank you John for being 
> patient with me.
> 
> Also, I may have made a mess of sending this message as I'm struggling with 
> the 'technology' i.e. I'm notified by the digest, I then visit 
> https://lists.gnucash.org/pipermail/gnucash-user/2019-September/087015.html 
> to view the whole thread and as I use roundcube on iredmail through brave, I 
> do not have an automated 'reply all' functionality.  I have therefore 
> handmade a pseudo 'reply all' with this message and hope it works.
> 
> I'm sure I'm doing this all wrong and consider it a 'work in 
> progress'/'life'.  This is not a question as it is off-topic, but assistance 
> or guidance given will be gratefully received and acknowledged.
> 
> Best Regards, Uttam
___
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] Badly formed URL unknown-type

2019-09-16 Thread Uttam Chakravorty
My apologies for the bump.  Thank you Liz and thank you John for being 
patient with me.


Also, I may have made a mess of sending this message as I'm struggling 
with the 'technology' i.e. I'm notified by the digest, I then visit 
https://lists.gnucash.org/pipermail/gnucash-user/2019-September/087015.html 
to view the whole thread and as I use roundcube on iredmail through 
brave, I do not have an automated 'reply all' functionality.  I have 
therefore handmade a pseudo 'reply all' with this message and hope it 
works.


I'm sure I'm doing this all wrong and consider it a 'work in 
progress'/'life'.  This is not a question as it is off-topic, but 
assistance or guidance given will be gratefully received and 
acknowledged.


Best Regards, Uttam
___
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] Badly formed URL unknown-type

2019-09-16 Thread Uttam Chakravorty

Bump?

On 13/09/2019 20:18, Geert Janssens wrote:

Op vrijdag 13 september 2019 20:50:35 CEST schreef Uttam Chakravorty:

Firstly I apologise if I should be trying something other than posting
here.  If so, any guidance would be appreciated.

I'm running Gnucash on Ubuntu 18.04 desktop to look after a small UK 
VAT

registered company (two people: my wife and our son).

When I run 'Reports' -> 'Payable Ageing' (Trade Creditors). In the 
first
entry the Company is blank, the days are zero and there is -£2.54 in 
the

total column.

Clicking on -£2.54 calls up a box displaying 'Badly formed URL
unknown-type==48dfa64b05d642c5f5c4cc051
3dba700'


I have run 'Actions' -> 'Check & Repair' globally and on each 
individual

account to no avail.  I'm stumbling around in the dark.


Hi,

Which version of GnuCash are you using ? I seem to remember fixing this 
in one

of the more recent releases.

Regards,

Geert


--
If this email is not for you, please excuse me as it is a genuine 
mistake.

Please accept my sincere apologies and I hope you have a great day.
___
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] Badly formed URL unknown-type

2019-09-14 Thread Uttam Chakravorty
Many thanks for looking at this.  Details are:

GnuCash 3.7
Build ID: 3.7+(2019-09-07)

 Static hostname: abacus.home
   Icon name: computer-desktop
 Chassis: desktop
Operating System: Ubuntu 18.04.3 LTS
  Kernel: Linux 5.0.0-27-generic
Architecture: x86-64 

I'm inserting an image in case it helps, however if this is not done
please tell me and I will know for the future. 

Best Regards, Uttam 

On 13/09/2019 20:18, Geert Janssens wrote: 

> Op vrijdag 13 september 2019 20:50:35 CEST schreef Uttam Chakravorty: 
> 
>> Firstly I apologise if I should be trying something other than posting
>> here.  If so, any guidance would be appreciated.
>> 
>> I'm running Gnucash on Ubuntu 18.04 desktop to look after a small UK VAT
>> registered company (two people: my wife and our son).
>> 
>> When I run 'Reports' -> 'Payable Ageing' (Trade Creditors). In the first
>> entry the Company is blank, the days are zero and there is -£2.54 in the
>> total column.
>> 
>> Clicking on -£2.54 calls up a box displaying 'Badly formed URL
>> unknown-type==48dfa64b05d642c5f5c4cc051
>> 3dba700'
>> 
>> I have run 'Actions' -> 'Check & Repair' globally and on each individual
>> account to no avail.  I'm stumbling around in the dark.
> 
> Hi,
> 
> Which version of GnuCash are you using ? I seem to remember fixing this in 
> one 
> of the more recent releases.
> 
> Regards,
> 
> Geert
___
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] Badly formed URL unknown-type

2019-09-13 Thread Uttam Chakravorty

Thank you very much.  I will check this out and revert tomorrow.

On 13/09/2019 20:18, Geert Janssens wrote:

Op vrijdag 13 september 2019 20:50:35 CEST schreef Uttam Chakravorty:

Firstly I apologise if I should be trying something other than posting
here.  If so, any guidance would be appreciated.

I'm running Gnucash on Ubuntu 18.04 desktop to look after a small UK 
VAT

registered company (two people: my wife and our son).

When I run 'Reports' -> 'Payable Ageing' (Trade Creditors). In the 
first
entry the Company is blank, the days are zero and there is -£2.54 in 
the

total column.

Clicking on -£2.54 calls up a box displaying 'Badly formed URL
unknown-type==48dfa64b05d642c5f5c4cc051
3dba700'


I have run 'Actions' -> 'Check & Repair' globally and on each 
individual

account to no avail.  I'm stumbling around in the dark.


Hi,

Which version of GnuCash are you using ? I seem to remember fixing this 
in one

of the more recent releases.

Regards,

Geert

___
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] Badly formed URL unknown-type

2019-09-13 Thread Uttam Chakravorty
Firstly I apologise if I should be trying something other than posting
here.  If so, any guidance would be appreciated. 

I'm running Gnucash on Ubuntu 18.04 desktop to look after a small UK VAT
registered company (two people: my wife and our son). 

When I run 'Reports' -> 'Payable Ageing' (Trade Creditors). In the first
entry the Company is blank, the days are zero and there is -£2.54 in the
total column.

Clicking on -£2.54 calls up a box displaying 'Badly formed URL
unknown-type==48dfa64b05d642c5f5c4cc0513dba700'


I have run 'Actions' -> 'Check & Repair' globally and on each individual
account to no avail.  I'm stumbling around in the dark. 

-- 

If this email is not for you, please excuse me as it is a genuine
mistake.  Please accept my sincere apologies and I hope you have a great
day.
___
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.