Skip to Content

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   2.you 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 .

Headertable.Docentry=Childtable1.Docentry

OPCH.Docentry=PCH1.Docentry.

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

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply