Skip to content

How do I run a report?

A report is a table-shaped report that someone has designed beforehand: sales by customer, items in stock, open items by due date. You run it from Reports → Reports and it comes out on screen, as a PDF or as a CSV.

What do I need before I start?

Nothing: the ERP comes with standard customer, supplier and sales agent reports, available from day one. If you need one that isn’t there, you design it: Create a custom report.

A report only appears on the screen if your role can read all the tables it uses. A journal lines report can’t be seen from a role without access to accounting, and it isn’t an error: it is the permission.

How do I run it?

There are two ways and both end up in the same window.

From the module you work in. Each area has its reports page in the menu: Sales → Sales reports, Purchases → Purchase reports, Treasury → Receipt reports, Records → Customer reports, and the same for suppliers, sales agents, VAT and accounting. On the left is that area’s reports menu, grouped as in the Desktop ERP (Orders, Documents, Journals…); when you click one, its ranges and the View, Report, Data, Selection and Query buttons appear on the right. The last group, More reports, brings together what isn’t in the classic menu: standard reports that had no entry and the reports you have designed yourselves for that area. A standard report with the same name as an entry in the groups above isn’t repeated in More reports: you will find it in the whole catalogue (see below).

From the whole catalogue.

  1. Open the Reports group in the menu and click Reports.
  2. On the left you have the Categories panel, one per area —Customers, Suppliers, Sales agents, Sales, Purchases, Receipts and treasury, VAT, Accounting, Warehouse, Production…— and, at the end, Custom, each one with how many reports it has. Choose the category and on the right you will see its reports, one per row, with their title and code.
  3. Click the row of the one you want (or its Run).
  4. A window opens with the report name at the top and the details to fill in.
  5. Fill in the details it asks for. The ones with an asterisk are required.
  6. Choose what you want:
    • View shows it as a table inside the same window (on-screen display).
    • Report shows the laid-out report as a full-screen PDF, to read and sign it.
    • Data downloads a spreadsheet with the same content as the view.
  7. Click Close when you finish.

Report and Data have an arrow attached on their right, which opens out the rest of their options below:

Next to them are Selection, which says how many distinct records are in the report, takes you to the ones behind them —their customers, their items…— (see How do I go from some invoices to their customers?) and saves them as a group or as a segment (see How do I save what I have narrowed as a group or as a segment?), and Query, which opens a panel to narrow the report step by step (see How do I narrow a report step by step?).

The buttons are on a fixed bar at the bottom: even if the report asks for many ranges and the screen is small, you don’t need to scroll down to them. The ranges scroll above and the bar stays in view. When you bring up the View, the bar goes back to its place above the table.

If the report doesn’t ask for anything, the window says so: ‘This report needs no parameters. Choose how you want to view it’.

You can click View, Report and Data one after another without closing the window. It runs each time with the details you have entered at that moment.

How do I narrow a report step by step?

With Query, in the window of any report (Reports → Reports, or your area’s reports page). It opens a panel on the right, with the report on its left, and in it you keep adding steps: each step is a condition that leaves fewer records. The ranges above still apply; the steps are applied on top.

  1. Click Query. The panel says how many records there are with the ranges you have entered.
  2. In Add condition, choose the Field (those of the report and those of its records: the customer’s province, the total, the date…). If the detail belongs to another table —the customer’s payment method, the items on an invoice—, choose it first in From which table.
  3. Choose the Condition: is equal to, is not equal to, contains, starts with, is one of, is greater or less than, is between, is empty or has a value. Only the ones that make sense for that field appear.
  4. Type the Value. If the field is a record’s code (a customer, an item) it has its magnifying glass; if it only allows certain values, it is a drop-down; and if it is a date you can enter a specific date or a period that is worked out each day: today, this month, last month, the last 90 days…
  5. Click Add.

The step appears in the list with its text —‘Province is equal to «Valencia»’— and with how many records are left after it. At the top, the panel says how many are left in total and out of how many: ‘40 of 1,240’. The table on the left is redone on its own with the steps applied.

Each step has four buttons:

The curved arrow at the top undoes the last change (up to ten). If a condition isn’t valid —its value is missing, or the field doesn’t allow that question— the panel says so and the query stays as it was.

With steps applied, everything comes out narrowed: the View, the Report (which prints them in its header, below the ranges), the Data and the email. The Query button shows a number with the steps that are on, even with the panel hidden: hiding the panel doesn’t remove the steps.

When comparing text, capitals and accents don’t count: ‘valencia’ finds ‘Valencia’ and ‘almeria’, ‘Almería’.

A query is yours: nobody else sees it. And it is a working tool: if you don’t use it for seven days, it is deleted.

How do I narrow a report by a detail from another table, such as the customer’s payment method or the items on their invoices?

With From which table, in Add condition of the Query panel in the report window (Reports → Reports). To begin with, the table of the report itself is chosen; opening the drop-down shows its related tables, in two groups, and when you choose one the Field goes on to offer the details of that table. You don’t need to know what any field is called.

From one table you go on to its own: from the sales lines to the item on the line, and from there to its family. The path you have chosen is written above the drop-down, and the arrow on its right goes back to the previous table. You can follow up to three Data of tables in a row, and one Has table inside another.

In a Has table, How many also appears:

How manyThe records left are those that…
anyhave at least one row that meets the condition
nonehave no row that meets it
at least… · at most…have that number of rows that meet it, or more, or fewer
adding up to at least… · adding up to at most…add up to that figure in the amount or quantity you choose in What is added up

In a Has table the Field can be left unchosen: ‘customers with no sales document’ is their sales documents with none, and nothing else.

The step reads in full in the list. Only the tables your role can read are offered.

How do I find a detail if I don’t know which table it is in?

With Find a field, in Add condition of the Query panel in the report window (Reports → Reports). Type what you are looking for —‘payment method’, ‘family’, ‘route’— and press Enter: below it, each detail with that name appears, with the table it is in. When you click one, the form moves to that table and leaves the field chosen; all that is left is to say the condition and the value. It searches the report and its related tables, the nearest ones first.

How do I add records to the ones I have already narrowed down, or remove some?

With What this step does, the first thing in Add condition in the Query panel of the report window (Reports → Reports). Each step does one of these three things with what was there before it, and the steps are applied in the order they are in:

An example, on the report of customers: first Only those that have item A01; then Only those that have a payment method starting with K; and lastly Add those that have a payment method starting with D. What is left are those with item A01 and payment method K and, in addition, all those with payment method D.

In the list, the step that adds reads ‘Plus those that: …’, is shown in green with a + and its count goes up; the one that removes reads ‘Minus those that: …’ and is shown in red with a −. You cannot start by adding: with nothing narrowed down, the report already has all its records, and the panel says so.

How do I put two conditions in the same step of a query, with ‘and’ or with ‘or’?

With the and… and or… buttons of each step, in the Query panel of the report window (Reports → Reports). When you click one, Add condition tells you which step what you fill in goes to; when you click Add to the step, the condition goes into that step instead of being a new one.

The cross on the notice leaves it, and the next thing is a new step again. The extended step reads in full in the list, with its ‘or’.

How do I narrow a report by telling the assistant in my own words?

With AI query, the box at the top of the Query panel in the report window (Reports → Reports). Write what you want the way you would say it —“remove those from Valencia”, “only those who haven’t bought in the last 90 days”, “those with more than 1,000 euros invoiced this year”— and press Ask.

The assistant opens with your sentence. It turns it into a step of the query and adds it: the step appears in the panel’s list, with its text and with how many records are left, just as if you had added it yourself in Add condition. The text of the step is written by the program, not by the assistant: what you read is exactly what is applied.

If what you ask for cannot be known from the report data —“those with an Instagram page”—, the assistant says so instead of adding a similar step.

This needs the AI assistant enabled in your company. Without it, the query works the same by hand. Everything you can ask it about a report, also without having it open: narrow a report by talking to the assistant.

How do I see where the remaining records are from?

With Break down by, in the same Query panel of the report window (Reports → Reports). Choose a field —the province, the customer type, the sales agent— and the list of its values appears with how many records each one has, from most to fewest. Clicking a value adds the step that keeps only those records.

If there are many distinct values, the list shows the ones with the most records and says how many there are in total.

