Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
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
