cancel
Showing results for 
Search instead for 
Did you mean: 

Condition on PLD

bhavank_gajjar
Active Contributor
0 Kudos
90

Hello experts,

i am stuck up because of one functionality i want on PO PLD

i have created on UDF on row level name TO PRINT --> YES/NO on basis of this against each item there will be YES/NO

i want Items to print where TO PRINT = YES

other items will be there in PO but it should not come to PLD

Regards,

Bhavank

Accepted Solutions (1)

Accepted Solutions (1)

bhavank_gajjar
Active Contributor
0 Kudos

Chidambaram,

I have done as told you but its not working it shows me grand total for all items in PO not for particular items where TO PRINT='Y'

Regards,

Bhavank

Former Member
0 Kudos

Hi Bhavan,

You need make sure what are exact values in your UDF. Is it 'Y', 'N' or just 1,0?

Thanks,

Gordon

Former Member
0 Kudos

Hi Bhavank,

its very simple,

If you create a UDF for To Print(Yes/No) Field.

Try this,

->> Open your require PO PLD.

->> Create 1 database field in Repetitive Area.

ex.

Field ID -> F_001


Table -> POR1
Column -> U_TO PRINT

->> Create 2 Formula in Repetitive Area on PO PLD and Use the below formula.

Formula Field 1:

ex: Field ID -> F_002


F_001=='Y' (OR) F_001=='YES'

Formula Field 2:

ex. Formula Field ID -> F_003 AND Line Total Field ID = F_025


F_002*F_025

->> Use F_002 Link to all Repetitive Area Fields.

->> Create 1 Formula Field in Repetitive Area Footer.


ColSum("F_003")

Save as PLD and RUN the Print Preview.

Regards,

Madhan.

Answers (3)

Answers (3)

bhavank_gajjar
Active Contributor
0 Kudos

Dear Madhan,

thanks for your reply.

its solved. n i have closed thread.

Regards,

Bhavank

bhavank_gajjar
Active Contributor
0 Kudos

Chidambaram

Thanx for reply.

i got solution

but one problem is still there i have putted one variable field 84(F_025) for line total in PO PLD repetitive area and in the footer of that repetitive area i have shown grand total for items.

now there is problem in grand total it shows sum of that F_025 now here it shows sum of all items not for particular item where TO PRINT = YES

Thanks in advance

Regards,

Bhavank

Former Member
0 Kudos

Hi Bhavan,

If that is the case please intro a Formula Filed in Repeatative area and multiply that Line Total with 1 if the Formula condition of that Print Y='Y'

Then Sum the Field which is multiplied in the repeatative area in the Footer to get the Grant Total.

Regards

Chidambaram

Former Member
0 Kudos

Hi Bhavan,

It is very simple, use a formula field in the repeatative are in that content check the Field say (Filed_090) UDF FIELD as example

Field_090=='Y' or 'Yes' how you store the information in Table

Link all the relavent field like itemcode,item description,qty and all other field

whichever you want to print in the document to that Filed_090

In General Tab Link all the above field to the Formula field(F_090) as i said as example....

If the Value of the UDF is =='No' or 'N' it wont print the information

I think you got the solution. try and reply me

Regards

Chidambaram