[GNC] Is there any way to find all outstanding bills?

[Geert Janssens]

Most likely you have created payments and bills independently of each other and never 
linked them. In that case your balances show 0, but the gnucash business logic doesn't know 
the bill is actually paid.

There are a few ways to solve this. I propose to try this:
* Open Business->Vendor->Process Payment...
* Select the vendor that's listed in your payable ageing as having unpaid bills.
* Select the proper "Post To" account. It should be different depending on the currency of 
the outstanding bills.

=> This should show a list of pre-payments and bills in the documents view that haven't been 
considered as processed by the business logic.

* Use shift-click or ctrl-click to select one or more payments and bills that should be linked 
together.

=> If the payments and bills balance, the payment and refund fields should both be 0 and 
the "Transfer Account" list greyed out.

* Click the Ok button to complete linking the bill(s) and payment(s).

* Repeat for each of the vendors that appear to have unpaid bills.

Hope that helps,

Geert

Op dinsdag 24 januari 2023 03:39:02 CET schreef Dr. David Kirkby:
> On Tue, 24 Jan 2023 at 01:50, Murugan Muruganandam <
> 
> m.muruganandam at hotmail.com> wrote:
> > have you tried looking at the Payable ageing report
> > 
> > 
> > Saludos Cordiales
> > 
> > 
> > Murugan
> 
> No, I had not, and that seems to have what I wanted. I'm just a bit puzzled
> that some of the figures don't make sense. If I look at Accounts Payable,
> which is in GBP, the data seems correct - I owe RS £210.41.
> 
> Accounts Payable for USD and HKD are both zero, but the report indicates
> monies are owed. But when I click on the vendors, it shows nothing owed.
> When I click on the bills, it shows these are paid.
> 
> These seem to have a pre-payment on these couple of transactions. I assume
> I have done something wrong with these transactions, It's a lot more
> complicated dealing with payments in another currency. I assume this means
> there's a good chance reports I generate will be wrong. One of the amounts
> (USD amount) is very small, but the one in HKD is not so small.
> 
> BTW, I was in the pub a couple of weeks ago, and somehow got chatting to a
> chartered accountant. I was telling him about issues when invoicing people
> in USD or Euros (my native currency is GBP). He said that I should not be
> billing people in anything other than GBP. I asked him whether he thought I
> was breaking the law in invoicing in USD and Euros, and he said that* in
> his opinion, it is against the law for me to invoice customers in anything
> other than GBP*. My accountant has never had a problem with this, but it
> obviously caused me to research it more. Our government website clearly
> states we can invoice in any currency. The only requirement is that if VAT
> is payable, then that amount needs to be in GBP. But it would be quite rare
> to invoice someone in USD if they are in the UK.
> 
> I'm pretty sure this guy in the pub was wrong, despite him saying he was a
> chartered accountant. From our own government website.
> 
> https://www.gov.uk/guidance/foreign-currency-transactions-vat-and-tour-opera
> tors
> 
> *You can invoice in any currency for the goods and services that you