PLD (Print Layout Designer)

If you are missing a link to arrow next to a field you would normally expect to see an arrow, you must have forgotten to put...

While creating a report in Print Layout Designer (PLD) from a query I noted that the maximum number of fields that the PLD would import was 100.

If you do not use FOR BROWSE in your query and you attempt to create a Print Layout Designer (PLD) report from that query, you may find that there will be no field descriptions for the fields.

The Print Layout Designer (PLD) apparently does not allow you to refresh the query (i.e., add columns to the query and thus add fields to the PLD). The only way we have found to overcome this is to copy all of the original layout and paste it into another layout (yes...you can do that!). Here are the steps:

1. Change your original query and save it.
2. Save the old report layout as a new name.

Follow these steps:

• From the drop-down menus at the top of the screen, go to: Tools -> Queries -> Query Manager
• Click on the Query Manager icon located on the icon bar at the top of the screen.

 Line Break

• Determines how the values in the field will be displayed.
• Overflow will allow the text to extend beyond the length of the field.
  Adjust to Cell will cut off the information to the assigned length of the field

Report Areas

 While using print preview for a report you may find that the text is too small to see on the screen. You can control the size of the font by changing a setting in the Print Layout Designer.

The Orchestra Team does it again! SAP Business One Partner the Orchestra Team has a series of videos (over 20) about using SBO that they have posted on YouTube.  Here are a few examples of what you will find there:

Sales Analysis

Use Last Evaluated Price List

Enter a Sales Order for a Lead