Skip to Content
Author's profile photo Former Member

Step By Step Process to Create Crystal Layout for SAP Business One

In this example i will create one layout for Sales- A/R

1.Open SAP Crystal Reports for SAP Business One.

2.Go To File -> New -> Blank Report . It will ask for Data source to connect.

3.Create a New connection for SAP Business One.

4.Open the connection goto B1Tables -> Category and select the tables as shown below and say OK.

5.It will show up the default BusinessOne Relationships between the tables. If no changes hit Ok

6.Create Simple Delivery note as shown Below

Important Note :
It is important to note that a Crystal Reports .rpt file that you want to define as a layout in SAP Business One must contain a parameter with the DocKey@ token.

7.Create DocKey@ token to set this report as a Layout in SAP Business One.

8.Create a new Parameter and Enter the name DocKey@ and make sure it is a number.

9.Save as the report with some name related to report.

10.GoTo SAP BusinessOne and Administrator -> Setup -> General -> ReportsandLayout Management

11.Click on Import -> Next -> Browse the Report -> select Layout radio button

12.Hit on Ellipses shown there find for relevant document types. Here for example del for delivery and choose delivery Note for Items and hit Choose next say Ok.

13.If you goto Report and Layout Manger it will show up the newly created Layout.

Or Goto Sales A/R -> Delivery and Click on Layout Designer choose the created Layout and set as Default Layout

14.And If you open any Past records and ask for Review it will open up with new Layout applied

Note ::
You can create the layout for one marketing document and apply this layout to another marketing document. When you view the layout for the latter marketing document, SAP Business One automatically redirects you to the tables relevant to that document and displays the correct data, although the layout itself contains the table information relevant to the former marketing document.
For example, you create a layout with the tables OINV, INV1, and so on, which are relevant for an A/R invoice and you apply the layout to a sales order. When you view the layout in sales orders, SAP Business One redirects you to the tables ORDR, RDR1, and so on, which are relevant to sales orders.
To avoid the automatic redirection, do the following:
After you add tables for the layouts in the Database Expert window, rename the tables with the postfix “_ONLY”

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good stuff. It is so help full for me.

      Author's profile photo Former Member
      Former Member

      Very helpful to create a crystal Layout. ThanK you

      Author's profile photo Former Member
      Former Member

      Great blog.Simplified steps to create and mange SAP Business One crystal Reports..

      Author's profile photo john spencer
      john spencer

      Great Article thankyou, 1 quick question, If I have a form that is pulling sales order data when I run the report I want to be able to type in the ORDR.DucNum and then only get back the details for that sales order.  How would I go about this ?

       

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      you can create a parameter for that.

      Author's profile photo Former Member
      Former Member

      How to restrict to data of the Current document only??

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      for that you can create filter on current document.

      Author's profile photo Former Member
      Former Member

      You would have step by step to ECC ?

      Author's profile photo Sw H
      Sw H

      Good instruction!

      The layout file name was system default, such as A/R Invoice_xxxx_yyyymmdd_HHMMSS when generated as an email attcgmenr.  How do I rename the file and email subject line to send out?  Thanks in advance.