Ever been to a magic show or watched one on TV? There is this one trick that works every time. When the magician pulls a million things out of a hat, handkerchiefs in many colours, pigeons, a bunny, flowers, and the list goes on. Where could all those things be stored? While a magic show is based on entertaining deceptions, running a successful business is based on, amongst other things, retrieving the essential data, analysing it, and processing it correctly. With that said, the Open Items List report in SAP Business One is a bit like a magician’s hat. Although it looks plain, it holds many different reports that are enhanced by newly added columns:

Open Items List Report


The newly available columns are not displayed in the report by default. You need to make the relevant columns visible in the ‘Form Settings’ window. Different document types may have different new columns available. In the above example, you can see the columns that can be added when generating the reports for A/R Invoices, sales orders, purchase orders, return requests, and goods return requests. The column ‘Approved’ is available as well, but none of them are available when running the report for ‘Missing Items’.

For the complete list of newly added columns for the various report options, have a look at the What’s New document.

Available in Web Client for SAP Business One 10.0, and SAP Business One 10.0 version for SAP HANA. Please get in touch if you would like to upgrade to version 10.0.

We hope that you find this tip helpful. For more information on Business One, please visit our webpage.

Source: Ari Schapira | SAP Business One – The Tip of the Week