AHK said:

advise me if there is a way to generate a report for inventory quantities to be ordered, where "Quantities on Purchase" are shown at alongside the columns of "quantity in stock", "minimum quantity" and "quantity on purchase" and finally "quantity to order"-

Set it to print in Landscape, and / or scrunch the columns together by dragging the bars between them with the mouse.   If the dotted page break line isn't on the right hand side, each page of the report will be split into multiple pages.

There is a Print Preview button in the upper left corner of the report screen that will show the printout before the trees are used up.  

If you only want a list of what needs to be ordered, use a filter:

Dear RandyW,

Thank you for your suggestion which is very helpful in preparing a new order for numerous  items . You have been very precise in your answer which is a great virtue . Rgds/AHK