Follow these steps:

  1. Create a Query in SAP Business One
  2. Open the Query Manager
  3. Find your Report
  4. Highlight your report (single click)
  5. Click on the Create Report button at the bottom of the window.
  6. A window appears with the name of your query at the top of the window.
  7. Window is divided into two parts: Top is existing reports, bottom is a list of the report templates.
  8. Click on the User Report (System) template in the bottom part of the window.
  9. Click the OK button.
  10. You are returned to the Query Manager
    (At this point you are probably thinking that nothing happened, but it did).
  11. Click on the Create Report button once more.
  12. The Create User Report window opens again. Now in the top part (the box under Name) of the window you will see the name of the report you were trying to create. This indicates that the initial report was created successfully.
  13. Now…Double Click on the the name of your query in that section and the Print Layout Designer (PLD) windows will open and allow you to modify the layout of the query information on the report.

After you have completed your changes to the layout and have saved your work, you can see the actual printed document by accessing the Query Manager, highlighting your report name, and clicking the print preview icon at the top of the screen.

Thanks to Ed Monk of