How do I go from some invoices to their customers?

With Selection, on the bar of the report window (Reports → Reports, or your area’s reports page). It opens a strip with how many distinct records there are and a Their … button for each type of record its rows point to. When you click it, the general report of that type opens narrowed to the ones behind the records you had: the ranges you had entered and the steps of the Query go with it.

For example, to find out who you sold an item to in October:

  1. Open a sales invoices report and enter October in the dates.
  2. Click Query and add the condition for the item (or leave only the dates, if you want all of them).
  3. Click Selection and then Their customers.

The customers report opens with the Query panel on and a single step, which reads in full: ‘has Sales documents with Document date is between 01/10/2026 and 31/10/2026 and…’. Click View to see them. From there on it is a query like any other: you can add steps to it (‘only the ones in Valencia’), bring up the Report or the Data, or send it by email.

The step is a condition, not a fixed list of names: if another October invoice with that item comes in tomorrow, its customer appears.

What the report already filtered on its own goes too: from Sales invoices only the numbered invoices that aren’t cancelled or replaced count, which are the ones that report shows (and if you tick its cancelled box, they count as well).

There are a few reports you can’t go from to another type of record, and the strip says so when you try: the ones that keep only the groups whose total meets a limit (remove that limit and ask for it as a condition in the Query), and the ones that filter with a design formula that has no equivalent condition, such as comparing two fields with each other or measuring a text. Of the standard ones there are three: Credit notes and corrective invoices, Documents by vehicle and Issued cheques report. Their records can still be saved as a group (see the next section).

How do I save what I have narrowed as a group or as a segment?

With Selection, on the bar of the window of any report whose rows are records: customers, items, invoices, instalments, journal lines… (Reports → Reports, or your area’s reports page). Below the count —‘312 distinct customers’, ‘1,240 distinct records’— there is a Save as line: you type a name and choose what you want to save.

The group or segment is of the *report*’s type of record: an invoices report gives a group of sales documents; a stock one, a group of stock. If what you want to save are the customers of those invoices, click Their customers first and save it from there.

On saving, the strip shows a link to open it. Both stay in CRM → Groups and segments, where you view them, change them and share them (see groups and segments).

A standard report that filters with a formula that has no equivalent condition (comparing two fields with each other, measuring a text) can also be saved as a group: the program reads the whole report, up to 50,000 rows, and saves what comes out. What you can’t do is go from it to another type of record, or use a segment built on it as a step of another query; the message explains this when you try.

How do I add to a group, or remove from it, the ones I have in the report?

With Selection, on the bar of the window of a report that can be saved (Reports → Reports). In the Group or segment drop-down you choose a group of yours of the same type of record —of items in an items report, of sales documents in an invoices one— and click Add to the group or Remove from the group: all the ones the report has now, with its ranges and its steps, go in or come out. A notice says how many there were and how many were already in it (or weren’t).

It only works with a group of yours that isn’t archived. Nothing is added to or removed from a segment: its rule decides. This is the way to fill a group of documents, instalments or stock, which have no field to add them by code in the group’s record.

How do I keep the ones that are, or aren’t, in a group or a segment?

With Selection, on the bar of the window of a report that can be saved (Reports → Reports). Choose one of the same type of record in Group or segment and click Only the ones in it or The ones not in it. A step is added to the Query —‘is in the group «Fair»’, ‘is not in the segment «Late payers»’— and the report is redone with it.

It is a step like any other: you turn it off, remove it and combine it with the rest. That is how they are intersected and subtracted: ‘the ones in Valencia that are in the trade fair group and not in the late payers one’ are three steps.

Your own and the ones someone else has shared both work. If you ask about a segment, it is evaluated at that moment and with your permissions.

How do I save a query as a new report?

With Selection → Save as → Report, on the bar of the report window (Reports → Reports). Type the title and click Report: a new report is created, yours, the same as the one you had open but with the Query steps already built in. What they filtered, it now always filters; if you had sorted or asked for subtotals in a step, that becomes its order and its groups.

The new report still asks for the same ranges when you run it. It appears with the rest of yours (see Where are the reports we have made ourselves?) and can be adjusted in the designer. You need permission to create reports; without it, the button is off.

It is useful for a report you want to repeat as it is, with its design and its columns; if what you want is the list of records that meet the query, a segment usually suits better, and it can also be used inside other queries.

Where do I choose the report?

On the left, in Report types: the categories of this area, and inside each one its reports. When you click one, its ranges and the buttons to run it appear on the right.

The categories are the ones from the Desktop ERP (Orders, Documents, Journals…), so if you came from there you find them where you used to look for them.

Where are the reports we have made ourselves?

In their area, next to the standard ones. A report drawn with the designer has an area —the designer suggests it from the chosen table (sales documents → Sales, journal lines → Accounting…) and you confirm it when saving— and with it, it appears in both places: in that area’s category in the catalogue and in the More reports group on that module’s reports page. A sales report you have made yourselves appears in Sales reports, like the standard ones.

The Custom category, the last in the list, only keeps the ones that have no area, such as those saved choosing ‘Only in Custom’. It is the only category that is always there, even when it is empty; in that case it tells you so and offers you the button to design the first one. To move one from there to its area, open it with Edit and choose the area in the designer header.

The Search box on the right, on the other hand, searches all the categories at once: if you know the name or the code, you don’t need to get the category right (the ones left with no matches disappear from the panel). The small search box in the left panel only filters the category names.

If a category called Other reports ever appears, they are standard reports that the programme couldn’t assign to any area. They are run like any other.

What are the details it asks me for before running?

They are the *report*’s parameters: what its design left open to narrow it down each time. The typical ones are a date range, a customer or a series.

Each one is asked for with the control that matches its type: a date picker, a number, a tick box, a drop-down or a text box. The window shows them in the order they were defined.

The ones that narrow by a master have a magnifying glass: customer, supplier, sales agent, item, payment method, treasury account, warehouse, price list and ledger account. You can type the code directly or search for it by code or name. A range (from / to) goes on the same row, with its two magnifying glasses; if you leave one of the two blank, the range is left open on that side.

When you type a code and leave the field, the programme completes it as the record would —‘7’ becomes ‘000007’, and in a ledger account ‘430002’ becomes ‘43000002’— and writes the record’s name next to it. If the code exists, nothing else opens; the search window only appears when what you have typed doesn’t match any record, and with your text already entered so you don’t have to repeat it.

Why do the ranges come already filled in?

Because they show what there is: a customer range opens from the first code to the last, and the date range from the start of the financial year to today. That way you can see at a glance what is going to come out and you only have to narrow down what interests you. A value that comes from outside —from a link, from the menu or from a record— takes precedence over these; ranges for other dates (due date, expiry date) and those for numbers or text open blank.

There is one exception, and it is worth knowing about: the VAT register reports open from the oldest invoice there is, not from the start of the financial year. The VAT register keeps every year —including those imported from another programme—, so restricting it to the current financial year would show it empty on the day you look up a past year. If you only want the financial year, enter the date yourself.

Can I fill in the ranges without the mouse?

Yes, just as on the customer record or in a document header: Enter starts typing in the field and the next Enter confirms and jumps to the next one; the left and right arrows go through the fields in order and the up and down ones change row; Escape undoes what you typed; typing directly over a field replaces its value; and F2 opens the magnifying glass. After the last range, Enter leaves the focus on View, so one more Enter runs the report.

The ranges go from top to bottom, a from always above its to, in wide columns (code with its name, free text) or narrow ones (simple codes, dates, numbers, drop-downs), up to three, arranged so that the window takes up as little height as possible and the report below keeps the space. Enter goes through them in that same order, column by column.

If the three columns don’t fit side by side, the ones that fit stay at the top and what is left over is spread out below in as many columns as fit (two or three, because they are usually the narrow ones), instead of being stacked in a single long column. The arrangement is redone on its own when you resize the window, and Enter follows what you see: first the top part and then the bottom part. On a mobile screen everything goes in one column.

The standard reports —the general ledger, the treasury statements, the warehouse movements, batches and serial numbers, price lists…— ask for the same ranges as the Desktop ERP, except those this model can’t honour (for example, a currency range in a report whose rows have no currency). In the general ledger, the ‘Text in description’ box leaves only the journal lines whose description contains that text, ignoring capitals.

