Zero value in unit price and total

[Former Member]

Hi Experts

I Created a Delivery order with four items, in that one Item is FOC (free of cost) and we cannot type any alphabets in the unit price column, but I need the empty feild to be displayed as FOC or '-' in the printout, so it will be very clear to the customer that this item is FOC or zero value.

Any idea how to design this PLD.

Tha nks

vinodh

Edited by: Vinod Kumar on Jul 9, 2009 10:31 AM

[Former Member · Accepted solution]

Hi Vinod

Create hardcoded TEXT field in the PLD and link that field with unit price. select if the unit price is 0.00. No need to make an udf.

Hope it helps

Ashish Gupte

[Former Member]

Hi Vinod,

You can select the TYPE from the form settings and then update the FOC details in the Text field and link the same in the PLD.There is no need to create an UDF. Hope this solves your problem.

Regards,

Joseph

[Former Member]

Create an UDF FOC

if the UDF is selected in row level then print FOC

Thanks

Krish

[Former Member]

write a small query with a case statement. You check the value, if it like 0, the query replace the 0 with a "FOC". But take a look at the total sum.

Regards Steffen