Skip to Content
avatar image
Former Member

Can I get Sum of one UDF which is at line level of Sales Order

Hi to All Gurus / Experts,

I had added one udf named U_SpPriceMT (Units and Total) Amount, i need its sum at Header level udf without using SDK. Can i use Formatted Search..? How ?

Please guide me to resolve this problem..

Thanks..

Chintesh Soni

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 31, 2007 at 05:05 AM

    Hai Chintesh,

    Yes you can use formatted search to do it

    example you have 3 UDF in Purchase Order Form

    U_1 , U_2 and U_3

    in U_3 u must defined formatted search using this code

    [code]

    '================================

    declare @f as nvarchar(10)

    declare @e as nvarchar(10)

    select @f = $[$142.U_1] ' $[$<NoForm>,<NoItem>]

    select @e = $[$142.U_2]

    select cast(@f as decimal(10,2)) * cast(@e as decimal(10,2))

    '============================================

    [/code]

    and after defined this code, u can enable the checkbox Auto refresh when fields change to get the event

    Reward Point if this help You

    Regards,

    Arthur Siwan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hai Chintesh,

      sorry I'm kind of busy with my add ons, so I didn't tried with SALES ORDER

      but for information this below is code for title level

      [code]select @f = $[$142.U_1] ' $[$<NoForm>,<NoItem>] [/code]

      and this below code for row level

      [code]select @f = $[$<NoMatrix>,<NoColumn>,0] [/code]

      you can combine both of these code to your formated search in SALES ORDER FORM

      Hope this will help you

      Regards,

      Arthur Siwan

  • avatar image
    Former Member
    Aug 30, 2007 at 02:05 PM

    Hello Chintesh Soni,

    If it is needed in the print out you can use sum column in the PLD template.

    Go to Sales Order template

    Create a database Field to call the UDF.

    Add a Formula field in operation select sum column and select the UDF field FieldID.

    if it is needed in the form

    Select sum (rdr1.U_UDF) from RDR1

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Dear for replying the thread,

      I thinnk i have not explained the requirement properly in my thread. I want to make sum of one UDF called U_SpPriceMT which is in RDR1 and I need its sum at U_TotalPrice which is in ORDR.

      I want to create one approval process based on this.

      Thanks..

      Chintesh Soni

      91 94276 08674