Skip to content

The standard reports in each area

The ERP comes with the reports of the Powergest Desktop ERP as standard, with the same title, columns and ranges. This page tells you which ones there are in each area besides the usual ones (invoices, delivery notes, instalments) and what each one gives you. They are all run from their area’s reports page or from Reports → Reports, and the ones that aren’t in the page’s menu appear in More reports.

Which customer reports are there besides the invoice and delivery note ones?

In Customers → Customer reports:

Which sales agent reports are there?

In Customers → Sales agent reports:

Which sales reports are there for checking the till and analysing what was sold?

In Sales → Sales reports:

The profit percentage is calculated as the company sets in Warehouse price calculation: on cost or on sales. The sales agent is the one on the invoice.

Where are the issued invoices?

In the Invoicing group, the same one purchases have and in the same place:

If your user can’t see the VAT reports, you won’t get the first one.

The cost of a sale is the one recorded on the line when it is sold. The cost and profit columns come out right for what was sold with a recorded cost; a line with no cost counts as profit in full.

Which purchase reports are there?

In Purchases → Purchase reports:

Where do I see received invoices with the VAT for each rate?

In the Invoicing group:

Sales have the same group with the issued ones.

Where are the IRPF withholdings?

On the VAT management reports page: Withholding tax (IRPF) on sales and Withholding tax (IRPF) on purchases, one line per invoice with withholding, with the tax base and the withholding (credit notes subtract) and the total for each month or quarter.

Which receipt and cash reports are there?

On the Receipt reports page:

In the splits between cash and card, what decides is the treasury account the immediate payment was collected into: a receipt taken partly in cash and partly by card appears in full in one of the two.

How do I get the movements of a till, a bank or a card?

In Treasury → Receipt reports, group Treasury reports, as in the Desktop ERP: Till movements, Bank movements and Credit card movements. The same group has the account lists: List of till accounts, of bank accounts and of credit card accounts.

Each statement comes from the ledger of the till’s, bank’s or card’s accounting account: everything posted to it, whether from a receipt, a payment, an invoice or a manual journal entry. For each account:

In the dialog you narrow it down by account (with the treasury accounts magnifier), date and document.

A till, bank or card without an accounting account in its record doesn’t appear: it has no ledger to come from. You set it in its treasury account record.

Which reports are there for what is owed to suppliers?

They are the same instalment reports as the receipt ones: in their dialog, Open items chooses Receipts or Payments, as in the Desktop ERP, and the labels change with it (‘Supplier’ and ‘Paid’ instead of ‘Customer’ and ‘Collected’). In Treasury → Payment reports they open with Payments already chosen:

They are narrowed by supplier (the customer range isn’t used in payments), invoice date, invoice number, due date, bank, payment method, status and currency. The Outstanding column only counts the instalments that are still pending: one already paid comes out at zero.

Which accounting reports are there?

In Accounting → Accounting reports, grouped as in the desktop accounting programme:

They all open with the active financial year: dates from its start to today, months from January to the current month and accounts from the first to the last.

How do I get the balance at group level?

In Accounts at level you choose how many digits each line has: with ‘2 digits’, the line ‘43 Customers’ adds up all the sub-accounts starting with 43. Empty, one line per sub-account. In Totalled at level you choose the group that has its own total, with its name (‘Total 43 Customers’); it opens at 2 digits, like the Desktop ERP.

What doesn’t the balance filter that the Desktop ERP did?

The Desktop ERP’s Cost accounting journal isn’t a report: you look it up in Cost accounting → Cost journal.

Which warehouse reports are there?

In Reports → Reports, in the Warehouse tab:

Sizes come out in rows, one per size and colour, and not in columns as the Desktop ERP printed them.

Warehouse → Warehouse reports also has these, as in the Desktop ERP warehouse menu, each with its four valued versions (at sales, average, last and purchase price) and its stock check:

Purchase forecast tells you what to buy of each item to cover one, two and three months, as in the desktop ERP. It takes what was sold in the last months (you choose how many; ten by default) up to the calculation date and works out the average monthly consumption. It subtracts what you have: stock, plus what is pending to be received and transferred, minus what is pending to be delivered. If the result is negative there is nothing to buy and it shows zero. With Separate warehouses you get one table per warehouse with its total; without it, one row per item with all warehouses added up. Landscape format also shows the item's supplier and its reference. Items with no stock, nothing pending and no sales are left out.

Item labels opens the labels screen, where you choose the items, the format and the copies.

And, in their groups, Price list, Item properties and Item production, which are the same reports as in the purchases, sales and production areas.

The Purchases and Sales groups are the Queries menu of the desktop ERP, with the same reports on both sides:

PurchasesSales
Incoming detailOutbound detail
Incoming summary by itemOutbound summary by item
Incoming summary by supplierOutbound summary by customer
—Outbound summary by family
—Profit report
Purchase ordersSales orders

In the desktop ERP, the detail and the orders had a submenu for each order (by supplier or customer, by date, by item, by family). Here each one is a single option and the order is chosen in the Subtotals by filter, which opens on the supplier or the customer, the first option in the desktop ERP.

Stock at date, with the same four valuations and the stock control, gives the stock there was on a past day. It is calculated as in the desktop ERP: today’s stock minus what documents have moved since that day, valued at today’s prices. The control shows the four figures: today’s, what came in and went out afterwards, and what there was. A stock correction made by hand on the item, a stock count or the terminal leaves no movement: if it was made after that date, the report includes it.

In the Production tab, the Components report gives all the bills of materials for a range of items.

The Warehouse tab also has Changed items: the items that were added and the prices that were changed, with the previous price, the new one and who did it. It comes from the change log (see the next section). In the ERP a purchase doesn’t change the item record, so it doesn’t include supplier or warehouse as in the Desktop ERP.

Can I find out who changed something or who has logged in?

Yes, in the System tab of Reports → Reports, if your role has the settings permission:

Both open with today’s date. What comes in through an import doesn’t appear: it isn’t anyone’s change. And they are kept for a year; anything older is deleted automatically.


See also: Run a report · Where each report is · Group and total a report

More about Reports