Skip to Content
avatar image
Former Member

Zero value in unit price and total

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 12, 2009 at 05:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2009 at 02:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2009 at 07:24 AM

    Create an UDF FOC

    if the UDF is selected in row level then print FOC

    Thanks

    Krish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 13, 2009 at 01:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded