Dear instance managers,
Our reports will soon have a major improvement. This comes out of a contribution from Sebastian Castro.
Sebastian Castro is a well known developer in the French open source community. He is for example the maintainer of an awesome map tool called Gogocarto. He is also a small-scale farmer and helps hubs running on OFN France And no he is not available for hire
His proposal was very much inline with the improvements we already wanted to do on our reports, and the code quality is brilliant. For example he did a lot of technical improvements that will enable us to maintain reports more easily, but also make them evolve in an easier / quicker way.
Therefore the delivery team decided to help him release this big piece of work.
Indeed, if the delivery team would have done this work, we would have done it incrementally, reports by reports. Small bits by small bits. Hence this message to you: now that we are soon ready to ship these improvements we will need your help to communicate this to users in advance and help them handle the new features and potential breaking changes.
Everything should be ready to release on May 24th, but we will confirm this date by the end of the week.
Once the date is confirmed, we suggest you communicate to all users the changes are upcoming + ask them to reach your support team to explain if they are doing scripts / macros / fancy Excel formula with the reports and if so which ones. Indeed, we noticed we don’t know how many instances are running scripts on reports, therefore it is very difficult for us to plan any breaking changes.
Therefore we have put together the following strategy: this release should NOT break anything in the csv format of the reports ( but there are a couple of changes you need to be aware of, see below).
What type of changes are we talking about?
1. Several options for downloading reports (alongside on screen display)
ALL reports will now have PDF, Spreadsheet, CSV & JSON available for download.
2. Print option
All reports can now be printed easily.
3. Rendering options
You will be able to hide columns before downloading or reading online.
You will be able to choose if you want a header row or total / summary row displayed on the report
- Spreadsheet versions should display prices as prices (no changes in CSV).
4. UI Uplift
All reports will have two sections: filters and rendering options
5. New kid on the block
Packing reports can be viewed by customer or producer. Now they also come by product.
6. Content changes
Changes that could harm scripts
-
Spreadsheet are the human readable version and CSV the machine readable version. So in CSV “No” is changed to “false”
-
In order cycle management report “code” heading was renamed “customer code”. Note that this does not apply if you have translated it in another way.
-
Orders suppliers total now also have total rows, but you can unselect the option
-
Download file names have changed
-
The two last columns of Order Cycle Supplier Totals are removed (they were absolutely useless)
-
Column “to hub” in OC suppliers totals by distributors is renamed “hub” - again unless you have translated it otherwise
Other changes:
-
Packing reports: Price and phone are added (but hidden by default)
-
The Xero reports code was selecting default data. This is now shown on the UI and the user can change them.
What will come next
These improvements will either be done by Sebastian or made available through papercuts:
-
Merging of reports types which are very close in terms of columns (ex tax reports or delivery reports)
-
Improve UX of Show/hide columns
-
Ability for the admin to save their rendering options per reports
and probably more
Please don’t hesitate if you have questions!