A parameter marked with an asterisk is required: without it, the report doesn’t run and you will see the warning in the window itself.

How do I get documents from other financial years in a report?

A report of documents (invoices, delivery notes, orders, quotes) brings those of the financial year you are working in. To also see those of the company’s other financial years, tick Include other financial years, below the ranges.

The box appears when it is needed: when you enter dates that fall outside the current financial year, or in a report of documents that does not ask for dates. With the dates inside the financial year it is not shown, because it would change nothing. It does not appear either if the company has a single financial year.

With it ticked:

It is not remembered from one time to the next: every report opens in the current financial year.

Everything else does not need the box. A report of due dates, of the VAT register, of movements or of the ledger already brings all the company’s financial years, and shows the number of its invoice even if it is from another year. A December delivery note also says which January invoice includes it.

If you ask the assistant for the report, say it in your own words: ‘the 2024 invoices, from all financial years’.

Do voided invoices appear?

No, not to start with. The sales invoice and credit note reports —sales invoices, by customer, by sales agent, summaries and analyses— leave out, as the Desktop ERP does:

To see them, tick Include voided in the ranges. In Sales invoices they then appear in the list, but with their amounts at zero, so they don’t change the totals.

The documents’ Status range is a drop-down (confirmed or pending invoicing, invoiced, voided, replaced); blank, all of them. To see only the voided ones, choose ‘Cancelled’ and tick Include voided.

How do I get only the invoices pending receipt, or only the collected ones?

With the open items tick boxes in the ranges, as in the Desktop ERP:

What counts is the invoice’s open items: a returned bill becomes outstanding again (only once, not twice), and an invoice without instalments is taken as collected.

If what you want is the list of what you are owed, instalment by instalment and with each customer’s total, open Unpaid invoices (or Invoices pending payment): it is in the Receipts group of the customer reports, in Payments of the supplier ones and in the Treasury reports. See Where do I get the invoices pending receipt or payment?.

Several reports also have the Paid column, what has already been collected on each invoice: Sales summary by customer, Profit summary by customer, Invoices by sales agent and date and Invoices by sales agent and customer. And Receipts summary by customer shows, invoice by invoice, what was collected as immediate payment, what is deferred, what is still outstanding and the total.

How do I see what is still to be delivered on orders?

With the reports in the Orders group of the sales and purchase reports (Sales orders, Items on sales orders, Outstanding items by order, Order check, Purchase orders…) and the Order daybooks. Each line has three quantities, as in the Desktop ERP:

The Pending delivery tick box leaves only the lines that still have something to be delivered, and an order delivered in full no longer appears. It opens unticked, as in Powergest: without ticking it, all the lines appear.

Sales order detail and Purchase order detail also show, by customer or supplier and line by line, whether it has been delivered in full, the purchase price, the sales price and the % profit on cost; in the totals the percentage is calculated on the sums, not by adding up percentages.

When is an invoice ‘direct’ and when is it ‘from delivery notes’?

It is the question in the Source drop-down of the invoice reports (sales and purchases): Direct only, From delivery notes only or, blank, both. An invoice is from delivery notes if any of its lines comes from a delivery note, even if the invoice brings several together; and so is one that the Desktop ERP marked as made from delivery notes, even if its delivery notes weren’t brought over. The rest are direct: one written by hand, one made from an order or a quote and the replacement of a direct invoice.

How do I know which invoice includes a delivery note?

The delivery note reports (Delivery notes, Delivery notes by customer, Detailed delivery notes by customer, Delivery notes by sales agent and date and the purchase ones by supplier) have the Invoice column: the number of the invoice made from that delivery note, or No if it hasn’t been invoiced yet. If the delivery note was invoiced in two goes, both appear, separated by commas. With the Invoice no. detail in the run window you get the delivery notes that a particular invoice includes.

In the same way, Order check has the Delivery note that fulfilled each order.

What appears in ‘Credit notes and corrective invoices’?

The Desktop ERP’s four classes, each with its tick box, ticked to start with:

The Type column says which each one is; Corrects is the invoice that a credit note or a corrective invoice corrects, and Corrected by, in the other direction, the corrective invoice or the credit notes of an invoice.

