Where do I see what is outstanding with my suppliers?
There are two different questions and they are answered in two different places. What I still have to receive or invoice is shown in the Purchases list. What I still have to pay is shown in the payment open items, which live in Treasury. One is about documents and the other is about money.
What does the Purchases list tell me at a glance?
At the top of the Purchases list there are four counters that sum up what you are looking at:
- Total amount: the accumulated amount of all the documents in the list.
- Outstanding: what you still have to pay on those documents, according to the open items. For a part-paid invoice it only counts the part still owed, not its whole amount.
- Drafts: the documents not yet issued. They are the only ones that can be issued in bulk.
- Purchase docs.: quotes, orders and goods receipts, in other words everything that isn’t an invoice or a credit note.
All four count all purchase documents, not just the ones on the page you are looking at.
How do I search for a purchase document?
The Purchases list has a search box and three drop-downs, and you can combine them all.
- The Search by supplier or number field filters by the supplier’s name or by the document number.
- The status drop-down lets you see only Draft, Outstanding, Partly pending, Paid, Partial (partly received), Invoiced or Voided documents. If the company distinguishes overdue items, also the Overdue ones.
- The series drop-down narrows it to a specific series, or to No series.
- The Drafts only box leaves nothing in the list except what can be issued.
When you come in through a menu option —for example Purchase orders— the list is already filtered by that type, and the types drop-down doesn’t appear: to see another type you change option in the menu. If you go into Purchases without choosing a type, it does appear, and it is the only way to see purchase credit notes: you choose them by setting Credit note.
Clear filters leaves the list as it was, but doesn’t change the type: that is set by the menu.
The columns are Type, Number, Date, Supplier, Series, Amount, Outstanding, To be received and Status. Amount is what the document says; Outstanding, what you still have to pay on it. On an unpaid invoice they are the same; on a part-paid one, they aren’t; and on a fully paid one the outstanding amount shows a dash. To be received is what is still to arrive from a quote or an order (or still to be invoiced, for a goods receipt), as an amount; on an invoice it shows a dash. When you make the window narrower, some of them collapse; Number, Supplier and Amount are always shown. Clicking the row opens the document.
The colour of each status is the same throughout the program: what each status colour means.
What does the Status of a purchase invoice mean?
While the document is live and has instalments, the Status refers to its PAYMENT and not to its cycle:
| Status | What it means |
|---|---|
| Outstanding | It has live instalments and you haven’t paid anything yet, even if its date has passed |
| Partly pending | You have paid part of it; Outstanding shows what is left |
| Overdue | Something is still to be paid and an instalment is already past its date. Only if the company distinguishes overdue items |
| Paid | There is nothing left to pay |
By default, an unpaid invoice is Outstanding even if its date has passed, as in the desktop ERP. To see it as Overdue, in red, switch on the Distinguish overdue items tick box in Settings, in the Transfer section. It applies to the whole company: it also changes the payment open items and the supplier record. Overdue takes priority over Partly pending.
Anything that doesn’t have instalments —a draft, a quote, an order or a goods receipt not yet invoiced— still shows the document status: Draft, Outstanding, Partial (part has already arrived and part is still to come), Invoiced, Voided.
Where do I see what is outstanding?
Go into any Purchases list and set the status drop-down to Outstanding.
That shows everything issued that still has something left to do, mixed together: orders with units not yet received, goods receipts not yet invoiced and newly issued invoices.
To separate it, use the types drop-down:
- Order with status Outstanding: what you have ordered and hasn’t fully arrived yet.
- Delivery note with status Outstanding: what has arrived and the supplier hasn’t invoiced you for yet.
- Quote with status Outstanding: quotes you haven’t converted into an order yet.
In those three cases the status belongs to the document, because an order, a quote and a goods receipt not yet invoiced don’t have instalments. On invoices, on the other hand, the status already refers to the payment.
Where are the payment open items?
In the Treasury menu, Payments option. That is where the payment instalments are: what you owe each supplier and when it is due.
Payment instalments are created when you issue a purchase invoice, according to the supplier’s payment method. A purchase credit note creates a negative instalment, which is deducted from what you owe.
The payment open items are about money, not documents: that is where the detail is, bill by bill, with its date and its payment method. The Purchases list already tells you how much is left on each invoice —the Outstanding column—, but to see which instalment each euro comes from, and to pay, you go to Payments.
How to record a payment, how to pay only part of it and how to produce the bank transfer file for the bank is in record a payment to a supplier.
Can I ask the assistant?
Yes, and for some questions it is the quickest way, because there is no screen that answers them directly.
The assistant can answer, among other things:
- Which purchase orders haven’t been fully received, with the units still missing.
- Which goods receipts still have no invoice from the supplier and how much they add up to.
- Which payments you have outstanding and which ones are already overdue.
- What price a supplier has sold you an item for in their latest deliveries, to see whether they have put the price up.
You ask it in everyday language: ‘which orders from supplier 42 am I still waiting to receive?’.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| ‘No document matches the current filters.’ | There are filters set that don’t let anything through | Click Clear filters |
| I can’t find the purchase credit notes | You are in a section with a fixed type | Go into Purchases without choosing a type and set Credit note in the drop-down |
| A paid invoice still shows as Outstanding | The list was loaded before the payment | Go back into the list: the status and the Outstanding amount are read when you open it |
| An invoice says Partly pending | Part of it was paid and the rest is still live | Outstanding shows what is left; the detail is in Treasury > Payments |
| A received order still shows as Outstanding | Less was received than was ordered | Open it and see which line has something outstanding |
| The Outstanding counter doesn’t match the open items | The counter only counts PURCHASE documents; the open items also include what was carried over from other financial years | The full debt is always the one in Payments |
Previous: The supplier’s invoice number · Next: Make a credit note for a purchase invoice · See also: Record a payment to a supplier
More about Purchasing
- How do I make a credit note for a purchase invoice?
- How do I turn a quote into an order, or an order into a goods receipt or an invoice?
- How do I create a purchase document?
- What is ‘Supplier invoice no.’ and what happens if I repeat it?
- How do I invoice several goods receipts at once?
- Purchasing with Powergest
- What is the Purchases module and what is its cycle?