Skip to Content
Author's profile photo Former Member

SAP Business One Layout (PLD) in Crystal Report .

Dear All,

I would like to share the requirement  to make SAP Business One PLD with standard fields .

  • Report Header
Fields Table and field name Design Part Link  Part
Company Name OADM.Companyname Try to take all fields from database so that  you can use same PLD for all clinet and also can easily change for other document like AP Invoice To AR Invoice 1.Parameter should be DocKey@ for all layout don’t need to give link for OADM,OADP .
Company Address OADM.Address cangrow option should be enable Parameter should link with Docentry not docnum
Logo OADP.Logoimage
  • Page Header

Fields Table and Fieldname Design Part Link Part
Docnum Docnum Remove commas
Series Name NNM1.Seriesname header.Series=nnm1.series and header.objtype=nnm1.objectcode
Document Date Docdate set proper date format depend upon requirement
Due Date DocDueDate set proper date format depend upon requirement
Customer Code Cardcode
Customer Name Cardname
Address Address

cangrow option should be enable

To avoid blank space choose Format field –>Paragraph–>Text Interpretation–>HTML

1.You have to give proprt linking  for CRD1  otherwise data will duplicate  .

2.You have to give proprt linking for CRD7 otherwise data will duplicate (Its better take values from 12th childtable like PCH12,INV12)

Customer Reference Numatcard
1.PAN No 2.CST NO 1.Taxid0 2.Taxid1
  • Deatil Section (Child one table like POR1,PCH1.)
Fields Table andField Design Part Link Part
Itemcode Itemcode check font style in design otherwise you will miss which fields are don’t have values when you chek in preview. you can easily find by linenumwheather datas are dupilcated or not when docment have more line datas
Itemname Dscription cangrow option should be enable and give more space to itemname .



Quantity Quantity Put inventoy uom with quantity if req
Accout Code AcctCode (Service)
Price Price
Taxcode Taxcode
Tax Percent VatPrcnt
TaxAmount Vatsum
Discount Percent DiscPrcnt
Location (If Req) LocCode
Price Before Discount PriceBefDi
Amount LineTotal LineTotal
  • Page Footer
Fields Table and Field Name Design Part Link Part
Page Number put page number depend upon requrimenrt like 1 of 3 or simply 1
Company Name and address (If req)
  • Report Footer (Header Table like OPCH,OINV)
Fields Table amd Field Name Design Part Link Part
Tax Subreport child 4th table you should give supreport link with docentry 2.check subreport font style it should match with main repot and give cangrow option for taxname
Discount DiscSum (Header Table)
Dowpayment DpmAmnt (Header Table)
Withholding Tax Amount WTSum
Frieght TotalExpns (Header Table)
Sales Person OSLP.slpname
PaidAmount PaidSum (Header Table)
Amount in Words
Shiping Type OSHP.Transpname Header.Docentry=12th.table.Docentry
FormNo 12thchild.Formno Header.Docentry=12th.table.Docentry

-Rajesh N

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Nagarajan K
      Nagarajan K


      Thanks for sharing valuable information with us.

      Best Regards,


      Author's profile photo Mayank Shah
      Mayank Shah


      Thanks it will be help full for new Consultant ...


      Mayank Shah    

      Author's profile photo Former Member
      Former Member

      Thanks Anna for sharing your knowledge.



      Author's profile photo Former Member
      Former Member

      Thanks for sharing. Very helpful information!



      Author's profile photo Balaji Sampath
      Balaji Sampath

      This information is very useful to me

      Thanks and Regards

      Balaji Sampath

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

      Thank you All  🙂

      Author's profile photo Former Member
      Former Member

      Thank You!!

      Author's profile photo Former Member
      Former Member

      Thank you for sharing with us 🙂



      Author's profile photo Karthick S
      Karthick S

      Very Useful Information