Can I run the ledger without opening, collection or invoice entries?

Yes. The General ledger has four tick boxes, as in the desktop ERP, ticked by default:

Untick the ones you don’t want to see. An entry brought from the desktop ERP without its invoice or its collection counts as manual.

What are ‘Initial’ and ‘Start’ in the warehouse reports?

The stock at the ‘from’ date of the range, what the Desktop ERP calls ‘opening stock’:

The same movements you ask for in the ranges count (warehouse, item, batch…): if you narrow it to one warehouse, the opening stock is that warehouse’s.

Bank accounts, Cash accounts and Card accounts work the same way with money: one line per account with Previous (the balance before the ‘from’ date), what came in and what went out in the period (on the card ones, Sales and Collected, and their Commission) and the Balance at the ‘to’ date. An account with no movement at all in the period doesn’t appear.

How do I read the ‘Outstanding balance analysis’?

One line per customer with what they owe, split by age into separate bands, as in the Desktop ERP. With the Calculation date (empty, today) and the 1, 3 and 12-month bands it comes with to start with:

ColumnWhat it adds up
1st bandwhat fell due in the last month
2nd bandwhat fell due between 1 and 3 months ago
3rd bandwhat fell due between 3 and 12 months ago
Remainderwhat fell due more than 12 months ago and what isn’t due yet
Totaleverything still to be collected

The months of each band are changed in the window. With Minimum age in months, what fell due less than that ago goes into Remainder. A returned bill counts: the return leaves it outstanding again.

How do the monthly reports come out?

Monthly sales by customer, Monthly purchases by supplier and Monthly amounts by sales agent come out as in the Desktop ERP: one line per customer, supplier or sales agent, with the tax base of their invoices for each month in twelve columns —January to December— and the total at the end. The months are calendar months: if you ask for more than one year, the Januaries of the two years are added in the same column.

Why does a customer appear under another name in ‘Sales invoices’?

Because it appears with the name of the invoice’s delivery address, as in Powergest. A customer with several shops has one delivery address per shop, and each invoice says which one it goes to: the report prints the customer code and the name of that shop (‘5235 LA PINTORÁMICA’), not that of the company that groups them (‘TAS VENTURES’). If the invoice has no delivery address, or the address has no name or street, the customer’s name appears. The same goes for Delivery notes, Quotes and Corrective invoices and credit notes.

Which Desktop ERP columns do the standard reports have?

The ones Powergest prints and this programme stores. Some that are worth knowing how to read:

The parameters aren’t kept from one time to the next. Each time you open the window they go back to the default ranges, except those the design has with its own default value (for example, ‘Date from’ one month back), which take precedence over them and can be changed.

Yes. Each report has its own address, and you can put the filters in it:

/informes/ejecutar?codigo=CLIEN002
/informes/ejecutar?codigo=CLIEN002&clienteDesde=0001&clienteHasta=0001

codigo is the report code (it appears on its row in Reports); the rest are its filters, with the name they have in the design. The page opens the report with those values already entered, and the rest is filled in as in the normal window. It is useful for keeping a shortcut in your favourites or for passing someone ‘this report with these filters’. Reports without a code (the ones you designed) are opened with formatoId= instead of codigo=.

How do I keep a report to hand in the menu?

With the Add to menu button in the report window. It asks for the shortcut text (by default, the report title), and when you click Pin to ‘My reports’ it creates in your menu —only in yours, not in the whole installation’s— a My reports group with an entry that opens that report with the ranges you had entered at that moment. If you want a range to be calculated each time, type a formula starting with = in it before pinning: =Today()-30 in ‘Date from’ always opens with the last month.

The group appears in the side menu without reloading. To change its order, icon or text, or to put it in the menu for the whole installation, there is the menu editor (My settings → Menu).

How do I launch a report from a customer record?

On the record of a customer, a supplier, a sales agent or an item, the action bar at the top right —the same one where ‘Save’ or ‘Delete’ are— has Reports. It opens out the reports whose dialog asks for that master —‘Invoices by customer’, ‘Delivery notes by customer’…— and, when you choose one, it opens the window with that customer already entered in ‘from’ and ‘to’. What appears in the list is decided by each report’s design (if it asks for a customer range, it appears), not by a fixed list.

