PLD Format Help

[former_member202778]

Hi,

I am preparing PLD format Layout, This is my first time using PLD format..

I am actualy changing CR report invoice format to PLD format since crystal report cannot open its payment receipt when invoice previewed with payment..

So,

1. How to use if formula in PLD format??

2. How to round of number field to two decimal place??

3. How to insert current page number?? I want have Page 1 of 3 like this...

I am using SAP B1 8.82 PL08. Thank you...

[KennedyT21 · Accepted solution]

Hi Ibrahim Rasheed...

1. How to use if formula in PLD format??

http://www.pioneerb1.com/wp-content/uploads/2012/04/HowTo_PrintLayouts_PLD_88.pdf

http://www.vision-33.com/media/5432/howto-customizepldtemplates.pdf

http://sap.ittoolbox.com/groups/technical-functional/sap-business-one/how-to-use-a-formula-in-a-pld-...

2. How to round of number field to two decimal place??

The PLD only facilitates achieving decimal precision control through the Round() Function.

Example: Field name F_012

Insert a new field -->select source type -->Formula

and in the empty space Round(F_012,2)......It will give the cost or rate in two decimal places.

3. How to insert current page number?? I want have Page 1 of 3 like this...

CurrentPage()

The number of the page in the document printout.

TotalPages()

The total number of printed pages.

Hope Helpful

Regards

Kennedy

[Former Member · Accepted solution]

Dear Sir,

             How to create full border in SAP PLD layout (How to combine Header ,Repetitive area and footer), Please sir help me.

Thanks & Regards

Hemant Aakodiya

07415208003