Running reports and formatting documents

Everything that comes out on paper or in a file goes through here. Reports extract data from the ERP as a table; document layouts decide what the PDF of an invoice or a delivery note looks like. They are two different things, and this page tells you which one you need.
Which is the right screen for getting data out?
Reports → Reports. It is the one that runs reports and the only one that takes any data from the ERP to paper or to a file. There are other screens in the programme called ‘reports’ that don’t do the same thing, so if you have landed on the wrong one, where each report is clears it up on a single page.
A report is a table-shaped report designed in advance: sales by customer, items in stock, open items by due date. You run it on screen, as a PDF or as a CSV, and the ERP comes with some standard ones from day one: run a report. The ones for each area, one by one, are in the standard reports in each area.
How do I open it in a spreadsheet?
With the Data button, which downloads an Excel sheet with the amounts as numbers; the arrow on its right lets you choose CSV, a text file that any spreadsheet opens. The page explains what each one contains and the name of the file: export a report to Excel.
What if I only want part of the report?
With Query: a panel next to the report where you add conditions one by one —‘from Valencia’, ‘with a total greater than 1,000’, ‘no purchases in the last 90 days’— and see how many records are left after each one. What you get afterwards (the view, the report, the data) is narrowed: how do I narrow a report step by step?.
What if the report I need doesn’t exist?
You design it. The Report designer lets you put together your own report without any technical knowledge: you choose the table, drag the columns and save, and it is available in Reports to run whenever you need it. The step-by-step guide is in create a custom report.
What turns a flat list into a real report is grouping: sales by customer, stock by warehouse, open items by payment method, with their subtotals. It takes two things, both of them needed, and they are explained in group and total a report.
Bear in mind that permissions rule: the designer only offers the tables your role can read, and a report only appears on screen if you can read all the tables it uses. When a report can’t be seen, it is almost always that and not a fault.
How do I see how much of the year a period accounts for?
Sales summaries tell you how much has been sold between two dates. To find out what share of the financial year that represents —and at what average price it went out— there are the two analyses in Sales → Sales reports, which ask for two date ranges instead of one: analyse the sales for a period.
How do I change what an invoice looks like?
The look of the paper —where the logo goes, which columns the body has, what it says at the foot— lives in the document layout and is drawn in the layout editor. Changing the design of an invoice means drawing a new sheet, not editing the existing one on the fly: change the design of an invoice.
Once it is drawn, you decide when it is used. The layout is chosen on the document itself, with a drop-down that is both in the header and in the footer, and it also appears when you invoice delivery notes in bulk: choose which layout a document is printed with.
How do I print labels?
In Reports → Labels: item labels with their barcode and price, customer and supplier labels for shipping, shipping labels (one per package on a delivery note) and purchase labels (one per unit that comes in). They come out on whatever sheet you use —a sheet of sticky labels, a half sheet, a full sheet or a roll—, and you can start at the first free label on a sheet you have already started: print labels.
What changes depending on what I choose?
A report and a document layout are alike in that both end up as a PDF, but they don’t do the same thing. The report extracts data: whatever you ask for, with the filters you set, and it works the same for PDF as for CSV. The document layout decides how a particular document looks, and it also decides how the body of the paper is grouped.
Changing a layout doesn’t change any data: the invoice still says the same thing, it is just printed differently.
More about Reports
- How do I group and total a report?
- How do I see what share of the year’s sales falls in a period?
- How do I change the design of an invoice?
- How do I create a custom report?
- Where is each report?
- How do I choose which layout a document is printed with?
- How do I export a report to Excel?
- How do I print labels?
- The standard reports in each area
- How do I run a report?