If the window is narrow, the bar keeps just the icons and, if they still don’t fit, puts the last buttons in the ··· menu on its right: Reports also opens out from there.

If the button is greyed out, it is because the record hasn’t been saved yet or because, when you click it, no report asks for that master. The reason appears in the tooltip that shows when you hover over it.

What do I see when I click View?

A table with the *report*’s columns and its rows already formatted. Number columns come out right-aligned.

Below the table it shows how many rows have been read.

With a lot of rows (more than 200), the table sits in a fixed-height box with its own scroll bar: rows appear as you scroll down and the header stays at the top. That way the screen responds the same with 50 customers as with 9,000.

If the report returns a lot of rows, the warning ‘Showing the first rows (result truncated)’ appears at the top. It isn’t a fault: there is a safety limit so the screen doesn’t hang. Narrow it further with the parameters if you need to see it all.

View doesn’t draw the group headers or the subtotal lines: that is only seen in the Report. The only exception is Totals only mode, which also on screen gives one line per group with its sums.

Numbers and dates come out in Spanish format. Yes-or-no boxes come out as Yes and No.

What appears in the PDF?

The laid-out report: column header, the rows, and —if the design has them— the group headers, each group’s subtotals and the grand total. After each subtotal there is a blank line, so that the next group doesn’t start right up against the previous one’s total.

When you click Report the PDF opens full screen, inside the programme. There you read it with zoom, text search and page jumps, and from its bar you print it or save it to disk. Back to the report takes you back to the screen you opened it from —for example, Sales reports—, with the same report chosen in the menu and the ranges as you had them, in case you want to change one.

If all you want is to print, open the arrow next to Report and click Print: it goes straight to the print dialog, with the report already loaded.

What font does the report use and what happens if the columns don’t fit?

The report is printed in the same font as the Desktop ERP —by default, Times New Roman at 8 points, which at the same size fits more text in each column than Arial—, and it adjusts itself so that nothing important is cut off:

The font and its limits (size and how far it can shrink) are set by whoever administers the installation, in My settings → Printing; a particular report can have its own from the designer.

What is the ‘Banded report’?

They are the grey bands behind the lines of the report, so you don’t lose the row with your eye on a long sheet — just as in the Desktop ERP. You turn it on or off with the Banded report tick box, which appears when you open the arrow next to Report.

The programme remembers your last choice for next time. If you have never changed it, it opens with whatever whoever administers the installation has set (also in My settings → Printing).

The bands only cover the detail rows: a group header or its subtotal line have no band, and the banding starts again on white right after each one — as in the Desktop ERP.

What is ‘Totals only’ when running a report?

With the Totals only tick box ticked —it appears when you open the arrow next to Report—, the report comes out with one line for each group and its sums, without the detail rows. The report needs to have some group —the one its design has or the one you choose in Subtotals by, if the report offers it (see Can I choose the subtotals when running it?); without any group the tick box has nothing to summarise.

Can a report be signed?

Yes. On the report screen, the bar has Signature and Annotations: you can sign by hand —with the mouse or with your finger on a tablet—, highlight and write notes on the document, and then save it or print it with what you have added.

The signature and the notes belong to the PDF you take away, not to the report: the report saved in the programme doesn’t change, and whoever runs it again gets it clean.

The width of each column is the one it was given when designing, shared out over the usable width of the paper. If a value doesn’t fit in its column, it is cut off with ‘…’ instead of running over the next one. If what gets cut off is an amount, widen that column in the design.

How do I send a report by email?

Open the arrow next to Report and click Send by email. An area opens below the buttons, and when you finish you click Send. It has:

It is sent with the parameters you have entered at that moment, the same ones you would see the report on screen with, and with the Query steps if you have any. You don’t need to type anything again.

What formats can I attach?

FormatWhat it is for
PDFThe laid-out report, just as it is printed. Anyone can open it.
ExcelA spreadsheet where the amounts are numbers: they can be added up and sorted.
CSVThe raw data, to put into another programme.
ImageA picture of each sheet, to paste into a chat or a report.

