[GNC] Badly formed URL unknown-type

[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=00000000000000000000000000000000&acct=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