The difference between Excel and CSV is that in Excel the amounts go in as numbers and in the CSV everything is text. If you are going to do calculations with what you send, choose Excel.

Why does it say ‘queued for sending’ and not ‘sent’?

Because that is what has really happened. The email doesn’t go out at that moment: it is left in a queue and goes out shortly afterwards. That way, if the mail server is down or slow, the ERP tries again on its own instead of losing the send.

If you want to check that it has gone out, the technical service sees it in System → System email. Each email appears there with its status and, if something failed, why.

If the report has many sheets

Sending a three-hundred-sheet report as an image means three hundred files, and that neither goes out nor is of any use to whoever receives it. That is why there is a limit (ten sheets by default) and, if you go over it, the ERP tells you and suggests sending it as a PDF, which doesn’t have that problem.

There is also a limit on the total size of the attachments (15 MB by default). If you go over it, narrow the report with the parameters or send fewer formats at once.

What does each sheet have at the top and the bottom?

At the top of every sheet, not just the first, goes the report header, with the same arrangement as the Desktop ERP:

That way a loose sheet makes sense on its own: it says whose it is, which report it is, with what range it was run and which sheet it is.

Only the parameters you filled in appear. If you asked for many and they don’t fit in the three lines, the ones left over are put together on the last one, which is cut off with ‘…’ if it doesn’t fit either.

At the foot of each sheet, if the report adds up any column, there is the Carried forward: what those columns have added up from the first sheet to that one. The last sheet doesn’t have it, because the grand total is there. If the report is grouped, each group’s subtotal says which group it belongs to —‘Total January 2026’, ‘Total CERAMICA DEL RIO SALADO’— instead of a generic ‘Subtotal’, and it isn’t split between two sheets: it always goes with the last rows of its group. The same goes for the grand total: it takes the last rows with it so that it isn’t left on its own at the start of a new sheet.

What language does a report come out in?

In yours: the one you have in My settings → Preferences → Language. With English, the standard reports come out in English from start to finish —title, columns, subtotals, the details it asks for before running— in the view, the PDF, the Excel file, the CSV and the image sent by email. The data (names, descriptions, what you typed on a record) comes out as it is.

A report you designed yourself comes out with the texts you wrote. If any of them matches one of the programme’s (‘Customer’, ‘Date’), that one does come out translated. Dates and amounts keep the Spanish format.

Invoices, delivery notes, labels and Tax Agency forms don’t change language: they are read by your customer or by the Tax Agency, not by you.

Can I change a report that has already been saved?

Yes. On the *report*’s record click Edit, or, if you already have it open with its ranges in front of you, Edit the layout in the window itself (only those who can design see it). The designer opens with that design loaded and you can change columns, filters, groups or parameters. When you click Back in the designer you go back to where you were.

When you save, the change affects everyone: the report is single, there isn’t a copy per user. If you want a variant without touching the original, design a new report.

The standard reports are edited just like the others: they aren’t untouchable. Even so, it is best to start from a copy and leave the original as it was.

Reports already run don’t change: what has already been printed or downloaded stays as it was.

If something goes wrong

What you seeWhat has happenedWhat to do
‘No reports saved yet.’Not even the standard ones are there: something failed when the installation was preparedTell whoever administers the ERP
‘Couldn’t load the report (it doesn’t exist or you don’t have access).’It has been deleted, or your role can’t reach one of its tablesReload the screen; if it continues, ask for the permission
‘No permission to run this report (some of its entities are not accessible).’Your role can’t read one of the design’s tablesAsk for access to that area
‘Report {n} does not exist or cannot be run.’The design has been deleted from the catalogueTell whoever designed it
‘The report ‘…’ has an unreadable layout.’The saved design is damagedDesign it again from the designer
A warning with the name of a detail you didn’t fill inA required parameter is missingFill it in and click again
‘Showing the first rows (result truncated).’The result exceeds the row limitNarrow it down with the parameters
The table comes out emptyThe parameters don’t let any row throughWiden the ranges and try again
Clicking Report does nothingThe report returned no rows, so there is nothing to lay outClick View first to check there is data

See also: Create a custom report · Export a report to Excel · Where each report is

More about Reports